Complete Data Analysis for Beginners (7.5 hrs)

Course Code: CRS-N-0046591

In this course, participants will be introduced to the basic concepts of Data Analytics and leveraged on technology to make sense from the data. This knowledge helps participants to understand their data better and enable them to make informed decisions.

  • Learn about the basic concepts of Data Analytics
  • Leverage on technology to analyse date
  • Make better decisions in different contexts

Basic concepts of data

  • Data versus information
  • Big data buzz
  • V’s of data
  • How to make big data actionable?

Concepts of Data Analytics

  • Basics of Data Analytics
  • Types of Data Analytics
  • Why Data Analytics
  • Data Analytics and business users [self-service business intelligence (BI)]
  • Descriptive and predictive Data Analytics with Excel

Data Analytics process

  • Choosing Data Analytics platform
  • Accessing data
  • Importing data
  • Cleaning and transforming data
  • Presenting results of Data Analytics – reports and dashboards
  • Tables and Pivot Tables
  • Introduction to Power Pivot and Power View

Let the visualizations do the talking

  • Creating bar charts, line charts, pie charts, bubble charts
  • Exploring data visualizations like cards and tiles, maps using Power View
  • Filtering data with slicers
  • Working with additional properties of data visualizations

Exporting Data Analytics reports and Dashboards

  • Exporting to different formats (Excel, PowerPoint, PDF)
  • Share the Dashboard with others

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

This course is designed for anyone with minimal or no prior knowledge of Data Analytics and would like to acquire solid foundation skills to understand data better.

Prerequisite

Participants must have a basic working knowledge of Excel 2016 or earlier versions.

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $280.00
Nett Fee Incl. 7% GST : $299.60
SDF Support* : $15.00

* 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 basic concepts of Data Analytics
  • Leverage on technology to analyse date
  • Make better decisions in different contexts
Course Contents

Basic concepts of data

  • Data versus information
  • Big data buzz
  • V’s of data
  • How to make big data actionable?

Concepts of Data Analytics

  • Basics of Data Analytics
  • Types of Data Analytics
  • Why Data Analytics
  • Data Analytics and business users [self-service business intelligence (BI)]
  • Descriptive and predictive Data Analytics with Excel

Data Analytics process

  • Choosing Data Analytics platform
  • Accessing data
  • Importing data
  • Cleaning and transforming data
  • Presenting results of Data Analytics – reports and dashboards
  • Tables and Pivot Tables
  • Introduction to Power Pivot and Power View

Let the visualizations do the talking

  • Creating bar charts, line charts, pie charts, bubble charts
  • Exploring data visualizations like cards and tiles, maps using Power View
  • Filtering data with slicers
  • Working with additional properties of data visualizations

Exporting Data Analytics reports and Dashboards

  • Exporting to different formats (Excel, PowerPoint, PDF)
  • Share the Dashboard with others
Learning Methodology

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

Who Should Attend

This course is designed for anyone with minimal or no prior knowledge of Data Analytics and would like to acquire solid foundation skills to understand data better.

Prerequisite

Participants must have a basic working knowledge of Excel 2016 or earlier versions.

Course Details

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $280.00
Nett Fee Incl. 7% GST : $299.60
SDF Support* : $15.00

* 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 28, 2020 - January 28, 2020 (9:00 am - 5:30 pm) Register Now
March 2, 2020 - March 2, 2020 (9:00 am - 5:30 pm) Register Now
May 13, 2020 - May 13, 2020 (9:00 am - 5:30 pm) Register Now
July 17, 2020 - July 17, 2020 (9:00 am - 5:30 pm) Register Now
September 17, 2020 - September 17, 2020 (9:00 am - 5:30 pm) Register Now
November 5, 2020 - November 5, 2020 (9:00 am - 5:30 pm) Register Now