img
iTrainingExpert Logo

Microsoft Power BI

Description

Microsoft Power BI


This is an in-depth 2-day course covering the important functions and tools of Microsoft’s Power BI, a business analytics tool for stunning visuals, extracting, transforming & analyzing data, collaborating & decision making.

This course trains participants to extract data from multiple systems or sources, cleanse data, combine data, connect data, build visualizations (dashboards), publish visualizations, managed the datasets, reports & dashboards in workspaces using Power BI web version and Power BI Desktop version.

Data miners, data analysts, business intelligence executives, project managers, revenue managers, finance managers, journalists & those who are performing roles related to data mining, data analysis, data preparation for end-reports, reconciliations, data cleansing, appending & merging files of multiple systems, creating and publishing dashboards and making informed decisions from company data.

This course is suitable for participants who are intermediate Excel users or above.

DAY 1
9.00 am - 5.00 pm


9.00AM - 10.30AM 
MODULE 1 : OVERVIEW ON IMPORTANT ASPECTS OF POWER BI

  • Understanding the multiple data sources under ‘Get Data’
  • Dashboards, reports & datasets in Workspace
  • The Report view, Data view & Relationship view on Power BI Desktop

10.30AM - 10.45AM Break

10.45AM - 1.00PM 
MODULE 2 : USING THE QUERY EDITOR IN POWER BI

  • Understanding ETL- Extract, Transform & Load
  • Getting data from data sources
  • Merging, Appending, Combining Files
  • Removing rows & columns
  • Replacing values in columns
  • Pivoting & unpivoting data

1.00PM - 2.00PM Lunch

2.00PM - 3.30PM  
MODULE 3 : USING THE QUERY EDITOR IN POWER BI (Continuation)

  • Formatting data in columns
  • Merging columns
  • Creating customized columns
  • Indexing columns
  • Inserting calculations in columns

3.30PM - 3.45PM Break

3.45PM - 5.00PM 
MODULE 4 : CREATING VISUALIZATIONS IN POWER BI

  • Using the Power BI Desktop & Power BI Service
  • Adding visualizations to the Report Canvas
  • Using Data view to sort & format data
  • Designing your dashboard & creating column, bar, pie, line graphs, cards, matrices, KPIs, tables, geographical maps, ArcGIS maps

DAY 2
9.00 am - 5.00 pm

9.00AM - 10.30AM 
MODULE 5: CREATING VISUALIZATIONS IN POWER BI (Continuation)

  • Inserting slicers into the dashboard
  • Using inline hierarchies
  • Applying filters to dashboards
  • Creating desktop & mobile view layouts
  • Pinning tiles & live pages
  • The Power BI Publisher for Excel
  • Pinning Excel elements to Power BI
  • Generating Quick Insights
  • Using the Q&A feature

10.30AM - 10.45AM Break

10.45AM - 1.00PM
MODULE 6:
CREATING VISUALIZATIONS IN POWER BI (Continuation)

  • Using App Workspace
  • Publishing an App
  • Creating QR codes
  • Sharing reports on SharePoint
  • Downloading & setting up the Power BI Mobile
  • Viewing & annotating pages in Power BI Mobile

1.00PM - 2.00PM Lunch

2.00PM - 3.30PM 
MODULE 7: DATA MODELLING IN POWER BI

  • Relational files & the Data Model in Power BI
  • Understanding & creating data relationships

3.30PM - 3.45PM Break

3.45PM - 5.00PM 
MODULE 8 : USING DAX IN POWER BI

  • Creating a calculated column
  • Using Measures
  • Using New Quick Measures
  • SUM, SUMX, CALCULATED, &&, RELATED, FILTER

Participants work on datasets ranging from conventional data to big data during the 2-day training. They undergo strict step-by-step instruction-led coaching to achieve the intended outcome of each dataset for each of the course modules.This course covers the installation of Power BI Desktop

SETUP REQUIREMENTS

Required setup: Power BI Desktop, web browser, Excel 2016, email address from a company domain (not free email accounts from gmail or yahoo), broadband access.

NEXAM MOKHTAR
Corporate IT Trainer
Bachelor of Design (Industrial Design) | UPM
Certification in Physical Science | KPM Matriculation College

Nizam is experienced in handling participants from the corporate as well as the public sector.
Nizam has been actively training for the past 8 years in training and 10 year of corporate work experience.

He has also worked through various age group of participant and have a lot of experience in handling versatile participants.

Clients List

  • Pos Malaysia Berhad –MS Excel
  • Universiti Malaysia Pahang Holding –MS Excel,Word,Power Point
  • DRB Hicom-MS Excel,Word
  • Universiti Islam Antarabangsa-Custom Software
  • PLUS Berhad-MS Word,Power Point
  • OYL Manufacturing-MS Excel
  • FITEC-KD Max,InteriCAD
  • MTIB-AutoCAD
  • WISDEC-AutoCAD
  • Hitachi Transport-MS Excel
  • Trans Water-CADWorx
  • RMC-MS Word
  • F&N-MS Powerpoint
  • Penjom Gold Mine-MS Word
  • Proton-MS Power Point,Excel
  • ILSAS-MS Publisher
  • Politeknik Ibrahim Sultan-Adobe Photoshop,Illustrator,InDesign,Acrobat
  • Sime Darby-MS Power Point
  • BE Semiconductor Industry-MS Excel
  • Felda-MS Excel
  • Felcra-MS Excel
  • MINDEF-MS Excel
  • MiDF-MS Excel
  • Kuala Lumpur Airport Service-MS Word,Excel,Power Point
  • Jabatan Pertahanan Awam Malaysia-MS Publisher
  • Jabatan Alam Sekitar-MS Word
  • GE Manufacturing-Solidwork 2013
  • Epson Precision-MS Excel & MS Power Point
  • Celcom Axiata-MS Excel
  • Fabtronic-MS PowerPoint
  • Prolintass-MS Excel
  • Taylor’s College-MS Publisher
  • Petronas Gas Berhad-MS Excel
  • Institut Latihan Perindustrian Miri-Adobe Flash & Photoshop
  • Akzo Nobel-Microsoft Excel
  • Majlis Perbandaran Subang Jaya-Microsoft Word
  • Uchida MK-Kingsoft 2013
  • Jabatan Pengajian Kolej Komuniti-3D Studio Max 2010
  • UiTM Shah Alam-3D Studio Max2013
  • UiTM Machang-3D Studio Max2013
  • Central Cables Sdn Bhd-MS Excel
  • Walsin Precision Technologies Sdn Bhd-AuotCAD 2013
  • Dominant Opto Sdn Bhd-MS Excel
  • To contact Nexam, please feel free to email us at info@itrainingexpert.com or call +603 8074 9056 | +6012 6869 628 

OR 

VINCENT CHIN
Chartered Accountant, FCCA
Microsoft Certified Trainer
Certified Six Sigma Black Belt
HRD Corp Certified trainer

Vincent has held financial, continuous improvement, and I.T. positions in the banking, shared services and hospitality industries. He is a FCCA, Certified Six Sigma Black Belt, Microsoft Certified Trainer, Microsoft Office Specialist, and HRD Corp accredited trainer.

His previous roles include being an internal change consultant of a global team, a financial shared-services local head, and a finance regional head. He currently trains professionals in Excel and Lean Six Sigma covering topics related to finance, business intelligence tools, pivot tables, dashboards, VBA, and process improvement. 

Vincent brings to you his 20+ years of work and training experience in multiple industries where he was in charge of financial and business reengineering functions.

He also develops complex VBA applications regularly in process improvement projects which require his expertise.

One of his highest achievements in the role of Financial Controller for several multinational conglomerates was being able to turn a loss-making company into a profitable one within the year. Vincent has also managed a portfolio of business improvement projects with realized benefits of USD2 million in the prior year in an international bank

Vincent has trained employees from Genting Group, Dell, Motorola, Technip, CIMB, Malakoff, Digi, IBM, Starwood Hotels & Resorts, Petronas ICT, and HSBC.
Vincent adapts a highly practical approach in his training and relates topics he conducts to real-life scenarios. Because he is a no-nonsense person, his solid background in financial operations and process re-engineering experience aid him to create a unique training methodology that mimics closely the solutions that are needed in his participants’ organizations. 

OR 

Other professional trainers in this field. 
To contact Vincent , please call +6012 6869 628, +603 8074 9056, +603 -8082 3707 or info@itrainingexpert.com

Normal Fee Early Bird Group Fee
Sign up 1 pax Sign up 1 pax Sign up 3 pax or more
Pay 1 day(s) before course starts Pay 14 day(s) before course starts Pay 14 day(s) before course starts
MYR 2990 per pax MYR 2600 per pax MYR 2500 per pax
USD 890 per pax USD 760 per pax USD 730 per pax

Upon successful completion of this program, you will receive Certificate of Achievement.

1. ONLINE PAYMENT by Credit card: You can opt to register and pay online with our latest payment integration system through our website.
2. Telegraphic Transfer- You can also opt to use GIRO or telegraphic transfer of payment via international banks.

We'd happy to help.
Feel free to talk to us today, however most suitable for you.
Mobile call/ whatsapp: +6012 6869 628 | +6018 2175 123
Office: +603 8074 9056
Email: info@itrainingexpert.com
Website: www.itrainingexpert.com

USD 890

Share to your friends