Skip to main content
senior dataanalyst
previous arrow
next arrow

#Senior Data Analyst

Senior Data Analyst is an experienced analytics professional who transforms complex business data into meaningful insights that drive strategic decisions. Using advanced skills in SQL, Power BI, Tableau, AI, and real-time analytics, they build enterprise dashboards, optimize business performance, and solve data-driven challenges. Senior Data Analysts work closely with stakeholders to identify trends, create KPIs, and deliver actionable recommendations across industries. It is one of the most in-demand and high-growth career paths for professionals aiming to become analytics leaders.

Training Highlights
✅ SQL Server (T-SQL) from Beginner to Advanced
✅ Power BI with AI & Microsoft Copilot
✅ Tableau Desktop & Tableau Server
✅ 1:1 Expert Mentorship
✅ Mock Interviews & Interview Guidance
✅ Job Assistance & Placement Support
✅ 1 End-to-End Enterprise Projects

Modules We Learn
✅ Module 1: MSSQL, Tuning
✅ Module 2: Power BI
✅ Module 3: Python (Analytics)
✅ Module 4: Advanced Excel
✅ Module 5: AI, CoPilot
✅ Module 6: Tableau
✅ Module 7: Realtime Projects

Course Duration: 4.5 Months

Senior Data Analyst
Course Contents:

Module 1: MSSQL & TSQL

Ch 1: SQL Database Job Roles

  • Database Intro
  • OLTP, DWH, OLAP
  • DBMS Basics
  • SQL Database Job Roles

Ch 2: Database Intro & Installations

  • SQL Server Installations
    Instance & Collations
  • SSMS Tool Installation
  • Connections, Authentications

Ch 3: SQL Basics V1 (Commands)

  • SQL Basics (DDL, DML, etc..)
  • Creating Databases, Tables
  • Data Inserts (GUI, SQL)
  • Basic SELECT Queries

Ch 4: SQL Basics V2 (Commands, Operators)

  • DDL: Create, Alter, Drop
  • DML: Insert, Update, Delete
  • DQL: Select, Fetch
  • Add, Truncate Statements
  • SQL Operators

Ch 5: Data Types & Variables

  • Integer Data Types
  • Character, MAX Data Types
  • Decimal & Boolean Data Types
  • Date and Time Data Types
  • SQL_Variant Type

Ch 6: Data Imports

  • Data Imports with Excel
  • Data Imports with CSV
  • Data Types Detection
  • OLE-DB Connections
  • ORDER BY, TOP, OFFSET

Ch 7: Schemas & Batches

  • Schemas & Table Grouping
  • Real-world Banking Database
  • 2 Part, 3 Part & 4 Part Naming
  • Batch Concept & “Go” Command

Ch 8: Constraints, Keys & RDBMS

  • Null, Not Null Constraints
  • Unique Key & Check
  • Primary Key Constraint
  • Foreign Keys, Default
  • DB Diagrams & ER Models

Ch 9: Normal Forms & RDBMS

  • Normal Forms: 1 NF, 2 NF
  • 3 NF, BCNF and 4 NF
  • 1:1, 1:M, M:1 Cardinality
  • Cascading Keys, Self Referencing Keys

Ch 10: Joins & Queries

  • Joins: Table Comparisons
  • Inner Joins & Matching Data
  • Outer Joins: LEFT, RIGHT
  • Full Outer Joins & Aliases
  • Self Joins & Aliases

Ch 11: Sub Queries

  • Basic Sub Queries
  • Aggregations
  • Combining Queries
  • Correlated Sub Queries
  • UNION, UNION ALL

Ch 12: Group By Queries

  • Group By, Distinct
  • GROUP BY, HAVING
  • Cube( ) and Rollup( )
  • Sub Totals & Grand Totals
  • Grouping( ) & Usage
  • ISNULL, COALESCE

Ch 13: Joins with Group By, Sub Queries

  • 3 Table, 4 Table Joins
  • Join Queries & WHERE
  • Join & Group By, Sub Queries
  • IIF(), CASE Statement
  • EXISTS, NOT EXISTS
  • Query Execution Order

Ch 14: Views & RLS

  • Views: Realtime Usage
  • DML, SELECT with Views
  • WITH CHECK OPTION
  • Row Level Security (RLS)
  • Important System Views

Ch 15: Functions & Queries

  • User Defined Functions
  • Scalar, Table Value Functions
  • Variables & Parameters
  • Date & Time Functions
  • String Functions
  • Aggregated Functions
  • Data Conversion Functions

Ch 16: Advanced SQL & Window Functions

  • Window Functions (Rank)
  • Row_Number, DenseRank
  • Partition By & Order By
  • Lag & Lead Functions
  • Pivot, UnPivot
  • Running Totals
  • Moving Average

Ch 17: Stored Procedures – 1

  • Stored Procedures: Realtime Use
  • Parameters Concept with SPs
  • Procedures with SELECT
  • System Stored Procedures
  • Stored Procedures, Tuning

Ch 18: Stored Procedures – 2

  • Merge Statement (Upsert)
  • Merge with OLTP & DWH
  • Matched and Not Matched
  • Merge & SP Recompilations

Ch 19: Triggers & Automations

  • Need for Triggers in Real-world
  • DDL & DML Triggers
  • For / After Triggers
  • Instead Of Triggers
  • Disabling DMLs Triggers

Ch 20: Transactions & ACID

  • Auto Commit Transaction
  • Explicit Transactions
  • COMMIT, ROLLBACK
  • Checkpoint & Query Blocking
  • READPAST, LOCKHINT
  • TRY…CATCH & Error Handling

Ch 21: SQL Query Performance & Indexing

  • Clustered vs Nonclustered Indexes
  • Index Seek vs Scan
  • Execution Plans
  • SARGable Queries
  • Tuning Queries
  • Avoiding SELECT *
  • Indexing JOIN/WHERE columns
  • Statistics Basics
  • Query Optimization Examples

Ch 22: CTEs & Tuning

  • Common Table Expression
  • CTEs for Data Retrieval
  • CTEs for DML Operations
  • Data Cleansing Techniques
  • Duplicate Detection/Removal

Ch 23: Temp Tables & Query Techniques

  • Local & Global Temp Tables
  • SELECT..INTO Statement
  • Cursor Basics – When to Use & Avoid
  • NULLIF
  • Basic Execution-Plan Reading

Ch 24: Bonus / Advanced Module: SQL Server Internals

  • Database Engine Components
  • Parser, Compiler & Optimizer
  • Parsing and Compilation
  • Memory Manager & IO Managers

Real-Time Project on HealthCare Domain
Project Requirement:
Solve 20+ Real-World Healthcare Business Requirements.

Project Workflow:
Database Design → SQL Development → Data Analysis → Performance Optimization

Project Operational Flow:
Healthcare DB → Patients → Doctors → Appointments → Treatments → Billing → Insurance → SQL
Analysis → Stored Procedures → Performance Tuning → Business Reports

Business Requirements:
Monthly Hospital Revenue, Top Doctors By Patients Treated, Repeat Patients, Department
Performance, Average Treatment Cost, Unpaid Bills, Insurance Claim Analysis, Patient Trends,
Month-Over-Month Revenue And Top Procedures…

Module 2: Power BI

Ch 1: Power BI Intro, Installation

  • Power BI & Data Analysis
  • Power BI Eco System
  • Power BI Design Tools
  • Power BI Installation

Ch 2: Report Design Concepts

  • Basic Report Design (PBIX)
  • Data Points, Spotlight
  • Visual Interactions & Edits
  • Focus Mode, PDF Exports

Ch 3: Grouping, Hierarchies

  • Creating Groups: Lists
  • Creating Groups: Bins
  • Hierarchies & Drill-Downs
  • Drill Up, Conditional Drill Down

Ch 4: Slicer & Visual Sync

  • Slicer Visual in Power BI
  • Slicer: Format Options
  • Single Select, Multi Select
  • Slicer: Select All On / Off
  • Visual Sync with Slicers

Ch 5: Filters & Drill Thru

  • Power BI Filters
  • Basic, Top & Advanced
  • Visual Filters, Page Filters
  • Report Level Filters, Clear Filter
  • Drill Thru Filters & Usage

Ch 6: Bookmarks, Buttons

  • Power BI Bookmarks
  • Images: Actions, Bookmarks
  • Buttons: Actions, Bookmarks
  • Page to Page Navigations
  • Score Cards, Master Pages

Ch 7: SQL DB Access & Big Data

  • SQL DB Access, Queries
  • Storage Modes: Direct Query
  • Formatting & Date Time
  • Storage Modes in Power BI
  • Data Modeling & Formatting

Ch 8: Power BI Visualizations

  • Charts, Bars, Lines, Area
  • Tree Maps & Axis Items
  • Funnel, Card, Mult-Row Card
  • Pie Charts & Waterfall
  • Scatter Chart, Play Axis
  • Infographics, Classifications

Ch 9: Power Query Transformations – 1

  • Power Query (Mashup)
  • ETL Transformations in PBI
  • Table Combine Options
  • Merge, Union All Options
  • Missing Values, Duplicate Records
  • Wrong Data Types, Outliers
  • Close, Apply & Visualize

Ch 10: Power Query Transformations – 2

  • Group By Transformation
  • Aggregate, Pivot Operation
  • Reverse Rows, Count Rows
  • Data Cleaning, Null Handling
  • Data Type Detection, Change
  • Rename, Replace, Move
  • Fill Up, Fil Down

Ch 11: Power Query Transformations – 3

  • String / Text Transformations
  • Split, Merge, Extract, Format
  • Numeric and Date Time
  • Add Column & Expressions
  • Column From Examples

Ch 12: Power Query Transformations – 4

  • Parameters in Power Query
  • Static Parameters, Defaults
  • Dynamic Dropdowns, Lists
  • Linking with Table Queries
  • Step Edits, Type Conversions

Ch 13: Power BI Cloud & Fabric

  • Power BI Cloud, Microsoft Fabric
  • Microsoft Fabric Concepts
  • Fabric One Lake (DWH, LH, etc.)
  • Microsoft Fabric Workspace
  • Power BI Desktop Connections
  • Report Uploads (PBIX)
  • Report Edits, Semantic Models

Ch 14: Power BI Cloud Dashboards

  • Power BI Dashboards
  • Dashboard Creation, Usage
  • Pin Visuals, Pin LIVE Pages
  • Add Image, Video Tiles
  • Q&A & Pin Tiles

Ch 15: Power BI Cloud Operations

  • Report Shares, Alerts
  • Subscriptions, Exploration
  • Downloads & Edits
  • Report Cloning in Cloud
  • QR Codes, Web Publish
  • Lineage & Metrics

Ch 16: Power BI Cloud Gateways

  • Data Gateways, Data Refresh
  • Install, Configure Gateways
  • Data Refresh & Scheduling
  • Gateway Optimizations
  • Incremental Refresh
  • Large Dataset Optimization

Ch 17: Power BI Cloud Apps

  • Power BI Apps: Creation
  • App Sections & Content
  • Audience & App Security
  • App Updates, Favorites
  • App URL, End User Access

Ch 18: Power BI Report Server, RDL

  • Power BI Report Server
  • RS Config Tool Options
  • Report Database, TempDB
  • Web Service & Server URL
  • Report Builder Tool
  • Paginated Report (RDL)
  • RDL Report Publish

Ch 19: DAX Concepts & Calculations

  • DAX Concepts: Intro & Realtime Need
  • DAX Columns: Creation, Use
  • DAX Measures: Creation, Use
  • DAX Functions: IIF, ISBLANK
  • SUM, CALCULATE Functions

Ch 20: DAX Quick Measures

  • Quick Measures in Power BI
  • Running Totals
  • Star Rating Calculations
  • DAX Measures in Data View
  • DAX in Cloud Reports

Ch 21: Data Modelling

  • Dimensions Tables
  • Fact Tables & DAX Measures
  • Data Models & DDAX Joins
  • Star & Snowflake Schemas
  • Many-to-Many Relationships
  • Calculation Groups

Ch 22: DAX Joins, Variables

  • CALCULATEX & Variables
  • COUNT, COUNTA, etc..
  • SUM, SUMX, etc..
  • SELECTED MEMEBER
  • Filter Context, RETURN

Ch 23: DAX Models & Calculations

  • VAR, SWITCH, SUMMARIZE
  • TREATAS, USERELATIONSHIP
  • CROSSFILTER, GENERATE
  • RANKX, TOPN, WINDOW
  • OFFSET, INDEX

Ch 24: DAX Time Intelligence

  • Need for Time Intelligence
  • Date Table Generation
  • Time Intelligence with DAX
  • PARALLELPERIOD, DATE
  • CALENDAR, Total Functions
  • YTD, QTD, MTD with DAX

Ch 25: DAX – Row Level Security

  • RLS: Row Level Security
  • Data Modelling & Roles
  • Add Cloud Users & KPIs
  • CoPilot with DAX

Ch 26: DAX – Analytical Reports

  • DAX with Excel
  • Analytical Reports
  • Virtual Cube Concepts
  • Cross Filter Reporting
  • Alerts, Data Activator

Ch 27: PL 300 Exam Guidance

  • PL 300 Exam Guidance
  • Exam Samples
  • Exam Scenarios

Realtime Project: Enterprise Healthcare Data & Analytics Platform
Project Objective
Design and implement a modern Healthcare Data Platform using Power BI Analytics and Reporting services
to process patient, hospital, clinical, and operational data for reporting, analytics, and decision-making.

Technologies Used

  • SQL Server
  • MS Excel
  • Parquet
  • CSV
  • PDF
  • Azure

Learning Outcomes
After completing this project, you can confidently showcase experience in:

  • Power BI Reporting
  • Power BI Data Analytics
  • Business Process Understanding
  • Performance Optimization
  • End-to-End Power BI Implementation in Cloud

Module 3: Python (For Data Analysts)

Ch 1: Python Introduction

  • Python Introduction
  • Python Versions
  • Python for Data Analysts
  • Python Architecture

Ch 2: Python Installations

  • Python Introduction
  • Python Installations
  • Anaconda Installation
  • Python IDE & Usage
  • Jupyter Notebooks

Ch 3: Python Print Statement

  • Python Print Statement
  • print(), print()
  • Testing Case Sensitivity
  • Single Line, Multi Line prints
  • print() with single quotations
  • Debug with AI (AI Assistants)

Ch 4: Python Variables

  • Python Variables
  • Assigning values
  • Variable Value Reads
  • Multiple Variables & Print()

Ch 5: Python Operators

  • Athematic Operators
  • Python String Literals
  • Single, Double Quotes
  • Format Strings (f string)
  • Comparison, Indexing Operators

Ch 6: Python Data Types

  • Python Data Types
  • Integer, Float, String Data Types
  • Type Casting
  • Type Identification
  • Multi Value Assignments

Ch 7: Python Lists

  • Creating Python Lists
  • Printing List Items
  • Print List Slices
  • Empty Lists, Append
  • Loops, List Updates

Ch 8: Python Dictionaries

  • Python Dictionary
  • Indexing Dictionaries
  • Edit Key Values
  • Lists inside Dictionaries
  • Delete & Clear

Ch 9: Python Tuples

  • Python Tuples
  • Defining, Indexing
  • Length(), Type()
  • Mixed Values in Tuples
  • Overwriting Tuples

Ch 10: Python IF..ELSE Condition

  • If..Else conditions
  • if..elif..else & Shorthand if
  • composite conditions
  • Indent, pass statement
  • in & negation operators
  • range conditions

Ch 11: Python Loops

  • Python For Loop
  • For Loop @ Range
  • For Loop @ Sequence Values
  • While Loop, Exit Conditions
  • Break, Continue, Paas

Ch 12: Python Dataframes

  • Dataframes: Creation
  • Pandas Dataframes
  • Dataframes From Single List
  • Dataframes from Dictionary
  • Display Dataframes, List Items
  • Identify, Replace Nulls, NumPy

Ch 13: Python SQL DB Access

  • SQL DB Access with Python
  • import pandas.DataFrame
  • pyodbc module, sql functions
  • SQL Query Executions: DDL, DML
  • Filters, Aggregations with SQL
  • Dataframe Usage with SQL

Ch 14: Dataframe Transformations – 1

  • Dataframe Transformations
  • Concat & Append
  • Merge Function
  • Join with Multiple Dataframes
  • Data Type Checks, Conversions
  • Loops with Dataframes

Ch 15: Dataframe Transformations – 2

  • Pandas – Cleaning Data
  • Replace, Transform Columns
  • Data Discovery & Column Fill
  • Identify & Remove Duplicates
  • dropna(), fillna() Functions

Ch 16: Dataframe Transformations – 3

  • Python Functions for date, time
  • Now() Function in Python
  • date, time Functions
  • Calendar Data Generation

Ch 17: Python Functions & Lambda

  • Python Functions & Usage
  • Function Parameters
  • Default & List Parameters
  • Python Lambda Functions
  • Recursive Functions, Usage
  • Return & Print @ Lamdba

Module 4: Excel Analytics (Basic to Advanced)

Ch 1: Excel Concepts, Basic Functions

  • Excel Basics & Concepts
  • Excel Functions
  • Excel Operations

Ch 2: Formatting and Proofing

  • Currency Format
  • Format Painter
  • Formatting Dates
  • Custom and Special Formats
  • Formatting Cells
  • Absolute, Mixed
  • Relative Referencing

Ch 3: Functions

  • SUMIF, SUMIFS, COUNTIF
  • COUNTIFS, AVERAGEIF
  • AVERAGEIFS, NESTED IF
  • IFERROR STATEMENT
  • AND, OR, NOT

Ch 4: Protecting Excel

  • File Level Protection
  • Workbook
  • Worksheet Protection
  • Security Concepts
  • Realtime Issues, Solutions

Ch 5: Text Functions

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate
  • Find, Substitute

Ch 6: Date & Time Functions

  •  Today, Now
  • Day, Month, Year
  • Date, Date if, Date Add
  • EOMONTH
  • Weekday Functions

Ch 7: Adv. Techniques

  • Paste Formulas
  • Paste Formats
  • Paste Validations
  • Transpose Tables

Ch 8: New in Excel & 365

  • Charts – Tree map & Waterfall
  • Sunburst, Box and whisker Charts
  • Combo Charts – Secondary Axis
  • Adding Slicers Tool in Pivot & Tables
  • Using Power Map and Power View
  • Forecast Sheet, park lines

Ch 9: New in Excel & 365

  • Using 3-D Map
  • New Controls in Pivot Table
  • Various Time Lines
  • Auto complete a data range
  • Quick Analysis Tool
  • Smart Lookup manage Store

Ch 10: Printing Workbooks

  • Setting Up Print Area
  • Customizing Headers
  • Templates
  • Print Titles –Repeat Rows

Ch 11: Sorting and Filtering

  • Filtering on Text
  • Numbers & Colors
  • Sorting Options
  • Advanced Filters
  • Filter Criteria

Ch 12: What If Analysis

  • Goal Seek
  • Scenario Analysis
  • Data Tables (PMT Function)
  • Solver Tool

Ch 13: Logical Functions

  • If Function
  • How to Fix Errors – if error
  • Nested If
  • Complex if and or functions

Ch 14: Data Validation

  • Number, Date & Time
  • Text and List Validation
  • Custom validations formulas
  • Dynamic Dropdowns

Ch 15: Lookup Functions

  • V lookup / H Lookup
  • Index and Match
  • Smooth User Interface
  • Nested V Lookup
  • Reverse Lookup
  • Worksheet linking
  • V lookup with Helper Column

Ch 16: Pivot Tables – 1

  • Creating Simple Pivot Tables
  • Classic Pivot table
  • Filtering PivotTables
  • Modifying PivotTable Data
  • Grouping
  • Calculated Fields

Ch 17: Pivot Tables – 2

  • Array with IF, LEN
  • MID function formulas.
  • Array with Lookup functions.
  • Various Charts
  • SLICERS, Filter data
  • Manage Primary Axis
  • Manage Secondary Axis

Ch 18: Excel Dashboard

  • Planning a Dashboard
  • Adding Tables and Charts to Dashboard
  • Adding Dynamic Contents to Dashboard

Ch 19: VBA Macro – Level 1

  • Using Outlook Namespace
  • Send automated mail
  • Outlook Configurations, MAPI
  • Worksheet Operations
  • Workbook Operations

Ch 20: VBA Macro – Level 2

  • Merge Worksheets using Macro
  • Merge multiple excel files into one sheet
  • Split worksheets using VBA
  • Worksheet copiers

Ch 21: Statistics For Data Analysis – 1

  • Mean
  • Median
  • Mode
  • Variance
  • Standard Deviation
  • Correlation

Ch 22: Statistics For Data Analysis – 2

  • Probability Basics
  • Hypothesis Testing
  • A/B Testing
  • Confidence Interval
  • Outliers
  • Normal Distribution

Module 5: AI & Co-Pilot

Ch 1: Copilot Introduction

  • AI Concepts
  • AI Fundamentals
  • AI in Realtime
  • Microsoft Copilot

Ch 2: Copilot Architecture

  • Copilot Architecture
  • Anatomy of a copilot
  • Prompts in Copilot
  • Data Security
  • Copilot Configurations

Ch 3: Building Prompts

  • Copilot Usage
  • Building Good Prompts
  • Dos & Don’ts
  • Undo Options

Ch 4: Copilot in Power BI Desktop

  • Copilot for Data Modelling
  • Copilot for Visuals
  • Copilot for Formatting
  • Visual Interactions
  • Visual Sync

Ch 5: Copilot in Power Query

  • Copilot for M Language
  • Copilot for ETL
  • Copilot with Expressions

Ch 6: Copilot in Power BI Cloud

  • Copilot in Cloud Service
  • Visual Analytics
  • Semantic Models
  • Power BI Dashboards
  • Power BI Apps

Ch 7: Copilot in DAX

  • DAX with Copilot
  • Big Data Analytics
  • DAX Constructs with Copilot
  • Q & A Concepts

Ch 8: Analytical Reports & AI – 1

  • Copilot with Power BI Desktop
  • CoPilot in Power BI Cloud
  • Key Influencers
  • Decomposition Tree
  • Smart Narrative

Ch 9: Analytical Reports & AI – 2

  • Q&A Visual
  • Anomaly Detection
  • Forecasting
  • AI Visuals
  • Azure AI Integration

Module 6: Tableau

CH 1: TABLEAU INTRO, INSTALLATION

  • Introduction to Tableau
  • Report Types in Real-time
  • Data Sources for Report Design
  • Tableau as a Self Service BI
  • Tableau Features
  • Power BI Licensing Plans

CH 2: TABLEAU ARCHITECTURE

  • Data Sources, Connectors
  • Tableau Clients
  • Tableau Server Components
  • VizQL Server & Data Engine
  • Backgrounder, Data Server
  • Fast Data Engine
  • Gateway Components

CH 3: TABLEAU INTRO, INSTALLATION

  • Tableau Public Desktop
  • Report Development
  • Data Sources Types
  • Tableau Prep Tools
  • Data Modelling
  • Drilldown Reports

CH 4: TABLEAU REPORTS & JOINS

  • Data Search
  • Alias, Bins, Workbooks
  • Bookmarks, Calculations
  • Tableau File Type
  • Pages, Rows, Columns
  • Inner, Left / Right Outer Joins

CH 5: TABLAU REPORT DESIGN

  • Cross Tabs, Dashboards,
  • Visual Sync
  • Sets, Marks, Workbooks
  • Data Pane, Dimensions
  • Extract, Filters

CH 6: BIG DATA ACCESS, BLENDING

  • SQL Data Access
  • Remote Data Sources
  • Remote Joins
  • SQL Queries in Tableau
  • Data Blending
  • Multiple Data Sources
  • Combine, Aggregations
  • Data Grouping

CH 7: TABLEAU CALCULATIONS

  • Tableau Calculations
  • Numerical Calculations
  • Aggregated Calculations
  • Calculations From Shelves
  • Calculation Edits, Identifications

CH 8: STRING, DATE FUNCTIONS

  • Tableau Functions
  • String Functions
  • Date Functions
  • Time Functions
  • Aggregation Functions
  • Other Functions

CH 9: TABLE CALCULATIONS

  • Calculations For Year, Quarter, Month
  • Custom Calculations
  • Data Appending
  • Custom Date and Time Formats
  • Calculations Reuse and Edits
  • Date and Time Conversions
  • Running Total
  • Row Number, Case Statements

CH 10: LOD CALCULATIONS

  • Table Calculations
  • Level of Details
  • Table Calculations
  • Partitioning, FIXED LOD
  • INCLUDE LOD Expressions
  • EXCLUDE LOD Expressions

CH 11: TABLEAU VISUALIZATIONS – 1

  • Tableau Visualizations
  • Tableau Bar Charts
  • Horizontal & Colored Charts
  • Interactive Charts & Filters
  • Continuous Charts
  • Dual Line Chart, Area Charts
  • CrossTab Charts, Pie Charts

CH 12: TABLEAU VISUALIZATIONS – 2

  • Divergence, Color Palettes
  • Box & Wishker Plots
  • Text Tables;
  • Heat Maps, Treemaps
  • Motion Charts
  • Bullet Graphs

CH 13: TABLEAU FILTERS

  • Tableau Filters
  • Extract Filters, TDE (hyper)
  • twb Files, History, TDE
  • Context Filters
  • Dimension Filters
  • Measure Filters
  • Filters Scope and Quick Filters

CH 14: PARAMETERS, SETS

  • Tableau Parameters
  • Parameters, Conditions
  • Calculations, Dynamic Filters
  • Dynamic Dimensions
  • Dynamic Measures With Sets
  •  IN and OUT Concepts

CH 15: TABLEAU FORECASTS, ACTIONS

  • Tableau Trend Lines
  • Reference Lines
  • Forecasts, Exponential Smoothing
  • Forecasts, Bookmarks
  • Tableau Action Types
  • Static/Dynamic Actions
  • URL and Parameter Action Types
  • Tableau Actions & Dashboards

CH 16: DASHBOARDS & STORIES

  • Dashboards and Stories
  • Building Dashboards
  • Legends and Quick Filters
  • Floating Layouts
  • Layout Containers
  • Dashboard Extensions, API
  • Device Designer
  • Customizing Layouts
  • Bollinger Bands

CH 17: Tableau Prep

  • Installation ETL
  • Tableau Desktop Store
  • Server Store

CH 18: TABLEAU SERVER

  • Tableau Server – Architecture
  • Installation Process
  • Workbook, Sharing and Layouts
  • Custom Layouts
  • Tableau Online Vs Table Server
  • Device Layouts in Tableau Online

CH 19: COLLOBORATE TABLEAU ONLINE

  • Tableau Online, LIVE Reports
  • Projects and Workbooks
  • Report Views in Tableau Online
  • Account Settings, Drill Down
  • Sharing, Subscription
  • Web Authoring
  • Phone Marks and Maps

CH 20: MANAGE TABLEAU SERVER

  • Tableau Server – Administration Concepts
  • Tableau Sites, Users, Groups Security
  • Project Permission and Locking
  • Data Security with user Filters
  • Filters and Hybrid Models in Server
  • TSM : Tableau Services Manager
  • GUI and CLI; Backups and Restores
  • Tabcmd : Imports; Tabcmd

Module 7: Realtime Projects

Realtime Project – 1 (ECommerce Domain)

  • Project Requirement
  • Project Solution
  • Project FAQs
  • AI Sales Dashboard

Realtime Project – 2 (Finance Domain)

  • Project Requirement
  • Project Solution
  • Project FAQs
  • AI Financial Forecast

Career Guidance

  • Resume Optimization
  • LinkedIn Optimization
  • ATS-Friendly Resume
  • Interview Strategies

Who is this Senior Data Analyst course designed for?

This course is ideal for data analysts, BI developers, Excel/SQL professionals, and freshers with basic analytical skills who want to move into a senior analytics role by mastering SQL, Power BI, and Tableau together.

What is the duration of the Senior Data Analyst course?

The course runs for 3 months and covers 4 modules — SQL Server (T-SQL), Power BI with AI & Copilot, Tableau, and a Realtime Enterprise Project.

Do I need prior SQL or BI experience to join?

No prior experience is required. The course starts from SQL Server basics (Ch 1–2) and progressively builds up to advanced topics like DAX, Power Query, and Tableau Server administration.

What tools and technologies will I learn?

You’ll learn SQL Server (T-SQL), Power BI (including AI, Microsoft Copilot, DAX, Power Query, and Cloud deployments), and Tableau Desktop & Server — a rare combination that most institutes teach separately.

Is there a real-time project included?

Yes, Module 4 includes an end-to-end Enterprise Project covering a healthcare domain business case, with deliverables like Tableau workbooks, SQL scripts, a Business Requirement Document (BRD), KPI documentation, and resume points.

Does the course include placement or job support?

Yes — the program includes mock interviews, resume optimization, LinkedIn optimization, ATS-friendly resume building, salary negotiation guidance, interview strategy, and job assistance/placement support.

What is covered under Power BI with AI & Copilot in this course?

This module covers standard Power BI reporting plus AI-driven features like Key Influencers, Decomposition Tree, Smart Narrative, Anomaly Detection, Forecasting, and Microsoft Copilot integration — along with PL-300 exam guidance.

Demo Videos

Why SQL SCHOOL?

Training Modes

Why Choose SQL School

  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
A man smiling and giving a thumbs up while holding a notebook.
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance

Oracle PLSQL Certificate of Completion by SQL School | Hyderabad | MSME & ISO Certified
Verified by MonsterInsights