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

Excel Data Analytics

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.

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.

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

Analyzing Bike Sales Data Using Pivot Tables + Creating A Dashboard

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.

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.

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.

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