Guided Course: Scraping and Data Visualization with Tableau
Preparing the data
A guided course by Victor Pascual , Data Visualization Specialist
About the video: Preparing the data
Overview
“In order to complete the course project, it's important to use spreadsheets efficiently. In this lesson, we'll cover some Google Spreadsheets tricks that generally also work in other tools like Excel. Among other things, we'll learn how to use keyboard shortcuts to work more efficiently. In addition, we will look at what the z-score is and how to calculate it to allow for a consistent comparison between values obtained from different series.”
In this video lesson Victor Pascual addresses the topic: Preparing the data, which is part of the Domestika online course: Guided Course: Scraping and Data Visualization with Tableau. Learn to extract, clean and visualize television series data using Scraping and Tableau public techniques.
Partial transcription of the video
“Hello again! In our last lesson. we successfully extracted the season and episode from the cell where information was initially combined. Now. we have all the values in their raw form. They are clean and ready for further processing. so let's move on to the next step in our analysis. we've tidied up our data somewhat. Now. what we lack is the next step in analysis. First. generate the final dataset. meaning. in this case. for example. season and episode are something we won't need anymore because we have them broken down in another column. And. For instance. position and length are details ...”
This transcript is automatically generated, so it may contain mistakes.
Course summary for: Guided Course: Scraping and Data Visualization with Tableau
-
Category
Design, Marketing & Business -
Software
Google Sheets, Tableau Public -
Areas
Infographics, Information Design, Interactive Design, Multimedia
Victor Pascual
A guided course by Victor Pascual
Víctor Pascual is a self-confessed lover of scientific data visualization, who has a doctorate in computer science and digital communication. He dedicated his doctoral thesis to researching new methods for representing web data and has been a data scientist and data visualization specialist since 2009.
After three years as part of the Bestiario team, Víctor began his new adventure as a data analysis and visualization consultant for companies including SIRIS Academic and Mobile Media Content, where he leads a diverse range of R&D projects.
Víctor is also committed to training in information visualization, which led him to codirect Spain's first postgraduate course on the subject (IDEC) as well as participate in a number of different conferences and workshops. He currently collaborates with different master's and postgraduate degree programs.
- 24 students
- 7 lessons (1h 27m)
- 7 additional resources (1 files)
- Online and at your own pace
- Available on the app
- Audio: Spanish, German, English, French, Italian, Dutch, Polish, Portuguese, Turkish
- Spanish · French · English · German · Italian · Portuguese · Polish · Turkish · Dutch
- Level: Beginner
- Unlimited access forever
Recommended software & tools for this course
Google Sheets
Tableau PublicCategory
Areas
