Power Query for Excel and Power BI (Introductory Level)
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
An Introductory course to the BEST Data Wrangling tool created by Microsoft for Business Users - Power QueryDescription
Power Query, also known as “Get & Transform”, is an amazing piece of ETL technology built into Excel 2016 and Power BI Desktop, and is available as a free add-in for Excel 2013 and 2010. It allows you to Extract data from a vast array of sources, Transform it more quickly and easily than you ever thought possible, and then Load it directly into a table or your data model.
If you need to learn one new tool today, Power Query is it! Power Query for Excel and Power BI is an introductory excerpt from our full course, Power Query Academy. In this course, we will introduce you to the magic of Power Query and how it will transform the way you work with data forever.
Ken Puls and Miguel Escobar, both top Power Query experts, will guide you as you learn about this powerful tool. They will walk you through how Power Query works, connecting to basic data sources, performing simple transformation techniques, combining data from multiple sources), and loading the prepared data in Microsoft Excel and Power BI Desktop.
Requirements
- Requirements
- You can use any version of Power Query (aka Get & Transform) inside Excel (Excel 2010 or later) or even inside Power BI Desktop
- No prior knowledge of Power BI, Excel formulas or functions is required
Business Intelligence and Automated Reports using Power BI
- 3.7
-
![]()
![]()
![]()
![]()
![]()
Self-service Business Intelligence with complex, insights-rich, interactive reports and dashboards in Power BI Pro Enroll now to get this benefit for life!**...
Power BI Master Class - Dashboards and Power BI Service 2021
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Learn how to create interactive dashboards and to publish to the Power BI Service Students who have taken this course have this to say:...
Microsoft Power BI Intermediate
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Take your data modelling skills to another level and learn how to use SQL, DAX with Power BI to drive change...
Excel Power Tools for Data Analysis
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data....
