Create Stunning Excel Dashboards with Powerpivot - Power View Excel Tools

Andreas Exadaktylos, Teacher | Expert Computer Scientist | Entrepreneur

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
22 Videos (1h 29m)
    • Excel Dashboards with Powerpivot

      1:29
    • What is Power BI? (NEW 3/2017)

      1:33
    • What are Powerpivot and Power View add ins

      2:45
    • Install the PowerPivot and Power View add ins

      3:16
    • How to import data from PowerPivot tab

      3:04
    • Link a table in Excel and add into powerpoint data model

      2:06
    • The diagram view and the relations between data

      2:22
    • Calculated fields

      4:56
    • Calculated columns

      7:37
    • Create calculated fields using DAX formula language

      4:17
    • Create filtered calculations

      2:56
    • Case Study: Company Sales Stats + new DAX Functions – Part:1

      6:14
    • Case Study: Company Sales Stats + new DAX Functions – Part:2

      4:22
    • What are KPIs and how to create them

      2:28
    • Add key metrics and create our first Powerpivot pivot table

      5:42
    • Design your Dashboard with link buttons

      7:07
    • Create pivot charts

      4:33
    • Complete the dashboard worksheet using slicers and timeline

      5:45
    • Preconditions and features of Power View

      2:55
    • Using Matrices, Cards and Tiles to visualize Power View Data

      2:54
    • How to create an amazing sales map and other useful charts

      4:02
    • The finishing touch–completing dashboards with pivot charts

      6:35