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.

Working with reusable data

Working with reusable data

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Working with reusable data

“

- [Instructor] There are some datasets I consider standard and reusable, like a dates table. A dates table is one of the more common scenarios you'll run into with reusable data. It allows you to bring your dates in with common date calculations that you might find you're rebuilding every time you work with dates. Let's create our own custom dates table using Excel. That way you can use it anytime you have data-related calculations on dates. Okay, I've opened up the Excel dates file, and I want to go ahead and create just a few date calculations. Again, this file goes from 1/1/2019 to 12/31/2025. So I'll use equal and value to convert this to the serial number. That way, if I need serial number, I can use it. I'll go ahead and do day of week. So I'll do equal. I'll do weekday. Now it asks for serial number, but I could choose either A2 or B2, and it'll still work. And then I'll double click to auto-fill that down. By default, the first day of the week is Sunday. I can change that if I…

Contents