Data Analytics Essentials with Microsoft Power BI

person icon Ahmed Oyelowo

4 ★★★★ ★

Buy Now

Data Analytics Essentials with Microsoft Power BI

Name: Data Analytics Essentials with Microsoft Power BI
Rating: 4 (305 reviews)
Author: Ahmed Oyelowo

Expert Led Tutorial by a Microsoft MVP and Certified Trainer

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Ahmed Oyelowo

English [CC]

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

Lectures -70

Resources -6

Duration -4.5 hours

4 ★★★★ ★

Add to Cart Buy Now

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point 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

Goals

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

Prerequisites

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

Curriculum

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

Module 1 - Intro to Data Prep and Data Viz
30 Lectures

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

Course Certificate

Use your certificate to make a career change or to advance in your current career.