Yashaswi Tirole | Data Analyst

Hi, I'm Yashaswi Tirole.

A

Collect, process, analyse and present data - from supporting everyday business decisions to driving global change.

About

I am passionate about leveraging data analytics tools to uncover insights and drive informed decision-making. With a strong foundation in Power BI, SQL, Python, and Microsoft Excel, I enjoy transforming complex datasets into meaningful visualizations and reports. Eager to learn and grow in the field, I am constantly exploring innovative data solutions to optimize processes and enhance business strategies. I look forward to connecting with professionals and contributing to impactful data-driven projects.

Languages: Python, SQL, HTML/CSS
Databases: MySQL, PostgreSQL, SQL Server
Libraries & Packages: Pandas, NumPy, Matplotlib, Seaborn, SciPy, StatsModels
Visualization Tools: Power BI, Tableau, Clevertap
Machine learning & Analystics: Scikit-learn, TensorFlow (basic), OpenCv, Scikit Learn
Tools & Technologies: Git, Excel (Advanced), Google Sheets

Let’s discover how our shared interests and experiences can create meaningful collaborations.

Experience

Avaali Solutions Pvt. Ltd.

Associate Consultant

Worked as a consultant on support projects for three different clients to help them understand the system and resolve all the issues in realtime.
As a consultant, I have worked on implementing and customizing SAP VIM solutions using ABAP programming, successfully optimizing systems and automating processes to enhance efficiency. Within three months, my expertise led to involvement in multiple projects, and in the following two months, I became the direct point of contact for clients, handling their queries and providing real-time solutions. I have also provided comprehensive user training and support, ensuring smooth adoption of solutions.
Additionally, I have developed custom reports and dashboards for actionable insights, demonstrating strong problem-solving and data analysis skills. I am proficient in delivering tailored solutions that meet specific business requirements.
Tools: SAP VIM, ABAP, Excel, OT Extraction, BCC/IC4S Archiving.

Jan 2024 - Jan 2025 | Banglore, India

Projects

      
 ZenBoard: Meeting Fatigue & Focus Analyzer 
        
        Helps you to increase productivity of working day. 
      
AccomplishmentsTools:  Tableau, Excel
Developed an interactive Tableau dashboard analyzing 500+ calendar events to detect employee fatigue
          patterns, leveraging 12+ custom metrics to surface burnout peaks, focus gaps, and optimal DND hours for
          smarter scheduling.

Delhi Metro 360
                  
                  It analyzes and optimizes the Delhi Metro system. 
                
AccomplishmentsTools:  Python, Pandas, Sklearn, Seaborn, Matplotlib, Power BI
Prediction consist of:
                  Passenger Flow Prediction, Train Frequency Optimization, Smart Fare Pricing and Predictive Maintenance.
Analysis consist of: 
                  Route & Stops Analysis & Visualization,Inbetween Trip Duraation, Number of trips in diffent parts of day, much more. 

Sales Data Analystics
        
        It analyzes and provide insighs related to sales for the organisation. 
      
AccomplishmentsTools: SQL, Power BI
The Analysis is conductied in three parts:
Product Data Analysis
Sales Data Analysis
Customer Data Analysis

Road Accident Analysis
        
        Dashboard is an interactive visualization created in Microsoft Excel. 
      
AccomplishmentsTools: Excel
Designed to provide insights into accident trends, casualties, and contributing factors.
It uses data-driven visuals to highlight key statistics, aiding in better understanding and decision-making regarding road safety.
The interactive nature of the dashboard allows users to explore different dimensions of the data.

HR Analytics Dashboard
        
        This is an interactive HR Dashboard created using Microsoft Excel. 
      
AccomplishmentsTools:Excel
The dashboard provides key HR insights like
Department Analysis : Top 5 departments by employee count.
Employee Status : Active vs. non-active employees.
Demographics : Marital status, gender diversity, and education levels.
Job & Salary Insights : Salary distribution, job categorization, and interactive filters by department and gender.

Life Expectency Prediction
        
        Statistical analysis of life expectancy factors.
      
AccomplishmentsTools:Python
Project Overview : Analyzes factors affecting life expectancy using WHO and UN data (2000-2015).
Dataset : Includes health and economic data from 193 countries.
Correlation Insights : Strong links between health expenditure, GDP, immunization, and mortality rates.
Outlier Detection : Identifies anomalies in mortality, immunization, GDP, and health factors.

Flight Delay Analysis
        
        Analyzed 5M+ flights, delays, cancellations, trends. 
      
AccomplishmentsTools: Power BI
Flight Volume:  Monthly and weekly trends visualized in bar charts.
Delays: Calculated flight delay and average delay
Cancellations: Analysed various cancellation reasons like weather, airline etc
Airline Reliability: Figured out most and least reliable flights
Dashboard: Visualizes trends, delays, and cancellation insights effectively.

Library Management System
        
        Project handle's book records, members, and more. 
      
AccomplishmentsTools: SQL
Features: 
Book Management
Member Managemen
Staff Management
Transactions
Fine Systems
Book Requests

Many more projects
        
        For other project which showcase my skills check out my Github repo.
      
AccomplishmentsTools: Python, SQL, Power BI ,Excel
My projects demonstrate a strong set of skills aligned with the data analyst role. Each project follows a structured approach, covering the entire process from data gathering and cleaning to analysis, visualization, and deriving meaningful insights. These insights highlight key trends that can drive real-world business decisions.