SALES ANALYSIS USING EXCEL & ACCESS

• Description: An interactive dashboard showing Sales Analysis
• Tools Used: Excel
• Data Source: Access Files
• Story:
1- Getting data from Access files
2- Using power pivot:
a. Creating tables relationships
b. Calculations with DAX language
i. Revenue
ii. COGS
iii. Profit
iv. Profit Margin
v. Working Days
vi. Avg Profit/Day
3- Pivot table for each data set
4- Pivot charts
5- Designing Interactive Dashboard with filters displays Sales Analysis