Certified in Data Analytics
Total Number of Modules6
Total Number of Topics102
Estimated Duration160:00 H
Module 1 – Data Analytics Overview & Life Cycle
- Introduction to Data Analytics60 Mins
- Data Types & Collection60 Mins
Module 2 – Python
- Python Setup, Environment and Basics120 Mins
- Practice Program60 Mins
- Python Operators240 Mins
- Practice Program60 Mins
- Python Control Statements180 Mins
- Practice Program90 Mins
- Python Loops240 Mins
- Practice Program120 Mins
- List and Set210 Mins
- Practice Program90 Mins
- Tuple & Dictionary210 Mins
- Practice Program120 Mins
- Function210 Mins
- Practice Program120 Mins
- Python Modules150 Mins
- Practice Program90 Mins
- Assessment120 Mins
- Python OOPs - Class & Object, Constructor180 Mins
- Practice Program90 Mins
- Python OOPs - Inheritance & Polymorphism210 Mins
- Python OOPs - Data Abstraction & Encapsulation180 Mins
- Practice Program120 Mins
- Python File & Exception Handling180 Mins
- Tkinter Introduction120 Mins
- Widgets150 Mins
- Practice Program - Student Registration Form GUI180 Mins
Module 3 – Power BI
- Introduction to Power BI60 Mins
- Why Power BI?90 Mins
- Getting Started with Power BI Desktop60 Mins
- Data Loading and Transformation45 Mins
- Introduction to Data Visualizations60 Mins
- Practice Task - Sales Data Preparation & Dashboard Reporting60 Mins
- Data Modeling and Relationships60 Mins
- Relationship Cardinality and Cross-Filtering45 Mins
- Creating Measures with DAX (Introduction)45 Mins
- Understanding Hierarchies45 Mins
- Power BI Query Editor60 Mins
- Practice Task - Sales Data Preparation & Dashboard Reporting90 Mins
- Advanced Data Modeling and DAX Functions60 Mins
- Aggregation Functions45 Mins
- Creating Calculated Tables60 Mins
- Handling Time Intelligence in Power BI90 Mins
- Introduction to Power BI Bookmarks60 Mins
- Practice Task - Calculated Columns for Sales Analysis90 Mins
- Practice Task - Calculated Measures for Sales Analysis90 Mins
- Visualizations and Reporting90 Mins
- Advanced Visualizations60 Mins
- Using Waterfall, Funnel, and TreeMap Visuals90 Mins
- Drillthrough, Drilldown, and Slicers90 Mins
- Power BI Report Interactivity90 Mins
- Practice Task - Customer and Sales Data Visualization Dashboard90 Mins
- Publishing and Sharing Reports60 Mins
- Sharing Reports and Dashboards with Users45 Mins
- Power BI Data Refresh60 Mins
- Security and Permissions in Power BI60 Mins
- Practice Task - Sales Dashboard Publishing and Security90 Mins
- Assessment - Power BI Overall Assessment120 Mins
- Project - Market Potential and Cluster Analysis240 Mins
Module 4 – Exploratory Data Analysis (EDA) using NumPy and Pandas
- Introduction to NumPy60 Mins
- NumPy Arrays90 Mins
- Array Indexing and Slicing60 Mins
- NumPy Operations60 Mins
- Array Manipulation60 Mins
- NumPy Linear Algebra120 Mins
- NumPy Random Module60 Mins
- NumPy Data Handling90 Mins
- Practice Questions30 Mins
- Introduction to Pandas30 Mins
- Creating and Accessing Data30 Mins
- Selecting and Modifying Data30 Mins
- Data Aggregation and Grouping30 Mins
- Advanced Data Handling60 Mins
- Practice Program30 Mins
- Introduction to Statistics180 Mins
- Data Visualization60 Mins
- Matplotlib60 Mins
- Seaborn60 Mins
- Practice Program120 Mins
- Assessment - Overall Assessment of EDA60 Mins
- Main Project - Stock Market / Covid-19 Data Analysis180 Mins
Module 5 – MySQL
- Fundamentals of MySQL60 Mins
- Practice Program60 Mins
- Querying & Filtering Data60 Mins
- Practice Program60 Mins
- Joins & Relational Queries60 Mins
- Practice Program60 Mins
- MySQL Connectivity Basics30 Mins
- Advanced MySQL Connectivity60 Mins
- Assessment60 Mins
- Project - Employee–Department Management System120 Mins
Module 6 – Excel
- Excel Interface and Basic Functions120 Mins
- Practice Task - Basic Excel Operations and Visualization90 Mins
- Data Analysis with Excel120 Mins
- Practice Task - Data Analysis and Pivot Tools90 Mins
- Charting and Graphing in Excel120 Mins
- Practice Task - Advanced Charting Techniques120 Mins
- Data Transformation and Modeling120 Mins
- Practice Task - Power Query and Power Pivot90 Mins
- Assessment - Basic Excel60 Mins
- Project - Patient and Appointment Dashboard120 Mins
