Arani Consulting

Email:info@araniconsulting.com

Unit 1: Introduction to Power BI

1. Business Intelligence
2. Self Service Business Intelligence
3. SSBI Tools
4. What is Power BI
5. Why Power BI?
6. Key Benefits of Power BI
7. Flow of Power BI
8. Components of Power BI
9. Architecture of Power BI
10. Building Blocks of Power BI

Unit 2: Power BI Desktop

1. Overview of Power BI Desktop
2. Data Sources in Power BI Desktop
3. Connecting to a data Sources
4. Query Editor in Power BI
5. Clean and Transform your data with Query Editor
6. Combining Data – Merging and Appending
7. Cleaning irregularly formatted data
8. Views in Power BI Desktop
9. Modelling Data
10. Manage Data Relationship
11. Cross Filter Direction
12. Create calculated tables and measures
13. Optimizing Data Models

Unit 3: Data Analysis Expressions (DAX)

1. Essential concepts in DAX
2. Why is DAX important?
3. DAX Syntax
4. Data Types in DAX
5. Calculation Types
6. DAX Functions
7. Measures in DAX
8. DAX Operators
9. DAX tables and filtering
10. DAX queries
11. DAX Parameter Naming

Unit 4: Data Visualization

1. Essential concepts in DAX
2. Why is DAX important?
3. DAX Syntax
4. Data Types in DAX
5. Calculation Types
6. DAX Functions
7. Measures in DAX
8. DAX Operators
9. DAX tables and filtering
10. DAX queries
11. DAX Parameter Naming
12. KPI Visuals
13. Z-Order

Unit 5: Introduction to Power BI Q&A and Data Insights

1. Introduction to Power BI Service
2. Dashboard vs. Reports
3. Quick Insights in Power BI
4. Creating Dashboards
5. Configuring a Dashboard
6. Power BI Q&A
7. Ask questions of your data with natural language
8. Power BI embedded

Unit 6: Direct Connectivity

1. Introduction to using Excel data in Power BI
2. Exploring live connections to data with Power BI
3. Connecting directly to SQL Azure, HD Spark, SQL Server Analysis Services/ My SQL
4. Introduction to Power BI Development API
5. Import Power View and Power Pivot to Power BI
6. Power BI Publisher for Excel
7. Content packs
8. Introducing Power BI Mobile

Unit 7: Power BI Report Servers

1. Report Server Basics
2. Web Portal
3. Paginated Reports
4. Row-level Security
5. Data Gateways
6. Scheduled Refresh
7. Resources (Rest API/ SOAP API’s/ URL Access)

Unit 8: Advanced Analytics in Power BI using R and Python

1. R Integration in Power BI Desktop
2. R visuals in Power BI
3. R Powered Custom Visuals
4. Creating R visuals in Power BI
5. R Visuals in Power BI Service
6. R Scripts Security
7. Creating visual using Python