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.
Finding existing data
From the course: Learning Data Analytics: 1 Foundations
Finding existing data
- [Robin] Our decision makers are starting to realize that they want more access and quicker access to make decisions than how they've done it in the past. Everything we see on reports or Pivots comes from somewhere and without doubt, most of it's in a system or in a database. And that's typically our best starting point. I will say that a fair amount of the reports I've seen through the years that are Pivot-based or have charts, they're often hand-built by the user. Asking questions is such an important part of the process, but not the, "Why are you doing it this way?" question, but more like, "Do you know where this data lives? "How do you get this data? "Are you exporting it? "Or does someone email it to you?" Once you have the answers to these questions, then you can ask additional questions. Like, "Can I export this from the system myself? "Does this system allow us to access "the back end of the tables?" It's also important to know who to ask the questions to. Let's take a look…
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.
Contents
-
-
-
-
-
Learning to interpret existing data3m 27s
-
(Locked)
Finding existing data3m 23s
-
(Locked)
Cleaning data2m 6s
-
(Locked)
Understanding data and workflow5m 48s
-
(Locked)
Understanding joins2m 56s
-
(Locked)
Working with joins and validation7m
-
(Locked)
Challenge: Products are not categorized42s
-
(Locked)
Solution: Products are not categorized2m 33s
-
-
-
-
-
-