Skip to content

π€π§πšπ₯𝐲𝐬𝐞 𝐄-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞 π’πšπ₯𝐞𝐬 πƒπšπ­πš π‚π«πžπšπ­πžπ 𝐚𝐧 𝐈𝐧𝐭𝐞𝐫𝐚𝐜𝐭𝐒𝐯𝐞 πƒπšπ¬π‘π›π¨πšπ«π 𝐔𝐬𝐒𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈.

Notifications You must be signed in to change notification settings

deepa1922/Madhav-Store-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

21 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

MADHAV STORE ANALYSIS

π€π§πšπ₯𝐲𝐬𝐞 𝐄-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞 π’πšπ₯𝐞𝐬 πƒπšπ­πš π‚π«πžπšπ­πžπ 𝐚𝐧 𝐈𝐧𝐭𝐞𝐫𝐚𝐜𝐭𝐒𝐯𝐞 πƒπšπ¬π‘π›π¨πšπ«π 𝐔𝐬𝐒𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈.

πŸ“ŒObjective:

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

πŸ“Œ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).

About

π€π§πšπ₯𝐲𝐬𝐞 𝐄-𝐜𝐨𝐦𝐦𝐞𝐫𝐜𝐞 π’πšπ₯𝐞𝐬 πƒπšπ­πš π‚π«πžπšπ­πžπ 𝐚𝐧 𝐈𝐧𝐭𝐞𝐫𝐚𝐜𝐭𝐒𝐯𝐞 πƒπšπ¬π‘π›π¨πšπ«π 𝐔𝐬𝐒𝐧𝐠 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published