Greetings! I'm Yash Bhardwaj, a dedicated data analyst hailing from the bustling city of New Delhi, India. My passion lies in the intricate world of data, where I excel at unraveling its mysteries to extract valuable insights.
With a robust skill set encompassing Excel, SQL, Python, and advanced visualization tools such as Power BI, I possess a knack for transforming raw data into compelling narratives. Whether it's cleaning messy datasets, conducting in-depth analyses, or crafting visually stunning dashboards, I thrive on every aspect of the data journey.
Having honed my craft through hands-on experience and academic rigor, I bring a blend of technical expertise and creative problem-solving to the table. My goal? To empower organizations with the knowledge they need to make informed decisions and drive strategic growth.
Beyond my professional pursuits, I'm a lifelong learner with an insatiable curiosity for all things data-related. I'm constantly seeking new challenges and opportunities to expand my skill set and stay at the forefront of industry trends.
If you're on the lookout for a passionate data enthusiast who can elevate your analytics game, look no further! Let's collaborate and embark on a data-driven journey together.
0 + Projects completed
Hello! I'm a skilled data analyst proficient in Excel, SQL, Python, and visualization tools like Power BI. From cleaning messy datasets to crafting insightful reports, I'm passionate about transforming data into actionable insights. Let's work together to unlock the potential of your data!
Applied sophisticated statistical techniques to identify and rectify missing data points, improving dataset completeness by 30% and enabling more reliable and robust data-driven decision-making. Identified, analyzed, and managed missing data points, applying statistical techniques to fill in gaps and enhance dataset integrity. Created detailed and interactive visualizations using Power BI to present data trends and insights effectively.
Conducted extensive data cleaning and preprocessing, ensuring data quality and consistency. Identified and handled null values by employing statistical methods to impute missing data. Developed and maintained interactive and insightful dashboards using Power BI to facilitate data-driven decision-making. Collaborated with various departments to understand data needs and deliver tailored analytical solutions.
CGPA : 8.9
CBSE : 86
Data Source: Obtained a dataset from Kaggle that includes a variety of metrics related to store sales, customer demographics, and product preferences. Data Analysis: Employed Excel for in-depth data analysis to identify key trends and patterns in sales, customer behavior, and product performance. Visualization: Developed detailed visualizations using Excel to effectively present the findings.
Data Source: Acquired dataset from Kaggle, containing various metrics related to a cafe's sales, customer demographics, and product preferences. Data Analysis: Utilized Excel and Python (Pandas) to conduct thorough data analysis, identifying key trends and patterns in sales, customer behavior, and product performance. Visualization: Created comprehensive visualizations using Excel and Matplotlib to present findings clearly and effectively.
Data Cleaning and Transformation: Employed Power Query Editor to clean, transform, and prepare the data for detailed analysis. Data Analysis: Used Power BI to analyze key performance metrics such as runs scored, average, strike rate, and match-winning contributions. Visualization: Created dynamic and interactive dashboards to illustrate career highlights, performance trends over time, and comparisons across different formats (Test, ODI, T20). Insights: Analyzed the data to identify strengths, areas for improvement, and patterns that contributed to his success.
Below are the details to reach out to me!
New Delhi, India