Power BI Essential
current icon CURRENT
camput icon On Campus
Start Anytime
Industry Recognised
Workplace Simulation
Price: $160
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

FEE INFORMATION

  • Fees must be paid within 5 days of receiving the confirmation of enrolment and invoice for the enrolment fee.
  • Seed Training Group may cancel 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
Download Course Brochure