Session 1: Introduction to Data Analytics
Provide a strong foundation on what data analysis is, where it fits in organizations, and different career paths in analytics.

• What is Data Analytics?
• Difference between Data Analytics, Business Intelligence (BI), and Data Science
• Types of analytics: Descriptive, Diagnostic, Predictive, Prescriptive
• The Data Analyst workflow
• Tools used in data analysis (Excel, SQL, Power BI, Tableau, Python—optional introduction)
• The role and responsibilities of a Data Analyst
• Importance of data-driven decision making

Session 2: Data Collection & ETL Fundamentals (Using Power BI)
Introduce how analysts acquire, clean, and prepare data using ETL concepts and Power BI.

• Understanding the ETL (Extract, Transform, Load) process
• Data sources (Excel, CSV, Databases, APIs)
• Using Power Query for:
  • Data extraction
  • Data cleaning (removing duplicates, handling NULLs, formatting)
  • Data transformation (joins, merges, splits, derived columns)
• Loading cleaned data into Power BI
• Best practices for data preparation

Session 3: Power BI: Data Modeling & Visualization

Create powerful interactive dashboards and reports with Power BI.
Learn how to structure and relate data for efficient analysis and reporting.

• Star schema and relational modeling for analytics
• Understanding tables, relationships, cardinality, and data granularity
• Calculated columns vs. measures
• Introduction to DAX for:
  • Basic calculations
  • Time intelligence
  • KPIs
• Building interactive dashboards:
  • Slicers, filters, drill-through
  • Designing intuitive report pages
• Data storytelling in Power BI

Session 4: Data Visualization with Tableau Alternative visualization tool and strengthen dashboarding skills.

• Tableau interface and workspace overview
• Connecting Tableau to various data sources
• Building core visualizations:
  • Bar & line charts
  • Geographic maps
  • Scatter plots
  • Highlight tables
• Dashboard creation:
  • Filters, actions, interactivity
  • Layout and design principles
• Publishing and sharing Tableau dashboards

Session 5: Introduction to SQL for Data Analysts

Learn SQL from basics to complex queries and performance optimization

• What is SQL and why analysts use it
• Database Fundamentals and SELECT Statements
• Basic SQL syntax
• SELECT statements

• Filtering with WHERE
• Sorting with ORDER BY
• Working with basic functions (COUNT, SUM, MIN, MAX)
• Simple hands-on query exercises
• Data Manipulation and Performance Optimization

Session 6: Intermediate SQL for Analysis Advance SQL proficiency for real analytical tasks.

• GROUP BY and HAVING for aggregation
• Joins (INNER, LEFT, RIGHT, FULL)
• Subqueries and Common Table Expressions (CTEs)
• Data cleaning with SQL (CASE statements, string functions)
• Combining SQL with BI tools
• Writing queries for reporting and business insights

Why Choose Sazan Consulting for Data Analyst Training?

1. Industry-Expert Trainers: Our program is conducted by industry expert trainers working in Canadian industry more than 14 +years featuring real-world project exposure and providing you tips for the interview preparation Attend a free demo session to experience our training quality.
2. Job-Focused Curriculum: Our Data Analyst program covers fundamentals to advanced tools and is regularly updated to match current industry requirements.
3. Live Projects Experience: Work on live Data Analytics projects across multiple industries with expert mentorship.
4. Flexible Blended Learning: Access live online classes and recorded sessions with a single enrolment.
5. Repeat Classes for No extra cost. Once you enrol with us you can repeat any classes that you missed or if you need more time to understand any concept the entire batch can be repeated at no extra cost for one year.
6. Placement & Career Support: Get resume support, interview preparation, mock interviews, and placement assistance through our dedicated career team.