>- Selamat datang di website PT Fiqry Jaya Manunggal. Semoga anda senantiasa sehat afiat. Kami siap melayani anda
Database Analysis & Dashboard Reporting
Rp 6.950.000| Stok | Tersedia |
| Kategori | 100+ Pelatihan Engineering & Migas Profesional 2026 | Sertifikat Resmi, Administration, Engineering, Human Resource, IT, Soft Skills |
4 – 5 February, 2025 di Hotel Sofyan Cikini Jakarta
Andika Bayu Saputra, S.Kom, M.Kom
Database Analysis & Dashboard Reporting
Powerful Database Analysis & Dashboard Reporting using Microsoft Excel
BACKGROUND:
The process of analyzing data and creating a dashboard summary report from text files imported from large applications, such as SAP/ERP, is still often conducted using time-consuming methods, taking hours or even days, even when using Microsoft Excel.
However, by employing advanced methods—already available in Excel—and utilizing its latest functions, tasks such as data processing, data validation, data analysis, and reporting can be completed quickly, even when dealing with over 100,000 (one hundred thousand) records and can be tailored to meet the requirements of the employee’s superiors.
Moreover, the results can be presented in the form of an interactive, dynamic, and visually appealing dashboard summary report for further database analysis. Excel also offers powerful features that are not enabled by default, such as the Solver Analysis Tool Pack.
By using the Data Solver Analysis tool, budgeting analysis simulations can be conducted quickly and easily, with a high degree of accuracy.
With the existing validation and database analysis functions, there is no longer a need to develop a separate database analysis and summary reporting application using specific programming languages, which would require significant time and cost. All the aforementioned tasks can be efficiently, accurately, and easily handled using Excel.
OBJECTIVES:
- Mastering advanced data analysis techniques
- Enhancing data visualization skills
- Optimizing database utilization in Excel
- Understanding advanced tools & features in Excel
- Improving work efficiency
- Supporting data-driven decision-making
Recommended Participants
- Data Analysts & Business Analyst
- Finance & Accounting Professionals
- Sales & Marketing Teams
- Operations & Supply Chain Managers
- Project Managers who require data processing
- Human Resources Analysts
- IT Support Staff handling data reporting
- Administrative Staff responsible for data management
- Entrepreneurs or Small Business Owners managing their own data
Course Outline
- Step-by-step operation for external data converting process to Excel database.
- Created & designed worksheet using Sparklines object
- How to use Auto Filter with union field key &Custom Filter
- Optimization filtering column in the database.
- How to make an Advance Filter (Criteria and Output Data Query).
- How to make and use Consolidate Methods.
- Removing Duplicate Rows
- Using the Excel Built-In Data Entry Form
- Creating a Drop-Down List in a Cell
- How to make Ranking Values
- Performing a LOOKUP function.
- How to use Operational Table with ADVANCE LOOKUP Function
- How to make and use PivotTable Optimization
- Created and designed worksheet report using PivotTable
- Creating and Utilizing Pivot Charts Optimized with Slicer Panels
- Created and designed Cells Graphic using Spark Lines
- How to make and use Data Validation
- How to make and use Data Validation Automation with Table Function.
- How to make and use the Data Table Method for one-cell input and two-cell input.
- How to make & use data analysis method (What If Analysis).
- How to make and use the analysis function.
- How to make active and use solver analysis tool pack:
- How using of Format Cells for Locked & Hidden Cells
- How using of Using Allow Users to Edit Range (Permission User Access Setting)
- How to use of Protect Sheet (Select Locked Cells & Select Unlocked Cells)
- Case study implementation
About The Course Leader
Andika B Saputra S.Kom, MKom
Andika B. Saputra, S.Kom, M.Kom, is a practitioner, instructor, and lecturer with a strong background in Information Technology (IT). He earned his Bachelor’s and Master’s degrees in IT in 2013 with commendable performance and is currently pursuing a doctoral degree in the same field.
Since 2010, Andika built extensive practical experience as both an HRD Manager and Operational Manager. In 2016, he started working as a lecturer and took on the role of Head of the Informatics Bachelor Study Program in Jogjakarta, Indonesia. Alongside his academic roles, he consults and delivers public and in-house IT training, including certified sessions by the Indonesia National Professional Certification Agency (BNSP). Clients from oil and mining companies across Sumatra, Kalimantan, and Java actively seek his expertise.
In addition to his formal education, Andika holds an impressive array of certifications, such as Certified Digital Marketing (CDMP), Google Digital Marketing, Certified International Information System Auditor (CIISA), IT Auditor (IATI), and several certifications in design, big data, Python, and IBM technologies.
He has delivered various high-impact training programs, including Google Digital Marketing, Project Management with Primavera and Microsoft Project, Data Science with Python, IT Auditing, Big Data & Cloud Computing, UI/UX Design, and ITIL (Information Technology Infrastructure Library), among many others. His expertise covers a wide spectrum of IT domains, reflecting his commitment to advancing knowledge in the industry.
Database Analysis & Dashboard Reporting
Instrumentation, Electrical and Control System
BACKGROUND: Covers the principles of industrial instrumentation, sensor, signal transmission, interfacing, actuator, process control, the operation of basic PID Controller on PLC and DCS. Describe the electronics of instrument, interface device and controller. Also provides the usually found advanced PID configuration in industrial systems. Simple method for PID controller tuning is also discussed. OBJECTIVES: After…
Rp 7.950.000
Kalibrasi dan Ketidakpastian Pengukuran
BACKGROUND: Kalibrasi adalah proses membandingkan pembacaan suatu peralatan atau sistem dengan peralatan lain yang telah dikalibrasi & dijadikan referensi terhadap sekumpulan parameter yang diketahui. Peralatan yang digunakan sebagai acuan harus dapat ditelusuri secara langsung ke peralatan yang dikalibrasi sesuai ISO/IEC 17025. Tujuan kalibrasi adalah untuk meminimalkan ketidakpastian pengukuran dengan memastikan keakuratan peralatan uji. Kalibrasi mengkuantifikasi…
Rp 7.950.000
Pengoperasian Unit Pembangkit Listrik
BACKGROUND: Unit pembangkit listrik adalah komponen vital dalam penyediaan energi listrik yang andal untuk memenuhi kebutuhan industri, komersial, dan rumah tangga. Pengoperasian yang efisien dan aman dari unit pembangkit ini memerlukan pemahaman mendalam tentang prinsip kerja mesin pembangkit, sistem kelistrikan, serta peralatan pendukung lainnya. Dalam era modern ini, penggunaan teknologi canggih pada unit pembangkit listrik…
Rp 7.950.000
Manajemen Risiko Sesuai ISO 31000
BACKGROUND: Proses pengelolaan resiko menurut ISO 31000 seharusnya merupakan bagian yang terintegrasi, melekat dalam budaya dan praktik manajemen, dan tercustomisasi menurut proses bisnis organisasi. Menurut ISO 31000, asesmen risiko merupakan bagian yang paling penting dan fundamental dalam proses pengelolaan risiko. Oleh karena itu, organisasi perlu melakukan asesmen risiko yang benar agar memperoleh laporan profil risiko…
Rp 7.950.000
Process Safety & Asset Integrity Management System
Background: Process Safety & Asset Intergrity Management System, biasanya merupakan dua hal yang terpisah. Padahal keselamatan proses (Process Safety) dan integritas aset (Asset Integrity) merupakan fondasi utama dalam industri migas yang berisiko tinggi. Kegagalan pengelolaan kedua aspek ini bisa menimbulkan kerugian besar, baik dari sisi manusia, lingkungan, maupun bisnis. Process Safety & Asset Integrity Management…
Rp 7.950.000
Hazard Analysis Critical Control Point (HACCP) & Culinary
BACKGROUND: Hazard Analysis Critical Control Point (HACCP) & Culinary Makanan yang aman & sehat sangat penting bagi karyawan untuk mendapatkan nutrisi yang sesuai. Makanan yang dimakan tidak boleh membahayakan konsumennya. Baik melalui faktor biologis, kimiawi atau melalui kontaminan lainnya. Melalui food safety dan kualitas yang dikontrol, akan menjamin didapatkannya makanan yang aman, baik melalui seluruh…
Rp 6.950.000