This analysis is for the Google Data Analytics Capstone Project (Cyclistic).

This is my first Bi-weekly assessment during the Nsonye Cohort 3. The instructions and dataset was provided by the course tutor, Mr. Gbolahan Adebayo. The skills that was taught and applied to this assessment was Pivot tables, Inserting calculated fields, Conditional Formatting, Filters, Sorting, Grouping, I also checking the dataset for duplicates

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

This repository hosts the files and resources for my Excel dashboard project, showcasing my expertise in data visualization, charting, and pivot table usage. The interactive dashboard is designed to provide a comprehensive view of key insights derived from complex datasets, making it an essential tool for data-driven decision-making and analysis.

Excel bike sale project with pivot tables and Dashboard showing Sales performance per region, sale trend overtime, Sales contribution margin analysis and total quantity sold per product type.

My Capstone project repository, the culmination of my academic journey, tackles best areas to purchase a home in the Houston city limits. Leveraging Excel, Python, and SQL, it showcases my skills in data cleaning, wrangling and execution.

Portofolio ini berisikan salah satu proyek dashboard dengan menggunakan Microsoft Excel mengenai distribusi jumlah siswa sekolah dasar berdasarkan status tahun ajaran 2018/2019 s.d 2021/2022 di Provinsi Jawa Barat.

"Exploring laptop data through cleaning, analysis, and visualization."

Excel Data Analytics

This analysis is for the Google Data Analytics Capstone Project (Bellabeat).

Through a supervised project on bike sales, I had the opportunity to collaborate with the renowned YouTuber, @AlexTheAnalyst, to enhance my proficiency in data analysis using MS Excel.

This repository contains a comprehensive sales analysis dashboard for DMart's 2024 sales data, created using Microsoft Excel. The dashboard provides insights into category-wise, sub-category-wise, ShipMode-wise, segment-wise, and region-wise sales, with interactive slicers for filtering data by state, sub-category, and a ship date timeline.

Analyzing Bike Sales Data Using Pivot Tables + Creating A Dashboard