Holistic BI capabilities built on an Enterprise Data Model

An Enterprise Data Model can break up data silos and promote Self-Service Business Intelligence. Power BI, XMLA.

An Enterprise Data Model (EDM) enables your organization to build a holistic and platform independent reporting ecosystem. 

Reading this article will give you an overview on why organizations often struggle with data silos and how an Enterprise Data Model can contribute to fulfill both Enterprise Business Intelligence and Self-Service Business Intelligence requirements.

But why should you avoid data silos and how can an Enterprise Data Model contribute?

Why it is important to break up with data silos

Data silos are collections of data and information that are often isolated and only accessible by individuals or certain departments of an organization which use specific technologies or tools. Sooner or later this leads to several challenges that various organizations will face. These challenges – in terms of provisioning data in a secure, timely and well governed manner - occur especially for fast growing companies that at some point are not able to provide trusted data for all departments and employees. In order to combine and report on those silos individual departments often invest in own integration or reporting solutions, which can create an additional silo on top of the existing ones.

There are several reasons why data silos occur, to name three overarching topics:  


Data silos can arise when departments are not collaborating and hence not communicating with each other in a proper way.


Departments within an organization can use various technologies and tools which are not compatible with each other.


Widespread ‘silo thinking’ in the minds of employees and absence of an organizational data- and knowledge-sharing culture.

Based on the above, data silos generate an incomplete view of the organizations business. If each department has its own data silo, it can get very challenging to retrieve trusted and well governed data - especially in case of missing or insufficient communication within the organization. 

Duplicate information between departments leads to an inefficient use of IT resources and thus also to avoidable costs. 

Storing same information in different departments can also provide inconsistent data, e.g. when an information is updated in system A while the same information in system B is not considered in the update. In case of new data source or a change in the source system, all data silos have to be adjusted accordingly, which creates additional efforts.  

To avoid data silos and the associated drawbacks, it is crucial to have a central hub for organizational data such as an Enterprise Data Model, which will be introduced in the following section.

Advantages of a central Enterprise Data Model

An Enterprise Data Model (EDM) can help with breaking up the before mentioned data silos by combining security aspects, audited calculations and trusted data sources which can be used be a variety of analytics- and visualization-tools. This helps organizations to build a well governed holistic and platform independent reporting ecosystem. 

Single Source of Truth - Central Hub for Data and Data Model

Having an Enterprise Data Model can break up data silos within the organization. In a real-world scenario a single data source is used multiple times by various users and departments to fulfill their reporting needs – sometimes even with different visualization tools. 

In many cases this also leads to duplicate data transformations within the data pipeline and the addition of key figures or metrics on top of the data source. This common scenario – which often occurs in practice - has several downsides. To name three:

  • Efforts might be multiplied as common transformations are performed multiple times – either within the reporting tool itself or sometimes in middleware applications.
  • Key Figures and metrics with the same name are calculated differently across reports which provides a non-holistic view and potential violation of corporate guidelines.
  • Administrative and maintenance efforts are not centralized – a new source system has to be integrated manually into several transformations.

An Enterprise Data Model – along with organizational governance - can help to solve those challenges and provide a holistic Single Source of Truth for corporate data sources. An EDM can help to establish data standards within the organization and enables the coexistence of both Enterprise Business Intelligence (BI) and Self-Service Business Intelligence (SSBI). Users can stick to curated data sources with verified transformations, both standardized and trusted metrics and are still free to build additional transformations or metrics to fulfill their individual reporting needs.

In summary, an Enterprise Data Model can come with a bunch of advantages, to name a few:

  • Single source of truth with verified transformations and trusted metrics 
  • Unified data governance, security and access management
  • Less administrative and maintenance effort for individual report creators and IT in the long term
  • Unified enterprise reporting experience for report consumers, by establishing and using predefined organizational standards

In the next chapter of this article we will have a focus on Enterprise Business Intelligence with Microsoft Power BI, where we will outline various use cases for Enterprise Reporting via the XMLA endpoint.

Applying an Enterprise Data Model in Power BI

How can the before mentioned advantages of an Enterprise Data Model look like when it comes to practical usage and use cases within an organization? Below we outlined practical examples from the report consumers view.

Gartner’s’ Magic Quadrant names Microsoft as a leader when it comes to Analytics and Business Intelligence Platforms. In an article by my colleague, we pointed out why. With the ability to connect to a Power BI Premium Dataset via the XMLA endpoint the platform offers huge opportunities for Enterprise Reporting and the provisioning of an Enterprise Data Model.

The Power BI Dataset – which represents the EDM in this example – can contain data of various source systems of different departments within the organization. The queries and transformations are verified, it contains validated and standardized metrics and on top of this access management is handled.

From the pure reporting perspective, this Power BI Dataset can now be used in many scenarios, as a central data source for … 

  • interactive organization wide Power BI Reports
  • pixel perfect and printable Power BI Paginated reports
  • simulation purpose via an Excel connection
  • 3rd party Analytics applications, such as Tableau

These are just a few possible scenarios to benefit from an Enterprise Data Model. The individual improvement opportunities can be identified when taking a deep look at the organizations use cases, needs and existing data and reporting landscape. As a conclusion this also leads to the point that the organizational reporting landscape can be harmonized by having a Single Source of Truth – which also provides the same view on the data across tools without any inconsistencies. 

Key Takeaways

  • Organizations are struggling with data silos and inefficiency in managing the data 
  • An Enterprise Data Model brings trust into corporate data as it enables your organization to build a holistic and platform independent reporting ecosystem 
  • An overall managed data governance also ensures quality of data 
  • Having an EDM in place, setting up a model Power BI is easier than thought  

Microsoft is continuously progressing and providing new features to its Modern Enterprise BI platform. We stay excited to follow the new features and how they can provide value for the data solutions of our customers. To learn more about the new Enterprise BI features, Microsoft presented on the Ignite, you should have a look on this article.

Stay “up-to-date” with news around Smart Data & Solutions including everything around Modern Enterprise BI by subscribing to this RSS Feed. Do not hesitate to get in touch with us for any questions.

Stay healthy.