Learn about the course structure and agenda in this module
Definitive Power BI Architecture
This training is designed for data architect or administrator, who is designing the architecture of leveraging Power BI in a solution. Someone who wants to understand how all components of Power BI are sitting beside each other to build the whole solution. This training is designed for understanding the strategy of using Power BI rather than the development of it.
In this training, you will learn about architecting the strategy of a Power BI solution from end to end. This is not training about development (Modules 1 to 3 already covered that). You do not need to watch previous modules to attend this course. This course is designed separately from those. However, knowing some of the basics of Power BI is helpful.
You will learn about Power BI Service, and different types of connections in Power BI and choose the right type of connection for your solution. You will also learn all different ways of sharing a Power BI Solution and the pros and cons of each. The course continues with a detailed discussion about row-level security. You will learn how gateway configuration and set up will be in the whole package. You will also learn about integrating Power BI with other tools, and some architecture blueprints to follow when you are designing a Power BI solution.
At the end of this training, you will be able to design the architecture of Power BI for your requirement; you can choose the right way of sharing and design the gateway configuration as well as the communication of Power BI with other tools and services. You will be able to answer any questions that come to your mind about a solution architecture in Power BI world and make the right decision to choose the right strategy of Power BI usage in your organization.
Modules
Module 1: Power BI Components
There are many components and tools in the Power BI ecosystem. In this module, you will learn about all tools and services, and how they work with each other to build a Power BI solution. This module is an overview of Power BI tools and services.
Lessons
Module 2: Connection Types
One of the first and foremost decisions you need to make before starting your Power BI implementation is choosing the right type of connection. In this module you will learn about connection types such as Import Data, DirectQuery, Live Connection, and Composite Mode. You will learn pros and cons of each module, and where and when to use each for different architectures for Power BI implementation.
Lessons
Module 3 : Gateway
If your Power BI report is using an on-premises data source, you will need a component called Gateway. In this module, you will learn what is the gateway, how to install and configure it, and how to connect it to a dataset so that you can get your data refreshed from a local domain data source.
Lessons
Module 4: Dataflow and Shared Dataset; a Power BI Architecture
Dataflow and shared datasets are two important objects in building a multi-developer and low-maintenance Power BI architecture. In this module you will learn what are challenges in a multi-developer environment for Power BI, and how dataflow and dataset can help in overcoming those and building an architecture that works in many Power BI implementations.
Lessons
- Module 4: Lesson 1 – Challenges of a Single Power BI Solution
- Module 4: Lesson 2 – What is the Dataflow and the Use Cases of it
- Module 4: Lesson 3 – How to Create a Dataflow and Use it in Power BI Datasets
- Module 4: Lesson 4 – Shared Dataset
- Module 4: Lesson 5 – The Multi-Developer Architecture
- Module 4: Lesson 6 – Dataflow Vs Dataset
Module 5: Sharing
There are many sharing methods for Power BI content. In this module, You will learn seven different methods of sharing the Power BI content, Each method is explained with details and pros and cons. At the end there is a lesson that helps you to choose the right method of sharing for your organization. Methods such as workspace, Power BI app, Embedded, Publish to Web etc are all discussed in this module.
Lessons
- Module 5: Lesson 1 – Basic Sharing of Dashboard and Reports
- Module 5: Lesson 2 – Workspaces and Role Setup
- Module 5: Lesson 3 – Power BI Apps – Ultimate Sharing Experience for End Users
- Module 5: Lesson 4 – Publish to Web – The Only FREE method of sharing
- Module 5: Lesson 5 – Embed in SharePoint Online
- Module 5: Lesson 6 – Secure Embed in any website or portal
- Module 5: Lesson 7 – Power BI Embedded
- Module 5: Lesson 8 – Choosing the Right Sharing Method
Module 6: Security
Securing the content so that everyone see their own data is another important aspect of a Power BI solution. As an architect, you will see what are possible, and how the Power BI solution can show the content that the user is authorized to see. This module won’t discuss the development aspects of row-level security, but will explain it in an architecture level. You will learn about static vs dynamic row-level security, and some of the possible patterns of it.
Lessons
Module 7: Administration
In the Power BI service, there are a few different admin roles, You will learn in this module about their difference, and what is the Power BI tenant admin. You will learn what are important tenant settings that an admin should be aware of it. You will learn about some specific access and features that an admin can work with.
Lessons
Module 8: Integration
Power BI can integrate with many other tools and services. In this module, you will learn how Power BI works with PowerPoint, Excel, other third party tools, Paginated reports, and REST API functionality of Power BI.
Lessons
Module 9: Power BI On-premises, Power BI Report Server
If you intend to use Power BI, but for any reason can’t move to cloud yet, there is fully on-premises solution for you with Power BI, called Power BI Report Server. In this module, you will learn about the report server, how it works, and how it is different from Power BI service.
Lessons
Module 10: Licensing
Licensing in Power BI can be confusing. There are multiple options, per user options which are free and pro, and capacity based licensing which includes embedded and premium. This wide variety makes it often hard to decide what is the best and the most cost-effective option for your Power BI implementation. This module explains all the licensing options, and their differences and helps you to decide to choose the best plan for your implementation.
Lesson
Module 11: Architecture Blueprints
Throughout this course, you learned some architecture advises for sharing, multi-developer approach, enterprise usage of Power BI, and self-service. This last module is a quick summary of those as blueprints.