Definitive Power BI Architecture

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours money-back guarantee* T&C applies

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours money-back guarantee* T&C applies

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month per member

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. 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.

Length: 4 Hours and 51 Minutes

$259.95
Or log in to access your purchased courses

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 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 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 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 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