In this video, we break down how to utilize the powerful features of powerful tools like Tableau Desktop, Tableau Prep Builder, and Microsoft Power Query to clean and transform your data so it's ready for analysis and visualization.
Download tutorial data sets here (if you are following along):
data.world/sqlbelle/dataprep-...
Download original data source:
opendata.vancouver.ca/explore...
Let's connect:
sqlbelle.ck.page
Features
🧹 Data Cleaning Techniques: Seamlessly combine multiple files and worksheets while eliminating inconsistencies and missing values.
🔄 Data Transformation: Master the art of merging, UNION-ing, and reshaping datasets for precise analysis.
🤔 Tableau vs Power Query: Side-by-side comparison of these powerful platforms, and grasp the unique pros and cons each offers.
🌏 Real-World Use Cases: Tackle data transformation challenges in real-world settings using real-world data sets.
Why This Matters
🌟 The power of data analysis lies in the quality of the data. If your data is messy or incomplete, your analyses and decisions will be flawed. That's why knowing how to clean and transform data is so crucial in today’s data-driven world.
In addition:
- See two different ways to clean in Tableau Prep Builder
- Learn more about Power Query (loading as table or connection only, Transform vs Add Column, different ways to do conditional actions)
#tableaudesktop #TableauPrepBuilder #Microsoft #PowerQuery #DataAnalysis #RealWorldUseCase #RealWorldDataSets
00:00 Introduction
00:09 What is a union operation?
00:53 Data Source used for tutorial
03:00 Cleaning with Tableau Desktop
08:21 Cleaning with Tableau Prep Builder #1 - via Connection
12:37 Cleaning with Tableau Prep Builder #2 - via Union operator
18:12 Cleaning with Microsoft Power Query
Негізгі бет Ғылым және технология Fix messy data: Practical Guide using Union in Tableau and Microsoft Power Query
Пікірлер: 8