mode helix
NEWIntroducing Helix—the first instant, responsive data engine.Learn more

Analysis

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
Analysis

July 30, 2018 3 minute read

Knowing Your Blindspot as an Analyst

Image of author

Derek Steer

CEO

Before starting Mode, I was an analyst. It's embarrassing to admit, but at the time, I thought I had all the answers. I thought that being the one with access to data made me the arbiter of truth, and that I was right by default when talking with someone who wasn't using quantitative information to back up their ideas.

Continue Reading
Analysis

June 25, 2018 4 minute read

3 Weird Analytical Practices at Mode

Image of author

Tayler Mehit

Associate Marketing Manager

For many of Mode's employees, this is their first job at an analytics company. Those team members often assume that Mode's internal analytics processes mirror the way analysis is commonly conducted within other organizations. In some ways, that assumption holds true. As CEO Derek Steer puts it, "I wish I had a more mind-blowing story for how we do internal reporting... But mostly, it's funnel analysis." That said, we approach analysis from some uncommon angles.

Continue Reading
Analysis

May 30, 2018 2 minute read

Introducing Plotly for R in Mode

Image of author

Marissa Gemma

Writer

Plotly lets analysts and developers create powerful interactive visualizations, whether offline or right in your browser. Plotly.R is now available in Mode’s new R Notebooks. This means that it’s easier than ever to build all kinds of custom, interactive R-powered visualizations right into your Mode reports and dashboards.

Continue Reading
Analysis

April 25, 2018 6 minute read

7 R Data Science Influencers to Follow

Image of author

Marissa Gemma

Writer

Among data scientists and analysts, R has long held its own against Python in the battle to determine the “best” analytical programming language. Statisticians and numerically-savvy academics of all stripes have typically preferred R to Python, so lots of R&D - both inside the ivory tower and in various industries - gets done in R.

Continue Reading

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

Get the latest.