Internship Program β CS
Data Analyst Intern (Python, SQL, Power BI & Gen AI)
Expert Trainer
Lead Trainer β Internship Program
β
β
β
β
β
(150)
Piedocx Technologies offers a hands-on Data Analytics Internship in Lucknow for students who want to become job-ready data analysts. This 3 to 6 month internship takes you from Excel and SQL to Python, Power BI dashboards and Generative AI tools, and you learn by working on real business datasets, guided by industry mentors.
What You'll Learn
Advanced Excel & Data Cleaning
SQL (MySQL & PostgreSQL)
Python, NumPy & Pandas
Data Visualization (Matplotlib & Seaborn)
Power BI & DAX
Statistics for Data Analysis
Machine Learning Basics
Generative AI for Analytics
Live Projects & Capstone
Git, GitHub & Portfolio Building
Requirement For This Training
Laptop / PC with Internet
CS Student (1stβ3rd Year)
Basic Subject Knowledge Helpful
Excel & Data Foundations
+
Advanced Excel
Formulas & Functions
Pivot Tables & Charts
Data Cleaning in Excel
Excel Dashboards
Statistics & Business Basics
+
Descriptive Statistics
Probability Basics
Hypothesis Testing
KPIs & Business Metrics
Data Storytelling
Python Programming Basics
+
Python Basics & Syntax
Data Types, Loops & Functions
File Handling
Jupyter Notebook
Developer Tools
+
Git & GitHub Basics
VS Code & Google Colab
Kaggle Datasets
Data Sources & APIs
SQL & Database Technologies
+
MySQL
PostgreSQL
Joins & Subqueries
Window Functions
Database Management
Python for Data Analysis
+
NumPy
Pandas
Data Cleaning & Preprocessing
Exploratory Data Analysis (EDA)
Matplotlib & Seaborn
Business Intelligence & Dashboards
+
Power BI
DAX
Data Modeling
Interactive Dashboards
Publishing & Sharing Reports
Machine Learning for Analysts
+
Scikit-learn
Regression & Classification
Clustering (K-Means)
Model Evaluation
Feature Engineering
Generative AI for Data Analytics
+
Prompt Engineering for Analysts
ChatGPT, Gemini & Claude for Data Analysis
AI-Assisted SQL & Python
Text to SQL
Automated Report Generation
Advanced Analytics & Automation
+
Time Series Analysis
Web Scraping for Data Collection
Automation with Python
Streamlit Dashboards
Data Pipelines Basics
Excel & SQL Projects (Month 1)
+
Sales Data Dashboard (Excel)
Student Performance Analysis
HR Analytics Dashboard
Library Book Issue & Return System (SQL)
Inventory & Stock Management (SQL)
Python Data Analysis Projects (Month 2)
+
Market Trend Analysis
Cricket & IPL Data Analysis
E-Commerce Behavior Analysis
Data Visualization Report
COVID-19 / Public Dataset Analysis
Power BI Dashboard Projects (Month 3)
+
Sales & Profit Dashboard
Customer Analytics Dashboard
Financial Performance Dashboard
Healthcare Data Dashboard
Retail Store Analysis
Machine Learning Projects (Month 4)
+
Customer Churn Prediction
Customer Segmentation (K-Means)
House Price Prediction
Stock Market Analysis & Prediction
Movie Recommendation System
Industry Internship Projects (Month 5-6)
+
Client-Based Live Project (Real Requirement)
Social Media Sentiment Analysis
AI-Powered Data Analyst Assistant (Text to SQL)
Automated Business Report Generator
Project Documentation & Code Review
Weekly Demo & Mentor Feedback
Final Capstone & Career Readiness
+
Final Capstone Project (End-to-End Analytics + Dashboard)
Live Demo & Business Presentation
GitHub Portfolio & Documentation
Resume, LinkedIn & Naukri Profile Optimization
Mock Technical Interviews
Final Project Presentation
Training Includes
130 Lessons
400 of Content
Intermediate
Hindi/English
150+ Enrolled
Certificate on Completion
3β6 Months
Offline