Introducing Visual Explorer, a new tool for data visualization.Learn more

Archive

Mode updates
Mode's Diversity Report for Q1, 2022

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Derek Steer

June 9, 2022

Data Teams
Using Data to Navigate: Data Leaders On Leading Companies Through Economic Uncertainty

This guide is designed to help you navigate the challenges that arise in major economic shifts or rapid change.

Jessica Schimm

June 2, 2022

Mode updates
How Non-Analysts Can Take Advantage of Mode

Starting with Visual Explorer, we’re going to walk through ways you can use Mode to explore reports.

Chioma Dunkley

May 27, 2022

Data Teams
Choosing An Analytics Tool You Can Grow With

If you are struggling to bring together and analyze data, it’s probably a sign you need an advanced analytics tool. What you need is not…

Chioma Dunkley

May 5, 2022

Analysis
Cohort Analysis: An Introductory Guide for Better Retention

Cohort analysis is the process of breaking up users into cohorts and examining their behavior and trends over time.

Chioma Dunkley

March 29, 2022

Analysis
Who’s Behind the Numbers? A Conversation with Hassan Kibirige, Creator of Plotnine

We are excited to highlight Hassan Kibirige, creator of Plotnine, to learn more about his data journey and how he ended up creating the…

Chioma Dunkley

March 8, 2022

Mode updates
New Features in Visual Explorer Are Here

With these new releases, you can now see Grand Totals, sort even more granularly, and adjust column widths for better presentation views.

Nathan Bao

March 4, 2022

Analysis
Who’s Behind the Numbers? A Conversation with Dr. Angela Baltes—Data Scientist, Informaticist & Senior Research Analyst

We are excited to start this series by highlighting Dr. Angela Baltes—a Data Scientist, Informaticist, and Senior Research Analyst.

Chioma Dunkley

February 15, 2022

Mode updates
Mode's Diversity Report for Q4, 2021

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Derek Steer

February 7, 2022 2 minute read

Mode updates
Visual Explorer for Executives and Stakeholders

Discover how Visual Explorer can make your team work more efficiently.

James Locus

February 2, 2022

Mode updates
Introducing our new CEO, Gaurav Rewari

Today, we welcome Gaurav Rewari as Mode’s new CEO.

Derek Steer & Gaurav Rewari

January 11, 2022 3 minute read

Mode updates
See Mode’s Visual Explorer in Action [Webinar]

Get a tour of Visual Explorer and see how it makes data exploration easier.

James Locus

January 5, 2022 2 minute read

Analysis
PostgreSQL Date Functions and 7 Ways to Use Them in Business Analysis

PostgreSQL date functions (like DATE_TRUNC, EXTRACT, and AGE) make wrangling timestamps much easier. Follow these seven use case examples…

Joel Carron

January 4, 2022

Analysis
How to Master Anti Joins and Apply Them to Business Problems

How to perform an anti join using LEFT JOIN and WHERE. Plus three examples of using anti joins in business scenarios.

Joel Carron

January 4, 2022 7 minute read

Mode updates
Connecting Your Data to Charts for More Expressive Insights

With Visual Explorer, analysts can customize their visualizations to help stakeholders better understand their data.

James Locus

December 14, 2021 2 minute read

Visualization
Violin Plots 101: Visualizing Distribution and Probability Density

A violin plot is a hybrid of a box plot & a kernel density plot, which shows peaks in the data. Learn the various types & discover tools to…

Joel Carron

December 13, 2021 5 minute read

Analysis
How to Switch from Excel to SQL

Learning SQL is easy when you know Excel. Learn how to make the transition in this guided example & seriously speed up your workflow.

Melissa Bierly

December 10, 2021 10 minute read

Mode updates
Introducing Visual Explorer for Data Exploration

You can now explore your data faster in Mode with Visual Explorer, our new flexible visualization system.

James Locus

December 6, 2021 3 minute read

Analysis
Group By in SQL and Python: a Comparison

Analysts and data scientists with a deep understanding of multiple analytical programming languages find themselves at an advantage in today…

David Wallace

December 3, 2021 11 minute read

Visualization
9 Useful R Data Visualization Packages for Data Visualization

For new R coders, CRAN’s repository may seem overwhelming. Here’s an overview of 9 useful interdisciplinary R data visualization packages to…

Asha Hill

December 1, 2021

Mode updates
Mode's Diversity Report for Q3, 2021

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Bailey Douglass

November 5, 2021 2 minute read

Analysis
Our Take On Prescriptive Analytics and How We Used it in 2020

In 2020, Mode used prescriptive analytics to field turbulent economic conditions; here’s a closer look at what we did and how it helped us…

Rochel Maday

October 28, 2021 7 minute read

Analysis
Analyzing JSON data with SQL

Use SQL to manipulate & restructure JSON data and streamline your analytical workflow. This process makes it easy to repeat analysis…

Nathan Vos

October 25, 2021 5 minute read

Visualization
12 Python Data Visualization Libraries to Explore for Business Analysis

This list is an overview of 10 interdisciplinary Python data visualization libraries including matplotlib, Seaborn, Plotly, Bokeh, pygal…

Melissa Bierly

October 22, 2021 10 minute read

Mode updates
Now Live: Scale Data Collaboration Securely with Collection Permissions

Ensure that the right teams have the right level of access to data with granular Collection permissions.

Ethan Alter

September 7, 2021 4 minute read

Mode updates
Mode's Diversity Report for Q2, 2021

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Bailey Douglass

August 6, 2021 2 minute read

Mode updates
Mode is Certified Redshift Ready

Mode has achieved the Amazon Redshift Ready designation, part of the Amazon Web Services (AWS) Service Ready Program.

Ethan Alter

June 29, 2021 1 minute read

Mode updates
How Our Award-Winning Customer Support Team Built a Best-in-Class Tech Stack

We’re pulling the curtains back on the tech stack for our award-winning customer success team.

Jessica Schimm

June 28, 2021 3 minute read

Mode updates
Measure Your Mode Usage with Discovery Database

Mode now offers two methods for admins to measure how their organization uses Mode: Discovery Database and Discovery API.

Nate Coleman

June 15, 2021 3 minute read

Mode updates
Now Live: Mode University + Revamped Help and Support

Get more out of Mode with the help of Mode University and our new revamped Help + Support site.

Ethan Alter

June 8, 2021 1 minute read

Analysis
Types of Product Usage Segmentation

Users will teach us more about our own product than any amount of self-study possibly could. Here's a closer look at product segmentation.

Ethan Alter

May 18, 2021 8 minute read

Mode updates
Mode's Diversity Report for Q1, 2021

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Bailey Douglass

May 5, 2021 2 minute read

Mode updates
Now Live: Data Freshness Integration With dbt

We're partnering with dbt from Fishtown Analytics to help users better understand data freshness when viewing reports in Mode.

James Locus

April 12, 2021 2 minute read

Mode updates
Now Live: Create Calculated Fields in Explorations

This new release allows you to create new calculated fields within Explorations that don't impact the underlying report.

Katie Flynn

April 6, 2021 2 minute read

Mode updates
Mode’s Diversity Report for Q4, 2020

Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.

Bailey Douglass

March 24, 2021 2 minute read

Analysis
How to Avoid Inflated A/B Test Results

Our A/B tests could be leading us astray. If we understand and account for the statistical significance filter, we can get more trustworthy…

Julia Glick

March 19, 2021 4 minute read

Mode updates
Mode’s Customer Support Team Brings Home a Gold Stevie® Award for Customer Support

We're excited to announce that Mode's Senior Manager of Customer Support and Success Operations, Asha Hill, has been recognized for her team…

Rebecca West

February 3, 2021 2 minute read

Mode updates
The Case for Humility, aka: “Keep doing nothing, Bindu”

Humility is not always celebrated in tech, but it should be.

Maura Ginty

January 22, 2021 2 minute read

Mode updates
Core Concepts: Create a Single Source of Truth for Your Data

We built a single source of truth for Mode's data and can help you with yours in a new promotion through the end of January 2021.

Mode

December 22, 2020

Mode updates
Webinar recap: Datasets that we wanted to take a second look at in 2020

Our data crew shared datasets that left a lasting impact on them this year and why. We’ve recapped some of the highlights.

Lilianna Hogan

December 22, 2020 3 minute read

Mode updates
Mode’s Diversity Report for Q3, 2020

Here are the self-reported diversity statistics of our team at the end of Q3 in 2020.

Bailey Douglass

December 16, 2020 2 minute read

Analysis
(At Least) 5 Ways Data Analysis Improves Product Development

Traditional BI tools are great at answering static questions, but not the big-picture questions that determine your product roadmap.

Maura Ginty

December 8, 2020 3 minute read

Mode updates
We Can’t Reverse the Division of Our Country Without America’s Corporations

"Consider this a call to my fellow CEOs: let’s acknowledge that politics exist in the workplace. Let’s shape our companies to deliberately…

Derek Steer and Benn Stancil

November 22, 2020 5 minute read

Analysis
Lessons Data Teams Can Learn From the 2020 Election Polls

Has polling played too big of a role in our elections? And similarly, how much weight should data have in our business decisions?

Nate Coleman

November 13, 2020 4 minute read

Mode updates
Please Take the Time to Vote

Find out where and how.

Mode

October 30, 2020 1 minute read

Analysis
Now Live: Analytic Functions in Calculated Fields

Analytic functions make Calculated Fields even more powerful by allowing you to calculate metrics based on specified partitions of your data…

Ying Luo

September 23, 2020 4 minute read

Mode updates
Mode’s Diversity Report for Q2, 2020

Having an inclusive culture and diverse team is important to us at Mode. To hold ourselves accountable to improve representation at all…

Bailey Douglass

September 15, 2020 1 minute read

Mode updates
Now Live: Easy Python Library Updates With Python Edge

Today we’re launching Python Edge to create a smoother experience when Python library updates occur.

Hien Phan

August 18, 2020 1 minute read

Mode updates
Now Live: Mode’s Explorations Introduce Collaborative Self-Serve BI

We’ve launched Explorations—a new feature to help you collaborate with your domain experts for better analysis.

Katie Flynn

August 12, 2020 3 minute read

Mode updates
Announcing Our Series D

We just closed a round of Series D funding. We couldn’t achieve this without our incredible network of investors, customers, employees, and…

Derek Steer

August 6, 2020

Mode updates
Now Live: Get Faster Insights With Calculated Fields in Mode

Today, we’re launching Calculated Fields to improve your workflow, extend your analysis, and explore data faster.

Katie Flynn

August 3, 2020 3 minute read

Mode updates
Now Live: New Features to Help You Manage Users and Discover Data at Scale

Today’s releases create more efficiency in admin workflows and enhance your ability to manage data and metadata at scale. We’re excited to…

Katie Flynn

July 27, 2020 3 minute read

Analysis
The Top 5 Most Popular Window Functions and How to Use Them

The data team at Mode loves SQL. We code it, write about it, and empower people to use it all over the world. In that vein, we thought it…

Nate Coleman

July 23, 2020 5 minute read

Data Teams
How Five Data Leaders Are Leading Teams Through the Pandemic

Mode interviewed five data leaders during the COVID-19 pandemic to discuss their strategies for maneuvering through a crisis.

Jessica Schimm

July 15, 2020 1 minute read

Analysis
How to Do Linear Regression in SQL

"We’ve all had to work with simpler tools than we might like from time to time, and I have gotten a lot of mileage out of doing regression…

Julia Glick

June 29, 2020 2 minute read

Analysis
Use Common Table Expressions (CTE) to Keep Your SQL Clean

At Mode, we put a lot of emphasis on writing good, clean SQL. As a collaborative team, it’s important that our queries can be easily read…

Joel Carron

June 16, 2020 4 minute read

Mode updates
Our Stance on Racial Injustice

Mode stands with Black communities. We stand with our Black team members. But saying this alone is not enough.

Mode

June 5, 2020 1 minute read

Analysis
Newly Remote Workers Left Internet Explorer at the Office

As COVID-19 caused many people to start working from home, we observed an interesting trend: a steep decline in the rate of web traffic to…

Joel Carron

May 27, 2020 1 minute read

Analysis
Reassessing Customer Health Scores in a Fluctuating Market

Here’s how we launched a volatility-driven customer health score model in days, not weeks.

Lizz Harrell

May 21, 2020 4 minute read

Data Teams
You... May Enjoy These Recent Mode Product Enhancements

We’d like to spotlight some new analytics workflow enhancements and improvements to managing large organizations in Mode.

Mike DeCarlo

May 5, 2020 3 minute read

Analysis
13 Shortcuts for Mode Power Users

Have a lot of analysis to get through? Here’s a quick list of handy shortcuts for Mode power users.

Sam Novak

April 27, 2020 5 minute read

Mode updates
Just When You Thought You Had It All: Homeschooling + Working

Working and parenting at the same time is tough. We love and adore our children and are simultaneously sharing strategies in Slack about on…

Maura Ginty

April 14, 2020 3 minute read

Mode updates
Leading by Example: How Mode Customers are Giving Back in Trying Times

We’re proud of these customers that have pivoted quickly to help their communities and ease new realities.

Jessica Schimm

April 9, 2020 2 minute read

Mode updates
We're Sharing Our Slack Guidelines and How They're Helping in an All-Remote Culture

Our CEO rolled out internal Slack guidelines in January not realizing how critical they would be today. We're publishing them now to be…

Derek Steer

April 8, 2020 15 minute read

Mode updates
An Analyst’s Perspective on COVID-19’s Economic Impact on Businesses

In a previous life, Mode's co-founder and president worked as an economic analyst studying the 2008 financial crisis. Here is his assessment…

Benn Stancil

March 25, 2020 12 minute read

Mode updates
COVID-19: We Don't Work Alone

In the weeks and months to come, all of Mode is aligned to help our users and your communities.

Derek Steer

March 19, 2020 2 minute read

Mode updates
How Mode Went Completely Remote in 36 Hours, and 7 Tips We Learned Along the Way

We rounded up our top seven learnings on how to transition a multi-city company to a completely remote workforce in 36 hours.

Maura Ginty

March 12, 2020 4 minute read

Analysis
A Dispassionate Examination of the Empirical Evidence Regarding Positional Punctuation in SQL

"As data scientists, our work sways elections; our models move markets; our recommendations launch and dismantle businesses. In positions of…

Benn Stancil

January 9, 2020 5 minute read

Analysis
How to Demystify Skewed Data and Deliver Analysis

Our data doesn’t always look nice and clean. Mode's Data Scientist, Nate Coleman, shows us how visualizing distributions can tell us if our…

Nate Coleman

December 20, 2019 6 minute read

Mode updates
Design Systems are for Everyone

Here at Mode, we’ve recently started building a design system to support our organization. Design systems have been a hot topic of…

Anthony Simone

October 29, 2019 19 minute read

Mode updates
Announcing Helix: Closing the Data Divide

Since its inception, Mode has been for data scientists and analysts. As former data scientists, my cofounders and I started Mode with the…

Benn Stancil

October 8, 2019 2 minute read

Mode updates
Embedding Data Protection by Design in Analytics Services

As an analytics platform, Mode operates in a very contentious space with respect to data protection and privacy. In fact, data analytics and…

Rafae Bhatti

September 30, 2019 4 minute read

Data Teams
3 Tips for Effective Data Science Processes

Here are some quick notes on how to accelerate your data science efforts for a larger impact.

Benn Stancil

September 19, 2019 1 minute read

Analysis
How Mode and intermix.io Deliver Fast Queries on Amazon Redshift

Lars Kamp is the Co-Founder & Chief Data Engineer at intermix.io where he helps customers optimize Amazon Redshift and their analytics…

Lars Kamp

September 17, 2019 4 minute read

Mode updates
Hack Days at Mode

When the idea of instituting regular hack days began at Mode several years ago, it started—as it does for many companies—as a way to break…

Curtis Mitchell

September 16, 2019 3 minute read

Mode updates
Learning Mode’s Ruby codebase through its Gemfile

What is the most efficient way to wrap your head around an unfamiliar codebase?

Max Edmands

September 9, 2019 4 minute read

Mode updates
Gems We Love

At Mode, we have an interview question we often use during phone screens for engineering candidates which is “What is an example of a…

Ushashi Chakraborty

August 25, 2019 5 minute read

Mode updates
1,000,000x Improvement to Your Data Application Stack with the Switch Framework

Josh Ferguson, Cofounder and Chief Architect at Mode, recently gave a talk at Data Council introducing our framework for building data…

Paul Thurlow

August 19, 2019 1 minute read

Mode updates
What Really Matters: Our Favorite Mode Values

At Mode, we make decisions while staying true to our company values. We asked few of our engineers and engineering leaders about the values…

Ushashi Chakraborty

August 5, 2019 4 minute read

Data Teams
4 Lessons to Keep Your Data Model Under Control

A data model defines how an organization's various data sources are organized, related, and accessed. As data sources are added and…

Joel Carron

May 2, 2019 3 minute read

Data Teams
Get More Done With the New API Cookbook and Developer Docs

Today, we're announcing the newly-designed Mode developer site. The new site contains extensive documentation of commonly used API endpoints…

Leqi Long

March 27, 2019 2 minute read

Data Teams
Using Empathy to Communicate Your Analysis

As analysts and data scientists, we have to make our work compelling and persuasive to change the way our organizations think. It can be…

Benn Stancil

March 5, 2019

Data Teams
The Problem With Hands-Off Analytics

A hands-off approach would seem reckless for questions about things like security. And yet that approach is not just the norm for analytical…

Benn Stancil

February 14, 2019 2 minute read

Mode updates
Mode Has Raised a Series C!

There's a fundamental change taking place in the way that organizations make decisions. For analysts and data scientists, the days of being…

Derek Steer

February 12, 2019 2 minute read

Mode updates
You're Only 30 Minutes From Answers

Regardless of how agile your team might be, you're limited by how quickly you can provision a warehouse, build ETL pipelines, set up event…

Benn Stancil

January 24, 2019 2 minute read

Data Teams
Overplanned Analytics Initiatives Are Doomed to Fail

One of the most common reasons an organization reaches out to Mode is that they're about to begin investing in analytics, and they want our…

Benn Stancil

January 14, 2019

Data Teams
How to Develop the Five Soft Skills That Will Make You a Great Analyst

Analysts often assume that the best way to advance their careers or provide more value is to improve their technical chops. While it's true…

Derek Steer

December 4, 2018 10 minute read

Analysis
Chess Fans Booed This Year's World Championship, but Computers Cheered

The World Chess Championship 2018, a match between reigning champion Magnus Carlsen and challenger Fabiano Caruana, just came to a…

Joel Carron

November 28, 2018 4 minute read

Analysis
Don't Choose Dashboards Over Analysis

When we talk to analytics teams about what they're working on and what big projects are coming up, this is a common refrain we hear: “Right…

Benn Stancil

November 2, 2018 2 minute read

Analysis
How to Make Your Product Freemium

In case you missed it, we launched a free product earlier this year, Mode Studio. Free products aren't common in the world of analytics…

Benn Stancil

October 25, 2018 8 minute read

Mode updates
The Role of an Analyst in the Age of the Citizen Data Scientist

Anytime you look for patterns in previous experiences, or make a tradeoff between one option and another, you're analyzing something. This…

Derek Steer

September 25, 2018 2 minute read

Mode updates
More Cool Public Datasets and Lots of Ideas for Exploring Them

A few weeks ago, Google announced a new feature, Dataset Search, that aims to make it easier for anyone to discover public datasets…

Asha Hill

September 18, 2018 8 minute read

Analysis
JOINs in SQL, Python, and R

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…

Sadavath Sharma

September 12, 2018 7 minute read

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

As analysts, we know that each question we ask of our data can be answered with multiple potential languages and toolkits. Each language has…

Sadavath Sharma

August 30, 2018 5 minute read

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

If your company is one of the thousands using Salesforce on a daily basis, their customer-relations management (CRM) tool is a treasure…

Sadavath Sharma

August 16, 2018 5 minute read

Data Teams
How We Learn Analytical Skills on the Job: Christin Price in Finance

Any time you look for patterns in previous experiences or make a tradeoff between one option and another, you're working with analytical…

Liam Hausmann

August 14, 2018 4 minute read

Data Teams
How We Learn Analytical Skills on the Job: Brian Libicki

At Mode, we believe everyone is analytical. Any time you look for patterns in previous experiences, or make a tradeoff between one option…

Liam Hausmann

August 9, 2018 4 minute read

Data Teams
How We Learn Analytical Skills on the Job: Alexa Guerra

At Mode, we believe everyone is analytical. Any time you look for patterns in previous experiences, or make a tradeoff between one option…

Liam Hausmann

August 7, 2018 3 minute read

Analysis
Knowing Your Blindspot as an Analyst

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…

Derek Steer

July 30, 2018 3 minute read

Mode updates
Summertime Gladness: Mode Gets Better

We are always looking for ways to improve Mode. Sometimes this means adding completely new features, but other times this means taking a…

Katie Lane

July 25, 2018 2 minute read

Data Teams
3 Analytics Leaders on Building Efficient Teams

What makes an analytics team great? To find out, we interviewed the leaders of three. Our discussion ranged from team structure, to mission…

Tayler Mehit

July 18, 2018 5 minute read

Data Teams
The Big Four Reasons Companies Struggle to Hire Data Talent

Between the thousands of data scientists, analysts and others who use Mode every day, and the hundreds of companies that run their…

Derek Steer

July 11, 2018 4 minute read

Visualization
12 Extensions to ggplot2 for More Powerful R Visualizations

We're featuring 12 of our favorite ggplot2 extensions, to help you add more power and polish to your ggplots—or just to make them easier to…

Asha Hill

July 2, 2018 13 minute read

Analysis
3 Weird Analytical Practices at Mode

For many of Mode's employees, this is their first job at an analytics company. Those team members often assume that Mode's internal…

Tayler Mehit

June 25, 2018 4 minute read

Data Teams
The Future of Data Engineering is the Convergence of Disciplines

Jasmine Tsai got her first taste of data engineering through a common gateway: she was tasked with a data project as a software engineer…

Liam Hausmann

June 7, 2018 7 minute read

Analysis
Introducing Plotly for R in Mode

Plotly lets analysts and developers create powerful interactive visualizations, whether offline or right in your browser. Plotly.R is now…

Marissa Gemma

May 30, 2018 2 minute read

Data Teams
How to Attract Top Data Science Talent: Lessons from 1,400+ Insight Fellows

When Jake Klamka founded Insight Data Science in 2011, the term “data science” had a much different understanding in the private sector than…

Liam Hausmann

May 1, 2018 9 minute read

Analysis
7 R Data Science Influencers to Follow

Among data scientists and analysts, R has long held its own against Python in the battle to determine the “best” analytical programming…

Marissa Gemma

April 25, 2018 6 minute read

Analysis
Announcing R and Mode Studio: A Free Toolkit for Every Analyst

Four years ago, Mode set out to build the best data platform for every analyst in the world. Since then, we've seen more and more people…

Derek Steer

April 17, 2018 3 minute read

Analysis
3 Industry Leaders on the Future of Data Tooling

Specialized tooling has proliferated the data engineering community. This trend is growing, and the data infrastructures of modern…

David Wallace

April 10, 2018 5 minute read

Analysis
The (Data Science) Notebook: A Love Story

Computational notebooks for data science have exploded in popularity in recent years, and there's a growing consensus that the notebook…

David Wallace

April 2, 2018 6 minute read

Data Teams
5 Data Scientists on Making the Leap from Academia to Industry

As an academic discipline, data science is bigger than ever, and still growing. Inside Higher Ed recently reported that 303 new accredited…

Marissa Gemma

March 28, 2018 8 minute read

Analysis
Set Operations in SQL and Python: a Comparison

As an analyst or data scientist, developing a deep understanding of multiple analytical programming languages can create an advantage in…

David Wallace

March 22, 2018 6 minute read

Mode updates
Delivering Embedded Analytics With Wordpress

The collection and analysis of user data by software companies is key part of the product development process. User data is valuable to more…

Emily Ritter

March 19, 2018 2 minute read

Analysis
Styling Analysis with Python

Python's powerful data analysis capabilities are loved the world over. When it comes time to share findings with your team, taking a few…

David Wallace

March 14, 2018 2 minute read

Analysis
How Facebook Made Business Forecasting Scalable for the Masses with Prophet

It's time to add forecasting to your data team's tool kit. Mode notebooks now support Prophet, a powerful forecasting library for Python and…

David Wallace

March 6, 2018 3 minute read

Visualization
8 Great In-App Analytics Pages in B2B Software

Usage data is like gold for software development teams. Software companies are constantly analyzing user behavior to create valuable insight…

Liam Hausmann

February 28, 2018 5 minute read

Data Teams
Resources for Data Science Job Seekers

Getting your first job in data science can be a full-time job all on its own. Simply finding a job post worth applying to can be a chaotic…

Sadavath Sharma

February 12, 2018 7 minute read

Analysis
How to Create a Great In-App Analytics Page

So you've built a software product, and you have some users. You're generating data about how users interact with your product. You want to…

Joel Carron

February 1, 2018 6 minute read

Visualization
Drill Deeper, Make Better Decisions

Now, before going back to the analyst to ask your next big game-changing question, you can answer more of the simple stuff on your own—right…

Emily Ritter

January 30, 2018 2 minute read

Analysis
Python and SQL Intersection in Analytics

A look at recent trends in the data science and analytics landscape shows it’s becoming increasingly advantageous to have a deep…

David Wallace

January 23, 2018 5 minute read

Analysis
Window Functions in Python and SQL

As an analyst or data scientist, it’s becoming increasingly advantageous to have a deep understanding of multiple analytical programming…

David Wallace

January 23, 2018 8 minute read

Visualization
How Mode's User Stats Page Answers Customer Questions While Increasing Feature Use

Analysts and product teams now work together to build White-Label Embeds that solve all sorts of data delivery use cases. Most commonly…

Joel Carron

January 18, 2018 4 minute read

Data Teams
How Quora’s Head of Data Science Conducts Candidate Interviews

Eric Mayefsky, head of data science at Quora, has assessed hundreds of job candidates in his half decade in management at various tech…

Liam Hausmann

January 16, 2018 10 minute read

Analysis
Scaling Event Tables with Redshift Spectrum

We here at Mode Analytics have been Amazon Redshift users for about 4 years. Redshift enables and optimizes complex analytical SQL queries…

David Wallace

January 11, 2018 5 minute read

Analysis
35 New and Improved Python Libraries in Mode

Just in time to make good on New Year's resolutions, today we're releasing a major upgrade to Mode's Python Notebooks: support for over 2…

Marissa Gemma

January 9, 2018 2 minute read

Analysis
In Early-Stage Analytics, Decide and Move Forward

In this day and age, every company needs an analytical decision-making culture. Every company needs to be data-driven. And not someday…

David Wallace

January 4, 2018 3 minute read

Mode updates
AWS re:Invent 2017: Freedom (and Frameworks) to Build

This year's annual AWS re:Invent conference was full of exciting product announcements. From long-awaited crowd-pleasers such as Elastic…

David Wallace

December 18, 2017 4 minute read

Analysis
Analyzing Customer Success Performance With 3D Visualization

Customer success teams are a central pillar of recurring-revenue businesses. Great customer success teams help users get the highest…

Joel Carron

December 14, 2017 5 minute read

Analysis
Molecule's Embedded Analytics & Updates to White-Label Embeds

Last year, we launched White-Label Embeds to provide a secure and seamless way to serve data to customers as a part of any application. Our…

Angeline Char

December 12, 2017 1 minute read

Analysis
Designing An Analytics Stack Like We Design Software

2017 feels like a turning point for the analytics community—everyone seems to be talking about the sudden proliferation of analytics tools…

David Wallace

December 6, 2017 7 minute read

Mode updates
7 Python Data Science Influencers to Follow

A few months ago, Stack Overflow confirmed what many people have been predicting for years, and crowned Python king of the software jungle…

Marissa Gemma

November 29, 2017 7 minute read

Mode updates
Amazon Redshift Improvements & re:Invent 2017

Amazon Redshift users got a nice surprise last month when AWS announced their new Dense Compute (DC2) nodes, providing up to twice the…

David Wallace

November 22, 2017 2 minute read

Mode updates
Mode's Python Notebooks now support the Requests library

Mode is the only analytics platform with native support for Python Notebooks. For the last year and a half, Mode users have been rapidly…

Angeline Char

November 21, 2017 2 minute read

Mode updates
Webhooks and the Mode API are here

Analysts turn to Mode as the toolkit of choice for their work: SQL and Python-powered data exploration, visualization, and advanced…

David Wallace

November 16, 2017 2 minute read

Analysis
Query Your S3 Data with Amazon Athena and Mode

Connect Mode to Amazon Athena to explore data stored in Amazon Simple Storage Service (Amazon S3). An interactive query service that…

Angeline Char

October 26, 2017 1 minute read

Data Teams
How to Job Interview a Data Scientist

Hiring a data scientist can be a tricky process. The actual definition of “Data Scientist” is vague, the day-to-day job of someone with…

Derek Steer

October 24, 2017 6 minute read

Visualization
How to Use Your Brand's Color Palette in Data Visualizations

The applications of color theory in business are vast. One of the most useful applications of color theory is the visualization and…

Samantha Novak

October 12, 2017 7 minute read

Visualization
Custom Chart Colors and Brand New Palettes

Colors are key to understanding data visualizations. They represent your data and guide people through charts and dashboards, making them…

Angeline Char

October 11, 2017 2 minute read

Mode updates
Better Admin Controls with Query Headers

Earlier this week, we released visualization filters that allow everyone on Mode to interact more deeply with dashboards to find new answers…

Angeline Char

September 28, 2017 2 minute read

Mode updates
Product Update: Visualization Filters

Over the last few months, we've been heads down building new power into Mode to help everyone explore data. Earlier this summer we released…

Angeline Char

September 26, 2017 2 minute read

Mode updates
How to Find the Best Data Jobs

Pairing great data talent with great data jobs As an analyst, finding a great job can be tough. We're all too familiar with this here at…

Liam Hausmann

September 14, 2017 4 minute read

Analysis
Choosing an ETL Tool for Your Analytics Stack

For most companies, essential data starts its life in all sorts of silos. Many businesses are running on a growing range of SaaS platforms…

Benn Stancil

August 8, 2017 12 minute read

Mode updates
WrangleConf 2017: Facing bias, ethical obligation, and your audience

As it has in previous years, WrangleConf 2017 brought to the foreground some of the most pressing issues for data scientists today. While…

Cindy Willis-Chun

July 26, 2017 6 minute read

Visualization
Brand. New. Charts.

Phase II of this summer's code-free data exploration rollout is now live: drag-and-drop data exploration.

Emily Ritter

July 13, 2017 3 minute read

Mode updates
Filters: Fast, Easy Data Exploration

A couple of weeks ago we announced a series of new code-free data exploration features to let everyone find answers hidden in data. The…

Emily Ritter

May 31, 2017 3 minute read

Mode updates
Two Big Leaps Forward

There's a common misconception that an analyst's work is lonely. That we're mad scientists off in a corner somewhere crunching numbers in…

Derek Steer

May 16, 2017 2 minute read

Mode updates
4 Design Tips for TV-Ready Dashboards

Designing dashboards for display around the office introduces unique challenges for effectively communicating insights. The dashboards need…

Nick Binder

May 11, 2017 2 minute read

Mode updates
Dashboards That Deliver

Dashboards. They're the best way to keep every team focused on goals and provide critical context for your business as a whole. While not…

Nick Binder

May 3, 2017 2 minute read

Mode updates
Custom Data Visualizations in the Workplace

Analysts at companies of all sizes are pushing beyond ordinary dashboards and charts, using custom data visualizations to deliver high…

Nick Binder

April 6, 2017 2 minute read

Analysis
Using dbt and Mode to Help Eko Rebuild its Analytics Stack

You might not have heard of Eko, but chances are you’ve interacted with their content. Eko has pioneered the medium of interactive video and…

Drew Banin

April 5, 2017 4 minute read

Visualization
25+ Resources to Learn D3.js from Scratch

From streamgraphs to voronoi to polar clocks, there's essentially no limit to the types of data visualizations you can make with the…

Melissa Bierly

March 14, 2017 6 minute read

Visualization
Taking Data Viz to the Next Level

Presenting data effectively is a critical part of communicating insights. Making reports look appealing or building interactive charts isn't…

Nick Binder

March 9, 2017 3 minute read

Mode updates
Keep Your Dashboards On Brand With Custom CSS

Analysts know that having the right numbers is only half the battle. In order for your work to make an impact, it has to be presented in a…

Joel Carron

March 7, 2017 3 minute read

Mode updates
Give Your Team Context, With New Text Elements

The best analysts know that charts alone are not always enough to inform decisions. Even the most amazing chart of all time can be left open…

Nick Binder

March 2, 2017 2 minute read

Mode updates
This Just in from Stitch: Introducing Singer, Open Source ETL

Our partner Stitch is introducing Singer: an open source project for simple, composable ETL. Singer enables any data source to be analyzed…

Emily Ritter

March 1, 2017 2 minute read

Analysis
4 Handy SQL Tips for Pivot Tables

Mode's SQL-powered pivot tables are designed to give everyone the ability to instantly explore shared data sets. But a pivot table is only…

Jennifer Chu

February 28, 2017

Mode updates
Improved Python Notebooks Make Sharing Analysis Easier than Ever

Today we're rolling out two new updates for Mode Python Notebooks, making Python analysis more efficient and accessible to everyone.

Nick Binder

February 23, 2017 3 minute read

Mode updates
Introducing: SQL-Powered Pivot Tables

When trying to understand a data set, analysis often starts broad and narrows as you go. SQL is perfect for pulling the broad data set and…

Nick Binder

February 14, 2017 2 minute read

Analysis
Creating Persistent Derived Tables

Now that the Mode SQL editor supports running multiple SQL statements, you can do so much more than pull data back from the database. One…

Joel Carron

February 8, 2017 7 minute read

Analysis
5 Tips for Faster Access to Analysis with Spaces

Keeping work organized is hard. It's time consuming to ensure everything is in the right place and clearly labeled. Plus, if you're not sure…

Nick Binder

February 2, 2017 3 minute read

Visualization
Where to Find the Cleanest Restaurants in NYC

What we found when we mapped over 400k NYC restaurant health inspection scores.

Joel Carron

February 1, 2017 3 minute read

Mode updates
Hello, Slack Enterprise Grid!

Back in December, we brought customers 12 new features in 12 days, including the highly requested Mode Slack app. People are now sharing…

Emily Ritter

January 31, 2017 1 minute read

Mode updates
A Note On Donald Trump

On December 20th, 2016, the day the Electoral College made Trump's presidency official, we sent this internal letter to the Mode team. Now…

Mode

January 30, 2017 2 minute read

Analysis
Beyond Clicks and Opens: Measuring the Impact of Engagement Campaigns

Sometimes, your customers need a little nudge to engage more deeply with your product. This can happen for a whole host of reasons…

Melissa Bierly

January 12, 2017 4 minute read

Mode updates
Stats That Grow With You

We just capped off 12 days of new features, but we couldn't resist adding one more before the holidays!

Nick Binder

December 20, 2016 2 minute read

Mode updates
Preview Definitions, Right in the Editor

We launched Definitions back in September to help analysts save time writing queries and establish trusted business logic across projects…

Nick Binder

December 16, 2016 2 minute read

Mode updates
Make a Statement. Then Make Another One.

Today we're releasing the #1 most requested SQL editor feature: support for multiple SQL statements in one query. Hello, temp tables!

Nick Binder

December 15, 2016 1 minute read

Mode updates
Easily Customizable Organization Settings

Over the past 10 days we've added four powerful new ways to share analysis: Slack, email upgrades, external sharing, and White-Label Embeds…

Nick Binder

December 14, 2016 1 minute read

Mode updates
Mode Integrates with Slack to Help Teams Share Data, Faster

The Mode Slack App is here! Now it's easier than ever to put timely, relevant data into the hands of decision makers, right when and where…

Emily Ritter

December 13, 2016 1 minute read

Mode updates
Deliver Charts Straight to Your Co-worker's Inbox

Email is still a mainstay for communication and sharing ideas, even if it feels like it's going the way of the dinosaur. Whether it's ad hoc…

Nick Binder

December 12, 2016 1 minute read

Mode updates
New Gallery Examples

Analysis isn’t just about finding the insights—it’s about delivering them to your coworkers. And often the biggest challenge is helping…

Nick Binder

December 11, 2016 3 minute read

Mode updates
Upping the Contrast to Provide Better Legibility

It's easy to get swept up in the latest design trend. Remember when everyone was into skeuomorphism? Long shadows? All caps cursive with a…

Blake Reary

December 10, 2016 1 minute read

Mode updates
SQL Query History in the Click of a Button

Query history button ⌘-Z! ⌘-Z! We've all been there.

Nick Binder

December 9, 2016 1 minute read

Mode updates
Share Analysis With Anyone You Want

External sharing As your business grows, so too does the list of people outside your company who need to access to data and reporting…

Nick Binder

December 8, 2016 2 minute read

Mode updates
From Our Product to Yours: Introducing White-Label Embeds

Embedded analytics As consumers, we're increasingly accustomed to seeing data served back to us as features in the apps and products we use…

Emily Ritter

December 7, 2016 3 minute read

Mode updates
The Feature on Every Analyst's Wish List: Highlight to Run

Highlight to run Today, as part of our effort to deliver 12 highly requested “Wish List” features in 12 days, we're adding highlight to run…

Nick Binder

December 6, 2016 1 minute read

Mode updates
12 days. 12 features.

12 features. 12 days. From highly-requested SQL editor upgrades, to tools to share analysis with everyone in your organization (and beyond…

Nick Binder

December 5, 2016 1 minute read

Mode updates
A Word Cloud of Westworld

Last week, we examined HBO's original series Westworld with charts showing the relationships between characters, whom they mention, and how…

Joel Carron

November 22, 2016 3 minute read

Analysis
Data Wrangling Westworld

For the past seven weeks, a corner of the internet has been obsessed with the HBO original series Westworld. Redditors have spent hours…

Joel Carron

November 15, 2016 5 minute read

Analysis
If Artificial Intelligence Wrote the Presidential Acceptance Speech

Clinton and Trump are two of the most unpopular presidential nominees in U.S. history. That made us wonder: Would we be better off if a…

Joel Carron

November 3, 2016 3 minute read

Analysis
Tracking Customer Service Metrics With SQL

Regardless of the size or purpose of your company, customer service (or success or support) is a crucial part of your customer lifecycle…

Kostas Pardalis

October 18, 2016 9 minute read

Mode updates
Analytics Dispatch 045: Data in the deep fryer

The impact of outliers, marathon performance, and why machine learning is like deep frying.

Nick Binder

October 17, 2016 2 minute read

Mode updates
Accessing Reports from Multiple Spaces

Last month we launched our new Spaces feature to make it easier to organize reports around teams and projects. Analysts quickly found a good…

Nick Binder

October 13, 2016 1 minute read

Mode updates
5 Python Libraries for Creating Interactive Plots

According to data visualization expert Andy Kirk, there are two types of data visualizations: exploratory and explanatory. The aim of…

Melissa Bierly

October 12, 2016 6 minute read

Mode updates
Analytics Dispatch 044: Studying The Simpsons

Nobel Prize winners, your typical farmers market, and The Simpsons side characters.

Nick Binder

October 10, 2016 2 minute read

Mode updates
Analytics Dispatch 043: Data movie magic

The year's best data visualizations, fact checking the debate, and movie magic with data viz.

Nick Binder

October 3, 2016 2 minute read

Mode updates
Analytics at Clearbit: Simple, flexible, scalable

Problem Analytics are hard to get right – especially for complex business models (like API-first SaaS). Building a flexible analytics stack…

Luke Whiting

September 30, 2016 4 minute read

Mode updates
Weekly Data Science News Roundups You Can Get In Your Inbox

Data science newsletters Where do you get your data science news? Twitter? Reddit? Social media is a great way to discover new articles…

Melissa Bierly

September 26, 2016 5 minute read

Mode updates
Analytics Dispatch 042: Polling the pollsters

Gender roles in Hollywood, stats for soccer fans, and four results from one election poll.

Nick Binder

September 26, 2016 3 minute read

Mode updates
Automating Ad Spend Reporting

As a demand generation marketer, I'm constantly searching for the right mix of ad platforms and publishers to bring in leads. But when each…

Alexa Guerra

September 22, 2016 7 minute read

Mode updates
Analytics Dispatch 041: Income rising

DROPPIN' BEATS Visualizing Hundreds of My Favorite Songs on Spotify A deep statistical dive into defining songs with attributes—such as…

Melissa Bierly

September 19, 2016 2 minute read

Mode updates
Making Simple Visualizations Easy: A Front-End Engineer's Perspective

Franklin at Mode Since the beginning, one of Mode's goals has been to make simple things easy and complex things possible. In the past year…

Melissa Bierly

September 15, 2016 9 minute read

Analysis
Clean Up Your Code in Just One Click

Anybody who's ever tried writing code of any kind knows that style matters. Caps or no caps? CamelCase or use_underscores? Tabs or spaces…

Nick Binder

September 13, 2016 2 minute read

Mode updates
Dashboard Reporting with Multiple Sources

From the start, Mode's goal has been to make data more accessible. When analysts and their business partners work together on one data…

Nick Binder

September 12, 2016 2 minute read

Mode updates
Analytics Dispatch 040: The state of data engineering

Digital economists, swing states, the art of asking good questions.

Melissa Bierly

September 12, 2016 2 minute read

Mode updates
Analytics for Every Team

Mode for Teams A trio of new features is launching today: Definitions, Spaces, and Access Controls are all designed to create a tight-knit…

Emily Ritter

September 8, 2016 3 minute read

Mode updates
Dynamic Parameters: Save Time Writing Picklists

When analysts create reports for teams throughout their company, there are inevitable follow-up questions. Engagement is higher on mobile…

Nick Binder

August 31, 2016 2 minute read

Visualization
Pareto Chart 101: Visualizing the 80-20 Rule

Pareto chart abstracted You've probably heard of the Pareto principle, even if you didn't realize it at the time. Here are a few examples…

Joel Carron

August 30, 2016

Analysis
8 Handy Python Libraries for Formatting and Cleaning Data

These Python libraries will make the crucial task of data cleaning a bit more bearable—from anonymizing datasets to wrangling dates and…

Melissa Bierly

August 23, 2016 5 minute read

Mode updates
Analytics Dispatch 037: End the language war

Visualizing clickbait, counting conundrums, and the problem with the Rio pool.

Melissa Bierly

August 22, 2016 2 minute read

Mode updates
70+ Resources for Transitioning to a Data Science Career

Considering a career in data science? Time to read up. Here's a list of tutorials, tips for interviewing, and stories from people who've…

Melissa Bierly

August 16, 2016 11 minute read

Mode updates
Analytics Dispatch 036: Data journalists go for gold

Trump tweets, Olympic data viz, and tips for designing better tables.

Melissa Bierly

August 15, 2016 3 minute read

Mode updates
Communicating Trends Just Got Easier with Big Number Charts

Mode now offers Big Number charts, to clearly display your key numbers and easily build dashboards that offer insights at a glance.

Nick Binder

August 11, 2016 2 minute read

Mode updates
New Integration: Tenjin.io

Today we're excited to announce Mode's new integration with DataVault from Tenjin, a company focused on providing marketers insight into…

Emily Ritter

August 10, 2016 1 minute read

Mode updates
Analytics Dispatch 035: Visualizing Slack

A Star Trek network viz, ethics for algorithms, and the Olympics.

Melissa Bierly

August 8, 2016 3 minute read

Mode updates
Build Algorithms Like You Give a Damn

WrangleConf Opening Source: Sam Charrington via Twitter For the second year in a row, WrangleConf did not disappoint. The conversation…

Derek Steer

August 2, 2016 6 minute read

Mode updates
Hello, Stitch!

Stitch Logo Last October, our friends at RJMetrics introduced the beta version of their ETL service, RJMetrics Pipeline. Today, they've…

Emily Ritter

August 1, 2016 2 minute read

Mode updates
Analytics Dispatch 034: Lies and statistics

Data viz developments, dodgy statistics, and genomics.

Melissa Bierly

August 1, 2016 2 minute read

Data Teams
Defining Metrics: An Interview with Walker & Co’s 1st Product Manager

Since its debut in 2013, Walker and Company has drawn attention for its unique mission: to make health and beauty simple for people of color…

Melissa Bierly

July 26, 2016 7 minute read

Analysis
67 Years of Lego Sets

There are many of us—errr, people—who build stuff with Legos at all ages. Having grown up with loads of hand-me-down Legos (and having a…

Joel Carron

July 21, 2016 8 minute read

Mode updates
Introducing the Mode Example Gallery

Sometimes communicating data is as simple as sharing out a basic chart. Sometimes telling an impactful data story means creating a knock-out…

Joel Carron

July 14, 2016 2 minute read

Mode updates
Taking Heap SQL to the Next Level with Mode

Today we're excited to announce Mode's integration with Heap, a powerful platform that enables you to build analytics infrastructure for…

Emily Ritter

July 12, 2016 2 minute read

Analysis
Thinking in SQL vs Thinking in Python

Over the years, I've used a variety of languages and tools to analyze data. As I think back on my time using each tool, I've come to realize…

Benn Stancil

July 7, 2016

Visualization
11 Data Visualization Experts Who Will Constantly Inspire You

When writers hit a block, they read. When musicians get stuck, they seek stimulation by listening to music. It's the same with any craft…

Melissa Bierly

June 28, 2016 7 minute read

Visualization
A New Way to Measure Customer Service

As your business grows, maintaining excellent customer service requires delivering high-quality solutions efficiently and effectively. But…

Joel Carron

June 23, 2016 8 minute read

Visualization
Added Plotly Support Makes Mode Python Notebooks More Powerful

No matter how you're looking to present your data, there's a seemingly endless number of Python libraries and resources to use (check out…

Nick Binder

June 21, 2016 2 minute read

Analysis
How DataHoliks Predicted Highfive's Customer Engagement

In our previous blog post, we covered some of the exploratory analysis we did for Highfive, a modern meeting room collaboration and video…

Sourav Dey

June 16, 2016 8 minute read

Visualization
Updated Tables Make Exploring Data in Mode Even Easier

Sometimes you just need to share a data set. A list of app users who meet certain criteria. A call list for a sales team. You get the idea…

Nick Binder

June 15, 2016 2 minute read

Visualization
What Election Map History Can Teach You About Presenting Data

Presenting new data always raises more questions than it answers. Your coworkers want to better understand results to inform decision-making…

Joel Carron

June 2, 2016 8 minute read

Analysis
Measuring Customer Engagement: How DataHoliks Helped Highfive Find the Right Metric

Head into a conference room at RueLaLa or Expensify and you’ll probably see something special: people actually enjoying meetings. They’ve…

Sourav Dey

May 26, 2016 7 minute read

Analysis
Making Analytics Accessible

Since day one, Mode has been a product built by analysts, for analysts. As analysts, we're at our best when free to uncover unexpected…

Derek Steer

May 23, 2016 3 minute read

Data Teams
Practical Tips for Democratizing Data at Your Company

Intronis CEO Rick Faulk argues that there are three key benefits of total transparency at your company: Employee trust and buy-in A more…

Melissa Bierly

May 19, 2016 6 minute read

Mode updates
12 User Retention Resources to Help You Drive Growth

Despite the fact that retention is key for SaaS and mobile growth, there's very little consensus on the factors that indicate good retention…

Melissa Bierly

April 27, 2016 6 minute read

Mode updates
Snazzy New Ways to Add and Edit Charts

Head over to the Report Builder to check out a few new features that will make it easier to present a data story beautifully. Rather than…

Emily Ritter

April 14, 2016 1 minute read

Data Teams
3 Ways to Build Trust in Your Sales Analyses

With the emergence of data integration tools it's easier than ever to get your hands on consolidated data from third-party tools. Access to…

Melissa Bierly

April 13, 2016 6 minute read

Mode updates
Your Customer Data in One Place: Segment Sources

Did Sheila get the answer she needed when she emailed our support team? Did Joe spend more in store this trip compared to last trip? Did…

Emily Ritter

April 6, 2016 2 minute read

Data Teams
How Does the Data Science Team Work at Twitch?

Head over to Twitch on any given day and you'll find 250,000 broadcasters live streaming content to more than two million concurrent viewers…

Melissa Bierly

April 5, 2016 10 minute read

Analysis
Analyzing CRM Data? Familiarize Yourself with These 5 Salesforce Objects First

The Salesforce customer relationship management (CRM) tool is your sales organization's second brain. It's a memory bank filled with every…

Melissa Bierly

March 29, 2016 8 minute read

Analysis
3 Things Your User Retention Rate is Hiding

With bad retention, acquisition efforts fill a leaky bucket. Great retention, on the other hand, can bolster a wide variety of important…

Benn Stancil

March 17, 2016 11 minute read

Analysis
What Rom-Coms Can Teach Us About User Engagement Strategies

We recently talked about ways to set your customers up to be successful, long-term users of your product. By identifying strong audiences…

Benn Stancil

March 9, 2016 5 minute read

Mode updates
It's Here! Share Analysis via Email

If a tree falls in the forest and no one is there to hear it, does it make a sound? We're not entirely sure. What we do know is that if you…

Emily Ritter

March 3, 2016 2 minute read

Data Teams
Ask the Analyst: What's It Like to Work at a Wedding E-commerce Company?

Many shopping sites follow a similar retail calendar, focusing on big promotional pushes around the holidays. But when you're in the…

Melissa Bierly

March 2, 2016 7 minute read

Analysis
How 72 Popular Instagram Photographers Use Color

Yesterday, we explored how brands use colors on Instagram. Today, we're looking at trends in Instagram's early-adopter photographer…

Melissa Bierly

February 24, 2016 4 minute read

Mode updates
Do Brand Colors Translate to Instagram?

Starbucks green. UPS brown. Target red. Some of the most recognized brands have built their visual identity on just one color. They create…

Melissa Bierly

February 23, 2016 3 minute read

Analysis
4 Ways to Tackle Growth with Retention

Retention has long played second fiddle to user acquisition. It's easy to see why: getting new users is fun and can feel impressive (5,00…

Melissa Bierly

February 2, 2016 4 minute read

Mode updates
Introducing Layouts

Sometimes you just want to put two charts next to each other. Now you can. Today we're rolling out a new drag-and-drop report builder that…

Emily Ritter

January 21, 2016 2 minute read

Visualization
2015 in Review: What Questions Did Analysts Ask?

In 2015, people used Mode to answer thousands of questions. As we looked back on the year, we were curious about trends across companies…

Melissa Bierly

January 14, 2016 4 minute read

Mode updates
New Features for Embedded Reports

When it comes to distributing analysis, it can be helpful to put data where folks discover it over the natural course of their day. For some…

Emily Ritter

January 8, 2016 2 minute read

Mode updates
Introducing the All-New Mode

Like the analysts who use Mode day-in and day-out to answer some of the hardest questions a business can throw at them, we hammer on our…

Emily Ritter

December 17, 2015 3 minute read

Analysis
Discover New Ways to Explore Your CRM Data with SQL

Anyone who's used Salesforce is familiar with its reporting dashboard. The deal pipeline, the closed deals speedometer, the reps' activities…

Melissa Bierly

December 11, 2015 9 minute read

Mode updates
What's the best database for an analyst?

Which database is best? The question, obviously, depends on what you want to use it for.

Benn Stancil

December 9, 2015 6 minute read

Analysis
Funnel Analysis: How RJMetrics Used Their New Product to Analyze Its Own Onboarding Funnel

In October, we launched our new product, RJMetrics Pipeline. Pipeline integrates data from all the systems you use to run your business…

David Wallace

December 3, 2015 6 minute read

Data Teams
3 Tips for Centralizing Your Analytics Team Structure As You Grow

Nearly a year ago we wrote about the questions folks should consider when making early analytics hires. While those questions are helpful…

Melissa Bierly

December 1, 2015 4 minute read

Analysis
Data Science in the HIPAA Compliant Cloud

There’s a pretty cool marriage of tech and health going on right now. You can see it on the “about” page of so many of the Rock Health…

Emily Ritter

November 20, 2015 3 minute read

Analysis
Smooth Out the Noise of Daily Data With Moving Averages in SQL

The moving average is the Swiss Army knife of metrics. It's adaptable, reliable, and simple to use.

Saul Jackman

November 12, 2015 5 minute read

Mode updates
Working with UTM Parameters in SQL to Answer Bottom-of-the-Funnel Questions

Are our ebooks more successful on LinkedIn than on Twitter? If you've ever worked with a marketer to understand campaign and channel…

Emily Ritter

November 4, 2015 6 minute read

Analysis
Get New Analytics Hires up to Speed with This Handy Database Visualization

On my first day at Mode, I was given a list of basic business questions to answer. How many SQL queries do our customers write each day? How…

Saul Jackman

October 29, 2015 9 minute read

Mode updates
The Human Element of Data Science

There's an interesting discussion happening in the Silicon Valley data science community. Last week about 100 data scientists gathered for…

Derek Steer

October 26, 2015 4 minute read

Mode updates
4 Data Science Insights from the Rich Data Summit

On Wednesday over 500 members of the data science community gathered at the Village in San Francisco for CrowdFlower’s Rich Data Summit. It…

Melissa Bierly

October 16, 2015 4 minute read

Analysis
DATE_TRUNC: A SQL Timestamp Function You Can Count On

DATE_TRUNC() function in SQL allows you to round a timestamp to the interval you need, making timestamps easier to aggregate on and easier…

Saul Jackman

October 6, 2015

Analysis
How to Make a Box-and-Whisker Plot in SQL

Understanding how your data is distributed is critical for any analysis. Box-and-whisker plots are great for summarizing distributions and…

Benn Stancil

October 1, 2015 7 minute read

Mode updates
Working with Email Addresses in SQL

Analyzing datasets that include email addresses can be a pain. But when armed with a few common operations, you can clean your data quickly…

Benn Stancil

September 24, 2015 3 minute read

Mode updates
Deliver Analysis, Not Charts

Data analysis can be a bit like baseball An old baseball coach of mine used to say “that's a million-dollar catch and a ten-cent throw…

Benn Stancil

September 10, 2015 2 minute read

Mode updates
We Don't Work Alone

Join Us At The Data Table Today we're announcing our $7.5 Million Series A, led by Foundation Capital.

Derek Steer

August 20, 2015 2 minute read

Mode updates
Amp Up Your Amplitude Data

Query Your Amplitude Data Our friends over at Amplitude have a unique approach to event tracking and analytics for mobile apps. Like some…

Emily Ritter

June 2, 2015 3 minute read

Visualization
Cohort Analysis That Helps You Look Ahead

A standard cohort analysis, like the one commonly seen in Mixpanel For people who analyze customer behavior, the table above is a familiar…

Benn Stancil

May 11, 2015 4 minute read

Mode updates
It's Time to Slice and Dice! Introducing Pivot Charts

When we launched Mode's new SQL workflow earlier this year, we said there would be a lot to come on the charting front. Today the first set…

Emily Ritter

March 31, 2015 3 minute read

Mode updates
Turning SQL Queries Into Self-Serve Data Tools

An analyst's daily work can get repetitive. One day a request from a product manager can sound like: “Hi Derek, could you please pull the…

Derek Steer

March 27, 2015 5 minute read

Analysis
Finding User Sessions with SQL

A lot of product questions are based on the idea of a user “session.” What do users do when they first log in? In what order do users take…

Benn Stancil

March 20, 2015 7 minute read

Mode updates
How to Ask an Analyst a Question

Asking questions is easy. It's so easy that, as askers, we often don't think about the quality of our questions. Poorly framed questions…

Derek Steer

March 18, 2015 3 minute read

Mode updates
The Evolution of a Data-Driven Startup

People often talk about a startup's evolution in terms of funding, sales, or product engagement milestones. But companies also change over…

Derek Steer

March 12, 2015

Analysis
Beyond Hacker News: Finding Watsi's Growth Engine

Our friends over at Segment recently came to us with a great idea: they wanted to get a bunch of analysts together to help a non-profit find…

Benn Stancil

March 6, 2015 1 minute read

Mode updates
Get Collaborative with Big Data

As more teams get up and running on Mode to analyze data together, we're hearing more requests for connections to a wider variety of…

Emily Ritter

February 17, 2015 2 minute read

Analysis
How 1 Clever Trick Helps CrowdFlower Fly Through 10x More Support Tickets

CrowdFlower, the leading data enrichment platform, helps data scientists collect, clean, and label data. Their on-demand workforce tackles…

Emily Ritter

February 13, 2015 2 minute read

Analysis
Analyzing Analysts To Build Better Analysis Software

When we launched Mode's public beta in June 2014, we knew we were putting an MVP (minimum viable product) editor into the wild. As soon as…

Benn Stancil

February 6, 2015 5 minute read

Analysis
Balancing Data Analysis With Design Research

Mode recently released a big update to our collaborative analytics tool. The new features were informed by a careful combination of product…

Blake Reary

February 6, 2015 5 minute read

Mode updates
Introducing A More Powerful SQL Workflow

We're on a mission to build analysis software that works the way today's analysts work. And that means building tools an analyst can share…

Emily Ritter

February 5, 2015 2 minute read

Analysis
Facebook's Aha Moment Is Simpler Than You Think

Many leading tech companies have promoted “aha moments”—the instant a user understands the value of their product—as a key to growth. Most…

Benn Stancil

January 30, 2015 6 minute read

Data Teams
4 Questions to Consider When Making Your Next Analytics Hire

Over the course of a startup's lifetime, a company can face a range of data challenges. In the beginning, startup founders do most analysis…

Derek Steer

January 27, 2015 6 minute read

Mode updates
Building Credibility for Your Analytics Team—and Why It Matters

If you work with data regularly, chances are you trust it. You know how it's collected and stored. You know the caveats and the roadblocks…

Derek Steer

January 21, 2015 5 minute read

Mode updates
For 15 NFL Teams, Next Season Starts Today

Today marks the last day of the 2014 NFL regular season. Sixteen teams enter this week with a chance to claim one of the 12 spots in the…

Benn Stancil

December 28, 2014 2 minute read

Mode updates
Open Sourcing Our Analysis

We recently launched the Mode Playbook, a series of open-source SQL queries and visualizations designed to be tailored to common data…

Benn Stancil

November 12, 2014 4 minute read

Mode updates
Introducing the Mode Playbook, Cloud Connector, and Support for Segment SQL

We're thrilled to bring you Playbook, a series of open source SQL queries and visualizations you can tailor to your data. If you have a SQL…

Emily Ritter

November 5, 2014 3 minute read

Mode updates
Automate Your SQL Queries and Dashboards

If you've ever run a SQL query and thought, "welp, that's gonna take a while..." we'd like to introduce you to your new favorite feature…

Emily Ritter

October 14, 2014 2 minute read

Analysis
Could Friday be the Best Day to Publish Your Tech Startup’s Press Release?

Conventional wisdom says that it’s best to issue press releases in the middle of the week: the press is more active and readers more engaged…

Benn Stancil

September 26, 2014 6 minute read

Mode updates
Collaborate your way to better SQL queries and data visualizations

This week's feature release includes collaborative editing and homepage updates that put your favorite reports, lists, and dashboards front…

Emily Ritter

September 24, 2014 2 minute read

Mode updates
Lists, Dashboards, and new Report features to simplify your SQL workflow

This week's new features are based on the insightful feedback from teams of data analysts using Mode to create and share SQL-based analyses…

Emily Ritter

September 15, 2014 2 minute read

Mode updates
Meet Mode at DataWeek

If you're heading to the DataWeek + APIWorld 2014 conference next week, we hope to meet you. You can track us down by attending one of the…

Emily Ritter

September 10, 2014 2 minute read

Analysis
Conversation starters: the data behind your story

First Tom Giratikanon brought to light the spread of military surplus gear in this alarming New York Times graphic. And then he did…

Emily Ritter

August 22, 2014 2 minute read

Mode updates
Crowdsourcing Labor Day Adventures

With just over a week left before we put our white pants away (or not—who does that?), we teamed up with our friends at CrowdFlower to start…

Emily Ritter

August 21, 2014 2 minute read

Mode updates
Say Hello to Mode's Public Table API!

The public table API makes it easier to get your datasets into Mode using scripts written in languages like Python, Ruby, and R. Data…

Josh Ferguson

August 14, 2014 2 minute read

Analysis
Fit Christoph Janz's cohort analysis to your data in less than 5 minutes

In just a few steps, you can create a living cohort analysis that anyone at your company can update any time -- without exporting data to…

Emily Ritter

August 8, 2014 2 minute read

Mode updates
5 Public Datasets, and Lots of Ideas for Exploring Them

The world is full of interesting datasets. But even though data is increasingly accessible, it's sometimes hard think up an interesting…

Benn Stancil

July 23, 2014 15 minute read

Analysis
Are Home Run Derby Hitters Different?

Benn Stancil

July 14, 2014 1 minute read

Mode updates
A New Way to Learn SQL—and Five Reasons to Start Now

Several years ago, I made the jump from being an Washington, D.C. policy analyst to a data analyst at a San Francisco tech company. Prior to…

Benn Stancil

July 8, 2014 3 minute read

Analysis
Are Taxi Drivers Racist?

Benn Stancil

June 27, 2014 11 minute read

Mode updates
Welcome to Mode

The world is producing fascinating data at an unprecedented pace, on subjects ranging from air quality in Chicago, to the economics of…

Derek Steer

June 17, 2014 2 minute read

Analysis
Where Americans Think They Live

Benn Stancil

May 5, 2014 2 minute read

Analysis
Are the Playoffs Taking Forever?

Benn Stancil

May 1, 2014 6 minute read

Analysis
Finding the Most Gerrymandered Districts

Benn Stancil

April 16, 2014 5 minute read

Analysis
Plotting the Rest of the Baseball Season

Benn Stancil

April 11, 2014 2 minute read

Analysis
FiveThirtyEight vs. The Oddsmakers

Benn Stancil

March 28, 2014 5 minute read

Analysis
The Odds of Your Bracket

Benn Stancil

March 18, 2014 2 minute read

Analysis
Engineering a Best Picture

Benn Stancil

February 27, 2014 11 minute read

Analysis
How Big Are Winter Olympians?

Benn Stancil

February 20, 2014 3 minute read

Analysis
Ninety Years of College Football Recruiting, in One Map

Benn Stancil

February 6, 2014 5 minute read

Analysis
Where are the Offensive Penalties in the NFL Playoffs?

Benn Stancil

February 2, 2014 3 minute read

Mode updates
Are Experienced Founders Better?

Benn Stancil

January 30, 2014 7 minute read

Analysis
Where College Basketball Teams Recruit

Benn Stancil

January 21, 2014 3 minute read

Mode updates
Where Football Players Call Home

Benn Stancil

January 16, 2014 3 minute read

Analysis
When is a One-Hit Wonder a One-Hit Wonder?

Benn Stancil

January 8, 2014 8 minute read

Mode updates
Predictions for Data Analysis in 2014

Derek Steer

January 3, 2014 5 minute read

Analysis
The History of 'Groups of Death' in the World Cup

Benn Stancil

December 16, 2013 2 minute read

Analysis
Are Stanford Grads Good Investments?

Benn Stancil

December 9, 2013 7 minute read

Analysis
10 Charts San Franciscans Should Be Thankful For

Benn Stancil

November 28, 2013 9 minute read

Analysis
What Can Moneyball Teach Us About Unicorns?

Peter Fishman

November 20, 2013 5 minute read

Analysis
The Demographics of Obamacare—And Those Who Oppose It

Benn Stancil

November 4, 2013 4 minute read

Analysis
The Red Sox and Cardinals. Again.

Benn Stancil

October 23, 2013 4 minute read

Analysis
Is Seed Round Funding from VCs Good for Startups?

Benn Stancil

October 17, 2013 7 minute read

Analysis
The Market for U.S. Debt - Too Big to Disrupt

Benn Stancil

October 15, 2013 3 minute read

Analysis
Mapping Cannabis Prices: An Interactive Visualization of Marijuana Sales

During a recent walk through the Tenderloin in San Francisco, a man asked me if I wanted to trade a joint for a cigarette.

Benn Stancil

October 3, 2013 5 minute read

Analysis
Scoring Your Fantasy Football Draft, Before It’s Too Late

Benn Stancil

September 25, 2013 7 minute read

Analysis
Has YouTube (and Miley Cyrus) Peaked?

Benn Stancil

September 21, 2013 6 minute read

Analysis
How to Create 100,000 Parking Spots in San Francisco

Benn Stancil

September 18, 2013 6 minute read

Analysis
The Agony, Ecstasy, and Odds of a (Nearly) Perfect Game

Benn Stancil

September 9, 2013 5 minute read

Analysis
Are Traffic Lights the Real Hyperloop?

Benn Stancil

September 6, 2013 3 minute read

Mode updates
A Data-Driven Look at the VMAs

Benn Stancil

September 2, 2013 5 minute read

Get our weekly data newsletter

Work-related distractions for every data enthusiast.