| Jadwal Kegiatan Public Training |
| Tanggal posting 22-Jan-25 19:50 wib. dilihat sebanyak 30
kali
|
| Jadwal Kegiatan Public Training Excel Power Query Fundamental Training - Purnama Academy di H.R. Rasuna Said Jakarta Selatan - Purnama Academy |
| Rp
-Hubungi Whatsapp-
( 4 Days )
|
|
| Posting oleh : Purnama Academy , Whatsapp. 08380838**** |
|
|
|
| Jadwal Kegiatan Public Training , Jawa Barat
|
|
|
| |
|
|
| |
jadwalkegiatan.com
|
| |
|
|
|
| |
|
|
| |
 Detail dan Status Jadwal Kegiatan Sampai Dengan Januari 2025 |
| Waktu Pelaksanaan |
4 Days |
| Biaya |
Rp
-Hubungi Whatsapp- |
| Keterangan |
Info Terbaru bulan Januari 2025 , Public Training di H.R. Rasuna Said. purnamaacademy, Whatsapp 083808380001. Excel Power Query Fundamental: 4-Day Intensive Training
Overview
Unlock the full potential of Excel by mastering Power Query in our 4-day intensive Excel Power Query Fundamental training, hosted by Purnama Academy. This course is tailored for professionals who want to enhance their data management and transformation skills using Power Query, a powerful Excel tool that simplifies data preparation and analysis.
Delivered by certified and experienced trainers, this hands-on course will cover the essentials of using Power Query, from connecting to various data sources to cleaning, transforming, and loading data into Excel. Participants will gain practical skills to streamline their data processes and make informed business decisions.
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 and Data Connections
Morning Session:
Overview of Power Query: Features and Benefits
Getting Started: Setting Up Power Query in Excel
Connecting to Data Sources: Excel, CSV, Databases, and Web Data
Afternoon Session:
Importing Data: Managing Queries and Data Connections
Data Preview and Basic Transformations: Filtering, Sorting, and Removing Columns
Hands-on Exercise: Connecting to and Importing Data from Multiple Sources
Day 2: Data Transformation Techniques
Morning Session:
Advanced Data Transformations: Merging, Appending, and Grouping Data
Working with Columns: Splitting, Combining, and Unpivoting Columns
Handling Data Types: Changing Data Types and Custom Formatting
Afternoon Session:
Using Formulas in Power Query: Custom Columns and Calculations
Managing Errors: Handling Missing Data and Errors in Queries
Hands-on Exercise: Performing Complex Data Transformations
Day 3: Data Loading and Integration
Morning Session:
Loading Data into Excel: Table, PivotTable, and Data Model
Refreshing Data: Automatic and Manual Refresh Options
Combining Data from Multiple Queries: Using M Language for Custom Scripts
Afternoon Session:
Integrating Power Query with Power Pivot: Creating Data Models and Relationships
Using Power Query with Power BI: Exporting Queries to Power BI for Advanced Analytics
Hands-on Exercise: Building Integrated Reports with Power Query and Power Pivot
Day 4: Best Practices and Advanced Features
Morning Session:
Query Optimization: Improving Performance and Efficiency
Best Practices in Power Query: Naming Conventions, Documentation, and Organization
Automating Data Processes: Scheduling and Advanced Data Loads
Afternoon Session:
Introduction to Power Query Parameters: Creating Dynamic Queries
Final Project: End-to-End Data Transformation and Analysis with Power Query
Course Review and Q&A
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, to suit your learning preferences.
This syllabus provides a comprehensive introduction to Excel Power Query, ensuring participants gain the skills needed to efficiently manage and analyze data within Excel. Adjustments can be made to tailor the content to specific needs or objectives. *** 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 : Wednesday, 22-January-2025, 14: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 'Jadwal Kegiatan Public Training Excel Power Query Fundamental Training - Purnama Academy di H.R. Rasuna Said Jakarta Selatan - Purnama Academy ' . Di-generate otomatis oleh google map Api update bulan Januari 2025 .
Informasi selengkapnya silahkan hubungi langsung pemilik iklan kegiatan |
| |
|
|
| |
|
|
| |
|
|
|
|
|
