PivotTables have been on my mind lately (you’ll see why in a couple weeks). An issue you may face with PivotTables is how to change the source data for a PivotTable you’ve meticulously set up. You have some new data being added to your source data, and you have to change the PivotTable source data […]
When you think of sports and data, you may think about all the data collect on player performance and game stats. There’s another world of sports data that is usually overlooked: the fans. In this episode, I speak with Caiti Donovan, the VP of Data & Insights at Sports Innovation Lab, a sports market research firm. […]
Transforming Netlify’s data pipeline one SQL statement at a time. Lauren Adabie started her career analyzing data and answering questions about the data at Zynga. As a data analyst at Netlify, she’s doing more than just exploratory analysis. She’s also helping build out Netlify’s revenue data pipeline; something she’s never done before. We discuss how […]
Numerous studies claim that data scientists spend too much time cleaning and preparing data (although this article claims it is a bullshit measure). I agree with some points in that article in that you should get your hands dirty with cleaning data to understand what eventually goes into the analysis. You may already be cleaning […]
This episode is all about data storytelling at a “traditional” enterprise company like LinkedIn and also at a major news publication. Janie Ho is a former global account analyst at LinkedIn in NYC where she facilitated data-driven presentations to close revenue deals for LinkedIn’s top global strategic accounts. Currently, she is a senior editor in […]
Oz is one of the best creators of Excel content I know with his Excel on Fire YouTube channel. Unlike traditional “how-to” videos, his videos blend education with entertainment making the learning process feel like binging your favorite Netflix show. Oz and I met on Google+ way back in the day and in person at […]
It’s a story we’ve all heard before. You’re working a full-time job, and you have more fun doing your side hustle than your 9 to 5. This is what happened to John Michaloudis. He was a financial controller at General Electric but found his passion sharing Excel tips and tricks on an internal GE newsletter […]
The NY Enterprise Tech meetup was one of my favorite events to attend in-person prior to the pandemic. While the meetup is now all virtual, the speakers they bring in continue to be top-notch–particularly in the data space. The host of the meetup is Work-Bench, a VC focused on enterprise software companies. Priyanka Somrah is […]
Data warehouses have come a long way since the days of Oracle and Microstrategy. A data warehouse should be able to grow and expand with the business it supports. At Canva, the data amount of data coming into the data warehouse has exploded in the last few years given the platform’s surging usage. In this […]
One of the best feelings is knowing you’ve streamlined and automated a report such that your colleague doesn’t have to spend hours creating the report every week. Whether you automate the report through a bunch of Excel formulas or setting up some sort of data pipeline, analysts are always thinking about driving internal efficiencies. This […]
Excel for the Real World I studentVery nice course! Everything has been explained super clearly and I learned some very handy things.
Clean Gray Cover for Mac Excel $24.99 
Emerald Green Cover for Mac Excel $24.99 
Cool Blue Cover for Mac Excel $24.99 
