Analyzing Data with PowerBI
Days 2 Code 10989 Fee £990
This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.
Course Details
This two-day instructor-led course provides students with the knowledge and skills analyze data with Power BI.
Prerequisites
This course requires that you meet the following prerequisites:
-
Basic knowledge of the Microsoft Windows operating system and its core functionality.
-
Some exposure to basic programming concepts (such as looping and branching).
-
Familiarity with Microsoft Office applications – particularly Excel.
-
Basic knowledge of data warehouse schema topology (including star and snowflake schemas).
-
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
Course Outline
Module 1: Introduction to Self-Service BI SolutionsIn this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will learn the rationale for self-service BI, considerations for using self-service BI, and how Microsoft products can be used to implement a self-service BI solution.Lessons
- Introduction to business intelligence
- Introduction to data analysis
- Introduction to data visualization
- Overview of self-service BI
- Considerations of self-service BI
- Microsoft tools for self-service BI
Lab : Exploring an enterprise BI solutionAfter completing this module, you will be able to:
• Describe key concepts in business intelligence
• Describe key concepts in data analysis
• Describe key concepts in data visualization
• Describe the rationale for self-service BI
• Describe considerations for self-service BI
• Describe how Microsoft products can be used to implement a self-service BI solutionModule 2: Introducing Power BIThis module introduces Power BI.Lessons
- Power BI
- The Power BI service
- Power BI mobile apps
Lab : Cresting a Power BI dashboardAfter completing this module, you will be able to:
• Describe Power BI
• Describe the Power BI Service
• Implement Tenant Management
• Describe Power BI mobile apps
• Create a simple dashboardModule 3: Power BI DataThis module describes Power BI data sources.Lessons
- Using Excel as a Power BI data source
- Using databases as a Power BI data source
- The Power BI service
Lab : Import data into Power BIAfter completing this module, you will be able to:
• Use Excel as a Power BI data source
• Use databases as a Power BI data source and describe the R language
• Configure the Power BI ServiceModule 4: Shaping and Combining DataThis module describes how to shape and combine data.Lessons
- Power BI desktop queries
- Shaping data
- Combining data
Lab : Shaping and combining dataAfter completing this module, you will be able to:
• Create Power BI Desktop queries
• Shape data
• Combine dataModule 5: Modelling DataThis module describes how to model data in Power BI.Lessons
- Relationships
- DAX queries
- Calculations and measures
Lab : Modelling dataAfter completing this module, you will be able to:
• Configure the Power BI Service
• Create Relationships
• Write simple DAX queries
• Create calculations and measuresModule 6: Interactive Data VisualizationsThis module describes Power BI visualizations.Lessons
- Creating Power BI reports
- Managing a Power BI solution
Lab : Creating a Power BI reportAfter completing this module, you will be able to:
• Use Power BI Desktop to create interactive data visualizations
• Describe the management of a Power BI solution