After cleaning the dataset, I moved into analysis and dashboarding using Power BI.
I focused on answering simple business questions.
key KPIs.
β’ Total Orders
β’ Total Quantity
β’ Total Revenue
β’ Total Profit
This gives a quick glance of how the business is doing.
Kicked things off today and am excited to share my progress.
So far, Iβve:
1οΈβ£ Loaded the dataset into Excel
2οΈβ£ Created a working copy to preserve the original data
3οΈβ£ Converted the data into a table for easier handling
4οΈβ£ Removed duplicates and cleaned blank spaces. ππ
To make the dashboard interactive, I added slicers for:
β’ Year
β’ Month
β’ Region
β’ Ship Mode
This project helped me practice:
β’ Data cleaning
β’ DAX measures
β’ Dashboard design
β’ Turning data into insights
Kicked things off today and am excited to share my progress.
So far, Iβve:
1οΈβ£ Loaded the dataset into Excel
2οΈβ£ Created a working copy to preserve the original data
3οΈβ£ Converted the data into a table for easier handling
4οΈβ£ Removed duplicates and cleaned blank spaces. ππ
I want to carry out an end to end sales data analysis project using Excel for data cleaning and Power BI for visualization.
Someone said the fastest way to grow is by building real projects, so Iβm committing to this one to measure my progress, identify my strengths, and π
As you don blow now, no forget that woman wey dey always allow you take Garri and groundnut on credit every day when hunger dey wire you. When times hard, na she stand by you, so make sure say as money dey enter your hand now, you remember her. No be everybody go show you love when you never get anything. The people wey help you when you dey struggle, na dem be your real ones. So as you dey chop life now, make sure say you carry dem along too.