Get this course

SELF LEARNING → FUNCTIONAL → SL - IT & SOFTWARE

GROUP - POWER QUERY FOR BEGINNER (00005)


Description
Power Query is a data connection and transformation tool developed by Microsoft, integrated into products like Power BI and Excel. It allows users to connect to various data sources, clean and reshape data through a graphical interface, and load it into analytical tools. Key features include support for diverse data sources, a formula language (M), and optimization for performance through query folding. Power Query is widely used for data preparation in self-service business intelligence scenarios.

Learning Outcome
1.Master data connection and import from various sources using Power Query.
2.Learn effective data transformation and cleaning techniques through Power Query's graphical interface.
3.Acquire proficiency in using the M formula language for advanced data manipulations within Power Query.

Date: 16/04/2021 Trainer: Jimmy Teh Compulsory: No Source: Internal Training Duration (H...: 2

Content
  • Training Videos
  • Part 1 - Power Query For Beginners Introduction
  • Part 2 - Analyse Large Data Quickly
  • Part 3 - Power Query Interface and Import Data Source
  • Part 4 - Power Query Editor and Data Transformation
  • Part 5 - Formula Bar, Applied Steps and M Code
  • Part 6 - Close & Load Function
  • Part 7 - Power Query Refresh Options
  • Part 8 - Import Excel and Extract Text Based on Pattern
  • Part 9 - Final Merging of Data with Other Files
  • TRAINING FILES
  • Notes to Training Files
  • TEST & ASSESSMENT
  • Power Query for Beginners Quick Test
  • TRAINING EVALUATION
  • Training Evaluation Form
Completion rules
  • All units must be completed
  • Leads to a certificate with a duration: Forever
Back