From the course: Power BI: Dashboards for Beginners

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Create safeguards by assuring data quality

Create safeguards by assuring data quality

From the course: Power BI: Dashboards for Beginners

Start my 1-month free trial Buy for my team

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…

Contents