- Module 1: Learn how to become a solution architect.
In this module, you will:
- Learn about what is expected of a solution architect.
- Learn about the role of a solution architect during the project phases.
- Module 2: The process of creating a complicated data model in Power BI is straightforward. If your data is coming in from more than one transactional system, before you know it, you can have dozens of tables that you have to work with. Building a great data model is about simplifying the disarray. A star schema is one way to simplify a data model, and you learn about the terminology and implementation of them in this module. You will also learn about why choosing the correct data granularity is important for performance and usability of your Power BI reports. Finally, you learn about improving performance with your Power BI data models.
In this module, you will:
- Create common date tables
- Configure many-to-many relationships
- Resolve circular relationships
- Design star schemas
- Module 3: In this challenge project, you are creating your own solutions to the stated problems for a customer. You are analyzing and architecting solutions based on a series of sheets in a planning workbook.
In this module, you demonstrate your ability to:
- Choose a customer based on a provided industry
- Get to know the customer
- Evaluate the current state of technology
- Compare to the stated needs
- Perform discovery and planning exercises
- Complete the project workbook
Validate your Microsoft Power Platform Solution Architect skills
Overview
Syllabus
- Module 1: Module 1: Becoming a solution architect for Dynamics 365 and Microsoft Power Platform
- Introduction to becoming a solution architect
- Existing product and platform skills
- Expectations of a solution architect
- Solution architect role during project phases
- Pillars of a great architecture
- Check your knowledge
- Summary
- Module 2: Module 2: Design a data model in Power BI
- Introduction
- Work with tables
- Create a date table
- Work with dimensions
- Define data granularity
- Work with relationships and cardinality
- Resolve modeling challenges
- Exercise - Model data in Power BI Desktop
- Check your knowledge
- Summary
- Module 3: Module 3: Challenge project - Create Microsoft Power Platform solutions
- Introduction
- Prepare
- Exercise - Create solutions for customers using Power Platform
- Knowledge check
- Summary
