Over the past few months, I had the pleasure of working on an innovative case wherein we wanted to migrate our analytics reports from the Oracle Business Intelligence Suite, Enterprise Edition (OBIEE) platform to the Power BI model.
As the world is moving towards a data-driven culture, Power BI offers powerful analytics and rapid visualization features for organizations. With its powerful self-service abilities, business users are no longer dependent on IT service providers for extracting, transforming, and analyzing data.
The journey we took to migrate our existing OBIEE model to Power BI was challenging but at the same time exciting.
Following are some of the major challenges we faced during the migration:
Architecture for Power BI
In an enterprise environment, the volume of data is huge. Power BI (without Power BI Premium) only allows up to 1GB size of the model, which may not be enough for business users. Our client already had a data model and data warehouse in place with a huge volume of data. After taking into consideration the existing data model, volume of data, and customer requirements, we came up with following architectural model for our client.
Data from various sources and stored in various databases cannot be used directly for visualization. Data warehouses are central repositories of consolidated data from multiple sources. To integrate and process the data from disparate sources, ETL (extract, load, transform) tools are used. In our project, we used the SSIS (SQL Server Integration Services) ETL tool.
In the architecture for enterprises, SSAS plays an important role. By using state-of-the-art compression algorithms and multi-threaded query processors, the Analysis Services Vertipaq analytics engine delivers fast access to tabular model objects and data by reporting client applications like Power BI and Excel.
Power BI Report Server
Power BI Report Server is the on-premise solution for reporting today, with the flexibility to move to the cloud tomorrow. It is included with Power BI Premium, so you can move to the cloud on your terms. In an organization, Power BI report server can be used to:
Power BI Reports
A Power BI report is a multi-perspective view into a dataset with visuals that represent different findings and insights from that dataset. A report can have a single visual or pages full of visuals.
The key benefits of Power BI are:
In this post, you will learn about implementing the Power BI architecture for an enterprise environment using components such as SSAS and Report Server. Report Server is an on-premises report server. You can create reports in Power BI Desktop or Pro, and viewers can use Report Server to access those reports on a web browser or mobile device, or receive them through email. With SSAS Tabular, there is no hard limit on the dataset size.