Share

Iterative Business Intelligence Development

Christopher Wagner • January 9, 2020

Business Intelligence and Agile Development go hand in hand

Earlier this week, we published the BEST way to get started in Power BI starter kit that includes:

  1. Kratos BI Data - A sample dataset used for:
    • Demo of tabular model best practices
    • Testing out DAX statements
    • New features in Power BI
  1. Kratos BI Sample Report - A sample Power BI report used for:
    • Report Best Practices
    • Layout examples
    • Examples of bookmarks
    • Examples of navigation
  1. Kratos BI Power BI Theme - A sample custom Power BI report them used for:
    • Best practice for custom Power BI theme
    • Match corporate colors
    • Consistent look and feel
    • Starter file for those new to JSON file formats
  1. Kratos BI Backgrounds - A PowerPoint file filled with sample layouts used for:
    1. Report layout best practices
    2. Report performance
    3. User understanding


The Power BI starter kit is an excellent resource for testing out new features and build out as part of writing this blog. Look for updates to this starter kit to correspond to the updates on this blog.

First Report Feedback and Updates

The feedback for the Power BI starter kit was overwhelmingly positive. Thank you.

There was some feedback on how the Kratos BI report could be improved to look better.

Alex Ooi ACMA wrote to me and offered two suggestions that were apparent improvements to the report. Thank you Alex!

Pop Up Card

Alex's first piece of feedback was on the State card that would pop-up over the map visual on the Sales page of the report.

The blue background with the black text was tough to read. Alex shared a link to a great blog he wrote on the value of color contrasts and an excellent resource for selecting colors that work well together.

Alex played with the colors a bit and eventually recommended changing the background to white. It was the easiest to read and kept the focus on the pop-up data.

Changing the pop-up card to a white background was a significant improvement (see the screenshot below).

Bubbles tickle my nose

Alex's next recommendation was to do something about the bubble charts on the detailed Reseller and Customer Sales pages. On the bubble charts, the size of the purchase and a large number of items visualized made it hard to read, select a single value, or understand if there were any patterns or outliers.

Removing the size measure increased the usability of the bubble chart. Once the change was made, individual resellers became apparent, and it was clear to see that there were growth patterns within the Value Added Resellers and the Warehouse reseller, clients.

These changes (and a few less noteworthy) have been made to the Kratos BI Sample Report and are now available for you to download.

If you have any other comments or thoughts, please let me know! I will update these materials and share with others the best practices that come from the community.

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.

Become a Data Engineer

By Christopher Wagner • September 3, 2024
Your guide to becoming a Data Engineer.

Microsoft Fabric vs Databricks

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.

Data Wizardry and Epic Adventures: A Day in the Life of a Microsoft Fabric Engineer

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.

Power BI usage scenarios: Lakehouse to Power BI

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: