From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Unlock this course with a free trial

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

Building a matrix and visuals

Building a matrix and visuals

From the course: Learning Data Analytics Part 2: Extending and Applying Core Knowledge

Start my 1-month free trial Buy for my team

Building a matrix and visuals

“

- [Instructor] Decision makers will literally ask for everything on a dashboard. That's because they're not sure how they want to consume the information in a glance. When designing a dashboard, you might want to consider that you really can't put everything on the dashboard. It would be too overwhelming to really be meaningful. I like to create what I call artifacts which are samples that might go into the dashboard, or might not. Let's start by connecting to our data so we can take a look at our product lines. I'll go ahead and get data, go to Excel and choose my 2020 sales. This workbook has tables defining the data as well as sheet tabs called returns and sales. I can choose either one, but I'll go ahead and choose Order Status and Sales2020 and I'll choose Load. It's detected a relationship between our data. So I'm going to go check that first. I'll go to the model, I go ahead and minimize my properties here and I can see the join line. Click and go to Properties and just confirm…

Contents