• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Power BI Masterclass

Microsoft Power BI Masterclass

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • On-Demand course

  • 14 hours 25 minutes

  • Intermediate level

Description

Join our Microsoft Power BI Masterclass course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Microsoft Power BI Masterclass course has everything you need to get a great start in this sector.

Improving and moving forward is key to getting ahead personally. The Microsoft Power BI Masterclass course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now!

You will Learn The Following Things:

  • Learn strategies to boost your workplace efficiency.

  • Hone your skills to help you advance your career.

  • Acquire a comprehensive understanding of various topics and tips.

  • Learn in-demand skills that are in high demand among UK employers

This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Microsoft Power BI Masterclass. Enrol today and complete the course to achieve a certificate that can change your career forever.

Details

Perks of Learning with IOMH

  • One-to-one support from a dedicated tutor throughout your course.

  • Study online - whenever and wherever you want.

  • Instant Digital/ PDF certificate

  • 100% money back guarantee

  • 12 months access

Process of Evaluation

After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate.

Certificate of Achievement

After completing the Microsoft Power BI Masterclass course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International).

Who Is This Course for?

This Microsoft Power BI Masterclass is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. 

On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. 

This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.

Requirements

There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Microsoft Power BI Masterclass course.

Do note: you must be at least 16 years old to enrol.

Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course.

Career Path

The certification and skills you get from this Microsoft Power BI Masterclass Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors.

Course Curriculum

Section 01: Introduction

Welcome!

00:01:00

What is Power BI?

00:03:00

Download & Installing Power BI Desktop

00:04:00

Getting to know the interface

00:03:00

Mini Project: Transform Data

00:07:00

Mini Project: Visualize Data

00:05:00

Mini Project: Creating a Data Model

00:07:00

Course Outline: What will you learn in this course?

00:05:00

How to learn best with this course?

00:03:00

Section 02: Preparing our Project

Creating our initial project file

00:04:00

Working with the attached project files

00:04:00

Section 03: Data Transformation - The Query Editor

Exploring the Query Editor

00:06:00

Connecting to our data source

00:07:00

Editing rows

00:08:00

Changing data types

00:08:00

Replacing values

00:03:00

Close & Apply

00:03:00

Connecting to a csv file

00:03:00

Connecting to a web page

00:05:00

Extracting characters

00:06:00

Splitting & merging columns

00:09:00

Creating conditional columns

00:06:00

Creating columns from examples

00:09:00

Merging Queries

00:17:00

Pivoting & Unpivoting

00:06:00

Appending Queries

00:08:00

Practice & Solution: Population table

00:15:00

The Fact-Dimension-Model

00:09:00

Practice: Load the dimension table

00:04:00

Organizing our queries in groups

00:03:00

Entering data manually

00:05:00

Creating an index column

00:03:00

Workflow & more transformations

00:05:00

Module summary

00:05:00

Exercise 1 - Instruction

00:02:00

Exercise Solution

00:11:00

Section 04: Data Transformation - Advanced

Advanced Editor - Best practices

00:09:00

Performance: References vs. Duplicating

00:10:00

Performance: Enable / Disable Load & Report Refresh

00:05:00

Group by

00:05:00

Mathematical Operations

00:05:00

Run R Script

00:15:00

Using Parameters to dynamically transform data

00:06:00

M formula language: Basics

00:07:00

M formula language: Values, Lists & Tables

00:14:00

M formula language: Functions

00:13:00

M formula language: More functions & steps

00:05:00

Exercise 2 - Instructions

00:01:00

Exercise 2 - solution

00:05:00

Section 05: Creating a Data Model

Understanding the relationship

00:05:00

Create & edit relationships

00:06:00

One-to-many & one-to-one relationship

00:06:00

Many-to-many (m:n) relationship

00:08:00

Cross filter direction

00:06:00

Activate & deactivate relationships

00:06:00

Model summary

00:03:00

Exercise 3 Create Model

00:02:00

Exercise 3 Solution

00:02:00

Section 06: Data Visualization

Our first visual

00:08:00

The format tab

00:12:00

Understanding tables

00:10:00

Conditional formatting

00:09:00

The Pie Chart

00:06:00

All about the filter visual

00:13:00

The filter pane for developers

00:09:00

Cross filtering & edit interactions

00:04:00

Syncing slicers across pages

00:07:00

Creating drill downs

00:08:00

Creating drill throughs

00:07:00

The tree map visual

00:07:00

The decomposition tree

00:05:00

Understanding the matrix visual

00:05:00

Editing pages

00:07:00

Buttons & Actions

00:09:00

Bookmarks to customize your report

00:10:00

Analytics and Forecasts with line charts

00:10:00

Working with custom visuals

00:07:00

Get data using R Script & R Script visual

00:08:00

Asking questions - Q&A visual

00:04:00

Wrap up - data visualization

00:08:00

Section 07: Power BI & Python

Python in Power BI - Plan of attack

00:03:00

Setting up Python for Power BI

00:03:00

Transforming data using Python

00:11:00

Creating visualizations using Python

00:08:00

Violin plots, pair plots & ridge plots using Python

00:15:00

Machine learning (BayesTextAnalyzer) using Python

00:00:00

Performance & Troubleshooting

00:03:00

Section 08: Storytelling with Data

Introduction

00:01:00

Show Empathy & Identify the Requirement

00:03:00

Finding the Most Suitable KPI's

00:02:00

Choose an Effective Visualization

00:04:00

Make Use of Natural Reading Pattern

00:03:00

Tell a Story Using Visual Cues

00:05:00

Avoid Chaos & Group Information

00:02:00

Warp Up - Storytelling with Data

00:02:00

Section 09: DAX - The Essentials

Introduction

00:03:00

The project data

00:04:00

Measures vs. Calculated Columns

00:15:00

Automatically creating a date table in DAX

00:08:00

CALENDAR

00:05:00

Creating a complete date table with features

00:04:00

Creating key measure table

00:03:00

Aggregation functions

00:06:00

The different versions of COUNT

00:14:00

SUMX - Row based calculations

00:09:00

Section 10: DAX - The CALCULATE function

CALCULATE - The basics

00:11:00

Changing the context with FILTER

00:07:00

ALL

00:08:00

ALL SELECTED

00:03:00

ALL EXCEPT

00:07:00

Section 11: Power BI Service - Power BI Cloud

How to go on now?

00:03:00

Power BI Pro vs Premium & Signing up

00:04:00

Exploring the interface

00:04:00

Discovering your workspace

00:03:00

Connecting Power BI Desktop & Cloud

00:04:00

Understanding datasets & reports

00:03:00

Working on reports

00:04:00

Updating reports from Power BI Desktop

00:04:00

Creating and working with workspaces

00:07:00

Installing & using a data gateway

00:13:00

Get Quick Insights

00:03:00

Creating dashboards

00:04:00

Sharing our results through Apps

00:10:00

Power BI Mobile App

00:05:00

Creating the layout for the Mobile App

00:04:00

Wrap up - Power BI Cloud

00:07:00

Section 12: Row-Level Security

Introduction

00:03:00

Creating a Row-Level Security

00:05:00

Row-Level Security in the Cloud

00:04:00

Row-Level Security & Data Model

00:05:00

Dynamic Row-Level Security

00:07:00

Dynamic Many-to-Many RLS

00:04:00

Hierarchical Row-Level Security

00:13:00

Section 13: More data sources

JSON & REST API

00:10:00

Setting up a local MySQL database

00:14:00

Connecting to a MySQL database in Power BI

00:05:00

Connecting to a SQL database (PostgreSQL)

00:05:00

Section 14: Next steps to improve & stay up to date

Congratulations & next steps

00:06:00

The End

00:01:00

Resources

Resources - Microsoft Power BI Masterclass

00:00:00

About The Provider

Tags

Reviews