Your cornerstone in improving data quality

The main purpose of a dashboard is to provide a comprehensive snapshot of performance, which means that you should incorporate a large amount of detail without using too many drill-downs. It uses data from the past to identify trends and patterns that can help design future process improvements.

Data Quality Dashboard is an information management tool that visually tracks, analyzes, and displays key performance indicators metrics It`s highlighting key data points to monitor the health of a business, department, or specific process. …

Implementing design thinking methodology in building BI solutions with Kanban

During five years of managing the Data quality Dashboard, we moved from a centralized old-fashioned BI tool to a modern user-centric platform that allows self-service analytics. The mission stays the same — to help improve data quality by showing relevant metrics and dashboards.

Image for post
Image for post
Photo by @benchaccounting on Unsplash

Besides the shape of the tool itself, the development process also went on a long journey. Combining design thinking, Lean and Agile is currently fundamental in the delivery process.

Why this is important:

1. Better product — Better validation with end-user

Only validated features are delivered to customers. …

Quick guide to declutter your PowerBI report

Image for post
Image for post
Photo by @benchaccounting on Unsplash Photo by

If you have a large number of measures in your report and you are running out of space this can be very helpful to clean up your report. Instead of showing a separate chart for all of your measures and cluttering your report just use SWITCH() to create a slicer that will adjust what users see on one or more charts.

It’s a common occurrence to see reports like the below where we see similar charts all in one report. It sometimes makes sense, but it does take up quite a bit of room.

To make Data Quality Analyst life easier.

A decent part of my work is dealing with Data Quality KPI`s so a lot of heat-maps, gauges, and color-coding in my reports to show pain points and weak spots and improvements.

My latest project was to create a rather straight forward request for HR data quality dashboard. Contains 18 basic checks for employees master data grouped by business country and responsible. Thresholds are the same for all checks. Not going into details here are three simple adjustments that I would love to see improved in Microsoft product.

Image for post
Image for post
Lukas Blazek on Unsplash

1. Matrix batch conditional formatting — I used a matrix to create…

The Good, The Bad and The Ugly

In this data-driven age, organizations are looking to leverage data to enhance business efficiency and effectiveness. The decision on all levels are made with the use of BI and Advanced Analytics tools, better the data better outputs those tools provide and that leads to the creation of opportunities, generating more revenue and improving operational excellence.

Garbage in Garbage out — if data you want to analyze is not accurate then it’s not useful

Image for post
Image for post
Photo by Franki Chamaki on Unplash

Here are 10 reasons why you need to keep your Data Quality in order:

1. Better strategic decisions — the higher the data quality is, the more…

Maciek Lasota

Data Quality professional. Product manager for analytics platform. Passionate for data, people and technology.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store