Home » Excel Dashboard with Power Pivot and Power View
Excel Dashboard with Power Pivot and Power View
May 27, 2025
Jadwal Pelatihan Excel Dashboard with Power Pivot and Power View
| Tanggal | Tempat | Kota | | 03 - 05 Juni 2025 | - | Yogyakarta |
DESKRIPSI
Memaksimalkan penggunaan Excel terutama pengolahan data data presentasi laporan yang dinamis dan interaktif sangat dibutuhkan dalam kebutuhan manajemen perusahaan, karenanya penggunaan fitur Excel Add-in cukup dibutuhkan yaitu Power Pivot dan Power View yang bisa Anda gunakan untuk melakukan analisis data yang hebat dan membuat model data yang canggih. Dengan Power Pivot, Anda bisa mengolah data bervolume besar dari berbagai sumber, melakukan analisis informasi dengan cepat, dan membagikan data/informasi dengan mudah serta menarik dalam bentuk dashboard analysis.
MATERI Training Excel Dashboard with Power Pivot and Power View
1. Creating a Power Pivot Data Model
- Creating the Excel Workbook
- Enabling the Power Pivot Add-In
- Loading Tables from a SQL Server Database
- Loading a Table from an OData Data Service
- Loading a Table from an Excel Workbook
- Relating Tables
- Exploring the Power Pivot Data
- Marking the Date Table
- Configuring Column Value Sorting
- Creating Calculated Columns
- Enriching the Model with Hierarchies
- Defining Calculated Fields
- Defining a KPI
- Creating a Pivot Table Report
- Finishing Up
2. Creating Power View Reports
- Exploring the Power View Designer & Setting the Report Title
- Creating a Card Report to Display Individual Products
- Creating the Sum of Revenue by Demographic Chart
- Filtering the View
- Task 5 – Creating the Sum of Quantity by Category Chart
- Interacting with the Data Regions
- Transforming the Sum of Quantity by Category Chart to a Scatter Chart
- Introducing Tiling to the Card Report
- Adding a Slicer and Map
- Finishing Up
TRAINING METHOD
Pre Test
Presentation
Discussion
Case Study
Post Test
Evaluation
FACILITIES
Training Kit
Handout
Certificate
1x Lunch & 2x Coffee Break
Souvenir
