For information on course costs and booking onto a course, please click here. For any queries please contact us on business@nptcgroup.ac.uk or call: 0330 81 88 100Welcome, Guest

Excel 2013 Power BI

Who it's For:

This video series is aimed at Excel Power Users who are looking to make intelligent business decisions based on data gathered, analyzed and presented through Excel.

What it is:

This video series on Excel Power BI will introduce you to four Microsoft Excel Add-Ins that will assist you in gathering, analyzing and presenting data.

What You'll Learn:

There are three essential steps in making intelligent business decisions. First, you'll need to gather the data. Second, you'll then need to analyze that data. And third, you'll then need to create visualized reports based on that data for presenting.

This video series will walk you through using four Excel Add-Ins specific to accomplishing these three steps. You'll experience using Excel Power Query to gather data from outside sources. Using Excel Power Query you will also begin to analyze and transform that data. Once the data is gathered and transformed you'll then experience the power of Excels PowerPivot to further analyze the data through relationships. And finally you'll dive into creating visualizations through Excels Power Map and Power View.

Topics

Excel Power BI: Part 1

  • Excel 2013 Power BI Intro
  • Intro To Power Bi
  • Powerpivot And Power View Add-ins
  • Install Power Map And Power Query
  • Using Power Query
  • Power Query Append
  • Power Query Merge

Excel Power BI: Part 2

  • Powerpivot
  • Powerpivot Calculations
  • Powermap Visualization
  • Power View Dashboard
  • Powerpivot Kpi Audio
  • Power Bi Online Audio