Case Competitions
In this case competition, we worked with Jack Links to try solve a business problem they gave us. We had two months to clean and organize 3 million rows of POS data. To do this, we mainly worked with Python and Power BI. After the two months were up, 7 teams presented to Jack Link’s executives, and in the end, my team won the competition! If you want to see the presentation please click on the image to the left.
In this case competition, we worked with Hormel for 2 months. They gave us a struggle and a business problem they have been dealing with, along with 2 million rows of POS and Panal data. As a team, we used Excel and Power BI to develop findings. Along with using outside resources to support them. After presenting to Hormel executives and competiting againist 7 other teams. My team came out on top wining the competition! If you want to see the wining slide show, please click the image on the right!
In this case study, I looked at a company that needed to try bring single-channel users to multi-channel users. I focused on customer lifetime value and made a recommendation based on the analysis done. I used Power BI and Python to conduct my research and clean the data. If you want to see the presetation please click the image to the left!
Internship
In my internship, I was tasked to analyze the performance of a planogram and give recommendations based on my analysis. I used data gathered from Nielsen, looking at the last 52 weeks. Then, using Excel to conduct my analysis. If you want to see the presentation, please click on the image to the right!
Another task I was given in my internship was to complete a Quarterly Business Review (QBR) for a parent company with multiple brands under it. I was tasked to look at their brands’ performance at Hy-Vee, UNFI, and AWG. I pulled all of the data from Nielsen and compiled it in Excel, where I did my analysis. Comparing them to competitors and how they were performing compared to the previous quarter and year. If you want to see the presentation, please click the image to the left!
24 hour Hackathons
This is an annual data analytics hackathon hosted at the University of Minnesota-Duluth. After being given the business problem and data, you have 24 hours to come up with a recommendation and present your findings to the judges. After getting the data, we cleaned the data in Power Query within Excel, then used both Excel and Tableau to conduct our findings. After a long 24 hours and a presentation, my team ended up winning the competition! If you want to see the winning presentation, please click the image to the right!
This was the second year of the annual hackathon at the University of Minnesota-Duluth, which I participated in. We were also given 24 hours to analyze the data and make a presentation. Once given the data, we used Tableau and Power BI to identify a key moment of purchase they were missing. If you want to see the presentation, please click on the image to the left!
Dick’s Sporting Goods Competition
This was the first round of the annual Dick’s Sporting Goods analytics competition. We were given customer data and tasked to build a reward/punch card system for them. We had two weeks to make a 7 min presentation, then it will be judged to see if we move on. There were over 80 teams that applied. We used Excel and Tableau to make our analysis. I even made a regression model within Excel to find what had a positive impact on returning customers. Click the image to the left to see the presentation!
We were selected as one of the top 8 teams in the country! And were flown it to Pittsburgh to present to another panel of judges! But we were first given more data and told to go extremely in-depth with a rewards program targeted at their House of Sport locations and younger audiences. We developed a concept for an app and intergrated rewards system for users and a lot more. Please click on the image to the left to see the whole presentation!