Business Policy Update

By

About the Project

One of the cornerstones of a Saint Joseph's University education in the business school is completing the class business policy. This class challenges students to undergo a semester long project to discover the functional problems of a company by analyzing the internal and external environments in which the firm operates.
Afterwards, we create a presentation to show our findings and develop a strategy to either remedy the issues faced by the company or tackle other strategic objectives set by the team.

My Group & My Contributions

My group chose Caesars Entertainment, a casino-gambling company with a turbulent past and an uncertain future. Since I was a Finance and Business Intelligence & Analytics double major, I was charged with the internal and external analysis of the past financial statements and preparing the pro-forma statements with updated forecasts to reflect our strategy. Included here are our slides. I utilized my graphic design skills to create the theme for the slide deck (I can link them here if anyone would want them) and I utilized my skills in finance to prepare all of the financials for our company.
Given that most companies don't report much internal information outside of their 10K, 10Q, and other financial filings, a large majority of the research and quantitative analysis landed on me since I was the only finance major in the group.

The Future For This Project / Other Updates

In addition to the slide deck, I also started a Tableau Visualization that I unfortunately was not able to complete. I will post this once I finish debugging it, but it wasn't worth developing further during the course of the class due to time restrictions in developing it and that our group only had 15 minutes to present. 
Stay tuned for more updates in the future, but I hope to push the boundaries further with this project. 

Comments

Post a Comment

Popular posts from this blog

Custom Theme Palettes in Tableau

By
Image
Usage / Implementation of Custom Themes  While Tableau features several very nice themes that help to accentuate your data, the standard themes don't really differentiate your dashboard from others. You can create your own theme to match your company / desired theme for your dashboards. This guide will show you clearly how to create your own theme either using Adobe Illustrator or a free-to-use online tools I found the other day. STEP 1: Gather Hex Codes  Tableau determines colors based off of Hex Codes, which are unique alphanumeric identifiers for specific colors. While these can be daunting to look at, their usage is quite simple. Here's steps to find some using both Illustrator and a web source.  A. Online Web Source  If you navigate to  https://www.color-hex.com , you are given the ability to create custom color palettes relatively simply online for free. While it doesn't give the user as much guidance on good color pairings for color pale...
Read more

Easily Sourcing Geographic Data Via Google Maps

By
Image
INTRO One of the most recent trends within Tableau and the visualization world is the utilization of geographic data and heat maps. While entering ZIP codes and City names are useful, it would be significantly more interesting to see specific locations as individual pins within those areas. That's where using Google maps has its benefit. Using the below method, you can easily source geographic data using Latitudes and Longitudes and export the table into excel. There are really only two pieces of software that you need: Microsoft Excel (ON PC) A web browser capable of accessing Google Maps  A google account **Unfortunately, I have not yet been able to recreate my success with this process on Mac. The XML conversion is a bit difficult to navigate there** STEP 1: Create a Custom Google Map with the Locations For the sake of this example, I will plot all of the Chik-Fil-A locations in the Philadelphia area. First, we must plot the area of the map. For this, navigate to...
Read more