Program Overview
Advanced Executive Certification & Internship in Data Analytics With PowerBI and Microsoft's DA-100 / PL-300 Certification
Offered by: Centre for Training and Employment, CTE
Collaboration with: Council for Citizen Rights, CCR (NGO) - National Mission Technical Education for Employment Wing
Duration: 4 months
Mode: Online and Offline

Regular Classes Start from next week - Monday.
Enrollments open till next week - Friday. Choose your preferred Weekday or Weekend Batches with timings:
1) Morning: 9:00 AM / 11:00 AM
2) Evening: 6:00 PM / 8:00 PM

For Assistance:
Call/WhatsApp: 9281434940, 9281434942, 9281434945, 9281434946.
WhatsApp Only: 8072211686, 9346000855
Visit our centers for in-person guidance.

For Enrollment Payments:

Refer LMS Portal Above -> Click on "Enrollment Booking" -> Buy Now for 49/- -> Scan the QR Code (below) or use UPI or Bank Account of CTE to Pay Enrollment Fees for Training / Internship / Placement or any of these -> Take Invoice from CTE Support Team -> Join Regular Batch WhatsApp Community Group -> Start attending LIVE Classes online / offline.

1) GPay or PhonePe or Paytm or BHIM App etc:
UPI:
cte-india@ibl, cte-india@ybl, cte-india@axl 
QR Code:

2) Account Name: Centre for Training and Employment CTE:
HDFC Bank.
Account Number: 50200099547479
IFSC Code: HDFC0004342

Note:
Contact CTE Support Team for Enrollment Invoice.

Roadmap, Skills & Tools, Learning Path of the Course - available at LinkedIn:
https://lnkd.in/g2KAhusq

Key Features:

•  260 hours of SME led Training & 80 hours of Projects & Exercises
•  LIVE in-person classroom and LIVE Online Video Classes
•  Each Session Live Recordings, Study Materials, Program Files, Assignments, Projects, Quizes available in Learning Management System (LMS) Portal after the class
•  Lifetime Access to Course
•  1:1 mentorship
•  50+ industry projects
•  Certification from the Centre for Training and Employment (MSME, ISO, AICTE)
• Guranteed Job Assistance Till Placement
•  Campus immersion at India's reputed Universities, Institutions, MNCs, Industries
•  Up to ₹50 Lakh startup incubation support

Our Credentials:

•  Certified & Placed Students: 15 Thousand+  
•  Instructors: 56+ Industry Experts  
•  Hiring Partners: 125+  
•  Corporates & Colleges Upskilled: 175+  
•  States in India with Learners: 18+  

Why Data Analytics with Power BI?

Growing Career Opportunities: Data Analytics is among the fastest-growing fields, and Power BI is one of the most in-demand tools for data visualization and business intelligence.

High Demand: Over 50% of organizations globally are adopting Power BI for their analytics needs, leading to a surge in job openings for Power BI specialists.

Salary Potential: Professionals skilled in Power BI earn 40–50% higher salaries than average data analyst roles due to the tool's widespread adoption and importance in decision-making.

Skill Development: Master skills like creating interactive dashboards, generating insightful reports, data modeling, and advanced DAX (Data Analysis Expressions) to become a key asset for any organization.

Learning Path and Roadmap

• Python
• SQL
• Excel
• Performance Metrics
• Forecasting
• Power BI
• Data Storytelling

Skills to Master

•  SQL, Python
•  Data Wrangling and Data Analysis  
•  Data Visualization (Power BI, Excel)   

Tools

•  SQL Tools  
•  Python (NumPy, Pandas, Matplotlib)  
•  Power BI  
•  Microsoft Excel  
•  Jupyter Notebook  

Detailed Modules:

📘 Module 1: Excel for Data Analysis & Dashboards
Topics Covered:  
- Advanced Excel Functions (VLOOKUP, INDEX/MATCH, IF, SUMIFS, etc.)
- Pivot Tables, Pivot Charts, Slicers  
- Conditional Formatting  
- Data Cleaning using Excel Tools  
- Dashboard Design & Best Practices  
- Excel to Power BI Transition  

🛠️ Hands-on:  
- Build Sales & Finance Dashboards  
- Data Cleaning Assignment  

🐍 Module 2: Python for Data Analytics
Topics Covered:  
- Python Basics (Data Types, Loops, Functions)  
- NumPy for numerical computations  
- Pandas for data analysis & preprocessing  
- Matplotlib & Seaborn for visualization  
- Working with CSV, Excel, JSON files  

🛠️ Hands-on:  
- Analyze a retail dataset using Pandas  
- Plot data trends & correlations  

🧠 Module 3: Statistics & EDA (Exploratory Data Analysis)
Topics Covered:  
- Mean, Median, Mode, Range, IQR  
- Standard Deviation, Variance, Z-score  
- Outlier Detection & Treatment  
- EDA with Pandas + Seaborn  
- Data Imputation & Transformation  

🛠️ Hands-on:  
- Perform EDA on healthcare or HR dataset  

🗃️ Module 4: SQL for Data Analytics
Topics Covered:  
- DDL, DML, DQL  
- SELECT, WHERE, GROUP BY, HAVING  
- JOINS (INNER, LEFT, RIGHT, FULL)  
- Subqueries, CTEs, Window Functions  
- Real-time Reporting Scenarios  

🛠️ Hands-on:  
- Analyze employee database  
- Prepare HR & Finance queries  

📊 Module 5: Power BI Basics & Data Modeling
Topics Covered:  
- Power BI Desktop Overview  
- Data Sources, Loading, Transforming (Power Query)  
- Relationships & Data Modeling  
- Star vs Snowflake Schema  
- Calendar Tables & Time Intelligence  

🛠️ Hands-on:  
- Create Model for Sales & HR datasets  
- Create Calendar & Date Intelligence  

📈 Module 6: DAX for Data Analysis
Topics Covered:  
- Calculated Columns vs Measures  
- Basic DAX (SUMX, CALCULATE, FILTER)  
- Time Intelligence Functions  
- KPI Creation using DAX  
- Dynamic Slicers & Filters  

🛠️ Hands-on:  
- Build a dynamic sales KPI dashboard  
- Time-based YOY analysis  

📉 Module 7: Interactive Dashboards & Storytelling
Topics Covered:  
- Visualization Best Practices  
- Slicers, Tooltips, Drill-Through  
- Bookmarks, Buttons, Navigation  
- Mobile View Configuration  
- Storytelling Framework  

🛠️ Hands-on:  
- Create HR & Sales dashboards  
- Design storytelling board for client  

📜 Module 8: DA-100 / PL-300 Certification Prep
Topics Covered:  
- DA-100 / PL-300 Exam Domains  
- Key Topics: Data Preparation, Modeling, Visualization, Deployment  
- Sample Questions & Mock Tests  
- Exam Strategy & Time Management  

🛠️ Hands-on:  
- 2 full-length mock tests  
- Weekly review tests  

🧪 Module 9: Capstone Project + Internship Simulations
Project Options:  
- Sales Analysis Dashboard  
- HR Attrition Predictor + Dashboard  
- Retail Product Profitability Report  
- Power BI for Government/Public Sector Analysis  

📌 Includes:  
- Data Cleaning (Excel/Python)  
- SQL Queries & Integration  
- Power BI Dashboards  
- Executive Report (PDF + PPT format)

📁 Module 10: Portfolio, Interview Prep & Job Assistance
Topics Covered:  
- Resume & LinkedIn Optimization  
- Portfolio Building (GitHub/Behance)  
- Mock Interviews – Technical + HR  
- Internship Experience Letter  
- Interview Q&A for DA-100/PL-300 Roles 

Faculty and Advisors

•  Renowned professors
•  Industry experts

Career Services

•  1:1 Mock Interviews  
•  Dedicated Placement Support  
•  Career Fairs and Resume Building  
•  Access to 200+ job postings monthly  

Job Roles and Salaries

•  Data Analyst: ₹6-12 LPA  
•  Business Analyst: ₹8-14 LPA  
•  Machine Learning Engineer: ₹10-18 LPA  
•  Data Scientist: ₹12-20 LPA  
•  Business Intelligence Analyst: ₹8-15 LPA  

Innovative Features:  

•  Learn by Doing: Hands-on exercises, projects, quizzes, assignments and capstone projects.
•  Gamified Learning: Hackathons and group activities.
•  Peer Networking: Build professional connections through collaborative learning.

Program Pedagogy: 

• Instructor-led Training: Delivered by top industry experts.  
• Projects and Exercises: Gain real-world experience.  
• Hackathons: Understand real-world project-building techniques.  
• Personalized Learning: Tailored 1:1 mentoring. 

About Centre for Training and Employment (CTE):

CTE is a leading online education provider, and also classroom / offline services partnering with prestigious colleges and industries, consultants.

Mission: Democratizing education with cutting-edge training solutions.

Placement Sources

1. Premium Job Portals:

•      Naukri, LinkedIn, Glassdoor, Monster, and Indeed for job matching and direct applications.

2. Hiring Companies Requirement List:

•      Regular updates from partnered companies about open roles and skill demands.

     Industry-specific collaborations (e.g., IT, Banking, Healthcare, E-commerce).

3. HR Connections:

•     Build a network of HR professionals for referrals and insights into recruitment trends.

    Conduct periodic meetups and webinars with HR executives.

4. Consultations and Industry Experts:

•     Collaborate with career consultants and market experts to refine placement strategies.

5. Recruitment Agencies:

•     Partnerships with top recruitment agencies for exclusive job openings.

6. Company Tie-Ups:

•      Direct collaborations with companies for hiring events and job drives.

7. Internship Providers:

•      Companies offering internships, leading to pre-placement offers (PPOs).

8. Freelance and Gig Platforms:

•       Platforms like Upwork, Toptal, and Fiverr for freelance and contract-based work opportunities.

9. Networking Events:

•       Job fairs, industry conferences, and alumni networking are used to connect with employers.

10. Technology Tools:

•      Use of Applicant Tracking Systems (ATS) and AI-driven tools for job search optimization.

Flexible Fee Structure and Payment Options

• At CTE Academy, we aim to make quality education accessible and affordable for everyone. 
• Explore our flexible fee categories, scholarships, and EMI options tailored to suit your financial needs.

Fee Categories

• Training Only: ₹15,500
• Training and Placement: 24,500 (EMI options available)
• Book for Offline - Classroom (Hyderabad - Vijayawada and Siddipet) / Work and Learn .
  • Reserve Seat for ₹3,000
  • The fee structure is the same as Online via LMS
• Pay After Placement:
  • Before Placement: ₹15,500 
  • After Placement: ₹44,500

Scholarship Program

• Who Can Apply: Unemployed and underprivileged candidates
• Scholarship Amount: 10% to 40% off on the One-Time Payment (OTP) fees

Exclusive EMI Plans - CTE Academy via Unacademy (Graphy) Collaboration with several organizations:

• Make learning stress-free with our easy-to-manage EMI options. 

"Education made easy – success made inevitable!"