A pure PHP library for reading and writing spreadsheet files
-
Updated
May 29, 2024 - PHP
A pure PHP library for reading and writing spreadsheet files
Analysed data of Fashion Store and prepared advanced dashboard using MS Excel.
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 is a Analytics Project on Sales data of a Coffee Shop. Tool used for analytics is MS Excel, Power Query and Power BI desktop and Service.
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
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.
expss: Tables and Labels in R
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.
Awesome Chocolates Sales
Skills: Tableau, Python, Microsoft Excel, Exploratory Data Analysis (EDA)
Add a description, image, and links to the msexcel topic page so that developers can more easily learn about it.
To associate your repository with the msexcel topic, visit your repo's landing page and select "manage topics."