Eoin McMillan - Sourcetable Blog

How to use Aggregates in Sourcetable

Aggregating your data to find: AVG, COUNT, MIN, MAX, SUM Data analysis with spreadsheets relies on combining, changing, and investigating data to find useful information that can be used to make decisions. Aggregates are an important tool in your arsenal like structured referencing, or

Dashboard

Case Study: Where's all my data?

Luv Aj needed all of their analytics and reports in one place without sacrificing complex analysis and granular details. Sourcetable was there to help.

HowTo

How to use JSON data in Sourcetable

JSON files look confusing at first but once you understand their structure you can easily use the Parse formula to analyze them in Sourcetable.

HowTo

How to use Joins in Sourcetable

Sourcetable uses an easy interface with recommendations for joins between tables and across integrations to ensure success.

HowTo

How to use Structured Referencing in a Spreadsheet

One of the best ways to make use of all that Sourcetable offers is to use structured referencing when creating your reports and analyzing your data. This allows you to manipulate the data you selected in any data table in your workbook on one

BigData

Product Updates 5/2/2022

Hello Sourcers! Back again with new product feature updates: 1. Google Drive Integration Using the Google Drive integration you can access any CSV, TSV or JSON that you have in your Google Drive folder in Sourcetable. Even large datasets that cannot be manipulated in

BigData

Mason Bottle's Story

Mason Bottle needed a dashboard that synced their Shopify and advertising data automatically inside a spreadsheet. Using Sourcetable, they were able to get the live data for their business across multiple platforms and have one place to access it all.

product update

Product Updates - 4/19/2022

Hello Sourcers! Back again with new product feature updates: 1. Two weeks filter Want to see your payroll data every two weeks? Not a problem now that we have a two week filter and time group by for every two weeks. Simply expand the

shopify

Rachel Pohl Art's Story - a user case study

Rachel Pohl art is a fine art and apparel company that has been growing through social media and email outreach. They create athletic apparel and outdoor gear with designs from

Feature Releases 3/29/22

How-to videos, improved performance and more filters for you data! Hello Sourcers! More new features have been released and are ready to be used: 1. How-to Videos Sourcetable has many features. To get help you get the most out of your workbooks we have

Sourcetable product update

Groupby, Faster Joins, Bulk CSV import, and more Data Integrations! Hello Sourcers! We've been productive over the past couple of weeks. Here’s what we’ve released: 1. Groupby Want to find out your total orders by hour or day of the week? No

Sourcetable

Sourcetable product update — conditional formatting, all-time data sync, and more

Hello Sourcers! Here's what we've been up to over the past couple of weeks: Conditional Formatting, All-time Data Sync, Other Exciting Updates! 1. Conditional Formatting Big fan of cohort analyses? So are we. Now you can make them shine with Sourcetable's color scale and

Sourcetable

New Year, New Sourcetable

Sourcetable Product Updates // Visualizations, Integrations and Invites! // Jan 10, 2022 Hello Sourcers! Welcome to 2022. I hope your holidays season was restful, COVID free, and full of data. We have some exciting updates to share, not least of which is that Sourcetable is now

bizops

Bizops at CoinList, an interview with Regan Bozman.

What are the typical tasks performed by business operations (“bizops”) people? How can someone get into bizops, and what skill sets might they need? These are just some of the questions that Regan Bozman [https://www.linkedin.com/in/reganbozman/], Director of Business Operations

bizops

The role of bizops in start-ups, with Jay Nargundkar

What is bizops? How does it best support the needs of the organization? Sourcetable sat down with Jay Nargundkar to find out.

Why use Sourcetable?

Spreadsheets are one the most used applications on the planet. With over a billion users, it's no surprise that use cases are almost infinitely varied. That said, the bulk of spreadsheet use tends to be split across three spheres: project management, analysis, and as

Sourcetable vs Alternatives (Excel, Sheets and BI tools)

Our mission at Sourcetable is to make data accessible to everyone. To live up to this promise, we're building a next-generation of spreadsheet that is more powerful, more collaborative, and easier to use than alternatives on the market. More powerful than Excel: modeling in

Subscribe to Sourcetable Blog