How to Visualise Data in Tableau
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
How to Create a Financial Model with Debt Financing
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
How to Analyse Data in Microsoft Excel with Power Query and a Pivot Table
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
How to Start a Consulting Business from Scratch
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
Learn How to Become a Self-Taught Data Analyst
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
Your First Steps in Microsoft Excel – Beginner’s Crash Tutorial
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
How to Create a Cash Flow Forecast in Microsoft Excel
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
How to Use Python and Pandas for Data Consolidation and Transformation
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
How to Use Cohort Analysis to Calculate Retention and Churn Rate in Microsoft Excel
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
