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 Lessons (1h 29m)
    • 1. Excel Dashboards with Powerpivot

    • 2. What is Power BI? (NEW 3/2017)

    • 3. What are Powerpivot and Power View add ins

    • 4. Install the PowerPivot and Power View add ins

    • 5. How to import data from PowerPivot tab

    • 6. Link a table in Excel and add into powerpoint data model

    • 7. The diagram view and the relations between data

    • 8. Calculated fields

    • 9. Calculated columns

    • 10. Create calculated fields using DAX formula language

    • 11. Create filtered calculations

    • 12. Case Study: Company Sales Stats + new DAX Functions – Part:1

    • 13. Case Study: Company Sales Stats + new DAX Functions – Part:2

    • 14. What are KPIs and how to create them

    • 15. Add key metrics and create our first Powerpivot pivot table

    • 16. Design your Dashboard with link buttons

    • 17. Create pivot charts

    • 18. Complete the dashboard worksheet using slicers and timeline

    • 19. Preconditions and features of Power View

    • 20. Using Matrices, Cards and Tiles to visualize Power View Data

    • 21. How to create an amazing sales map and other useful charts

    • 22. The finishing touch–completing dashboards with pivot charts


About This Class

Do you struggle creating dashboards in Excel?

Do you want to master business modeling and analysis techniques with Excel 2013 and create effective dashboards?

Do you want to learn how to use PowerPivot and Power View tools to create mind blowing charts and graphics?

This class is a guide with simple step by step instructions walk you through creating business intelligence reports and dashboards quickly and efficiently.

Excel Dashboards are a powerful tool to present and report data. However building a dashboard is a complex process. In this class I'll walk you through the most effective ways and tools to build Excel dashboards that will wow management both visually and substantively. We'll use Microsoft's free PowerPivot and Power View tools to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!

What you'll learn:

  • Dashboard design principles, tips and tricks
  • Understand and install the Excel PowerPivot and Power View add-ins
  • Import data from spreadsheets, Access, SQL, text files and other sources
  • Add calculated fields and columns with Data Analysis Expressions (DAX) formula language
  • Create complex reporting systems
  • Design your Dashboard with link buttons
  • What are KPI's and add key metrics
  • Create mind blowing Excel Pivot Charts from PowerPivot
  • Create powerful reports using Slicers and Timeline
  • Make an amazing interactive sales map using Excel Power View powerful add-in
  • Summarize data with Matrices, Cards and Tiles
  • Perform simple-to-sophisticated calculations like Month to date and Year to date
  • Analyze multiple tables together without the need to ever write VLOOKUP formulas again

Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.

Enroll now and master the creation of interactive Excel Dashboards!


About the instructor

"Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever i can.

I have over 16 years of experience in teaching as an instructor. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a passion for software products that make people's lives easier.

Thank you and I'll see you inside!"