Chapter 3

Prepping Data for Visualization

IN THIS CHAPTER

Bullet Defining the types of data sources Power BI supports

Bullet Exploring how to connect and configure data sources in Power BI

Bullet Working with shared datasets

Bullet Importing and connecting to datasets

Bullet Finding and working with common data sources

Bullet Identifying cleansing needs based on anomalies, properties, and data quality issues

Enterprise software vendors such as Microsoft have built data source connectors to help organizations import data into applications such as Power BI. You quickly realize that connecting to data sources isn’t necessarily the tricky part — it's often the data transformation that takes a bit of time. After you figure out which method is best to prep and load the data into Power BI, you're well on your way to analyzing and visualizing the data in your universe.

In this chapter, you discover the methods you can apply to prep ...

Get Data Analytics & Visualization All-in-One For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.