Global Internet Access & Infrastructure Dashboard

About the Project

This repository contains an interactive Power BI dashboard designed to analyze global internet accessibility, infrastructure growth, and their correlations with economic and demographic factors. The project transforms raw global datasets into actionable, highly visual insights, demonstrating the impact of internet access on modern economies.

The .pbix file is included in this repository. Feel free to download it and explore the data model and DAX measures!

---

Interactive Features (Demo)

1. Dynamic Parameter Controls & Cross-Filtering

Demonstrating the "Internet & Economy" dashboard. By changing the core metric parameter, all linked visualizations—including dynamic line charts, tables, and scatter plots—update instantly to reflect the new data context.

2. UI/UX: Interactive Chart Toggles

Demonstrating the "Internet & Demographics" dashboard. I implemented custom button actions and bookmarks that allow users to seamlessly toggle between different analytical views (e.g., comparing gender differences by Country vs. tracking them over Time).

---

Technical Skills & Techniques Demonstrated

This project showcases a comprehensive end-to-end BI workflow, highlighting the following competencies:

• Data Transformation (Power Query / M):
  • Extracted, cleaned, and reshaped raw datasets from multiple sources.
  • Handled missing values, standardized country names, and optimized data types for performance.
• Data Modeling:
  • Designed an efficient relational data model ensuring seamless cross-filtering across dimensions (Geography, Time, Demographics).
• DAX (Data Analysis Expressions):
  • Created custom measures for aggregations, year-over-year comparisons, and dynamic averages.
• Advanced Data Visualization:
  • Implemented scatter plots with trend lines to highlight correlations (e.g., Internet Access vs. GDP per capita).
  • Utilized interactive map visuals for spatial data analysis.
• UI / UX Design in Power BI:
  • Built an intuitive, app-like interface using Bookmarks, Buttons, and Page Navigation.
  • Applied consistent formatting, conditional colors, and clean layouts to guide the user's attention.

---

Repository Contents

• Global_Internet_Analysis.pbix - The main Power BI project file containing the dataset, data model, and interactive report.
• Global_Internet_Analysis.pdf - The pdf file generated from the Power BI project.
• README.md - Project documentation and demonstration.

How to Open

1. Download the Global_Internet_Analysis.pbix file from this repository.
2. Open it using Power BI Desktop.
3. Interact with the slicers, maps, and bookmarks to explore the data!