Skip to main content

Data Visualization - Power BI Competition

In my Fall 2017 semester, I took Data Visualization. For the final group project in that class, we were tasked with selecting a location in the United States that tech companies are looking to locate to. From there, our group would find data sets to create an argument for why a company should move there. After presenting to the professor, three groups from all the sections were selected to participate in the competition. One additional group outside the class would also be selected to participate. The top three placements receive a cash prize: 1st gets $3000, 2nd gets $1500, and 3rd gets $500 (awarded to the group, so split among the group members). The judge and sponsor was a representative from Power BI!

Our group chose Atlanta, Georgia as our location. Much to the professor's dismay, no one picked Dallas, Texas as everyone thought it would be too obvious of a choice with lots of groups picking it.

For our data, we chose airport traffic, cost of living with median rent and housing price, bachelor's degree concentrations, and commuter transportation. With these factors in mind, we found various data sets and worked with them through various visualization tools such as ggplot2 in R Studio, Power BI, and d3 (web-based visualizations).

Linked here is the Power Point we made (Google Drive):
https://drive.google.com/file/d/1J5uwMXcrKyYcJGqruUtLm0Te7vA-o488/view?usp=sharing

My group ended up getting 2nd place at the competition! We were all super proud, and it took a lot of hard work to make it look as nice as it is! Despite our efforts, 1st place did go above and beyond with an interactive website, so kudos to them!

Pictured here is my group, along with the professor:
(That's me on the far right!)

Overall it was a great experience! We got to test our visualization skills (as well as the skills that lead up to it like data cleansing and formatting), and got to show them off in a competitive environment with high stakes! It was a tremendously helpful learning experience, and one that I'm proud of! Hands-on experience like this is invaluable, and it's great to get opportunities like this!

Next up is my Information Security final project presentation.
Thanks for reading, hope you enjoyed!

Comments

Popular posts from this blog

Information Systems Capstone - Introduction

In my Spring 2018 semester (the current one as of this post), I will be taking the Information Systems Capstone, which acts as a replacement for my internship requirement to graduate. This means the class will involve a full-semester-long project that replicates something we would do in the working world. As a group, we must propose to a Fortune 500 company why they should invest in Augmented Reality to help them save or earn more money. This involves a 10,000 word report detailing the opportunity, an explanation of the proposed solution, technical architecture, financial justification, and the implementation plan, an interactive dashboard that assists our argument to implement AR, and a manual detailing dashboard use, underlying financial analysis, and technical infrastructure. The project overall is quite the undertaking, requiring us to form a Sprint Workplan to stay on track during the semester, as well as weekly status reports with the professor. Everything is on us to researc...

Information Systems Capstone - Dashboard Rough Draft

The project has certainly come a long way from the beginning of the semester. For some additional background information, we've chosen Volkswagen as our hypothetical sponsor, and plan on implementing AR technology with various dealerships that offer repair/maintenance services with the Microsoft HoloLens. The goal is to increase customer satisfaction and trust with Volkswagen by providing a more transparent and efficient maintenance and repair service by utilizing AR technology. We've hammered out a lot of the details, and are currently putting together the 10,000 word proposal as well as the dashboard. The dashboard itself shows the financial impact our AR implementation will have, and will require a SQL connection of some sort for the final submission. Posted here will be the rough draft, which involves predicted revenue and market share increases should our AR implementation be accepted. We are still working on the SQL connection, and availability online through Tableau on...