iOS 12 – Siri Shortcuts and Tableau

By

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 and when I am active in my day. So start the process in iOS 12's Shortcut's app and select the "Export Health Data" icon and select allow access. For the purpose of this exercise, I'm going to draw data hourly by how many steps I take: 
1: Open the Shortcuts app and Select "Export Health Data"

2: Change the Start date to a couple of days before (as I did) and then group the data by hour so you get 12 measures per day. 

3: Now interact with the share sheet and click on "Shortcuts"

4: From this Menu, select the "Save to Any Drive" option I added. 

5: Select your preference of a storage option,

Interacting with the Data

Now that we've converted the data, locate it either on iCloud Drive or Dropbox and then open the data in Excel. You won't exactly see something pretty when you open it up: 
To solve this cluster of data, simply select all of the A Column and go to data – text to columns. 


You could further separate the date data, but everything you need is now formatted correctly and ready to go! 

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

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