Excel/Sheets Analysis

Management Information Systems Final Analysis Project.mp4

MIS Final Project

This practice was a graded assignment from college as part of my Management Information Systems course during my sophomore year, which ended with an A grade. The entire course covered Excel, SQL, Tableau, and dashboards.

The purpose was to analyze the given real estate data and make corresponding dashboards in Excel, Tableau, and (a makeshift one in) SQL. I had to work with another classmate to work on it. We had 2-3 weeks to complete it before the final exam.

The entire project was divided into four milestones. They included cleaning and manipulating datasets 1-3 and 4-7, then using visualizations to analyze the data and appropriately placing the visualizations in dashboards.

BITS Case Study Workshop.pdf

Wacky Wallets Recommendations

I did this at a technology workshop at Rutgers BITS (Business Information Technology Society) in my sophomore year. It was a less intense Excel-focused data analytics case study.

This piece was to find the demographic Wacky Wallets - a new leather alternative product selling company - should focus on to expand its business. Based on the insights, we had to make our recommendations, too. I worked with two others - Ria and Akshar - to draw conclusions and present them. The data was from BITS.

The data given for it is below.

We had ~30 minutes to work on it. I cleaned it up so we could add it to our portfolios.

Wacky Wallets DATASET

Strategies for Cyclistic Memberships.pptx

Cyclistic - Memberships Marketing Strategies

This is my first practice. It was a case study to wrap up my Google Data Analytics Certification Course. The course offered two tracks. This was the first of the two options of the first track - to analyze data already given.

This particular practice was to produce marketing strategies for a fictional bike-sharing company, Cyclistic, based on 38 months (from April 2020) worth of company data. The presentation was made inferring that it was made by a junior analyst within Cyclistic's Marketing Analytics Team.

I have an affinity for marketing from this case study and considered doing more similar projects.

*There are glitches in the preview here, so downloading it and viewing it on Microsoft PowerPoint would be better*

Page updated

Google Sites

Report abuse