IT Professional Curricula     Enterprise Database Systems Solution Area     Data Visualization     Prepare and Process Data in Power BI

---

Using Power BI for data analysis means you can pull data from multiple places into one location and turn that combined data into meaningful insights. Use this course to learn how to connect different data sources to Power BI and the types of transformations that can be applied to this data.
Install Power BI desktop. Load data from CSV, XML, and JSON files as well as from SQL Server. Use Power Query within Power BI to apply transformations. Then, explore transformations crucial to building meaningful, responsive, and informative visualizations, such as trimming out unnecessary data and merging columns containing related information.
Upon completion, you'll be able to load data into Power BI and transform it for analysis.

---

---

Objectives

PL-300: Loading & Transforming Data in Power BI discover the key concepts covered in this course download and install Power BI desktop connect to and import data from an Excel file into Power BI import data from CSV and XML files into Power BI and recall the role of Power Query in transforming the data load data from a JSON file into Power BI import data from a relational database and load it into Power BI remove unnecessary columns and rows from a data source using Power Query modify the types of columns in a table using Power Query merge the contents of two related columns in Power Query summarize the key concepts covered in this course