From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Modeling data with queries

Modeling data with queries

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Modeling data with queries

“

- [Instructor] There are lots of different ways to model data. If you have backend access to a database, you're likely to use queries to model your data. You'll leverage joins and join types to create the datasets you need. Let's take a look at the model data with queries database. Our survey data is captured in this database and people have responded on different dates. We can see that they have a start date of different days. So I have on 7/24, 7/25. I can scroll through and look through the 262 responses. We want to analyze their responses by date. We also want to look at what day of the week was most popular or even which one of the months was more popular. For example, is Monday the most popular day or was it Sunday? Let's bring in our date data. I'll go to external, new data source, from file and Excel. I'm going to use my reusable dates dataset. I'll browse and choose Dates. I don't need to link or append a copy. I'll just import the source data. I'll click okay. I see my date…

Contents