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.

Power BI HR Analytics Dashboard project using employee dataset

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

Power BI capstone project analyzing 2 years of retail sales data for a synthetic home-goods company. Answers 10 business questions on sales vs. profit growth, category margins, campaign ROI, regional performance, customer retention, and a discount what-if scenario — with full DAX model, interactive report, and executive PPTX summary.

Read-only Power BI PBIP/PBIR assurance and metadata review tool.

Interactive HR Employee Survey Dashboard built with Microsoft Power BI to analyze employee satisfaction, engagement, and workplace trends.

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

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 | Segmenting customers by Recency, Frequency, and Monetary value to identify high-value customers, evaluate purchasing behavior, and support data-driven marketing strategies.

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.

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

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.

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. 🏦✨