You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The HR-Analytics Dashboard uses Power Query, DAX Query and Power BI to analyze employee attendance data and provide insights into attendance patterns. The data is cleaned and transformed using Power Query and DAX Query. A dashboard is created with visualizations, measures, filters, and slicers to help HR identify areas for improvement.
The tool is macro based program written in VBA and implemented in MS Excel office application. It's intend for back office corporate operations when it is necessary to allocate people and plan work in a large corporate teams.
The Project is centered around the critical analysis of a Bank Loan Data. Bank loans are a crucial financial tool that enables individuals and businesses to achieve their goals and manage financial needs. However, it's essential for borrowers to understand the terms, costs, and responsibilities associated with loans to make financial decisions
This project analyzes sales data for Adventure Works, a bike company. Perform analysis by uncovering trends, customer behavior, and product profitability to optimize sales and marketing strategies.
This project leverages Microsoft Excel to create sales and finance reports. The sales reports analyze customer performance and market trends, while the finance reports focus on Profit and Loss (P&L) by Fiscal Year, Months, and Markets. Using Excel skills like ETL and Power Pivot, these reports assist in strategic business planning.
This project automates updating physical stock info for Semi-Finished Goods (SFG) in Excel. It eliminates manual entry for new batch data and stock updates, saving time and boosting efficiency.
This project aims to streamline the process of analyzing variations between two production plan roll-out files. It addresses the challenges of working with large datasets, performing VLOOKUP operations across multiple files to calculate differences between production week plans.
This repository contains my solutions and project work for the ACCENTURE DATA ANALYTICS AND VISUALIZATION JOB SIMULATION Virtual internship offered by Forage.
Sales Insights are data driven insights, that can help sales teams improve their performance. They can be used to identify trends, opportunities, and challenges, and to develop strategies for closing deals
Automate repetitive tasks and streamline workflows in Microsoft Excel with this project. Enhance efficiency, accuracy, and productivity through custom macros, formulas, and VBA scripting solutions.
Automated Physical Stock Integration simplifies stock management by automating data integration between batch and physical stock records. This Python-based solution enhances efficiency and accuracy, saving time in resource management. Streamline your processes with this easy-to-use automation tool.
In this project, I worked with Microsoft Excel and analyzed one year of sales data for Vrinda store. I started by cleaning and pre-processing the data. Then, I created various pivot charts and a dashboard to provide clear insights and suggestions for improving sales in the upcoming year.