Data Analytics Fundamentals

AUDIENCE

1. Business Analysts
2. Data Analysts
3. Data Scientists
4. Database Engineers

PREREQUISITES

Tidak ada training khusus yang dipersyaratkan

CONTENT

1. Introduction to SQL and Data Manipulation

1.1 Introduction to SQL Commands
1.2 Setting Up Roles/Users, Schemas, Databases, and Tables
1.3 Displaying and Manipulating Data
1.4 SQL Functions

2. Data Governance

2.1 Introduction to Data Management
2.2 Data Governance
2.3 Data Architecture
2.4 Data Warehousing & Business Intelligence

3. Introduction to Tableau Visualization

3.1 Visualization Foundations
3.2 Visualizing Data
3.3 Building Dashboard

4. Sharing Tableau

4.1 Adding Formatting and Action
4.2 Preparing Data with Tableau Prep

5. Introduction to Data Science and Decision Makin

5.1 What and Why Data Mining?
5.2 Python and Data Science

6. Process & Data Preprocessing

6.1 Data Mining CRISP-DM Process
6.2 Pandas for Data Preparation
6.3 Pandas Data Structures

7. Data Analysis Communication Management

7.1 The Role of Communication in Data Insights
7.2 Identifying Stakeholders and Their Needs
7.3 Planning and Distributing Data Results
7.4 Managing Expectations and Interpreting Findings
7.5 Improving Communication Strategies