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.
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.
– 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.
Basic knowledge of Windows operating system and familiarity with databases and Excel.
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.
|Section 1: Introducing to Power BI|
This session introduces self-service BI with Microsoft Power BI.
· Introduction to Power BI
· Walkthrough of Power BI Key Features and Functionalities
|Section 2: Data Gathering in Power BI|
This section describes how to extract, shape and combine data from various data sources.
· Extract data from Excel Data Source.
· Extract data from SQL Server Database.
· Shaping and Combining Data.
|Section 3: Data Modeling in Power BI|
This section describes how to model data, create relationship and use of some DAX functions.
· Model Relationships.
· Introduction to DAX Queries.
· Calculations and Measures.
|Section 4: Data Visualization in Power BI|
This module describes how to visualize the modeled, shaped and clean data as dashboard or report.
· Creating PowerBI Reports.
· Upload PowerBI Reports on PowerBI Service.
· Create PowerBI Dashboard.