Physical AI (Robotics)

1. What is an Application?

2. Types of Applications

3. Web Application Fundamentals

4. Web Technologies: (List key technologies and their roles)

Frontend: HTML, CSS, JavaScript, React

Backend: Python, Java, Node.js

Databases: SQL (MySQL, PostgreSQL), NoSQL (MongoDB).

5. Software Development Life Cycle (SDLC)

Phases: Planning, Analysis, Design, Implementation (Coding), Testing, Deployment, Maintenance.

6. Application Development Methodologies

Agile: Core principles, Scrum, Kanban

Waterfall

1. What is Data

2. Types of Data

3. Data Storage

4. Data Analysis

5. Data Engineering

6. Data Science

1. The Importance of Computing Power

2. Key Computing Technologies:

CPU (Central Processing Unit)

GPU (Graphics Processing Unit)

3. Cloud Computing:

What is the Cloud?

Cloud Service Models:

IaaS (Infrastructure as a Service)

PaaS (Platform as a Service)

SaaS (Software as a Service)

1. What is Artificial Intelligence (AI)?

2. How AI Works?

3. Key Concepts:

Machine Learning (ML)

Deep Learning (DL)

4. Generative AI:

What is Generative AI?

Examples: Large Language Models (LLMs), image generation models.

5. AI in Everyday Learning

1. Customer Relationship Management (CRM)

2. Human Resource Management Systems (HRMS)

3. Retail & E-Commerce

4. Healthcare

1. NumPy Arrays and Operations

2. Array Indexing and Slicing

3. Mathematical and Statistical Functions

1. DataFrames and Series

2. Data Cleaning and Transformation

3. Aggregations and GroupBy

1. Matplotlib Basics

2. Seaborn for Statistical Visualization

1. Scikit-learn, TensorFlow, PyTorch Overview

2. Environment Setup for AI Development

1. End-to-End Python Data Pipeline

2. Capstone Project

Overview of Analytics and Power BI Tools Suite

Career Opportunities and Job Roles in Power BI

Power BI Data Analyst (PL 300) Certification Overview

Introduction to AI Visuals and Features in Power BI

Understanding the Power BI Ecosystem and Architecture

Data Sources and Types for Power BI Reporting

Power BI Design Tools and Desktop Tool Installation

Exploring Power BI Desktop Interface: Data View, Report View, and Canvas

Visual Interaction Techniques in Reports

Using Slicers for Dynamic Report Filtering

Managing Report Pages and Visual Sync Limitations

Implementing Grouping and Binning in Reports

Creating and Utilizing Hierarchies for Drill-Down Reports

Introduction to Power Query M Language

Basic Data Transformations in Power Query

Understanding Query Duplication and Grouping

Overview of Power BI Cloud Components and App Workspaces

Creating and Managing Reports and Dashboards in Power BI Cloud

Sharing, Subscribing, and Exporting Reports in Power BI Cloud

Understanding the Importance of DAX in Power BI

Learning Basic DAX Syntax, Data Types, and Contexts

Simple Measures and Calculations with DAX

Building data pipelines in Fabric

Data flow design and execution

Workflow automation

Monitoring and alerting

Data quality frameworks

Governance and compliance

Accessing Big Data Sources and Azure Databases

Advanced Filtering Techniques and Utilizing Bookmarks

Implementing Various Chart Types and Map Visuals

Deep Dive into Advanced Data Cleaning and Preparation Techniques

Implementing Parameter Queries for Dynamic Data Loads

Creating and Managing Parameters in Power Query

Configuring and Managing Gateways for Data Refresh

Utilizing Workbooks and Excel Online with Power BI Cloud

Creating and Managing Power BI Apps

Implementing Quick Measures and Advanced Calculations

Data Modeling and Relationship Management in DAX

Mastering Variables and Dynamic Expressions in DAX

Advanced DAX Functions for Time Intelligence

Implementing Row Level Security (RLS) with DAX

Utilizing DAX for Custom Analytics and Reporting

Configuring Power BI Report Server

Understanding Power BI Administration and AI Features

Managing Security and Administration in Power BI

Implementing Cloud and Server Deployments

Custom Visualizations and Integration with REST APIs

Project Phases: From Basic Report Design to SME Level Deployments

Resume Preparation and Mock Interviews

Cross-validation, metrics, hyperparameter tuning

Forecasting, ARIMA, Prophet

Model serving, APIs, production best practices

Topics:

Introduction to Excel: Interface, Basic Operations, and Managing Worksheets

Fundamental Data Operations: Sorting, Filtering, and Conditional Formatting

Basic Formulas and Functions: Sum, Average, Logical Functions (IF, AND, OR), and Text Functions (LEFT, RIGHT, CONCATENATE)

Topics:

Advanced Data Management: Data Validation, Advanced Filtering, and Named Ranges

Creating and Managing Tables for Efficient Data Analysis

Introduction to Data Visualization: Creating and Customizing Charts (Bar, Line, Pie), and Using Sparklines

Topics:

Comprehensive Guide to PivotTables: Creating, Customizing, Slicers, and Timelines

Basic to Advanced PivotTable Techniques: Grouping Data, Calculated Fields

Data Cleanup Techniques: Removing Duplicates, Text to Columns, Flash Fill

Topics:

Mastering Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP

Introduction to Power Query for Data Transformation and Cleaning

Power Pivot and DAX Basics: Creating Data Models, Introduction to DAX Formulas for Data Analysis

Topics:

Automating Tasks with Macros and an Introduction to VBA for Custom Functions

Advanced Chart Techniques and Creating Interactive Dashboards

Workbook Protection, Sharing Workbooks for Collaboration, Documenting and Auditing Workbooks

Image, audio, and video generation models

API integration

Building production GenAI applications

Bias, safety, ethical considerations

End-to-end GenAI project

Topics:

Understanding Table Relationships: Primary keys, foreign keys, and the importance of relationships in databases.

Join Operations: `INNER JOIN`, `LEFT JOIN`, `RIGHT JOIN`, and `FULL JOIN`.

Subqueries and Nested Queries: Using subqueries in the `SELECT`, `FROM`, and `WHERE` clauses.

Aggregating Data: Using `GROUP BY` and aggregate functions (`COUNT`, `SUM`, `AVG`, `MIN`, `MAX`).

Topics:

Data Manipulation Commands: `INSERT`, `UPDATE`, `DELETE`.

Managing Tables: Creating and altering tables (`CREATE TABLE`, `ALTER TABLE`, `DROP TABLE`).

Advanced Filtering Techniques: Using `LIKE`, `IN`, `BETWEEN`, and wildcard characters.

Working with Dates and Times: Understanding and manipulating date and time data.

Topics:

Advanced SQL Functions: String functions, mathematical functions, and date functions.

Window Functions: Overviews of `ROW_NUMBER`, `RANK`, `DENSE_RANK`, `LEAD`, `LAG`, and their applications.

Query Performance Optimization: Indexes, query planning, and execution paths.

Common Table Expressions (CTEs): Writing cleaner and more readable queries with `WITH` clause.

Topics:

Analytical SQL for Reporting: Building complex queries to answer analytical questions.

Pivoting Data: Transforming rows to columns (`PIVOT`) and columns to rows (`UNPIVOT`).

Data Warehousing Concepts: Introduction to data warehousing practices and how they apply to SQL querying.

Integrating SQL with Data Analysis Tools: Connecting SQL databases with tools like Excel, Power BI, and Python for deeper data analysis.

Agent frameworks and orchestration

Multi-agent collaboration patterns

Persistence and context handling

Self-directed agent execution

Testing and safety guardrails

Deployment and scaling

1. Introduction to Python

Overview of Python's history, key features, and comparison with other languages.

Setting up the Python environment, writing your first program. 2. Core Programming Concepts

Variables, data types, conditional statements, loops, control flow.

Introduction to strings, string manipulation, and basic functions.

Topics:

1. Deep Dive into Collections

Understanding lists, tuples, dictionaries, sets, and frozen sets.

Functions, methods, and comprehensions for collections.

2. Functional Programming in Python

Exploring function arguments, anonymous functions, and special functions (map, reduce, filter).

3. Object-Oriented Programming (OOP)

Classes, objects, constructors, destructors, inheritance, polymorphism.

Encapsulation, data hiding, magic methods, and operator overloading.

Topics:

1. Mastering Exception Handling

Exception handling mechanisms, try & finally clauses, user-defined exceptions.

2. File Handling Essentials

Basics of file operations, handling Excel and CSV files.

3. Database Programming

Introduction to database connections and operations with MySQL.

Topics:

1. Getting Started with Flask

Setting up Flask, creating simple applications, routing, and middleware.

2. Exploring Django

Introduction to Django, MVC model, views, URL mapping.

Topics:

1. Automation and Scripting

Enhancing file handling, database automation, and web scraping with BeautifulSoup.

2. GUI Development with TKinter

Basics of TKinter for developing desktop applications.

3. Version Control with Git

Managing projects with Git, understanding repository management, commits, merging, and basic Git commands.

Motion planning, SLAM, obstacle avoidance

Reinforcement learning, control systems

Natural language, gesture, collaborative robotics

On-device ML, edge computing

End-to-end robotics project