Microsoft Power BI Interactive Data Visualizations


 
Course Length: 12hrs (2 Days)
Microsoft Excel 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. This course covers both Excel Power BI Online and Power BI desktop.

Learning Objectives:
Upon completing this course students will have the ability to utilize and implement the concepts learned. Students will have a basic understanding of the below topics:
  • Power BI
  • Power BI Desktop
  • Working with CSV, TXT, and Excel Worksheets
  • Connecting to Databases
  • Merging, Grouping, Summarizing, and Calculating Data
  • Reporting
  • Power BI Online
Target Student:
This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.

Course Outline:
Section 1: Power BI
What is Power BI?
Examining Power BI Suite of Products
Identifying Differences Between Products
Understanding Power BI Updates

Section 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

Section 3: Working with Csv, Txt and Excel Worksheets
Importing Data
Transforming Data
Loading Data
Appending Operations
Working with Folders and Files
Using Pivot Tables

Section 4: Connecting to Databases
Working with Relational Data
Understanding Relationships
Importing from SQL Server Analysis Services Multidimensional and Tabular

Section 5: Merging, Grouping, Summarizing, and Calculating Data
Understanding the Issues with Merges
Performing Merges
Grouping Options
Summarizing
Calculating

Section 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

Section 7: Power BI Online
Introduction to Power BI Online
Importing Data
Creating Reports
Configuring Dashboards
Sharing Reports and Dashboards
Exploring Power BI Mobile
Microsoft Power BI Interactive Data Visualizations

Register for this class

This Course Comes With


eBook Manual

Take the manual anywhere and save the environment with an electronic copy of your training manual for use on any of your computers or devices

After Training Support

Get 30 days of live 24/7 after training support via phone, email and online chat to help apply what you’ve learned

Customize Your Course

Tailored Training

Your manual will follow a standard course outline but your class can be tailored to focus on the subjects that are most important to you

Use Your Own Files

Whether it's one-on-one or group training you can give us files to include in your training session and help you apply what you learn even more!

Also Available With This Course

Printed Manual

Instead of the PDF that comes with your course, purchase a printed paper manual for use during your class and future reference
Register for this class here
Learn more about each course here
Contact us for more information here