Data, Data Availability in IT
IT data storage areas
Data warehouse, BI definitions and layers
Power BI existence in IT, Product services
Power BI Features
Power BI Tools and Components

What are BI, OLAP, and OLTP? Importance in the current Enterprise?
Competitive advantages
Power BI vs Other BI tools
SQL History, SQL Extensions and Power BI detailed history
Hardware, Software requirements
Installation methods

Power BI Client
Power BI Server
Power BI Desktop

Creative visualization through software

Installation and Working with Power BI

Introduction to Power BI, Installation of Power BI

Need of Power BI, Monthly updates of Power BI

Latest new features in PBI

Working with Power BI Desktop

Working with power BI Services

Power BI availability for.

Building blocks of PBI

Differences between Power BI and SSRS(MSBI)

Connecting to Database, Fetching data from different files

Working with different visualizations, Importing custom visualizations

Working with import and direct query options

Getting data from different external data source

Working with Query Editor, Creating custom table in the Power BI

Merge Queries and Append Queries

Remove columns and split columns

Choosing required columns in the data

Working with different transformations

Working with Applied steps in query editor

Report View
Data View
Relationship View
Working with hierarchies and measures
Working with table and matrix visuals
Working with different level of filters
Visualization level
Page level
Report level

Column charts and bar charts
Line charts and area charts
Waterfall charts and tunnel charts
Pie charts and tree map charts and remaining all visualizations
Working with single row cards and multi row cards
Working with slicers
Publishing a report to Power BI Services
Managing report in Power BI services
Creating groups in Power BI Services
Different ways to share dashboards to Client and colleagues.
Working with multiple pages
Creating Power BI dashboards
Using social websites to create Dashboards

Power view
Power query
Power map
Power pivot

Creating calculated columns/fields and usage
Working with Power pivot data model
Working with data modeling
Developing KPIs and measures.
Defining relationships between tables
Power BI gateways and types

Text functions

Filter functions

Date functions

Logical functions

Information functions

Other functions

Creating and working with calculated measures by using DAX.

Creating and working with calculated columns by using DAX.

Implementing dynamic titles in the report.

Creating a custom table with range of dates.

Working with dynamic parameters.

Using dynamic parameters to filter the entire report.

Creating and publishing with Content packs.

Scheduling the Dashboards.

Different ways to share dashboards.

Creating groups and managing groups.

Adding videos and pictures in the dashboards.

You will never miss a lecture with us ! You can choose either of the two options:

View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

We have limited number of participants in a live session to maintain the Quality Standards. So, unfortunately participation in a live class without enrollment is not possible. However, you can go through the sample class recording and it would give you a clear insight about how are the classes conducted, quality of instructors and the level of interaction in a class.

All the instructors are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by edureka for providing an awesome learning experience to the participants.