Power BI Essential
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Contact Us
DOWNLOAD COURSE BROCHURE
CERTIFICATES
FLEXIBLE DELIVERY
LIVE SUPPORT
INTERNSHIP AVAILABLE

ABOUT THE COURSE

*The course will be delivered in Mandarin (中文授课).

UNITS

Module 1 Components of Power BI

Module 2 Get Data with Power Query

  • 1) Understand Power BI data sources
  • 2) Connect to a file: Excel, CSV, Access
  • 3) Connect to a web data source
  • 4) Import Excel data models to Power BI
  • 5) Send data from Power Query to Power Pivot

Module 3 Data Analysis in Power BI

  • Append data to a query
  • Merge and group data
  • Reduce data with the Query Editor
  • Transform data
  • Add an index column
  • Clean up data
  • Create hierarchy/relationships between tables
  • Use lookup tables in a dataset
  • Generate insight with DAX calculations

Module 4 Create Business Report in Power BI

  • Create and format chart visuals
  • Use Matrices, Cards, and Tiles to visualise Power View Data
  • Complete the dashboard using slicers and timeline
  • Create an amazing sales map and other useful charts
  • Creating interactive dashboards
  • Set drill through features in Power BI report
  • Publish report to Power BI
  • Refresh and remove reports
  • Share reports with a security setting

UPON COMPLETION

This course is eligible for CPD hours.

CAREER OPPORTUNITIES

  • Financial Modeller
  • Business Analyst
  • Data Analyst
  • Financial Accountant
  • Management Accountant
  • Business Analyst

DURATION

  • 9:30-16:30    13 May 2018      
  • 9:30-16:30    04 Nov 2018

OTHER RELEVANT COURSES/PATHWAY

FINANCE OPTIONS

FINANCE OPTIONS

Fees must be paid within 5 working days of receiving the confirmation of enrolment and invoice for the enrolment fee.

Seed Training Group may cancel an enrolment or discontinue training if fees are not paid as required.

Both direct deposit and credit card are accepted.

*Please refer to the Student Information Handbook for further details regarding Fees & Refund Policy and Procedure.

Trainer’s Profile

  • 17 Years of Dedicated Best-Practice Financial Modeller Extensive Experience in Building & Reviewing Complex Financial Model
  • Experienced Financial Controller of an ASX listed company
  • Managing Director of AFMA (Australian Financial Modeller Association)
  • Committee Member of ACAA (Association of Chinese Accountants Australia)
  • Special Guest Trainer of ABC Television (Australian Broadcasting Corporation)
  • Guest BI (Business Intelligence) Lecturer of CPA Australia
  • Lecturer of Shanghai University of Finance and Economics MBA
  • Experienced Financial Analyst and Financial Modeller
TESTIMONIALS
PARTNERSHIP & COLLABORATORS
Call Me Back