Event Information
Event code CMAI24112718 Language English
Event name Microsoft Power BI - Prepare Your Data Efficiently for Excel Analysis
CPD hours 2.00
Competency Information Technology Sub-Competency Data management and analysis
Level 1 - Foundation
Contact online@hkicpa.org.hk / 2287 7435
Description

Offline enrolment form

 

Overview

Get started on data gathering!
This is the second course in the Microsoft Power BI series of courses. This course focuses on getting data from different sources into Excel.

Tools like Power Query (now known as "Get & Transform") can make transforming data from those sources quick and easy. Whether you are importing data or cleaning it, learn how to make it happen!

Key Topics

  • Various forms of data sources
  • Accessing data sources
  • Working with multiple tables/sources
  • Importing data for analysis
  • Introduction to Get & Transform (formerly Power Query)

Learning Objectives

  • Differentiate between proper and improper data structure.
  • Select the best way to import data into Excel.
  • Identify ways to use Get & Transform/Power Query to clean your data.

(This is a re-launch programme. No CPD hours will be granted if a member has previously enrolled for CMAI23080156 Microsoft Power BI - Prepare Your Data Efficiently for Excel Analysis) 
Event Date
Date / Time CPD hours
27 Nov 2024 00:00 - 31 Dec 2099 23:59 2.00
Fee Information
Type Fee (HKD)
Enrolment IA 500.00
Member 500.00
Student 500.00
Non-member 580.00
Enrolment Date
Enrolment from 27 Nov 2024 (00:00) to 31 Dec 2099 (23:59)
Full Hot and limited seat Promotion
Closed e-Learning Continuing Education Fund
  Choose Skin