Training Online – 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

Form Pre-Registrasi

	Data Materi Training
Topik Training	: Training Online – 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 26, 2024

Training Online – Training Needs Analysis (TNA) and Training Evaluation (TE)

November 26, 2024

Training Online – Sertifikasi Kompetensi Operasional Pengelolaan Limbah B3 (OPLB3) by BNSP

November 26, 2024

Training Online – Sertifikasi Ahli K3 Ketenagalistrikan By BNSP