Automating reports can make workflows easier, data more accessible, and businesses more data-driven.

The benefits of company-wide KPI dashboards.

Here's what building a data-driven organization takes, with step-by-step actions.

We've built some successful churn prediction models at Mode—now, we're sharing what we've learned to predict churn effectively.

The pressure is on for data teams to deliver business insights at scale. Is self-service analytics the answer?

Get a basic primer on product metrics and the value they can generate across a company.

Physical and psychological safety for all of our employees is a non-negotiable for us. Here’s what we’re doing about the overturn of Roe v…

A modern data stack helps data teams, and the rest of their company, stay competitive and data-driven. Learn why it’s the best choice for…

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

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

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

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…

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

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

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

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

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

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

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

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

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

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

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…

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

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

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

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

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

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…

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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.

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

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

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

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

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

Find out where and how.

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

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

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

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

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

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

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

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…

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

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

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…

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

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…

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

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

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

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

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

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

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

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

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

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

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…

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

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

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

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

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

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…

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

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

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

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

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

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

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

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

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

Today, analysts themselves can get an entire data infrastructure up and running in 30 minutes.

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…

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…

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

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…

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…

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

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

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…

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

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

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

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

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

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…

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

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

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

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…

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

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

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

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

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

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…

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

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

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

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

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

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

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…

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

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…

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…

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…

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

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

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

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

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

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…

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

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

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

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…

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

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

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

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

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

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

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…

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

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

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

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…

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…

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

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

Phase II of this summer's code-free data exploration rollout is now live: drag-and-drop 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…

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…

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

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…

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

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…

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

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

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…

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…

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

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…

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

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…

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…

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…

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

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

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

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

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

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

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

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

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…

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…

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

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…

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

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

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

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…

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

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

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

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…

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

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

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

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

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

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

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…

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…

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…

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

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

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

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…

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

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…

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

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

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

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

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…

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…

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

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

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…

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…

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

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…

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

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…

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

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

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…

The first step to data democratization is granting employees access. The second is getting people to use data regularly.

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

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…

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…

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…

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…

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

The way we've all grown accustomed to looking at retention hides as much as it reveals. Deconstruct retention rate to help bolster virality…

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

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…

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

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

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

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…

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…

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

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…

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…

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

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

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

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

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…

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

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

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…

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

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

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

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

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

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…

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

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

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

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…

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…

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…

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…

Here's the data plan you need for each phase of your startup launch.

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…

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…

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

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…

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

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…

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

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…

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…

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…

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

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…

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…

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…

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

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…

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

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…

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

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…

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

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…

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

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