Smriti Rawat
Entry-Level Data Analyst skilled in Python, SQL, Excel, and Power BI, with hands-on experience in data cleaning, exploratory data analysis (EDA), dashboard development, and predictive analytics through academic projects.
Experience
Education
AcceleratorX
Certificate
Chandigarh University
Bachelor of Science
CGPA: 7.58 CGPA: 6.36
SPS International School
Higher Secondary (XII)
Percentage: 73.2%
Skills
PythonSQLMyformulasdata cleaningPowerBIPandasNumPyData Cleaning & PreprocessingData VisualizationExploratory Data Analysis (EDA)CommunicationMachine learningMatplotlibSciket learn
PROJECTS
Titanic Survival Analysis
Built a Titanic Survival Analysis solution by cleaning and preprocessing data, handling missing values, and performing feature engineering. Trained and evaluated multiple machine learning models and developed an interactive Power BI dashboard, achieving 80% prediction accuracy and identifying key survival trends.
Technologies Used
Python (Pandas, Scikit-learn, Matplotlib), Power BI, DAX, Machine Learning, Feature Engineering, Data Visualization.
Retail Analytics Project
Developed a Retail Analytics solution using SQL, Python, and Power BI to analyze sales data and uncover product, customer, and seasonal insights. Built interactive Power BI dashboards and performed customer segmentation, sales trend analysis, and revenue analysis to support business decisions.
Technologies Used
SQL (MySQL), Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, ETL, Feature Engineering, Data Visualization.
Hotel Booking Analytics
Developed a Hotel Booking Analytics solution using SQL, Python, and Power BI to analyze booking demand, cancellations, occupancy trends, and revenue performance. Performed EDA, data cleaning, and feature engineering to identify cancellation patterns, ADR differences, and guest demographic trends.
Technologies Used
SQL (MySQL Workbench), Python (Pandas, Seaborn, Matplotlib), Power BI, DAX, EDA, Feature Engineering, Data Visualization.