Kompetensi

Data Analyst

Effective Data Story Telling with Self-Service Analytics

This course focuses on getting users of entry level to be embedded with self service analytics The course will cover various features available in the visualization tool and provide adequate hands on exercises to enhance the understanding of the discussed topics An adequate understanding of fundamental concepts of building worksheets and dashboards is a plus for this course

Course Objective

1. Memahami perhubungan antara pelbagai fungsi dan objek yang sedia ada.
2. Memahami cara dan kriteria untuk menghasilkan pelbagai jenis carta.
3. Menghasilkan dashboard visual dengan cekap melalui keupayaan sendiri.

Course Outcomes

1. Understand the relation between various functions and objects available
2. Understand the rules to create different types of charts
3. Feel competent in producing visual dashboards independently

Course Outline

1. Basics of Data Visualization
   • Introduction to Basic Elements in Visualization Tool
   • Supported Files and Database Connections
   • Various Output Documents: Export Files, Printing, Metadata, Data Extract
   • Appropriate Chart Types for Presentation and Analysis
   • Data Visualization Best Practices
   • References and Reading Materials
2. Functions and Analysis
   • Working with Data: Excel and Database
   • Data Treatment Features
   • Techniques in Data Transformation, Join Table and Union
   • Perform User Defined Calculation in Visualization Tool
   • Advanced Calculation with Table Calculation Functions
   • Working with Dates and Time
   • Data Filtering, Formatting, Sorting, Set and Grouping
   • Analytics Functions
   • Forecasting and KPI Monitoring
   • Visualization with Map
   • Sharing Interactive Reports with Others
3. Dashboard Building
   • Introduction to dashboard building elements
   • Types of dashboards for different target users
   • Creating a dashboard for visual analysis
   • Using actions and guided analytics function
   • Mini project to build a complete management dashboard
4. Advanced Data Visualization
   • Working with single data sources
   • Using multiple data sources
   • Using calculations in visualization tool
   • Advanced table calculations
   • Creating and using parameters
   • Defining subsets of your data
   • Geocoding
   • Viewing distributions
   • Statistics and forecasting
   • Dashboards and stories