I am passionate about transforming raw data into meaningful business insights using Power BI, SQL, Excel, Python, and data visualization techniques. I enjoy building interactive dashboards, analyzing datasets, and solving business problems through data-driven decision-making.
Currently pursuing B.Tech in Computer Science & Design at Datta Meghe Institute of Higher Education and Research, I am continuously improving my analytical, visualization, and business intelligence skills through real-world projects and internships.
- Power BI
- SQL
- Excel
- Tableau
- Data Visualization
- Dashboard Development
- KPI Reporting
- Business Intelligence
- Python
- Pandas
- NumPy
- Matplotlib
- Seaborn
- MySQL
- GitHub
- Jupyter Notebook
- Google Colab
- Visual Studio Code
- Streamlit
Designed and developed a complete Library Management System using PostgreSQL. Implemented relational database design, CRUD operations, joins, aggregate functions, CTAS, and PL/pgSQL stored procedures to automate book issue/return processes and generate business reports.
Developed an interactive sales analytics dashboard using Power BI to monitor KPIs, sales performance, profit, customer behavior, product trends, and regional insights with interactive visualizations.
Built a sales forecasting dashboard using Power BI to predict future sales trends and support business planning through forecasting techniques and time-series analysis.
Performed end-to-end retail sales analysis using SQL by writing complex queries involving joins, aggregate functions, subqueries, CTEs, and window functions to uncover customer behavior, product performance, and sales trends.
Created an interactive HR analytics dashboard to analyze employee attrition, workforce demographics, performance metrics, and organizational insights using Power BI and DAX.
Developed a machine learning web application using Python and Streamlit to predict multiple diseases based on user inputs. Implemented classification models, data preprocessing, and an interactive user interface.
- Performed exploratory data analysis and preprocessing
- Worked with Python and analytical techniques
- Generated insights and reports for predictive analysis
- Worked with healthcare datasets and operational analysis
- Assisted in SQL querying and reporting
- Supported workflow optimization and structured data handling
- Advanced SQL
- Power BI DAX
- Python for Data Analytics
- Machine Learning
- Data Engineering Basics
Seeking opportunities as a Data Analyst, Power BI Developer, or Business Intelligence Analyst where I can apply analytical thinking, visualization skills, and problem-solving abilities to create impactful business solutions.
π LinkedIn: https://www.linkedin.com/in/prajyot-yesankar-79215b258/ π» HackerRank: https://www.hackerrank.com/profile/yesankarprajyot π GitHub: https://github.com/yesankarprajyot123
β Passionate about turning data into actionable insights through analytics and visualization.