PowerBI Topics:
- Business Intelligence
- Self Service Business Intelligence
- SSBI Tools
- What is Power BI
- Why Power BI?
- Key Benefits of Power BI
- Flow of Power BI
- Components of Power BI
- Architecture of Power BI
- Building Blocks of Power BI
Power BI Desktop
Learning Objective: This module will introduce you to Power BI Desktop. You will know how to extract data from various sources and establish connections with Power BI Desktop, perform transformation operations on data and the Role of Query Editor in Power BI.
Topics:
- Overview of Power BI Desktop
- Data Sources in Power BI Desktop
- Connecting to a data Sources
- Query Editor in Power BI
- Clean and Transform your data with Query Editor
- Combining Data – Merging and Appending
- Cleaning irregularly formatted data
- Views in Power BI Desktop
- Modelling Data
- Manage Data Relationship
- Cross Filter Direction
- Create calculated tables and measures
- Optimizing Data Models
Data Analysis Expressions
Learning Objective: This module will help you learn the basics of DAX in Power BI Desktop.
Topics:
- Essential concepts in DAX
- Why is DAX important?
- DAX Syntax
- Data Types in DAX
- Calculation Types
- DAX Functions
- Measures in DAX
- DAX Operators
- DAX tables and filtering
- DAX queries
- DAX Parameter Naming
Data Visualization
Learning Objective: This module will help you understand the benefits and best practices of Data Visualization. It will also help you in creating charts using Custom Visuals.
Topics:
- Introduction to visuals in Power BI
- Charts in Power BI
- Matrixes and tables
- Slicers
- Map Visualizations
- Gauges and Single Number Cards
- Modifying colors in charts and visuals
- Shapes, text boxes, and images
- What Are Custom Visuals?
- Page layout and formatting
- KPI Visuals
- Z-Order
Introduction to Power BI Q&A and Data Insights
Learning Objective: This module will help you in creating Dashboards and publishing it on Power BI services. You will also be taught to monitor Real-time Data with REST API.
Topics:
- Introduction to Power BI Service
- Dashboard vs. Reports
- Quick Insights in Power BI
- Creating Dashboards
- Configuring a Dashboard
- Power BI Q&A
- Ask questions of your data with natural language
- Power BI embedded
Direct Connectivity
Learning Objective: This module will help you learn, how to connect data sources directly to Azure, HD Spark, My SQL, and create interactive dashboards.
Topics:
- Introduction to using Excel data in Power BI
- Exploring live connections to data with Power BI
- Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
- Introduction to Power BI Development API
- Import Power View and Power Pivot to Power BI
- Power BI Publisher for Excel
- Content packs
- Introducing Power BI Mobile
Power BI Report Servers
Learning Objective: This module will help you understand about Power BI Report Servers and data gateways. Also, you will learn about the web portal in which you display and manage reports and KPI’s.
Topics:
- Report Server Basics
- Web Portal
- Paginated Reports
- Row level Security
- Data Gateways
- Scheduled Refresh
- Resources (Rest API/ SOAP API’s/ URL Access)
Advanced Analytics in Power BI using R & Python
Learning Objective: This module will help you create R and Python visuals in Power
BI Desktop as well as in Power BI Service.
Topics:
- R Integration in Power BI Desktop
- R visuals in Power BI
- R Powered Custom Visuals
- Creating R visuals in Power BI
- R Visuals in Power BI Service
- R Scripts Security
- Creating visual using Python