PinnedKathryn DeanLittle data, big analyticsA framework to bring big data maturity to your spreadsheets. For anyone wanting to improve their data management & better answer questions.3 min read·Feb 13, 2024----
Kathryn DeanMy favorite spreadsheet formulas & formula combosThere are several formulas that I find myself returning to. They can be used in both Google Sheets & Excel!5 min read·Mar 30, 2024----
Kathryn DeanUnpivoting data in Excel & Google Sheets“Unpivoting” is the opposite of “pivoting” data. Data typically needs to be in an unpivoted/flattened format for analysis — learn how here!6 min read·Mar 24, 2024----
Kathryn DeanAn intro to PowerQueryIt is my great honor to introduce you to PowerQuery — one of my favorite tools for automating data work. It’s built right into Excel…12 min read·Mar 24, 2024----
Kathryn DeanUsing AI for data prep & analysisBenefits of using AI, like Florence GPT, for spreadsheet data management & analysis along with practical prompts to use in your analysis!5 min read·Mar 10, 2024----
Kathryn DeanThe essentials of data cleaningThis article is for anyone doing data work and analytics in a spreadsheet, who’s trying to learn more about how to clean their data or what…4 min read·Feb 15, 2024----
Kathryn DeanStructuring data in a spreadsheetThis article is for anyone doing data work and analytics in a spreadsheet, who’s trying to learn more about how to structure their data or…7 min read·Feb 12, 2024----