Database Analysis & Dashboard Reporting

Course Outline

1. Step-by-step operation for external data converting process to Excel database.
2. Created & designed worksheet using Sparklines object
3. How to use Auto Filter with union field key &Custom Filter
4. Optimization filtering column in the database.
5. How to make an Advance Filter (Criteria and Output Data Query).
6. How to make and use Consolidate Methods.
7. Removing Duplicate Rows
8. Using the Excel Built-In Data Entry Form
9. Creating a Drop-Down List in a Cell
10. How to make Ranking Values
11. Performing a LOOKUP function.
12. How to use Operational Table with ADVANCE LOOKUP Function
13. How to make and use PivotTable Optimization
14. Created and designed worksheet report using PivotTable
15. Creating and Utilizing Pivot Charts Optimized with Slicer Panels
16. Created and designed Cells Graphic using Spark Lines
17. How to make and use Data Validation
18. How to make and use Data Validation Automation with Table Function.
19. How to make and use the Data Table Method for one-cell input and two-cell input.
20. How to make & use data analysis method (What If Analysis).
21. How to make and use the analysis function.
22. 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)
23. 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.