Course Details
Home // Course Details
Data Analytics Course
This Course Included
Share Course
50
Duration
6 Months
Skill Level
Advance
Language
Bilingual
Certificate
After Completed
Course Overview
The Data Analytics Course is a comprehensive training program designed to teach students how to analyze, manage, and visualize data using modern tools and technologies. This course covers essential software such as Advanced Excel, SQL, Power BI, and Python, which are widely used in the data analytics and business intelligence industry.
Students will learn how to collect, organize, analyze, and present data to support business decision-making. The course includes practical training, real-world projects, and industry-relevant skills required for data-driven careers.
Students will learn how to collect, organize, analyze, and present data to support business decision-making. The course includes practical training, real-world projects, and industry-relevant skills required for data-driven careers.
Course Overview
Syllabus:
Module 1: Basic Computer
This module builds the foundation for working with data and office productivity tools.
Basic Computer
- Basic Concepts of Computer
- English Typing
- Hindi Typing
- Data Entry
MS Word
- Font & Paragraph Formatting
- Editing, Saving & Printing Text Documents
- Inserting Table
- Header & Footer
- Smart Art
- Page Breaks
- Using List & Styles, Spelling & Grammar Check
- Understanding Document Properties & Tabs
- Mail Merge
- Document Views & Macros
- Saving & Protecting Sheets Documents
- Project Work
Advanced Excel     Â
- Introduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)
- All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
- Entering and Editing Data.
- Inserting and Deleting Row or Column.
- Auto fill Lists ( Default lists & Creating new lists)
- Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
- Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
- Charts (Working With Charts)
- Logical Functions (IF, AND, OR, NOT, IFERROR)
- Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, XLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
- Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
- Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
- Project Work
- and many more…
MS PowerPoint        Â
- Creating & Printing Slides
- Adding Custom Animation
- Using Slide Transitions
- Using Charts, Graphs & Photo Album
- Creating Professional Presentation
- Project Work
Internet  Â
- Introduction to Internet
- Browser Basics
- Downloading, Searching, Surfing and Storing Data
- Online Forms Submission
- Online Bill Payment
- Online Ticket Booking
- and many more..
Module 2: MIS Reporting & Dashboard Creation
This module focuses on Management Information System (MIS) reporting and business dashboards.
MIS Reports
- Types of Reports: Operational, tactical, strategic
- Creating Reports: Templates, data collection, presentation
- Automating Reports: scheduled reports
- Project Work
- and many more….
Pivot Tables
- Basics: Creating, designing pivot tables
- Advanced Techniques: Grouping, calculated fields, charts
- Insights: Analyzing data, using slicers, timelines
- Project Work
- and many more….
Dashboard Creation
- Introduction: Purpose, types of dashboards (Operational, Analytical, Strategic)
- Excel Dashboards: Data prep, chart selection, using slicers
- Advanced Excel: Pivot tables/charts, Power Pivot, dynamic dashboards
- Design Principles: Layout, color usage, readability
- SQL Integration: Pulling live data, combining with Excel for dashboards
- Advanced Features: Real-time dashboards, automation, sharing/collaboration
- Project Work
- and many more….
Module 3: SQL for Database Management
This module teaches students how to work with databases and query data using Structured Query Language (SQL).
- Create, Manage Databases and Tables
- Insert, Update, and Delete Data in tables
- Select with filters(where) and Sorting(Order By)
- Use join to combine data from multiple tables
- Create table relationships with foreign key
- and many more….
Module 4: Power BI for Data Visualization
Power BI is one of the most popular tools for business intelligence and data visualization.
Getting Started with Power BI
- Importing dataset into Power B
- Adjusting table and column name
- Setting correct data type
- Splitting and removing column
- Replacing values in a column
Data Manipulation and Analysis
- Text data manipulation
- Numeric data analysis
- Date and time manipulation
- Conditional column
- Grouping and aggregating
- Joining dataset
- Concatenating datasets
Data Modeling and Connection
- Understanding data modeling
- Creating data model in Power BI
- Managing & editing data models
- Data column formats & categories
- Creating & managing hierarchies
Data Analysis Expressions(DAX)
- DAX for math and statistics
- DAX for counting categories
- DAX for logical functions
- Creating Dashboard
Module 5: Python for Data Analytics
This module introduces Python programming for data analysis and visualization.
- Understanding Data Types
- Understanding Tuples and Lists
- Conditionals and Functions
- Data Cleaning
- Data Manipulation
- Merging and Concatenating
- Pivot table analysis
- Data Visualization Methods
- Data Transformation Methods
- Data Preprocessing
- and many more…
Career Opportunities After This Coturse
After completing the Data Analytics Course, students can work in the following roles:
- Data Entry Operator
- MIS Executive
- Junior Data Analyst
- Excel Data Analyst
- Reporting Executive
- Data Management Executive
- Dashboard Executive
- Power BI Executive
- SQL Data Executive
- Operations Data Analyst
