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 Analyse Data in 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 Excel with Power Query and a Pivot Table
Learn How to Become a Self-Taught Data Analyst
In this blog, I share steps I have taken to learn data analysis, including the list of books and resources that helped me along theRead More »Learn How to Become a Self-Taught Data Analyst
Your First Steps in Excel – Beginner’s Crash Tutorial
This step-by-step tutorial will give you a quick overview of Excel with examples of how to use basic calculations, formulas, and Pivot Tables. Download aRead More »Your First Steps in Excel – Beginner’s Crash Tutorial
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 Excel
Your business data contains a lot of valuable information about your customers, operations, costs and finances. And by using cohort analysis, a type of behaviouralRead More »How to Use Cohort Analysis to Calculate Retention and Churn Rate in Excel