IT Skills     Data and Databases     Data Visualization     Prepare and Process Data in Power BI

---

A vital step between gathering data and creating a report or visualization from it is transforming it into a cohesive form. Use this course to gain hands-on experience in transforming raw data for visualizations.
Practice combining related data into a single table. While doing so, perform a preliminary analysis of the data so you can imagine what visualizations can be created from it. Next, combine data from several files into a single table and conduct several transformations, from aggregating data to filtering out unnecessary rows.
Finally, build a simple column chart visual from the contents of a Power BI table. While doing so, identify the different storage modes in Power BI and how they affect your visuals.
Upon completion, you'll be able to prepare data for visualization using a variety of transformations.

---

---

Objectives

PL-300: Preparing Data for Visualizations in Power BI discover the key concepts covered in this course connect to data sources that are related but stored in separate files and load them into Power BI use Power BI's column profiling feature to recognize what information is stored in a dataset perform a join operation to merge two related tables into a single unit load data from multiple separate but related files located in a single directory perform aggregations on data in a table to summarize the contents of a dataset apply the M formula language to perform data transformations in Power BI filter out unnecessary data by defining row-level filters create a basic column chart to visualize data in Power BI connect to a relational database in DirectQuery mode build a simple column chart from the contents of a Power BI table and distinguish between Import and DirectQuery storage modes in Power BI summarize the key concepts covered in this course