| Course Others | You are Offering Professional Course | Locality Marathahalli |
POWER BI TRAINING BY 15 YEARS EXPERT IN MARATHAHALLI at "boyina softcon"
Microsoft Power BI
Duration: - 40 hrs
Delivery Method: - Instructor-Led
Trainer: Srinivas Sirigirisetty
(15 yrs of Real-time experience in Microsoft Power BI & BI Analytics (OBIEE, Tableau and Informatica)).
Trainer has 13 yrs of Experience abroad (USA)
The syllabus covers the concepts like Power Bi Desktop, Data Transformation, Powerbi Data Analysis Expressions(DAX) and Data insights, Power Bi Custom Visuals, Power Bi Integration. At the end of this course students will be able to analyse data from different data sources and create their own datasets.
--------------------------------------------------
------------------------------------------------------------
------
Components of the Course (Microsoft Power BI)
1) Power BI Desktop
2) Power BI service
3) Mobile Power BI app
Course Content
Module 1:
Introduction to Power BI
Introduction to BI (Business Intelligence)
Introduction to Tables
Introduction to Joins
Introduction to Data Modelling
Star and snowflake schema
Introduction to data visualization
Installing Power BI Desktop
Components of Power BI
Introduction to Power Query Editor
Importing Data to Power BI Desktop
Joins in Power BI
Creating Basic Visualizations in Power BI Desktop
What is Visual, page and Report in Power BI
Publishing Power BI to Power BI Service
Creating Workspaces in Power BI Service
Sharing content to the users in the Organization
Module 2:
Power BI Desktop and Power BI Service
Exploring the Sales Data
Identifying Metrics and Attributes in Sales Data
Understanding the Sales Data model
Creating relationships between tables in Relationships tab.
Creating Simple measures and columns
Difference between New measure and calculated column
Module 3: Introducing to DAX
This module introduces to DAX (Data Analysis Expressions), this is the most important topic in Power BI Desktop.
Aggregate Functions
SUM
SUMX
AVERAGE
MIN
MAX
DIVIDE
Count Functions
COUNT
COUNTDISTINCT
COUNTA
COUNTROWS
Logical Functions
CALCULATE
AND
OR
IF
ISBLANK
ISERROR
Module 4:
Intermediate level DAX
CONCATENATE
COMBINEVALUES
FILTER
ALL
ALLSELECTED
ALLEXCEPT
Time-intelligence DAX
DATEADD
DATEDIFF
DATESBETWEEN
DATEYTD
DATEQTD
DATEMTD
PARALLELPERIOD
TOTALMTD
TOTALQTD
TOTALYTD
Power Query editor:
Transforming data
Perform a range of query editing skills in Power BI
Add, Merge, Delete Columns
Creating new Tables, combine or merge tables.
Shape data, using formatting and transformations.
Module 5:
Interactive Data Visualizations
Creating Power BI reports
Working on Power Custom Visuals
Working on App work Spaces
Security Set-up in workspace
App creation in Power BI
Dashboards and Tiles in Power BI Service
Content Packs
RLS Security
Managing a Power BI solution
Module 6:
Power BI mobile app
Power BI mobile apps
Using the Power BI mobile app
Power BI embedded
Power BI Web data
Get Data from Web
Creating Power BI Report based on Web data
Workspace and App creation of for the Web Report.
Power BI embedded
Marketing Analytics
Metrics in Marketing Analytics
Flow of Marketing Data
Marketing Analytics Dashboard
Finally Resume Preparation, Mock-up Interviews
Good Luck we are always here to help you.
Thanks for Attending the Course. All the Best.