ASK Training

Course Description

In today’s corporate environment, fact-based data plays a big part in shaping key business decisions. We have seen reports, spreadsheets and slide decks jostle for space in our email inboxes. Hence, it is demanding for our attention as part of our decision-making process. 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. Eventually, you get to make your data narratives more impactful to the reader.  In addition, you can set up alerts for yourself when data changes at the backend. Besides, you can set up automated reports to yourself via email at regular time intervals. This is to keep you notified of the latest data trends. Hence, you can stay abreast of changes and amend your presentations accordingly.

 

You can also share your data sources with anyone who needs access to them. For instance, you and your team open up the Power BI service interface on the browser or mobile device at the same time. All are able to work on the same dashboards and reports simultaneously. The updates can be refreshed automatically to ensure that you are constantly working on the latest data inputs.

 

Power BI also helps you remove any fear that tinkering on your end will affect original datasets and shared content. Eventually, you can have peace of mind knowing that you can switch the view of content or revert to the original default data easily. 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

CourseCodeVenueJun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22
Bridging Big Data Analytics using Power BITGS-2020502588JTC Summit15--21--07
TGS-2020502588Mountbatten Square--10--09-

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 HRP Portal, 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