-
Duration – 15 hours

Candidates for this exam should have a good understanding of how to use Power BI to perform data analysis. Candidates should be proficient in connecting to data sources and performing data transformations, modeling and visualizing data by using Microsoft Power BI Desktop, and configuring dashboards by using the Power BI service
INR 1000
Analyzing and Visualizing Data with Microsoft Power BI
Introduction
Â
Introduction
Â
Installing Power BI Desktop
Â
What are we going to learn?
Â
Resources
Â
Â
Creating and formatting a table visualization
Â
Importing from Excel, and Creating our first visualization
Â
Viewing data
Â
Focus mode and Different visualizations
Â
Saving visualization to the Desktop and to the Power BI service
Â
Â
Formatting our first visualization
Â
Formatting font and font size
Â
Formatting colors
Â
Stylistic options
Â
Position visuals
Â
Align visuals
Â
Configuring summarization, both default and in a specific visualization
Â
Changing number and date formatting
Â
Â
Creating different visualizations Matrices and bar charts
Â
Matrix
Â
Drill down data, see data and records, and export data
Â
Stacked bar charts and j. switch theme for reports
Â
Bar Chart formatting
Â
Configure interactions between visual (Edit interactions)
Â
Clustered and % Stacked bar charts
Â
Line and area charts, including b. Configure duplicate pages
Â
Combo charts (Line and column charts)
Â
Â
Adding more control to your visualizations
Â
Adding Text boxes, Images and Shapes
Â
Visual level, page level and report level filters – basic filters
Â
Advanced Filtering
Â
Filter Top N Items
Â
Slicer
Â
Slicer Warning
Â
Sort visuals
Â
Use Bookmarks for reports
Â
Drillthrough
Â
Buttons and Actions
Â
Â
Other visualizations
Â
Ribbon charts
Â
Waterfall charts
Â
Scatter, bubble and dot charts
Â
Pie charts and donut charts
Â
Treemaps
Â
Funnel charts
Â
Adding Marketplace visualizations
Â
Â
Mapping
Â
Maps
Â
Formatting maps
Â
Adding Data Categories
Â
Filled Maps,Conditional Formatting, and color blindness
Â
Creating hierarchies
Â
ArcGIS Maps for Power BI
Â
Â
Measure performance by using KPIs, gauges and cards
Â
Gauges
Â
Cards and Multi-row cards
Â
More conditional formatting
Â
KPIs
Â
Â
Get and Transform Data Level  – Home PartÂ
Â
Introduction – let’s Get some more Data
Â
Exploring the Power Query Editor interface
Â
Introducing the M language
Â
Let’s start look at the Home tab
Â
Home menu – Manage Columns
Â
Home menu – Reduce Rows and Use First Row as Headers
Â
Â
Get Data – Home
Â
Sort and Filter
Â
Split Column
Â
Other Transform activities
Â
Â
Getting Multiple files
Â
Merge Queries and Expand Table
Â
Merge Queries with Group By, and different types of Joins
Â
Appending two queries together
Â
Appending three or more queries together + resolving a problem with data types
Â
Combine Files (getting information from a folder)
Â
Â
Â
Transform Menu
Â
Transform – Table and Any Column
Â
Pivot Column
Â
Unpivot
Â
Unpivot in conjunction with other Transform features
Â
Â
Transform – Text and Numbers
Â
Transform/Add Column – Text – Format
Â
Transform/Add Column – Text – Merge Columns
Â
Transform/Add Column – Text – Extract
Â
Transform/Add Column – Text – Parse
Â
Transform/Add Column – Number Column – Statistics and Standard
Â
Transform/Add Column – Other Number Column functions
Â
Â
Transform – Dates and Time
Â
Creating a list of dates
Â
Transform/Add Column – Date
Â
Transform/Add Column – Dates in other cultures/languages
Â
Transform/Add Column – Time
Â
Transform/Add column – Duration
Â
Â
Add Columns, View and Help Menus
Â
Column from examples
Â
Conditional Column
Â
Resolving Errors from Conditional Columns
Â
Index Column and Duplicate Column
Â
Custom Column – If Then Else
Â
View and Help menus and advanced functionality
Â
Other M Functions
Â
View and Help menus
Â
Advanced Editor
Â
Functions and Parameters
Â
DateTimeZone date type and Functions
Â
Worked Practice Activity  – Dividing Annual data into Months
Â
Â
Get other types of data
Â
Introduction to SQL Server
Â
Importing database data into Power BI, and Query Folding
Â
Expanding multiple tables in SQL Server
Â
Importing data from SQL Server Analysis Services (SSAS)
Â
Setting up Azure SQL Database
Â
Using Azure SQL Database in Power BI
Â
Using Big Data
Â
Â
An introduction to DAX functions, including Logical functions
Â
Get multiple data sets, and connecting them together
Â
The problems with direction of relationships between data sets
Â
DAX functions – A useful Resource
Â
Calculated columns – an introduction
Â
Basic operators
Â
IF, BLANK and ISBLANK
Â
AND, OR and NOT
Â
SWITCH
Â
Other functions
Â
Â
Statistical functions
Â
Measures – an introduction, with standard aggregations including Countblank
Â
Aggregation of calculations
Â
Other statistical functions
Â
Â
Mathematical functions
Â
Introduction to mathematical functions
Â
Rounding functions
Â
Division functions – MOD and QUOTIENT
Â
SIGN (and use with SWITCH) and ABS
Â
Exponential functions
Â
Other functions
Â
Â
Text functions
Â
Text searching
Â
Text extraction and substitution
Â
Text conversion
Â
Other functions
Â
Â
Information Functions
Â
ISERROR and LOOKUPVALUE
Â
Other functions
Â
Filter and Value Functions
Â
RELATED
Â
RELATEDTABLE and COUNTROWS
Â
Context
Â
ALL
Â
FILTER
Â
CALCULATE
Â
ALLEXCEPT
Â
ALLSELECTED
Â
Other functions
Â
Â
Time Intelligence Functions
Â
Date and Time Functions
Â
FIRSTDATE, LASTDATE
Â
Start of… and End of…
Â
Previous… and Next…
Â
DATESINPERIOD
Â
DATESMTD, DATESQTD, DATESYTD, TOTALMTD, TOTALQTD, TOTALYTD
Â
Opening Balance and Closing Balance
Â
SAMEPERIODLASTYEAR and PARALLELPERIOD
Â
Other Time Intelligence Functions
Â
What People Are Saying

Abhilash -
A very good match. i am enjoying every bit.

Sonal-
Experience was quite good and it was very useful and well elaborated course.

Karan-
I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-
I find that the explanation is good and also understandable.

Seyed-
Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-
I really like this course, it was a good match for me :))

Mahesh-
Standard process and hands on covered nicely.

Emily-
Perfect, with complete hands on. Well structured and nicely covered.

Kevin-
Great Content, nice and up to the mark course.

Mayuresh-
Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-
Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-
A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-
Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-
Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-
This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -
A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-
Yes lessons are very good. Not so fast, well explained

Kishore-
Worth course for the beginner to invest their time to learn this demanding skills.
