Project on creating sales insight of the Atliq Hardware Using Mysql, MS PowerBI, Data Wrangling
Mysql database has all sales transactions, customers, products and markets information. I have analyse this database and than hook it up with PowerBI Desktop. In PowerBI I perform ETL and data cleaning operations to make it ready so that we can build our dashboard. Then build a powerful dashboard that can help us generate sales insights on Atliq hardware business. It Contains several fields like Total Revenue, Total Sales Quantity, Top 5 customers, Top 5 products, Customer Type (Brick&Mortar or E-commerce), Graph w.r.t year also Year and monthly wise slicer is used to get full insight.
Sales Overview
Sales 2020
Sales 2019
Sales 2018
