NICF – Data Visualization with Power BI (SF) (16.5 hrs)

Course Code: CRS-Q-0039318-ICT

The demand for visual analytics in business processes is ever-increasing. Data visualization is a crucial tool to demystify complex data and help to facilitate quick and informed decisions. Participants will be equipped with the knowledge and skills to analyse data using Power BI. They can use the Power BI Desktop to connect data (multiple data sources), shape data (with queries that build insightful and compelling data models), and create reports. The Power BI Desktop centralises, simplifies, and streamlines what can otherwise be a scattered, disconnected, and arduous process of designing and creating business intelligence repositories and reports.

Participants who fulfil all requirements will receive a Statement of Attainment (SOA) issued by the SkillsFuture Singapore (SSG).

  • Learn about the self-service business intelligence solutions
  • Apply Power BI Desktop to connect data (multiple data sources), shape data (with queries that build insightful and compelling data models), and create reports
  • Combine data techniques
  • Create interactive data visualizations

Identify self-service business intelligence (BI) solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Labs

Explore Power BI data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Labs

Apply shaping and combining data techniques

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Labs

Apply modelling data skillset

  • Relationships
  • DAX queries
  • Calculations and measures
  • Labs

Develop interactive data visualizations

  • Creating Power BI reports
  • Managing a Power BI solution
  • Labs

Participants will benefit from the hands-on practical sessions during the course.

This course is suitable for anyone who owns a Microsoft Excel 2013 Professional edition and uses it for advanced business intelligence purpose.

Prerequisite

Participants are assumed to:

  • Have basic knowledge of the Microsoft Windows operating system and its core functionality
  • Familiar with Microsoft Office applications, particularly Excel

Duration : 2 day (16.5 hrs)
Time : 9:00am to 6:30pm

Course Fee : $1,000.00
Nett Fee Incl. 7% GST : $1,070.00
Nett Fee after Training Grant* : $245.00 (SMEs) | $822.50 (Non-SMEs / Self-Sponsored)
Nett Fee after MCES* : $245.00
Nett Fee after WTS* : $195.50

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Key Benefits
  • Learn about the self-service business intelligence solutions
  • Apply Power BI Desktop to connect data (multiple data sources), shape data (with queries that build insightful and compelling data models), and create reports
  • Combine data techniques
  • Create interactive data visualizations
Course Contents

Identify self-service business intelligence (BI) solutions

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations of self-service BI
  • Microsoft tools for self-service BI
  • Labs

Explore Power BI data

  • Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • The Power BI service
  • Labs

Apply shaping and combining data techniques

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Labs

Apply modelling data skillset

  • Relationships
  • DAX queries
  • Calculations and measures
  • Labs

Develop interactive data visualizations

  • Creating Power BI reports
  • Managing a Power BI solution
  • Labs
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is suitable for anyone who owns a Microsoft Excel 2013 Professional edition and uses it for advanced business intelligence purpose.

Prerequisite

Participants are assumed to:

  • Have basic knowledge of the Microsoft Windows operating system and its core functionality
  • Familiar with Microsoft Office applications, particularly Excel
Course Details

Duration : 2 day (16.5 hrs)
Time : 9:00am to 6:30pm

Course Fee : $1,000.00
Nett Fee Incl. 7% GST : $1,070.00
Nett Fee after Training Grant* : $245.00 (SMEs) | $822.50 (Non-SMEs / Self-Sponsored)
Nett Fee after MCES* : $245.00
Nett Fee after WTS* : $195.50

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Course Application

Details Registration
January 6, 2020 - January 7, 2020 (9:00 am - 6:30 pm) Closed
January 22, 2020 - January 23, 2020 (9:00 am - 6:30 pm) Closed
February 10, 2020 - February 11, 2020 (9:00 am - 6:30 pm) Closed
February 26, 2020 - February 27, 2020 (9:00 am - 6:30 pm) Closed
March 9, 2020 - March 10, 2020 (9:00 am - 6:30 pm) Closed
March 26, 2020 - March 27, 2020 (9:00 am - 6:30 pm) Closed
August 3, 2020 - August 4, 2020 (9:00 am - 6:30 pm) Closed
August 17, 2020 - August 18, 2020 (9:00 am - 6:30 pm) Closed
September 3, 2020 - September 4, 2020 (9:00 am - 6:30 pm) Closed
September 14, 2020 - September 15, 2020 (9:00 am - 6:30 pm) Closed
October 1, 2020 - October 2, 2020 (9:00 am - 6:30 pm) Register Now
October 15, 2020 - October 16, 2020 (9:00 am - 6:30 pm) Register Now
November 9, 2020 - November 10, 2020 (9:00 am - 6:30 pm) Register Now
November 23, 2020 - November 24, 2020 (9:00 am - 6:30 pm) Register Now
December 10, 2020 - December 11, 2020 (9:00 am - 6:30 pm) Register Now
December 21, 2020 - December 22, 2020 (9:00 am - 6:30 pm) Register Now