PL-300: Preparing Data for Visualizations in Power BI
Microsoft Power BI 2.96
| Beginner
- 12 Videos | 1h 51m 18s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this courseconnect to data sources that are related but stored in separate files and load them into Power BIuse Power BI's column profiling feature to recognize what information is stored in a datasetperform a join operation to merge two related tables into a single unitload data from multiple separate but related files located in a single directoryperform aggregations on data in a table to summarize the contents of a dataset
-
apply the M formula language to perform data transformations in Power BIfilter out unnecessary data by defining row-level filterscreate a basic column chart to visualize data in Power BIconnect to a relational database in DirectQuery modebuild a simple column chart from the contents of a Power BI table and distinguish between Import and DirectQuery storage modes in Power BIsummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview3m 19sUP NEXT
-
2.Loading Related Data into Power BI9m 28s
-
3.Profiling Data in Power Query8m 46s
-
4.Merging Tables in Power BI11m 44s
-
5.Combining Data in a Folder Using Power BI11m 14s
-
6.Performing Aggregate Operations on Data11m 40s
-
7.Using the M Formula Language in Power BI11m 27s
-
8.Applying Row-level Filters in Power BI12m 21s
-
9.Building a Simple Visualization in Power BI12m 39s
-
10.Loading Data to Power BI with DirectQuery10m 15s
-
11.Building a Visual with DirectQuery in Power BI6m 8s
-
12.Course Summary2m 18s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.