This course is conducted in PC/Windows operating system

2-Day Data Analytics Using Power BI Desktop Series 1 - Data Modeling And DAX Formulas Course In Singapore (Exclusive)

Learn how to analyse data and create data models, create calculated fields and measures using DAX formulas

Data Analytics Using Power BI Desktop Series 1 - Data Modeling And DAX Formulas Course Overview

Skills in data analysis, reporting and the creation of dashboards are highly valued in today’s business environment. Microsoft Power BI is quickly becoming the world’s most powerful self-service business intelligence (BI) platform, and an absolutely essential tool for data professionals and beginners alike. Microsoft Power BI can help you get more insights from your data on your computer or in the cloud.

Regardless if you are a data analyst, data scientist or even a power user of Excel who manipulates data for various reporting requirements to your organization, Power BI allows you to be productive and creative with what you build. With Power BI you can connect to hundreds of data sources, build complex relational models using simple and intuitive tools, and design stunning, interactive dashboards from scratch – all for FREE (You can download from here).

There is no beneficial use on using Microsoft Power Bi without first knowing how to build the data model. What sets us apart from other training providers providing Microsoft Power BI course?

  • We do not have readily created database for you. Since this is a project-based learning course, you will learn how to build database from scratch from the raw data provided, clean up the data, build the data model with table relationships and use DAX formulas to generate other required data and KPIs, and display out as a final report, just like a pivot table.
  • You will learn the importance of Data Normalisation and how it works

Data Analysis with Power BI Desktop comprises of 2 Series. This course is Series 1 of the two series. Series 2 is the continuous course from Series 1 and all data files developed in Series 1 will be used in Series 2. Learners are advised to enroll for Series 1 prior to undertake  Series 2*.

  1. Series 1 – Data Modeling And DAX Formulas
  2. Series 2 – Time Intelligence And Dashboard Visualization

*Except users with excellent working knowledge of data modeling and DAX formulas

At the end of the course, learners are able to:

    • get started with Microsoft Power BI Desktop confidently
    • connect to source data
    • use Power Query
    • transform and shape data
    • use Database normalization
    • build a relational data model
    • understand basic DAX functions
    • create calculated fields and measures using DAX formulas
    • create KPIs using Matrix

This course is for:

  • anyone who is looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
  • data analysts and intermediate-to-advanced Excel users hoping to develop advanced data modeling, dashboard design and business intelligence skills
  • who wants to monitor their business metrics, department process or KPIs e.g. accountants, human resource, business, sales, finance, stock or forex traders, business owners etc
  • aspiring data professionals looking to master the #1 business intelligence tool on the market

This is a hands-on practical course. Trainer will walk through the topic step-by-step. Learners will be provided with exercise files on every topic to effectively apply what have been taught. A short Q & A session will be available after each topic.

  • This course is designed for PC/Windows users (currently not available for Mac)
  • Must have at least Intermediate Excel skills
  • Proficient with Excel functions like IF and nested functions is a plus
  • Well versed with Excel Pivot Table is a plus, but not required
  • PC/Windows operating system laptop (personal laptop is preferred as some company laptops may have restriction in accessing internet and USB thumb drive)
  • Laptop power adaptor
  • A USB mouse
  • A USB thumb drive or hard-disk
  • Software requirement: Microsoft Power BI Desktop (FREE)
    Download the Power BI Desktop step-by-step installation guide here

Course Outline

Get started with your Power BI Desktop journey with the new look of workspaces launched in April 2020

  • Connecting source data
  • Connecting to folder containing multiple source data
  • Power Query Editor
  • Using text, number, date specific tools
  • Adding columns like Index and Conditional columns
  • Grouping and aggregating data
  • Pivoting and unpivoting
  • Merging, appending and refreshing queries
  • Defining hierarchies
  • Database normalization
  • Data tables vs Lookup tables
  • Primary and foreign keys
  • Creating table relationships
  • Managing & editing relationships
  • Active vs Inactive relationships
  • Relationship cardinality
  • Filter flow
  • Hiding fields from Report view
  • Calculated columns
  • Measures
  • DAX Syntax
  • DAX operators
  • Math & Stats functions
  • Logical functions
  • Text functions
  • Filter functions
  • Date & time functions
  • Iterator functions

Our Dedicated Trainer

Alaster has been training adult learners in IT in both the private and public sectors since 1986. Alaster’s career before training centred around IT for over 12 years, as he held various roles within software development. He has earned himself a Microsoft Office Specialist (MOS) certification and he is an existing Trainer approved by People’s Association (PA). He was also a former Associate Trainer with the Civil Service College.

He specialises on training Microsoft Applications and Adobe Photoshop. Based on his vast experience and keeping abreast with the emerging trends, tools and technologies with the IT industry, especially software, he has extensively involved in developing several course outlines and course materials and conducting training to equip learners with skills in-demand or likely to be most important in the jobs of the future work.

Alaster constantly explore innovative and effective ways in imparting knowledge and engaging his learners at the same time. He also focuses his training on providing practical solutions to real-life problems, especially Excel. He is more than willing to help overcome various problems faced by his learners that arise in their workplace in applying their newly-acquired knowledge and skills any time after the course. He is well-known for his dedication, commitment and passion to training that makes him well-liked and appreciated by his learners.

Online Registration

Organisations with more than 2 learners, click here to download registration form.

All registration forms should be submitted at least 2 weeks before course commencement. Many courses have pre-requisites, which are intended to foster a learner’s success in the course. Be sure to check the necessary pre-requisites before registering.

Apply Online

Online Registration Form – Company

Part A:     Course Information

  • Create Fill-in Form in Word & Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling & DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualization
  • Excel 100 Tips & Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • Excel VBA Series 1 – Fundamentals
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • ————————————————————————————————————————————————————————————-
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • Error-Proofing Your Process, Products and Services
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038

Part B:     Company Information

Part C:     Particulars of Training Coordinator / Contact Person

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.

Part D:     Billing Information 

Part E:     Learner(s) Information

Learner 1

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference

Learner 2

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Others
  • Muslim
  • Vegetarian
  • No Preference
  • ALS Sales Team / Email Updates
  • Search Engines (Bing, Yahoo, Google)
  • Social Media (LinkedIn, Facebook)
  • Referral (Colleagues, Friends, Family)
  • Others

Online Registration Form – Individual

Part A.     Course Information

  • Create Fill-in Form in Word & Import Form Data from Excel
  • Creating Dynamic & Interactive Chart in Excel
  • Data Analysis using Dynamic & Interactive Excel Dashboard
  • Data Analysis with Excel Power Query, Data Model & Power Pivot
  • Data Analytics using Power BI Desktop Series 1 – Data Modelling and DAX Formulas
  • Data Analytics using Power BI Desktop Series 2 – Time Intelligence & Dashboard Visualisation
  • Excel 100 Tips and Techniques
  • Excel Advanced Formulas & Functions
  • Excel Data Cleansing & Building Techniques
  • Excel Pivot Table In-Depth
  • Excel VBA Series 1 – Fundamentals
  • PowerPoint Tips & Techniques
  • Word Tips & Techniques
  • 21st Century Supervisory Management Skills
  • Adapt, Evolve and Change – Embracing Changes in an Ever-Transforming Work Environment
  • Better Grammar for Business
  • Dealing with Difficult Customers Behaviour
  • Editing & Proofreading Skills
  • Emotional Intelligence Skills to Make A Difference In your Service to Customers
  • Error-Proofing Your Process, Products and Services
  • How to Talk to Anyone: The Art of Everyday Conversation
  • Keys To Increase Your Focus & Productivity At Work
  • Kickass Presentations Intensive
  • Leading with Influence:Walk, Talk And Act Like A Boss™
  • Managing Conflict and Confrontation the Less Stressful Way
  • MEMORY Empowerment Workshop for Higher Efficiency
  • Nurturing Your Creative Brain
  • Persuade Like A Lawyer
  • Persuasion and Influence Secrets
  • Proactive Failure Management using FMEA (Failure Mode Effect and Analysis)
  • Problem Solving the 8D (Disciplines) Approach
  • Quality Control Tools for Data Analysis and Problem Solving
  • Quick Guide for Supervisory Management Roles
  • Reducing Stress While Optimizing Your 24/7
  • Systematic Approach to Solve Problems and Make Decisions
  • The Art of Technical Writing
  • The CRM Ways to Long Lasting Relationship
  • The Fundamentals of Business Process Reengineering – Don't Wait for Something to be Broken to Fix It!
  • The Real Approach (and Human Side) of Project Management
  • The Transformative Power of Story: Using Storytelling to Lead, Sell & Influence
  • Uncover Your Communication Power Towards Greater Understanding
  • Understanding how to be LEAN (not just for manufacturing industry)
  • Writing Better Emails
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038
  • Month
  • January
  • February
  • March
  • April
  • May
  • June
  • July
  • August
  • September
  • October
  • November
  • December
  • Day
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • Year
  • 2018
  • 2019
  • 2020
  • 2021
  • 2022
  • 2023
  • 2024
  • 2025
  • 2026
  • 2027
  • 2028
  • 2029
  • 2030
  • 2031
  • 2032
  • 2033
  • 2034
  • 2035
  • 2036
  • 2037
  • 2038

Part B.     Personal Information

  • Mr.
  • Mrs.
  • Ms.
  • Miss
  • Prof.
  • Dr.
  • Singaporean
  • Singapore PR
  • Foreigners
  • Vegetarian
  • Muslim
  • No Preference
  • No results
  • ALS Sales Team
  • Referrals (Colleagues, Friends, Family)
  • Search Engine
  • Social Media
  • Website
  • Others

Course Information

Course Code:

ALSIT-PBI1

Course Fee:

S$850.00 (Nett)

Inclusive of 2 coffee breaks with refreshments and catered/buffet lunch

Call us for a group rebate when you register in a group of 6 or more

Absentees will be charged the full course fee

Course Dates:

2 days, 9:00am – 5:00pm
(14 hrs, exclude lunch break)

If you have a group of 6 or more preparing for the same course, you can opt for your own “closed” class. Closed classes are perfect for corporate team training where group learning can make a difference. 

Please note that closed class is not customised class.

Registration:

For Company-Sponsored Learners: Click here to download registration form

For Self-Sponsored Learners:
Click here to download registration form

You can also register online here

For Government Ministries / Agencies on HRMS / ACE, you are unable to see our courses on the list. Please inform your Training Coordinator the Course Code, Course Title, Course Date and the Training Provider is Advanced Learning Singapore to upload into the system for registration

Course Venue:

Details of hotel will be confirmed nearer the course start date

Others:

Note:

ALS reserves the right to reschedule, postpone or cancel any course, change the trainer and hotel venue at short notice and at its absolute discretion, due to insufficient enrolment, class size, availability and circumstances outside our control

More Courses By Alaster