Vrinda Store analysis and Dashboard using Advanced Excel

Excel Data Analytics

In this project, I will analyze and transform data, and create interactive visualizations, reports, and dashboards by using Microsoft Power BI.

Bike Sales Excel Dashboard Project: Analyzed and visualized sales data, cleaned datasets, and created interactive dashboards in Excel.

A repository where I keep all of my data cleaning samples/portfolio items.

This Repository consist of all the Jupyter Notebooks, Images and .CSV files of the tasks that were assigned during the Accenture Data Analytics Job Sim hosted on Forage

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

Developed an Excel-based dashboard to analyze sales performance, identify trends, and financial metrics for Vrinda Store's operations in 2022.

Se usó una base de datos llamada "2023 Data Scientists Salary" que contiene los salarios de los profesionales que se dedican a ser Científicos de datos y áreas similares, para crear un dashboard analizando los mismos..

FIFA World Cup Analysis Using Microsoft Excel

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.

Analyzed Data By Creating Interactive Dashboard Using MS Excel

UNCW BAN 501 This course introduces students to the field of prescriptive analytics. Students will learn how to develop and use modeling techniques used extensively in the business world. Both mathematical and spreadsheet skills in MS Excel are utilized for performing optimization, simulation, and decision analysis techniques.

Engineered Excel reports for sales analysis and Profit & Loss evaluation by country, year, month, and product

UNCW BAN 502 This course explores methods for model selection, parameter estimation, and validation. Focused on techniques and algorithms from the statistical and machine learning disciplines.