Masters in Data Analytics
Total Number of Modules9
Total Number of Topics142
Estimated Duration280: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 Basics180 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 – 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 4 – 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 5 – Power BI
- Introduction to Power BI120 Mins
- Why Power BI?120 Mins
- Getting Started with Power BI Desktop90 Mins
- Data Loading and Transformation90 Mins
- Introduction to Data Visualizations120 Mins
- Practice Task - Sales Data Preparation & Dashboard Reporting180 Mins
- Data Modeling and Relationships180 Mins
- Relationship Cardinality and Cross-Filtering40 Mins
- Creating Measures with DAX (Introduction)180 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 Visuals120 Mins
- Drillthrough, Drilldown, and Slicers90 Mins
- Power BI Report Interactivity180 Mins
- Practice Task - Customer and Sales Data Visualization Dashboard210 Mins
- Publishing and Sharing Reports160 Mins
- Sharing Reports and Dashboards with Users180 Mins
- Power BI Data Refresh180 Mins
- Security and Permissions in Power BI180 Mins
- Practice Task - Sales Dashboard Publishing and Security240 Mins
- Assessment - Power BI Overall Assessment120 Mins
- Project - Market Potential and Cluster Analysis360 Mins
Module 6 – Tableau
- Introduction to Tableau60 Mins
- Introduction to Tableau (Getting Started with Desktop)60 Mins
- Basic Data Exploration and Visualizations90 Mins
- Introduction to Dashboards and Reports90 Mins
- Practice - Basic Data Visualization and Dashboard Creation60 Mins
- Data Connections in Tableau60 Mins
- Data Relationships and Joins120 Mins
- Data Transformation in Tableau120 Mins
- Data Extracts and Refreshes120 Mins
- Advanced Data Transformations120 Mins
- Practice - Data Preparation and Transformation120 Mins
- Advanced Visualization Techniques120 Mins
- Advanced Formatting and Customization120 Mins
- Using Parameters in Tableau120 Mins
- Calculated Fields and Table Calculations120 Mins
- Analytics Pane120 Mins
- Practice - Interactive and Responsive Dashboard Design120 Mins
- Creating Interactive Dashboards120 Mins
- Using Maps in Tableau120 Mins
- Responsive Dashboard Design120 Mins
- Dashboard and Report Navigation120 Mins
- Exporting and Sharing Dashboards120 Mins
- Practice - Tableau Server Publishing and Collaboration120 Mins
- Assessment - Tableau Overall Assessment60 Mins
- Project - Social Media Analytics Dashboard180 Mins
Module 7 – Basic 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
Module 8 – Advanced Excel
- Excel Automation and Macros180 Mins
- Excel for Collaboration and Security180 Mins
- Practice Task - Automation and Macros120 Mins
- Building Complex Data Models and Dashboards120 Mins
- Practice Task - Advanced Data Models and Dashboards120 Mins
- Advanced Financial and Statistical Functions120 Mins
- Practice Task - Excel for Financial and Statistical Analysis240 Mins
- Integrating Excel with Other Softwares100 Mins
- Practice Task - Excel Integration with External Tools240 Mins
- Working with Big Data in Excel120 Mins
- Practice Task - Excel for Big Data240 Mins
- Assessment - Advanced Excel Overall Assessment240 Mins
- Main Project - Financial, Statistical, and Big Data Dashboard360 Mins
Module 9 – AI Tools (Application of AI in Data Analytics)
- GitHub Copilot - AI Pair Programming, Setup, Usage, Ethics240 Mins
- Cursor - AI IDE, Setup, Code Generation, Documentation, Ethics240 Mins