Share

Delivering Great BI on a Deadline

Christopher Wagner • December 7, 2019

You gotta work!!!

Every great developer becomes saddled with an infinite demand for their work. On any given day, we are often triple, quadruple, or quintuple booked in meetings. The ability to do many things at the same time is a crucial factor in being successful. Multi-tasking in the tech field requires a deep understanding of tech and the ability to learn as you go.


The #powerbi template method pioneered by Chris Hamill at Microsoft blew me away when I first saw it a few months ago. I was infinitely more impressed yesterday when I went to try it out.


Here's what happened:


Typical Business Intelligence situation

A senior leader comes in looking for a list of challenges to some POC work done for executives, and the work needs to be done by the end of the day. For a seasoned BI Pro, it wasn't anything out of the norm and something that could be banged out without any issues.


An hour later, everything seemed done.


  • Model changes: Check.
  • New measures: Check.
  • Validation: Check.
  • Automated loads: Check.
  • Visual adjustments: Check.
  • New visuals: Check???


The new visuals introduced some challenges. The report was already bordering on having a cluttered look to it. These new charts pushed the report full into the cluttered category.


Crap.


Cluttered is no good for our executives. Something had to change fast if it was going to be delivered by the end of the day.


I made a decision to change the layout of the report radically, figuring that if the UX is good enough, then users will not require any training or additional explanations.


Over the next hour, I followed the techniques in Chris Hamill's blog posts on Background Concepts and In-Page Navigation. The process was much easier than I anticipated, and the results were far more beautiful than I had hoped.


Now the report isn't cluttered, scrolling is gone, and four huge pages are combined into a single page.


Better yet, the report was delivered on time and the new UX is a big hit with the users.


Thank you Chris Hamill!!!


I highly recommend trying these techniques out.


Background Concepts

Background Gallery

In-Page Navigation


CHRIS WAGNER, MBA MVP

Analytics Architect, Mentor, Leader, and Visionary

Chris has been working in the Data and Analytics space for nearly 20 years. Chris has dedicated his professional career to making data and information accessible to the masses. A significant component in making data available is continually learning new things and teaching others from these experiences. To help people keep up with this ever-changing landscape, Chris frequently posts on LinkedIn and to this blog.
By Christopher Wagner September 3, 2024
Your guide to becoming a Data Engineer.
By Christopher Wagner August 19, 2024
Compare Microsoft Fabric and Databricks, two leading data platforms. Highlights their features, strengths, and unique offerings across various domains like data engineering, data analytics, data science, DevOps, security, integration with other tools, cost management, and governance. Microsoft Fabric is noted for its low-code/no-code solutions and seamless integration with Microsoft tools, making it accessible for users with varying technical skills. Databricks is praised for its high-performance capabilities in big data processing and collaborative analytics, offering flexibility and control for experienced data teams.
By Christopher Wagner November 15, 2023
In a dynamic data engineering scenario, Sam, a skilled professional, adeptly navigates urgent requests using Microsoft Fabric. Collaborating with Data Steward Lisa and leveraging OneLake, Sam streamlines data processes, creating a powerful collaboration between engineering and stewardship. With precision in Azure Data Factory and collaboration with a Data Scientist, Sam crafts a robust schema, leading to a visually appealing Power BI report.
By Christopher Wagner April 28, 2023
NOTE: This is the first draft of this document that was assembled yesterday as a solo effort. If you would like to contribute or have any suggestions, check out my first public GIT repository - KratosDataGod/LakehouseToPowerBI: Architectural design for incorporating a Data Lakehouse architecture with an Enterprise Power BI Deployment (github.com) This article is NOT published, reviewed, or approved by ANYONE at Microsoft. This content is my own and is what I recommend for architecture and build patterns.
Show More
Share by: