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. …
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.
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. …
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.
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.
1. Matrix batch conditional formatting — I used a matrix to create…
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
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…
Data Quality professional. Product manager for analytics platform. Passionate for data, people and technology.