WEBVTT
1
00:00:04.140 --> 00:00:19.470
Michelle Coppens :: Webinar Producer: Well Hello everyone and welcome to today's webinar how tablo training can transform the way you see and understand data our speaker today is tablo trainer and data scientists Jason Becker them.
2
00:00:20.580 --> 00:00:30.300
Michelle Coppens :: Webinar Producer: Jason is a data scientist with end to end analytics experience Jason is one of the lead certified instructors for tablo training courses.
3
00:00:30.780 --> 00:00:38.040
Michelle Coppens :: Webinar Producer: Jason is fluid in both English and French, and can create content and deliver your training services in both languages.
4
00:00:38.730 --> 00:00:45.060
Michelle Coppens :: Webinar Producer: from Toronto Canada Jason has been working with tableau for four years and teaching students for two years.
5
00:00:45.540 --> 00:00:58.920
Michelle Coppens :: Webinar Producer: His clients span across multiple industries such as healthcare, telecommunications and finance and for a personal touch his favorite sports teams, or the Toronto raptors and villanova wildcats basketball teams.
6
00:00:59.940 --> 00:01:15.900
Michelle Coppens :: Webinar Producer: Now, before we get started with today's webinar I want to touch on the functionalities during the session everyone's microphones will be muted, so if you have any questions, please enter them in the Q amp a box at the bottom of your screen.
7
00:01:16.980 --> 00:01:27.810
Michelle Coppens :: Webinar Producer: We also have the chat window enabled so you can post your questions in either the Q amp a or the chat, we will have a dedicated question answer session after the presentation.
8
00:01:29.040 --> 00:01:38.220
Michelle Coppens :: Webinar Producer: today's webinar is being recorded and will send a copy out to everyone who registered to be here alright let's get started, you can take it away Jason.
9
00:01:39.750 --> 00:01:49.290
Jason Bekkedam: Thank you, thank you, thank you hi everyone yeah my name is Jason i'm a tablo instructor i'm really excited to be here with you guys today, probably on your lunch breaks.
10
00:01:49.890 --> 00:01:55.920
Jason Bekkedam: So yeah Thank you so much for coming let's jump right into a poll question, right now, just so I can get a gauge.
11
00:01:56.220 --> 00:02:08.070
Jason Bekkedam: Of the audience i'd love to know how much experience you have working with tableau so i'm just going to launch this poll, right now, and if you could take a second to answer be really appreciate it.
12
00:02:14.640 --> 00:02:22.170
Jason Bekkedam: All right, all right answers are flowing in perfect Thank you guys so much let's just take a look at those results, right now, so.
13
00:02:23.100 --> 00:02:30.630
Jason Bekkedam: It looks like 84% of you are new to tablo so that's perfect I know who i'm talking to mostly.
14
00:02:31.320 --> 00:02:41.670
Jason Bekkedam: Then we have 13% with less than one year and then 3% with more than one year so that's great to know Thank you so much for sharing that.
15
00:02:42.300 --> 00:02:53.580
Jason Bekkedam: Alright, so let's go into the agenda there's three points that I really want to hit on today, the first one is what is tablo authorized training authorized is the key word there.
16
00:02:54.120 --> 00:03:05.730
Jason Bekkedam: Then, most of my webinar today or most of the webinar today is going to be a sneak peek at tableau desktop life, so this is the course that we find has the.
17
00:03:06.000 --> 00:03:26.640
Jason Bekkedam: Is the most popular and i'm actually going to show you live in tablo what you can expect to learn from these tableau desktop courses so stay tuned for that, and then, finally, in the end, I want you guys to understand why you should definitely take a tablet training course with us.
18
00:03:28.830 --> 00:03:41.520
Jason Bekkedam: Alright, so what is tablo authorized training well it's officially developed and authorized by tablo, this means that tablo itself has developed curriculum.
19
00:03:42.030 --> 00:03:56.190
Jason Bekkedam: to teach these courses and i've actually gone down to tablo to learn how to teach this curriculum Okay, why not get the curriculum directly from the source, they know their product best they know how to teach it best.
20
00:03:57.240 --> 00:04:03.030
Jason Bekkedam: it's live and instructor led so it's usually a two or three day course.
21
00:04:03.990 --> 00:04:14.850
Jason Bekkedam: And you'll basically be on a call with me or another instructor at any time or at all times and this really allows you to ask a question as soon as it comes up right.
22
00:04:15.150 --> 00:04:19.890
Jason Bekkedam: If you if you don't know how to do something you can just unmute your MIC and ask away.
23
00:04:20.130 --> 00:04:26.130
Jason Bekkedam: Or if you don't want to use your MIC you can also use your chat or email and happy to answer in any way possible.
24
00:04:26.340 --> 00:04:33.510
Jason Bekkedam: But I really like this, because it keeps students engaged, it also keeps me engaged right because i've taught this course many, many times.
25
00:04:33.810 --> 00:04:38.550
Jason Bekkedam: And the more engagement I get from the students, the more interesting it keeps it for me as well.
26
00:04:39.240 --> 00:04:53.340
Jason Bekkedam: And also, I really like to interact with students, because it makes sure that no one gets left behind okay I there's a lot of IT training and, believe me, i've taken a lot of dull IT training in the past where.
27
00:04:54.930 --> 00:04:58.980
Jason Bekkedam: I don't have an instructor it's not instructor led instead i'm looking at a video.
28
00:04:59.370 --> 00:05:14.910
Jason Bekkedam: And sometimes it's really hard to keep up because I might get stuck at one point I can't ask question okay so being able to ask that question on the spot is super useful and then, finally, you can choose from a variety of course offerings, so this is.
29
00:05:16.110 --> 00:05:20.970
Jason Bekkedam: This is really important, because tablo offers a ton of different offerings depending on.
30
00:05:21.510 --> 00:05:30.270
Jason Bekkedam: Firstly, the level at which you're you are in tableau so I saw most of you have not used tablo so you're very new to tablo.
31
00:05:30.480 --> 00:05:38.070
Jason Bekkedam: that's fine i'm going to direct you to the course that you probably be most comfortable in and where you probably get the most value in.
32
00:05:38.430 --> 00:05:48.180
Jason Bekkedam: right but tablo also has a ton of courses for people who are more advanced as well, so we're going to go over that throughout this webinar and don't worry about it.
33
00:05:49.920 --> 00:06:02.640
Jason Bekkedam: Okay, so what courses are offered well the courses are divided, depending on the software that you're actually using in tablet so just as an introduction to tablo.
34
00:06:03.330 --> 00:06:18.030
Jason Bekkedam: tablo basically has three software offerings you have tablet desktop, this is the product, this is really the flagship product of tablet this is how tablo became a super huge company they developed this.
35
00:06:18.570 --> 00:06:30.180
Jason Bekkedam: Really innovative way of building reports in a super easy way and tablet desktop is great for doing that you don't need to know any coding it's really just drag and drop functionality.
36
00:06:31.410 --> 00:06:46.260
Jason Bekkedam: And then tablo decided, well, we need a way for people to actually maintain these reports in a central repository so they've developed something called tableau server there's also courses on tableau server and they.
37
00:06:47.790 --> 00:06:55.560
Jason Bekkedam: They really deal with data, governance, data security data sources maintenance.
38
00:06:56.040 --> 00:07:03.540
Jason Bekkedam: All that that's tableau server and then, finally, this is a newer product but it's starting to get a bit more mature now in the marketplace.
39
00:07:03.720 --> 00:07:13.470
Jason Bekkedam: there's tablo prep, so this is, if you want to take a really raw data source and maybe it's not ready yet to go into tableau desktop to create your reports.
40
00:07:13.800 --> 00:07:28.560
Jason Bekkedam: that's where tablet prep is going to come as that intermediary step, where you can take that raw data source, you can transform it, you can clean it and then you can push it to your tablet desktop to author those really, really great reports.
41
00:07:29.970 --> 00:07:41.790
Jason Bekkedam: Okay, so let's hop on to the second poll question, I think I might have an idea as to what the answers are going to be considering most of you are new to.
42
00:07:43.320 --> 00:07:50.730
Jason Bekkedam: tablo but let's take a look at this so let's relaunch we want this one.
43
00:07:57.810 --> 00:08:02.100
Jason Bekkedam: Alright, so the question is which tablo platform, do you use.
44
00:08:05.760 --> 00:08:13.800
Jason Bekkedam: All right, oh lots of answers coming and I like it, I think we have some new people to in here so welcome welcome if you missed the intro.
45
00:08:14.640 --> 00:08:23.670
Jason Bekkedam: Okay sweet so i'm going to end the polling and 321 beautiful let's take a look at these results.
46
00:08:24.240 --> 00:08:37.680
Jason Bekkedam: So we actually have quite a few people who are using tableau server so that's really great and and then of course tableau desktop is a big one, and other okay great really great to know thanks thanks for sharing guys.
47
00:08:39.420 --> 00:08:50.280
Jason Bekkedam: Wonderful so let's actually talk about what you get when you when you sign up for a tablet course so for every single tablet course.
48
00:08:51.210 --> 00:09:08.040
Jason Bekkedam: you're going to receive a practice guide, so this is going to be basically a manual over 100 pages, you have a ton of different exercises, you have the exercise solutions as well, if you want to refer to them, this is really where you're going to be able to learn on your own.
49
00:09:09.300 --> 00:09:15.870
Jason Bekkedam: And test out your knowledge that you were taught in the course so that's great you're also get a theory manual so.
50
00:09:16.440 --> 00:09:25.470
Jason Bekkedam: Some people they like to review some stuff after class or maybe a month from the chorus they like to review make sure they kept up with everything.
51
00:09:25.710 --> 00:09:31.440
Jason Bekkedam: Well you're going to get a theory manual with all the different subjects and all the different chapters that we're going to learn in the chorus.
52
00:09:32.070 --> 00:09:37.740
Jason Bekkedam: you're also going to get an example or a bunch of examples for tablo workbooks so.
53
00:09:38.400 --> 00:09:44.670
Jason Bekkedam: let's say you want to know how to do a map in tableau and you don't remember how to do it from the course.
54
00:09:44.940 --> 00:09:55.170
Jason Bekkedam: Well, you can actually go, you can open up tablo tablo has an example of that map right, you can basically do that for any chart you learn in the course.
55
00:09:55.560 --> 00:10:12.870
Jason Bekkedam: And then finally you're going to get something called an access to e learning on tablo COM Okay, so this is a 90 day free pass to this great resource that's also developed by tablo has a bunch of videos and a bunch more theory as well.
56
00:10:15.660 --> 00:10:24.630
Jason Bekkedam: All right, beautiful so let's let's go into tablet desktop Okay, this is the courses that we see that are really the most popular.
57
00:10:25.260 --> 00:10:33.960
Jason Bekkedam: So the first one is tablet desktop fundamentals Okay, this is really going to teach you the fundamentals so i'm really a basketball guy so.
58
00:10:34.920 --> 00:10:47.670
Jason Bekkedam: When I was learning the fundamentals as a kid I learned how to dribble I learned how to shoot I learned how to pass okay so you're really going to learn the basics, the fundamentals, maybe you're not really a sports kind of person.
59
00:10:48.750 --> 00:10:54.600
Jason Bekkedam: Well, most I think most of us to chemistry in high school, this is really I think.
60
00:10:55.200 --> 00:11:06.330
Jason Bekkedam: That you're going to learn basically the periodic table for Chemistry okay you're going to learn all the different elements of tablo but you're not necessarily going to learn how they interact.
61
00:11:07.230 --> 00:11:21.930
Jason Bekkedam: Then you're going to hop to desktop to okay so desktop to is for the intermediate tablet desktop user maybe now you have access to all your periodic table elements and you're like Okay, what if I take.
62
00:11:22.500 --> 00:11:30.300
Jason Bekkedam: This element and interacted with this element does is it going to explode, as it can make fire okay that's what desktop tool is going to do for you.
63
00:11:31.590 --> 00:11:33.570
Jason Bekkedam: And then finally desktop three.
64
00:11:33.930 --> 00:11:45.390
Jason Bekkedam: Well, this is going to get really advanced Okay, this is, if you went to college and you took organic chemistry becomes much more abstract but also extremely useful now allows you to develop.
65
00:11:45.570 --> 00:11:59.490
Jason Bekkedam: New concoctions of chemistry well desktop three is exactly like that you're going to learn some abstract formulas and you're going to be able to have a toolset that's going to enable you to actually innovate and tablo.
66
00:12:00.390 --> 00:12:06.300
Jason Bekkedam: Okay, so now what i'm gonna do is i'm going to go into tablo and we're going to do a progression.
67
00:12:07.560 --> 00:12:17.130
Jason Bekkedam: i'm just start with what you probably learn, or what you would reasonably learn in desktop one i'm going to go through just a couple of charts and one report.
68
00:12:17.700 --> 00:12:27.780
Jason Bekkedam: But it's really just the tip of the iceberg, then after i'm done those charts i'm going to go to desktop two and then finally we're going to see what you learn in desktop free.
69
00:12:35.520 --> 00:12:45.360
Jason Bekkedam: Right beautiful So the first thing in tablet is you need to be able to connect to a data source, so if you've never seen tablo and you're wondering oh.
70
00:12:45.870 --> 00:12:56.610
Jason Bekkedam: Can I actually connect to my data source, the answer is most likely, yes, we can connect to files, so this is where you have your Microsoft excels.
71
00:12:57.030 --> 00:13:09.000
Jason Bekkedam: Your csv files your spatial files and then there's also servers so there's a ton of different servers in here there's also something called odissi OD BC and Jay.
72
00:13:09.240 --> 00:13:14.220
Jason Bekkedam: Jay D BC connector So if you don't see your server in here as well, you can probably use it.
73
00:13:14.730 --> 00:13:28.920
Jason Bekkedam: Through a connector but for today and for our courses and desktop we're really only going to look at flat files around the A look at csv files and Microsoft excel files Okay, so if I go to Microsoft excel.
74
00:13:30.570 --> 00:13:32.490
Jason Bekkedam: And I find my.
75
00:13:34.950 --> 00:13:36.930
Jason Bekkedam: Data set so client list.
76
00:13:39.060 --> 00:13:44.310
Jason Bekkedam: I can actually get a live preview of what my data set looks like and tablo.
77
00:13:44.850 --> 00:13:56.640
Jason Bekkedam: Okay, so this data set is actually a data set I made up for this webinar it's one one of the things I like to do for my courses as well, I like to make up different data sets to keep it a little fun.
78
00:13:57.150 --> 00:14:03.210
Jason Bekkedam: So this is actually it's kind of a look inside of a tablo training organization okay.
79
00:14:03.600 --> 00:14:11.790
Jason Bekkedam: we're going to say Oh, this is the company that we trained, this is the course title that they train the amount of students and their satisfaction score.
80
00:14:12.240 --> 00:14:25.410
Jason Bekkedam: So these companies are actually all fictitious we have this Springfield nuclear power plant from the Simpsons here there's also X capital, we also have what's the avengers one again.
81
00:14:27.630 --> 00:14:38.970
Jason Bekkedam: stark industries Okay, so this is by no ways a real data set but I like to use data sets that can be applied in real use cases right in my teaching So here we go.
82
00:14:39.750 --> 00:14:47.190
Jason Bekkedam: This is our data set let's go ahead and click on our first sheet here to introduce Pablo desktop.
83
00:14:47.940 --> 00:14:53.610
Jason Bekkedam: Okay, with tableau desktop you're going to have access to some data on the side here.
84
00:14:54.210 --> 00:15:10.500
Jason Bekkedam: And this data is separated in two different ways, the first so this blue area, right here, this is something called dimensions, this is really data that you're going to be able to categorize your data set by and then below that.
85
00:15:11.670 --> 00:15:23.070
Jason Bekkedam: In green right here, this is something called measures, measures are our stuff that you can aggregate okay there's numeric value a variable, such as the amount of students, that you had.
86
00:15:23.400 --> 00:15:29.910
Jason Bekkedam: or your satisfaction score Okay, by combining dimensions and measures in tableau desktop.
87
00:15:30.210 --> 00:15:43.350
Jason Bekkedam: we're actually able to create really cool looking visualizations and do it very quickly and easily okay that's the key here we're not trying to spend hours and hours to get a visualization just right.
88
00:15:43.680 --> 00:15:52.410
Jason Bekkedam: Now you can create a visualization in just a few clicks, for example, maybe I want a bar chart of my course titles.
89
00:15:52.980 --> 00:15:58.950
Jason Bekkedam: By the amount of students i've had in each one of these courses well i'm just going to drag.
90
00:15:59.520 --> 00:16:14.880
Jason Bekkedam: A dimension and a measure to my rose, and there we go, we have that bar chart super quickly right oh desktop one into accelerated is our most popular course nice what's our at least popular oh server architecture.
91
00:16:15.420 --> 00:16:26.880
Jason Bekkedam: Okay, quick and easy, we have a bar chart another thing you're going to learn and desktop one is filtering okay there's a ton of different ways, you can filter and desktop one.
92
00:16:27.390 --> 00:16:45.150
Jason Bekkedam: But let's cover a date filter So if I take the course date now and I just added to my filter here, I can actually filter by a range of dates within my data set so let's say I want to go back, I want to only see data from like mid let's say.
93
00:16:47.880 --> 00:16:53.430
Jason Bekkedam: Nice will see my data changes depending on my filter here.
94
00:16:55.200 --> 00:17:02.520
Jason Bekkedam: Okay sweet so that's a bar chart so name this bar chart or tablet desktop one bar chart.
95
00:17:03.930 --> 00:17:13.200
Jason Bekkedam: And let's create another chart that you'd expect to learn in desktop one, so this one is going to be called desktop one line chart.
96
00:17:14.910 --> 00:17:33.840
Jason Bekkedam: Okay, so why charts are a chart that's super commonly used in time series analysis and in order to do a time series analysis, we need to use a date field so let's use our core state, this time in our columns and let's use the month of our core state.
97
00:17:34.890 --> 00:17:43.770
Jason Bekkedam: And again let's take a look at the amount of students that we've had throughout each one of these months okay beautiful.
98
00:17:44.370 --> 00:17:57.000
Jason Bekkedam: So here we go, we have a line chart really quickly of all of our different students throughout each one of our months and we can see there's a big peak right here okay so may 2020.
99
00:17:58.440 --> 00:18:10.410
Jason Bekkedam: Why do we think we got more students in May 2020, this is a question that you can now answer based off of this graph or you can now research based off of this crap and probably.
100
00:18:10.800 --> 00:18:14.700
Jason Bekkedam: What people will say is well there's a lot of stuff got locked down.
101
00:18:15.300 --> 00:18:26.160
Jason Bekkedam: right before this so companies were trying to scramble to find different ways to train people online okay that's why we got such an uptick in students for that month.
102
00:18:26.490 --> 00:18:33.720
Jason Bekkedam: I get this is just a fictitious data set I doctored these numbers but there you go, we have an insight already on our second graph.
103
00:18:35.490 --> 00:18:41.100
Jason Bekkedam: Now, with this graph to will also learn about dynamic labels and desktop one.
104
00:18:42.180 --> 00:18:53.760
Jason Bekkedam: Okay, so maybe I want to show the amount of students for the maximum point of my data set so by taking the amount of students and adding it to my label.
105
00:18:54.390 --> 00:19:13.860
Jason Bekkedam: I now have effectively labeled every single point in my line chart but maybe I only want to show the maximum Well, I can do that i'm just going to hit Min Max and only allow my maximum value and there we go, we have 157 for highest point.
106
00:19:15.270 --> 00:19:32.790
Jason Bekkedam: Maybe I want to show the course date for that point as well well i'll take my course that and i'll just add it to my label as well may 2020 and, finally, for the ultimate customization let's increase the font here and let's say Max students.
107
00:19:35.820 --> 00:19:37.830
Jason Bekkedam: let's add this as read.
108
00:19:41.040 --> 00:19:45.120
Jason Bekkedam: Beautiful oh whoops went to my other screen.
109
00:19:46.440 --> 00:19:51.000
Jason Bekkedam: Beautiful MAC students 157 pay 2020.
110
00:19:53.100 --> 00:20:00.450
Jason Bekkedam: Okay, so this is just to charge so you're you're learning desktop blind right I think you're going to learn upwards of 15 charts and desktop one.
111
00:20:01.290 --> 00:20:14.700
Jason Bekkedam: Once you learn all these charts you're also going to learn how can you actually create a final interactive report in order to combine these charts to gain insights well in tableau reports are called.
112
00:20:15.510 --> 00:20:26.700
Jason Bekkedam: dashboards okay so i'm going to show you guys how to create this dashboard I just clicked on this button at the bottom here and i'll call this desktop one dashboard.
113
00:20:30.510 --> 00:20:42.960
Jason Bekkedam: With dashboards all you have to do to bring in your charts is to drag and drop okay so let's say I want to have my bar chart at the top, while i'm going to drag and drop it.
114
00:20:43.260 --> 00:20:53.460
Jason Bekkedam: And then my line chart at the bottom on drag and drop it at the bottom there we go, we have our two charts interact or together in one report.
115
00:20:54.480 --> 00:21:09.510
Jason Bekkedam: And then, how can we actually interact with these or make them interactive maybe I want someone to be able to click on desktop to, and then we only see data before desktop to in my line chart below.
116
00:21:09.960 --> 00:21:17.580
Jason Bekkedam: Well, we can do that super easily with tablo i'm just going to click on this little button called us as filter.
117
00:21:19.710 --> 00:21:27.690
Jason Bekkedam: And now let's click desktop to, and we can see our line shirt is effectively filtering depending on what I click.
118
00:21:29.520 --> 00:21:46.830
Jason Bekkedam: I can also make this filter at the top here applied to desktop or to my bar chart as well, so i'll say apply to worksheets all using this data source and now, when I change this filter, we can see it's effectively changing as well.
119
00:21:51.360 --> 00:22:00.360
Jason Bekkedam: Okay, so some really cool stuff that I can't show you guys because we're just going to run out of time what's another really cool thing that you'll learn in desktop one is.
120
00:22:01.650 --> 00:22:15.270
Jason Bekkedam: let's say you have a URL that you want to point to that you want to be dynamic you want it to be a dynamic URL well, you can actually learn how to do that in desktop one as well, so that's just.
121
00:22:15.660 --> 00:22:24.570
Jason Bekkedam: Something that I get really excited about of course you're going to have to take the course to kind of to kind of view that that kind of use case there.
122
00:22:25.590 --> 00:22:32.940
Jason Bekkedam: Okay, so that's desktop one let's take a look at a chart that you would see in desktop to.
123
00:22:38.370 --> 00:22:49.080
Jason Bekkedam: Okay, so when I went back to my analogy of periodic tables desktop one yeah we learn how to do a bar chart and we learn how to do a line chart that's great.
124
00:22:49.710 --> 00:22:59.970
Jason Bekkedam: Well, in desktop to we're going to be a little more use case focused okay so we're going to talk about real problems that companies are facing every day.
125
00:23:01.260 --> 00:23:05.850
Jason Bekkedam: And one of those problems is something called a cohort analysis.
126
00:23:06.240 --> 00:23:15.630
Jason Bekkedam: Okay, if you don't know too much about what a cohort analysis is that's totally fine i'm going to explain to you once we've done the chart how we can read it and how we can use it.
127
00:23:16.260 --> 00:23:29.070
Jason Bekkedam: But I also want to highlight that in desktop to you're also going to learn advanced formulas okay it's not only desktop three that you learn formulas desktop to you're also going to start to learn those formulas.
128
00:23:31.170 --> 00:23:53.220
Jason Bekkedam: And you actually have to use a formula for a cohort analysis okay so let's let's build out a bar chart to begin so let's say, of course, date and I brought it to my columns here, and then I want to take my amount of students and put it on my as a bar chart so i'm just going to do that.
129
00:23:56.790 --> 00:24:06.600
Jason Bekkedam: Alright perfect, so I have my amount of students per year in my desktop here and now, I want to do a cohort analysis so.
130
00:24:08.250 --> 00:24:13.230
Jason Bekkedam: To do a cohort analysis we're actually going to explore a custom calculation here.
131
00:24:15.030 --> 00:24:17.910
Jason Bekkedam: And i'm going to call this calculation.
132
00:24:22.470 --> 00:24:24.090
Jason Bekkedam: Men have fixed dates.
133
00:24:29.250 --> 00:24:36.960
Jason Bekkedam: Okay, so we're not gonna have the time to like explain this super in depth, usually it's like a 20 minute lesson on what this formula is.
134
00:24:37.650 --> 00:24:51.300
Jason Bekkedam: But i'm going to cover it on a high level so in tablo you have these formulas called fix level of detail expressions, and they basically allow you to tell tablo.
135
00:24:52.260 --> 00:25:17.550
Jason Bekkedam: To ignore certain dimensions in your workbook okay so right now my amount of students is absolutely dependent on my year of that course state Okay, so that amount of students here is being categorize by 2016 and that really allows tablo to to.
136
00:25:19.200 --> 00:25:28.830
Jason Bekkedam: empower its users to create visualizations very quickly, the problem is with certain use cases this is actually going to be a be detrimental.
137
00:25:29.490 --> 00:25:47.970
Jason Bekkedam: And that's when we have to be more flexible and used level of detail expression so to do a level of detail expression i'm going to write the word fixed and then i'm going to add the category that I actually want to use to categorize my data and i'm going to say company name.
138
00:25:49.080 --> 00:25:52.260
Jason Bekkedam: With company name I want the minimum date.
139
00:25:53.880 --> 00:25:55.410
Jason Bekkedam: of their course.
140
00:25:57.060 --> 00:26:08.520
Jason Bekkedam: Okay, so what this is effectively going to give me is the first year that a company took our course okay so we're going to be able to track.
141
00:26:10.230 --> 00:26:18.450
Jason Bekkedam: Our customers or our companies throughout our years Okay, this is really sweet and super useful information.
142
00:26:19.500 --> 00:26:38.940
Jason Bekkedam: i'm going to add it to color here, and the way we can read this cohort analysis is okay everyone in 2016 is colored as blue, if we look at our legend at the top, right here, we have 2016 colored as blue and out of these 214 students.
143
00:26:40.500 --> 00:26:44.340
Jason Bekkedam: We had 115 students continue.
144
00:26:46.230 --> 00:26:49.080
Jason Bekkedam: To take another course in 2017.
145
00:26:51.840 --> 00:27:08.790
Jason Bekkedam: In 2017 We actually had 128 new students Okay, and this is going to go on for each one of these bars, so we can see 2016 has we've had quite a few repeat customers and especially in 2020 2017.
146
00:27:09.570 --> 00:27:19.530
Jason Bekkedam: You know it got it got it the numbers went a little down in 2018 but they've recovered and then there's actually no one that started in 2019.
147
00:27:20.370 --> 00:27:31.320
Jason Bekkedam: So this is the kind of analysis or the code analysis that kind of analysis that's going to allow you to understand okay have my marketing campaigns been working.
148
00:27:32.670 --> 00:27:47.700
Jason Bekkedam: To get new customers, or are they really just maybe bringing back existing customers okay that's your cohort analysis super useful definitely one of my favorite use cases that you'll learn about in desktop too.
149
00:27:50.250 --> 00:27:52.050
Jason Bekkedam: All right, let's take a look at.
150
00:27:53.100 --> 00:27:59.160
Jason Bekkedam: One more use case in desktop too, so this is called relationships.
151
00:28:00.810 --> 00:28:11.280
Jason Bekkedam: Okay, so right now, if we look at our data set, we are only using one table, but oftentimes you want to be able to link different tables in tableau.
152
00:28:12.390 --> 00:28:16.860
Jason Bekkedam: Well, to do that we're going to learn something called relationships in desktop to.
153
00:28:20.100 --> 00:28:30.930
Jason Bekkedam: i'm going to take my company list, right here and i'm going to add it to my fact table via something called a noodle yes, that is, the technical term here for this orange.
154
00:28:32.760 --> 00:28:39.450
Jason Bekkedam: Line it's called a noodle so right now join our client fact table with our company list.
155
00:28:40.620 --> 00:28:46.140
Jason Bekkedam: we're going to choose what kind of ideas, we want to use to join these together so it's.
156
00:28:48.510 --> 00:28:51.390
Jason Bekkedam: Company ID and company ID.
157
00:28:53.550 --> 00:29:04.530
Jason Bekkedam: There we go and now we can effectively have linked this table that has based off of each company a contact name, as well as a contact person.
158
00:29:04.980 --> 00:29:21.210
Jason Bekkedam: Okay, so for burns industries, we have trials Montgomery burns, and we have their phone number ah Well, now we can build a new kind of chart that's going to take advantage of this kind of relationship.
159
00:29:22.830 --> 00:29:24.060
Jason Bekkedam: Okay, so let's say.
160
00:29:25.380 --> 00:29:47.580
Jason Bekkedam: Have a list of my companies, I have the contact person for that company, because I have access to my company lists right, we have our original data set right here, but then we also have our new table that has been linked to our data right So there we go company list.
161
00:29:48.690 --> 00:29:52.290
Jason Bekkedam: contact person let's also add their phone number.
162
00:29:57.090 --> 00:30:10.350
Jason Bekkedam: And then let's add a satisfaction score so for satisfaction score what i'm going to say is I want the average satisfaction score for each company, and I want to sort.
163
00:30:12.300 --> 00:30:23.940
Jason Bekkedam: So you can see Wayne enterprises so contact person Bruce Wayne he is a five out of five satisfaction score right so now if we're if if we're.
164
00:30:24.630 --> 00:30:32.430
Jason Bekkedam: A company that delivers training and we have a really great relationship with with Wayne enterprise, we can say oh.
165
00:30:32.820 --> 00:30:37.980
Jason Bekkedam: We can call up Bruce Wayne here and we can ask them to give us a five minute testimony.
166
00:30:38.310 --> 00:30:54.900
Jason Bekkedam: about how they enjoyed our training, hopefully we'll get more leads, as a result, and this is kind of a list to see Oh, who are my clients that had five out of five right, we have just a bunch at the top here now Bruce Wayne might be a little hard to reach depending on the time of day.
167
00:30:56.310 --> 00:30:58.380
Jason Bekkedam: But maybe we we'd rather call.
168
00:31:00.420 --> 00:31:05.940
Jason Bekkedam: jack shepherd from last there you go well, he might be a little hard to reach to for different reasons, but okay.
169
00:31:06.990 --> 00:31:07.740
Jason Bekkedam: Get the idea.
170
00:31:09.090 --> 00:31:21.270
Jason Bekkedam: So here we go desktop to relationships, also a desktop to we're going to create we're going to add more functionality for dashboards Okay, so if I call this desktop two.
171
00:31:22.620 --> 00:31:23.700
Jason Bekkedam: main dashboard.
172
00:31:26.670 --> 00:31:27.660
Jason Bekkedam: and
173
00:31:28.710 --> 00:31:35.250
Jason Bekkedam: i'm going to use that cohort analysis, as well as i'm going to go back to my bar try for a second here.
174
00:31:37.200 --> 00:31:40.440
Jason Bekkedam: So there we go, we have this quick and easy report.
175
00:31:41.610 --> 00:31:50.340
Jason Bekkedam: let's say I want people to be able to navigate to another dashboard that might have more granular information.
176
00:31:51.690 --> 00:32:04.020
Jason Bekkedam: Right so to do this, we first have to create the other dashboard and then we're going to add some navigation to these dashboards so a call this desktop to contact list.
177
00:32:06.150 --> 00:32:10.830
Jason Bekkedam: i'm just going to use this relationship contact list that we created earlier.
178
00:32:13.860 --> 00:32:25.710
Jason Bekkedam: Okay beautiful and now i'm going to add interaction so in tablo there's something called dashboard actions so i'm going to add a dashboard action to filter over.
179
00:32:27.930 --> 00:32:40.440
Jason Bekkedam: To my other dashboard OK, so my source sheet is going to be let's do our bar chart menu is good find out more information.
180
00:32:43.110 --> 00:32:50.880
Jason Bekkedam: or find out contact information from previous clients for.
181
00:32:53.580 --> 00:33:01.050
Jason Bekkedam: Of course title our target sheets are now going to be that second dashboard I just created okay so desktop to.
182
00:33:01.380 --> 00:33:17.130
Jason Bekkedam: Contact list and let's take a look at what this is actually going to give for us if I go to desktop one accelerated I now have a hyperlink that says find out contact information from previous clients for desktop one and two accelerated I can click on that.
183
00:33:18.120 --> 00:33:32.940
Jason Bekkedam: And we now effectively have our clients sorted by satisfaction score but also, these are clients that took tablo desktop accelerated okay so it's effectively the.
184
00:33:33.750 --> 00:33:53.100
Jason Bekkedam: it's effectively going to filter out this list, depending on the course that you select it Okay, this is one just one of the many actions that you would expect to learn in tableau desktop to and then finally let's go quickly into desktop three.
185
00:33:57.510 --> 00:34:11.100
Jason Bekkedam: So with desktop three we're going to get more abstract and i'm not going to go really into the weeds of it but i'm just going to show you two of the use cases that I like to show in desktop three so do maybe pie chart here.
186
00:34:13.860 --> 00:34:32.100
Jason Bekkedam: let's quickly create a pie chart, so this is something you'll actually learn in desktop to or sorry desktop one but we're going to use a pie chart to create something called embedded analytics so let's take her pie chart if I can remember how to make one i'm just kidding.
187
00:34:44.010 --> 00:35:00.330
Jason Bekkedam: Perfect so we have a pie chart for each one of our courses and maybe I want to know the amount of people for each one of these courses, well, I can take my students at it to label, I can even change my students to be.
188
00:35:03.150 --> 00:35:14.760
Jason Bekkedam: percentages so let's change this to percentage that way, we know exactly because pie charts you know, after all, are but percentages percent of total there we go.
189
00:35:15.930 --> 00:35:27.330
Jason Bekkedam: desktop wanting to accelerated with 26% and then server architecture with 6% so that's great let's do something called embedded analytics so this looks super cool.
190
00:35:29.430 --> 00:35:35.070
Jason Bekkedam: let's say i've created my bar chart once again of my years.
191
00:35:48.000 --> 00:36:00.210
Jason Bekkedam: And I want people to be able to hover over these bars and actually see that pie chart that we just created well super easy to do, I can just add it something called my tool tip i'm going to insert my pie chart.
192
00:36:00.990 --> 00:36:13.620
Jason Bekkedam: And now, when I hover over here we actually have that pie chart showing and the date the underlying data for this pie chart is actually filtered by the year that you're hovering over Okay, so this is.
193
00:36:15.300 --> 00:36:38.730
Jason Bekkedam: These percentages these data values are actually representative of 2018 okay so that's embedded analytics burning go over that in depth in tableau desktop three another use case that I really like is maps are saved up Hello desktop three map.
194
00:36:40.440 --> 00:36:51.300
Jason Bekkedam: So we haven't seen this before we actually don't have any data here, that is, geographical so let's say we did actually just add a locations table now to my relationships.
195
00:36:53.850 --> 00:36:59.220
Jason Bekkedam: Now I have access to geographic data sets that I can create.
196
00:37:03.060 --> 00:37:22.050
Jason Bekkedam: territories, I can create custom territories using this data set so let's say all my clients are in Connecticut and I want to create custom territories to get information off of them well, first of all i'm going to add the amount of clients so i'm going to add the amount of clients.
197
00:37:23.520 --> 00:37:25.680
Jason Bekkedam: To each one of these territories.
198
00:37:27.570 --> 00:37:39.090
Jason Bekkedam: Okay, so we can see 28 right here, new haven county that's our most popular, oh no actually when him county is our most popular county and then the least popular is fart fairfield.
199
00:37:39.480 --> 00:37:47.310
Jason Bekkedam: But let's say I want to actually put these into sales territories, I can just create something very quickly called a group.
200
00:37:48.480 --> 00:37:52.650
Jason Bekkedam: A group these two together and i'll group these three together.
201
00:37:54.390 --> 00:38:01.470
Jason Bekkedam: And I can rename these groups as well, so my blue group i'm going to say Oh, this is my Western.
202
00:38:05.580 --> 00:38:06.990
Jason Bekkedam: Red will be Eastern.
203
00:38:10.290 --> 00:38:11.100
Jason Bekkedam: And then.
204
00:38:13.560 --> 00:38:15.360
Jason Bekkedam: The Center orange will be central.
205
00:38:17.310 --> 00:38:33.000
Jason Bekkedam: Okay beautiful So there we go, we have our territories in something that's super cool now and that something that you'll learn throughout each one of these desktop courses, is how can you deal with hierarchical data sets or hierarchical data structures.
206
00:38:33.420 --> 00:38:45.540
Jason Bekkedam: Alright, so this state and county is actually a hierarchical data set by removing county from my graph here, we now have.
207
00:38:46.350 --> 00:39:03.690
Jason Bekkedam: Each one of our territory is being separated based off of our legend here Okay, so this is a super good looking graph it takes like two seconds, a lot of my students get really excited when they see how to make this we can even add labels here.
208
00:39:05.400 --> 00:39:08.730
Jason Bekkedam: If we want to add some custom here stuff here.
209
00:39:11.460 --> 00:39:13.620
Jason Bekkedam: So let's say territory.
210
00:39:17.970 --> 00:39:20.820
Jason Bekkedam: And amounts of clients.
211
00:39:23.340 --> 00:39:24.630
Jason Bekkedam: let's increase this.
212
00:39:28.170 --> 00:39:28.890
Jason Bekkedam: 15.
213
00:39:30.150 --> 00:39:43.080
Jason Bekkedam: There we go, so we have central the amount of clients of 56 or 43 Eastern was 77 and Western with 56 Now you can also embed.
214
00:39:44.130 --> 00:39:54.600
Jason Bekkedam: That pie chart if we wanted to into our tool tip so we're really going to build some really robust visualizations here, you know what i'm going to do cohort analysis let's do it, why not.
215
00:39:55.890 --> 00:39:59.490
Jason Bekkedam: actually now let's let's stay with pie chart let's keep things a bit simpler.
216
00:40:00.900 --> 00:40:15.000
Jason Bekkedam: Okay beautiful, so now we have that data for our central region, this is our pie chart for that central region Okay, and the pie charts going to change, depending on the region that you select.
217
00:40:17.970 --> 00:40:35.880
Jason Bekkedam: Okay beautiful, we can also create dashboards here in desktop three with this we're mostly going to learn about formatting, so this is something that you'll also learn in the other courses i'm just going to show off a bit of formatting for now so let's say we had.
218
00:40:37.050 --> 00:40:38.850
Jason Bekkedam: Two different two different.
219
00:40:39.870 --> 00:40:52.620
Jason Bekkedam: charts well we're going to talk about sizes so you're going to learn all these different sizing, for instance, maybe you want automatic you want everything to fit to your screen we're going to talk about the pros and cons of this in.
220
00:40:52.920 --> 00:41:11.160
Jason Bekkedam: All of our desktop courses we're going to talk about how can you add backgrounds or borders, even to our visualizations to make them look super sweet Okay, for instance, if I access this screen, I can just add a quick border and background to both my visualizations.
221
00:41:14.940 --> 00:41:28.890
Jason Bekkedam: And we can add a bunch of different and we could, by doing this we're adding some white space to go between archive so white spaces principle and visual analytics that we're going to learn about.
222
00:41:29.850 --> 00:41:44.610
Jason Bekkedam: You know states if you if you want to learn more about visual best practices of talk about that in a second but there we go that's going to conclude the desk or the live portion of this course so let's just go back to our PowerPoint presentation right now.
223
00:41:49.530 --> 00:41:59.520
Jason Bekkedam: And let's talk about two other tablet desktop courses, so this course, I really want to highlight it desktop one and two accelerated people.
224
00:41:59.790 --> 00:42:06.600
Jason Bekkedam: really like to take this course, because it combines the most important parts of desktop one into accelerated.
225
00:42:07.020 --> 00:42:19.980
Jason Bekkedam: You don't have to know anything about tablo to take this course, and it seems to be the best bang, for your buck it's a three day condensed course so you're only paying for three days and your new learn desktop one and two.
226
00:42:20.400 --> 00:42:22.710
Jason Bekkedam: Normally, that would be a four day span.
227
00:42:23.280 --> 00:42:37.320
Jason Bekkedam: And then there's also something called visual analytics, so this is probably recommended after you've taken your desktop courses, if you want to go really deep into how can you create really visually appealing reports, you can take this visual analytics courts.
228
00:42:38.730 --> 00:42:48.090
Jason Bekkedam: We have tableau server, so this is your first you have tableau server administration, so if you want to learn everything around security, governance.
229
00:42:49.110 --> 00:43:00.690
Jason Bekkedam: Access installations, this is your server administration course and then you also have server architecture, so this is going to go more into the weeds of topology of servers so how many.
230
00:43:01.140 --> 00:43:15.060
Jason Bekkedam: How many how much Ram should you be using, how do you install fail overs, how do you have high availability is to make sure people always have access to your reports that's all about server architecture so check that one out.
231
00:43:16.290 --> 00:43:23.370
Jason Bekkedam: And then finally there's two courses associated with tablo prep so there's prep one that's the foundation of tablo prep.
232
00:43:23.670 --> 00:43:31.500
Jason Bekkedam: And then there's also an analyst boot camp, so the analysts boot camp is interesting because it's going to combined desktop and prep to gather.
233
00:43:31.800 --> 00:43:40.920
Jason Bekkedam: This one is actually really, really interesting because it's a five day course it's really going to cover everything you need to know from having that raw data set to.
234
00:43:41.520 --> 00:43:58.620
Jason Bekkedam: Moving it to a data set that's clean enough for tablet desktop and then you're going to also learn the foundations of tableau desktop So if you want to get someone up and going with tableau and five days really analyst boot camp is super super.
235
00:43:59.790 --> 00:44:01.500
Jason Bekkedam: worthwhile checking out.
236
00:44:03.270 --> 00:44:16.530
Jason Bekkedam: Okay, so let's just add let's let's just talk about why you should take these courses so first of all, first of all, you really want to be able to shift to a modern data organization.
237
00:44:17.460 --> 00:44:29.850
Jason Bekkedam: Right now, if you most organizations are moving this way, so you might want to start getting on the bandwagon where you might get left behind right people also really.
238
00:44:31.050 --> 00:44:39.900
Jason Bekkedam: appreciate learning about data okay it's a really hot hot word right now, so if you give them a course about data they'll be really appreciative about about it.
239
00:44:40.530 --> 00:44:48.240
Jason Bekkedam: You also have world class, educators and expertly made curriculum okay I don't want to toot my own my own Horn too much here.
240
00:44:48.780 --> 00:44:54.510
Jason Bekkedam: But with me if you take my my courses with me i'm going to throw in some really interesting use cases.
241
00:44:54.960 --> 00:45:02.790
Jason Bekkedam: Some of them are going to be a bit more silly, for instance, we can take a look at bachelor data yeah the TV show the bachelor i'm a huge fan.
242
00:45:03.390 --> 00:45:11.220
Jason Bekkedam: you're going to be able to take a look at Oh, how can we organize ages from different bachelor contestants in the previous.
243
00:45:11.700 --> 00:45:25.170
Jason Bekkedam: seasons what's the average distribution of those ages of those contestants but i'm also going to look at more serious use cases right, so my background is in economics and business, so we can also take a look at scatter plots.
244
00:45:25.740 --> 00:45:36.000
Jason Bekkedam: and exploring correlations between let's say interest rates and spending or interest rates and savings so we'll take a look at that as well.
245
00:45:36.330 --> 00:45:41.610
Jason Bekkedam: And then, finally, the materials, so these materials are unparalleled tablo spent a ton of.
246
00:45:41.970 --> 00:45:53.640
Jason Bekkedam: a ton of time and resources constantly refining these materials so you know you're going to have the state of the art most up to date, materials and also certifications okay so.
247
00:45:54.570 --> 00:46:00.000
Jason Bekkedam: You can get tablo certifications that you can post on your linkedin So if you tell your employee look.
248
00:46:00.210 --> 00:46:04.110
Jason Bekkedam: you're going to be able to put this on your linkedin it's going to look really good for you so.
249
00:46:04.320 --> 00:46:14.760
Jason Bekkedam: Not only are you going to learn skills are going to help our organization, but it's also going to help your personal development, I find that's a really great way to sell your employees on taking these courses.
250
00:46:15.030 --> 00:46:23.610
Jason Bekkedam: That you know Okay, they can be a little taxing because you're there's a lot of information, but hey there's light at the end of the tunnel you're going to get a certification.
251
00:46:23.910 --> 00:46:28.440
Jason Bekkedam: If you are interested in these certifications here's just a few of them, that you can get.
252
00:46:29.190 --> 00:46:33.930
Jason Bekkedam: So you have your specialist your associate in your professional one thing to note.
253
00:46:34.230 --> 00:46:45.570
Jason Bekkedam: Your specialist for desktop the official course that is recommended to take this specialist exam is actually tablo desktop one fundamentals So there you go.
254
00:46:45.930 --> 00:47:01.320
Jason Bekkedam: take that course you'll be ready to take this certificate, without a doubt, and then there's also servers, so this is for people who are more advanced into server there's an associate in a professional in our courses will definitely help you prepare for this as well.
255
00:47:03.480 --> 00:47:13.350
Jason Bekkedam: Alright, so i've done a lot of talking i'd love to hear back from you guys so are you more likely to attend a tablet training as an individual or as a team i'm just going to launch that poll here.
256
00:47:15.180 --> 00:47:22.800
Jason Bekkedam: please feel free to answer can also say not sure if you're not not too sure it's no problem.
257
00:47:24.600 --> 00:47:28.350
Jason Bekkedam: Okay awesome answers are rolling again beautiful.
258
00:47:29.880 --> 00:47:31.710
Jason Bekkedam: Okay five more seconds.
259
00:47:37.980 --> 00:47:45.750
Jason Bekkedam: Excellent excellent so let's just let's take a look at this for one second so most people so 66% said individual.
260
00:47:47.130 --> 00:47:56.160
Jason Bekkedam: 9% said team and then not sure you know what I find it's great to do individually it's also great to do as a team.
261
00:47:56.610 --> 00:48:14.370
Jason Bekkedam: You can kind of laugh at some data sets, you can have a side chat going just with just your team laughing at some of the use cases we're going to explore but yeah individuals totally fine too, in fact, most of my students are actually individuals in my course So there you go.
262
00:48:15.810 --> 00:48:18.300
Jason Bekkedam: Thanks guys just going to know.
263
00:48:19.710 --> 00:48:21.720
Jason Bekkedam: Past pass it back to Michelle.
264
00:48:22.020 --> 00:48:35.040
Michelle Coppens :: Webinar Producer: Excellent well I am so thrilled to see so many of you are interested in taking training, so let me tell you why you should be choosing exit certified, for your authorized tablo training.
265
00:48:35.460 --> 00:48:50.070
Michelle Coppens :: Webinar Producer: So professionals, just like you have been training with us since 2001 and today we deliver over 9500 authorized IT training courses by more than 25 different brands.
266
00:48:51.360 --> 00:48:59.280
Michelle Coppens :: Webinar Producer: You want to know that your training provider has the credibility to earn your organization's trust, and I can tell you that exit certified delivers.
267
00:48:59.640 --> 00:49:13.950
Michelle Coppens :: Webinar Producer: vendor authorized IT training is our only business when you train in our facilities you'll find well equipped classrooms with friendly staff who are dedicated to make your learning experience comfortable and productive.
268
00:49:14.670 --> 00:49:21.780
Michelle Coppens :: Webinar Producer: And in today's world when you train remotely you'll see that our investment in technology makes online learning.
269
00:49:22.200 --> 00:49:43.020
Michelle Coppens :: Webinar Producer: every bit as engaging as the training, you could take in person, so if you have any questions about why you should take a tablo training course or which course is right for you or any questions whatsoever, I want to invite you to visit our website linkedin the chat and to contact us.
270
00:49:45.030 --> 00:50:04.170
Michelle Coppens :: Webinar Producer: Alright, this is going to move us into the question and answer portion of the presentation and there are quite a few questions queued up in the Q amp a which is fantastic to see so Jason I will, I will just read them out to you and we'll take these off one by one.
271
00:50:04.980 --> 00:50:13.770
Michelle Coppens :: Webinar Producer: Sure alright so first and foremost when did tablo originally develop their authorized curriculum.
272
00:50:15.630 --> 00:50:21.930
Jason Bekkedam: yeah that's a good question I think it's been over five years that they've developed it I don't know for sure.
273
00:50:23.610 --> 00:50:31.560
Jason Bekkedam: But basically, what they're authorized training because tableau software keeps releasing new updates they keep refining their data.
274
00:50:32.880 --> 00:50:46.740
Jason Bekkedam: or their curriculum as new features come out so that's super great, and then we also get users user feedback through surveys and we keep refining that training as well, so yeah great question it's been it's been around for a while.
275
00:50:48.150 --> 00:51:02.910
Michelle Coppens :: Webinar Producer: Very cool and what is the difference between the 90 day free access to e learning on tableau.com and the free E learning that users can already get by going directly to that site.
276
00:51:04.770 --> 00:51:14.580
Jason Bekkedam: yeah that's when I have to double check on that one I haven't really thought of that yeah so we'll have to maybe send out an email for that one.
277
00:51:17.400 --> 00:51:32.070
Michelle Coppens :: Webinar Producer: I met let's see can you speak on how practical it is to invest in tableau with power bi out there being more popular How would one decide which one to be trained on.
278
00:51:33.810 --> 00:51:43.080
Jason Bekkedam: yeah for sure, so I would consider what software you're using within your organization if let's say you're not using any of these software's.
279
00:51:44.880 --> 00:51:52.230
Jason Bekkedam: i'm telling you tablo and power bi are very similar they they both have very similar pricing so really just take a look.
280
00:51:52.590 --> 00:52:01.290
Jason Bekkedam: and see which one feels best for you in terms of being more popular i'd have to take a look at the market share i'm not i'm.
281
00:52:01.770 --> 00:52:13.980
Jason Bekkedam: not too sure it's really buy as much of a wide margin, because yeah after all tablo it's just sold to salesforce last year for like billions of dollars right so it's pretty profitable for sure.
282
00:52:16.620 --> 00:52:28.020
Michelle Coppens :: Webinar Producer: Can you speak a bit on is the sql used for data manipulation or data joins available somewhere or can it be created.
283
00:52:29.850 --> 00:52:39.540
Jason Bekkedam: yeah that is a great question so that's a bit more advanced so basically you can't actually you can't generate the sequel that.
284
00:52:40.440 --> 00:52:42.480
Jason Bekkedam: These visualizations are using.
285
00:52:42.780 --> 00:52:49.620
Jason Bekkedam: But you can go to tablo if you just Google tablo sequel or sequel behind tablo visualizations.
286
00:52:49.950 --> 00:53:04.590
Jason Bekkedam: Go see okay when they put some when they put a dimension on rose we're going to group by rose but there's no way to actually have a very detailed explanation of that sequel within a specific visualization, unfortunately.
287
00:53:07.140 --> 00:53:12.780
Michelle Coppens :: Webinar Producer: And what about social media data can you access the social media data using tableau desktop.
288
00:53:14.370 --> 00:53:27.720
Jason Bekkedam: Oh yeah for sure it's going to depend where that social media data is stored, but one of them, one of them I use for a client is Google analytics you can just connect directly to Google analytics there's a connector there yeah.
289
00:53:30.030 --> 00:53:36.450
Michelle Coppens :: Webinar Producer: And can you speak on the advantages of tableau compared to power bi.
290
00:53:39.630 --> 00:53:50.400
Jason Bekkedam: yeah that's that's a great question number one i'll say you know we I think their training program is better template they they actually in.
291
00:53:51.090 --> 00:54:06.690
Jason Bekkedam: to become a trainer you actually have to go to tablo headquarters for a week and you're going to learn from people who've been in education, their whole lives very experienced people they're going to prep you on different teaching strategies as well, in terms of the software.
292
00:54:06.720 --> 00:54:09.690
Jason Bekkedam: itself, I think it's really going to depend on.
293
00:54:09.840 --> 00:54:16.080
Jason Bekkedam: Are you more experienced using a Microsoft stack so if you're really into as your.
294
00:54:17.370 --> 00:54:21.180
Jason Bekkedam: You might consider using Microsoft, but if you're not really.
295
00:54:22.470 --> 00:54:36.480
Jason Bekkedam: If you don't really know what you're using are using something like snowflake or alter X, I prefer using tableau I just find the connectors and the integration is a little easier on tablo versus power bi.
296
00:54:40.350 --> 00:55:01.590
Michelle Coppens :: Webinar Producer: And does the analytics boot camp specifically or any other course allow for time to work on, or maybe get help with a project that you're working on, in other words can can can a user bring a project to the class and either use that data or ask for some insight with that data set.
297
00:55:03.570 --> 00:55:11.430
Jason Bekkedam: So that that is a tough question so it's going to depend on a case by case basis what i've done in the past.
298
00:55:11.730 --> 00:55:25.710
Jason Bekkedam: Is i've said to a student Okay, if you want to like spend an extra half an hour half hour after the course and we can chat about your use case i'd be happy to do that and then like when students are doing their independent study.
299
00:55:26.580 --> 00:55:38.010
Jason Bekkedam: I can take a look at your use case and offer some suggestions, but if it's like a really, really complex use case it's not going to be within the scope of the course, unfortunately.
300
00:55:39.810 --> 00:55:54.900
Michelle Coppens :: Webinar Producer: And kind of feeding off of that post class support one attendee asked if there are options to add on some type of post course support maybe like coaching instructor time consulting services.
301
00:55:56.100 --> 00:55:58.440
Michelle Coppens :: Webinar Producer: In collaboration with tableau training.
302
00:55:59.850 --> 00:56:00.810
Jason Bekkedam: Oh yeah for sure i'm on.
303
00:56:00.900 --> 00:56:03.990
Jason Bekkedam: i'm also a consultant right, so you guys can also have access to.
304
00:56:03.990 --> 00:56:04.410
me.
305
00:56:07.650 --> 00:56:17.910
Jason Bekkedam: Whether it's it's billable or not let's say this is a very common scenario I have very often with my students, a few weeks after taking the course they'll have like a very quick question.
306
00:56:18.240 --> 00:56:24.840
Jason Bekkedam: about something that they think it was covered in the course or maybe something that wasn't even covered in the course if I know the answer.
307
00:56:25.260 --> 00:56:31.380
Jason Bekkedam: i'll just send you guys that quick email with the answer or i'll point you to like a blog posts.
308
00:56:32.040 --> 00:56:46.800
Jason Bekkedam: With the resources that you'll need to answer your question i'll never leave you dry, but if you still need to for me to take a closer eye at your use case you know you could also discuss some consulting work with you guys as well i'm happy to do that.
309
00:56:49.620 --> 00:56:58.110
Michelle Coppens :: Webinar Producer: And let's squeeze in one more question can you share a couple of real world examples where tablo prep would be necessary.
310
00:57:00.060 --> 00:57:02.430
Jason Bekkedam: yeah so in tableau.
311
00:57:04.740 --> 00:57:10.110
Jason Bekkedam: And tableau most data structures they're going to use are going to be a tabular data structure right so.
312
00:57:11.730 --> 00:57:18.630
Jason Bekkedam: With that in mind if your data set isn't a tabular data set you're going to run into some issues when you're using tablo.
313
00:57:18.900 --> 00:57:29.820
Jason Bekkedam: Now these aren't very common most use cases are going to be tabular data set but, for instance, I was working with a government agency on how they can track their.
314
00:57:30.270 --> 00:57:37.860
Jason Bekkedam: covert infection, so how can you draw a line from one person to another to another to another I ended up using tableau prep.
315
00:57:38.190 --> 00:57:48.420
Jason Bekkedam: Because the data source that they were using was an actually in tabular form it was actually in javascript object form right so you're able to take that javascript.
316
00:57:48.930 --> 00:57:57.930
Jason Bekkedam: javascript object and basically put it through a series of tools to transform it into a tabular data set to move it to tablo.
317
00:57:58.380 --> 00:58:08.520
Jason Bekkedam: So they're just like anytime that data set isn't tabular you might want to use tableau prep and then the other big use case I see tablo prep use for is data quality.
318
00:58:09.000 --> 00:58:24.030
Jason Bekkedam: You can actually test how many nodes you have in your data set maybe you're joining data data together and you want to say oh what's that joint actually successful, how can I evaluate the quality of that joint that's where a tablet prep really comes into play in the super helpful.
319
00:58:25.080 --> 00:58:36.300
Michelle Coppens :: Webinar Producer: Excellent well, we are at the end of our session there were a couple of questions we didn't get to i've noted those down and we'll try to either answer them in a blog post or connect with you directly.
320
00:58:36.600 --> 00:58:41.670
Michelle Coppens :: Webinar Producer: i've also shared our the exit certified link once again in the chat window.
321
00:58:42.390 --> 00:58:51.420
Michelle Coppens :: Webinar Producer: to learn about the prerequisites for the course or to speak with one of our coordinators, you can contact us by visiting our website.
322
00:58:51.960 --> 00:59:06.090
Michelle Coppens :: Webinar Producer: Thank you so much Jason for this informative session Thank you everyone for taking some time out of your day to attend as a reminder we've recorded this session and we'll email it out to everyone so keep an eye for a follow up message from us.
