ASK Training

Course Description

In today’s corporate environment, fact based data plays a big part in shaping key business decisions. Reports, spreadsheets and slide decks jostle for space in our email inboxes, demanding for our attention as part of our decision making process. Are you finding it difficult to locate what you need? Or are you feeling swamped by the huge volume of reports to be analyzed before writing proposals to your bosses? Our 1-day ‘Bridging Big Data Analytics Using Power BI’ course can help you streamline your data analysis process.

 

So what can Power BI do for you? Power BI allows you to combine unrelated sources of data into interactive insights. You can transform endless rows and columns of numbers and words into colourful and visually appealing graphics that make your data narratives more impactful to the reader.  You can also set up alerts for yourself when data changes at the backend or set up automated reports to yourself via email at regular time intervals to be notified of the latest data trends. This will allow you to stay abreast of changes and amend your presentations in good time.

 

You can also share your data sources with anyone who needs access to them. Open up the Power BI service interface on your browser or mobile device and you and your colleagues will be able to work on the same dashboards and reports that update and refresh automatically to ensure that you are constantly working on the latest available data inputs.

 

Power BI also helps you remove any fear that tinkering on your end will affect original datasets and shared content. You can have greater peace of mind knowing that you can either choose to save your view of content or revert to the original default data view with the click of a button at anytime you want. This is possible even after you filter, slice or export the data at your disposal on your browser.

Course Objectives

At the end of this course, you should be able to:

Recognize key terminology phases concepts and benefits of data analytics

Recognize key terminology, phases, concepts and benefits of data analytics

Import shape and clean up data set before analysis

Import, shape and clean up data set before analysis

Execute advanced summarization techniques with pivot tables

Execute advanced summarization techniques with pivot tables

Set up Power BI Desktop

Set up Power BI Desktop

Create data visualizations to build and share reports

Create data visualizations to build and share reports

Build and share dashboards in Power BI Service

Build and share dashboards in Power BI Service

Recognize key terminology phases concepts and benefits of data analytics

Recognize key terminology, phases, concepts and benefits of data analytics

Import shape and clean up data set before analysis

Import, shape and clean up data set before analysis

Execute advanced summarization techniques with pivot tables

Execute advanced summarization techniques with pivot tables

Set up Power BI Desktop

Set up Power BI Desktop

Create data visualizations to build and share reports

Create data visualizations to build and share reports

Build and share dashboards in Power BI Service

Build and share dashboards in Power BI Service

Course Outline

You will be learning the following:

  • Common terminologies
  • Key concepts and benefits
  • Main phases of data analytics
  • Changing method of aggregation
  • Displaying multiple aggregation
  • Displaying values using built-in calculations
  • Applying frequency analysis
  • Filtering with report filter, slicer and timeline
  • Understanding reports and dashboards
  • Setting up common visualisations
  • Applying conditional formatting
  • Creating and configure a dashboard
  • Sharing a dashboard
  • Setting password in Access
  • Compacting and repairing a database
  • Importing data
  • Eliminating duplicate records
  • Cleaning up data
  • Setting up tables
  • Filtering with slicers
  • Connecting to data sources
  • Establishing the data model
  • Clean and transform data
  • Setting up reports
  • Adding calculations and measures
  • Adding interactivity features
  • Creating summary charts
  • Publishing report to Power BI Service
  • Sharing report

Course Fees And Grants

S$428.00 per participant (Incl. GST)

 

Click here for UTAP Fundings

 

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueMay-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21
Bridging Big Data Analytics using Power BITGS-2020502588JTC Summit07---15---
TGS-2020502588Mountbatten Square--19---17-

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

S$428.00 per participant (Incl. GST)

 

Click here for UTAP Fundings

 

SDF Subsidy for Company Sponsored Individuals: S$2 per training hour. For more information on SDF, please refer to www.skillsconnect.gov.sg > Funding Mechanism.

 

Applicants may use SkillsFuture Credit for this course

 

SKILLSFUTURE CREDIT
> Check your account

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer