This repository contains my project work in Microsoft Excel.
About Performance Dashboard
This dashboard helps managers and business leaders in tracking key KPIs or metrics and take a decision based on it.
Objective
A Company wants to design a Performance dashboard to analyze the sales,employee sales performance report,region wise sales and revenue report.
Dataset Description
Within this file you will find the following fields:
| Field | Description |
|---|---|
| Order ID | Product Order ID |
| Date | Order Date |
| Customer ID | Unique Customer ID |
| Customer Name | Name of the customer |
| Sales Person | Sales person name |
| Region | Region Name |
| Item | Item detail |
| Price | Price of the product |
| Quantity | Quantity sold |
| Revenue | Total Revenue Generated |
Create a chart to analyze total sales trend month wise in company.
Prepare a table of Sales by region, named it as ‘Sales by Region’.
Prepare a table of Sales by Employee,named as 'Sales by Employee'.
Prepare a table of Item share.
Prepare the table of Customer revenue.
Create slicers for connecting the different charts.
Create a dashboard.
Basic Knowledge of Pivot Tables,Basic VBA,Charts and formatting in Excel
I have utilized following items in building sales dashboard which analyzes data by different aspects.
Pivot Tables
Different Chart
Slicers
I'm an aspiring Data Analyst...
