ChallengeJP Blog

tableau data visualisation how to tutorial

How to Visualise Data in Tableau

April 21, 2021

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, to visualise Germany’s 2020 International Trading…

How to Analyse Data in Excel with Power Query and a Pivot Table

February 26, 2021

Jacek Polewski

Blog

Data Analytics, Excel Tutorial

No Comments

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 of a data set to examine…

Learn How to Become a Self-Taught Data Analyst

December 10, 2020

Jacek Polewski

Blog

Business Insights, Data Analytics

In this blog, I share steps I have taken to learn data analysis, including the list of books and resources that helped me along the way. Find out about why…

Your First Steps in Excel – Beginner’s Crash Tutorial

November 15, 2020

Jacek Polewski

Blog

Data Analytics, Excel Tutorial

No Comments

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 a sample Excel file for practical…

How to Use Python and Pandas for Data Consolidation and Transformation

August 27, 2020

Jacek Polewski

Blog

Data Analytics, Python Tutorial

No Comments

Python scripts can help you automate and improve the efficiency of your data analytics processes. Even a basic Python command will accelerate your work with data and Excel spreadsheets. In…

How to Use Cohort Analysis to Calculate Retention and Churn Rate in Excel

June 15, 2020

Jacek Polewski

Blog

Business Insights, Data Analytics

Your business data contains a lot of valuable information about your customers, operations, costs and finances. And by using cohort analysis, a type of behavioural data analytics, you can dig…

ChallengeJP Blog

How to Visualise Data in Tableau

How to Analyse Data in Excel with Power Query and a Pivot Table

Learn How to Become a Self-Taught Data Analyst

Your First Steps in Excel – Beginner’s Crash Tutorial

How to Use Python and Pandas for Data Consolidation and Transformation

How to Use Cohort Analysis to Calculate Retention and Churn Rate in Excel

Useful Links

My Services

How I Can Help

Contact Details

Book A Free Consultation