Type: User
💬 I am proficient in Excel VBA, Python, SQL, R, Tableau, Power BI, DAX
📫 How to reach me: [email protected]
📊 Some of my recent works:
| HR Analytics Dashboard | Playstore Dashboard |
|---|---|
| Pharmacy Dashboard | VBA Dashboard |
|---|---|
|
|
|
bike-sales-analysis
The project, executed in MS Excel, delivered a dynamic dashboard enhanced by VBA macros, featuring pivot tables, charts, and slicers showcasing key sales trends across various demographics and preferences.
codestorm-challenge
Used Python to solve 30 complex coding questions, spanning topics like data types, indexing, slicing, operators, built-in functions, conditionals, loops, object-oriented programming, and exception handling.
hr-analytics-dashboard
The project utilized Power BI to analyze CSV-based employee data, offering insights into performance and attrition, aimed at enhancing employee retention and satisfaction.
medical-inventory-optimization
The project, utilizing MySQL for data preprocessing and analysis, focuses on reducing bounce rates and increasing revenue in a healthcare organization by improving inventory management and addressing patient dissatisfaction.
monthly-sales-report-automation-with-vba
This VBA project automates Excel sales reports with pivot tables, charts, and PowerPoint integration.
play-store-app-review-analysis
The project analyzed Play Store app data using Python libraries like NumPy, Pandas, Seaborn, and Matplotlib, focusing on identifying key factors that influence app engagement and success.
power-bi-pharmacy-sales-dashboard
This is a Power BI dashboard integrated with a MySQL database, offers real-time analysis of pharmacy sales, and is optimized by fetching only essential data through parameterized queries for increased efficiency.
product-dissection-relational-database
Performed product dissection on the Swiggy Food Delivery App, designing the schema and establishing relationships between entities. I also used MySQL to create the database and tables, transforming my conceptual model into a practical ERD.
rohitpaul09
Config files for my GitHub profile.
tableau-playstore-data-analysis
The project involved data preprocessing in Python, and the creation of Tableau dashboards on app engagement, sentiment, and revenue, all integrated into a comprehensive Tableau story.
tableau-superstore-analysis
The project analyzes the Superstore sales dataset in Tableau, showcasing key insights through a variety of chart types, custom calculations, and interactive features for an in-depth exploration of data trends and patterns.
web-scraping-data-science-job-listings
The project used Python and BeautifulSoup to scrape job details from a portal, organized the data with pandas, and employed Matplotlib and Seaborn for visual analysis, offering insights into job market trends.
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
Django
The Web framework for perfectionists with deadlines.
Laravel
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft
Open source projects and samples from Microsoft.
Google
Google ❤️ Open Source for everyone.
Alibaba
Alibaba Open Source for everyone
D3
Data-Driven Documents codes.
Tencent
China tencent open source team.
