Swarnali Mistry
data analyst | Business analyst
SKILLS
ABOUT ME
I'm a dedicated and detail-oriented student at Jadavpur University , in pursuit of building a career IN DATA ANALYSIS with a strong foundation in statistical analysis, data visualization and CASE-SOLVING. Passionate about transforming raw data into actionable insights, I have hands-on experience with programming languages like Python and SQL, and I am proficient in using data analysis tools such as MYSQL , POSTGRESQL,POWERBI,TABLEAU and Excel. My DETAIL ORIENTED projects have equipped me with the skills to tackle complex data challenges and deliver data-driven solutions.
FEATURED PROJECTS
SALES ANALYSIS DASHBOARD | POWER BI | MYSQL
ANALYSING PIZZA SALES DATA to identify key trends and insights. By creating interactive dashboards and querying the database, I provided actionable recommendations to improve sales performance and customer satisfaction.
ECOMMERS DATASET | PYTHON | JUPYTER NOTEBOOK | SQL
ANALYZING ECOMMERCE DATASETS uncovered patterns and trends to optimize business strategies. Utilizing data visualization and statistical analysis and libraries like numPy, pandas, matplotlib, seaborn I provided actionable insights for improving customer engagement and sales performance
SENTIMENT ANALYSIS | PYTHON | NLTK | VADER
SENTIMENT ANALYSIS OF AMAZONFOODREVIEWS using Python libraries such as VADER, NLTK, and SEABORN to evaluate and visualize consumer feedback. By analyzing the sentiment of textual data, I provided valuable insights to enhance product development and customer satisfaction strategies
CONTACT ME
POWER BI SALES ANALYSIS
Developed an interactive Power BI dashboard to analyze sales data, providing insights into sales trends, customer behavior, and product performance.I WORKED WITH- Data modeling and DAX formulas
- Visualizations and interactive filters
- Drill-through and slicing capabilitiesMY GOAL IN MIND WHILE WORKING ON IT WAS- Revenue growth and profitability
- Improved sales forecasting and pipeline management
- Enhanced customer segmentation and targeting
- Data-driven decision-making and strategic planningThe dashboard provides a single source of truth for sales data, enabling business stakeholders to make informed decisions and drive business success.
ECOMMERCE DATA ANALYSIS
Analyzed ecommerce data using Python, MySQL, and Jupyter Notebook to gain insights into customer behavior, sales trends, and product performance.
I WORKED WITH
- Data ingestion and preprocessing using Pandas
- Data visualization and exploration using Matplotlib and Seaborn
- Statistical analysis and modeling using Scikit-learn
- Database querying and data retrieval using MySQLMY GOAL IN MIND WHILE WORKING ON THIS PROJECT- Identify key customer segments and behaviors
- Analyze sales trends and product performance
- Develope data-driven recommendations to optimize marketing strategies, improve customer experience, and increase revenue
Key findings and recommendations were presented to inform business decisions and drive growth.
SENTIMENT ANALYSIS
Developed a sentiment analysis model to analyze customer feedback and reviews, providing insights into customer opinions and emotions. The model enables businesses to identify areas of improvement, track brand reputation, and make data-driven decisions.
I WORKED WITH- Text preprocessing and tokenization
- Feature extraction and sentiment scoring
- Nltk , vader libraries
MY GOAL WHILE WORKING ON THIS PROJECT
The model achieves and provides actionable insights into customer sentiments, enabling businesses to make informed decisions.
- Improving customer satisfaction and loyalty
- Enhancing brand reputation and online presence
- Informing product development and marketing strategies
- Identifying areas of improvement and optimizing operationsThe model provides a data-driven approach to understanding customer sentiments, enabling businesses to make informed decisions and drive growth.