0
  • LOGIN

  • No products in the basket.

Overview

Overview

Grasp the science of Microsoft Power BI Masterclass and how it relates to launching a lucrative career. Prepare for future Microsoft Power BI Masterclass needs by looking beyond the ongoing Microsoft Power BI Masterclass impact with Discover Training’s up-to-date Microsoft Power BI Masterclass course .

Discover Training’s Microsoft Power BI Masterclass course gives you a solid foundation in Microsoft Power BI Masterclass in many settings of human development. With industry expert interviews, you’ll gain a greater understanding of Microsoft Power BI Masterclass‘s applications and limitations, as well as how it’s already been efficiently used in the field. Discover Training’s Microsoft Power BI Masterclass course will help you obtain facts and knowledge to strengthen your abilities on both standard Microsoft Power BI Masterclass techniques.

As you progress through the interactive modules of this online program, you will have a strong grasp of Microsoft Power BI Masterclass to identify new opportunities for innovation and drive digital growth within your organization. Enrol in the Microsoft Power BI Masterclass course today and leverage your knowledge tomorrow. 

Description:

Industry professionals developed the content of this online Microsoft Power BI Masterclass course, combining their expertise and in-depth knowledge. The curriculum was developed by Discover Training to assist you in growing in your current role by providing you with the necessary information and concepts. As you progress through the modules of this course, you’ll learn the fundamentals of  Microsoft Power BI Masterclass and explore the essential concepts.

Who is this course for?

This Microsoft Power BI Masterclass course is for you if you want to learn about the revolutionary potential of Microsoft Power BI Masterclass. Whether you are a newbie or a seasoned veteran, a grasp of challenges that Microsoft Power BI Masterclass techniques can tackle would benefit anyone working in the Microsoft Power BI Masterclass sector. This Microsoft Power BI Masterclass training covers crucial subjects that will help you overcome challenges and improve your practices.

Requirements:

  • Prerequisites: None
  • Age Limit: 16+
  • Gadgets: Smart devices and internet

Certification

Once the Microsoft Power BI Masterclass course is successfully completed, the learner can obtain the PDF certificate without any cost. The hardcopy version of the certificate is also available for only £9.99. However, anyone ordering the hardcopy certificate from outside the United Kingdom may need to pay an additional delivery charge.

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

FAQS

We intend to inspire and encourage everyone to seek and receive a top-notch education. We have brought together the finest and most visionary experts to help you through your learning period. Our courses are open to anyone and everyone looking for a new objective, a career changeover, or a promotion.

Yes, of course, you can. After you’ve enrolled on our site, you’ll frequently get special offers and exclusive deals. You are free to take whatever courses that suit your needs.

We will provide you with a Certificate (with an added cost) depending on the course genre you ended up taking after completing all of the mandatory tasks. Point to be noted; you must obtain a passing grade by the course’s completion date.

You will have 14 days to revoke your Course purchase from your purchase date. Regrettably, refunds are not allowed after your purchase have been approved, and materials have been posted to the student’s dashboard or accessed.

We offer various payment options depending on the country and region of your account. When you wish to acquire a course, you could look at the several payment options:

  • • Go to the course home page and click ‘Take This Course’ after selecting the course you wish to take.
  • • You’ll end up on the Checkout page, where you can choose from a number of different payment choices (credit card, debit, deposit, or bank transfer).

There are no time constraints for starting or completing any course. You are free to begin any course at any time. Furthermore, as long as your account is in good standing and we own the copyright to the course, you’ll have access to it even after you’ve finished it.

Discover Our Similar Courses

Financial Modeling Using Excel
4.6
£11.99
Financial Modeling Using Excel

67 Student

  • Excel
  • Microsoft Office

4.4
£11.99
Basic Electronics Course

39 Student

  • Employability
  • Personal Development

Nail Sanitation & Gel Treatment for Nail Technician
4.7
£11.99
Nail Sanitation & Gel Treatment for Nail Technician

15 Student

  • Employability
  • Personal Development

Beauty Technician - All in One
4.5
£11.99
Beauty Technician – All in One

11 Student

  • Personal Development

COPYRIGHT © 2021 One Education

Oops! We could not locate your form.