This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:

No description provided.

Assessed historical shipping data for a shipping company selling products and shipping them to its customers' destinations to determine future shipping strategies.

Data Analysis of a Superstore using MS Excel with Visualization

Advanced MS Excel

Developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.

Created an dashboard on excel using e-commerce datasets

Statistical Analysis using Excel Spreadsheets

An analysis of Amazon Stock Data from December 2020 to November 2021 that provides information regarding increase/decrease in Amazon's value on any given day.

'Vrinda Store' Data Analysis Project using Excel

Developed as a way to keep track of my expenses, allowing me to make informed and smart money decisions based on my complete financial picture.

This repository serves as a showcase of the skills I've acquired through Datacamp's "Data Analysis in Excel" course.

A tool to monitor expenses, helping to make data-driven and intelligent financial decisions based on a comprehensive overview of my finances.

Data-driven analysis of inventory management and supply chain efficiency (2015-2018). Identifies key trends in product classes, sales performance, and shipping. Provides actionable insights to optimize inventory levels, reduce costs, and improve customer satisfaction in a complex supply chain environment.

Advanced MS Excel

Excel

Utilizing Excel and statistics, including t-tests and z-tests, in the analysis of housing prices to determine the most influential factors driving home prices.

No description provided.

An interactive Excel-based dashboard for analyzing employee attrition trends, workforce demographics, and key performance indicators. The project includes raw data processing, pivot tables, and visualizations to provide actionable insights into employee retention.

Personal data analysis project combining insider threat detection, cybersecurity, and exploratory data analytics. Built for portfolio showcase and practical skills demonstration.

The Coffee Orders and Sales Dashboard uses Excel to visualize key data, including sales by country, top customers, roast type, and order date, helping optimize operations and boost sales through data-driven insights.

This project showcases a comprehensive Customer Detail Dashboard built using Excel. It visualizes key metrics and insights from transactional data (2020-2022), providing an interactive interface for analyzing customer behavior, sales performance, and profitability across regions and demographics.

In this project, I conducted a comprehensive data analysis on the dataset from Vrinda Clothing Store, which included developing multiple interactive dashboards in MS Excel. The project encompassed key processes such as data cleaning, data processing, analysis, and visualization, providing a detailed view of customer and sales insights.

The HR Insight Dashboard provides a dynamic overview of an organization's workforce. It visualizes key metrics such as department distribution, absences, and educational credentials, enabling HR professionals to make data-driven decisions and develop proactive strategies.

Hello! I am Ufuk. This repository contains selected projects in **Excel, SQL, Power BI, and Tableau**, showcasing real-world data analysis scenarios and my ongoing work on data-related projects.

Analysis of consumer complaints in the financial services sector, leveraging data from 2013-2016. This project examines customer satisfaction, resolution times, and dispute rates across various companies and products. It provides actionable insights and recommendations to improve complaint handling processes, enhance customer satisfaction.

Conducted extensive analysis of WeTalk's 2020 Q1 dataset using Google Sheets. Leveraged pivot charts to extract actionable insights, meticulously crafting a comprehensive dashboard for detailed evaluation of agent performance and operational trends in the support center.

Preforming analysis on Kickstarter data to uncover trends and emulate successful campaigns

Dashboard interactivo en Excel para análisis de ventas de productos tecnológicos (2021-2024). Visualización de KPIs, tendencias mensuales, top 10 productos y márgenes de ganancia.

No description provided.