Importing Data into Power BI
Now that we understand the importance of cleaning data and even how to tackle some of the most common data-cleaning operations, it’s time to start bringing some data into Power BI.
When it comes to importing data into Power BI, there are six main topics, as listed next, to consider. Most importantly, for the top three, there are metrics that help us identify how clean data is prior to us working on it. In this chapter, you will learn about these topics and how you can use the Power BI platform to assess these metrics within your own data.
Specifically, we will be going through the following topics:
- Understanding data completeness
- Understanding data accuracy
- Understanding data consistency
- Assessing data relevance
- Assessing data formatting
- Assessing data normalization, denormalization, and star schemas
By the end of this chapter, you will be able to confidently assess how clean the data you’ve imported...
