PL-300: Loading & Transforming Data in Power BI
Microsoft Power BI 2.96 | Beginner
- 10 videos | 1h 20m 1s
- Includes Assessment
- Earns a Badge
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.
WHAT YOU WILL LEARN
discover the key concepts covered in this coursedownload and install Power BI desktopconnect to and import data from an Excel file into Power BIimport data from CSV and XML files into Power BI and recall the role of Power Query in transforming the dataload data from a JSON file into Power BI
import data from a relational database and load it into Power BIremove unnecessary columns and rows from a data source using Power Querymodify the types of columns in a table using Power Querymerge the contents of two related columns in Power Querysummarize the key concepts covered in this course
IN THIS COURSE
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.Digital badges are yours to keep, forever.
YOU MIGHT ALSO LIKE
PEOPLE WHO VIEWED THIS ALSO VIEWED THESE
Course Getting started in Excel 365