Excel Dashboard with Power Pivot and Power View

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 

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

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Excel Dashboard with Power Pivot and Power View
Link
*Jumlah Peserta	Estimasi Jumlah Peserta yang di ajukan
*Nama Peserta Yang Didaftarkan
	Personal Data
*Nama
*Jabatan	Jabatan/Divisi/Departement
*Nama Perusahaan
*Alamat Perusahaan
*Email Perusahaan
*Email Alternatif	eg: gmail, yahoo, hotmail
*Telepon Kantor
Ekstensi
*Handphone
	* Harus di isi
	Submit

SIMILAR ARTICLES

November 25, 2024

Sertifikasi Pelayanan Prima (Service Excellent) by BNSP

November 25, 2024

Sertifikasi Pengelolaan Aset by BNSP

November 25, 2024

Sertifikasi Public Speaking by BNSP