Course Code: beglev
Duration: 16 hours
Prerequisites:

Target Audience: Participants with limited experience in data analytics or visualization


Objective: Build foundational skills in organizing, analyzing, and visualizing data using Excel and Power BI to support reporting and decision-making

Course Outline:

Day 1: Foundations of Data Analysis with Excel

1. Introduction to Data Analytics

  • The role of data in decision-making
  • Types of data: structured vs unstructured
  • Overview of Excel and Power BI in the analytics workflow

2. Excel Essentials for Data Analysis

  • Organizing and cleaning data (removing duplicates, handling blanks, basic text functions)
  • Sorting, filtering, conditional formatting
  • Basic formulas: SUMIF, COUNTIF, IF, VLOOKUP/XLOOKUP

3. PivotTables and PivotCharts

  • Creating and customizing PivotTables
  • Using slicers for interactive filtering
  • Generating PivotCharts for summary visualizations

Hands-on Exercises:

  • Clean and prepare messy data
  • Generate summary tables and basic charts

Day 2: Introduction to Power BI

4. Getting Started with Power BI

  • Power BI components: Desktop, Service, and Mobile
  • Loading and transforming data in Power BI
  • Data types, basic transformation, and data modeling

5. Visualizing Data in Power BI

  • Creating bar, column, pie, line, and map visuals
  • Customizing charts: labels, colors, tooltips
  • Creating simple dashboards with interactive elements

6. Publishing and Sharing Reports

  • Publishing to Power BI Service
  • Sharing reports securely within an organization
  • Basic permissions and collaboration features

Hands-on Exercises:

  • Build a basic Power BI report from embassy-related sample data
  • Create a dashboard with interactive visuals