Global Superstore- Analysis.
Jay Mistry
Analytical Professional | Transforming Data into Actionable Insights for Optimal Operations
Here is my first Power Bi dashboard,
I have learnt basic and some advance features of power bi with the help of Deeksha Anand 's Visulise Data with PowerBI and number of videos related to design and filter.
I have chosen practice dataset of Global superstore for analysis and visualization.
The aim is to boost store's sales with help of previous years performance.
Dataset has 3 different tables named orders, returns and customer names.
I used orders table for most of my analysis as it has 19 columns suggesting sales, profit, dates, customer background and product details.
Dashboard features various basic visuals and some advanced features offered by PowerBi to convey message.
following DAX functions are applied and learnt by me in this project to create calculated columns and measures
- Average
- SUM
- SUMX
- DISTINCTCOUNT
- COUNT
- ISBLANK
- ISNUMBER
- ISTEXT
I also took care of Z pattern, starting from most powerful KPI's , Brief details to minute ones.
Software Engineer | C++ | Mobile App Developer | HTML | CSS | OOP | DSA | Database Management | @SWE fellow at headstarter AI
1 å¹´Awesome ??
Business Analyst | Stakeholder Communication | Project co-ordination | Requirements Gathering | Requirements Elicitation | Wireframing | SDLC | Agile methodologies
1 å¹´Great dashboard Jay Mistry
Product @IndiaLends | Data | Analytics | FinTech
1 å¹´Looks clean and professional Jay ??