JavaScript seems to be disabled in your browser.
You must have JavaScript enabled in your browser to utilize the functionality of this website.

Home
Basic Microsoft Power BI Training

Basic Microsoft Power BI Training

29 Review(s) | Add Your Review

Microsoft Power BI is a suite of interactive data visualisation business analytics tools that deliver insights throughout your organization. You can use Power BI to connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis. It produce beautiful reports, then publish them for your organization to consume on the web and across mobile devices.

Everyone can create personalised dashboards with a unique, 360-degree view of their business. And scale across the enterprise, with governance and security built-in

Course Highlights

Create Visualisation and Report Using Power BI Service
Data Transformation Using Power BI Desktop
Power Query Editor
Create Dashboard

Learning Outcomes

By end of the course, learners should be able to

LO1 - Create report and visualization using Power BI Service
LO2 - Model data using Power BI Desktop
LO3 - Integrate Power BI Desktop, Power BI Service and Power BI mobile apps

Certificate

All participants will receive a Certificate of Completion from Tertiary Courses after achieved at least 75% attendance.

Funding and Grant Applications

Click the links below to apply. Note that you need to register the course first.

For Singaporeans: SkillsFuture Credit

For Company: SSG Training Grant

Course Code: CRS-N-0046957

Course Booking

$298.00 (GST-exclusive)

$318.86(GST-inclusive)

Mode of Training

Synchronised Teaching using ZOOM
Physical Classroom Training (after Phase 1)

Course Date * Course Date

Course Time * Course Time: No. of Participants

Sponsorship

Self-Sponsored
Employer-Sponsored

Name(s) on Certificate *

NRIC (Last 3 Digits and Alphabet)

Additional Message or Emails for Course Notification

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

Course Details

Topic 1 Get Started on Power BI

Overview of Business Intelligence
Introduction to Power BI
Power BI Application Case Studies
Login to Power BI Service Account
Explore Power BI Service Interface
Import/Connect Data to Power BI Service
Power BI Desktop and Mobile

Topic 2: Create Report with Visualizations

Overview of Visualizations on Power BI Service
Create Visualizations
Format Visualizations
Filter Data and Slicer
Create a Report with Visualizations

Topic 3 Dashboard

What is Dashboard
Pin a Visual to Dashboard
Customize Dashboard
Create Visual by Q&A
Edit Dashboard Visual
Share Dashboard

Topic 4: Transform Data with Power BI Desktop

Overview of Power BI Desktop
Get Data into Power BI Desktop
Connect to Data Sources
Publish Report to Power BI Service
Power Query Editor
Transform Data
Combine Data from Multiple Sources
Filter Data
Merge and Append Queries
Customised Queries
Transform and Clean Data

Assessment (Q&A)

Course Admin

Prerequisite

This course is for beginner. No prior knowledge on programming is required.:

Software Requirement

Download and install Power BI Desktop https://powerbi.microsoft.com/en-us/desktop/

Who Should Attend

Data Scientists
Data Analysts
Digital Marketers

Trainers

Power BI Trainer Sanjiv i is an experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions.

Sanjiv is also known for his strong presentation and communication skills and being able to communicate complex topics in a simple and elegant way. His goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers

Sanjiv has spent a little over 20 years across North America (17 years) and Asia Pacific (3.5 years) with rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.

Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle.

Below are a few of his BI/analytics projects driven at scale:

Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB)
Helped develop key KPIs – identified key KPIs and helped land this in the DB
Developed a budget audit tool that captured budget inputs from a host of countries across the globe
Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team

Power BI Trainer Laks Mariappan has Masters in computer applications. He is from banking industry with 15+ years of experience in data analytics and business intelligence field. He has done various roles from Business analyst to Sr. Manager, leading the roll out of analytical reporting capabilities across multiple markets. He has also led the training initiatives for the tools.He has strong knowledge on the BI tools such as SAS, Actuate, Microstrategy, Tableau & Power BI.

Power BI Trainer Ken Hiong has over 20 years of work experience in the healthcare and pharmaceutical industry holding various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning.

He graduated with a degree in Pharmacy and holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.

He is an expert Excel user and has a keen interest in scripting and web development with practical knowledge of HTML, Javascript, CSS, PHP, MySQL, WordPress, VBA, amongst others. Applying these tools at work, he had simplified many work methodologies, improved data analysis and business reporting processes, achieved higher productivity and enhanced quality outcomes. He is an advocate of lifelong learning.

Microsoft Power BI Trainer Bimala Mishra has Overall 13 years of IT experience, with strong exposure in Database, Business Intelligence and Analytics domains. She has extensively worked on implementation of Enterprise Datawarehouse and BI solutions. She is a Certified Business Intelligence Professional from ICCP, USA (2013). Bimala’s varied career includes Data Analysis, Design and development of enterprise solution. She has done Masters in Computer application from one of the pioneer institutes of India and have worked on MNC such as Hewlett Packard. She is an expert on SQL backend Query, Excel, QlikView, Qlik Sense, C Programming, Java, Python to name a few. She enjoys working with both adults and youngsters. Currently she is an active volunteer of NLB S.T.A.R program, where she teaches Seniors about NLB mobile Apps and assists secondary students in her children school on their computer project assignments.

Power BI Trainer Gary HOW has overall 10 years of IT experience with strong exposure in Business Intelligence and Analytics domains. He has been delivering Qlik Sense enterprise solutions and training to corporate users for the past 4 years since it first released in 2014. Further, through the course of his work, he has also implemented software trials on various Business Intelligence solutions including MS Power BI and Tableau. He holds a Bachelor's degree in Computing from NUS.

Customer Reviews (29)

Trainer is very knowledgable Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Due to circuit breaker, cant comment much as it is a virtual training

Trainer is very knowledgable and passionate in giving training. Will enrol for the advance course (Posted on 4/30/2020)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

More time for hand-on practice (Posted on 3/8/2020)

Very useful learning Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Need more practices

(Posted on 3/8/2020)

will recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Very well packaged and well pitched for beginner's level. (Posted on 3/6/2020)

might consider Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 11/22/2019)

will Recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 11/19/2019)

will Recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 11/19/2019)

will Recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

. (Posted on 11/19/2019)

will Recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

More training materials (Posted on 11/19/2019)

will Recommend Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Provide the course notes, we may forget the learning points and steps after the class

Good to understand our needs and expectation to modify the class materials (Posted on 11/19/2019)

Might Consider Review by Course Participant/Trainee

1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment

Perhaps the course timing can be shortened? (Posted on 8/27/2019)