Hex Region Maps in QGIS and Why Build for Tableau Public with Iaroslava Mizai and Vladyslav Horbachenko
Where Ideas Become Vizzes: Inspiration, Creativity & Tableau Public
1h 21m 10,377 words transcribed
Summary
The Poland Tableau User Group's third-quarter meeting looks to its neighbours: host Agata Mężyńska welcomes two Tableau Ambassadors from Ukraine, Iaroslava Mizai and Vladyslav Horbachenko, both with Viz of the Day wins and Vizzies to their names. Iaroslava, a freelance data analyst presenting from Kyiv, starts with the people and resources that inspire her maps: Tableau Public's Viz of the Day, Alberto Cairo's The Functional Art, the Flerlage twins, Dennis Kao, Teddy Iskandar, cartographer Jonni Walker, Naresh Suglani, the Data + Maps TUG, Andy Kriebel, Makeover Monday and Workout Wednesday. She explains that her terrain backgrounds are rendered in QGIS from real elevation models rather than generated with AI, then, despite connection drops, walks through building the hex-region shapes behind her call center dashboard: setting the EPSG:4326 coordinate reference system, adding a hex shapefile as a vector layer, merging selected hexagons into regions with Dissolve, combining them with Merge vector layers, saving a permanent shapefile, and joining it to data in Tableau for a region-to-state drill down. Her step-by-step guide and Python code are on GitHub. Vladyslav, a data analyst at Ukraine's largest logistics and postal company, then tells how he went from an accounts receivable job he disliked, through the Google Data Analytics certificate, YouTube tutorials and Next Level Tableau, to downloading and dissecting Tableau Public vizzes, months of work with almost no feedback, a Ted Lasso data story, a surprise Viz of the Day nomination, and a Tableau Conference award he could not leave Ukraine to collect. He closes with three reasons to build for Tableau Public: you learn skills that outlast any tool, you meet people, and wonderful things you never expected can happen.
Listen to this TUG
Prefer to listen? This meeting is also an episode of the Tableau TUG recordings podcast.
Resources
Key points
- Tableau Public's Viz of the Day is a daily source of new techniques, people and ideas.
- Map backgrounds can be rendered in QGIS from a real digital elevation model and dropped into Tableau as background images, with no AI involved.
- Tableau can build a hex map, but merging hexagons into region shapes is far easier in QGIS.
- Check that a new QGIS project uses EPSG:4326, the standard coordinate reference system for shapefiles; Tableau reads it.
- In QGIS, select hexagons with Ctrl-click and run Dissolve on the selected features to merge them into one region, then Merge vector layers to combine the regions into a single shapefile.
- Make temporary layers permanent and keep all of a shapefile's companion files together in one folder, because Tableau needs them.
- Picture the result you want first, then find a way to build it with QGIS, Mapbox or Python.
- Downloading vizzes you admire and taking them apart teaches what courses and videos do not.
- Weeks of work can earn only a handful of views; keep going and build things you genuinely care about.
- Skills learned building in Tableau carry over to whatever tool comes next.
- Building for Tableau Public brings a community of people who will help you.
Jump to a chapter (32)
- 0:00 Welcome to the Poland TUG third-quarter meeting
- 0:51 Meet Iaroslava Mizai and Vladyslav Horbachenko
- 3:51 Iaroslava: freelance data analyst and Tableau Ambassador
- 5:34 Resources that inspire: Tableau Public, Alberto Cairo, the Flerlage twins
- 7:23 Map makers to follow: Dennis Kao, Teddy Iskandar, Jonni Walker
- 11:29 Terrain backgrounds built from elevation data in QGIS
- 13:14 More inspiration: Naresh Suglani, Data + Maps TUG, Andy Kriebel, Makeover Monday, Workout Wednesday
- 18:26 The call center dashboard and its hex regions
- 20:25 QGIS basics: a new project and the coordinate reference system
- 22:24 Connection drop and restart
- 25:43 Adding the hex shapefile as a vector layer
- 29:33 Merging hexagons into regions with Dissolve
- 33:41 Merge vector layers and save a permanent shapefile
- 37:16 Joining the shapefile to data in Tableau
- 42:57 Region-to-state drill down and the GitHub guide
- 46:16 Start with the result, then find the tool
- 49:10 Vladyslav: why I build for Tableau Public
- 50:27 From accounts receivable to data analytics
- 53:49 A Tableau course that was all theory
- 55:28 First Tableau dashboard ever
- 56:59 Learning Tableau on YouTube and a first analyst job
- 58:48 Discovering Tableau Public
- 1:00:11 Downloading dashboards and breaking them down
- 1:01:25 Weeks of work, almost no feedback
- 1:03:55 Next Level Tableau and a Ted Lasso data story
- 1:09:25 The Viz of the Day nomination
- 1:10:57 Building things you love
- 1:11:53 Speaking, writing and a Tableau Conference award
- 1:13:23 Reason one: you will learn a lot
- 1:15:40 Reason two: people
- 1:17:05 Reason three: wonderful things can happen
- 1:18:53 Thanks and close
Transcript
0:00 Agata Mężyńska: Welcome, everybody, to this third quarter meeting of Poland Tableau User Group.
0:08 Uh, usually during the online meetings of Poland User Group, we try to introduce everybody around to some interesting stuff connected to Tableau that has also something to do with Poland. This time we have extended the borders, and we think about our part of Europe.
0:29 As last year when I joined Tableau Conference, I was more than proud to hear that two, uh, next-door neighbors from Ukraine have just won Vizzies.
0:42 And living that close and thinking about that from US f- feels just like next-door neighbors.
0:51 Uh, so, uh, please welcome, uh, Iaroslava Mizai and Vladyslav Horbachenko, who will join us today. And these are not just any guests. These are very special guests. Uh, uh, I could now quote, uh, their prizes. Both of them have got some, uh, the number of Viz of the Day, and also, uh, all of us in this, in this small group, we are, uh, ambassadors.
1:22 Uh, Iaroslava is for the third time and, uh, Vladyslav-
1:26 Iaroslava Mizai: Second
1:26 Agata Mężyńska: …
1:27 for s- second? Okay.
1:28 Iaroslava Mizai: Second. Third time.
1:30 Agata Mężyńska: Three time. Third, okay.
1:33 Iaroslava Mizai: Yeah.
1:33 Agata Mężyńska: Yeah, and Vladyslav is for the first time, so I'm for the second. One, two, three, everything matches.
1:40 Uh, but actually, what I am really proud of is that I have invited people who really do great stuff in Tableau. So if you have ever seen works of Iaroslava, they have two common features. They are always very well done, very beautifully done, and also usually socially… somehow socially engaged, some- w- with some important message.
2:12 So thank you, Iaroslava, for that, and thank you for the fact that you will be sharing with us some of your secrets.
2:19 And then, uh, the story with Vladyslav was quite different. I have heard of Iaroslava before quite a few times, and then last year I took the course, uh, organized by, uh, uh, Iryna Demko, uh, about, uh, statistics in Tableau, and I met there Vladyslav. And, well, we didn't have, uh, in the course as… too many chances to interact, but I looked at the works of different people who joined the course, and I was really surprised that there is someone whom I haven't yet heard before and whose works I really, really love, and that was Vladyslav.
3:01 So, uh, today you will hear presentation of two… presentations of two people whose work I really, really admire.
3:11 Um, usually in Poland, I, I haven't asked you, uh, who should start first, so, mm, okay. In Poland, usually we start with women. Sorry, Vladyslav. So Iaroslava-
3:23 Vladyslav Horbachenko: Same in Ukraine. Nothing different.
3:25 Agata Mężyńska: Same in Ukraine? Okay. So in our part of the Europe, we behave so.
3:30 Uh, so Iaroslava, would you tell us a bit of, about your work and your favorite tool?
3:36 Iaroslava Mizai: Okay. I'm not so, you know, gender oriented and I don't care about, uh, when I start.
3:43 Agata Mężyńska: Okay.
3:44 Iaroslava Mizai: But-
3:44 Agata Mężyńska: I was… Just to cover my mistake, I should have asked you earlier who wants to start.
3:49 Iaroslava Mizai: Yeah. It's no matter for me. And, um, what should I tell about myself?
3:55 I'm s- three-time ambassador, and, um, I'm data analyst, uh, l- tonight… today I work like a freelancer. I have a contract with US company, so I'm creating a dashboard for this company.
4:12 Sor- sorry if, uh, it was broken.
4:14 Uh, I work as data analyst, uh, as a freelancer, and I have a contract for a US company, and it was US company, so I create some dashboards in regular life. Uh, but, uh, also I try to create my, you know, creative, uh, uh, creative dashboards for Tableau Public. It's like my hobby, but, uh, most time I create analytical and most, uh, and more boring dashboard, uh, rather than on Tableau Public.
4:47 Uh, today I will start to share my, uh, presentation with you. I want, I want share with, uh, you some, you know, some tricks. Uh, so my presentation, uh, contains two parts. First part is about, um, uh, is about people and, uh, resources, uh, who INSPIRE me, uh, who ins- uh, inspired me and, um, I want, uh, to show, uh, some pages for you.
5:17 Uh, first of all, uh, it will be… Yeah.
5:21 It's about, little about me. It's my contact, uh, on, uh, Tableau Public, and, uh, my Tableau Public page and LinkedIn page, so you can connect or write me if you have some questions.
5:34 I would love to share, uh, with you some resources. Uh, first of all, you know, general pages about Tableau Public.
5:43 So, uh, first, uh, first of all, main inspiration for me is Tableau Public general page.
5:50 Uh, there is a Viz of the Day. There are a lot of cool stuff. You can see all of the… Every day we have a viz of Day.
5:59 And, uh, it's main inspiration for all ambassador, main source to, uh, see new solutions, new people, uh, new tricks, and everything interesting you can find on this page.
6:13 But, uh, also I would love to share with you some useful, uh, contacts, and probably pages.
6:21 It's about, uh, probably you know, uh, famous, uh, data v- uh, data Uh, m- m- designer or, uh, artistic designer, Alberto Cairo.
6:34 Pro, uh, he's famous, and he's like a, uh, you know, top for me, for, uh, uh, top person for me. I always read his book, is The Functional Art. It's about basic, um, basic, uh, principle of data visualization.
6:52 Also, I would love to share with you some, uh, inspiring resources.
6:58 It's, uh, of, uh, brother Ken, uh, and Kevin. They are twins. They created a very useful blog, so you can read about this, uh, uh, guys, and you can also read about cool stuff they create and learn about new, you know, new, some s- s- tricks, new, uh, forms to, and new solutions and similar.
7:24 Also, I would love to share with you, uh, probably one of the most interesting user, Tableau user.
7:32 Nyarsmegler has a lot of interesting stuff, especially maps.
7:38 So, uh, you can observe his page. There are a lot of interesting solutions, and he's ambassador, too, and, uh, he creates a lot of interesting visualizations. Always you can find some of them. You can find, uh, as visual of the day.
7:55 That's cool stuff, especially on historical, uh, events or some historical location. It's really cool page.
8:04 Also, you, uh, one of the most interesting is, uh, cartographer, uh, not cartographer. He's, um, uh, he's, uh, he's, uh, uh, map, map evangelist for me.
8:19 Uh, Dennis Kao, he's, uh, head of, uh, Tableau User Group. Dennis Kao usually create very creative maps. You can find his page very interesting, and there are a lot of maps, too, especially, uh, uh, as, as, uh, he, he doesn't, uh, specific of his works, uh, that he doesn't, uh, use, um, uh, AI. He only use, uh, data, and he use, uh, own, you know, uh, his own maps.
8:53 He always, uh, try to be original in his, uh, project, and I always observe his projects. Each project, uh, is unique, is, uh, you know, a, a lot of, um, interesting solution, and you can download this, uh, project and recreate this project.
9:14 About sources, uh, uh, another very interesting source and inspiring source is a page of Teddy Iskandar.
9:23 Teddy, uh, is, was, uh, a Tableau ambassador, but I don't know he, uh, if he ambassador this time. But he creates, uh, a lot of maps about his, uh, hi- his country. You can observe, uh, and there are a lot of amazing solutions and design, especially design solution on his maps.
9:47 So you can scroll, and each map, map is unique. And you can teach from, uh, you, you can learn from his project and, uh, inspired by his projects.
9:59 So, uh, uh, another person is, uh, Jonni Walker. Jonni Walker is like a cartographer. He's cartographer, but he was a Tableau user.
10:12 I c- couldn't find his profile, but you can find his project, uh, for example, on Medium.
10:19 Do you see this article?
10:21 Uh, sorry, no, not article. His, uh, page, I guess.
10:26 Yeah.
10:27 Uh, he- y- you can see his, uh, projects, uh, on his page. Uh, he creates some, you know, eleva- uh, digital elevat- uh, elevation maps. Uh, a lot of interesting, uh, pictures, a lot of interesting solution, and as usually, he, uh, explain how he created these projects. Uh, uh, most of these projects were created in different, uh, tools. As I know, uh, he worked with, uh, so popular tool, uh, like, uh, Mapbox.
11:00 Also, I know that he created some solution in, uh, QGIS.
11:05 So I always observe his page and read articles, uh, his articles on, uh, Medium, and, uh, I usually try to follow his style. Probably you notice that I have, um, you know, I have some, um, some, some maps similar to his style with some elevation Mo- Mo- moments like this.
11:30 Uh, I create some, uh, I created some map like, like this one about, uh, volcanoes, about some, uh, thermal, uh, zo- areas.
11:40 And in this project, uh, I inspired actually from, uh, Jonni Walker, and in this project, I tried to use only data.
11:51 All these pictures on, behind this, uh, on, on this dashboard, um, uh, they are, mm, uh, they are generated in QGIS. So, uh, all this picture based on real, uh, uh, data elevation model.
12:11 And, uh, I don't use, uh, AI to generate pictures at all. So all, all, everything is created, uh, from data.
12:22 So, uh, mm, it's not a principle to avoid AI, but, uh, I try to, uh, create as much as I can in QGIS. It's like a hobby to, to do this, uh, and develop my skills.
12:39 So also I can, um, share some project, uh, project with you, my projects. Uh, it's about, uh, uh, monarchy and about this, um, uh, this, the Viz of the Day. It's, uh, cr- it was created in QGIS, uh, 2. This background map was created in QGIS 2.
13:00 Uh, you see some little elevation. And, uh, how I created this, it was created in… It firstly created image in QGIS, then exported image as a background, uh, for this dashboard.
13:14 So the next one, uh, in my, m- in my list is Naresh, uh, Suglani. Naresh Suglani is really, uh, really, really, you know, inspiring, uh, person. I don't know, uh, he, uh, probably he was… Uh, yeah, he was ambassador in previous years, but now it's, he's not ambassador. He's a really cool analyst, but he combine, uh, his dashboards with really, m- impressive maps.
13:42 And every time I really, uh, you know, I'm really jealous. I really, uh, want to have such skills, uh, to create similar, uh, maps. Uh, he's really cool, and each map is really original. Each dashboard is r- awesome, so.
14:01 I inspires every time from his page. It's, like, one of top sources.
14:08 Also, I try to follow, um, Teddy Iskandar. I told about this. Uh, I try to follow, uh, such group, like, uh, uh, Tableau user group, like Data + Maps Tableau User Group. They have a lot of cool events.
14:27 Uh, sorry.
14:28 They, they have a lot of cool events.
14:31 Uh, I can open this now.
14:34 Uh, but, um, you can see some, uh, so you can see some different solution. Uh, users present, uh, some solutions from, uh, Mapbox, from QGIS, and next week probably they'll have, uh, some event too, so please follow their group and join. You will see a lot of cool stuff and explanation about maps.
14:57 And, uh, uh, I have a lot of sources. My advice is to follow such list of people and, uh, resources.
15:06 Uh, this is, uh, this, uh, uh, list of people and resources which are g- good for practice. Andy Kriebel, I guess, Kriebel, he has, uh, a cool stuff. He creates a lot of data visualizations and share how, uh… and share his project on his page.
15:25 He a- he also has some free workshop. You can, uh, follow his, um, uh, page, and, uh, he share o- on LinkedIn, mostly on LinkedIn, he shares his, uh, um, solutions and, uh, uh, inv- invitation of hi- invitations, uh, on his workshops. Please follow him, and you will find a lot of cool stuff. Uh, you can recreate some dashboards. You can download some dashboard, but some dashboards you can't, 'cause he has a private school, unfortunately.
15:58 But not all is fr- everything is free.
16:00 Uh, also you can, uh, see as, uh, y- you can probably have seen, uh, some interesting hashtags in LinkedIn, uh, like, uh, Makeover Monday. It's a popular, uh, resource, uh, about some competitions. You can, uh, follow, uh, this resource and see some interesting submissions, uh, about, uh, different, uh, topics. They ha- they share, uh, datasets on their, um, on their resource, and you can download this datasets and, uh, recreate such dashboards or, uh, f- recreate some style of such dashboards and submit your works, uh, and, uh, share this in LinkedIn.
16:45 So it's cool to join such society and share and spread your skills, uh, in LinkedIn with, uh, all people, with, uh, other users.
16:56 Also, you can, uh, find Workout Wednesday. It's really, really popular, um, hashtag, uh, W-O-W, yeah, in LinkedIn too.
17:07 Uh, there are a lot of, uh… This page, uh, contains a lot of interesting solutions.
17:14 It's about, uh, uh, different topics, but you can download each, uh, dashboard, and you can, uh, recreate. You can read how t- it was created. You can recreate and publish your submission and participate in such kind of competition, how to create, uh, your own version of this dashboard or recreate this dashboard. So it's cool stuff too.
17:40 Uh, Mo- uh, another very cool page, I always observe this. Sorry, Adrien, but I'm cheater.
17:50 Uh, I observe his page. Adrien Zenou has cool re- really cool s- dashboards, really cool solutions on different, uh, topics. He, uh, participated in Iron Viz too, so you can inspires from this person. It's, you know, it's, uh, like, his main source for inspiration. Most people, uh, s- uh, include him in inspiration on dashboards, so it's really cool place to inspires, inspi- for inspiration.
18:24 And, uh, I would love to share with you another part of my presentation. I don't know if you'll see, if, if you have seen, probably have seen the dashboard. It's about, uh, a, uh, call center, uh, dashboard. It's about, uh, this one Uh, I will make this less.
18:48 Uh, this dashboard, it was created, uh, mm, in, in specific way. It's created… It was created with, uh, QGIS, uh, with, uh, shapes which, uh, I created, uh, in QGIS. So this is one little chunk, yes, was created in QGIS. Uh, why I created such map in QGIS? Uh, because, uh, Tableau, um, uh, you can't create such shapes inside of Tableau. You can't, um…
19:21 You can create, uh, something like this. You can, um, create a he- hex map inside of Tableau. There are a lot of calculation, uh, explanation how to do this. It's, uh, about hex map. Uh, but, uh, you can't… My idea was to create, uh, um, something like, uh, uh, regions, uh, with combined hex- hexagons. So it was real problem in Tableau. I couldn't find some, you know, uh, solution.
19:53 It's not… Actually, it's not impossible to join, uh, hex in this way in Tableau. So I decided to experiment with QGIS, and created this part in QGIS.
20:08 Uh, we have, uh… I, I, uh, if… I tried to share with you how, uh, I created this. Um, hope you will see this. Uh, please, uh, prove that you see, uh, QGIS.
20:24 Vladyslav Horbachenko: Mm-hmm.
20:25 Iaroslava Mizai: Yeah.
20:25 Vladyslav Horbachenko: Yeah.
20:26 Iaroslava Mizai: I opened QGIS. QGIS you can download from internet. It's free, but there are, there are some paid, uh, pay- paid versions of this, uh, so, of this, uh, program, but, uh, you can use this for free actually.
20:44 Uh, I use free version, so it's enough for me to create some shapes, uh, and, uh, work, uh, for, for to create some, you know, some stuff, uh, basics, uh, image, uh, in QGIS free, free version.
20:58 In this case, I want share with you how to create this, uh, this, uh, shape, uh, that I created in, uh, uh, for this dashboard, how I created this region- regional shape. So, uh, I can open this, uh, uh, QGIS and create new project. For new project, you can go to this, uh, menu, open new, and you cre- you can create, uh, su- such new project, and when you start, before start, uh, before this, uh, start to work with, uh, shape, uh, mm, you must check, um, it's kind of, uh, uh, coordinate reference system.
21:43 It's, uh, you can check this in this corner, right co- corner, uh, on this, uh, in this program.
21:50 You can see this, uh, if you see something, uh, another, for example, another number, it must be, uh, uh, two, uh, four, three, two, six, yes. If you have another numbers, you should, uh, fill, uh, this, uh, filter and find this. When you start to fill, uh, filter this, four, three, two, six, you will see coordinate systems. It's, uh, this coordinate system is a standard for sh- uh, for shapefiles.
22:20 When people create shapefiles, uh, uh, most-
22:24 Agata Mężyńska: Okay. There is a short break, and probably it, you should think about it, about the problem with, uh, connection, and I guess we will hear Iaroslava in a moment again, or let's keep our fingers crossed for that.
22:45 Well, she just said before that it might be link… It might be, be the problem that has something to do with air defense, uh, in Kyiv, so as she's presenting from Kyiv. So let's just be, uh, patient for an- be patient for another minute, and let's hope she comes back.
23:09 So yeah. Iaroslava, can you hear us?
23:14 You got again your-
23:15 Iaroslava Mizai: Yeah, yeah. Sorry.
23:16 Agata Mężyńska: Okay.
23:16 Iaroslava Mizai: It was, uh… When it, when it's, was broken, I hope, uh, it was on this place. I will share screen with you.
23:23 Agata Mężyńska: You were in-
23:23 Iaroslava Mizai: Uh-
23:23 Agata Mężyńska: … just in the beginning of presenting cookies, and you were presenting this reference number.
23:29 Iaroslava Mizai: Yeah.
23:29 Vladyslav Horbachenko: Yeah, you said that-
23:30 Iaroslava Mizai: Yeah, screen
23:31 Vladyslav Horbachenko: … standard, international standard.
23:32 Iaroslava Mizai: Uh, yes.
23:33 Agata Mężyńska: Yes.
23:33 Iaroslava Mizai: It's international standard, uh, when you, uh, or create new da- new, um, uh, new project.
23:38 Agata Mężyńska: And you need still to share your screen.
23:41 Iaroslava Mizai: Yeah, just a second.
23:43 Agata Mężyńska: Once again.
23:45 Iaroslava Mizai: Yeah.
23:46 You should see this now.
23:48 Agata Mężyńska: Almost.
23:50 Iaroslava Mizai: Yeah.
23:50 Agata Mężyńska: Yeah. We're, we're-
23:51 Vladyslav Horbachenko: Mm-hmm.
23:52 Agata Mężyńska: Thank you a lot.
23:52 Iaroslava Mizai: Uh, when you created even… S- sorry for this break. Uh, when you created this new project, you have a special, uh, numbers on the right honor. It's about standard, um, coordinate reference system. When you press on this, uh, numbers, if you have something different, you can change actually in this place or in, uh, uh, project, press project, and select some set, uh, uh, project settings, and change this reference system.
24:19 Uh, when you start to type, uh, four, three, uh, two, six, you will see, uh, you will filter out this reference system.
24:28 This, uh, this is standard, uh, for shapes. Uh, when most shapes are created with this, uh, reference, uh, coordinate reference system, and Tableau can read this too.
24:40 But, uh, Tableau has own reference system, uh, it's pseudo-Mercator, uh, with, uh, numbers, I guess. I'm cheating. Uh, three, eight- 97, I guess.
24:52 Uh, but, uh, most shapes are created with this, um, coordinate reference system. So, uh, in this case, we will, uh, we will work with such a shapefile. So I had a shapefile, I had created this. I will share with you all my, um, GitHub repository, and I de- described, uh, all this process, how to create such shapefile in Python in QGIS.
25:19 So you will work with, uh, uh, Python 2. If you are fa- familiar with this, it's really cool, but if you are not, you will…
25:28 can create this manually, but you need a shapefile with he- hexagon map for start. So imagine that you have-
25:36 Agata Mężyńska: I'm afraid we've got problems again.
25:39 Iaroslava Mizai: Yes.
25:40 You hear me?
25:40 Agata Mężyńska: Oh, you're back.
25:41 Iaroslava Mizai: Yeah.
25:41 Agata Mężyńska: Yes.
25:42 Iaroslava Mizai: Uh, when you… If you have such a file or you created such file-… uh, no matter actually, so you can…
25:51 If you create that you will have this in- inside of you Q- QGIS. Imagine you have downloaded this, uh, file from some source. In this case, I will share with you my, uh, my shapefile, and you can add this layer, uh, this shapefile as a layer into QGIS. For this, you should press layer in menu, and select add layer, and, uh, select add vector layer.
26:16 Shapefile is a vector, so you c- should press this.
26:21 Uh, you will see this window, and you should select, uh, uh, this, um, this three, uh, dots. Little three dots, and you select, uh… You should find your, um, your shapefile. Uh, as usually, shapefile shared in some, uh, you know, zip, zip files or, uh, folders with some supporting, uh, sha- uh, files. It's about metadata, about indexes, and, uh, projection too.
26:49 So when you, uh, have such folder or unzipped file, you will get all this set of files.
26:56 Uh, first of all, you should select shapefile. It's have a shape. You can read the shapefile. Select the shapefile, and you have, uh, standard settings. It's no matter for this, for this time.
27:10 Uh, you just add this, and close.
27:14 You will see, so this is a final, my final map, which I will create, and, uh, is, um, it's, well, it's result, yes? And another layer I will show add layer, add vector layer, and this, this one, files, I have a US hex map.
27:36 It's a hexagonal map. Select shape again.
27:40 This map is, is… Close. This map we sh- we have for start. So we have two shapes in this case.
27:48 But imagine we don't have this final, you know, final s- s- shape. We have, uh, we have s- imported start shape.
27:59 Uh, we should transform this shape. So tra- any shape can be, can be transformed. Uh, uh, in my case, uh, I selected some regions, um, to create some, you know, some, uh, this map. I, I splitted the US map on some regions, like five parts.
28:17 It's about, uh… I'll go back. I will show this on my, uh, Tableau.
28:25 On my Tableau. Do you see my Tableau?
28:27 Agata Mężyńska: Yes.
28:27 Iaroslava Mizai: Yeah. Uh, reset button. Should… Sorry.
28:31 Reset button.
28:35 Uh, I have this, uh, this, um, uh, this map in this case. Uh, I created, uh, this, uh, region. I splitted my, uh, basic map on some regions like, uh, uh…
28:48 Reset button. Like this. I splitted, I joined this, uh, uh, hexagons, uh, and created like a general shapes.
28:58 So in this case, I must, uh, read… When you, when you import this shapefile, for example, uh, in QGIS, you see this, uh, s- such, uh, tiles, uh, uh, such hexagons as separate, mm, elements. You should combine some s- these elements by selecting and grouping in, in regions like this, like I showed before. So, uh, like, mm, like this one.
29:25 Like this. Yeah.
29:26 So I found solution how to do this. It was, um, it… First of all, we should find how to do this. Yes.
29:34 Uh, you should go to menu and, uh, press processing. It's, uh, it has toolbox.
29:39 In this toolbox, you should se- select and, uh, you should, um, select some, um, settings like dissolve. Dissolve.
29:52 Yeah.
29:53 Uh, dissolve helps to join such elements in regions, but you should select such-… such re- such, um, uh, states in, uh, one by one. For this, you should press on this button. You select this. Select, uh, by features. Features in this case is, uh, each tile.
30:12 It's e- each hexagon.
30:14 You press this, and after this, you can keep Ctrl and press on each… Keep Ctrl and press on each element. You select somehow, yes.
30:27 In this case, we must create something like this. So something like this. Yes. So try to, to, to create the same.
30:35 Maybe it's not some, some- something similar I create. I just… I don't remember all states, but if you remember, uh, states, you can create this region somehow. Ctrl and press.
30:49 For example, this one is my region.
30:53 And, uh, you press dissolve. You selected your, your future area. For example, it's about west region. You selected more one, yes?
31:04 And you should press dissolve.
31:07 Dissolve can join all these elements in one region.
31:12 You can select, um, uh, first of all, you make sure that you work with y- this correct map. In this, mm, in this case, we correct with US hex map. It's correct, not in with US regions.
31:25 Uh, also, we should select, uh, some features, uh, which we will, uh, join. So select features only, so it will join these features.
31:36 And then you create a temporary file or a permanent file. You can create permanent file or temporary.
31:44 Uh, let's create, uh, let's create, say, uh, let- let's create west as a temporary. West.
31:55 Okay, and press run.
31:57 Okay, close. We see this region, yes? It's like, uh, joins, uh, hexagon in one area.
32:06 The same we can do with another. For example, you select this. Uh, you can, you must, uh, press, uh, again, feature. Yes, select feature. You must, uh, press control and select some regions. But you, you can't do anything in this case 'cause your, your layer is not active. You should activate your layer. Press U- US hex map, and select all this, uh, region, uh, all these states in your region.
32:33 For example, I'm not, uh, sure that it's correct, but, uh, correct, uh, set of states, but let's select the states and create, uh, another re- region.
32:44 Press dissolve again, and again, you do the same. Select feature only, and create, for example, uh, center. Center.
32:54 Yeah, like a, it's like a temporary file.
32:59 Run again, and you will get z- another layer, and you'll get this one shape.
33:06 So you have west, center, and you continue to create each region in this way.
33:13 As a result, you should give, get something like this.
33:17 This, yes.
33:18 You should get some region like this.
33:23 But all these regions, uh, all these regions, yes, they exist separate.
33:29 They, they are layers. They are, uh, like a different, uh, shapes in this case. You must, uh, join them in one sha- shapefile. So in this case, you press processing again, toolbox, and select, uh, merge.
33:48 Merge vector layer 'cause we work with vector, yes?
33:52 Merge vector layers and select this.
33:56 In this case, you'll have a men, uh, menu with, uh, selecting input layers.
34:02 Press these three, three dots, and select th- all these four, for only four, uh, I'm sorry, in my case, five regions. So we must select the Washington, DC too as fi- five, five re- fifth region, and you select, um, uh, Midwest, Northeast, South, Washington, DC, and West. Yes, five.
34:28 And press run.
34:31 Close this. And you will get something like merged.
34:36 Merged, yes?
34:37 Mm-hmm.
34:37 Iaroslava Mizai: Let's, let's put them on top. Move on top. And you will see that we get this map with all regions. So we have all, West, um, West, North, East, Midwest, uh, South, and Washington DC in this shapefile. After this, you should export this file. It's temporary file. You see this sign, little, like a little sign about temporary file. Yes?
35:06 Uh, you should save this file as a, a permanent one. For this, you press, uh, right button, uh, and make permanent. Press this.
35:18 This, you should s- s- select what kind of file you want. In this case, so we have is this menu, and shapefile as a default value. You select shapefile, then you select place where you want to save your files. In this, uh, s- in this case, we will create f- a folder.
35:37 For example, you ha- you have a US, uh, regions. Yes? You have regions folder for this file, and you will generate a, a set of files and shapefile in this folder.
35:52 Open this one, and you start to type this, like a US regions shapefile.
35:58 Save.
35:59 And you have a, a, like a route, uh, to your shapefile. It will be in this place.
36:06 After this, you can create, you can press okay. Yes?
36:11 I will cancel 'cause I have this file. Cancel.
36:14 And you g- should get su- such, uh, s- this layer, this layer on top. I just move this on top. You should, should get this, uh, permanent US regions, uh, file in your QGIS.
36:30 It means, uh, QGIS automatically shows this in your QGIS source, and also you have this QGIS fi-, uh, you have shapefiles in your files where, uh, you have folder regions.
36:44 You save these files in, uh, this folder.
36:48 When you open, you see five files in this, uh, six files in this folder, and you have one file, sha- shapefile.
36:56 As usually, I should save all these files in, in one folder. Uh, it's… It must be in one folder, 'cause, uh, this, uh, file has, uh, these files contains additional information, and you need this for, uh, Tableau too.
37:11 When you create, uh, when you work in Tableau, yes, you create, um, uh, you create, for example… We can start from zero.
37:21 Uh, I open, uh, Tableau, Tableau, Tableau Public, and you can create a new, uh, new, uh, source that, uh, you can create new… You must create new project. Uh, you can create new, or you can start from, uh, selecting some files. For exam- In this case, I started to join my data file with a shapefile, and you, when you import your file, you can, uh, you can, you must, uh, when you want to import shapefile, you select special file, and you select, uh, folder with your files.
37:59 You should find this folder and select the shapefile.
38:03 When you open this, you will see results of, uh, you will see first map, which we have, is about hexagonal map.
38:14 Uh, you must join some data with this shapefile. In this case, I worked with number of calls, so I have a s- just synthetic file for demonstration. It's about regions, calls.
38:29 I select this, uh, s- uh, text file, and then, uh, we have a spe- uh, we have this file. We can join, uh, to shapefile our data, or data to sha- shapefile. No matter in this case. You can, uh, join this.
38:45 Uh, you can, uh, you… I open this, uh, menu, and, and join this, uh, in, like a left join on, or outer join. In this case, no matter.
38:57 Uh, we can create right join. It's not popular, but in this case, it w- will be something, uh, regions, um, uh, it will be about, uh, state level, so it will be state or abbreviation state.
39:16 So state two.
39:18 So we have this, uh, join in this case, and move to the first sheet, and we created, uh, this, uh, we can create this map. So we have, when we, when we imported this, uh, shapefile, we get the geometry from shapefile. It will be information about all our shapes.
39:38 We put this in the, on this marks, and you can get this map.
39:43 As you see, do you remember I told that we create, uh, in another projection, uh, wh- which is, which, uh, and Tableau read this projection? This map was created in zero zero coordinates on a quarter position, and, uh, but Tableau read this, and, uh, we can work with this m- m- uh, this shapefile. So we must split this, uh, little areas, uh, th- this hexagons.
40:11 For this, we should add level of details. It's about, uh, state.
40:16 Uh, just move them on marks.
40:20 Now we have splitted regions and abbreviation, and, uh, it's, uh, about call. And we have this map. We have this map, and, uh, also, we add some call information about, uh, dun, dun, dun. Oh, we had, I have mistake.
40:40 Sorry, we should move ba- go back the, the data sor- data source. I joined open.
40:48 I joined wrong way, sorry. Remove.
40:51 I must join regions with shape again.
40:57 It will be right join, and go back again.
41:04 You have the same information, geometry. You, and we should get, uh, uh, calls, and sh- uh, put them as a color, for example, and we will get such map.
41:16 Also, we have another shape. We remember we have regional split shape.
41:22 Uh, we should add this, like, additional info. We get this, we get this in the space, special file, file.
41:30 We go to our regions map, select this shape, and open this, and we have this map.
41:40 We, uh, move geometry on marks, and put regions on this marks.
41:47 Also, we have, uh, but we don't have information about, uh, regions. We don't have, uh, calls for regions. In this case, I can use this, uh, join by similar column. We have region column. This is the same, uh, region split, and, uh, in get hex map, we have regions too. Let's join this, and we can actually use, uh, calls for this regions too. So we'll get this,
42:16 sum of calls, and, uh, we should get, we should, uh, put some regions, uh, states too, I guess.
42:26 Hmm, I don't know why it doesn't work in this case. Okay, let's switch to another project. It's ready. Re- region. I did this in the same way. I put calls. I, uh, added regions, calls, regions, re- uh, calls, regions, geometry, and, uh, region as, um, uh, labels. So we have, uh, we have states map.
42:50 We have state map, and we have, uh, in this case, remove.
42:55 We have state map, and have a region map.
42:58 I will share a bookmark, uh, book- or workbook, sorry, uh, about this, uh, solution. It's about, uh, to create, um, drill down between two, two of these maps, between this one, yes-
43:13 Agata Mężyńska: Mm-hmm
43:13 Iaroslava Mizai: … and, uh, how, and this one, and how to drill, uh, drill from, uh, one map to another.
43:20 Agata Mężyńska: Mm-hmm.
43:20 Iaroslava Mizai: So, uh, it will be, uh, open for you, and you can read in my Tableau rep- uh, in my, uh, GitHub re- repository how I create it step by step.
43:32 And, uh, when you move, uh, to this one, um…
43:36 Sorry.
43:37 Uh, when you move to this one, uh, layer, uh, m- dashboard, you will see that it will works in this dashboard. You can press on each region and re- press reset button. Uh, you can move to another region, drill down, and reset button, and so on. This solution was already described, but a lot… by a lot of, uh, users, but I describe this again, this, all this process, so you can read how I created this b- step by step.
44:06 It's very detailed, uh, uh, resource. Uh, it's like a, a manual, uh, for this, uh, for this case. You can get this from my Tableau repository. You will read all, everything. S- This picture step by step when I created this file. You can get all my code, Python code.
44:31 Agata Mężyńska: Wow.
44:31 Iaroslava Mizai: You can get, uh, all sprint screens, and you also, you will get, have also another, uh, way how to create this, uh, merged hexagon regional ma- map in Python in QGIS too. So Python works in QGIS too, so you can select way, uh, what is better for you and what is useful for you in your case. You can start from merged hexagon and create the same as I, as I showed before, and, uh, everything is the same actually.
45:04 So if you want, I can share this, uh, link with you for keep.
45:09 Agata Mężyńska: Definitely. Please do.
45:12 Iaroslava Mizai: You can read this, and… Oh, this is my GitHub.
45:17 And, uh, you can read about a- all of this stuff. Also, you can go to Tableau, Tableau Public.
45:24 Uh, there is some, um, some results. It's a dashboard.
45:30 You can also download workbook and see how I created such moments with a drill down. So, uh, when you open this, uh, workbook, uh, you will see…
45:43 You, you… Not the workbook, a, a published version, yes, on Ta- Tableau Public. You can es- you can see how it works in re- in reality, in a regular, uh, moment.
45:54 Uh, you can press on any region. Yes, it works. Reset button.
46:00 Again, go to another region, for example this one, and reset button. So it will, it will solution for my dashboard. It works in s- in such dashboard, so it's solution. Every time… Uh, sorry that I took a lot of time. Every time, uh, I have, uh, try, uh, every time I try to find solution in QGIS, I have idea, yes. I just imagine what I want to have in the result, and I try to get the solution in, in any way, uh, in QGIS, in Mapbox, it's another tool for maps, uh, in Python.
46:40 And all my maps are based on such, um, you, you know, search. I usually read a lot about how to create the, this, such stuff, or I try to find some video, how to find, how to create some step for my data visualization. So inspir- um, there are a lot of stuff and ins- resources to create such ta- uh, such, uh, dashboards, such maps.
47:08 And QGIS, for me, is the best in this case.
47:13 Mapbox is additional tool in my set, but it's, the QGIS is the best one.
47:21 Agata Mężyńska: Sounds really tempting, so thank you a lot.
47:23 Iaroslava Mizai: Sorry it's a lot of stuff.
47:26 Just I can't imagine how to explain QGIS in one hour or half of an hour. It's a lot of, uh, information. 'Cause you can read my, uh, repository, and I hope it will be very useful 'cause I shared screen, and you can repeat each step and follow all process. If you don't know Python, sorry, you will do manual way. I showed you manual way, uh, how to create this, like press on each region and create regions.
47:57 So you select what is the best for you.
48:02 That's it.
48:02 Agata Mężyńska: There is always-
48:03 Iaroslava Mizai: Thank you
48:03 Agata Mężyńska: … a good way, so thank you a lot for sharing your secrets.
48:07 Iaroslava Mizai: It's one, one secret.
48:08 Agata Mężyńska: At least.
48:08 Iaroslava Mizai: It's only one secret.
48:09 Agata Mężyńska: Yeah.
48:10 Iaroslava Mizai: I have a lot of secrets in my life, so I use AI too in one secrets.
48:17 Agata Mężyńska: Okay.
48:17 Iaroslava Mizai: A lot of se-
48:19 Agata Mężyńska: So thank you for s- uh, sharing with us the secret, and, uh, thank you for pr- your presentation, and thank you for going through all the technical problems on your way. Thank you. Thank you. Thank you.
48:33 And now-
48:33 Iaroslava Mizai: Hope it will help someone. I hope it will help you.
48:37 Agata Mężyńska: It will, for sure.
48:38 Iaroslava Mizai: We should, we should switch… Sorry. We should, we probably should, should switch our session 'cause it's one hour.
48:46 Agata Mężyńska: Don't worry. I think we should still, uh, we should still ask, uh, Vlad to share his work because that's still interesting. We theoretically have one hour, but on the other hand, the stuff you present is always so interesting that it's worth staying and listening further.
49:06 So, Vladyslav, your turn
49:11 Vladyslav Horbachenko: Okay. So first of all, once again, thanks to Iaroslava.
49:17 Uh, sometimes, not sometimes, always, I open Tableau Public, and I think, "How, how do they do this? How?" And, uh, wh- when you finally understand this, you, "Ah, this way." Okay.
49:34 So my presentation will not be technical, guys, so you can rest a little bit.
49:40 For those of you who don't know who I am, uh, my name is Vladyslav Horbachenko, but you can just call me Vlad.
49:48 Uh, I work as a data analyst for the biggest logistics and postal company in Ukraine, and when I have free time, uh, and inspiration, I build some data visualization.
50:05 So, uh, for my assistance, I created a super complex and sophisticated presentation.
50:14 Okay. So today, guys, I want to tell you why I actually started building for Tableau Public, and most importantly, why I think you should do the same.
50:27 So, uh, a little bit about my journey.
50:32 For me, it all started in 2023, and in 2023, I, I wasn't a data analyst.
50:42 I was working as…
50:44 Oh, God, uh, accounts receivable representative.
50:49 Yes. I worked in, uh, American company, and, uh, to be honest, I really hated my job.
50:57 It was pointless, useless, not interesting.
51:02 The culture in the company was terrible.
51:05 But, uh, despite all of that, there was one thing that I really liked at my work, and it was, attention, it was Excel.
51:16 Yes.
51:17 I really liked working with Excel. It was my favorite tool, and I really liked automating things with Excel. I really liked helping my colleagues solving their problems with Excel. So it was the only one thing I liked doing at my work.
51:36 And somewhere in 2023, maybe 2022, I heard that there was a profession called data analyst.
51:48 And I thought, "Okay, uh, maybe I should try this," uh, especially because I already had some, uh, commercial experience with Excel, and most data analysts, they start with Excel.
52:06 So I decided that I need to find some courses, some courses, some certifications, and, uh, as you might know, there are a lot of courses. It's, it's really hard to choose, especially when you start.
52:20 So I chose one.
52:23 You probably heard about it, and I think many of you even took it.
52:28 Uh, it's called, uh, Google Data Analytics Professional Certificate.
52:34 It was my first certification.
52:37 I didn't have any data training before.
52:41 And you know what? Uh, I genuinely liked this certification. It was really interested in- interesting.
52:50 I learned many things about data, data preparation, data cleaning, data security.
52:57 I learned SQL during that course.
53:01 But there was one particular section that I was looking forward to, and it was a section about Tableau.
53:12 Yes.
53:13 Before that, I had never used any data visualization tools.
53:20 Uh, the only thing I did was a dashboard in Excel. Yeah, dashboard in Excel.
53:28 Some years, some time ago, I did this.
53:31 Uh, I actually have a picture of one of my dashboards. Yeah. This one I created in Excel for my previous work.
53:41 Uh, don't worry. If you worry, this data is completely fictional, but the, the dashboard was real. So I really wanted to work with some professional data visualization tool, and I was waiting for that Tableau section during Google DA course.
54:02 And when that section came, I was disappointed, really, because, uh, that section was mainly theoretical.
54:13 You know, it wasn't much practice.
54:16 Uh, there were many videos like, "Data visualization is an integral part of data analysis, and it helps businesses to solve their problems," blah, blah, blah, something like this.
54:32 Not much practice. Yeah. I think you can agree on that.
54:36 Uh, and I thought, "Okay, maybe it's not that interesting. Maybe it's not that difficult. We don't have, uh, to practice a lot." And at the end of the course, there was a capstone project.
54:52 Yeah. We had some data.
54:54 We needed to analyze it and build some kind of a presentation, and in Tableau.
55:03 And that part was the most difficult for me because when I opened Tableau for my ca- uh, capstone project, I was perplexed.
55:13 I, I didn't know where to start Yes, I, I was overwhelmed with all those tabs, menus, uh, settings.
55:24 I just didn't know what should I do in order to build a dashboard.
55:29 So I had to go back, re-watch all those videos.
55:34 I had to Google, I had to go to YouTube.
55:38 Somehow I put it all together, and I finally created my capstone project, and, uh, actually, here it is.
55:50 This is my first Tableau dashboard ever.
55:56 Yeah.
55:57 I, I don't even want to start about, uh, what's wrong with this dashboard.
56:02 Iaroslava Mizai: It's cool one, sorry. It's cool one.
56:04 Vladyslav Horbachenko: Yeah.
56:04 Iaroslava Mizai: We'll start. It's really amazing. My first dashboard was about… Don't laugh from this. My start was about colonoscopy dashboard.
56:14 So it's okay.
56:16 Vladyslav Horbachenko: Okay.
56:17 Iaroslava Mizai: Any start is good.
56:19 Vladyslav Horbachenko: And, and you know, but at that time, I thought that this, this dashboard was super cool. I was so proud of myself.
56:28 Uh, I was proud that-
56:29 Iaroslava Mizai: You should be
56:29 Vladyslav Horbachenko: … I, I could build this.
56:32 Uh, but I finally finished my Google DA certification, and after that, I had a problem.
56:41 I finished my certification. Many students have this problem. I finished my certification, but I still didn't know how to build dashboards.
56:50 I was really nervous every time I had to do this.
56:55 So I decided that I need to learn more.
57:02 But this time I thought, "Okay, I'm gonna take a different approach.
57:08 I'm not gonna take another course, a program, a certification.
57:13 I will go to the place where you can learn basically anything." So I went to, uh, to the YouTube.
57:24 I decided that, okay, I need to find some videos from analysts, uh, and learn how to work in Tableau, and I did this. I found some really cool videos, some good, uh, YouTube channels, and, uh, those channels, they had videos, uh, like, you know, uh, how, how to build a Tableau project starting from gathering the requirements and finishing with a full-scale dashboard.
57:58 And to be honest, I learned a lot. Like, I finally felt comfortable with all those parameters, dashboard actions, bins, hierarchies, and, and, and, and other stuff. I felt really comfortable.
58:16 It even helped me to get my first data analytics job because, uh, one of the test tasks was to create a dashboard based on the data that they provided, and I created a dashboard using those YouTube knowledge, and they liked it, so they took me in.
58:36 Yeah.
58:38 Okay, so now I was a data analyst. I was working, uh, in a big company. I was creating dashboards.
58:48 And one day I found a website, very interesting website, and that website was called Tableau Public.
59:00 Before that, maybe I heard about this website, but I didn't know what it was for.
59:07 I thought that it was some, you know, a website which lets you save your dashboard for, for some reason. I, I wasn't interested in it, you know?
59:19 And imagine my shock when I saw things like this.
59:28 Um, first of all, I couldn't believe. At first I thought they were just pictures, but then I realized that they were l- real dashboards.
59:39 Uh, first of all, I, you know, I couldn't believe that these things were possible in Tableau.
59:47 Then I was disappointed again.
59:51 During my presentation you will hear many times when I was disappointed.
59:55 I was disappointed again because, uh, I, I, I realized that I don't know how to…
1:00:01 I don't know nothing about dashboards in Tableau.
1:00:05 So, uh, I had to make one more decision, uh,
1:00:12 and I decided that I wanted to learn more.
1:00:17 So I, I started downloading all these dashboards, dashboards that I really liked. I, I, I even remember that probably one of this, one of those dashboards that I saw was Iaroslava's dashboard. I don't remember which one, but I, I remember it was Iaroslava's dashboard.
1:00:34 So I started downloaded those dashboards, and I started, you know, breaking them down.
1:00:41 Like, very simple, very primitive approach.
1:00:45 I tried to understand how this worked, uh, what does this mean, how they implemented that, you know?
1:00:54 And you know, it, it was a life-changing process because I learned so many things which are not taught during any courses, certifications. You can't find these things on YouTube.
1:01:11 Uh, so after that I thought, "Okay, I want to build something like this." I want to create my dashboards, and I want to take them to the new level.
1:01:25 Moreover, I decided that I want to publish them and, uh, write about them on LinkedIn.
1:01:35 So the process began, and I had to spend weeks building some of my dashboards, and, uh, after that, I shared them. I wri- I, I wrote many posts about them, and every time I created a dashboard, I felt frustrated because I didn't get the result I wanted, even close.
1:02:04 Imagine, I spend weeks building one dashboard, and after that, it gets maybe 150, 200 views on Tableau Public, and it gets maybe 20, 30 reactions on LinkedIn. No feedback, just nothing.
1:02:25 Nothing.
1:02:27 And, uh, when you build projects in Tableau, you should understand that… I, I, I, I, I, I think you feel that way, too. When you start a new project, it's like you start from the beginning.
1:02:41 Every time, it's like you begin from level one, and you have to gather data, work with design, combine this data, uh, solve some, some unpredictable problems, and so on. And I spent months building my dashboards, uh, sharing them, and just absolutely no feedback, no reactions, nothing.
1:03:07 I even started thinking that maybe I was bad.
1:03:11 Maybe, uh, maybe I, uh, I should actually stop.
1:03:17 And very interesting thing that at work, my dashboards were, like, useful.
1:03:24 My colleagues used them. They gave me feedback.
1:03:28 I had some requests on building dashboards, but outside of my work, zero, nothing.
1:03:36 Okay, uh, so, uh, I made another decision. I thought, "Okay, maybe for now I should stop, and I need to level up my knowledge. Maybe I just know little stuff, and that's why my dashboards don't work."
1:03:55 So, uh, I went to the program. It's called Next Level Tableau.
1:04:03 It's, it's a program by Andy Kriebel.
1:04:06 You- I'm sure you've heard of him.
1:04:11 And, uh, I was absolutely blown away by this program. It was really cool. I learned so many interesting things for work, for personal projects. Like, wow, super cool stuff. I totally recommend it, so if you have time, if you have a- an opportunity, go for it 100%. You can learn a lot.
1:04:34 Okay, so I built, uh, things for this, uh, training program. I stopped posting on Tableau Public. No new dashboards, nothing.
1:04:46 And, uh, during that period, I was watching a TV show, and that TV show, uh, was, uh, called Ted Lasso.
1:04:59 I really like this TV show, not just because I'm a huge football fan but because this TV show is, uh, about way more things than just football. It's about leadership, uh, relationship, helping people, communicating, and other things. Many interesting things that I was genuinely interested in.
1:05:25 And one day, I was watching one of the episodes, and I thought, "Maybe I should create a visualization about Ted Lasso." Yeah.
1:05:36 I learned some leadership lessons from this TV show, and I thought, "Maybe I should put them in Tableau project." But I also thought, uh, "Okay, but how would it be different from a simple PowerPoint presentation? Like, show some texts, and what? Then what?" So I started doing my research. I went online, and I spent some time searching for data, and I actually found, uh, this company.
1:06:12 Believe me or not, but I'm still not sure how to pronounce its name.
1:06:18 It's probably Gallup or Gallup, something like this. But I discovered that this company conduct, uh, a lot of research on workplaces, employee engagement, AI, leadership, uh, effective management, and so s- so other things, so many other things, and every year, they build a huge report on workplaces all around the world.
1:06:48 So I, I started reading their 2025 report, and I was surprised because a lot of data in that report actually supported what I wanted to tell with Ted Lasso visualization. So I decided that this time I will combine something I love with real-world data.
1:07:14 I put it all together, and I created this.
1:07:18 This was- Uh, I can't even call it a dashboard. It's like, uh, a project, a data story where I tell about, uh, leadership lessons that I learned during this TV show.
1:07:33 It's actually pretty basic and simple. I just have a lesson, a leadership lesson that I found in that TV show, and on the right side, I visualized some data to back up this leadership lesson.
1:07:50 And under each section, I had a link to…
1:07:55 where you can see this leadership lesson in action.
1:08:01 So I spent a lot of time building this thing. I really enjoyed it. It was something way different from dashboards.
1:08:10 And you know what?
1:08:11 Uh, after I published it, uh, I had absolutely the same reaction as I had with all my w- with all my previous work.
1:08:23 Just nothing. No feedback, no reactions, no views, nothing.
1:08:28 Iaroslava Mizai: May I break you?
1:08:30 Vladyslav Horbachenko: Yeah.
1:08:31 Iaroslava Mizai: You think that you didn't have reaction, but you had reaction from other side.
1:08:37 Uh, we have a chat, a Tableau Ambassador chat, you know this, and, uh, some- somebody published this dashboard, and you had a reaction on this dashboard from Tableau Ambassador, probably less, uh, in numbers, but it had a reaction.
1:08:55 Vladyslav Horbachenko: But at that time, I didn't know about it, you know. I just published it and, okay, nothing happened. And after that, uh, project, I decided, "Okay, this is the end.
1:09:09 I stop building for Tableau Public. It doesn't work for me. I'm not good enough. I will just continue working with Tableau at work, but outside of, uh, work, nothing. That's it. The end."
1:09:25 And I remember this day very clearly. It was summer 2025. It was Friday, end of the working week. I was really tired, and I received a message in Slack from one of my classmates from Next Level Tableau, and that message said, "Congratulations."
1:09:52 It took me probably five minutes to realize what the hell he was talking about.
1:09:58 Congratulations? Congratulations with what? With my homework?
1:10:03 And I, I finally realized that for the first time in my life, my Tableau work was, was nominated for Viz of the Day.
1:10:18 I was totally blown away.
1:10:22 I felt so amazingly.
1:10:24 I was above the ground, you know. I was so inspired. Like, finally, I, I did this. I felt like I did this.
1:10:34 Finally, after all this weeks and months of building, creating, solving, searching, sharing, I finally got this one.
1:10:50 I took a few days, you know, to digest all this happiness, all this information, and, um, after that, I thought, "Okay, maybe I need to take a different approach.
1:11:06 Maybe I should build not just dashboards but build things that I really like." And this moment changed everything.
1:11:20 It finally clicked in my head, and I found, if you can say, my way.
1:11:27 I started building, uh, different things, different from, uh, from dashboards.
1:11:35 Uh, I started getting some feedback.
1:11:39 I started getting some, uh, people reaching out to me.
1:11:43 I built this one in a few months. This is my Harry Potter project, uh, about how Harry Potter changed the world.
1:11:53 Uh, after that, I was invited to be a speaker on various data analytics and data visualization events in Ukraine.
1:12:04 I was proposed to write articles on data visualization. People started reaching out to me to ask about my work, about data visualization.
1:12:15 I created a YouTube channel on Tableau and data analytics.
1:12:19 I even created my data visualization guide, and this work that you can see right now on your screens actually got me this. Yeah.
1:12:31 An award.
1:12:33 I created s- s…
1:12:35 Just imagine this. I was sitting in Ukraine in my flat, building something on my laptop, and later, in a few months, this was awarded somewhere across the ocean in the US during Tableau Conference.
1:12:54 How cool is that?
1:12:56 Uh, I couldn't even dream about it, you know.
1:13:01 So this changed everything for me.
1:13:06 And now you know why I started building for, for Tableau Public, why I started doing this.
1:13:16 And, uh, now I think that you should also know why I think you should do the same.
1:13:24 The first thing, uh, the first reason why I think you should invest your time and your effort into building visualizations for Tableau Public is you will learn a lot.
1:13:39 At least I did.
1:13:42 Uh, while working with my projects, I learned so many interesting things.
1:13:48 I learned how to, how to do a research.
1:13:53 I learned how to combine data from different sources.
1:13:57 I learned a lot of technical stuff in Tableau that I, I didn't even think was possible.
1:14:05 I learned how to use AI. I learned how to use, um, tools outside Tableau, and combine these tools with Tableau.
1:14:17 I learned how to share my, my work, because it was difficult at first. I learned how to, how to work with feedback, how to work with negative feedback. Yes, it was important. So
1:14:32 I think that you should build for Tableau Public because while doing this, you will learn so many interesting things, so many cool things that you will not necessarily learn at your work.
1:14:45 And you know that
1:14:49 AI changes everything. We don't know what will happen in the next one year or two years. Maybe in one year we will not be working with Tableau.
1:15:00 Maybe we will switch to, I don't know, Power BI, or Data Studio, or Cloud Dashboards, or maybe there will be one more super cool data visualization tool. But all these things that you learn in Tableau, you can take with yourself, and you can use all this knowledge outside of Tableau in any other data analytics and data visualization tool. So it's, it's super important that you spend some time, and all this effort, they will pay off, and it will give you some knowledge that you can use outside Tableau.
1:15:40 The second reason why I think you should invest your time and effort into this is people.
1:15:49 During my journey in Tableau, I met so many wonderful people that I would never met if I hadn't started.
1:15:58 I met great people from Europe, from the US, from Africa.
1:16:05 Uh, people who inspired me, people who gave me feedback, people who were ready to help. And you know, actually Agata is one of the examples.
1:16:17 Um, I remember last spring when I woke up and I discovered that I won an award at Tableau Conference, Agata reached out to me and proposed to take this award from me and send it to me, because she knew that I couldn't leave Ukraine for, for the moment.
1:16:41 And this was unbelievable, and, uh, she didn't have to do this, but she did.
1:16:48 And I would never met her if I hadn't started building for Tableau project. And so, s- and the same for many other wonderful people that I met along the way.
1:17:04 And there is one more reason, uh, why I think you should build for Tableau Public and invest your time in data visualization.
1:17:15 Wonderful things you never expected can happen to you.
1:17:22 One of the amazing things in life is that you never know where something will s- s- where something you start doing will take you.
1:17:31 Uh, when I started, I didn't know, too.
1:17:36 I thought about one thing.
1:17:38 I thought that maybe I, I will get 1,000 views on Tableau Public.
1:17:45 Maybe one day eventually I will get
1:17:51 Viz of the Day nomination. But it turned out to be a completely amazing and different thing, and way beyond my expectations.
1:18:03 And you know, when I started, I had nobody who could tell me this.
1:18:08 Uh, but now, when I know all this stuff, I think it's a good idea to share this.
1:18:16 And one last thing.
1:18:18 I can't tell you what exactly will happen to you if you build for Tableau Public, but I can guarantee that if you invest your time, and your effort, and you stay consistent, and you build something you really like and care about, wonderful things will definitely happen to you.
1:18:46 So basically, that's, that's all I have for you for today, guys.
1:18:53 Agata Mężyńska: Thank you, uh, thank, thank you, Vladyslav, a lot.
1:18:57 Uh, thank you for the presentation. Thank you for the story. For me, it's amazing how short is this story.
1:19:05 Uh, m- my story with Tableau was, is years longer. Iaroslava's is, uh, years longer as well.
1:19:15 And you did all of that in relatively short time, so congratulations.
1:19:21 And, uh, yeah, the thing is that data from the community is wonderful, and meeting all the people around, uh, is a wonderful, wonderful experience.
1:19:34 Vladyslav Horbachenko: Yeah.
1:19:35 Agata Mężyńska: Thank you a lot for everything. Thank you both for joining Poland Tableau User Group this time, and sharing tips, ideas, uh, experiences, whatever it took on your way.
1:19:51 Uh, for all those who would like to follow once again, uh, the instructions of, uh, Iaroslava, that were very precise, uh, we will soon publish, or at least, uh, you will be able to find the recording of the meeting on YouTube. So I will share the, uh, a link to that for anybody, uh, as soon as it will appear. Look for information on, uh, on LinkedIn.
1:20:23 It will be published there.
1:20:26 And thank you everybody for staying with us, uh, on this, uh, Wednesday evening, uh, or morning for some, for those who, uh, joined us from the other side of the ocean.
1:20:40 So thank you all again.
1:20:43 Thank you, Iaroslava. Thank you, Vladyslav. And I hope see you again as soon as possible.
1:20:49 Vladyslav Horbachenko: Yeah. Thank you too.
1:20:50 Iaroslava Mizai: Thank you, Edyta.
Shorts for this TUG
- No ai just data
- Hexagons need qgis
- Dissolve merges hexagons
- Keep shapefile files together
- Imagine the result
- Course was all theory
- First dashboard ever
- Thought they were pictures
- Break them down
- Weeks for 200 views
- Congratulations votd
- Build what you like
- Award across the ocean
- Skills outlive the tool
- Agata sent the award
- Wonderful things happen