Why Data Analytics – Beginners Course?
Data analytics for beginners is an essential starting point because it lays the foundation for understanding the fundamentals of data analysis, including:
1. Data types and sources
2. Data visualization
3. Statistical concepts
4. Data manipulation and cleaning
5. Basic analytics tools like Excel, SQL, or Power BIBy starting with the basics, beginners can build a strong foundation to tackle more complex data analytics topics and apply their skills to real-world problems.
Some benefits of starting with beginner-level data analytics include:
1. Developing essential skills for data-driven decision-making
2. Enhancing career prospects in various industries
3. Improving problem-solving and critical thinking abilities
4. Building confidence in working with data
Next Cohort's Calender
Virtual Classes
Online live classes
Duration
4 Weekends
Matriculation date
31st January 2026
Graduation date
28 February 2026
Time:
Default time schedule – Saturdays & Sundays 1:00pm – 3:00pm
WHAT YOU WILL LEARN IN DATA ANALYTICS BEGINNERS COURSE
- Definitions within the excel space
- Exploring definitions on the home tab
- Cells, columns and rows
- Worksheet and a workbook
- Renaming & creating worksheets
- Data Entry into cells, Autofitting, Drag fill handle, Auto filling technique.
- Mathematical Functions (Sum, Product, Power)
- Statistical Functions (MaX, Min, Count, Counta)
- Text Functions (Left, Right, Mid, Concatenate, Upper, Lower, Propper)
- Data Entry tasks.
- What is Power BI?
– Overview of Power BI and its components
– Use cases and benefits
- Connecting to Data
– Importing data from Excel
– Understanding tables, columns, and data types
- Data Cleaning with Power Query
– Removing duplicates
– Renaming columns
– Changing data types
- Creating Visuals
– Basic visuals: column chart, pie chart, card, table
– Using slicers and filters
- Building a Simple Dashboard
– Arranging visuals for storytelling
– Adding titles and formatting
- Introduction to Data & Databases Importance of data in everyday systems. Types of databases Flat files vs RDBMS vs NoSQL. What SQL is and why it matters.
- SQL & RDBMS Basics SQL history & portability. RDBMS core concepts: tables, rows, columns. Primary keys, foreign keys, relationships 11, 1M, MM.
- Constraints & Data Types (45 mins) Common data types INT, VARCHAR, DATE, DECIMAL. Constraints: NOT NULL, UNIQUE, DEFAULT, CHECK.
- Normalization & Schema Design 1 SQL Weekend Class Curricula and Modules What normalization is. 1NF, 2NF, and 3NF explained with simple examples. Design
- SQL Environment Setup
- Quick Recap & Warm-up
- SELECT + FROM Selecting specific columns. Aliases for columns and tables. Selecting distinct values.
- WHERE Comparison operators (=, >, <=, >=, !. Logical operators AND, OR, NOT. Pattern matching with LIKE, BETWEEN, and IN.
- GROUP BY Aggregations: COUNT, SUM, AVG, MIN, MAX. Grouping results by one/multiple columns.
- HAVING Difference between WHERE and HAVING. Filtering aggregated results.
- ORDER BY Sorting ascending/descending. Ordering by multiple columns.
- TASK
