Fundamentals of Data Analytics

Data and Information • Introduction to Data Analytics • Role of a Data Analyst • Data Analyst vs Business Analyst vs Data Scientist • Data-Driven Decision Making • Analytics Life Cycle • Structured, Semi-Structured and Unstructured Data • Qualitative and Quantitative Data • Data Sources • Descriptive, Diagnostic, Predictive and Prescriptive Analytics • KPIs • Business Metrics • Analytical Questions

Advanced Microsoft Excel

Workbook Management • Data Formatting • Tables • Sorting & Filtering • Data Validation • Conditional Formatting • SUM • AVERAGE • COUNT • IF • IFS • AND • OR • SUMIF/SUMIFS • COUNTIF/COUNTIFS • AVERAGEIF/AVERAGEIFS • IFERROR • ROUND Functions

Advanced Functions: VLOOKUP • HLOOKUP • XLOOKUP • INDEX • MATCH • LEFT • RIGHT • MID • LEN • TRIM • TEXTJOIN • SUBSTITUTE • FIND • SEARCH • TODAY • NOW • DATE • DATEDIF • EOMONTH • NETWORKDAYS

Excel Data Analysis, Power Query & MIS Reporting

Data Cleaning • Remove Duplicates • Missing Data • Text to Columns • Flash Fill • Pivot Tables • Pivot Charts • Slicers • Timelines • Power Query • Import CSV/Excel • Data Transformation • Split & Merge Columns • Append Queries • Merge Queries • MIS Reports • KPI Reports • Interactive Dashboards

SQL for Data Analytics

Database & DBMS • Relational Databases • Tables • Primary & Foreign Keys • MySQL • CREATE DATABASE • CREATE TABLE • INSERT • SELECT • DISTINCT • WHERE • BETWEEN • IN • LIKE • NULL • ORDER BY • LIMIT • COUNT • SUM • AVG • MIN • MAX • GROUP BY • HAVING • INNER JOIN • LEFT JOIN • RIGHT JOIN • CASE • Subqueries • CTEs • Views • Date Functions • String Functions • Window Functions • ROW_NUMBER • RANK • DENSE_RANK

Statistics for Data Analytics

Population & Sample • Types of Variables • Mean • Median • Mode • Range • Percentage Analysis • Frequency Distribution • Percentiles • Quartiles • Variance • Standard Deviation • Probability Basics • Sampling • Normal Distribution • Outliers • Covariance • Correlation • Correlation vs Causation • Regression Basics • Trend Analysis • Statistical Interpretation

Microsoft Power BI

Business Intelligence • Power BI Desktop • Data Import • Power Query • Data Cleaning • Data Transformation • Data Modeling • Relationships • Fact & Dimension Tables • Star Schema • Calculated Columns • Measures • DAX • SUM • COUNT • DISTINCTCOUNT • DIVIDE • CALCULATE • FILTER • Time Intelligence • MTD/YTD • Charts • Matrix • KPI Cards • Slicers • Filters • Tooltips • Drill Down • Drill Through • Interactive Dashboard Design • Publishing & Sharing Concepts

Python Programming Fundamentals

Python Setup • Jupyter Notebook • Variables • Data Types • Operators • Input/Output • Strings • Lists • Tuples • Sets • Dictionaries • Conditional Statements • For & While Loops • Functions • Lambda Basics • Modules • File Handling • Basic Exception Handling

Python for Data Analysis

NumPy Arrays • Array Operations • Pandas Series & DataFrames • Reading CSV/Excel • Data Selection • Filtering • Sorting • Missing Values • Duplicates • GroupBy • Aggregation • Merge • Join • Concatenation • Pivot Tables • Matplotlib • Line Charts • Bar Charts • Histograms • Scatter Plots • Box Plots • Exploratory Data Analysis (EDA) • Patterns • Trends • Outliers • Correlation

AI Tools for Data Analysts

Generative AI Fundamentals • Prompt Engineering • AI-Assisted Excel Formulas • SQL Query Assistance • Python Code Assistance • Data Cleaning Suggestions • Analytical Question Generation • Report Summarisation • Business Insight Generation • Visualisation Suggestions • AI Hallucinations • Result Verification • Data Privacy • Responsible AI Use

Business Analytics & Case Studies

Sales Analytics • Customer Analytics • Inventory Analytics • HR Analytics • Financial & Expense Analytics • Education Analytics • Target vs Achievement • Profit & Growth Analysis • Month-on-Month Comparison • Year-on-Year Analysis • KPI Reporting • Business Trends • Actionable Insights • Presentation of Findings

Practical Projects & Portfolio Development

Project Documentation • Analytical Report Preparation • Portfolio Development • Presentation Skills • Introduction to GitHub for Project Presentation

Career Preparation & Final Assessment

Professional Data Analyst Resume • Project-Based CV • LinkedIn Profile Basics • Portfolio Preparation • GitHub Basics • Excel Interview Questions • SQL Interview Questions • Power BI Interview Questions • Python/Pandas Questions • Data Interpretation • Mock Interview • Project Presentation • Final Practical Examination • Project Viva