Power BI E-Commerce Analysis / Retail Analysis / POS Analysis
Originally published: 31/01/2022 15:27
Publication number: ELQ-33042-1
View all versions & Certificate
certified

Power BI E-Commerce Analysis / Retail Analysis / POS Analysis

Uploaded excel data into the Power BI file. Then a bit of transformation in the power query. Then created DAX measures for all define KPIs. Then created visuals

Description
This is the Power BI E-Commerce Analysis / Retail Analysis / POS Analysis. Report.
Pages:
In this report, we have the following 3 pages.
1. Customer Analysis
2. Order Analysis
3. Product Analysis
4.Sales Analysis
5.Summary Analysis

KPIs:

In this report, I have created the following KPIs.
1.Total Sales
2.# of customer
3.# of Orders
4.Total Quantity
5.# of Products

Process:
In which the data source is an Excel file. First I have uploaded excel data into the Power BI file.
Then I did a little bit of transformation in the power query. Then created DAX measures for all above define KPIs. Then created visuals as shown in the attached images.

Modification if Needed :

If you want any modification in visualization, you can connect with me through Eloquens or WhatsApp here is my WhatsApp number +92 3000945833.

Deliverable :
I will provide you Excel dataset file and a power bi file in which all KPIs and visualization are present.

Usage:
You can use this report for learning purposes or entering into a competition or commercial use.
if you want to create any other domain reports then you can also let me know.
God Bless you.
Thanks and Regards
Muhammad Umair Shahid

This Best Practice includes
1 Excel file , pbix file

Muhammad Umair Shahid offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

You can use this report for learning purposes or entering into a competition or commercial use.


5.0 / 5 (4 votes)

please wait...