Course Description

This Virtual course is designed to equip you with the much needed techniques that will help you in report building and data analytics. The course is designed to equip you in communicating business data effectively and gain clearer insights through powerful analytics. This course has 143 Lessons which you would need to cover within a study time not less than 67.7 hours. By the end of this course, you would be able to:

  • Demonstrate working knowledge of Power Query.

  • Use a framework for building a Data Model.

  • Assess various data visualization options in Power BI Desktop.

  • Make sense of the DAX formula Language.

  • Produce typical business reports using DAX formulas you will build on a Power BI Data Model.

  • incorporate budget data to your reporting, Building budget variable analysis reports.

  • Produce a complete reporting solution from scratch in a full Day Case Study Session.

Register for the Next Class

Hurry! The next class is almost full book your seat today, before the deadline.

  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

live sessions delivered via ZOOM Training

dbrownconsulting, Virtual Training Methodology

Course curriculum

    1. Virtual Course Overview

      FREE PREVIEW
    2. How to use this Main Course Platform

    3. Requirements for Virtual Sessions

      FREE PREVIEW
    4. Getting Ready for Virtual Training

    5. How to use our Virtual Training Platforms

    6. Your Expectations

    7. Ask the Trainer

      FREE PREVIEW
    1. Course Brochure - Agenda

      FREE PREVIEW
    2. Course Manual

    3. More resources for you

    4. Join our growing Community on Telegram

    1. Overview of Power BI

    2. What is Power BI?

    3. What is Power BI Desktop?

    4. What is the Power BI service?

    5. Comparing Power BI Desktop and the Power BI service

    6. Introduction to Power Query

    7. Introduction to DAX

    8. Understanding the Power BI Eco System

    9. Download Power BI Desktop

    10. Power BI Technologies Quiz

    1. Introduction

    2. How Excel Works

    3. How Dates work in Excel

    4. The 7 Golden Rules of Data

    5. The 3 Sheet Framework

    6. Excel's Reporting Infrastructure Quiz

    1. What is Power Query?

    2. Get Data with Power Query

    3. Lab - Get Data with Power Query

    4. Getting External Data into Excel

      FREE PREVIEW
    5. Connect to Excel Files in a Folder

    6. Consolidate Excel Workbooks

      FREE PREVIEW
    7. Transform Data Types

    8. Loading your Query to Excel

    9. Power Query Quiz

    1. What is Data Modelling?

    2. Overview of modeling data

    3. Manage data relationships

    4. Understand star schema Data Model and the importance for Power BI

    5. Working with Tables

    6. Creating a Date Table

    7. Define Data Granularity

    8. Working with Relationships and Cardinality

    9. Data Modelling Quiz

About this course

  • $1,200.00
  • 129 lessons
  • 1 hour of video content

FAQ

  • How does Virtual Training Work?

    You cover fundamentals of Excel for the first 2 weeks on this platform with over 200 knowledge videos. Then you join a Virtual class to cover 10 virtual sessions.

  • How long is each Virtual Session?

    Each Virtual Session lasts two hours and is highly interactive. There is a 15 minute break in the middle and it is fully instructor led.

  • How long do I have access to the course content and platform?

    You have access to this platform will all the course content, videos, exercise files and access to the trainer via discussion forum for life. We will never switch you off.

  • Can I defer my Session?

    Deferral requests are treated on a case by case basis. Please email [email protected] with your request.

  • Are the videos available offline?

    Our videos are only available for streaming online. But you can download all exercise files and materials.

Instructor(s)

Adewale Yusuf

Microsoft MVP & MCT

Adewale is a Microsoft Most Valuable Professional (MVP) in the Data Platform and a Microsoft Certified Trainer (MCT) in Business intelligence and analysis, among other certifications he is a Microsoft certified Solution Associate and a Microsoft Certified Power Platform Functional Consultant. Wale facilitates our Data Analytics courses including, Excel, Office 365, Power BI, Power Apps and Advanced Presentation Skills. He is passionate about impacting knowledge to the community and currently leads many usergroups and communities driving Data Analytic Competencies.

Some of our Clients