fbpx

ANALYSE AND VISUALISE DATA WITH POWER BI MASTERCLASS:

Effective dashboard reporting and business intelligence for strategic insightS

POWER BI INDONESIA TRAINING SCHEDULE
20-21 Sep Live Online Course
6-7 Dec Live Online Course

Click on the link above to download course brochure

KEY TAKEAWAYS (POWER BI TRAINING INDONESIA)

By the end of the Power BI training course, participants will:

  • Clean and transform data with Power Query, model it and build KPIs and metrics that answer specific business questions
  • Use DAX effectively to build time intelligence reports, slice reports by measures and filter according to context
  • Access data from supported on-premises and cloud-based sources with automated, incremental refreshes
  • Combining multiple data sources into one dataset
  • Perform forecasting
  • Apply security rules and share content on PowerBI.com
  • Create stunning Power BI reports with interactive data visualisations
  • Perform analytics and find patterns with Power BI features like quick measures, grouping, forecasting and clustering.
REVIEWS FROM OUR CLIENTS (POWER BI TRAINING)

Head, HR Strategy & Analytics, Abbott Laboratories: "Alvin has good understanding of the corporate needs and is well-versed of how global organisations work. Very relevant for someone who is learning visualisation & modelling."

APAC Operation Manager, T.D. Williamson Asia Pacific: "The trainer is very knowledgeable. He is able to take questions while keeping the training on schedule. Very clear explanations and examples"

Head, Upstream Benchmarking, Petronas: “Being a beginner, the instructor guided well. Learnt a lot, giving me practical knowledge & skills which I will be able to apply.”

Director, Risk Management, Prudential: “Very helpful session. Progressed at a very nice pace, making it clear for all participants.”

Manager (Research Strategy), National University Health System Research Office: "The course is comprehensive and systematic, great for those getting started with Power BI."

Logistic and Procurement Manager, Ministry of Defence: "Alvin is helpful and able to present the material very well while guiding us through the tutorials."

Information Systems Manager, Keppel Infrastructure: "Very patient trainer since the training was conducted online. Good!"

Assistant Accountant, KSL Corporate Services: "Alvin provides useful recaps at the end of the sessions to summarise all the concepts he has shared. He has also provided us with some practical examples for us to apply the concepts taught."

Analytics Manager, MBSB Bank: “Alvin is a very knowledgeable and patient trainer. His training session is very insightful. Gained lots of knowledge during the session. Great job!”

cOURSE OVERVIEW (pOWER bi tRAINING INDONESIA)

Tired of struggling with countless complex Excel reports which contain hundreds of formulas, not to mention the headache of trying to make sure everyone is using the latest version. Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organisation. You can use Power BI to connect to hundreds of data sources, simplify data preparation, and drive ad hoc analysis. Power BI produces beautiful reports, then publish them for your organisation to consume on the web and across mobile devices. Everyone can create personalised dashboards with a unique, 360° view of their business and scale across the enterprise, with governance and security built-in.

We will show you how, without the need of former data analysis training or needing to learn another language, you can be building and sharing reports and dashboards that are useful and beautiful. Join us in our instructor-led Microsoft Power BI Training.

COURSE INSTRUCTOR (pOWER bi tRAINING INDONESIA)

Alvin Yong
MSc, FCCA, Microsoft Certified Trainer

Alvin Yong is a Fellow Chartered and Certified Accountant (FCCA). He obtained his Master of Science in Professional Accountancy in 2017 from the University of London. Alvin started his career with KPMG Singapore as an auditor in 1999, where he was involved in the audit, due diligence and tax of multinational corporations in various industries, including shipping and logistics, industrial manufacturing, medical and healthcare, construction consultancy and investment holdings.

With strong business acumen, Alvin went on to co-found several companies and has been an entrepreneur for more than 15 years. His companies have served clients across the globe, from US, Europe, Middle East, Africa, Asia to Australia. His current passion is data analytics and visualisation, as well as digital transformation. Alvin enjoys helping his clients understand the stories that their data tells about their business, thus enabling them to make informed, data-driven decisions to propel future growth.

WHO SHOULD ATTEND (POWER BI TRAINING INDONESIA)

This Power BI training is crucial for analysts, managers, reporting professionals, business owners, executives, and anyone who need to derive and share insights with business data.

The Power BI training is highly recommended for:

  • Directors
  • General Managers
  • Finance Managers
  • Business Analysts
  • BI Professionals
  • Sales Managers
  • HR Managers
  • Data Analytics Manager
  • Business Owners
  • Anyone who deals with business, management and financial reporting
COURSE PREREQUISITES

No prior knowledge of programming or data analysis is required.

COURSE METHODOLOGIES 

Clear explanation of theories coupled with hands-on exercises for a firm grasp of Power BI through:

  • Practical Examples
  • Case Studies
  • Short Exercises
  • Group Discussions
SOFTWARE USED

Power BI Desktop

COURSE AGENDA (POWER BI TRAINING INDONESIA)

Session 1: INTRODUCTION

  • Overview of training aim, objectives and agenda

Session 2: POWER BI CLOUD SERVICE

  • Cloud service overview
  • Importing report into the cloud service
  • Dashboard flow and navigation
  • Power BI for mobile
  • Natural language queries
  • Quick insights
  • Content packs
  • Publish to web (embedded)
  • Export to PowerPoint

Session 3: POWER BI DESKTOP

  • Overview of Power BI desktop
  • Similarities to Excel Power Pivot & Power Query
  • Technical options & settings
  • Monthly updates

Session 4: IMPORTING AND TRANSFORMING DATA

  • Importing data from various sources
  • Using DirectQuery
  • Query editor overview
  • Understanding query design & the ETL process
  • Query building best practice
  • Understanding applied steps
  • Data transformations
  • Cleaning data
    • Merging datasets
    • Unpivoting data
    • Combining files from a folder
    • Appending datasets
  • Using a dynamic fiscal calendar table
  • Creating parameters

Session 5: DATA MODELLING

  • Creating relationships
  • Bidirectional relationships
  • Default summarisation
  • Custom sorting of columns
  • Data types and formatting
  • Creating data synonyms

Session 6: REPORT BUILDING

  • Build a time intelligence report
  • Report layout guidelines
  • Understanding DAX syntax
  • Implicit vs explicit measures
  • Base measures and metrics
  • Commonly used DAX functions
    • Sum, average
    • Time intelligence (MTD, QTD, YTD, Prior year)
    • Calculate and filter context
    • Filter, All
    • IF, HasOneValue
    • Switch
    • Divide
    • UserRelationship
    • Selected Value
  • Optimising measures for self-service BI
  • Using quick measures
  • Exercise: Build a Monthly Trend Report
  • How to slice by measure
  • Dynamic headings & dates
  • Types of slicers and filters
  • Understanding KPI cards
  • Using field, format, analytics pane
  • Exercise: Build a Tabular Report (Matrix)
  • Types of conditional formatting

Session 7: REPORT FUNCTIONALITY

  • Drill-downs and drill-through
  • Slice by relative dates
  • Focus mode - see details
  • Setting visual interactivity
  • Exporting data from Power BI desktop
  • Using Power BI desktop quick insights
  • Handling multiple relationships with the fact table
  • Exercise: Build a Shipped Date Report
  • Building reports using Q&A

Session 8: REPORT VISUALISATIONS & DESIGN

  • Choosing visuals based on context
  • Native & custom visuals
  • Optimising bullet, scatter, ribbon & water charts
  • Adding tool tips
  • Types of conditional formatting
  • Custom page sizing
  • Logo & icons
  • Shapes and borders
  • Formatting tips & tricks
  • Best practice guidelines and development tips

Session 9: GOVERNANCE & DISTRIBUTION

  • Row level security - creating and testing roles
  • Publishing to the cloud service
  • Security - add users to defined roles
  • Sharing dashboards & reports
  • Creating app workspaces and publishing apps
  • Adding users and editing workspaces
  • Publishing apps
  • Organisational content pack

Session 10: DATA REFRESHING

  • Overview of the data gateway
  • Scheduling data refreshes
  • Refreshing on-demand
BROCHURE REQUEST (POWER BI TRAINING INDONESIA)