MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Retrieve, Transform, and Combine Data Using Power Query

Course Summary

This course targets the Business Intelligence (BI) Self Service professional who needs to obtain and shape data from multiple and various sources so that the data can provide useful BI to report viewers. The focus of this coures is Power Query.


  • +

    Course Syllabus

    Course Overview
    - 1m 53s

    —Course Overview 1m 53s
    Introduction & Concepts
    - 18m 44s

    —Power Query Introduction and Concepts 1m 38s
    —Overview of the BI Tools in Excel 3m 52s
    —Introduction to the Power Query Component Parts 5m 8s
    —Review of Which Versions of Excel Can Use Power Query 2m 57s
    —Demo - Install Power Query in Excel 2010, 2013, and 2016 3m 32s
    —Summary 1m 33s
    Data Retrieval
    - 17m 27s
    Worksheet vs. Excel Data Model
    - 12m 57s
    Data Cleansing
    - 21m 27s
    Combining Queries
    - 16m 35s
    Sharing and Reusing Queries
    - 12m 33s
    Summary
    - 11m 11s


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

 
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url