infyni

About Course

With the BI tools emerging every day, you cannot afford not to know them.

This live online course in Power BI helps you understand Power BI from the basics. Almost all organizations have included or have strategies to use BI in solving their administrative complications. Power BI is, as such the most widespread BI tool developed by Microsoft primarily intended to help everyone analyze and visualize their data.

It eliminates the human error factor, that comes into play very often to give you incorrect data. Thus, professionals having the capability to study data and make the outcomes presentable to corporate decision makers can expect to be most sought after.

What you will gain by the end of this live course in Power BI:

• Desktop Interface

• Data transformation

• Data Modelling

• DAX

• Charts and Page Layout

• Reports and Dashboard

• Power BI Service

All classes are instructor led, live and online using a hands-on approach. Take a trial for free and decide.

Skills You Will Gain

Intelligent visualizations Analytics Power BI Business data Decision-making processes Wide connectivity with CRM ERP

Course Offerings

Instructor-led interactive classes
Clarify your doubts during class
Access recordings of the class
Attend on mobile or tablet
Live projects to practice
Case studies to learn from
Lifetime mentorship support
Industry specific curriculum
Certificate of completion
Employability opportunity

Topics
Instructor (1)

1 Module 1

3 ways to use Power BI (desktop, service, mobile app)
Introduction and importance of BI
Tools and technologies in BI area

2 Module 2

Power BI architecture
Power BI introduction and its components
Power BI flow
Download Power BI desktop and interface tour
Key backstage options

3 Module 3

Get data from CSV, Text and Excel files
Get data from Odata
Connect to local folder

4 Module 4

Power query and power query editor
Merge, add and remove columns
Sorting
Merge and append queries
Group, transpose, reverse rows, count rows, use as header
Detect and change data type, fill, unpivot, etc
Splitting, replace values, extracting, merging, formatting
Statistical, standard, rounding and information
Calendar table
Conditional, custom, index and duplicate column
Flashfill

5 Module 5

Build relationship and cardinality
Filter flow and cross filter
Build entire model
Snowflake and star schema
Add related tables

6 Module 6

Understand DAX and its types
Calculated columns and measures
Logical DAX
Conditional column
SWITCH function
Year and Today function
Text functions

7 Module 7

Related function
Relatedtable function
Filter and Row context
Understand measures
Measure table
Count function
Calculate function
Calculated table using Filter function

8 Module 8

Iterator functions
MAXX function
Cross Filter
All function

9 Module 9

Month, Quarter, Year to Date calculation
Previous day, Month, Quarter, Year calculation
Periodic calculation

10 Module 10

Report view and create report
Page display settings
Setting color theme

11 Module 11

Non-visualization object
Basic charts and format tab
Comparison visuals
Bar chart for top n customers
Plotting values on map visual
Matrix visual along conditional formatting
Gauge chart
Slicers

12 Module 12

Monthly trend with line chart
Forecast in line chart
Area chart with tooltip feature
KPI
Drill through
Custom visual
Story telling through bookmark
Ask question
Sync slicer
Key influencer 1
Decomposition tree
Function based visual

13 Module 13

Row level security
Tooltip page
Interactive visuals in report

14 Module 14

Publish report to Power BI service
Understand Power BI service
Creating Power BI service account
Power BI interface tour
My workspace vs Workspace vs Apps

15 Module 15

Options in report interface -1
Options in report interface – 2
3 ways in creating dashboard
Options in dashboard interface

16 Module 16

Gateways and its types
Scheduled refresh
Assigning user roles and giving permissions
Sharing through publishing apps
Implementing Row level security
Real time data streaming connection
Real time data dashboard
Downloading and understanding Power BI Mobile App interface

17 Module 17

Question bank with 2 small projects

Uddipta Sarma

About Instructor

I am a Bachelor of Engineering (CSE) and PGDM in Marketing. Five years working experience as Data Analyst and 3 plus years as an online trainer for Power BI, Tableau, Excel, SQL Server for domestic and international clients and groups. I take courses in Python (basic to advanced), SQL server, Tableau Excel (basic to advanced), Excel with statistics, VBA and Google sheets. All my classes are live and online.

0

Rating

0

Review

167

Students

8

Courses

Complete Power BI Training IV

$244