Linear Tig(e)ression: Data Analytics - Cleaning your data in TimescaleDB
In this episode of Linear Tig(e)ression, explore TimescaleDB and PostgreSQL functionality for data analysis cleaning methods. Learn how to clean up your data using only your TimescaleDB database. This session includes basic SQL, PostgreSQL, and TimescaleDB functionality, so if you are a beginner, this session is for you! We will also be discussing some best practices for table schemas.
🐯 𝗔𝗯𝗼𝘂𝘁 𝗧𝗶𝗺𝗲𝘀𝗰𝗮𝗹𝗲
At Timescale, we are dedicated to serving developers worldwide, enabling them to build exceptional data-driven products that measure everything that matters. Analyzing this data across the time dimension ("time-series data") enables developers to understand what is happening right now, how that is changing, and why that is changing. We are backed by top-tier investors with a track record of success in the industry.
🛠 𝗥𝗲𝗹𝗲𝘃𝗮𝗻𝘁 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀
📌 Table structure data source ⇒ https://www.kaggle.com/jaganadhg/hous...
📌 Data cleaning with PostgreSQL blogpost ⇒ https://tsdb.co/data-cleaning-with-po...
💻 𝗙𝗶𝗻𝗱 𝗨𝘀 𝗢𝗻𝗹𝗶𝗻𝗲!
🔍 Website ⇒ https://tsdb.co/homepage
🔍 Slack ⇒ https://slack.timescale.com
🔍 GitHub ⇒ https://github.com/timescale
🔍 Twitter ⇒ / timescaledb
🔍 Twitch ⇒ / timescaledb
🔍 LinkedIn ⇒ / time. .
🔍 Timescale Blog ⇒ https://tsdb.co/blog
🔍 Timescale Documentation ⇒ https://tsdb.co/docs
📚 𝗖𝗵𝗮𝗽𝘁𝗲𝗿𝘀:
⏱ 0:00 ⇒ Introductions
⏱ 3:41 ⇒ Discuss the raw data and the issues
⏱ 6:03 ⇒ Correcting structural issues
⏱ 9:06 ⇒ TimescaleDB hypertables and why timestamp is important
⏱ 11:50 ⇒ Jumping into DBeaver / Creating or generating relevant data
⏱ 51:47 ⇒ Adding data to a hypertable
⏱ 57:40 ⇒ Outro