Data Analytics Essentials with Microsoft Power BI

person icon Ahmed Oyelowo

Data Analytics Essentials with Microsoft Power BI

Expert Led Tutorial by a Microsoft MVP and Certified Trainer

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Ahmed Oyelowo

architecture icon Microsoft Power BI,Data & Analytics,Data Analysis,Data Science,Data Visualization


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

Microsoft Power BI was launched in 2015, changing the course and dynamics of self-service Business Intelligence and Data Analysis. There are now a lot of Jobs for Power BI Developers.

Also, many organizations have Deployed Power BI as their Data Analytics and Visualization Tool. This makes a Power BI skill a lucrative one.

In this course, Ahmed Oyelowo, a 3-time Microsoft MVP, Microsoft Certified Trainer, and a Power BI Expert has carefully taught Power BI in a very easy and yet detailed method for anyone to follow with little or no prior analytics experience.

The course covers the essentials of data analysis and visualization with Power BI. You will learn:

  • How to clean data using Microsoft Power Query
  • How to Model Data inside Power BI
  • How to analyze and visualize Data and
  • How to publish your Power BI reports to the Power BI Service


What will you learn in this course:

  • Connect to data sources
  • Clean and prepare data
  • Build Fact and Dimension Tables
  • Write DAX formulas
  • Create reports and dashboards


What are the prerequisites for this course?

  • Windows Computer with a minimum of Windows 10 OS
  • Microsoft Power BI Desktop (How to install is covered at the beginning of the course)
Data Analytics Essentials with Microsoft Power BI


Check out the detailed breakdown of what’s inside the course

Module 1 - Intro to Data Prep and Data Viz
30 Lectures
  • play icon Introduction 04:07 04:07
  • play icon About the course 06:07 06:07
  • play icon Downloading & Installing Power BI Desktop 02:38 02:38
  • play icon 4-understanding-the-powerbi-user-interface 08:03 08:03
  • play icon Understanding the data 04:24 04:24
  • play icon Download the dataset here 04:24 04:24
  • play icon Importing Data into Power BI 03:53 03:53
  • play icon Understanding Power Query User Interface 05:26 05:26
  • play icon Introduction To Transforming Data With Power Query 1 03:29 03:29
  • play icon Introduction to Transforming Data with Power Query 2 05:05 05:05
  • play icon Reusing M Script and Loading Data Into Power BI 03:46 03:46
  • play icon Introduction to Power BI Reporting 03:36 03:36
  • play icon Visualizing Data in Power BI 03:33 03:33
  • play icon Formatting charts in Power BI 05:54 05:54
  • play icon Updated - Formatting Power BI Charts
  • play icon Creating Additional Charts in the Canvas 03:23 03:23
  • play icon Creating Top N Filters 03:34 03:34
  • play icon Sorting a Visual 03:20 03:20
  • play icon Reusing a Report Page as Template 04:40 04:40
  • play icon Page Filters with Slicers and Filters Pane 05:44 05:44
  • play icon Edit Visual Interactions 03:07 03:07
  • play icon Using Visual Background to enhance reports 01:56 01:56
  • play icon Working with Shapes and Text Box 03:03 03:03
  • play icon Working with Report Themes 03:45 03:45
  • play icon Adding Back button to navigate between report pages 01:48 01:48
  • play icon Designing a Mobile View Report 03:21 03:21
  • play icon Publishing Reports to Power BI Online Service 05:25 05:25
  • play icon Introduction to Q and A Feature 03:18 03:18
  • play icon Selecting the right visuals
  • play icon Module 1 Outro 00:46 00:46
Module 2 - Data Modeling
8 Lectures
Data Analysis Expressions (DAX)
16 Lectures
Data Visualization Part 2
9 Lectures
Data Preparation with Power Query
7 Lectures

Instructor Details

Ahmed Oyelowo

Ahmed Oyelowo

Ahmed is a Microsoft Data Platform MVP, a Microsoft Certified Trainer, Microsoft Certified Educator, Microsoft Certified Power BI Data Analyst, Microsoft Certified Azure Enterprise Data Analyst, Microsoft Office Specialist Excel Expert ?(He needs to stop ?)

He has developed cutting edge solutions and trained various corporate clients on Business Intelligence and Financial Modeling. He has been consulting & training on Power BI since it’s early days in 2015.

Ahmed has trained courses on:

1. Power BI

2. Power Query,

3. Financial Modelling

4. Advanced Data Analysis & Reconciliation and

5. Data Presentation.

He is the Managing Partner & Lead Trainer at Foresight BI & Analytics

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best


Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us