0:00Okay. So I'm going to start
0:02this blog post from a slightly different
0:03place.
0:04I'm going to start by showing you the
0:05output.
0:06So I'm going to connect to Google Sheets,
0:08and I'm going to connect to a dataset I've
0:10just been looking at with
0:12my fuel consumption and mileage on it.
0:16So the instant I connect,
0:18I know I need to do some data prep straight
0:20away.
0:20I don't need some of these fields.
0:23These two fields here are created in Google
0:26Sheets.
0:26So I'm actually going to hide them because
0:28we're going to do some of
0:29our own calculations and I'm going to use
0:31the custom split functions just to split
0:33out
0:33one column which has the date in it.
0:36So very, very quickly,
0:37I've done some data prep.
0:38I'm now ready to do some analysis in Table
0:41au.
0:41So the other thing I can do while I'm here
0:44is this premium tag
0:46is like a true or false.
0:49So I'm just going to put it here
0:50because it really should be a dimension.
0:52I'm going to drag out the dates and I want
0:54the exact date so I can
0:56see each day that I actually went to the
0:58fuel pump,
0:58and that's the cost.
1:00So here is a chart showing me the cost,
1:03how much I've been spending at the fuel
1:05tank on each visit over time.
1:07I started doing this in July.
1:09One of the really interesting things is I
1:12've started analyzing
1:13my fuel economy and therefore the
1:16performance of my car,
1:18and it's been really interesting.
1:20So let me just give you a very, very quick
1:22example.
1:22So I'm just going to divide the cost by the
1:26number of miles driven.
1:28What you can see here is if I just drop a
1:32reference line into the chart,
1:34with the value, and we actually format this
1:39so that this is a currency.
1:41You can see that the cost on average per
1:45mile that I drive is 12 pence.
1:49So that's 12 pence per mile.
1:50But up here in the 5th of September is
1:52actually 20p per mile.
1:54So what happened?
1:56Essentially, I had an issue with my car.
2:00If I just bring out the miles driven
2:03underneath that,
2:04you can see the actual day where I had the
2:06most miles driven was late September.
2:09I actually had to drive to collect my dog
2:13from Scotland.
2:14So here we have a very,
2:18very standout piece of data.
2:21What actually happened here is I had an oil
2:22leak.
2:23So the engine performance dropped basically
2:26through the floor.
2:27I was able to rescue that,
2:30but it was costing me eight pence per mile
2:32more than normal compared to my average.
2:35You can see it tends to stay roughly the
2:37same.
2:38These peaks and troughs are to do with the
2:41type of traffic I'm driving in.
2:42So if I do a lot of city driving, it's up
2:44high.
2:45If I do a lot of motorway driving,
2:46it tends to be just below 12 pence.
2:48So it's very easy for me to analyze this.
2:51This was all done because Workflow,
2:54Google Sheets, and Tableau were able to
2:57work together.
2:58For very, very minimal cost,
3:00I have the kind of setup most companies
3:03have in a database or data warehouse.
3:06Of course, with the new functions in Table
3:08au 10,
3:09you can do lots, lots more with that.
3:11So that's a very quick insight.
3:13Read the rest of the blog posts to find out
3:15more about how I've actually done this,
3:17and I'm able to do this kind of analysis.
3:19I'll see you in the next one
Tableau | Data visualisation | Data prep | Analytics