Data Analyst Course & Curriculum

NCPL's hands-on Data Analyst training — full curriculum, real projects, certification prep, and job placement support. We train, mentor and place you.

Module 1: Excel Fundamentals & Advanced Techniques

Master Excel from basics to advanced data analysis and automation.

  • Cell References and Logical Functions
  • Pivot Tables and VLOOKUP/XLOOKUP
  • Data Validation and Modeling
  • Power Pivot and VBA Automation

Module 2: SQL Fundamentals & Advanced Queries

Learn SQL from basics to complex queries and performance optimization.

  • Database Fundamentals and SELECT Statements
  • JOIN Operations and Subqueries
  • Window Functions and CTEs
  • Data Manipulation and Performance Optimization

Module 3: Power BI: Data Modeling & Visualization

Create powerful interactive dashboards and reports with Power BI.

  • Power BI Desktop and Data Connections
  • Data Modeling and DAX
  • Visualizations and Dashboards
  • Power BI Service and Gateways

Module 4: Tableau: Analytics & Storytelling

Master Tableau for advanced data visualization and storytelling.

  • Tableau Interface and Data Preparation
  • Advanced Visualizations
  • Dashboards and Interactive Stories
  • Tableau Server and Cloud

Module 5: Data Engineering Concepts

Understand data pipelines, ETL processes, and data warehousing.

  • Data Engineering Overview and Pipelines
  • Dimensional Modeling and Warehousing
  • ETL Processes and Tools
  • Data Quality Management

Module 6: Snowflake Data Warehousing

Learn Snowflake architecture and advanced data warehousing concepts.

  • Snowflake Architecture
  • Data Loading and Query Optimization
  • Time Travel and Cloning
  • Data Sharing and Snowpipe

Module 7: SAS Analytics

Master SAS programming for data manipulation and analysis.

  • SAS Basics and Data Step
  • PROC SQL in SAS
  • Data Manipulation Techniques

Module 8: Azure Data Factory

Build and manage data integration pipelines in Azure.

  • ADF Basics and Architecture
  • Pipeline Creation and Data Flows
  • Triggers and Scheduling
  • Monitoring and Logging

Module 9: Looker Analytics

Create embedded analytics and advanced data models with Looker.

  • LookML Fundamentals
  • Explores and Visualizations
  • Data Actions and Embedded Analytics
  • Advanced LookML