Excel Power Pivot & Excel Power BI Masterclass

Course details

*** Completely up-to-date for November 2016 ***

Learn PowerPivot and Power Business Intelligence Tools that are rarely found on Excel users and transform to an Excel Star!

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create interactive charts, summarize data intelligently using PowerPivot and PowerBI tools, and finally present output in stunning Dashboards.

Content and Overview

This course is a guide with simple step by step instructions to walk you through creating business intelligence reports and dashboards in Excel, quickly and efficiently. The course has been created with the version of Microsoft Excel 2013

Excel Dashboards are powerful if you want to present and report data. However building a Dashboard is a complex process. In this course 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 Excel free Power Pivot, Power View tools and DAX Formula Language to analyze huge amounts of business data fast and transform data into bottom-line results - no programming required!

Note: Power View is a new interactive tool available only in Excel 2013 (PowerPivot is available in both versions - Excel 2010 and Excel 2013)

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 24 hours.

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.

What are you waiting for? Enroll now and make your Excel Dashboards look amazing!

What you'll learn:

• Dashboard design principles, tips and tricks
• Understand and install the Excel Power Pivot 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 Excel 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 2013 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

Enroll now and master the creation of interactive Excel Dashboards!

100% risk free - 30 day money back guarantee! - Lifetime access

Who is this course for?

This course assumes that you have a basic knowledge of Excel 2010 or Excel 2013. You don't need to be a master of Excel. Only basic prior experience in Excel or Spreadsheets is required to get the most out of this Excel course.

This course is also ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals and students.

At the end of this Excel class you will be given a Certificate of Completion.

STUDENT REVIEWS:

"I highly recommend this course. It was exactly what I needed to jump start my career. I learned far more than I expected. The instructor is excellent !!!!!!!!" - Troy Newman

===================================================================

"A thorough tutorial on using charts, pivot tables, etc to create dashboard reporting. Very well presented and explain complex issues in a simple way. It is clear and easy to understand and has helped me develop reporting dashboards. Excellent!" - Albert Loomer

===================================================================

"Knowing how to create charts and how to create charts USEFULLY are different skills. Andreas helps the viewer use Excel skills to produce truly useful dashboards. Highly recommend for those looking to learn data presentation." - David Anderson

===================================================================

Enrol now and enjoy!