Data Analytics using Power BI
Welcome to my Power BI Portfolio Repository! This repository contains hands-on Power BI projects that demonstrate my skills in Data Cleaning, Data Modeling, DAX, Power Query, Data Visualization, and Business Intelligence.
Each project focuses on solving real-world business problems by transforming raw data into interactive dashboards and meaningful insights.
Repository Structure
DataAnalytics-PowerBI │ ├── Data Cleaning Project ├── Data Modelling Project ├── DAX Project ├── Dashboard Projects ├── Reports ├── Datasets └── README.md
Skills Demonstrated
Microsoft Power BI
Power Query (ETL)
Data Cleaning & Transformation
Data Modeling
Star Schema Design
DAX (Data Analysis Expressions)
Time Intelligence
KPI Development
Interactive Dashboard Design
Business Intelligence
Data Visualization
Projects Included
Data Cleaning Project
Objective
Prepare raw datasets for reporting by performing data transformation and preprocessing using Power Query.
Tasks Performed
Removed duplicates
Handled missing values
Changed data types
Renamed columns
Split and merged columns
Created calculated columns
Standardized data formats
Skills Used
Power Query
ETL
Data Transformation
Data Modelling Project
Objective
Design an optimized Power BI data model using Fact and Dimension tables.
Highlights
Created Star Schema
Built relationships between tables
Configured relationship cardinality
Created Date Dimension
Managed filter propagation
Improved report performance
Tables Used
Fact Sales
Fact Sales Targets
Fact Inventory
Fact Campaign Spend
Fact Promotion Coverage
Dim Date
Dim Products
Dim Customers
Dim Campaign
Dim Geography
Skills Used
Data Modeling
Relationship Management
Star Schema
Dimension Modeling
DAX Project
Objective
Create reusable measures and calculations for business reporting.
DAX Concepts
SUM, CALCULATE, FILTER, ALL, DIVIDE, IF, SWITCH, RELATED, Time Intelligence, Variables (VAR), Measures Created, Total Sales, Target Revenue, Sales Variance, Profit, Average Sales, Running Total, Year-to-Date (YTD), Month-to-Date (MTD), Quarter-to-Date (QTD).
Dashboard Features
KPI Cards, Interactive Filters, Slicers, Matrix Visuals, Trend Analysis, Bar Charts, Pie Charts, Line Charts, Drill-through, Tooltips, Conditional Formatting.
Learning Outcomes
Through these projects, I gained practical experience in:
Building scalable Power BI data models
Writing efficient DAX measures
Creating interactive business dashboards
Implementing Power Query transformations
Designing professional reports
Applying Business Intelligence best practices
Tools & Technologies
| Tool | Purpose |
|---|---|
| Power BI Desktop | Dashboard Development |
| Power Query | Data Cleaning & ETL |
| DAX | Business Calculations |
| Excel | Data Source |
| SQL | Data Preparation |
Sample Screens
Data Model, DAX Measures, Dashboard, Power Query Transformations.
Author: Mounish Kumar
Aspiring Data Analyst
Power BI | SQL | Python | Excel
Connect with Me
GitHub: https://github.com/MounishKumar228
LinkedIn: https://www.linkedin.com/in/mounish-kumar-685b47301/