Microsoft Power BI [BCTI]

Course Length: 1 Day

Delivered: Virtually

OVERVIEW:

In this course, students will learn to make use of the Power BI to create reports and dashboards from Power Query data.

TARGET AUDIENCE:

This course is designed for students with a sound working knowledge of Microsoft Excel and Microsoft Power Query. Power BI is a cloud based business analytics tool which provides interactive visualizations with self-service business intelligence capabilities. Using Power BI, end-users can create reports and dashboards by themselves without having to depend on information technology staff or database administrators.

COURSE OBJECTIVES:

Upon successful completion of this course, students will be able to interact with PowerBI.com and Power BI Desktop, create Power BI Data Models, manage data relationships, create and manage data model measures, identify the correct visualizations for data and add new visualizations, create and format Power BI Reports, create and share Power BI dashboards, and import queries and reports created in Excel.

COURSE CONTENT:

1 - Getting Started with Power BI

• Introduction to Power BI Online, Mobile, & Desktop
• Identifying version differences

2 - Power BI Desktop

• Installing and configuring Power BI Desktop
• Utilizing .PBIX & .PBIT files
• Examining data sources
• Understanding data types

3 - Working with CSV, TXT, and Excel Worksheets

• Importing data
• Transforming data
• Loading data
• Appending operations
• Working with folders and files
• Using Pivot Tables

4 - Connecting to Databases

• Working with relational data
• Understanding relationships
• Importing from SQL Server and examining relationships

5 - Advanced Data Manipulation

• Understanding issues with table merges
• Merging tables
• Grouping data
• Summarizing data
• Creating additional calculations

6 - Reporting

• Creating reports
• Utilizing visualizations
• Matrix, Maps, Cards, and Charts
• Utilizing Slicers