Welcome to my Power BI learning repository!
This repository contains all the Power BI assignments and practice files that I completed while learning Microsoft Power BI from the basics to intermediate and advanced concepts. Each .pbix file represents a separate session focused on a specific topic, helping me build practical skills in data visualization, data transformation, data modeling, DAX, and dashboard design.
| Session | Topic |
|---|---|
| Session 1 | Power BI Overview |
| Session 2 | Power BI Desktop Interface |
| Session 3 | Connecting to Data Sources |
| Session 4 | Power Query Editor (PQE) Basics |
| Session 5 | Column Operations |
| Session 6 | Data Transformations & Unpivot Columns |
| Session 7 | Merge Queries |
| Session 8 | Modeling Fundamentals |
| Session 9 | Advanced Modeling & Cross Filtering |
| Session 10 | Basic Visuals |
| Session 11 | Intermediate Visuals |
| Session 12 | Advanced Visuals |
| Session 13 | Visual Features & Importing Custom Visuals |
| Session 14 | DAX Basics |
| Session 15 | Aggregate & Logical Functions |
| Session 16 | Date & Time Functions |
| Session 17 | Filter & Iterator Functions |
| Session 18 | Filters, Slicers & Buttons |
| Session 19 | Drill-Through Pages |
| Session 20 | Report Design & Branding |
- Installing and setting up Power BI Desktop
- Understanding the Power BI interface
- Connecting to Excel, CSV, and other data sources
- Importing and managing datasets
Worked extensively with Power Query Editor to prepare data before analysis.
Topics covered include:
- Removing columns
- Removing rows
- Removing duplicates
- Replacing values
- Replacing errors
- Splitting columns
- Merging columns
- Changing data types
- Fill Down operation
- Unpivot Columns
- Query transformations
- Cleaning and shaping datasets
Learned how to create efficient data models by understanding:
- Fact Tables
- Dimension Tables
- Relationships
- Cardinality
- Cross Filter Direction
- Star Schema concepts
Created multiple report visuals including:
- Tables
- Matrix
- Bar Charts
- Column Charts
- Line Charts
- Pie Charts
- KPI Cards
- Cards
- Slicers
- Buttons
- Drill-through Pages
- Custom Visuals
Practiced writing DAX formulas using:
- Calculated Columns
- Measures
- SUM
- AVERAGE
- COUNT
- DISTINCTCOUNT
- MAX
- MIN
- IF
- SWITCH
- AND
- OR
- YEAR
- MONTH
- DAY
- TODAY
- NOW
- FILTER
- CALCULATE
- ALL
- SUMX
- AVERAGEX
Designed interactive dashboards by learning:
- Applying custom themes
- Branding reports
- Using gridlines
- Aligning visuals
- Organizing report layouts
- Adding logos
- Creating professional dashboards
Implemented Row Level Security (RLS) to restrict report access based on user roles.
Throughout these assignments, I worked with several sample datasets including:
- IPL Match Data
- Flipkart Sales Data
- Swiggy Orders
- Zomato Restaurants
- Paytm Transactions
- Movie Ticket Booking Data
These datasets were used to practice data cleaning, modeling, dashboard development, and DAX calculations.
By completing these assignments, I gained practical experience in:
- Importing and transforming data
- Building efficient data models
- Writing DAX calculations
- Designing interactive dashboards
- Creating business reports
- Applying best practices for report design
- Implementing Row Level Security
- Building clean and professional Power BI reports
- Microsoft Power BI Desktop
- Power Query Editor
- DAX (Data Analysis Expressions)
- Microsoft Excel
- CSV Files
Shivam Thakur
Aspiring Data Analyst | Python Learner | Exploring Data Analytics & AI
- 💼 LinkedIn: https://www.linkedin.com/in/shivam-thakur-55b167406/
- 📧 Email: dataanalyst.shivamthakur@gmail.com
This repository is part of my hands-on learning journey in Power BI. The focus is on understanding core concepts through practical assignments and applying them to build interactive reports and dashboards. As I continue learning, I plan to expand this repository with more advanced topics, real-world datasets, and end-to-end business intelligence projects.
⭐ Thank you for visiting my repository! Feel free to explore the .pbix files to see my progress and learning journey in Power BI.