MICROSOFT POWER BI

Duration: 3 Days

OVERVIEW

Learn how to create, control and present you report professionally with Microsoft Power BI.

AUDIENCE:

The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.

SOFTWARE REQUIREMENT:

Each computer will need to have the following software installed. Unless otherwise specified, the software should be full licensed versions.

• Microsoft® Windows® 10
• Microsoft .NET version 4.5
• Microsoft® 365 Business Premium (Trial)

METHODOLOGY:

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

COURSE OBJECTIVES:

• Analyze data with self-service BI.
• Connect to data sources.
• Perform data cleaning, profiling, and shaping.
• Visualize data with Power BI.
• Enhance data analysis by adding and customizing visual elements.
• Model data with calculations.
• Create interactive visualizations.

Upon completion, participants will be able to perform related topics covered and easily collaborate with work colleagues and related parties.

Module 1 – Introducing Power BI

• Getting started with Power BI
• Uploading data to Power BI
• Introducing natural-language queries
• Introducing Quick Insights
• Introduction to reports
• Introducing Visual Interactions
• Decorating the report
• Saving the report
• Pinning a report
• Refreshing the budget workbook
• Filtering a report

Module 2 – Sharing The Dashboard

• Inviting a user to see a dashboard
• Inviting users outside your organization
• Creating a group workspace in Power BI
• Turning on sharing with Microsoft OneDrive for Business
• Viewing reports and dashboards on mobile devices

Module 3 – Understanding Data Refresh

• Introducing data refresh
• Introducing the Power BI refresh architecture
• Introducing Power BI Desktop
• Publishing to Power BI
• Installing the Power BI Personal Gateway
• Configuring automatic refresh

Module 4 – Using Power BI Desktop

• Connecting to a database
• Loading from multiple sources
• Using Query Editor
• Hiding or removing tables
• Handling seasonality and sorting months

Module 5 – Getting Data From Services And Content Packs

• Consuming a service content pack
• Creating a custom dataset from a service
• Creating a content pack for your organization
• Consuming an organizational content pack
• Updating an organizational content pack

Module 6 – Building A Data Model

• Loading individual tables
• Implementing measures
• Creating calculated columns
• Improving the report by using measures
• Integrating budget information
• Reallocating the budget

Module 7 – Improving Power BI Reports

• Choosing the right visualizations
• Choosing between standard visuals
• Using custom visualizations
• First steps with custom visualizations
• Improving reports by using custom visualizations
• Identifying conditions when custom visualizations are required
• Using DAX in data models
• Creating high-density reports

Module 8 – Using Microsoft Power BI In Your Company

• Getting data from existing systems
• Understanding differences between data refresh and live connections
• Using relational databases on-premises
• Using relational databases in the cloud
• Using live connections to Analysis Services
• Integrating Power BI with Office
• Publish Excel data models in Power BI
• Consume Power BI content from Excel
• Using Power BI Tiles from Office Store
• Managing security to access data
• Using row-level security
• Extending and customizing Power BI
• Creating custom visualizations for Power BI
• Introducing the Power BI REST API
• Pushing real-time data to Power BI dashboards
• Power BI embedded in applications