Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

Power BI Business Analytics Training

Power BI ranks as a leader in the business intelligence and analytics platforms as recognised by Gartner. The suite is a collection of software services, apps and connectors that work together to turn your data into coherent, visually immersive and interactive insights. It lets one connect easily to data sources, visualise (or discover) what is important and share that with anyone or everyone one wants. It can be fast and simple capable of creating quick insights from excel or a database. It is also robust and enterprise grade, ready for extensive modeling and real-time analytics.

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-0047139

Course Booking

$498.00 (GST-exclusive)
$532.86(GST-inclusive)

Course Date

Course Time

* 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

Day 1

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

Day 2

Topic 5 Model Data with Power BI Desktop

  • Manage Data Relationship
  • Calculated Columns
  • Hide and Unhide Fields
  • Calculated Measures
  • Calculated Table

Topic 6: Advanced Visualization

  • Combination Charts
  • Animated Scatter Chart
  • Waterfall and Funnel Charts
  • Advanced Color Formatting
  • Group Interactions Among Visualizatoins
  • Visual Hierarchies and Drill Down

Topic 7 Advanced Data Exploration and DAX

  • Quick Insights
  • Create Custom Q&A Suggestions
  • DAX Language

Topic 8: Power BI App

  • What is Power BI App
  • Build App
  • Use App
  • Update App

Mini Capstone Project

Course Admin

Prerequisite

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

Software Requirement

Who Should Attend

  • Data Scientists
  • Data Analysts
  • Digital Marketers

Trainers

Power BI TrainerSanjiv 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

Microsoft Power BI TrainerBimala 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 TrainerGary 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 (5)

Might RecommendReview by Chia Jia Yang
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 7/16/2019)
Will RecommendReview by Warren Ang
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
Course was comprehensive with ample time to try the various scenarios in the program. (Posted on 7/12/2019)
Will RecommendReview by Jiaqi
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
How can we improve this course?
Include examples of dashboards created by actual users to allow us to get inspired on how Power BI is applied in the corporate world (Posted on 7/12/2019)
Will RecommendReview by Enersys
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 5/9/2019)
Will RecommendReview by Chai Khai Boon
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 8/22/2018)

Write Your Own Review

You're reviewing: Power BI Business Analytics Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
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
  • Reload captcha

Tags

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

Data Visualisation with Processing

Data Visualisation with Processing

$298.00 (GST-exclusive)
$318.86(GST-inclusive)
Data Visualisation with D3.js

Data Visualisation with D3.js

2 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
Basic Tableau Training

Basic Tableau Training

5 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
Data Visualisation with R Training

Data Visualisation with R Training

6 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)
Full Tableau Training

Full Tableau Training

93 Review(s)
$498.00 (GST-exclusive)
$532.86(GST-inclusive)
Basic Microsoft Power BI Training

Basic Microsoft Power BI Training

18 Review(s)
$298.00 (GST-exclusive)
$318.86(GST-inclusive)