📊 Power BI for Data Analytics -

📌 Overview

This repository represents my journey in learning and applying Data Analytics using Microsoft Power BI. It covers the complete workflow followed by data analysts — from raw data to actionable insights through interactive dashboards.

I focused on building practical, real-world skills by working with datasets, performing data transformations, and creating visually compelling reports. insights

Key Concepts Covered 🧠

🔰 Data Analytics Fundamentals

I started by understanding how data analytics works in real-world scenarios, including:

1. Types of data analysis
2. Role of a data analyst
3. Importance of data-driven decision-making

Data Cleaning & Transformation 🧹

I used Power Query to:

• Handle missing and inconsistent data
• Change data types
• Remove duplicates
• Perform transformations for better usability

➡️ This step helped me understand that data cleaning is one of the most critical parts of analytics.

🧩 Data Modeling

I created structured data models by:

1. Establishing relationships between tables
2. Understanding fact and dimension tables
3. Applying star schema design principles

➡️ This improved both performance and accuracy of my reports.

📐 DAX (Data Analysis Expressions)

I worked with DAX to:

• Create calculated columns and measures
• Perform aggregations and filtering
• Apply basic time intelligence

➡️ This enabled deeper analysis beyond simple visuals.

📊 Data Visualization

I designed dashboards using:

1. Bar charts, line charts, pie charts
2. KPI cards and summary visuals
3. Filters and slicers for interactivity

➡️ I focused on data storytelling to make insights clear and impactful.

📈 Dashboard Development

I built complete dashboards that:

• Combine multiple visuals
• Allow user interaction
• Highlight key insights and trends

➡️ These dashboards simulate real-world business reporting.

🛠️ Tools & Technologies

• Microsoft Power BI Desktop
• Power Query (ETL)
• DAX (Data Analysis Expressions)
• Data Modeling Techniques

🎯 Projects

• Project 1: Data Jobs Dashboard - Comprehensive two-page dashboard

  • Features: Market overview, drill-through analysis, interactive filtering
  • 📊 Dashboard File

• Project 2: Data Jobs Dashboard 2.0 - Single-page focused dashboard

  • Features: Streamlined insights, advanced DAX, star schema modeling
  • 📊 Dashboard File

📊 Data Sources

• 📁 monthly_files/ - Individual monthly Excel files
• 📁 star_schema_files/ - Normalized star schema format

How to Run Power BI Files

📋 Prerequisites

• Power BI Desktop (Free) - Download from Microsoft Power BI
• Power BI Service Account (Free tier available) - For publishing and sharing dashboards
• Microsoft Excel (Optional) - For viewing data files

🚀 Getting Started

1. Download Power BI Desktop

• Visit Microsoft Power BI Desktop download page
• Download and install the latest version (free)
• Sign in with your Microsoft account when prompted

2. Open Course Files

1. Navigate to the desired module folder (e.g., 1_Grand_Tour/, 2_Visualizations/, etc.)
2. Double-click any .pbix file to open it in Power BI Desktop
3. If prompted, click "Enable Content" to allow data connections

3. Working with Data Files

• CSV Files: Can be opened directly in Power BI Desktop using "Get Data" → "Text/CSV"
• Excel Files: Use "Get Data" → "Excel Workbook" to import
• Monthly Files: Import individual files or use folder import for batch processing

🔧 Troubleshooting

Common Issues

• "Enable Content" Dialog: Always click "Enable Content" when opening .pbix files
• Data Source Errors: If data connections fail, check the file paths in Power Query
• Missing Visuals: Ensure all required data fields are loaded and relationships are established

Data Connection Issues

• If you encounter data source errors:
  1. Go to Home → Transform Data → Data Source Settings
  2. Update the file paths to match your local directory structure
  3. Click "Change Source" and navigate to the correct data files

Performance Tips

• Large Datasets: Use filters in Power Query to reduce data size
• Refresh Issues: Close and reopen Power BI Desktop if refresh fails
• Memory: Close other applications if Power BI runs slowly

💡 Pro Tips

• Save Frequently: Power BI Desktop files can be large - save often
• Use Bookmarks: Create bookmarks to save different views of your data
• Test Interactions: Always test slicers, filters, and drill-through features
• Performance: Use measures instead of calculated columns when possible
• Documentation: Use the "About" section in your reports to document data sources and methodology

Found a Typo? Want to Contribute?

• If you find an error in this repo, please feel free to make a pull request by:
  • Forking the repo
  • Making any changes
  • Submitting a pull request