PG Program In Data Analytics & Gen AI

Key Areas of Learning

• Introduction to Excel
• Fundamentals of Excel
• Data Exploration with Built-in Functions
• Basic Visualization Analytics
• Charts and Graphs

Key Areas of Learning

• Functions
• Lookup, VLOOKUP, INDEX, HLOOKUP
• Date and Time Functions
• Data Tables and Validation
• Pivot Tables
• Financial Functions
• Macros & Coding
• Custom Formatting and Advanced Filters

Key Areas of Learning

• Storytelling with Excel
• Basics of Dashboarding
• Creating Advanced Dashboards

Key Areas of Learning

• Introduction to Databases & Queries
• Extracting Data using SQl
• Setting Up Big Queries
• Function Filtering & Sub-Queries
• Join Sub Queries
• Aggregation
• Date & Time Functions
• Indexing & Partitioning

Key Areas of Learning

• Probability
• Bayes Theorem
• Distribution
• Discriptive Statistics & Outliers Treatment
• Hypothesis Testing & AB Testing
• ANOVA
• Correlation

Key Areas of Learning

• Introduction Power BI
• Cleaning, Transforming, & Loading Data
• Designing a Data Model
• Visualisation
• Introduction to DEX
• Dashboarding
• Generating Reports
• Case Studies

Key Areas of Learning

• Programming Foundation- Flowchart, Data Types & Operators
• Condition & Loops
• Functions
• Sting Handling
• Data Structures- List, Tuple, Dictionary, Set, Matrix
• OOPs

Key Areas of Learning

• Numpy
• Pandas
• Data Acquisition
• Web Scraping
• Beautifulsoup
• Selenium

Key Areas of Learning

• Matplotlib
• Seaborn
• Visualisation using Charts & Graphs

Key Areas of Learning

• Understanding GPT
• Generative AI
  • Basics of AI
  • Types of Generative AI Models
    • Transfer Learning
    • Word Embeddings
    • Diffusion Models
    • Image Generation
    • Generative Adversarial Networks
    • Transformers & Attention Mechanisms

Key Areas of Learning

• Generative AI Frameworks
  • LangChain
  • Vector Databases (ChromaDB, FAISS)
  • APIs
  • Retrieval Augmented Generation (RAG)
  • OpenAI API
  • Prompt Design
  • Semantic Search
• Generative AI Tools
  • Vertex AI (Gemini)
  • Hugging Face
  • ChatGPT
  • Data Analytics GenAI Tools

Key Areas of Learning

• Use of Generative AI in Data Analytics
  • Generative AI in Data Analytics Lifecycle
  • GenAI for Data Preparation & Data Querying
  • Generative AI for Data Insights
  • Generative AI for Data Visualization
• Introduction to Ethics and Responsibilities in GenAI
  • Understanding the Ethical Implications of Generative Models
  • Addressing Bias and Fairness in Generative AI Systems
  • Ensuring Responsible Use and Deployment of Generative Models
• Product Development, Deploy WebApps with Flask
  • Project

Key Areas of Learning

• Overview of Git
• Git & GitHub Topics (General)
• Installation of Git & Shell Configuration
• Basic Shell Commands
• Working with Branches
• Merging Branches
• Fetching & Pulling
• Git Basic Files Configuration
• Git Collaboration Workflows

• Resume Building & Cover Letter
• LinkedIn & GitHub Optimization
• Communication Skills & Interview etiquette
• Aptitude Preparation Kit & Mock Interviews

Resume and cover letter building involves creating clear, concise, and tailored documents that highlight an individual’s education, skills, and experience. Together, they showcase qualifications, demonstrate enthusiasm, and help create a strong first Impression to attract potential employers.

LinkedIn and GitHub optimization involve refining profiles and repositories to boost visibility, professionalism, and collaboration. This includes crafting engaging summaries, showcasing skills and projects, maintaining clear documentation, and actively engaging with the community—enhancing personal branding, credibility, and career opportunities.

Effective communication and proper interview etiquette are essential for creating a strong impression during job interviews. Clear articulation, active listening, confidence, and positive body language help convey professionalism and enthusiasm. Arriving on time, dressing appropriately, maintaining eye contact, and expressing gratitude further demonstrate respect and preparedness, leaving a lasting positive impact on interviewers.

An aptitude preparation kit and mock interviews together provide a comprehensive approach to career readiness. The aptitude kit strengthens numerical reasoning, logical thinking, and problem-solving abilities through structured practice tests, study materials, and expert tips. Mock interviews, on the other hand, replicate real interview scenarios, allowing individuals to refine their communication, presentation, and analytical skills. Combined, they build confidence, improve performance, and enhance overall preparedness for academic assessments and professional job interviews.