Project Summary

Power BI Data Model Builds Better and More Accurate Reports

Power BI Data Model Builds Better and More Accurate Reports

A major Canadian University had contacted Imaginet because they needed reports built on top of an existing data warehouse. This is a long-term client of Imaginet’s, and we had previously built a data warehouse for another department within the organization. Much of the work for this project was about defining the semantic data model on top of the data warehouse and then building the reports on it.  

Before they had a data warehouse, they had multiple applications that were reporting data separately. Since the implementation of the data warehouse, the client wanted to use Power BI as a standard enterprise reporting portal.  

Our Solution 

We started with creating views in the SQL data warehouse, then created a Power BI semantic model by importing the data through the views and specifying how those views related. The semantic model used business names for the tables and columns and hid any names that were only there for internal system purposes. This created a model that was easy to understand by business users and report authors who understood the business terms rather than the system or programmatic, technical terms. In the semantic model, we specified the measures that correctly summarized the numerical data in the model – for metrics like Head Counts (of instructors, courses, or students), and more complex calculations like percentages, derivations from targets, and time-intelligence measures (Year To Date measure that accumulate metrics for the year, or Previous Year metrics that compare a metric from one time period to another).  

When the semantic data model is published in Power BI, then reports in Power BI are created from that semantic model to create visuals their desired KPIs and metrics.  

We had taken on work from a previous vendor, which required us to determine what had already been done and what additional data and metrics needed to be added to the semantic model.  

We ensured it was secure by implementing row-level security that allowed only relevant people the ability to view certain data reports.

Power BI Data Model
Power BI Data Model

The Benefit 

The greatest benefit of this project is the client now has a Power BI semantic model that is clear, concise, and easily consumable by report authors and data analysts, and we can create reports that meet their needs quickly and easily with accurate data and saving valuable organizational resources. Additionally, with the previous vendor, our client was not seeing the outcomes they desired. With our help, we were able to provide them with a beneficial solution that lived up to their standards. The competence of Imaginet’s Data Engineering team allowed them to quickly see positive results. 

Our team has been working hard these last few months, and we are excited to share our success with you. Don’t forget to subscribe to our newsletter to stay updated on our most recent Microsoft 365 projects. Fill out the form at the bottom of the page if your data is unreliable, you want to upgrade your data factory, or your data is difficult to manage.    

Technologies Used

Power BI Data Model

discover more

New Application Development Projects Enhance Resource Management 

Imaginet Resources CorpApr 11, 20243 min read

A telecommunications organization contacted Imaginet for assistance on 2 new application development projects. The first was a portfolio tracker, and the second was an office furniture ordering application.    Portfolio Tracker    The portfolio tracker we built for our client tracks and…

QR Code Phishing Attacks: Are You Protected?

Carlos TansecoApr 9, 20244 min read

QR Code Phishing Attacks: Are You Protected?  April 09, 2024 QR code phishing attacks or “Quishing” are on the rise, and it’s crucial to raise awareness about this evolving threat. Scanning these codes has become second nature to many of…

Virtual Workspaces Are Here! How Will You Use Them? 

Chris PowellApr 4, 20248 min read

Virtual Workspaces Are Here! How Will You Use Them?   April 4, 2024 My YouTube feed has been full of reviews of the Apple Vision Pro since it became available in the US on February 2. In one of the videos,…

Let’s Build Something Amazing Together

From concept to handoff, we’d love to learn more about what you are working on.
Send us a message below or drop us a line at 1-800-989-6022.