mode helix
NOW LIVEEmpower your end users with Explorations in Mode.Try it now

Archive

Now Live: Data Freshness Integration with dbt

Today, we’re launching our data freshness integration with dbt to surface timestamp and origin information into Mode’s reports. The feature…

James Locus

April 12, 2021 2 minute read

Now Live: Create Calculated Fields in Explorations

You can now create new calculated fields within Explorations without affecting the underlying report. Local calculated fields will allow…

Katie Flynn

April 6, 2021 2 minute read

Our new Discovery Database can help you see your Mode usage data

You can’t manage what you can’t measure, which is why we recently launched Mode’s Discovery Database to provide on-demand access to your…

Nate Coleman

March 31, 2021 2 minute read

Mode’s 2020 Diversity Report for Q4

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

Bailey Douglass

March 24, 2021 2 minute read

How to Avoid Inflated A/B Test Results

This is a excerpt from our latest whitepaper on A/B testing. When we run a traditional linear regression analysis or a t-test, as we do for…

Julia Glick

March 19, 2021 4 minute read

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

We go to customer support teams for resolution of our most tense problems. A quick response is the first sign of relief. But it’s the…

Rebecca West

February 3, 2021 2 minute read

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

“Keep doing nothing, Bindu.” This is one of my favorite compliments at Mode. It’s meant for a person who always responds to appreciation by…

Maura Ginty

January 22, 2021 2 minute read

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

Learn more about the value Mode has seen internally from Core Concepts in our webinar. As the turn of the year approaches, teams are…

Mode

December 22, 2020 2 minute read

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

World events in 2020 put a big spotlight on data. From COVID maps to election updates to economy tracking, many of us kept refreshing data…

Lilianna Hogan

December 22, 2020 3 minute read

Mode’s 2020 Diversity Report for Q3

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

Bailey Douglass

December 16, 2020 1 minute read

(At Least) 5 Ways Data Analysis Improves Product Development

One of the inevitable questions brought to a data analyst at any SaaS company is: how do we use our data to improve our product? At Mode, we…

Maura Ginty

December 8, 2020 3 minute read

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

Americans are in the middle of one of the most important government transitions of our lifetimes, but one thing is likely to remain constant…

Derek Steer and Benn Stancil

November 22, 2020 5 minute read

Lessons Data Teams Can Learn From the 2020 Election Polls

If you were like me, you spent the week of November 3rd constantly refreshing the live feed from FiveThirtyEight in one browser window and…

Nate Coleman

November 13, 2020 4 minute read

Please Take the Time to Vote

Find out where and how.

Mode

October 30, 2020 1 minute read

Now Live: Analytic Functions in Calculated Fields

Back in August, we released Calculated Fields, a feature that allows analysts to work more quickly by performing post-SQL analysis. Now, we…

Ying Luo

September 23, 2020 4 minute read

Mode’s 2020 Diversity Report for Q2

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

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. See how it works: What is Python Edge…

Hien Phan

August 18, 2020 1 minute read

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

Today, we’re launching Explorations: a new feature to help you collaborate with your domain experts for better analysis. See how it works…

Katie Flynn

August 12, 2020 3 minute read

Announcing Our Series D

When we started Mode seven years ago, as the industry was just emerging, it felt impossible to hire a qualified data scientist, let alone…

Derek Steer

August 6, 2020 2 minute read

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. See how it works: What…

Katie Flynn

August 3, 2020 3 minute read

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

At Mode, we think a lot about scalability. We know you’re looking for functionality that will help you scale your business, such as more…

Katie Flynn

July 27, 2020 3 minute read

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. So, in that vein, we thought…

Nate Coleman

July 23, 2020 5 minute read

How Five Data Leaders Are Leading Teams Through the Pandemic

We had the opportunity to sit down with five data leaders from Lyft, Intercom, Patreon, Sisu, and Greenhouse to learn their strategies for…

Jessica Schimm

July 15, 2020 1 minute read

How to Do Linear Regression in SQL

Ordinary least squares (OLS) regression is one of the most powerful tools in a data scientist’s pocket. Personally, as someone who…

Julia Glick

June 29, 2020 2 minute read

Use Common Table Expressions (CTE) to Keep Your SQL Clean [with example]

Here 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…

Joel Carron

June 16, 2020 4 minute read

Our Stance on Racial Injustice

The murders of George Floyd, Breonna Taylor, Ahmaud Arbery, Tony McDade, and countless other victims of police brutality and systemic racism…

Mode

June 5, 2020 1 minute read

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

Reassessing Customer Health Scores in a Fluctuating Market

As COVID-19 spread, there were more questions than answers. The first from an SMB customer in the travel sector asking to defer payment…

Lizz Harrell

May 21, 2020 4 minute read

You... May Enjoy These Recent Mode Product Enhancements

Happy May! Each month, we share notes that summarize Mode enhancements and bug fixes. This month, we’d also like to share more details of…

Mike DeCarlo

May 5, 2020 3 minute read

13 Shortcuts for Mode Power Users

We move fast at Mode. This means we often find ourselves talking a lot about what’s next, but not always about the existing features and…

Sam Novak

April 27, 2020 5 minute read

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

Today marks the fourth week that my daughter’s preschool was closed, just hours ahead of the weekend, and days ahead of the official order…

Maura Ginty

April 14, 2020 3 minute read

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

In response to COVID-19, many individuals, organizations, and companies are giving back where they can. Acting generously during a time of…

Jessica Schimm

April 9, 2020 2 minute read

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

Until last year, I found Slack frustrating, but tolerable. It was a nice place to send all our alerts, and facilitate open conversation and…

Derek Steer

April 8, 2020 15 minute read

Adapting to Changing Times

Note: Mode is free to any researcher or organization working with public health or epidemiology models. Same if you’re coordinating…

Bailey Douglass

March 27, 2020 4 minute read

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

Note: Mode is free to any researcher or organization working with public health or epidemiology models. Same if you’re coordinating…

Benn Stancil

March 25, 2020 12 minute read

COVID-19: We Don't Work Alone

Friends of Mode, When we founded Mode in 2013, we spelled out our core values. The very first of those values is this: We Don't Work Alone…

Derek Steer

March 19, 2020 2 minute read

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

Note: Mode is free to any researcher or organization working with public health or epidemiology models. Same if you’re coordinating…

Maura Ginty

March 12, 2020 4 minute read

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

“In any dispute the intensity of feeling is inversely proportional to the value of the issues at stake.“ -- Sayre’s law As data scientists…

Benn Stancil

January 9, 2020 5 minute read

How to Demystify Skewed Data and Deliver Analysis

Exploring the distribution of data can surface meaningful patterns, trends, or significant errors in data that simple summary statistics…

Nate Coleman

December 20, 2019 6 minute read

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

Announcing Helix: Closing the Data Divide

Data strands, divided Since its inception, Mode has been for data scientists and analysts. As former data scientists, my cofounders and I…

Benn Stancil

October 8, 2019 2 minute read

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

3 Tips for Effective Data Science Processes

The more insights your data science team can uncover, the more informed decisions your business can make. Below are some quick notes on how…

Benn Stancil

September 19, 2019 1 minute read

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

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

Learning Mode’s Ruby codebase through its Gemfile

What is the most efficient way to wrap your head around an unfamiliar codebase? There are lots of fantastic options. Some examples: you can…

Max Edmands

September 9, 2019 4 minute read

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

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

What Really Matters: Our Favorite Mode Values

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

Ushashi Chakraborty

August 5, 2019 4 minute read

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

Get More Done With the New API Cookbook and Developer Docs

As a long-time member of Mode's success team, I've had countless conversations with customers looking for ways to automate common tasks and…

Leqi Long

March 27, 2019 2 minute read

Empathy and the Art of Analytical Persuasion

Even the most sophisticated analysis is no match for an apathetic audience. If the human at the other end of the table doesn't care about…

Benn Stancil

March 5, 2019 2 minute read

The Problem With Hands-Off Analytics

We recently went through a common process at Mode; we considered bringing on a new tool for our data infrastructure. While those of us on…

Benn Stancil

February 14, 2019 2 minute read

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

You're Only 30 Minutes From Answers

Last week, I urged data science teams to focus on delivering value quickly and iteratively (thanks to Ian Blumenfeld for highlighting the…

Benn Stancil

January 24, 2019 2 minute read

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 5 minute read

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

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

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

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

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

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

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

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

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

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

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

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

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

Summertime Gladness: Mode Gets Better

Some subtle, yet significant updates from the last quarter We are always looking for ways to improve Mode. Sometimes this means adding…

Katie Lane

July 25, 2018 2 minute read

3 Analytics Leaders on Building Efficient Teams

What makes an analytics team great? To find out, we interviewed the leaders of three: Maura Church, Senior Data Science Manager at Patreon…

Tayler Mehit

July 18, 2018 5 minute read

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

12 Extensions to ggplot2 for More Powerful R Visualizations

Since its introduction in 2007, ggplot2 has become one of the most frequently-downloaded and widely-used R packages in the world. Many…

Asha Hill

July 2, 2018 13 minute read

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

The Future of Data Engineering is the Convergence of Disciplines

Jasmine Tsai shares lessons from building and leading Clover Health’s data platform. Jasmine Tsai got her first taste of data engineering…

Liam Hausmann

June 7, 2018 7 minute read

Introducing Plotly for R in Mode

If you're an analyst, you probably already know and love the tools made by Plotly. Plotly lets analysts and developers create powerful…

Marissa Gemma

May 30, 2018 2 minute read

9 Useful R Data Visualization Packages for Any Discipline

If you've visited the CRAN repository of R packages lately, you might have noticed that the number of available packages has now topped a…

Asha Hill

May 18, 2018 10 minute read

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

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

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

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

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

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

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

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

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

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

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

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

“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

February 7, 2018 11 minute read

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

Drill Deeper, Make Better Decisions

I don’t know about you, but sometimes getting a new report from an analyst feels to me like an exciting holiday morning—or like unboxing an…

Emily Ritter

January 30, 2018 2 minute read

Python and SQL Intersection in Analytics

Working at Mode, I get to talk with a lot of analysts and data scientists. These talks have led to a ton of insightful conversations about…

David Wallace

January 23, 2018 5 minute read

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

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

When we introduced White-Label Embeds about a year ago, our goal was to give people the ability to deliver data to their communities in a…

Joel Carron

January 18, 2018 4 minute read

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

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

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

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

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

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

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

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

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

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'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

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

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

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

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

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

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

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

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

Choosing an ETL tool for your analytics stack

Editor’s note, April 2021: A lot has changed since this post was written in 2017. We’ve added short notes throughout where things have…

Benn Stancil

August 8, 2017 12 minute read

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

Brand. New. Charts.

Phase II of this summer's code-free data exploration rollout is now live: drag-and-drop data exploration. There's a whole new world of data…

Emily Ritter

July 13, 2017 3 minute read

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

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

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

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

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

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

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

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

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

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

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

4 Handy SQL Tips for Pivot Tables

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

Jennifer Chu

February 28, 2017 4 minute read

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. With…

Nick Binder

February 23, 2017 3 minute read

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

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

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

Where to Find the Cleanest Restaurants in NYC

New York City is home to 24,000 restaurants. If you dine at a different eatery every day, it will take you 65 years to visit all of them…

Joel Carron

February 1, 2017 3 minute read

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

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

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

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! As the year comes to a close and…

Nick Binder

December 20, 2016 2 minute read

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

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

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 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

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

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

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

SQL Query History in the Click of a Button

Query history button ⌘-Z! ⌘-Z! We've all been there. Sometimes, ⌘-Z doesn't take you back far enough. And sometimes, it's not a matter of…

Nick Binder

December 9, 2016 1 minute read

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

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

The Feature on Every Analyst's Wish List: 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 to the SQL editor…

Nick Binder

December 6, 2016 1 minute read

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

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

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

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

Violin Plots 101: Visualizing Distribution and Probability Density

Sometimes the median and mean aren't enough to understand a dataset. Are most of the values clustered around the median? Or are they…

Joel Carron

October 26, 2016 5 minute read

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

Timestamps are crucial to business analysis for a very simple reason: they tell you when things happen. Imagine trying to suss out trends in…

Joel Carron

October 20, 2016 10 minute read

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

Analytics Dispatch 045: Data in the deep fryer

OUTSIZED OUTLIER How One 19-Year-Old Illinois Man Is Distorting National Polling Averages This deep-dive into the methodology of an election…

Nick Binder

October 17, 2016 2 minute read

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

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

Analytics Dispatch 044: Studying The Simpsons

DOH! The Simpsons by the Data America's favorite family has been around for 27 years, providing plenty of data to analyze. Find out who's…

Nick Binder

October 10, 2016 2 minute read

How to Master Anti Joins and Apply Them to Business Problems

Anyone who has tried to learn SQL knows it's tricky to get the hang of joins. You're breezing through SELECT statements and comparison…

Joel Carron

October 4, 2016 7 minute read

Analytics Dispatch 043: Data movie magic

AND THE NOMINEES ARE... Kantar Information Is Beautiful Awards - Shortlist The shortlist for the Kantar Information Is Beautiful Awards has…

Nick Binder

October 3, 2016 2 minute read

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

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

Analytics Dispatch 042: Polling the pollsters

ONE POLL, FOUR RESULTS We Gave Four Good Pollsters the Same Raw Data. They Had Four Different Results. Dig into the methodology of four…

Nick Binder

September 26, 2016 3 minute read

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

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

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

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

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

Analytics Dispatch 040: The state of data engineering

ASK ME ANOTHER Asking good questions is hard (but worth it) Although this framework is written from a programmer's perspective, it's a great…

Melissa Bierly

September 12, 2016 2 minute read

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

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

Pareto Chart 101: Visualizing the 80-20 Rule

You've probably heard of the Pareto principle, even if you didn't realize it at the time. Here are a few examples: 80% of web traffic comes…

Joel Carron

August 30, 2016 5 minute read

Handy Python Libraries for Formatting and Cleaning Data

The real world is messy, and so too is its data. So messy, that a recent survey reported data scientists spend 60% of their time cleaning…

Melissa Bierly

August 23, 2016 5 minute read

Analytics Dispatch 037: End the language war

EASY AS 1, 2, 3? 3 Reasons Counting is the Hardest Thing in Data Science Counting isn't technically difficult; the real challenge lies in…

Melissa Bierly

August 22, 2016 2 minute read

70+ Resources for Transitioning to a Data Science Career

Data science career transition For folks hoping to make a career switch to data science, there are a ton of questions to tackle: Which…

Melissa Bierly

August 16, 2016 11 minute read

Analytics Dispatch 036: Data journalists go for gold

MUST-READ What I Wish I Knew About Data For Startups One entrepreneur reflects on his learnings from four years of working with data at a…

Melissa Bierly

August 15, 2016 3 minute read

Communicating Trends Just Got Easier with Big Number Charts

At the end of the day, a key job of any analytics team is to effectively communicate data and insights, with the goal of driving informed…

Nick Binder

August 11, 2016 2 minute read

New Integration: Tenjin.io

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

Emily Ritter

August 10, 2016 1 minute read

Analytics Dispatch 035: Visualizing Slack

ENGAGE! Star Trek Viz Explore this network visualization of the entire Star Trek universe (except for Star Trek: Beyond). Filter by episode…

Melissa Bierly

August 8, 2016 3 minute read

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

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

Analytics Dispatch 034: Lies and statistics

SPIN DOCTORS Our nine-point guide to spotting a dodgy statistic Numbers might appear unwavering and objective, but they're easily…

Melissa Bierly

August 1, 2016 2 minute read

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

It all started with a tweet. And just like that—after stints at AOL, ThisLife, and Shutterfly—Romy Macasieb became the first product manager…

Melissa Bierly

July 26, 2016 7 minute read

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

Introducing the Mode Example Gallery

Example Gallery Screenshot Sometimes communicating data is as simple as sharing out a basic chart. Sometimes telling an impactful data story…

Joel Carron

July 14, 2016 2 minute read

Taking Heap SQL to the Next Level with Mode

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

Emily Ritter

July 12, 2016 2 minute read

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 8 minute read

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

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

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

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

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

10 Python Data Visualization Libraries for Any Field | Mode

Scroll through the Python Package Index and you'll find libraries for practically every data visualization need—from GazeParser for eye…

Melissa Bierly

June 8, 2016 9 minute read

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

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

Dataholiks Logo Sourav Dey is a Partner at DataHoliks, a data-science consulting firm founded to help organizations apply data science…

Sourav Dey

May 26, 2016 7 minute read

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

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

12 User Retention Resources to Help You Drive Growth

12 User Retention Resources Despite the fact that retention is key for SaaS and mobile growth, there's very little consensus on the factors…

Melissa Bierly

April 27, 2016 6 minute read

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

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

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

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

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

3 Things Your User Retention Rate is Hiding

Retention. It's the quiet force behind your product's growth. With bad retention, acquisition efforts fill a leaky bucket. Great retention…

Benn Stancil

March 17, 2016 11 minute read

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

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

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

Weddington Way Office This is the first installment of our new “Ask the Analyst” series. We'll be interviewing analysts from various…

Melissa Bierly

March 2, 2016 7 minute read

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

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

4 Ways to Tackle Growth with Retention

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…

Melissa Bierly

February 2, 2016 4 minute read

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

How to Switch from Excel to SQL | Mode

If you use Excel at work, you're probably frustratingly familiar with this dialog box: Excel Dialog Box You've probably also worked on a…

Melissa Bierly

January 19, 2016 10 minute read

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

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

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

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

What's the best database for an analyst?

Which database is best? The question, obviously, depends on what you want to use it for. Best Database Search I, like most analysts, want to…

Benn Stancil

December 9, 2015 6 minute read

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

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

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

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. Stock traders know this better than…

Saul Jackman

November 12, 2015 5 minute read

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

Parsing UTM Parameters Parsed UTM parameters mean squeaky clean campaign data for analysis. Check out our entire series of #datapointers…

Emily Ritter

November 4, 2015 6 minute read

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

The Human Element of Data Science

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

Derek Steer

October 26, 2015 4 minute read

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

DATE_TRUNC: A SQL Timestamp Function You Can Count On

In a world of ever expanding data streams, we rely on timestamps to organize data down to the millisecond. But this level of detail can be…

Saul Jackman

October 6, 2015 4 minute read

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

Working with Email Addresses in SQL

datapointer001 parsingemailsAnalyzing datasets that include email addresses can be a pain. But when armed with a few common operations, you…

Benn Stancil

September 24, 2015 3 minute read

Deliver Analysis, Not Charts

An old baseball coach of mine used to say “that's a million-dollar catch and a ten-cent throw” (adapted from a famous Bull Durham quote) to…

Benn Stancil

September 10, 2015 2 minute read

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. Steve Vassallo is joining our board…

Derek Steer

August 20, 2015 2 minute read

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

Cohort Analysis That Helps You Look Ahead

For people who analyze customer behavior, the table above is a familiar one. This Mixpanel chart measures retention rates across different…

Benn Stancil

May 11, 2015 4 minute read

Enjoy Your Pie (And Other New Charts) A La Mode

Charts. We love them. And while we prefer actual pie to pie charts, we're excited to serve up a delicious new set of chart types a la Mode…

Emily Ritter

April 15, 2015 1 minute read

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

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

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

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

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 6 minute read

Beyond Hacker News: Finding Watsi's Growth Engine

How we used data to help Watsi find sustainable strategies for funding worldwide healthcare. Our friends over at Segment recently came to us…

Benn Stancil

March 6, 2015 1 minute read

Get Collaborative with Big Data

Now you can use Mode to analyze data in Apache Hive, Cloudera Impala, Google BigQuery, and HP Vertica! As more teams get up and running on…

Emily Ritter

February 17, 2015 2 minute read

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

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

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

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

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

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

Building Credibility for Your Analytics Team—and Why It Matters

Building a successful analytics team requires investment in everything from people and tools to infrastructure and event tracking. But the…

Derek Steer

January 21, 2015 5 minute read

For 15 NFL Teams, Next Season Starts Today

Benn Stancil

December 28, 2014 2 minute read

Open Sourcing Our Analysis

Benn Stancil

November 12, 2014 4 minute read

Automate Your SQL Queries and Dashboards

Emily Ritter

October 14, 2014 2 minute read

Collaborate your way to better SQL queries and data visualizations

multipleauthors ActivitySelector

Emily Ritter

September 24, 2014 2 minute read

Meet Mode at DataWeek

layout: mode title: "Meet Mode at DataWeek" author: "Emily Ritter" authortwitter: "emilyarden" authortitle: "Marketing at Mode" date: 201…

Emily Ritter

September 10, 2014 2 minute read

Conversation starters: the data behind your story

Emily Ritter

August 22, 2014 2 minute read

Crowdsourcing Labor Day Adventures

Emily Ritter

August 21, 2014 2 minute read

Say Hello to Mode's Public Table API!

Josh Ferguson

August 14, 2014 2 minute read

Five 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

Are Home Run Derby Hitters Different?

Benn Stancil

July 14, 2014 1 minute read

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

Are Taxi Drivers Racist?

Benn Stancil

June 27, 2014 11 minute read

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

Where Americans Think They Live

Benn Stancil

May 5, 2014 2 minute read

Are the Playoffs Taking Forever?

Benn Stancil

May 1, 2014 6 minute read

Finding the Most Gerrymandered Districts

Benn Stancil

April 16, 2014 5 minute read

Plotting the Rest of the Baseball Season

Benn Stancil

April 11, 2014 2 minute read

FiveThirtyEight vs. The Oddsmakers

Benn Stancil

March 28, 2014 5 minute read

The Odds of Your Bracket

Benn Stancil

March 18, 2014 2 minute read

Engineering a Best Picture

Benn Stancil

February 27, 2014 11 minute read

How Big are Winter Olympians?

Benn Stancil

February 20, 2014 3 minute read

Ninety Years of College Football Recruiting, in One Map

Benn Stancil

February 6, 2014 5 minute read

Where are the Offensive Penalties in the NFL Playoffs?

Benn Stancil

February 2, 2014 3 minute read

Are Experienced Founders Better?

Benn Stancil

January 30, 2014 7 minute read

Where College Basketball Teams Recruit

Benn Stancil

January 21, 2014 3 minute read

Where Football Players Call Home

Benn Stancil

January 16, 2014 3 minute read

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

Benn Stancil

January 8, 2014 8 minute read

Predictions for Data Analysis in 2014

Derek Steer

January 3, 2014 5 minute read

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

Benn Stancil

December 16, 2013 2 minute read

Are Stanford Grads Good Investments?

Benn Stancil

December 9, 2013 7 minute read

10 Charts San Franciscans Should Be Thankful For

Benn Stancil

November 28, 2013 9 minute read

What Can Moneyball Teach Us About Unicorns?

Peter Fishman

November 20, 2013 5 minute read

The Demographics of Obamacare—And Those Who Oppose It

Benn Stancil

November 4, 2013 4 minute read

The Red Sox and Cardinals. Again.

Benn Stancil

October 23, 2013 4 minute read

Is Seed Round Funding from VCs Good for Startups?

Benn Stancil

October 17, 2013 7 minute read

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

Benn Stancil

October 15, 2013 3 minute read

The Best - And Worst - Playoff Teams in Recent Sports History

Benn Stancil

October 9, 2013 2 minute read

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

Benn Stancil

September 25, 2013 7 minute read

Has YouTube (and Miley Cyrus) Peaked?

Benn Stancil

September 21, 2013 6 minute read

How to Create 100,000 Parking Spots in San Francisco

Benn Stancil

September 18, 2013 6 minute read

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

Benn Stancil

September 9, 2013 5 minute read

Are Traffic Lights the Real Hyperloop?

Benn Stancil

September 6, 2013 3 minute read

Conflict Data on Military Interventions: Will Syria Be Different?

Benn Stancil

September 3, 2013 5 minute read

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.