Gunakan Excel Dashboard satu halaman untuk menyajikan berbagai infomasi bisnis secara visual yang akan membantu anda membuat keputusan bisnis yang lebih optimal. Dalam workshop ini anda akan belajar membuat dashboard yang menarik dan berkualitas profesional dengan menggunakan Excel. Peserta akan belajar best practice teknik - teknik visualisasi data dan prinsip-prinsip kunci dalam mendesign Dashboard yang akan mengubah data mentah menjadi visual yang menarik dan interaktif. Peserta akan mempelajari berbagai teknik yang digunakan oleh Business Intelligence Analyst dan Data Scientists dengan mengerjakan 4 buah Dashboard Project yang unik dan menarik.

Materi :
• Data Viz Best Practices
Data Viz 101, The 10-Second Rule, The 3 Key Questions, Essential Visuals, Chart Formatting Tips, Storytelling with Data, Common Visualization Mistakes, Data Visualization Best Practices
• Project 01: Single Visual
Project Brief, Selecting an Effective Chart Type, Creating the Chart in Excel, Applying Chart Formatting, Telling the Story
• Project 02: Exploratory Dashboard
Project Brief, Designing the Purpose and Visuals, Preparing the Filters and Interactivity, Using AVERAGEIFS for Conditional Calculations, Creating a Bar Chart, Sorting Based on Formulas, Creating a Donut Chart, Grouping Donut Slices, Creating a Combo Chart, Splitting Combo Chart Elements, Creating a Filled Map, Adding New Data with Data Types, Switching Between Series in a Map, Setting Up the Dashboard Layout, Using Color Strategically, Dynamically Highlighting Series, Inserting Form Controls, Creating Custom Color Themes, Protecting the Dashboard
• Project 03: Interactive KPI Dashboard
Project Brief, Defining the Purpose & Visuals, Preparing for Scale, Using Name Manager for Filter Values, Calculating KPIs, Applying Conditional Formatting Rules, Inserting Linked Pictures, Using Absolute Structured References, Creating a Line Chart, Hiding Zero Values in a Line Chart, Creating Complementary Bar Charts, Dynamically Sorting Data, Creating Top/Bottom Tables, Setting Up the Dashboard Layout, Using Color Strategically, Using the Titles to Tell a Story, Sharing the Dashboard Online, Formula Based Formatting.
• Project 04: Explanatory Dashboard
Project Brief, Understanding the Story, Defining the Purpose and Visual, Visualizing Seasonality with a Combo Chart, Contrasting Gains and Losses with a Column Chart, Conditional Custom Number Formats, Using Stacked Bars Instead of Pies, Visualizing Part of a PivotTable, Setting Up the Dashboard Layout, Using Text to Tell a Story, Saving the Dashboard as an Image

Cocok diikuti oleh
Setiap orang yang bertanggung jawab untuk menyiapkan Dashboard, Scorecards atau Laporan KPI berbasis Excel. Workshop ini sangat direkomendasikan untuk:
• Direktur
• General Manager
• Chief Financial Officer
• Finance Manager
• Accountants
• Marketing Manager,
• Sales Manager
• HR Manager
• Business Owner
• Setiap orang yang terkait dengan pelaporan bisnis

 

Pembicara 1 : Dr. Ikin Solihin, MBA, AFM, CTP, FPAC, CMA, FRM, FMVA, CSCP (Praktisi Keuangan
Pembicara 2 : Data)

Tanggal : 10-11 July 2023

Waktu : 08.30 - 12.00

Venue : Zoom Meeting

contact : 081311116063