An open API service providing repository metadata for many open source software ecosystems.

GitHub topics: advanced-excel

Wilson-Maho/Excel-DashBoard

Begginer Dash Board using online Data Set In Excel

Size: 8.94 MB - Last synced at: about 16 hours ago - Pushed at: about 17 hours ago - Stars: 0 - Forks: 0

ddihora1604/Advanced_Business_Analytics_on_World_Bank_Global_Financial_Inclusion_Data_2021

Bridging the Gaps in Financial Inclusion: Understanding the Cash-Credit Paradox, Divide between Cash and Digital Payments, and Financial Resilience.

Language: Jupyter Notebook - Size: 27 MB - Last synced at: about 2 months ago - Pushed at: about 2 months ago - Stars: 0 - Forks: 0

Prakshi-23/Bank-Application-

# Banking Application (GUI) A desktop-based Banking Application built with Python and CustomTkinter, featuring account management, transactions, and customer verification.

Language: Python - Size: 930 KB - Last synced at: about 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

SatyaCoder29/CRM-Analytics-Power-BI

CRM Analytics Dashboard – An interactive dashboard using Tableau, SQL, and Salesforce CRM Analytics (CRMA) to analyze sales performance, customer segmentation, and churn prediction. Features automated ETL pipelines, predictive analytics, and real-time insights for data-driven decision-making. πŸš€πŸ“Š

Size: 17.8 MB - Last synced at: 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

Prakshi-23/Airbnb-Dashboard-using-Excel

🏑 Airbnb Data Analysis Analyzed Airbnb listings to uncover pricing trends, customer preferences, and top-performing hosts. Identified revenue opportunities through location-based pricing and booking patterns. Provided data-driven insights for optimization.

Size: 2.01 MB - Last synced at: about 2 months ago - Pushed at: 2 months ago - Stars: 0 - Forks: 0

patriciavalentine/GYM-MEMBERSHIP-EXPLORATORY-DATA-ANALYSIS

This project analyzes a Gym Membership Dataset using Excel to uncover insights into member behavior and gym usage patterns. The analysis is visualized through charts and a dashboard.

Size: 576 KB - Last synced at: 11 days ago - Pushed at: 8 months ago - Stars: 1 - Forks: 0

Shivam5509/Power-BI-project

Expert in creating interactive dashboards and reports using Power BI, utilizing 10+ visual tools like cards, slicers, and charts. Skilled in cleaning and transforming large datasets with Power Query Editor. Proficient in advanced DAX functions (SUMX, FILTER, CALCULATE) to derive insights and drive data-driven decisions.

Size: 38.3 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

mayankyadav23/Superstore-Retail-Performance-Analysis

An interactive Power BI & Excel dashboard uncovering key insights on sales, customer behavior, and product performance. πŸ”₯

Size: 2.19 MB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 1 - Forks: 0

Rihana5rose/KultureHire-Projects

This repository explores the career aspirations of Generation Z using data analytics. It includes insights on industry preferences, work models, skill development trends, and salary expectations, backed by surveys and research data. πŸš€πŸ“Š

Size: 0 Bytes - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Keshab5300/Audible-Data-Cleaning---Power-Query-Editor

This repository features a project for analyzing Audible data, utilizing Power Query Editor for cleaning, formatting, and standardizing the dataset. It demonstrates data preparation techniques to ensure consistency and readiness for insightful analysis.

Size: 16.2 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

Keshab5300/Myntra-data-Analysis

This project involves analyzing Myntra's apparel dataset to gain insights into pricing, discounts, ratings, and available sizes. Through data cleaning, preparation, and analysis using Excel functions like `AVERAGEIF`, `COUNTIF`, `XLOOKUP`, and `INDEX & MATCH`, the project provides valuable insights that support strategic decision-making.

Size: 28 MB - Last synced at: 3 months ago - Pushed at: 3 months ago - Stars: 0 - Forks: 0

mayankyadav23/HR-Workforce-Analysis

A deep dive into employee attrition, salary trends, and workforce demographics using **Power BI & Excel**. πŸ”πŸ“‰ Gain key insights to enhance retention strategies, streamline hiring, and improve workforce planning. πŸ“Šβœ¨

Size: 2.8 MB - Last synced at: 3 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

Prakshi-23/Bank-App-management-project-v1-

A Bank App GUI made using Python (libraries used tkinter, customtkinter, pandas etc.) and the data is stored in backend in SQL Database and usind pandas stored in excel file as well. This excel file is further used to create a dashboard in Power BI and also used in machine learning alogorithm.

Language: Jupyter Notebook - Size: 1.26 MB - Last synced at: about 2 months ago - Pushed at: 4 months ago - Stars: 0 - Forks: 0

crazy-dot/Bank-Laon-Case-Study

Used Exploratory Data Analysis (EDA) to analyse patterns in the bank dataset. The main was to analyse the potential defaulters list and identify the cause for payment default. Tried to understand one of the risk assessment used by the banks and have duplicated the same for this project.

Size: 2.41 MB - Last synced at: 2 months ago - Pushed at: 5 months ago - Stars: 0 - Forks: 0

as16082023/Employee-Survey-Analysis

This project analyzes survey data from 1,500 employees to assess job satisfaction and engagement. Insights are summarized to help HR improve workplace culture and retention.

Size: 1.03 MB - Last synced at: 2 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

Rakesh3596/Zomato-Pizza-Sales-Analysis

Zomato Pizza Sales Analysis

Size: 1.13 MB - Last synced at: 3 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

tanjotveer-98/Advanced_Excel_Project

A Microsoft excel project to create a dashboard to analyze and visualize coffee sales worldwide using information about orders, products and customers.

Size: 414 KB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 1 - Forks: 0

as16082023/Global-Electronics-Retailer

Analyzed Maven Electronics' performance data to identify factors driving revenue decline since 2020.

Size: 1.54 MB - Last synced at: 2 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

as16082023/Manufacturing-Downtime-Analysis

In the Maven Analytics data challenge, analyzed manufacturing downtime for a soda production company using Excel, identifying key issues and root causes of delays. Insights were shared through tables, charts, and a concise report with actionable recommendations.

Size: 625 KB - Last synced at: 2 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

RishabhJain111/Bank_Loan_Report_Excel_Project

Description: A comprehensive Excel-based Bank Loan Report Dashboard designed to analyze and monitor key lending metrics for data-driven decision-making. The project includes interactive dashboards and visualizations for tracking Total Loan Applications, Funded Amounts, Amount Received, Average Interest Rates, and Good vs. Bad Loan KPIs.

Size: 8.86 MB - Last synced at: 6 months ago - Pushed at: 6 months ago - Stars: 0 - Forks: 0

dannykyungh/Data-Analytics-Portfolio

This is a repository that I have created to showcase skills, share projects and track my progress in Data Analytics / Data Science related topics.

Language: Jupyter Notebook - Size: 224 KB - Last synced at: 9 days ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

mayankyadav23/Career-Aspirations-of-GenZ

Explore a collection of interactive dashboards developed during my internship at KultureHire! This repository includes visual insights into Learning Aspirations, Manager Aspirations, and Mission Aspirations, designed to help stakeholders make informed decisions. πŸŒŸπŸ“ˆ

Size: 45.5 MB - Last synced at: 3 months ago - Pushed at: 7 months ago - Stars: 0 - Forks: 0

mayankyadav23/Air-BNB-Data-Analysis

Data analysis and insights from NYC Airbnb listings, focusing on key metrics such as host performance, neighborhood trends, pricing, and customer reviews. Comprehensive documentation of ETL processes and analytical methodologies is provided. Perfect for understanding Airbnb dynamics and decision-making in the NYC market.

Size: 9.03 MB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 1 - Forks: 0

AhanaPodder97/Workforce_Analytics

The project utilized Tableau, Excel and MySQL to analyze CSV-based employee data, offering insights into performance and attrition, aimed at enhancing employee retention and satisfaction.

Size: 101 KB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Bhushan148/Bank-Loan-Report-Dashboard-Excel

The πŸ’Ό Bank Loan Report Dashboard is a fully automated Excel πŸ“Š dashboard designed to analyze and visualize key metrics of a bank's loan portfolio. It provides πŸ“ˆ insights into loan applications, funded amounts, repayments, interest rates, and borrower profiles, helping banks make data-driven decisions with ease. 🏦✨

Size: 21.3 MB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Bhushan148/Sales-Dashboard-Excel

This project showcases a comprehensive Sales Dashboard designed to provide insightful visualizations and data-driven insights into sales performance across different time frames and categories. 🌟 Inspired by a YouTube tutorial, the project utilizes a combination of PowerPoint and Excel to create a visually appealing and interactive dashboard. πŸ–₯️✨

Size: 1.21 MB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Bhushan148/Forecasting-in-Excel

This project leverages Excel πŸ“Š to forecast YouTube views πŸ“ˆ for the next 7 days using three methods: FORECAST Function πŸ“‰ Graph Trendlines πŸ“ˆ Forecast Sheet Tool πŸ“… By comparing these methods, the project aims to identify the most accurate forecasting technique 🎯 and enhance predictive accuracy πŸ” for future view counts.

Size: 168 KB - Last synced at: 5 days ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

Bhushan148/Data-Entry-Form-Excel

This project involves creating a dynamic registration form in Excel, featuring dependent dropdown lists πŸ“‹, functional macros βš™οΈ, and protected sheets πŸ”’. The goal is to streamline data collection for meetings, ensuring ease of use and data integrity. πŸŒŸπŸ“Š

Size: 145 KB - Last synced at: 3 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

5ifar/AtliQHardware_Sales_and_Finance_Analytics

Portfolio Project: Analyzing AtliQ Hardware's Sales & Financial Performance from 2019 to 2021 using Excel

Size: 9.27 MB - Last synced at: 9 months ago - Pushed at: 9 months ago - Stars: 0 - Forks: 0

CodeNova-Kumar/High_Cloud_airlines

Data Analyst Project using Advanced Excel, SQL, Power BI, Tableau Dashboard

Size: 18.1 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

grgadekar/Excel-Sales-Analysis-And-Finance-Analysis

This project involves creating comprehensive Sales and Finance Reports using data provided by AtliQ Hardware. The objective is to empower businesses to monitor and evaluate their sales activities and financial performance, supporting informed decision-making and stakeholder communication.

Size: 2.79 MB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

yashisaxena111/Excel-Finance-Ananlytics

The goal of this task is to create two reports, specifically named 'P&L Statements by Market' and 'P&L Statements by Fiscal year'

Size: 573 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

yashisaxena111/Excel-Sales-Analytiics

The objective of this task is to generate reports that provide answers to the following business inquiries: - What are the top 10 products based on the percentage increase in their net sales from 2020 to 2021? - Generate a "Division" report to present the net sales data for 2020 and 2021, along with the growth percentage.

Size: 306 KB - Last synced at: 10 months ago - Pushed at: 10 months ago - Stars: 0 - Forks: 0

NakulSachdeva/Automotive-Sales-Analytics-Dashboard

An advanced dashboard using Power BI & Advanced Excel, analyzing Kaggle’s automotive dataset. Features KPIs, dynamic visualizations for sales trends, interactive filters, and geographic mapping. Enables strategic insights and decision-making in automotive sales.

Size: 874 KB - Last synced at: 11 months ago - Pushed at: 12 months ago - Stars: 0 - Forks: 0

Nem-tat/GAMECO-s-2017-MARKET-PLAN-BUDGETING

This repository contains the comprehensive project files for GAMECO’s 2017 Market Plan Budgeting, developed as part of the CareerFoundry Data Analytics Program. The project focuses on analyzing and optimizing the marketing budget to maximize return on investment (ROI) and support strategic decision-making.

Size: 31.2 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

muskansawant9/excel-analysis

This repository contains my data analysis projects for advanced excel

Size: 3.85 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

ShubhamBhardwaj19/Bike-Buyer-Dashboard-using-Excel

Size: 184 KB - Last synced at: about 1 year ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

krathore97/EXCEL_Store_Data_Analysisi

Store analysis and Dashboard using Advanced Excel

Size: 5.21 MB - Last synced at: about 1 year ago - Pushed at: about 1 year ago - Stars: 0 - Forks: 0

Rajesh-Sanikommu/Google_Data_Analytics_Capstone_Project

Google Data Analytics Capstone Project

Language: R - Size: 13.7 KB - Last synced at: about 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Jampana-Jagadeesh/Ecommerce-Sales-Dashboard-By-using-POWER-BI

Ecommerce Sales Dashboard By using POWER BI (DATA ANALYTICS)

Size: 186 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 2 - Forks: 0

rishabh1882/Advance-Excel

Explore advanced Excel techniques, from powerful data analysis and dynamic formulas, in this comprehensive repository for elevating your spreadsheet skills."

Size: 284 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

MSATYARAJ/AVIATION-Project

Aviation Project (Flight Performance Analysis)

Language: Jupyter Notebook - Size: 36.6 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

ankitpal17/Vrinda-Store-Sales-Analysis

Analysis using Excel

Size: 8.4 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

ankitpal17/Chocolate-Sales-Analysis

Chocolate Sales Analysis using Excel

Size: 142 KB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

ybg345/data-analysis-viz-excel

I have completed some MS Excel Course. This repository contains all the excel files (practice and exercises solutions by me) which were provided as Homework's or as hands on practice in course section.

Language: HTML - Size: 11 MB - Last synced at: over 1 year ago - Pushed at: over 5 years ago - Stars: 12 - Forks: 10

chahat-7/Sales-Analysis-Dashboard-Excel

Conducted in-depth data analysis on E-commerce Sales Data to gain some meaningful insights on Products' Sales for each region and segment.

Size: 3.86 MB - Last synced at: over 1 year ago - Pushed at: over 1 year ago - Stars: 0 - Forks: 0

Vishakha-D2/Project4-P-L

Analysis of Dataset in Excel using various advanced features to create various reports.

Size: 25 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

Vishakha-D2/Project3-Movies_Data_analysis

Analysis of Movies Dataset In Excel using various advanced features.

Size: 971 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

aditipohekar/Movie-Dataset-Analysis

Movie Data Analysis using Advanced Excel

Size: 291 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

aditipohekar/Sales-Analysis-Report

Sales Data Analysis using Advanced Excel

Size: 5.99 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

PiyushG0999/KPMG-Data-Analytics-Project

Analysis of Company data to optimise marketing strategy and promote growth using Excel, Powerpoint & Tableau

Size: 0 Bytes - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

PiyushG0999/IMDB-Movie-Analysis

Advanced MS Excel

Size: 2.7 MB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

PiyushG0999/Hiring-Process-Analytics

Statistics Using Excel

Size: 379 KB - Last synced at: almost 2 years ago - Pushed at: almost 2 years ago - Stars: 0 - Forks: 0

Shri3131/iNeuron_Full_Stack_Data_Analyst_2.0_Assignments

Ineuron_FSDA_2.0_Course_Assignments

Language: Jupyter Notebook - Size: 4.88 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

krichmond19/PortfolioProjects

Excel, SQL, Python, and ML projects

Size: 28.3 MB - Last synced at: about 2 years ago - Pushed at: about 3 years ago - Stars: 1 - Forks: 0

shreshthvashisht/ABC-Call-Volume-Trend-Analysis

Customer Experience Analysis

Size: 11.4 MB - Last synced at: 4 months ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

shreshthvashisht/XYZ-Ads-Airing-Report_Analysis

Ad data analysis using Advanced Excel

Size: 840 KB - Last synced at: 4 months ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

shreshthvashisht/Hiring-Process-Analytics

Statistics Using Excel

Size: 80.1 KB - Last synced at: 4 months ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

zjxte/VBA-Functions

excel vba's

Size: 18.6 KB - Last synced at: 6 months ago - Pushed at: about 2 years ago - Stars: 3 - Forks: 2

BalaTuty/ExcelProjects

You can find all the Excel Projects that I have worked on in here. Thanks for viewing

Size: 7.36 MB - Last synced at: 3 months ago - Pushed at: over 2 years ago - Stars: 1 - Forks: 0

anu2393/anupriya.github.io

Learn Code Upload Repeat

Language: Jupyter Notebook - Size: 8.06 MB - Last synced at: about 2 years ago - Pushed at: about 2 years ago - Stars: 0 - Forks: 0

manishkr1754/SuperStore_Sales_Dashboard_Excel

Super Store Sales Analytics using Excel

Size: 3.1 MB - Last synced at: 2 months ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

xiaojie-qian/House-and-Urban-development

Housing value predictive model (Using US official datasets to build predictive model by using excel)

Size: 168 MB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

BasseyIsrael/Employee-Credential-Management-System

This project provides a system for keeping accurate track of the credentials attached to an employee in a man-power driven service providing organization. This system ensures the most suitable employees are always called up for job assignments.

Size: 2.38 MB - Last synced at: over 2 years ago - Pushed at: over 2 years ago - Stars: 0 - Forks: 0

xiaojie-qian/Data_Analysis_in_Excel

Duke University project: Data analysis in Excel (statistical analysis)

Language: Roff - Size: 885 KB - Last synced at: over 2 years ago - Pushed at: about 3 years ago - Stars: 0 - Forks: 0

zobairhas/kickstarter_analysis

Performing analysis on Kickstarter data to uncover trends.

Size: 3.7 MB - Last synced at: over 2 years ago - Pushed at: over 3 years ago - Stars: 0 - Forks: 0

kellyblumhagen/excel-kickstart-my-chart

Uncover market trends and determine commonalities for successful campaigns by transforming and analyzing data from over four thousand past Kickstarter projects.

Size: 5 MB - Last synced at: about 2 years ago - Pushed at: over 5 years ago - Stars: 0 - Forks: 0

Related Keywords
advanced-excel 67 data-visualization 21 excel 20 data-analysis 20 pivot-tables 19 sql 11 data-cleaning 8 python 8 tableau 7 power-query 7 powerbi 6 power-bi 6 data-analytics 6 dashboard 5 statistics 4 data-science 4 pandas 4 mysql 4 business-intelligence 3 power-query-editor 3 eda 3 business-analytics 2 xlookup 2 power-pivot 2 data-collection 2 data-transformation 2 excel-dashboard 2 numpy 2 data-visualisation 2 data-modeling 2 vlookup 2 excel-vba 2 hr-analytics 2 msexcel 2 data-mining 2 interactive-visualizations 2 exploratory-data-analysis 2 graphs 2 machine-learning 2 sheet-protection 2 data-preprocessing 2 customtkinter 2 tkinter 2 tkinter-gui 2 extract-transform-load 1 charts 1 dax-expression 1 data-modelling 1 geographic-maps 1 powerbi-report 1 kaggle 1 report 1 kpis 1 mtd 1 dax-measures 1 dashbaord 1 spreadsheet 1 sales-analysis 1 exceltips 1 exceltemplates 1 r- 1 sales-trends 1 time-series-analysis 1 visualization 1 ytd 1 microsoft-powerpoint 1 possibility 1 gaussian 1 entropy 1 confusion-matrix 1 binaryclassification 1 arrayfunctions 1 hr-management-system 1 t-testing 1 reallifeproject 1 predictive-modeling 1 linear-regression-models 1 descriptive-statistics 1 swot-analysis 1 ranking 1 excel-visualizations 1 tableau-desktop 1 python-3 1 mysql-workbench 1 jupyter-notebook 1 formulas 1 dashboards 1 vba-excel 1 ad-airing-analysis 1 experience-analytics 1 call-volume-trend 1 call-centre-analysis 1 pandas-python 1 snowflake 1 data-analysis-excel 1 reports 1 powerpoint 1 email-insights 1 insights 1 hr-workforce 1