Microsoft® Power BI Course
Course Details
Session: 2 Days
Hours: 8 Hours /Day
Mode: Face to Face / online
Where
Dubai
United Arab Emirates
Microsoft® Power BI Course
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals.
Course Outline
Lesson 1: Course Overview
Lesson 2: Power BI
• What is Power BI?
• Examining Power BI Suite of Products
• Identifying Differences Between Products
• Understanding Power BI Updates
Lesson 3: Power BI Desktop
• Installing Power BI Desktop
• Exploring the Power BI Desktop Interface
• Utilizing File Types; PBIX vs PBIT
• Examining Data Sources
• Discussing Data Refresh
• Understanding Data Types
Lesson 4: Working With CSV, TXT and Excel Worksheets
• Importing, Transforming, and Loading Data
• Appending Operations
• Working with Folders and Files
• Using Pivot Tables
Lesson 5: Connecting to Databases
• Working with Relational Data
• Understanding Relationships
• Importing from SQL Server Analysis Services Multidimensional and Tabular
Lesson 6: Merging, Grouping, Summarizing, And Calculating Data
• Understanding the Issues with Merges
• Performing Merges
• Grouping Options
• Summarizing
• Calculating
Lesson 7: Reporting
• Creating Reports
• Utilizing the Matrix Visualization
• Utilizing the Map Visualization
• Utilizing the Card Visualization
• Utilizing the Chart Visualization
• Utilizing Slicers
• Publishing to Power BI Online
Lesson 8: Power BI Online
• Introduction to Power BI Online
• Importing Data
• Creating Reports
• Configuring Dashboards
• Sharing Reports and Dashboards
• Exploring Power BI Mobile
Training Method
The training will be conducted in a friendly, inclusive and professional atmosphere, which is conducive for different learning styles, but respects each attendee as an individual and ensures each one is challenged and achieve maximum benefit from the course. Our goal is that attendees will be highly engaged and encouraged to be participative.
Book your place
Microsoft® Power BI Course