Use your organisation's data to tell compelling stories

  • Do you want to create your own reports and dashboards?
  • Unable to access data needed to measure indicators?
  • Unable to monitor project results in real-time?
  • Having difficulty sharing your dashboards?
  • Is it difficult to report on your project's activities and impacts?


Power BI is the right solution for you

What you will learn

This two day course provides participants with a fundamental understanding of the capabilities of Power BI. This course will show you how to connect and model data in Power BI and create visually immersive reports that reveal data insights. At the end of this course, participants will have a solid understanding of this powerful collection of software, apps, and services. They will be able to analyze data and uncover insights and trends.

  • Prepare Data in Power BI Desktop

  • Transform Data in Power BI Desktop

  • Data Modeling in Power BI Desktop

  • Using DAX in Power BI Desktop

  • Designing a Report in Power BI Desktop

  • Creating a Power BI Dashboard

  • Data Analysis in Power BI Desktop

  • Sharing Dashboards

Course Fee

Ready to take this course?

Learn to create compelling visualizations

This course teaches the techniques needed to create stunning reports and dashboards

Features

  • Activities

    Hands-on activities enabling learners to practice what is learned in the course.

  • Live Instructor-Led

    Expert-led live labs providing learners with hands-on instruction.

  • Support

    Our team will help resolve any issues that occur during and after the course.

Your course includes

  • Two days of live online instructor-led training

  • Practical Exercises

  • Certificate of Achievement

  • Course Material

Course Outline

  • 1

    Module 1: Get Started with Microsoft Power BI

    • Lesson 1: Data analytics and Microsoft
    • Lesson 2: Getting Started with Power BI
  • 2

    Module 2: Prepare Data in Power BI

    • Lesson 1: Get Data from Various Data Sources
    • Lesson 2: The Power BI Service
    • Lesson 3: Resolve data errors
  • 3

    Module 3: Clean, Transform, and Load Data in Power BI

    • Lesson 1: Data shaping
    • Lesson 2: Enhance the data structure
    • Lesson 3: Data Profiling
  • 4

    Module 4: Design a Data Model in Power BI

    • Lesson 1: Introduction to data modeling
    • Lesson 2: Working with tables
    • Lesson 3: Dimensions and Hierarchies
  • 5

    Module 5: Create Measures using DAX in Power BI

    • Lesson 1: Introduction to DAX
    • Lesson 2: DAX context
    • Lesson 3: Advanced DAX
  • 6

    Module 6: Create Reports

    • Lesson 1: Design a report
    • Lesson 2: Enhance the report
  • 7

    Module 7: Create Dashboards

    • Lesson 1: Create a Dashboard
    • Lesson 2: Enhance a Dashboard
  • 8

    Module 8: Perform Advanced Analytics

    • Lesson 1: Advanced Analytics
    • Lesson 2: Data Insights through AI visuals

FAQ

  • What if I have questions after I complete the course?

    We will address queries during and after the course.

  • How soon after enrolling will I get access to the content?

    The LMS access will be available instantly, and you will be able to access the all of the course information, activities, and lesson labs.

  • Is the course material accessible to the students even after the course training is over?

    You will have lifetime access to the course material.