deepa1922 / madhav-store-analysis

𝐀𝐧𝐚𝐥𝐲𝐬𝐞 𝐄-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞 𝐒𝐚𝐥𝐞𝐬 𝐃𝐚𝐭𝐚 𝐂𝐫𝐞𝐚𝐭𝐞𝐝 𝐚𝐧 𝐈𝐧𝐭𝐞𝐫𝐚𝐜𝐭𝐢𝐯𝐞 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐔𝐬𝐢𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈.

MADHAV STORE ANALYSIS

𝐀𝐧𝐚𝐥𝐲𝐬𝐞 𝐄-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞 𝐒𝐚𝐥𝐞𝐬 𝐃𝐚𝐭𝐚 𝐂𝐫𝐞𝐚𝐭𝐞𝐝 𝐚𝐧 𝐈𝐧𝐭𝐞𝐫𝐚𝐜𝐭𝐢𝐯𝐞 𝐃𝐚𝐬𝐡𝐛𝐨𝐚𝐫𝐝 𝐔𝐬𝐢𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈.

📌Objective:

• Assisting Madhav Store in tracking and analyzing online sales across India.

📌Key Steps:

1. Data Import: Imported data from a CSV file.
2. Power Query Editor: Explored options like adding columns, changing data types, and advanced grouping for effective data manipulation.
3. Data and Model View: Used Model View to establish crucial relationships for analysis.
4. Report View: Created a dashboard using various charts, employing time-saving features like text boxes for titles, and utilizing format painter for consistency.

𝐏𝐫𝐨𝐣𝐞𝐜𝐭 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠𝐬:-

• Created an interactive dashboard to track and analyze online sales data.
• Used complex parameters to drill down in worksheets and customization using filters and slicers.
• Created connections, join new tables, and calculations to manipulate data and enable user-driven parameters for visualizations.
• Used different types of customized visualization (bar chart, pie chart, donut chart, clustered bar chart, scatter chart, line chart, area chart, map, slicers, etc).