Data Analysis and Business Reporting Techniques using Excel and PBI

certified Workshop sessions Total Number of Sessions: 5 duration Total Duration: 20 Hours
knowledge

Program Overview

This program unpacks the full process — Identify → Collect → Clean/Transform → Analyze → Visualize — and participants practice each step through guided exercises. The deck doubles as a hands-on manual to reuse at work; consistently applying these methods in real scenarios is what turns skills into professional mastery.

session schedule

Session Schedule

date 29 Nov 2026 (Sunday)
time 05:00pm - 09:00pm
venue Online
date 30 Nov 2026 (Monday)
time 05:00pm - 09:00pm
venue Online
target

Who Should Attend

Professionals and staff who want to strengthen their data analysis and reporting skills.

  • Analysts
  • Coordinators, consultants and managers who work with data and reports
  • Staff aiming to use Excel & Power BI effectively
objective

Learning Objectives

After completing this course

  • check

    Frame business problems and map them to the end-to-end analytics process.

  • check

    Distinguish between descriptive, diagnostic, predictive, and prescriptive analysis and choose appropriately.

  • check

    Collect data from appropriate sources and prepare it ethically and systematically.

  • check

    Clean and transform datasets efficiently with Excel and Power Query.

  • check

    Build analysis ready models in Power BI (Star vs Snowflake) and create robust DAX measures.

  • check

    Design clear, stakeholder aligned visualizations and interactive dashboards that drive decisions.

bg
objective

Course Prerequisite

Basic knowledge of Excel recommended.

  • check

    Familiarity with Excel basics

  • check

    Interest in data-driven decision-making

Course Outline

Introduction to Data Analytics:

  • Icebreaker activity, pre-assessment
  • The shift to data-driven decision making
  • Types & stages of analytics (descriptive, diagnostic, predictive, prescriptive)

Data Collection

  • Data sources: structured, semi-structured, unstructured
  • Primary & secondary data collection methods
  • Ethical considerations in data handling
  • Hands-on workshop: building a data collection form in Excel VBA

Data Cleaning & Transformation

  • Cleaning techniques (removing duplicates, handling missing values, formatting)
  • Power Query basics (transforming and merging datasets)
  • Workshop: cleaning job dataset & automating processes

Data Analysis

  • Using Excel (PivotTables, formulas, VBA basics)
  • Using Power BI (DAX, modeling, relationships, measures)
  • Workshop: building calculations, KPIs, and dynamic dashboards

Data Visualization & Reporting

  • Principles of effective visualization
  • Charts, dashboards, conditional formatting
  • Power BI interactive dashboards & reporting
  • Case study project: end-to-end analysis and reporting simulation
Sunday, Monday, Tuesday, Wednesday & Thursday : 05:00pm - 09:00pm
calendar Date: 29 Nov 2026 - 03 Dec 2026
Language: English
Regular Registration :
calendar Date : 1 Jan 2026 - 16 Nov 2026
1,500 QAR
right-arrowInquire now right-arrow Book an appoinment
Register Now right-arrow

QFBA - Qatar Finance and Business Academy. All rights reserved