Course Contents

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.
Upon completing this course, learners will have a basic understanding of the topics covered in the syllabus below, as well as the ability to utilize and implement the concepts on-the-job.

Who should attend? This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.

Lesson 1: Power BI

What is Power BI?
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Updates

Lesson 2: 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 3: Working With CSV, TXT and Excel Worksheets

Importing, Transforming, and Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables

Lesson 4: Connecting to Databases

Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular

Lesson 5: Merging, Grouping, Summarizing, and Calculating Data

Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating

Lesson 6: 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 7: Power BI Online

Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile

N/A

Instructor Profile

Ritu Arora

Ritu is an expert in Microsoft Office & Power BI with core developmental skills in MS-Excel, MS-Access, VBA, Advanced Excel, RDBMS, and all other areas of data management. She has also written a book on Advance Excel 2016.