Microsoft Power Business Intelligence (BI) Training
Secure enrollment now
Syllabus
Introduction to Power BI
- 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
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 (DAX)
- 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
- 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
- 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
- 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
- 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
Advanced Analytics in Power BI using R & Python
- 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
Complimentary sessions on communication presentation and leadership skills.
Benefits from the course
Mode of Teaching
Live Interactive
- Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information technology staff or database administrator.
- Power BI provides cloud-based BI services - known as Power BI Services, along with a desktop-based interface called Power BI Desktop. It offers Data modelling capabilities including data preparation, data discovery and interactive dashboards.
Prerequisite:
- Fundamental understanding of Microsoft Excel and formulas
Prerequisites
- Fundamental understanding of Microsoft Excel and formulas.
Course Duration:
27 Hours
Class Hours:
2 Hours Day time slots or 3 Hours week end Slots (May change)