You will get a fantastic deliverable that drives impact
Project details
• First phase: exploring and cleaning the data
• Second phase: analysis and designing the dashboard
1-First: exploring and cleaning the data
--The dataset of the project has 4 tables( customers data, division, regions, sales data)
-- Sales Table which we can consider to be our main table in the dataset
--Removed Null values
--Merged sum tables and Replace their Values
--Split the Invoice Date to ->Days ,months, Years
--Then I loaded the dataset on power query
2-Second: analysis and designing the dashboard
-I made some measures using DAX
Main insights
-The best customers for my company in the last year “Kellys Gigastore”
-The top sold product is the “mannicotti”
-The net profit for the company was obtained from the “G2” customer type
• Stacked Column Chart
• Second phase: analysis and designing the dashboard
1-First: exploring and cleaning the data
--The dataset of the project has 4 tables( customers data, division, regions, sales data)
-- Sales Table which we can consider to be our main table in the dataset
--Removed Null values
--Merged sum tables and Replace their Values
--Split the Invoice Date to ->Days ,months, Years
--Then I loaded the dataset on power query
2-Second: analysis and designing the dashboard
-I made some measures using DAX
Main insights
-The best customers for my company in the last year “Kellys Gigastore”
-The top sold product is the “mannicotti”
-The net profit for the company was obtained from the “G2” customer type
• Stacked Column Chart
Target Country
Canada, Russia, JapanWhat's included
| Service Tiers |
Starter
$50
|
Standard
$100
|
Advanced
$150
|
|---|---|---|---|
| Delivery Time | 5 days | 5 days | 5 days |
General Project Consulting | - | - | - |
Define Project Goals | - | - | - |
Define Deliverables & KPIs | - | - | - |
Establish Schedule & Milestones | - | - | - |
Risk Management | - | - | - |
Resource Management | - | - | - |
Budget Management | - | - | - |
Project Reports | - | - | - |
Project Diagrams Provided | - | - | - |
About Mona
power bi developer
Mansoura, Egypt - 9:59 am local time
Seeking a challenging position in a competitive technology driven corporation where I can
enhance, promote, and utilize education, experience and personal skills.
Steps for completing your project
After purchasing the project, send requirements so Mona can start the project.
Delivery time starts when Mona receives requirements from you.
Mona works on your project following the steps below.
Revisions may occur after the delivery date.
-First: exploring and cleaning the data
--The dataset of the project has 4 tables( customers data, division, regions, sales data) -- Sales Table which we can consider to be our main table in the dataset --Removed Null values
-Second: analysis and designing the dashboard
I made some measures using DAX