Mobile Health Monitoring with Tableau 9 – Thorogood BI & Analytics Update

hi everyone and welcome to my next session mobile health monitoring with tableau 9 my name is Madeleine malmgren and I’m a business intelligence and analytics consultant with very good and I work as part of our tableau practice so tableau is a data visualization tool that empowers users by putting the data back into their control they can connect to it and start visualizing it really easily with the desktop software and then share it with their colleagues through the server server offerings it frees them from the structured reports that they may be used to in their everyday business life and gives them more control this year we’re really proud to say that we were named emea strategic alliance partner of the year for 2014 with tableau and we’re so proud of this because it really represents how many enterprise customers we have helped to implement tableau successfully throughout the company through all different departments to gain real business value some of you who are familiar with tableau may know that we tableau 9 was released in april this year so it’s been out a couple of months and includes some really really interesting new features with the tool that are really going to improve the usability and some of the ones that we’re going to be covering today are the new tableau mobile app which is has some really interesting new features there’s many more options for data preparation when connecting to data in tableau and also there’s a new analytics pain you can see a lot of other new features listed at the bottom there interestingly the performance is always a huge topic when we talk to our customers about tableau so there’s been huge and core huge improvements there sorry and definitely worth investigating some of those new features and I just like to do a quick poll now cm how many of you are users of tableau at the moment just raise your hand okay so I thought I’ve got quite a few of you in here and who have you you in the room already moving to tableau nine okay couple less so it does always take a few months for the new releases to to filter through into enterprises so probably about what I expected those of you who aren’t familiar with tableau throughout the demos today we will be focusing on the new features but you should get a very good idea throughout those demonstrations as to how user-friendly tableau is and how easy it is to connect today to start visualizing it so the theme for this morning has been the Internet of Things so anything in your everyday life that’s connecting data anything with a sensor about 2-3 months ago i decided to sign up for a 10k run and i’m absolutely terrible at running I’m shocking at it so my friends decided they’d buy me a Fitbit so this is this band on my wrist which I wear every single day and its senses how many steps I take you to Jay how many calories I burned how many steps I’ve been how many floors I’ve climbed sorry my favorite thing is it attaches to an app on my phone which tells me when I’m running how far I’ve run and will pay some going so I’ve been using it for my training there were lots of similar technologies so you can see up here there’s the Fitbit up there we’ve also got Apple watch nike fit and a lot of your smartphone’s probably actually monitoring number of steps you take throughout the day and so what I’ve done for today is collect that data stored it in this excel file downloaded it from the website and it is actually the data that I’ve collected from the last three months so don’t judge me too much when Andy told me I was going to be doing this presentation and he said oh you’re wearing fit there why don’t you do it on that that goes with the theme I don’t know what I was more scared about standing up in front of all of you or you’ve seen that the day before I’ve done 500 steps probably between the sofa and the fridge so there will be a few gaps and but it is real date sir okay so some of you may be thinking it sounds quite interesting is quite interesting for me to start visualizing that data but what are the use cases so companies are already using data like this so insurance companies using data similar to this to monitor where you’ve got active customers and reducing their health insurance premiums you’ll have seen adverts on TV for in other of earth sorry motor insurance companies who are monitoring how well you drive by putting a little sensor into a car and reducing your insurance premiums that way pharmaceutical companies use a similar band like this to monitor your heart rate monitor your blood pressure and keep track of those clinical trials so back to Trevor’s point familia this is quite interesting data but it’s just another data source that we can connect to store anywhere I’m storing it in Excel we can store it

in Hadoop politely discussed earlier and in connect to it with visualization tools like tableau ok so now I’m going to head over to a demonstration I don’t have a helper today some of your doing a demonstration myself and what I’m going to do is open up tableau desktop so this is the tool from tableau where we connect to our data and we start visualizing it you’ll see in the window here is quite blank because I haven’t connected to my data yet so to connect that excel sheet that I’ve stored my data in I go to data at a new data source before I collect connect to that just so you can see how many data sources are options to connect to in tableau so we’ve got Hadoop which we were discussing earlier the entire Microsoft stack AWS cloud error as well so we can connect to connect the cloud on-premise and local excel files I’m going to select that excel file now and click on my April data I want to be my activities and immediately tableau has recognized the table of data in that sheet it’s very smart data engine it’s recognized where my column names are so how many calories are burned how many steps I’ve taken and it’s also recognized the data types of that data as well so previously there wasn’t there weren’t many other options to edit your data once you’ve connected it to it in tableau but now I have a couple of issues with this data so you’ll see the last four columns minute sedentary down two minutes very active are actually pivoted out data but this is data that are much easy it’s much more easy for me to use if I can pivot this round in previous versions you would have had to do this unfitting in Excel before you collect to it in tableau with tableau 9 we just select the columns click on the drop-down and click on pivot and now this is in a much more usable format that I can connect to in tableau and it’s done immediately in just one click what I also may want to do is get rid of any redundant information that I’ve now got so now I’ve pivoted my information I’ve got some useless useless words it kind of in that column that I’ve created so I don’t really need to see the words minutes and active here so there’s a couple of ways I can clean up that data I can either add in some aliases for the data or what’s much quicker for me is to just split it and I get the information I need tableaus recognize that that’s the unique quantity in that column and is split it out for me so I’ll hide the rest of that column I don’t need anymore and rename these two to my activity level and the next column to my activity minutes so now my data is ready to start visualizing and I’ll go to my new tab once i’m here i can use those um pivoted columns so drag on activity level to my rose and those active minutes to the columns the sum isn’t really important to me so I want to look at the average and now I can see about how many minutes I spend each of those activity levels throughout the day because the most is a certain tree but that is when I’m sitting in the office when I’m sleep I’m watching TV and but kind of quite a range of values there so in three clicks they’ve been able to get some information from that data that I couldn’t when it was in a spreadsheet using the tab show me feature in tableau this isn’t new but it’s a great way to find the right way to visualize your data and get the most value out of it we can click around explore the different options for those visualizations and choose the one that that tells the best story with the data okay so that’s connecting to data we’re now going to look at the analytics pain and so in true blue peter style got a dashboard that I’ve created earlier and this is what I use to monitor my Fitbit data on the left hand side we’ve got some KPIs and these are the design needs that are very similar to actually what we saw in data zone earlier in Henrietta’s and presentation I’ve got me an average number of calories I burn a day how many what my average steps per day I know I want to be aiming for 10,000 something bit below I’ve also got some spark lines which i’ve added underneath there we’ll see a big spike here in April this is the day I found out was doing this presentation that didn’t last very long but as soon as I hover over these I can get there the details of that data rather than just seeing the trend so see what date that was on and how many calories I burned I did mention earlier the performance updates that have come in tableau 9 and we’re not going to go into them too much but one of them relates to the tooltips as soon as I move through this visualization you’ll

see that tool to tool tip will update instantaneously and it actually gives you an easier way of comparing your data rather than having to wait for that tooltip just for a cuppa split leavin a split second to update gives you a different view on the data in the center here I’ve got some more details on how my activity level splits out so how long do I spend fairly active and how many steps do I take during that time and then a bottom at the bottom of time series one of the big features of tableau is how interactive it is so I can click on an activity level to focus in on that data and see see those trends outside of the other activity levels I can also drill down so if I click on the thirty-first March I can see how those steps broke down over time this is data from my iphone which I’ve collected and blended in but just drilling down through that information doesn’t really give me all the information I need so I’m going to open up the tab for my scatter plot and do a bit more analysis on it so if I click on the analytics pain this is a completely new pain for tableau 9 any of you who use it before use tableau before will know that you could add reference lines and add average lines but they were quite tricky to do so if I just show you how what the process would have been in tableau 8 you right click on an axis it’s not very obvious that’s what you want to do you need to do to add this reference line click on add reference line and you’ve got this big wizard to go through but it’s not obvious that that’s how you get to show those average information now with the analytics pain I just drag and drop an average line i canna choose to apply it to a table a pain or a cell in this case the tables most logical and where I want to apply it but I’m going to apply it to the whole table and as soon as I drag it your average line appears so it’s really easy to start to do analytics with your data and with tableau without relying on complex statistical scripts like our once I have these average lines here and in previous versions this average one would be fixed but now once they start to interact with my data I can see how those averages change so if I select lightly active my average line jumps up immediately but underneath I still have the greyed out area of what my total average was so I can see how it’s changed it’s about double for my likely active time because this is probably when I’m walking so I spend quite a lot of time walking in the day similarly if I click very active it’s a lot lower because this is a probably when I’m going for a run and they’ve kind of 27 minutes in my head kind of makes sense of how long I’d usually run for we can also edit those average lines very easily so if I click on the average line we can edit format or remove this average line just by clicking on it but we can also change which average we use I can change to view a minimum or a maximum or look at median like a roll now and if you don’t not interested in that average line anymore just drag it off and it’s gone so you can have much more options to play around your data without having to go through those wizards another new feature of the analytic pain you’ll see quite a few things lifted up the side I hope hopefully you’ll be able to read them I realize the text is quite small but a new feature is the improved forecasting so let’s go to my time series and in the same way as before I can drag on a forecast I’m just going to take that off color so we don’t bet the colors and this haven’t given me the best forecast because there aren’t too many patterns in the data but you can see that it’s very easy to drag and drop those forecasts on and if I click on the pill that this is created from I can change the forecasts that I’m using here so look at the prediction intervals or the trends once I’m happy with my dashboard I can publish it so that I can view this on the go there are three options for the tableau server what most of you will probably be familiar with this tableau server on promise so this is where you store your tableau server in house and you can connect to your enterprise data warehouse as well as public data and locally stored data there’s also tableau public this is generally used by bloggers and journalists and they will create visualizations online and store them online so they are publicly available and they use publicly available data what I will be using today is tableau online so this is the cloud-based offering from tableau this allows you to rent out space on the on the cloud from tableau and utilize their server without meeting and on-premise sir so and yes that’s what i’ll be using today and this will be a tableau server

that all of Thorogood users so everyone publishes their tableau workbooks up there to do that i’m not going to do it now just internet connection but it’s just you click on server and publish and then select hablo online if we can go to the ipad now please okay so once I’ve and published my dashboard to the cloud I can now connect to it online with an internet browser or I can connect with an iPad so you can see here a full list of the different work books that have been published to tableau online published by various members various colleagues of mine and just to connect my data I just click on the thumbnail and that will open up my Fitbit data so once this opens up you’ll be able to see that it has exactly the same interactivity and functionality that we had on the desktop so i can click on a certain area and and drill down into my data i can select activity levels to highlight certain areas of the data as well but the really good new feature is being able to edit on the go so if I now go option to the right hand corner and select the edit button you’ll see a very similar view to what we were seeing in tableau desktop come up on the mobile and this has been available for a while on tableau server so without having a desktop license if someone else had created or authored a dashboard and published it to the server you would be able to go on and edit that if you had the permissions to you can now do this on mobile as well people aren’t confined to having a laptop with them anymore people are using tableau much more on the mobile so this is a really helpful update for a lot of people so I’ve got my scatter plot and I may decide actually today I’m not that interested in seeing my active steps I want to see the calories burned so when I open that up I’ve got my full less list of dimensions measures all of the different data sources i’ve been using as well as the filters and i can change the color but to do this now all i’m going to do is drag on activity calories onto my columns and replace steps and then immediately you’ve seen that data update so you’ve got a live connection to your data through your mobile device if i save that and click done i’m going to go back to my dashboard but this is going to reload and have that new visualization available to me on the go and so some of you may be thinking why on earth would I have an iPad with me when I’m on a run this isn’t really like the most the biggest use case for the doing tableau using tableau on a mobile but and put it into a case of a client we had used recently I built some tableau dashboards for a consumer goods company and they were for the field sales force so these dashboards would be taken out by the field sales reps out into the field when they went in visited their store reps they’d sit down in store and monitor their sales and they’re on shelf availability with the store manager when they went on over this but when you have conversations with people that dashboard that I built for them maybe didn’t show absolutely everything they needed to answer that question that the store manager had but now with tableau 9 those field reps can now edit the data and say they want to have a look at the stock change those dashboards on the go and answer people’s questions while they’re there rather than having to say oh way I can find out that information for you but I’ll give it to you later when I can get onto my laptop so really interesting update there okay so just going to go back to slides so those were just three of the new features in tableau nine so we looked at the new data preparation window the analytics pain and the new tableau mobile app but there are loads more new features that are definitely worth looking into the level of detail calculations are going to really improve the range of calculations that you can create within tableau without having to rely on building cubes and creating lots of calculations in your relational database there’s a new and improved server which has been completely rewritten for performance reasons and also for usability is much easier now to set the security options and because it was quite hard to work things like that out in previous versions the performance is improved dramatically so now we have parallel querying rather than each query in a dashboard running one after the other and there’s improvements to the maps as well we’ve got some events coming up soon so we’ve got tableau for insurance and tableau and Microsoft coming up in the next month and so if you’d like to see more of these new features please do come along to those there’s details on the website we’ve also got an insight Spade on the fur a good website which has loads of videos and we’ve run

a huge range of webcasts as well which all the recordings are up there and if you have any questions i’ll be around at lunch i will probably catch me doing laps i’m a bit low on my step count for the day then also you can email me as well