OBJECTIVES
- Mampu menggunakan Power Pivot untuk membuat mekanisme pelaporan
- Melakukan automasi integrasi data dengan Power Query
- Membuat visualisasi dan dashboard dengan Power View
- Mempublikasikan dashboard ke web
AUDIENCE
- Data Processor
- Data Analyst
- Data Scientist
- Professional TI
- Professional Keuangan
PREREQUISITES
CONTENT
1. Structured Range of Data
1.1. Introduction
1.2. Name a Range of Cells
1.3. Excel Table
1.4. Advanced Functions
1. 5. Ensuring Data’s Integrity
2. Data Analysis
2.1. Quick Analysis Tools
2.2. Whatif Analysis
2.3. Forecasting & Trandline
2.4. Conditional Formating
3. Data Visualization with PivotTable & PowerMap
3.1. Database Concepts
3.2. Introducing the PivotTable
3.3. Customizing PivotTable
3.4. Creating Dashboard with PivotChart and Slicers
4. Data Preparation
4.1. Understanding the Internal Data Model
4.2. Introduction to a Power Pivot
4.3. Loading External Data into Power Pivot
4.4. Automating Tasks with Macros
4.5. Transform Data with Power Query
4.6. Improving Calculation Performance
Course Features
- Lectures 22
- Quizzes 2
- Duration 24 hours
- Skill level All levels
- Language Indonesia
- Students 8
- Certificate Yes
- Assessments Yes
Offline
- Start Date 16 Juli 2024
- End Date 19 Juli 2024
- Cost -
- Registered 8 Person
- Confirmed 8 Person Daftar