Power BI Data Quality

[fusion_builder_container hundred_percent=”no” equal_height_columns=”no” menu_anchor=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” id=”” background_color=”” background_image=”” background_position=”center center” background_repeat=”no-repeat” fade=”no” background_parallax=”none” parallax_speed=”0.3″ video_mp4=”” video_webm=”” video_ogv=”” video_url=”” video_aspect_ratio=”16:9″ video_loop=”yes” video_mute=”yes” overlay_color=”” video_preview_image=”” border_size=”” border_color=”” border_style=”solid” padding_top=”” padding_bottom=”” padding_left=”” padding_right=””][fusion_builder_row][fusion_builder_column type=”2_3″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” border_position=”all” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” center_content=”no” last=”no” min_height=”” hover_type=”none” link=””][fusion_text]

Build Power BI Data Quality Dashboards

Organizations continue to struggle with data quality in their applications.  Finding and cleaning core data elements can often be time consuming and difficult to organize.  Business users need an easy way to see current issues in their data as well as make changes in source applications to see the impact of data corrections.  Business Analyst can create Power BI Data Quality Dashboards directly against source data to uncover data issues.

In this Power BI Dashboard for Product Sales, I built data grids and graphs that show sales by Product Type, Retailer Type and Product Line.  Power BI automatically groups the data on the content available in the data.  Below are examples of data issues that popped out as I was building my dashboard.

Spotting Data Quality Issues

Product Type – The data shows sales for Eye wear and Eyewear, Latern and Laterns, Sun Screen and Sunscreen, and Watch and Watches.

Retailer Type – The data shows sales for Warehouse Store and Whouse Store, Outdoor’s Shop and Outdoors Shop, and Department Store and Depart Store

Product Line – The data shows sales for Mountaineering Equipment and Mountainering Equipment

For the interactive dashboard see – Power BI Data Quality Dashboard

Cleaning Up Data Quality

Users that see issues in the data through Power BI can clean up the data by creating a data feedback loop.  This loop could be users editing data in the source systems or working with IT do create processes to bulk clean up data.  Once the data is refreshed the dashboard will reflect the updates.  Data quality will improve over time by using the dashboards to make decisions.  Users will spot inaccuracies in the data such as the 2 categories of Eyewear and “Eye Wear”.

CDO Advisors Microsoft Power BI Solutions:

BI as a Service – Low Monthly Fees, Pay Per Month Per User

Executive Dashboards – Get Dashboards in 4 Weeks

Healthcare Dashboard Proof of Concept – SEE your data visualized

Microsoft Power BI Demo – Compare your current reporting to Power BI

Power BI Quick Start Solutions – Ready to start or enhance your Power BI?

Train Your Team – Remote Power BI Developer and End User Training

Use Power BI for Finance Teams – Learn how Power BI can improve operations

Virtual Chief Data Officer – Confused by all your data?  We can help

[/fusion_text][/fusion_builder_column][fusion_builder_column type=”1_3″ layout=”1_1″ background_position=”left top” background_color=”” border_size=”” border_color=”” border_style=”solid” border_position=”all” spacing=”yes” background_image=”” background_repeat=”no-repeat” padding_top=”” padding_right=”” padding_bottom=”” padding_left=”” margin_top=”0px” margin_bottom=”0px” class=”” id=”” animation_type=”” animation_speed=”0.3″ animation_direction=”left” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” center_content=”no” last=”no” min_height=”” hover_type=”none” link=””][fusion_youtube id=”https://youtu.be/wfkB-yegohI” alignment=”center” width=”” height=”” autoplay=”false” api_params=”” hide_on_mobile=”small-visibility,medium-visibility,large-visibility” class=”” css_id=”” /][/fusion_builder_column][/fusion_builder_row][/fusion_builder_container]