From the course: Advanced SQL for Data Scientists
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Challenge: Design a data model for analytics
From the course: Advanced SQL for Data Scientists
Challenge: Design a data model for analytics
(bright music) - [Instructor] Here is a data modeling challenge. Let's assume you're a consultant and you're working with an internet of things, or an IoT company, that is collecting streaming data from thousands of sensors and they collect this data every minute. For them, low write latency is essential. So as soon as the data comes in, it needs to be written because we don't want to basically have a backlog of data or anything like that, and it's also important that the write latency be fairly consistent so we don't want, you know, some periods where it's very bursty and we have very low latency, and then other times it's more prolonged, it's more delayed. Now, at the same time, this IoT company has a team of data scientists and they're going to be performing different kinds of time series analysis including roll-ups of aggregate data. So, say for example, by each sensor, what's the, what are some aggregate measures…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.