Eoin McMillan - Sourcetable Blog

Sourcetable in 2024.

Hello Sourcers! 2023 was a big year for Sourcetable. We built graphs, we built charts, we built pivots, conditional formatting, joins, a data library, and endless integrations to help people

funding

Sourcetable's Journey to Revolutionize Spreadsheets Just Got $4.25m Stronger!

Today, I'm excited to share that we've secured a $3m seed round led by Michael Berolzheimer at Bee Partners, in addition to $1.25m pre-seed funding from Lee Jacobs (Long Journey Ventures), Melody Koh (NextView Ventures) and Paul Bricault (AmplifyLA).

Company Size and the Bizops role with Josh Schenker

How does the size of a company change the Business Operation (“bizops”) role? Josh Schenker, VP of Finance and Strategy at Clean.io gives us insight into this question in our most recent interview. Here are the highlights: About Clean.io Clean.io is

Bizops popularity, a discussion with Olivia Man at Loan Snap

Why are Business Operations (“BizOps”) people so popular in today’s market? What can they do for a company? How can someone get into BizOps, and what skills might they need? These are just some of the questions that Olivia Man, Chief of Financial

Bizops at Lemonade with Eliot Jenkins

Where does Business Operations (“bizops”) stand today and where is it heading? What can it do for a company? And what’s the value it could bring for yours? These are some of the questions that Eliot Jenkins, Head of Business Operations at Lemonade

How to choose a Business Intelligence tool.

Business Intelligence tools are software applications that take in large amounts of data and make it available for analysis purposes. If you're reading this post, there's a good chance that your business is growing, your current reporting systems are getting

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

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

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:

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.

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

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.

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.

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

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

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,

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

Subscribe to Sourcetable Blog