OBJECTIVE
To jumpstart from Business Users to Empowered Data Users who can do analysis and communicate with technical people on the same frequency.
Why this course ?
- Address the Data Team's business context gaps
- Harness the power of data for a significant boost in productivity
- Empower business pros to expertly leverage crucial data
Who's this course for ?
- Business function (non-technicial)
- No background in data (except excel)
Course Structure
- 6 session (+ optional 2)
- 3 hr. / session
- 1 session / week
- onsite max 20 people
Data Jumpstart Course's Contents
WEEK 1
Welcome to the Data Era
Introduction
• Trends & importance of data
• Data usage case study
• The AI hype – Famous AI for work productivity
• Workshop : Brief Canvas – Briefing Chat GPT / Bard
• How to survive in AI era?
• AI implementation & concerns
• Key success factors for data project
• Workshop : Bring AI / data to your daily work
WEEK 2
Quick Wins Using Dashboards
Power BI / Looker Studio / Tableau
• What are dashboards? Why should we do dashboards?
• Dashboard Canvas
• Workshop : Dashboard Canvas
• Data Visualization 101
• What is Power BI?
• Basic function of Power BI
• Workshop : Build dashboard with Power BI
WEEK 3
Data Wrestling & Wrangling
Data Engineering
• Data type & data structure
• SQL select
• Data warehouse & architecture
• Dimensional data modelling
• Table storage type
• Workshop: Design your ideal database
• Data flow: from system to business
• Data freshness & cost
• Data security
• PDPA law
WEEK 4
Fantastic Data
& Where to Find Them
Data Collection
• Metadata, metrics & dimensions
• Research data
• Systematic data
• Data collection
• Open data
• Website data & social listening
• Case study on data collection
• Workshop : Decide your data sources
WEEK 5
Laputa Wasn’t Built in One Day
Cloud Architecture
• What is cloud? Why do people use it?
• Popular cloud : AWS, GCP, Azure
• Cloud structure : tenant, subscription, resources
• Cloud identity services & access control
• Cloud storage
• Cloud compute
• Cloud virtual machine
• Cloud data pipeline
• Example of cloud infrastructure
• Workshop : Set-up Azure, scrape data and store in SQL
WEEK 6
Data Alchemists : Turning Data into Gold
Data Sciences
• What is data sciences?
• GIGO – Garbage in, Garbage out
• Supervised learning models
• Unsupervised learning models
• Deep learning models
• Scope of data analysis
• ML Ops
• Python 101
• Workshop : Predicting yes/no for upselling
