Data Analytics Project Guide - Varanasi

Job summary

Learning data analytics becomes much more effective when guided by professionals who have both technical expertise and real-world experience. This mentorship program supports participants with a qualified team of data analysts and mentors who bring diverse skills across SQL, Python, and BI tools like Power BI & Tableau.

Responsibilities

• Design a relational database using SQL to manage sales transactions, customer profiles, and regional data.
• Build complex queries (joins, window functions, aggregations) to extract insights.
• Use Tableau to build an interactive dashboard that highlights retention risks, workforce diversity, and hiring trends.
• Perform Exploratory Data Analysis (EDA) on customer purchase data using Pandas, NumPy, and Seaborn.
• Apply clustering techniques (e.g., K-means) to group customers by behavior, then visualize results.
• Build a machine learning model (Logistic Regression / Random Forest) to predict customer churn.
• Use feature engineering, train-test split, and model evaluation metrics (AUC, precision, recall).
• Use Python to analyze stock price or financial transaction data.
• Perform time series analysis (moving averages, ARIMA/Prophet models) to forecast future trends.
• Visualize patterns with Matplotlib and Plotly.

Job description