Why Attend This Microsoft Power Bi Training Course?

This microsoft power bi training course certification is intended as a continuation of our introductory-level courses in Power BI (PL-300: Microsoft Power BI Data Analyst and/or Excel BI Tools: Power BI for Excel Users ).
This microsoft power bi training course covers common intermediate-level tasks and some of Power BI’s most desirable new features.

Get the best cost for this certified microsoft power bi training course certificate by ACAD Egypt

What Is The Microsoft Power Bi Training Course Methodology?

This microsoft power bi training course certification methodology depends on enabling participants to interact and exchange experiences, explore their competencies and achieve their career aspirations, using forward-thinking training arts, such as theoretical lectures and/or open discussion to exchange opinions and experiences, scenarios, innovative thinking brainstorming. Participants will receive an agenda including training material as a reference, in addition to some extra notes and booklets. 

Who Should Attend This Microsoft Power Bi Training Course?

The microsoft power bi training course certification is designed for users that have a desire to work effectively with data to create visually appealing reports or dashboards.

What Are The Microsoft Power Bi Training Course Objectives?

• Import data from PDFs, regions of web pages, and collections of files

• Characterize data with data profiling

• Merge mismatched data sets with fuzzy matching

• Generate custom columns in Power Query

• Perform advanced data modeling

• Use Power BI time intelligence

• Work with custom scripts in R and Python

• Create KPIs and scorecards

• Use advanced report design techniques

• Use advanced dashboard design techniques

• Perform basic statistical analysis in Power BI

What Is The Microsoft Power Bi Training Course Curriculum?

Introduction to Power BI

• What is Power BI?

• The Power BI service

• Power BI Report Server

• Power BI Desktop

• Reports and Dashboards

• Datasets

• Row-Level Security

• Content Packs

• Natural Language Queries

​​Data Sources

• Connecting to Files

• Importing Excel Files

• Publishing to Power BI from Excel

• Updating Files in Power BI

• Data Refresh

• The Power BI Data Model

• Managing Data Relationships

• Optimising the Model for Reporting

• Hierarchies

• SQL Servers

• Other Data Sources

• R Script Data Connector

• Configuring Data for Q&A

• Creating Content Packs

• Creating a Group

Shaping and Combining Data

• The Query Editor

• Applied Steps

• Advanced Editor

• Shaping Data

• Formatting Data

• Transforming Data

• Combining Data

• Merging Data

Modelling Data

• What are the Relationships?

• Viewing Relationships

• Creating Relationships

• Cardinality

• Cross Filter Direction

• What is DAX?

• Syntax

• Functions

• Context

• Calculated Columns

• Calculated Tables

• Measures

Interactive Data Visualisations

• Power BI Reports: Page Layout and Formatting

• Multiple Visualisations

• Creating Charts

• Using Geographic Data

• Histograms

• Power BI Admin Portal

• Service Settings

• Desktop Settings

• Dashboard and Report Settings

---

Hands-on Tasks:

Bring your own laptop to run and follow up the exercises and tasks provided by the instructor. To be sure that you can perform all tasks, Office 2010 or later version is required. Office 2007 users will find lack of some features and functions used during the exercises, in addition to some differences in the user interface and commands paths changes.

For the organization chart preparation, Microsoft Visio is required. We use Visio 2016 in the training. We recommend the latest version because Visio, unlike Excel and Office suite, usually comes with major enhancements and new features every release.