Digital Egypt Pioneers Initiative

Power BI Dashboard & Data Modeling

Business Scenario

An international economic organization requires an enterprise-level Power BI dashboard to

monitor country development, economic and health indicators, and population trends.

Detailed Required Tasks

• Perform advanced cleaning using Power Query and M language.

• Create calculated columns and advanced DAX measures.

• Develop a professional multi-page dashboard.

• Build advanced KPI cards and dynamic titles.

• Implement drill-through pages, bookmarks, and tooltips.

• Create geographical visualizations and country comparisons.

• Apply advanced conditional formatting and interactive filtering.

• Optimize dashboard performance.

Technical Requirements

• Minimum 10 DAX measures.

• Minimum 3 dashboard pages.

• At least 8 visualizations.

• Use drill-through and bookmarks.

• Implement advanced DAX calculations.