Big Data Analysis & Reporting (Online Training)

0

Overview

  • With little effort, you can organize and summarize multiple data sets using pivot table
  • Analyzing data to see comparisons, patterns, and trends in your data
  • Same data but you can view at different perspective to make business decision

When to Use

  • To extract only useful data from multiple and large data sets
  • Track the sums of data from long rows or columns
  • Grouping data into categories or break down into time period

Target Audience

  • Sales Executive / Managers
  • Business Analysist
  • Resource Planning Team
  • Project Managers
  • Purchasing Manager
  • Financial Executive / Managers

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise over a video conference platform.

Pre-Requisites

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to use Auto Filter command
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions

Course Modules

  • Lesson 1 : Getting and transforming data from multiple of sources
    • Import data from various database / system
    • Cleaning duplicate entry
    • Formatting the right data type
    • Splitting or joining columns or text
    • Removing spaces and special characters from your data

    Lesson 2 : Joining multiple tables
    • Joining all rows from multiple query into one query
    • Joining selected columns from multiple query into one query

    Lesson 3 : Getting Data to Analyse
    • Loading query into Data Model
    • Creating table relationship
    • Adding new calculated column based on existing column

    Lesson 4 : Analysing Data in Power Pivot
    • Creating Pivot Table from Data Model
    • Formatting Pivot Table
    • Refreshing Pivot Table for additional data

Get To Know The Trainer

Trainer Jarina

Trainer Jarina

 4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

  • 4 hours of Live Online / Virtual Training
  • 19 August 2020
  • 2pm - 6pm

COURSE BENEFITS

  • E-Certification
  • 14 Days of Email Support
  • HRDF Claimable

ALL IN FROM ONLY

RM49/PAX

*T&C Applies

What Other People Bought

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

Address

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?