MICROSOFT POWER BI TRAINING

$499

$439

-12% Off
Categories
Business Intelligence and Visualizations

Course Curriculum

Learning Objective: This module will introduce you to Power BI, its fundamental principles, and various basic features.

Topics:
* Business Intelligence
* Self Service Business Intelligence
* SSBI Tools
* What is Power BI
* Why Power BI?
* Benefits of Power BI
* Flow of Power BI
* Components of Power BI
* Architecture of Power BI
* Building Blocks of Power BI

Learning Objective: You will be introduced to Power BI Desktop in this module. In Power BI, you will know how to extract data from different sources and establish links with Power BI Desktop, perform data transformation operations, and the Query Editor role.

Topics:

    • Overview of Power BI 

    • Desktop Data Sources in Power BI Desktop 

    • Connecting to data Sources 

    • Query Editor in Power BI 

    • Alter and clean your data with Query Editor 

    • Combining Data – Merging and Appending 

    • Cleaning irregularly formatted data 

    • Views in Power BI Desktop 

    • Modelling Data 

    • Manage Data Relationship 

    • Cross Filter Direction 

    • Create calculated tables and measures 

    • Optimizing Data Models

Learning Objective: In this module, you will learn about the basics of DAX in the Power BI Desktop.

Topics:

  • Essential concepts in DAX 

  • Why is DAX important? 

  • DAX Syntax 

  • Data Types in DAX 

  • Calculation Types 

  • DAX Functions 

  • Measures in DAX 

  • DAX Operators 

  • DAX tables and filtering 

  • DAX queries 

  • DAX Parameter Naming 

Learning Objective: You will learn about the advantages and best practices in Data Visualization.

Topics:

    • Introduction to visuals in Power BI 

    • Charts in Power BI 

    • Matrixes and tables 

    • Slicers Map Visualizations 

    • Gauges and Single Number Cards 

    • Modifying colors in charts and visuals 

    • Shapes, text boxes, and images 

    • What Are Custom Visuals? 

    • Page layout and formatting 

    • KPI Visuals 

    • Z-Order

Learning Objective: You will learn how to create Dashboards and publish it on Power BI services.

Topics:

    • Introduction to Power BI Service

    • Dashboard vs. Reports 

    • Quick Insights in Power BI 

    • Creating Dashboards 

    • Configuring a Dashboard 

    • Power BI Q&A 

    • Ask queries of your data using natural language 

    • Power BI embedded

Learning Objective: In this module, you will learn how to connect data sources to Azure, My SQL, HD Spark and create dashboards.

Topics:

  • Introduction to ‘Using Excel data in Power BI’

  • Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ MySQL

  • Introduction to Power BI Development API 

  • Import Power View and Power Pivot

  • Power BI Power BI Publisher for Excel 

  • Probing live connections to data with Power BI

  • Content packs 

  • Introducing Power BI Mobile 

Learning Objective: This module will help us in understanding data gateways and Power BI Report Servers. You will also learn about the web portal where reports and KPI's are displayed and managed.

Topic:

  • Report Server Basics 

  • Web Portal 

  • Paginated Reports 

  • Row-level Security 

  • Data Gateways 

  • Scheduled Refresh 

  • Resources (Rest API/ SOAP API’s/ URL Access)

Learning Objective: This module will help you build visuals for R and Python on both the Power BI Desktop and the Power BI Service.

Topic:

    • R Integration in Power BI Desktop 

    • R visuals in Power BI 

    • R Powered Custom Visuals 

    • Creating R visuals in Power BI 

    • R Visuals in Power BI Service 

    • R Scripts Security Creating visual using Python

Learning Objective: You will create a comprehensive project here in which you will integrate all of your Power BI knowledge. At the end of this module, you should be able to learn to incorporate different features according to the company's requirements.

Course Description

Power BI is a Microsoft-powered business analytics service. With self-service business intelligence capabilities, it offers interactive visualizations where end users can create reports and dashboards on their own without having to rely on any information technology personnel or database administrator. Power BI, along with a desktop-based interface called Power BI Desktop, provides cloud-based BI services known as Power BI Services.

This training will boost your skills and provide you comprehensive knowledge of Power BI. Moreover, you’ll get the necessary hands-on experience to solve real-time industry-based Power BI projects. By the end of this training you will have sufficient knowledge to:

  • Master topics such as Integration and Data Visualization

  • Perform Data Binding and Formatting

  • Learn about Power View, Power Pivot, and Power Map

  • Comprehending DAX and SSBI

  • Understand and use Data Gateways, Power BI Report Server, and Content packs

  • Explore Power BI Q&A

  • Using and Adding Custom Graphics

  • Master Power BI Embedded and Workspace

This course is best suited for:

  • Business Analysts 

  • Business Intelligence Manager 

  • Statisticians and Analysts 

  • Data Scientists 

  • Project Manager

There is as such no previous technical knowledge required to learn Power BI.

Suggested Pre-requisites:

  • Microsoft Excel

  • Python

Minimum System Requirements for Microsoft Power BI Training Online

  • Windows 7 or above, .NET 4.5, Internet Explorer 9 or later, 1 GB RAM

  • CPU: 1 GHz or faster with x64-bit processor

Features

Frequently Asked Questions (FAQs):

There are no prerequisites for the Course, and you only require a good Internet Connection with a Laptop to undertake this Course.

With this course, you will gain an essential Certification in Business Analytics with Power BI, which will help you level up your familiarity with various tooling and libraries in Power BI.
Absolute beginners to Cloud can take up this course, either to improve their understanding of Power BI or to gain the Microsoft Power BI Certification Training for Business Analytics.

If you miss a class, you can choose from the two options:

  • View the recording of the session you missed anytime you want.

  • Attend the missed classes in upcoming live batch.

You get lifetime access to our expert technical support team, who are available 24x7 to resolve any of your queries.