Jyoti Dixit

Results-driven Data Analyst proficient in SQL, Power BI, Tableau, and Excel, with a track record to transform data into actionable insights. Experienced in data validation, reporting, and visualization, I am passionate about fostering a data-driven culture to support strategic decision-making. Eager to contribute my analytical skills and make a meaningful impact within a forward-thinking organization.

• Data Analyst, ExcelR, Bengaluru, Karnataka, 06/01/23, 06/01/24
• Data Collection, Cleaning and Transformation using Power Query., Learned how to extract insights from unstructured data using Excel, SQL, Power BI, and Tableau and dynamic Dashboards., Was mentored by working industry experts on technical skills along with Soft Skills training to enhance communication.
• Agile Project Management, ExcelR, Bengaluru, Karnataka, 12/01/23

Hobbies: Reading, Traveling, Dancing, Playing Badminton, Gymming, Listening to Music

• English
• Hindi
• Punjabi
• Kannada

Bank Analysis
- Analyzed financial data from multiple bank branches using Excel, Power BI, Tableau, and MySQL to optimize operational efficiency.
- Gathered and cleaned large datasets from various sources with MySQL to ensure the accuracy of financial metrics.
- Developed comprehensive models to analyze key performance indicators (KPIs) like net income and loan performance.
- Created interactive dashboards and visual reports in Tableau and Power BI for real-time tracking of branch performance.
- Conducted statistical analysis to identify underperforming branches, resulting in a 15% increase in overall customer satisfaction.

HR Analytics
- Implemented HR analytics using Excel, Power BI, Tableau, and MySQL to improve workforce management and retention strategies.
- Collected, cleaned, and analyzed employee data with MySQL for insights into turnover trends and engagement metrics.
- Created predictive models to address employee attrition issues proactively by identifying potential factors leading to turnover.
- Developed comprehensive dashboards offering real-time visibility into recruitment processes using Tableau and Power BI. Presented key insights that reduced turnover by 10% while improving employee engagement scores.

Manufacturing Process Improvement
- Analyzed manufacturing operations using Excel, Power BI, Tableau & MySQL. Defined critical KPIs related to cycle times & OEE effectiveness for assessing production efficiency across various lines.
Designed performance dashboards for visualization of production metrics. Provided data-backed recommendations that optimized schedules & enhanced productivity by reducing costs up by 12%.

Crowdfunding Analysis
-Analyzed crowdfunding campaigns utilizing Excel & SQL tools - developed funding rate measures focusing on goal achievement through the creation of real-time dashboards in both platforms. Delivered comprehensive reports summarizing insights that led to enhanced fundraising outcomes while improving campaign strategies based on competitive market research.