Querytech Academy Querytech Academy Academy
← BACK TO LISTINGS

Certified Data Analytics Associate CDAA

Data Analytics & Reporting Fundamentals

Level 1: Beginner

Build strong foundational skills in data handling and analysis.

"Master the fundamentals of Excel including formatting, basic formulas, sorting, filtering, and conditional formatting."

Included Modules
Getting Started with Excel
Basic Formulas and Functions
Conditional Formatting
Data Entry and Cell Formatting
Data Types and Basic Formatting
Printing and Page Setup
Sorting and Filtering Data

"Learn essential data analysis tools such as PivotTables, advanced lookup functions, and professional reporting techniques."

Included Modules
Working with Large Datasets
Advanced Lookup Functions
Data Validation and Protection
Text and Date Functions
PivotTables and PivotCharts
Advanced Conditional Formatting & Visualization
Formula Auditing and Error Handling

"This beginner course introduces relational databases and the SQL language from the ground up. Designed for Excel users and complete beginners, it focuses on writing clean, standard SQL queries (ANSI SQL) that work across MySQL, PostgreSQL, SQL Server, Oracle, and other platforms. "

Included Modules
Introduction to Databases & SQL
SELECT statement and Basic Filtering
Sorting, grouping and basic Aggregations
JOINs-Inner Join and Basic Outer Joins
Data Manipulation (INSERT, UPDATE,DELETE)
Data objects ( Tables, Views, Schemas)
Basic Function & Data Types

"This practical, hands-on course teaches Python programming with a strong focus on data analysis. Learners will master essential Python libraries (Pandas, NumPy, Matplotlib, Seaborn) to effectively clean, analyze, explore, and visualize data. The course bridges programming fundamentals with real-world data analysis workflows used by business analysts and data professionals."

Included Modules
Python Fundamentals for Data Analysts
Data Structures & File Handling
Introduction to NumPy
Pandas Mastery – Data Frames & Series
Data Cleaning & Transformation
Exploratory Data Analysis (EDA)
Data Visualization with Matplotlib & Seaborn
Advanced Pandas & Data Wrangling
Real-World Projects & Case Studies
Best Practices & Performance Tips
Milestone Project

Level 1 Milestone: Data Foundation & Database Implementation

Project Title: Industrial Dataset Cleanup and Database Migration

Objective: Transform a messy real-world industrial dataset from raw Excel into a clean, optimized relational database.

  • Clean a messy industrial dataset in Excel
  • Design relational schema
  • Import into SQL database
  • Optimize queries
  • Present performance improvement report

Assessment: Practical Database Rebuild + Technical Presentation

Deliverables:

  • Cleaned Excel workbook with documentation
  • Relational Schema Diagram (ER Diagram)
  • SQL scripts (Table creation + Data import)
  • Optimized queries for key reports
  • Technical presentation

Level 2: Intermediate

Core data analysis, querying, visualization, and statistical thinking.

"Develop expert skills in Power Query, Power Pivot, data modeling, interactive dashboards, and automation."

Included Modules
Power Query Fundamentals
Advanced Power Query Transformations
Power Pivot and Data Modeling
Data Model Relationships & DAX Basics
Advanced Logical & Analytical Formulas
What-If Analysis & Scenario Manager
Interactive Dashboard Building
Performance Optimization & Best Practices

"This beginner course introduces relational databases and the SQL language from the ground up. Designed for Excel users and complete beginners, it focuses on writing clean, standard SQL queries (ANSI SQL) that work across MySQL, PostgreSQL, SQL Server, Oracle, and other platforms."

Included Modules
Advanced Filtering & Conditional Logic
Advanced JOINs & self joins
Subqueries & correlated Subqueries
Common tables expressions (CTEs)
Window Functions (Basics)
Advanced Aggregation &Reporting
set operations ,(UNION, INTERSECT,EXCEPT)
Temporary tables and table variables

"This course teaches the theoretical foundations and best practices of relational database design. Learners will master normalization, entity-relationship modeling, and both transactional and dimensional (Star/Snowflake) modeling techniques."

Included Modules
Database Design Principles
Keys & constraints
Normalization (1NF-3NF+BCNF)
Entity-Relationship (ER) Modeling
Relational Schema Design Best Practices
Star & snowflakes Schema (Dimensional modeling )
Slowly changing dimensions (SCD) awareness

"This course equips learners with professional Tableau skills to transform raw data into compelling, interactive visualizations and dashboards. It emphasizes best practices in visualization design, advanced calculations, and storytelling with data. "

Included Modules
Data Connections & Preparation
Calculated Fields & Parameters
Filters, Sets & Level of Detail (LOD)
Visual Best Practices
Dashboards & Storyboarding
Advanced Analytics in Tableau
Performance Optimization
Publishing & Sharing

"This comprehensive course takes learners from intermediate to advanced proficiency in Power BI. It focuses on building robust data models, writing powerful DAX, creating interactive dashboards, and implementing enterprise-level features such as security and real-time data integration."

Included Modules
Data Modeling Fundamentals
DAX Fundamentals
Relationship Management & Optimization
KPI & Measure Design
Interactive Dashboard Development
Advanced DAX
Row-Level Security (RLS)
Real-time Data & Gateway Configuration

"This course provides analysts with essential statistical foundations. It focuses on practical application in business contexts rather than heavy mathematical theory."

Included Modules
Descriptive Statistics
Probability Distributions
Sampling Techniques
Confidence Intervals
Correlation vs Causation
A/B Testing Framework
Business Experiment Design
Statistical Power & Sample Size

"This course teaches systematic techniques to explore, understand, and extract insights from data before formal modeling or reporting."

Included Modules
Principles of Exploratory Analysis
Trend Detection & Pattern Analysis
Outlier Detection & Treatment
Distribution Analysis
Sector & Competitor Benchmarking
Regression Fundamentals
EDA Reporting & Insights
Milestone Project

Level 2 Milestone: End-to-End Business Intelligence Project

Project Title: Sales & Operations Performance Dashboard

Objective: Analyze a large multi-source dataset, build an interactive dashboard, and deliver actionable business insights.

  • Clean and integrate multiple raw datasets (Excel + CSV files)
  • Design and implement a star schema data model
  • Write complex SQL queries for key business metrics
  • Perform Exploratory Data Analysis (EDA) and statistical analysis
  • Create interactive dashboards in Power BI or Tableau
  • Implement KPIs, trend analysis, and comparative visualizations
  • Apply statistical methods and correlation analysis

Assessment: Interactive Dashboard + Insights Presentation

Deliverables:

  • Cleaned and integrated datasets
  • Data model diagram and SQL scripts
  • Professional interactive dashboard (Power BI or Tableau)
  • Executive presentation with insights and recommendations

Level 3: Advanced

Advanced techniques, optimization, statistical rigor, and business impact.

" This advanced course focuses on writing complex, high-performance SQL queries and understanding how to optimize them. Learners will analyze execution plans, implement indexing strategies, and apply tuning techniques across different database platforms."

Included Modules
Advanced SELECT & Query Techniques
Mastering All JOIN Types
Subqueries & CTEs Mastering
Advanced windows function
Query Optimization & Execution Plans
Indexing strategies
Creating and managing stores procedures and functions
Performance Tuning Techniques

"This focused course teaches how to properly apply statistical hypothesis testing to make data-driven business decisions with confidence."

Included Modules
Null & Alternative Hypotheses
T-tests (One & Two Sample)
Chi-Square Tests
ANOVA Concepts & Applications
P-values, Significance & Interpretation
Practical Application & Case Studies

"This practical course develops the critical soft skills analysts need to translate complex analysis into clear, persuasive business recommendations. Emphasis is placed on visual storytelling, executive presentations, and the avoidance of common communication pitfalls."

Included Modules
Visual Storytelling Principles
Avoiding Misleading or Deceptive Charts
Executive Presentation Structure
Translating Metrics into Business Language
Storytelling Workshops & Feedback
Milestone Project

Level 3 Milestone: Comprehensive Data Analytics Capstone Project

Project Title: Strategic Business Performance Optimization

Objective: Execute a full-cycle advanced analytics project from raw data to strategic business recommendations.

  • Source and integrate complex data from multiple platforms
  • Build and optimize a robust data model
  • Develop advanced analytics using Python and SQL
  • Apply statistical techniques including hypothesis testing
  • Create advanced calculations and dynamic dashboards
  • Implement Row-Level Security and performance optimization
  • Deliver executive-level storytelling with clear recommendations
  • Document complete methodology and limitations

Assessment: Full Capstone Project + Executive Presentation + Technical Defense

Deliverables:

  • Complete project documentation and methodology
  • SQL and Python scripts
  • Advanced interactive dashboard
  • Executive presentation deck
  • Live demonstration and Q&A defense

Available Bootcamps

Choose a cohort and begin your journey to becoming job-ready

No active cohorts at the moment.
No upcoming cohorts scheduled yet.
No past cohorts available yet.