1. SQL for Data Analysis

The SQL (Structured Query Language) training typically provides a comprehensive overview of managing and manipulating data within relational database management systems.

Module 1: SQL Basics & Setup

• What is a database? (RDBMS vs NoSQL)
• Installing MySQL/PostgreSQL/SQLite
• Tools: pgAdmin, MySQL Workbench, DBeaver
• Tables, rows, columns, Primary/Foreign keys
• SQL syntax conventions

Module 2: Querying and Manipulating Data

• SELECT, WHERE, AND, OR, NOT
• Sorting: ORDER BY
• Limiting: LIMIT, OFFSET
• Data types and casting
• INSERT, UPDATE, DELETE
• CREATE, DROP, ALTER tables

Module 3: Aggregations & Grouping

• COUNT, SUM, AVG, MIN, MAX
• GROUP BY and HAVING
• Filtering aggregate results

Module 4: Joins and Subqueries

• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
• Aliases and table prefixes
• Subqueries: IN, EXISTS, NOT IN
• Common Table Expressions (CTEs)

 

Module 5: Advanced SQL for Analytics

• Window Functions: RANK(), ROW_NUMBER(), LEAD(), LAG()
• Date functions: DATE_TRUNC(), EXTRACT(), INTERVAL
• CASE logic and conditional expressions
• Pivoting and unpivoting data
• Working with JSON/XML data (if applicable)

Module 6: SQL + Python Integration

• Running SQL queries in Python using pandas.read_sql()
• Connecting databases using SQLAlchemy
• Automating queries in data pipelines

Module 7: Real-World SQL Project

• Data modeling for e-commerce or HR datasets
• Writing reusable queries
• Dashboards powered by SQL (e.g., in Power BI or Streamlit)

 

2. Power BI for Data Visualization & Reporting

Power BI training provides comprehensive instruction on transforming raw data into interactive, insightful reports and dashboards to enable data-driven decision-making.

Module 1: Data Modeling & Preparation

• Power BI Desktop overview
• Importing data from Excel, SQL, CSV, Web
• Star Schema vs Snowflake Schema
• Creating relationships between tables
• Optimizing performance: filters, data types

Module 2: DAX (Data Analysis Expressions)

• Basic DAX: SUM, COUNT, DISTINCTCOUNT, AVERAGE
• Row context vs Filter context
• CALCULATE, FILTER, ALL, VALUES
• Time intelligence: SAMEPERIODLASTYEAR(), TOTALYTD(), DATESINPERIOD()
• Advanced DAX: What-if parameters, dynamic measures

Module 3: Visualizations & Reports

• Creating visualizations:
  • Bar, line, pie charts
  • Tables, matrices
  • Slicers, maps, cards
• Custom visuals from AppSource
• Hierarchies, drill-downs, tooltips
• Dashboard design best practices (layout, colors, KPIs)

Module 4: Publishing & Collaboration

• Power BI Service:
  • Workspaces, Apps, Sharing
  • Row-Level Security (RLS)
• Scheduled data refresh
• Power BI Mobile
• Embed reports in websites/apps (Power BI Embedded)

Module 5: Real-World Dashboards

• Sales & Marketing KPI Dashboard
• Finance Dashboard (P&L, Cash Flow)
• HR Analytics Dashboard

 

3. Excel for Data Analytics

The Advanced Excel training provides in-depth skills beyond basics, focusing on complex formulas and functions, data analysis with PivotTables, data visualization for interactive dashboards, and automation with Macros and VBA to improve efficiency and decision-making.

Module 1: Excel Basics

• Interface, workbooks vs. worksheets
• Cell referencing (relative, absolute)
• Data entry, formatting (dates, numbers, text)
• Essential functions: SUM, AVERAGE, MAX, MIN, IF, IFS

 

Module 2: Data Cleaning & Validation

• Removing duplicates, blanks
• TRIM(), CLEAN(), TEXT TO COLUMNS
• Data validation (dropdowns, custom rules)
• Conditional formatting

 

Module 3: Analysis Functions

• Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH, XLOOKUP
• Logical: IF, AND, OR, NOT
• Date & Time: TODAY(), DATEDIF(), WORKDAY(), NETWORKDAYS()
• Statistical: COUNTIFS, SUMIFS, AVERAGEIFS, RANK

 

Module 4: PivotTables & Visualization

• Creating PivotTables and PivotCharts
• Calculated fields and grouping
• Dashboard layout, slicers, dynamic ranges
• Charts: bar, line, combo, sparklines

 

Module 5: Power Tools in Excel

• Power Query:
  • Import, clean, transform data
  • Merge/append queries
• Power Pivot:
  • Data modeling
  • DAX formulas in Excel
• Intro to Macros:
  • Recording macros
  • Basic VBA for automation

Module 6: Statistical tests in Excel

• Correlation and regression
• Descriptive Statistics and T-tests
• Sampling and Histogram plots
• ANOVA and Predictive analysis