In this video, the instructor outlines a few common options when it comes to visualizing data from your data model, including PivotTables and PivotCharts, Power View, CUBE functions, and Microsoft Power BI.
- [Instructor] Okay quick work on…data visualization options, now you might've noticed…that data vis is an area that we didn't dig super…deep into as part of this course.…And there were a few reasons why that was the case.…For one, you could create entire courses…about data vis specifically, in fact I've got a separate…course covering data vis with Excel charts and graphs.…I've got a pivot course that has a whole section on pivot…charts 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 visualization…visuals and reports form your data model.…The most common and in many cases the most effective…option is simply to work with pivot tables,…pivot charts and conditional formatting.…So like the tips we showed here and there throughout…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.