In this step-by-step tutorial, you’ll learn how to build a Subscription Model Forecast with Churn Calculations using Microsoft Excel. We’ll start by forecasting customer acquisitionRead More »How to Create a Subscription Model Forecast with Churn Calculations
This tutorial will introduce you to Tableau and data visualisation. It will use an example of data downloaded from Destasis, Germany’s Federal Statistical Office, toRead More »How to Visualise Data in Tableau
Building a Financial Model with Debt Financing in Microsoft Excel is a vital skill for forecasting cash flows, structuring funding needs, and analyzing returns. InRead More »How to Create a Financial Model with Debt Financing
This step-by-step tutorial will show you how to analyse data and Excel spreadsheets using Power Query and Pivot Tables. It will use an example ofRead More »How to Analyse Data in Microsoft Excel with Power Query and a Pivot Table
This business planning tutorial will help you start your consulting company and execute your business plan. Each section will highlight the risks you should addressRead More »How to Start a Consulting Business from Scratch
In this blog, I share steps I have taken to learn data analysis, including the books and resources that helped me along the way. FindRead More »Learn How to Become a Self-Taught Data Analyst
This step-by-step tutorial will give you a quick overview of Microsoft Excel with examples of how to use basic calculations, formulas, and Pivot Tables. DownloadRead More »Your First Steps in Microsoft Excel – Beginner’s Crash Tutorial
Building a solid Cash Flow Forecast is vital in business planning, especially when presenting your model to investors or managing funding needs over time. InRead More »How to Create a Cash Flow Forecast in Microsoft Excel
Python scripts can help you automate and improve the efficiency of your data analytics processes. Even a basic Python command will accelerate your work withRead More »How to Use Python and Pandas for Data Consolidation and Transformation
Your business data contains valuable information about your customers, operations, costs and finances. Using cohort analysis, a type of behavioural data analytics, you can digRead More »How to Use Cohort Analysis to Calculate Retention and Churn Rate in Microsoft Excel
