Indepth Workshop

Mastering data visualization & dashboard development using Power BI

Join our comprehensive Power BI workshop and unlock the power of professional-grade data visualization in just 5 days (3 hours per day).
📅 February 10, 2025
 - February 14, 2025
  ⏰7:00 pm
 - 10:00 pm (CAT)
📌 Online (Teams)

3 Hours of interactive live sessions

Lifetime access to session recordings

Hands-on Practice exercises

Personalized feedback

Certificate of completion

Buy now: $49

Key Learning Outcomes:

  • Transform raw data into professional, interactive dashboards that tell compelling stories
  • Create automated reports that update in real-time, saving hours of manual work
  • Build powerful calculations and metrics using DAX formulas
  • Design visualizations that make complex data easy to understand
  • Share insights securely across your organization
  • Apply best practices in data visualization to maximize impact

Course outline

  1. Introduction and getting started
    • Overview of Business Intelligence and Data Visualization
    • Power BI ecosystem
    • The Power BI interface
    • Power BI building blocks
    • Overview of building reports and dashboards in Power BI
    • Connecting to a Microsoft Excel workbook
    • Creating your first visualizations
    • Editing and formatting visuals
    • Using the report
  2. Connecting to data
    1. Connecting to Excel and CSV files
    2. Connecting to KoboToolbox
    3. Connecting to ODK
    4. Connecting to Google Sheets
  3. Cleaning, transforming, and modelling data
    1. Data cleaning and transformation techniques
    2. Changing data types, renaming columns, find and replace
    3. Creating relationships between tables
    4. Creating and using hierarchies
    5. Defining row-level security
  4. Performing calculations using DAX
    1. Creating calculated columns and measures
    2. Basic DAX functions (SUM, AVERAGE, COUNT)
    3. Conditional assignment using IF and SWITCH
    4. Basic time intelligence calculations (YTD, MTD)
    5. Using CALCULATE and FILTER
  5. Creating basic visualizations
    • Introduction to Power BI’s visualizations (cards, charts, graphs, tables)
    • Selecting appropriate visuals for different types of data
    • Building bar charts, line charts, pie charts, and tables
    • Formatting visuals (colors, labels, legends)
    • Using slicers and filters for interactivity
  6. Advanced visualization techniques
    1. Working with maps, scatter plots, treemaps
    2. Creating KPI scorecards and guages
    3. Applying conditional formatting to visuals
    4. Downloading and using custom visuals
  7. Assembling visuals into a dashboard
    • Best practices for dashboard design
    • Combining multiple visuals into a single dashboard
    • Creating interactive reports with bookmarks and buttons
    • Synchronizing slicers across multiple pages
    • Adding tooltips for enhanced user experience
  8. Publishing and sharing dashboards
    • Publishing reports to Power BI Service
    • Sharing dashboards with stakeholders
    • Managing permissions and access control in Power BI Service
    • Exporting reports to PDF or embedding them in websites

Who should attend

  • M&E Specialists and Impact Measurement Managers
  • Program and Project Managers
  • Data officers or analysts
  • Anyone who would like to transform your impact reporting from basic spreadsheets to compelling visual stories