power-query-editor

OBJECTIVE Ecommerce or Retail Store wants us to help them create a dashboard to track and analyze their online sales across India to improve customer buy rate and sales.

End-to-end marketing analytics: SQL CTEs, Power BI dashboard, Python sentiment analysis — Orange DC Hackathon Top 3

This project showcases a Power BI dashboard created to analyze employee attendance and leaves over a three-month period. The data was sourced from Excel datasets available on the Codebasics website.

Enterprise Power BI Healthcare Analytics Dashboard showcasing Executive Reporting, DAX, Power Query, Star Schema Data Modeling, KPI Reporting, and Interactive Business Intelligence.

Analyzing the Patients records, Hospital operations and insurance details of a Massachusetts General Hospital.

Interactive Power BI dashboard for analyzing hospital readmissions, identifying high-risk patients, tracking healthcare KPIs, and exploring demographic, diagnosis, and treatment trends using DAX, Power Query, SQL, and advanced data visualization techniques.

This project is a Banking and Financial Transaction Analysis Dashboard created using Power BI. The primary goal is to provide actionable insights into customer demographics, branch performance, and financial transactions for effective decision-making.

An interactive HR Analytics Dashboard built using Power BI Desktop, analyzing employee attrition, salary, department, and demographics from a dataset of 1,480 employees. Published on Power BI Service.

Supply Chain Risk Analysis Dashboard built in Power BI using DAX, Power Query, Star Schema modeling, and Row-Level Security (RLS).

This project presents an interactive Power BI dashboard built using retail sales data from January 2020 to Decmber 2023. The analysis uncovers key trends in sales performance, product categories, store-wise comparisons, and customer purchasing behavior.

RFM Customer Segmentation Analysis | Excel + Power Query

End-to-end Power BI data analysis project for an EdTech startup, focusing on KPI tracking, revenue insights, and business intelligence dashboarding.

Power BI HR Analytics Dashboard project using employee dataset

Analyzed a year’s worth of pizza sales to understand our customers better. Using Excel Power Query, I cleaned and transformed the data without writing any formulas.

Interactive Power BI dashboard providing HR analytics and workforce insights through dynamic visualizations, KPIs, and business intelligence reporting.

This project analyzes bird-aircraft strike data from 2000 to 2011 using MySQL database as the data source and Microsoft Power BI. The interactive dashboard allows for exploration of trends and insights to improve aviation safety.

The 💼 Bank Loan Report Dashboard is a fully automated Excel 📊 dashboard designed to analyze and visualize key metrics of a bank's loan portfolio. It provides 📈 insights into loan applications, funded amounts, repayments, interest rates, and borrower profiles, helping banks make data-driven decisions with ease. 🏦✨

Power BI Healthcare Dashboard | Patient Insights & Billing Trends An interactive Power BI dashboard analyzing patient demographics, medical conditions, billing data, and insurance patterns using real-world healthcare records from Onyx Data’s Power BI Challenge.

This project delivers a complete data analysis, KPI computation, and business intelligence dashboard for Blinkit using SQL, Python, and Power BI. It provides insights into sales performance, customer ratings, outlet characteristics, and inventory distribution — aligned fully with the business requirements document.