B.I. Joe

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 ...

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...

iOS 12 – Siri Shortcuts and Tableau Intro One of the cool new features implemented in iOS 12 was Siri Shortcuts, which is an amalgamation of an app called Workflow and Apple's own software. It's a tool that's integrated directly into iPhones, iPads, and Apple Watches. With this cool new software comes a slew of tricks. Today, I'm going to show you how to integrate health data into excel and eventually into Tableau using your iPhone.  Initial Setup You will need to start with this workflow, provided to me by a  @vulkman  on reddit. Open  this link  on your iPhone and save the workflow. It's pretty easy setup. Additionally, you will need to be able to export the data, so I would just use  this workflow  I made to streamline the process. The second workflow allows you to export data from your iPhone to Dropbox or iCloud Drive.  Prep Your Data I love using this method for showing active calories. It allows me to visualize how active ...

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...