Excel Data Analytics
-
Updated
Sep 18, 2023
Excel Data Analytics
This repository contains my Week 1 Retail Sales Excel Analysis completed during my Data Analyst Internship at Logic Stack. The project focuses on data cleaning, quality checks, Excel functions, sorting, filtering, charts and basic sales analysis using a retail sales dataset. It showcases my practical Excel and data analysis skills.
Beverage sales analysis project for the U.S.A market, built with Excel & Power BI. Features data transformation, DAX measures, KPI dashboards, maps, top/bottom states insights, and advanced profitability metrics. Designed to visualize performance trends, enhance decision-making, & demonstrate analytical storytelling through interactive dashboards.
Exploratory Analysis - Data Preparation, Data Cleaning, and EDA using Excel, Data Visualization using Tableau Dashboard
Created two different dashboards of NHS UK Healthcare using the data of 2022- 2023
Bank customer churn analysis (10k accounts) using Power Query and Power BI. Identifies a 20.38% churn rate ($185.68M lost) driven by Germany (32.44%), ages 51–60 (56.21%), and 3+ product holders (82%–100%).
Hands-on learning and practice for data preparation and cleaning in Excel, including data transformation, formatting, cleaning, and preparing datasets for analysis.
To associate your repository with the excel-data-cleaning topic, visit your repo's landing page and select "manage topics."