[Kurz] Program kurzu (obsah přednášky/semináře/rekvalifikace/studia) ...
Goals After completing this course, students will be able to:
- Describe key features of a self-service BI solution
- Describe Power BI and its data sources
- Model, shape, and combine data
- Describe Power BI data visualizations
* After completing this course, students will be able to:
- Describe key features of a self-service BI solution
- Describe Power BI and its data sources
- Model, shape, and combine data
- Describe Power BI data visualizations
Outline Module 1: Introduction to Self-Service BI Solutions In this module students will be introduced to the key concepts in business intelligence, data analysis, and data visualization. In addition they will lea> 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 solution After 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 solution
Module 2: Introducing Power BI This module introduces Power BI. Lessons
Power BI The Power BI service Power BI mobile apps Lab : Cresting a Power BI dashboard After 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 dashboard
Module 3: Power BI Data This 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 BI After 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 Service
Module 4: Shaping and Combining Data This module describes how to shape and combine data. Lessons
Power BI desktop queries Shaping data Combining data
Lab : Shaping and combining data After completing this module, you will be able to:
- Create Power BI Desktop queries
- Shape data
- Combine data
Module 5: Modelling Data This module describes how to model data in Power BI. Lessons
Relationships DAX queries Calculations and measures
Lab : Modelling data After completing this module, you will be able to:
- Configure the Power BI Service
- Create Relationships
- Write simple DAX queries
- Create calculations and measures
Module 6: Interactive Data Visualizations This module describes Power BI visua