MICSOFT POWER BI TRAINING

Power BI Training Header-01

Synopsis

Every business today requires extensive insights into their business, yet the staggering amount of data that most businesses generate makes this extremely challenging. Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

This course provides participants with the knowledge and skills to analyze data using Power BI.

Course highlight

Participants will experience hands-on how to build powerful Power BI dashboards with interactive data visualizations. The class will discuss and learn from real world challenges of developing and deploying a Power BI solution with the help of an experienced instructor with many years of professional experience.

– What You Will Learn

• Introduction to Power BI
• Connecting Power BI to a variety of data
• Creating a Power BI dashboard
• Shape and Combine data with Power Query
• Date modelling in Power BI
• Creating Power BI reports
• Deploying and Managing a Power BI solution

– Who Should Attend?

Business users and data professionals who need to analyze data using Power BI. This course is also suitable for anyone who wants to learn about Power BI from scratch, or who has some experience with Power BI but wants to learn how to leverage the full potential of Power BI.

– Prerequisites

Basic knowledge of Windows operating system and familiarity with databases and Excel.

Course Methodology

The course is presented in a classroom environment, with practical demonstrations to illustrate the concepts taught. The concepts are then reinforced through hands-on computer lab exercises with examples of how they are applied in real world situations.

Course Duration

2 days, 9:30 am – 5:00 pm

Course Structure

– Introduction to Power BI

• Introduction to self-service business intelligence
• Introduction to data analysis and data visualization
• Power BI Overview
• Exploring the parts of Power BI

– Lab Exercise

• Sign up for Power BI
• Import a sample Content Pack
• Explore the Power BI Service

– Transforming and Modelling Data

• Getting data into Power BI
• Cleaning and transforming data
• Introduction to data modelling and relationships
• Working with calculated columns and measures

– Lab Exercise

• Import data from Access
• Import CSV data from a folder
• Import Excel data
• Manage table relationships
• Create calculated columns and measures
• Optimize the data model

– Creating Power BI Reports

• Creating and formatting visualizations
• Formatting and filtering data
• Walkthrough of Power BI visual templates
• Editing interactions
• Hierarchies and drill downs
• Optimizing reports for phone apps

– Lab Exercise

• Create a cross-tabular report
• Create a relationship report
• Edit interactions in a report
• Create a trend report
• Create a ranking report

– Managing a Power BI Solution

• Publishing reports
• Creating dashboards
• Sharing and unsharing
• Refreshing data
• Setting alerts

– Lab Exercise

• Publish a Power BI report
• Create and share a dashboard
• Schedule data refresh