Data Analytics Syllabus, Exam Pattern
Data Analytics Syllabus
1. Foundational Concepts:
i. What is Data Analysis? Types of Data Analytics (Descriptive, Diagnostic, Predictive, Prescriptive).
ii. The Data Analysis Lifecycle/Process (Ask, Prepare, Process, Analyze, Share, Act).
iii. Data Types (Quantitative vs. Qualitative, Nominal, Ordinal, Interval, Ratio).
iv. Understanding Business Objectives and Key Performance Indicators (KPIs).
2. Data Collection & Preparation (Data Wrangling/Munging):
i. Identifying Data Sources (Databases, APIs, Web Scraping, Logs, Spreadsheets).
ii. Data Cleaning: Handling missing values, duplicates, outliers, inconsistencies, incorrect data types.
iii. Data Transformation: Formatting, structuring, merging, aggregating data.
iv. Data Loading (ETL/ELT concepts).
3. Exploratory Data Analysis (EDA):
i. Descriptive Statistics: Mean, median, mode, variance, standard deviation, quartiles, percentiles.
ii. Inferential Statistics Basics: Hypothesis testing concepts, p-values, confidence intervals (often introductory).
iii. Correlation vs. Causation.
iv. Identifying patterns, trends, and anomalies in data.
4. Databases & SQL:
i. Relational Database Concepts (Tables, Primary Keys, Foreign Keys).
ii. Writing SQL Queries: SELECT, FROM, WHERE, JOIN (INNER, LEFT, RIGHT, FULL), GROUP BY, HAVING, ORDER BY.
iii. Aggregate Functions (COUNT, SUM, AVG, MIN, MAX).
iv. Subqueries and Common Table Expressions (CTEs).
5. Spreadsheet Software (e.g., Microsoft Excel, Google Sheets):
i. Formulas and Functions (VLOOKUP/HLOOKUP/XLOOKUP, IF, SUMIFS, COUNTIFS, etc.).
ii. Pivot Tables and Pivot Charts.
iii. Data Sorting and Filtering.
iv. Basic Charts and Graphs.
v. Data Validation.
6. Programming for Data Analysis (Often Python or R):
Python:
i. Core Python basics.
ii. Libraries: Pandas (DataFrames, Series, data manipulation), NumPy (numerical operations), Matplotlib/Seaborn (data visualization).
R:
i. Core R basics.
ii. Packages: dplyr (data manipulation), ggplot2 (data visualization), tidyr (data tidying).
7. Data Visualization:
i. Principles of effective data visualization.
ii. Choosing appropriate chart types (Bar, Line, Pie, Scatter, Histogram, Box Plot, Heatmap, etc.).
iii. Creating dashboards and reports.
iv. Storytelling with data.
8. Business Intelligence (BI) Tools (e.g., Tableau, Power BI, Looker Studio):
i. Connecting to data sources.
ii. Creating interactive charts, dashboards, and reports.
iii. Calculated fields and measures (e.g., DAX in Power BI).
iv. Sharing and collaborating on insights.
9. Communication & Reporting:
i. Presenting findings clearly to technical and non-technical audiences.
ii. Structuring reports and presentations.
iii. Summarizing key insights and recommendations.
10. Ethics and Privacy:
i. Understanding data privacy regulations (like GDPR, CCPA).
ii. Bias in data and analysis.
iii. Responsible data handling.
Data Analytics Exam Pattern
Duration : 120 Minutes
No.of Question : 100
Total Marks : 100