PowerBI Project using DAX, SQL and PowerBI Service

AtliQ Grand Data Analysis (DAX & PowerBI)

Developed a comprehensive analysis of AtliQ Grand Hotel utilizing PowerBI and Excel

Employed 25+ DAX measures to design and implement interactive dashboards for visual data representation in PowerBI

Leveraged Power Query for efficient data wrangling and transformation processes.

Created key performance Indicators (KPI's) with cards to highlight critical aspects of growth analysis within the sector and drill throughs for exploratory data analysis.

Amazon Sales Data Analysis (SQL & Power BI)

Designed and executed 28+ complex SQL queries including JOINS, window functions and subqueries to extract actionable business insights

Analyzed dataset of sales using Excel, SQL and developed interactive dashboard with 5+ visualizations using Power BI analyzing revenue trends, product performance etc.