Mode Blog

Analysis

September 12, 2018 7 minute read

JOINs in SQL, Python, and R

Image of author

Sadavath Sharma

Data Scientist

The internet is awash in Venn diagrams of SQL JOINs and explanations of why they're necessary. Though it would be nice if we could answer every data question with a single table, more often than not, to get a complete picture, we need to combine different data sets.

Continue Reading
Analysis

August 30, 2018 5 minute read

4 Things You Should Stop Doing in SQL and Start Doing in Python

Image of author

Sadavath Sharma

Data Scientist

As analysts, we know that each question we ask of our data can be answered with multiple potential languages and toolkits. Each language has its strengths and we've often pondered the distinctions. We've previously examined Group By, window functions and a general framework for thinking in SQL and Python.

Continue Reading
General

August 16, 2018 5 minute read

Get More From Your Salesforce Data: 4 SQL Queries to Write First

Image of author

Sadavath Sharma

Data Scientist

If your company is one of the thousands using Salesforce on a daily basis, their customer-relations management (CRM) tool is a treasure-trove of information for your business. This data provides a window into your potential and actual customers— which helps explain why it's one of the first third-party tools we see Mode customers integrating with their data warehouses.

Continue Reading
Data Teams

August 14, 2018 4 minute read

How We Learn Analytical Skills on the Job: Christin Price

Image of author

Liam Hausmann

Content Marketing

Any time you look for patterns in previous experiences or make a tradeoff between one option and another, you're working with analytical skills. Improving these skills is one of the best investments you can make; you can tackle your own problems at work and get closer to answers for your own questions.

Continue Reading
Data Teams

August 9, 2018 4 minute read

How We Learn Analytical Skills on the Job: Brian Libicki

Image of author

Liam Hausmann

Content Marketing

At Mode, we believe everyone is analytical. Any time you look for patterns in previous experiences, or make a tradeoff between one option and another, you're analyzing. The need for analytical skills in the workforce is at an all-time high, and growing. So when we improve our analytical skills, we improve our prospects in the world.

Continue Reading
Data Teams

August 7, 2018 3 minute read

How We Learn Analytical Skills on the Job: Alexa Guerra

Image of author

Liam Hausmann

Content Marketing

At Mode, we believe everyone is analytical. Any time you look for patterns in previous experiences, or make a tradeoff between one option and another, you're analyzing. Improving these skills can only be good for your career; the demand for analytical talent in the workforce is at an all-time high.

Continue Reading

Looks like you've got a thing for cutting-edge data news.
Get the latest.