MariamRaafatMohamed/ALX-Data-Visualization-Sprint4_Power-BI-Reports

All Power BI projects from ALX Data Visualization Sprint (Maji Ndogo case study) # ALX Data Visualization Sprint – Power BI Projects This repository contains my complete work from the **Visualizing Data** sprint in the ALX Data Analytics program. The sprint focuses on storytelling with data, building impactful visuals, and designing dashboards using **Power BI** — all within the fictional but data-rich world of **Maji Ndogo**. --- ## Sprint Learning Objectives Throughout this sprint, I learned to: - Create meaningful charts (bar, line, scatter, maps) - Apply storytelling principles using data - Transform, clean, and reshape data in Power BI - Write calculated columns and measures using **DAX** - Model data relationships (1:1, 1:many, cardinality) - Use **GeoJSON** maps for geographical visuals - Conduct exploratory analysis and communicate insights - Build dynamic reports with slicers, bookmarks, drilldowns --- ## Project Structure Each part of the sprint builds on the previous one, adding complexity and new Power BI skills. | Part | Focus | Repo | |------|-------|------| | **Part 1** | Water access dashboard, visuals, and formatting | 🔗 View Part 1 | | **Part 2** | Data modeling, Power Query, and relationships | 🔗 View Part 2 | | **Part 3** | Advanced formatting, conditional visuals, interactivity | 🔗 View Part 3 | | **Part 4** | Transparency & storytelling dashboards (final project) | Coming soon | --- ## Datasets & Files Used | File | Description | |------|-------------| | `md_summary.csv` | Core dataset with water access info | | `.pbix` files | Power BI project files for each part | | `map.geojson` | Custom map for Maji Ndogo provinces | | PDF exports | Dashboards exported to PDF for presentation | | Infographics | Visual summaries for sharing insights | --- ## Tools & Technologies - **Power BI Desktop** - Power Query Editor - DAX (Calculated Columns & Measures) - GeoJSON mapping - CSV files - Bookmarking, drill-through, and slicers - Dashboard design principles --- ## Key Concepts Learned - **Visual storytelling** …