Having an inclusive culture and diverse team is important to us at Mode. Here are our latest diversity numbers.
Derek Steer
June 9, 2022•
This guide is designed to help you navigate the challenges that arise in major economic shifts or rapid change.
Jessica Schimm
June 2, 2022•
Starting with Visual Explorer, we’re going to walk through ways you can use Mode to explore reports.
Chioma Dunkley
May 27, 2022•
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•
Cohort analysis is the process of breaking up users into cohorts and examining their behavior and trends over time.
Chioma Dunkley
March 29, 2022•
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•
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•
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•
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
Discover how Visual Explorer can make your team work more efficiently.
James Locus
February 2, 2022•
Today, we welcome Gaurav Rewari as Mode’s new CEO.
Derek Steer & Gaurav Rewari
January 11, 2022• 3 minute read
Get a tour of Visual Explorer and see how it makes data exploration easier.
James Locus
January 5, 2022• 2 minute read
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•
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
With Visual Explorer, analysts can customize their visualizations to help stakeholders better understand their data.
James Locus
December 14, 2021• 2 minute read
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
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
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
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
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•
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
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
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
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
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
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 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
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 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
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
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
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
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
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
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
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
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
Humility is not always celebrated in tech, but it should be.
Maura Ginty
January 22, 2021• 2 minute read
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•
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
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
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
"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
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
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
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
Today we’re launching Python Edge to create a smoother experience when Python library updates occur.
Hien Phan
August 18, 2020• 1 minute read
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
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•
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
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
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
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
"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
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 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
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
Here’s how we launched a volatility-driven customer health score model in days, not weeks.
Lizz Harrell
May 21, 2020• 4 minute read
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
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
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
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
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
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
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
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
"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
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
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
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
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
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
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
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
What is the most efficient way to wrap your head around an unfamiliar codebase?
Max Edmands
September 9, 2019• 4 minute read
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
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
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
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
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
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•
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
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
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
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•
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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 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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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. 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
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
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
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
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
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
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
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
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•
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
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
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
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
What we found when we mapped over 400k NYC restaurant health inspection scores.
Joel Carron
February 1, 2017• 3 minute read
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
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
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
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
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
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
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
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
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
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
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
Query history button ⌘-Z! ⌘-Z! We've all been there.
Nick Binder
December 9, 2016• 1 minute read
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
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
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
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
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
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
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
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
The impact of outliers, marathon performance, and why machine learning is like deep frying.
Nick Binder
October 17, 2016• 2 minute read
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
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
Nobel Prize winners, your typical farmers market, and The Simpsons side characters.
Nick Binder
October 10, 2016• 2 minute read
The year's best data visualizations, fact checking the debate, and movie magic with data viz.
Nick Binder
October 3, 2016• 2 minute read
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
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
Gender roles in Hollywood, stats for soccer fans, and four results from one election poll.
Nick Binder
September 26, 2016• 3 minute read
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
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
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
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
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
Digital economists, swing states, the art of asking good questions.
Melissa Bierly
September 12, 2016• 2 minute read
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
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 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•
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
Visualizing clickbait, counting conundrums, and the problem with the Rio pool.
Melissa Bierly
August 22, 2016• 2 minute read
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
Trump tweets, Olympic data viz, and tips for designing better tables.
Melissa Bierly
August 15, 2016• 3 minute read
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
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
A Star Trek network viz, ethics for algorithms, and the Olympics.
Melissa Bierly
August 8, 2016• 3 minute read
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
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
Data viz developments, dodgy statistics, and genomics.
Melissa Bierly
August 1, 2016• 2 minute read
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
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
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
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
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•
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Which database is best? The question, obviously, depends on what you want to use it for.
Benn Stancil
December 9, 2015• 6 minute read
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
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
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
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
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
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
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
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() 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•
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
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
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
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
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
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
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
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
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
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
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•
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Benn Stancil
February 6, 2014• 5 minute read
Benn Stancil
February 2, 2014• 3 minute read
Benn Stancil
January 24, 2014• 5 minute read
Benn Stancil
December 16, 2013• 2 minute read
Benn Stancil
November 28, 2013• 9 minute read
Benn Stancil
November 13, 2013• 6 minute read
Benn Stancil
November 4, 2013• 4 minute read
Benn Stancil
October 17, 2013• 7 minute read
Benn Stancil
October 9, 2013• 2 minute read
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
Benn Stancil
September 30, 2013• 3 minute read
Benn Stancil
September 25, 2013• 7 minute read
Benn Stancil
September 18, 2013• 6 minute read
Benn Stancil
September 12, 2013• 5 minute read
Benn Stancil
September 9, 2013• 5 minute read
Benn Stancil
September 3, 2013• 5 minute read
Work-related distractions for every data enthusiast.