Data Analytics & Visualization with Power Business Intelligence

20 Oct, 2021, Virtual Classroom Training

IPA Training is Registered with

Learn from the Best

Dr Steven Liew is a fellow member of the Chartered Institute of Management Accountants, UK and is a Chartered Accountant by profession. He has an Asia Pacific Executive MBA (for senior executives) from the National University of Singapore and a PhD in international finance with Rushmore University of USA.

 

Dr Liew had worked in private sector companies, ranging from family-run businesses to professionally manage multi-national corporations in South Asia and the ASEAN region. He has accumulated more than 30 years working experience in senior financial & operational management positions spearheading the profitability and growth of companies. He has worked for the MBF Finance & its related group of companies over the 10 years period.

 

He is a registered Trainer with the Government Human Resources Development Berhad (Pembangunan Sumber Manusia Berhad). And he is a GST Tax Consultant and had successfully completed the Custom examination.

 

Dr Steven Liew had conducted various seminars for corporate clientele including Association of Credit Management Malaysia, Chartered Institute of Management Accountants, Malaysia Institute of Management, Malaysia Institute of Accountants, Institute of Bank Malaysia, Nestle, IQPC Worldwide Pte Ltd , Singapore, Lexis Nexis,, Proton Edar Malaysia , Brunei Investment Agency, Small Medium Industries Development Corporation , Ministry of Development, Brunei , BICPA Asean Management, Brunei, Risda Group Of Companies, Sales & Marketing Training Forum, Sri Lanka, Giant Retail Sdn Bhd, Telekom Brunei & Ministry of Foreign Affairs, Malaysia, Sabah Electricity Sdn Bhd, Bank Islam Brunei Darussalam. Continental Tyres, Sime Darby Bhd, Sony Malaysia Sdn Bhd, Perodua Sdn Bhd & Credit Guarantee Corporation (M) Bhd; Fujixerox, UDA Holdings, SPNB, Diners Club, Elk Desa Capital Bhd, Antah Schindler, UCSI & Ministry of Finance; Seccom Sdn Bhd; Bridgestone Chemical Products (M) Sdn Bhd; Dialog Group Bhd; SEDCO, KK; Hosiden Electronics (M) Sdn Bhd; STO Maldives; Indah Water Consortium Sdn Bhd; CPA Australia (M) Sdn Bhd

 

He is currently providing management consultancy and training specialising in Power BI, SST, GST, Forecasting, Fast closing monthly, leadership, Strategic Planning, budgeting, accounting, finance, Cost reduction, credit management & loan recovery.

Venue Details

Virtual Classroom Training

Contact us

Juliany,
M - 012 2281 247
juliany@ipa.com.my

Michelle,
M - 019 363 7822
michelle@ipa.com.my 

FOR CUSTOMISED IN-HOUSE TRAINING
Yvonne,
M - 012 201 1247
yvonne@ipa.com.my

ADDRESS 
A-28-5, 28th Floor, Menara UOA Bangsar, 
No.5, Jalan Bangsar Utama 1, 
59000 Kuala Lumpur
www.ipa.com.my

FOCUSING ON
  • Module 1: Creating Interactive Excel Dashboard
  • Module 2: Getting Started
  • Module 3: Getting Data
  • Module 4: Application Of Power Bi (Case Study)
  • Module 5: Shaping And Transforming Data
  • Module 6: Publishing

    SPECIAL FEATURE: Participants Will Receive a Set of Practical Templates suitable for all sectors.
OBJECTIVES
Access the information you need when you need it through visually stunning dashboards and reports. Learn how to analyze and display data using Power BI and make better, more data-driven decisions.
WHAT YOUR COLLEAGUES ARE SAYING ABOUT THE COURSE…
“I now understand Power BI can do extraordinary data visualization and its ability to highlight financial performance to senior management."
Treasurer, Kolej University Islam Perlis

“Good introduction to the basics Power BI. it can show detailed financial results & enabling a clearer presentation to management.”
Admin Assistant, Panji Alam Sdn Bhd

“Power Bi has the ability to show the financial results in multiple presentation and with deeper data analysis.”
Accounting Manager, CJ Bio Malaysia Sdn Bhd

“Understand The basic of Power BI: Data must be raw, how to get data, transform data, data cleansing, creating reports, publish to power BI service & dashboard Thank you very much, Dr Steven.”
Encik Mohd Rosli, Finance associate, Malaysian Technology Development Corporation

AFTER ATTENDING THIS COURSE YOU WILL RETURN TO YOUR JOB…
  1. Understanding the Power Business Intelligence (BI)
  2. Combining multiple data sources into one dataset.
  3. Building interactive reports.
  4. Performing forecasting & What-If analysis
  5. Connecting the data to the dashboard, BI tool, or data warehouse of your choice
WHO SHOULD ATTEND
Accountants, CFO, CEO, Business Managers, Marketing Managers, Marketing Personnel, HR Managers, Logistics Managers, Operation Managers, Department Heads & Operation Heads, Supervisors and all Managers
METHODOLOGY
Interactive Lectures, Case Study & Group Discussion. Current financial & business cases will be analyzed, and scenario solutions will be discussed within the course.
COURSE CONTENT
9:00

MODULE 1: CREATING INTERACTIVE EXCEL DASHBOARD

  • From data set to pivot table
  • Pivot table to charts.
  • From charts to dashboard
  • Interactive dashboard


10.45

MODULE 2: GETTING STARTED

  • Introducing Power BI
  • A quick look at Power BI Desktop
  • A quick look at the Power BI service
  • Setting up Power BI Environment
12.00

MODULE 3: GETTING DATA

  • Available data sources in Power BI Desktop
  • Connecting to data sources
  • Get Data from Folder
    Handling multiple worksheets
  • Get Data from CSV file
1:00 Lunch
2:00

MODULE 4: APPLICATION OF POWER BI (CASE STUDY)

  • Sales performance
  • Web application
  • Profit by date
    Unit Sold by Each Country/States
  • Profit by product
3:00

MODULE 5: SHAPING AND TRANSFORMING DATA

  • Introduction to the Query Editor
  • Clean and transform your data with the Query Editor.
  • Cleaning irregularly formatted data
  • Data categorization
  • Relationship view
4:00

MODULE 6: PUBLISHING

  • Home
  • Publish
  • Success
  • Headline
  • Region
  • Decomposition tree
  • Export- PPT, PDF
  • Focus mode
  • Filter further
  • Introduction to the Power BI service
5:00 End of Course