Power BI is a business analytics service tool by Microsoft. It aims to supply interactive visualisations and business intelligence capabilities with an interface simple enough for end users to make their own reports and dashboards. It also can be used for exploratory data analysis. Web automation that imports CSV to Salesforce. Business Intelligence Master Program aims with Business Intelligence and Analytics, organisations can convert data into useful business insights.
It provides exposure to relevant tools like SQL, Data Warehousing, Informatica, Microsoft BI Vs Tableau.
What are the prerequisites for taking up this Power BI course?
Any Graduate/Any Post-Graduate
Freshers/Working Professionals
Course Duration:
90 hrs
What will you learn in this Power BI training?
Perform Power BI desktop data transformation.
Describe Power BI desktop modelling.
Implement the Power BI service.
Connect directly to data stores.
Describe the Power BI developer API.
Curriculum:
Introduction to Power BI
Introduction to Data warehouse
Data warehouse Tools
What is Power BI?
Power BI – Flow of Activity
Building Blocks of Power BI
Power BI – Primary Tools : Power Pivot, Power Query,
Power View, Power Map, Power Q&A, Power BI Desktop
Power BI Desktop
Power BI Desktop – Install
Data Sources and Connections
Connect to Data in Power BI Desktop
How to use Query Editor in Power BI
Advanced Data Changes and Transformation
Views in Power BI Desktop
Modeling Data – Manage Data Relationship,
Create Calculated Columns, Optimise Data Models
Data Analysis Expressions (DAX)
What is DAX?
Data Types in DAX
Calculation Types
DAX Functions : Date and Time, Time IIntelligence,
Information, Logical, Mathematical, Statistical, Text,
Aggregate Measures in DAX
Table Relationships and DAX
Data visualisation
Why Data Visualization
Practices for Data Visualization
How to use Visual in Power BI
Reports in Power BI
Charts in Power BI (Scatter, Waterfall, Funnel)
Slicers
Map Visualisations
Gauges and Single Number Cards
Custom visualisations
What Are Custom Visuals?
Ofce Store
Downloading Custom Visuals
Importing Custom Visuals in Power BI Report
KPI Visuals
Data Binding in Power BI
Power BI Integration page And Administration
Data Gateways
Content packs
Power BI Report Server
Power BI Embedded
Power BI Embedded Conceptual Model
Workspace Collection
Adding Power BI content to a Workspace
Application Authentication Tokens
Parts of Power BI embedded – REST API
Power BI Embedding without an Embed Token
Power BI Embedding with an Embed Token
Power BI Q&A
Power BI Q&A
Dashboard
Dashboard vs Reports
Creating a Dashboard
Dashboard Tiles
Pinning Tiles
Quick Insights with Power BI
Power BI Publisher for Excel
