MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop
This course introduces the basics of Power Query, a tool used to import and transform data in Excel and Power BI Desktop. It covers the user interface, locations to load data, and how to edit, delete, and add steps to a Power Query solution. Additionally, it explains how to add new data and refresh reports and Power Query queries. ▼
ADVERTISEMENT
Course Feature
Cost:
Free
Provider:
Youtube
Certificate:
Paid Certification
Language:
English
Start Date:
On-Demand
Course Overview
❗The content presented here is sourced directly from Youtube platform. For comprehensive course details, including enrollment information, simply click on the 'Go to class' link on our website.
Updated in [February 21st, 2023]
By taking this course, users will learn how to import and transform data in Excel and Power BI Desktop. They will learn how to clean and transform data in Excel, extract and import data from relational Access Database into Excel Power Pivot Data Model, extract and import data from multiple text files into Power BI Desktop Data Model, and replace complex Excel array formulas with simple Power Query solutions.
Possible development paths for learners include becoming a data analyst, data scientist, or business intelligence analyst. They can also use the skills they learn in this course to develop their own data-driven applications.
Learning suggestions for learners include taking courses in data analysis, data visualization, and machine learning. They should also practice their skills by working on real-world data sets and projects. Additionally, they should stay up to date with the latest trends in data science and technology.
Course Provider
Provider Youtube's Stats at AZClass
Discussion and Reviews
0.0 (Based on 0 reviews)
Start your review of MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop