| Silabus Training Inhouse Training |
| Tanggal posting 25-Nov-24 00:50 wib. dilihat sebanyak 46
kali
|
| Silabus Training Inhouse Training Data Analytics and Data Visualization using Excel Power Query and Power Pivot Trainin di H.R. Rasuna Said Jakarta Selatan - Purnama Academy |
| Rp
-Hubungi Whatsapp-
( 4 Days )
|
|
| Posting oleh : Purnama Academy , Whatsapp. 08380838**** |
|
|
|
| Silabus Training Inhouse Training , Jawa Barat
|
|
|
| |
|
|
| |
jadwalkegiatan.com
|
| |
|
|
|
| |
|
|
| |
 Detail dan Status Silabus Training Sampai Dengan November 2024 |
| Waktu Pelaksanaan |
4 Days |
| Biaya |
Rp
-Hubungi Whatsapp- |
| Keterangan |
Info Terbaru bulan November 2024 , Inhouse Training di H.R. Rasuna Said. purnamaacademy, Whatsapp 083808380001. Data Analytics and Data Visualization using Excel Power Query and Power Pivot: 4-Day Intensive Training
Overview
Elevate your data analysis and visualization skills with our comprehensive 4-day Data Analytics and Data Visualization using Excel Power Query and Power Pivot training, offered by Purnama Academy. This course is perfect for professionals looking to harness the advanced data management, analysis, and reporting capabilities within Excel.
By leveraging Power Query for data extraction, transformation, and loading (ETL) alongside Power Pivot for robust data modeling and DAX (Data Analysis Expressions) calculations, participants will be able to create sophisticated, dynamic dashboards and reports. Delivered by certified and experienced trainers, this hands-on course will enable you to turn raw data into actionable insights efficiently.
Training Details
Duration: 4 Days
Time: 09:00 AM - 04:00 PM (Each Day)
Methods:
Public Offline Training
Inhouse Training
Online via Zoom
Contact: For more information and registration, please contact our sales team via WhatsApp at 0838-0838-0001.
Course Syllabus
Day 1: Introduction to Power Query
Morning Session:
Overview of Excel Power Query: Features and Benefits for Data Analysis
Connecting to Various Data Sources: Excel, CSV, Databases, Web Data, and More
Basic Data Transformations: Filtering, Sorting, Removing Duplicates, and Basic Data Cleanup
Afternoon Session:
Advanced Data Transformation Techniques: Merging, Appending, and Grouping Data
Creating Custom Columns and Calculations using M Language
Hands-on Exercise: Data Preparation and Transformation using Power Query
Day 2: Introduction to Power Pivot and Data Modeling
Morning Session:
Introduction to Power Pivot: Creating Data Models within Excel
Establishing Relationships between Multiple Tables
Introduction to DAX: Basic Calculations, Measures, and Calculated Columns
Afternoon Session:
Time Intelligence Functions in DAX: Date Calculations, Year-to-Date, Quarter-to-Date, etc.
Building Hierarchies and Key Performance Indicators (KPIs) in Power Pivot
Hands-on Exercise: Developing a Data Model with Power Pivot and DAX
Day 3: Data Visualization with PivotTables and PivotCharts
Morning Session:
Creating Dynamic Reports: PivotTables and PivotCharts using Power Pivot
Enhancing Visualizations with Slicers, Timelines, and Conditional Formatting
Advanced Reporting Techniques: Combo Charts, Sparklines, and Custom Styles
Afternoon Session:
Integrating Power Query and Power Pivot: Seamless Data Flows from Source to Visualization
Using Excel Power View: Introduction to Interactive Data Visualizations within Excel
Hands-on Exercise: Designing Interactive Dashboards with Power Query and Power Pivot
Day 4: Best Practices and Real-World Applications
Morning Session:
Best Practices in Data Modeling: Performance Optimization and Data Management
Automating Data Analysis Processes: Refreshing Data and Workflow Automation
Case Studies: Practical Applications of Power Query and Power Pivot in Business Scenarios
Afternoon Session:
Final Project: Comprehensive Data Analysis and Visualization Task using Power Query and Power Pivot
Course Review and Q&A: Discussing Participant-Specific Challenges and Use Cases
Certification of Completion: Presentation of Certificates to Participants
Registration and Contact
To register for the training or for more information, please contact our sales team via WhatsApp at 0838-0838-0001. We offer flexible training options, including public offline sessions, in-house training, and online via Zoom, tailored to suit your learning preferences. *** Other Topics : Microsoft Excel VBA Macro, Power Query, QGIS, IBM Cognos, PHP Web Development, Microsoft Project, Power BI, Python Programming, Oracle, Magento, Primavera P6, JSON, Angular, JQuery, Tableau visit www.purnamaAcademy.com atau whatsapp 0838-0838-0001 | Posting Date : Sunday, 24-November-2024, 19:50 |
| |
|
|
| Kontak Kegiatan |
| Nama Kontak |
Purnama Academy |
| Kontak HP / Whatsapp |
08380838****
|
| Lokasi / Venue Kegiatan |
H.R. Rasuna Said |
| |
Jawa Barat, Jakarta Selatan |
| |
|
| Peta Lokasi Kontak |
|
 |
Perbesar Peta !
Detail peta sesuai alamat lokasi yang tertera di iklan 'Silabus Training Inhouse Training Data Analytics and Data Visualization using Excel Power Query and Power Pivot Trainin di H.R. Rasuna Said Jakarta Selatan - Purnama Academy ' . Di-generate otomatis oleh google map Api update bulan November 2024 .
Informasi selengkapnya silahkan hubungi langsung pemilik iklan kegiatan |
| |
|
|
| |
|
|
| |
|
|
|
|
|
