From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Data visualization options

Data visualization options - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Data visualization options

“

Okay. A quick word on data visualization options. Now, you might have noticed that data viz is an area that we didn't dig super deep into as part of this course. There are a few reasons why that was the case. For one, you could create entire courses about data viz specifically. In fact, I've got a separate course covering data viz with Excel charts and graphs. I've got a pivot course that has a whole section on PivotCharts. And the fact is, the purpose and the focus of this particular course was more on the unique tools and the fundamental concepts behind these new BI capabilities. Because once you get those fundamentals down and once you learn how to use these tools really, really well, then the visualization piece can follow. Now that said, there are several options for building visuals and reports from your data model. The most common, and in many cases the most effective option, is simply to work with PivotTables, PivotCharts, and conditional formatting. So like the tips we showed…

Contents