Planilha de Estudos para concurso publico feito no Excel varias fรณrmulas como: SE, SOMASE, PROCV, PROCH, CORRESP, SEERRO,, SUBTOTAL . Tambรฉm usado Macros e VBA
-
Updated
Mar 17, 2024
Planilha de Estudos para concurso publico feito no Excel varias fรณrmulas como: SE, SOMASE, PROCV, PROCH, CORRESP, SEERRO,, SUBTOTAL . Tambรฉm usado Macros e VBA
Data cleaning and insight generation using Kaggle Data Science Survey 2017-2021.
Dragonfly Analyzer is a tool that automatically compiles and generates statistical reports based on field observations of dragonflies. Co-developed with @lbrezgin.
This is excel analytics platform.
Interactive HR Recruitment Analytics Dashboard built in Excel to analyze hiring trends, evaluate candidate profiles, compare candidates, and estimate hiring probability using data-driven insights.
Streamlit app for courier and logistics analytics using Excel and Google Sheets. Supports month-wise packet tracking, sender and mode analysis, and payment reporting with drill-down insights.
Excel-based crash incident analysis (2019โ2023) with data cleaning, pivot tables, visualizations, and an interactive dashboard.
This is my first Excel project: Vrinda Store Data.
The Crowdfunding-Analysis with Excel project analyzes 1,000 crowdfunding projects and concludes that the US, theater, film and video, and music industries have the most campaigns, with a success rate of 50-60%. The dataset lacks some key data points such as gender and age of backers and distribution of campaigns across different US states.
A Streamlit-based tool for analyzing financial documents (CSV, Excel, PDF) with automated KPI extraction, statistical analysis, and interactive visualizations to help professionals gain quick insights.
"Retail Sales Analysis & Inventory Risk Modeling using MS Excel. Features advanced Pivot Tables, Multiple Linear "Regression and Correlation Analysis to optimize boutique revenue and markdown strategies."
Deloitte Australia Data Analytics Job Simulation (Forage) โ Gender pay equality analysis using Excel classification logic and Tableau dashboard visualization. Includes forensic data assessment and business insights.
This project includes Data Analysis using excel.
This project presents an analytical study of customer churn behavior using Microsoft Excel. The main objective is to identify patterns and drivers behind customer churn and provide actionable insights to improve customer retention and profitability. The analysis is performed entirely in Microsoft Excell.
Power BI Dashboard for analyzing Crop Residue Management adoption and resource usage trends.
Analyzed a Starbucks dataset to evaluate marketing promotions using A/B Testing and Statistical Significance. I calculated P-values and "Lift" in Excel to determine offer effectiveness, then built Tableau dashboards to visualize customer conversion. This project demonstrates data-driven decision-making to optimize marketing ROI.
A data-driven pricing optimization project using Excel and Python to increase revenue while adhering to business constraints.
Excel Dashboard to analyze data of a hotel over the past three years.
๐ Raw Sales Data โ ๐งน Clean & Transform โ ๐ Model Relationships โ ๐งฎ Build KPIs โ ๐ Visualize Dashboard โ ๐ฏ Analyze Trends โ ๐ก Generate Insights โ ๐ Drive Business Decisions
Add a description, image, and links to the excel-analysis topic page so that developers can more easily learn about it.
To associate your repository with the excel-analysis topic, visit your repo's landing page and select "manage topics."