Certified Google Sheets Professional – (CDIP-GS)

📘 Certified Google Sheets Intelligence Professional – (CDIP-GS)

The CDIP-GS is a professional certification examination designed to validate an individual’s applied expertise in Google Sheets for data analytics and business intelligence. It focuses on using Sheets’ advanced capabilities — including query functions, Apps Script automation, connected data sources, and visualization tools — to perform governed, end-to-end analytics workflows in collaborative environments.

This certification confirms the holder’s proficiency in designing, analyzing, and automating professional-grade data intelligence solutions entirely within Google Sheets, following reproducibility and governance standards recognized by the Council of Certified Data Intelligence Professionals (CDIPS).

---

🧭 Modules, Projects, and Examinations

The Certified Google Sheets Intelligence Professional – (CDIP-GS) certification comprises five structured modules and one capstone project, each assessing real-world analytical problem-solving using verified datasets and governed documentation practices.

Candidates must complete all assignments, examinations, and the final capstone project to qualify for certification issuance.

Component	Purpose	Evaluation Method	Weight
Module Assignments	Demonstrate practical Google Sheets analytics, automation, and visualization skills.	Submission of completed deliverables from 2 of 4 case study options per module.	45%
Module Examinations	Assess theoretical and applied understanding of Google Sheets data tools.	Timed online examinations with function-based and scenario questions.	25%
Capstone Project	Evaluate ability to execute a full analytics workflow (Extract → Transform → Model → Visualize → Automate).	Complete project submission with documentation and automation script.	25%
Professional Conduct & Documentation	Ensure ethical practice, reproducibility, and compliance with governance standards.	Review of documentation, dataset usage, and audit notes.	5%

Passing Requirement: Minimum overall score of 70%.
Reassessment Policy: Retakes available for modules or capstone within 45 days.

---

🧩 Module Overview

Module	Focus Area
Module 1	Data Import & ETL in Google Sheets
Module 2	Data Modeling with QUERY & ARRAYFORMULA
Module 3	Analytics with Advanced Functions
Module 4	Visualization & Dashboard Development
Module 5	Automation with Apps Script
Final Project	Google Sheets BI Capstone

---

📂 Study Guides

Each module includes an optional Study Guide containing:

• Verified dataset source links (e.g., AdventureWorks Dataset – Kaggle, Global Superstore Dataset – Google Data Studio)
• Case study outlines and guided workflow templates
• Step-by-step exercises for data cleaning, modeling, and automation

Note: Study Guides are optional preparation tools provided to aid reproducibility and documentation of the candidate’s process before submitting the module project, not before the examination.

---

🏅 Certification Issuance

Upon completing all modules, examinations, and the capstone project, candidates are awarded:

🎖️ CDIP-GS Certificate (PDF Format)
🧾 Digital Badge (CDIPS Registry-Verified)

This credential certifies the holder’s professional capability in applying Google Sheets for advanced analytics, automation, and business intelligence — aligned with global standards of governed and reproducible data practices under the CDIPS certification framework.