From the course: Power BI: Dashboards for Beginners
Join today to access over 24,000 courses taught by industry experts.
Create safeguards by assuring data quality
From the course: Power BI: Dashboards for Beginners
Create safeguards by assuring data quality
- [Narrator] When it comes to creating dashboards, there's nothing worse than getting to the end of your project only to realize that the data just doesn't look right. So if data quality is going to be an issue, isn't it better that we apply some basic checks early on in the piece? What you're looking at here is a Power BI model that already has a data connection, and we can check this by clicking on the table view icon on the left-hand side of the screen. Now when it comes to data integrity, it isn't possible to check for everything at this stage, but it can certainly help with identifying some obvious things, firstly, structure. Reliable data is neatly organized into rows and columns, such as this one here. If data doesn't look organized, then just avoid using it. Next, data gaps. If you scan through the data and see a bunch of blanks in our records, then this could be a red flag that something isn't right. Fortunately, in this case, there doesn't appear to be any. Lastly, let's…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.