In tihs project I developed a dashbord that include about all aspect of business. The main speciality of this dashbord is that in this dashbord you can analyze every feature of dataset that will help to increase sales, increase profit and decrease loss.
Steps
- Load and transform data
- Data Cleaning and preprocessing in in power query editor
- building relationship within sheets in data modeling
- developing various visualiztions
- Developed an intreactive BI report.
Insights
- promte tablet, copiers, bookcases and appliances sub category to increase sales.
- shiping cost should lower then 57.78 will increase sales
- there are some loss making products such as Cubify cubeX, Lexmark MX611dhe Printer, Motorola Smart phone and Bevis Computer Table etc we should remove these products or work on it to make profitable.