Practical Excel & Power BI Learning Resources

In this tutorial, I’ll show you how to build an interactive Excel sales dashboard using PivotTables, PivotCharts, slicers, and timelines. We’ll start from raw sales data, review the dataset, plan what the dashboard should show, create the supporting PivotTables, and then turn everything into a clean dashboard. You can download the practice file below and follow along with the video. Download the practice file: Watch the full tutorial: Dashboard scenario In this example, we ar

This project is to create a dashboard in Excel to analyse Netflix Userbase. In this blog post, I'll show you how I did it. This is the dashboard that I have created in Excel as shown below: The dataset I used is from Kaggle: https://www.kaggle.com/datasets/arnavsmayan/netflix-userbase-dataset It's important to read the dataset description to understand what's the data is about so that it will be easier when cleaning and analysing the dataset. Step 1 : Data Cleaning When clean