This repository contains all the code I use in my YouTube tutorials.
-
Updated
Mar 24, 2022 - Python
This repository contains all the code I use in my YouTube tutorials.
Tool for generating Word documents based on Excel spreadsheet
Netflix data analytics & dashboard
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.
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.
Process your transactions from etherscan (and other forks) into excel file for easier manipulation.
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.
A GUI application that can be used by a teacher to create report cards of students from an Excel sheet
End-to-End Data Analytics Project covering ETL (Python + Azurite), MySQL data modeling, and interactive Power BI dashboards. Features:
A complete end-to-end data analytics pipeline for unicorn startups, built for MAANG-style business decision-making. This project uses Python to clean and transform raw startup data, automates staging in Azurite cloud and MySQL, and delivers interactive, drill-through dashboards in Power BI.
Scraped and analyzed real-time election data to build interactive dashboards showcasing seat trends, vote share distribution, and postal ballot stats. The analysis uncovered insights on voting patterns, winning margins, and candidate forfeitures. Visual storytelling and timely data updates helped the project gain strong engagement on social media.
"End-to-end sentiment analysis pipeline for Amazon reviews leveraging Python (TextBlob), MySQL, and Power BI with cloud-ready architecture (Azure Blob Storage simulation)."
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."