Uncovering Insights and Unleashing the Power of Data Analytics using MS Excel, SQL and PowerBI
Python loading...
Based on a Case Study of an IT Hardware Sales company with a healthy market share of the ICT industry in India.
The Sales Director wanted a dynamic dashboard to be able to track sales revenue in all regions. I used MySQL for exploratory data analysis (EDA) and PowerBI for data cleaning, wrangling/tranformation and visualization.
Real life dataset taken from a survey conducted online to gain various insights into the "Data" field from experts, students as well as those making a switch or simply interested.
This is an Excel project where I did a walkthrough of the data cleaning process, created pivot tables and finished this off with an interactive dashboard with slicers for filtering purposes.