A provincial agricultural services corporation was experiencing challenges with its reporting solution. They were starting to use Power BI to replace operational reports that had previously used data from a DB/2 operational database. With data often duplicated and limited staff available to manage the data, they were encountering bottlenecks and governance issues. The client re-engaged Imaginet to help their team re-design their data analytics model and processes.
The client’s approach to replacing their existing reports with Power BI was to build each report with its own dataset from their new operational data store (ODS), which was now hosted in a SQL database. This led to many silos of similar data across multiple reports, and an inefficient report authoring process that did not easily reuse the data across multiple reports.
Imaginet’s approach was to build shared datasets in Power BI with multiple subjects, in a star-schema design with fact and dimension tables in Power BI that made it much easier to build many different reports. We showed how datasets can be endorsed in Power BI so they can be seen as having high quality and trustworthiness within the organisation. We added these shared datasets to source control to handle change tracking and provide a history of changes.
With the new solution, Power BI reports can be built from these endorsed datasets, and the business logic and data in the endorsed datasets is now consistently used. We configured Power BI in PowerPoint, drill through and drill down in reports, various buttons in reports, Role-based security, synonyms Q&A, and Power BI apps for collaboration with colleagues. The client can create personalized reports and subscribe to a specific report or dashboard in Power BI.
To ensure that reports had a consistent brand image, we created a style/theme document that formats elements like header alignment, decimal places, buttons, and colour sets for reports, saving the team hours of formatting work.
With the updated solution, the client can work with their data inside Power BI. Users can build reports themselves instead of waiting for IT team members to send them. The client’s data is trustworthy, with proper documentation and change tracking to keep things in check.
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 you would like to work with us and someone will be in touch.
A major Canadian oil & gas company reached out to Imaginet to rewrite some of the old infrastructure they currently had in place and pursue an Azure Data Factory migration. Imaginet had built their data warehouse 10 years ago, but…
Customized Modern Search Experiences with PnP Search Web Parts November 23, 2023 Today, PnP Search is often used in SharePoint to create customized search pages and result displays. This results in a fully custom modern search experience. It is equipped…
A leading real estate and financial services asset management company needed assistance migrating their legacy on-premises data environment that had become difficult to manage. Some key parts of the legacy system relied on Microsoft Excel and a web application. Loading…
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.