This course aims to bring you up to speed on the new BI functionality in Excel 2013 and 365.
Starting with a recap on Pivot tables we will move on to focus on how you can get PowerPivot to create links between tables by building relationships and managing them.
PowerPivot can integrate different sources of almost any kind of data presented in tables.
You can analyse data from databases, Excel Worksheets, and other sources together. Then use PowerView to create an interactive dashboard. In addition you will see how you can display geographical data on a map
Starting with a recap on Pivot tables we will move on to focus on how you can get PowerPivot to create links between tables by building relationships and managing them.
PowerPivot can integrate different sources of almost any kind of data presented in tables.
You can analyse data from databases, Excel Worksheets, and other sources together. Then use PowerView to create an interactive dashboard. In addition you will see how you can display geographical data on a map
- PIVOT TABLES
- - Recap on Essentials
- - Adding Pivot Charts
- - Utilising Slicers
- POWER PIVOT
- Getting Started with PowerPivot
- Creating a Data Model
- Creating a Pivot Table on the PowerPivot Model
Here is what some of our previous delegates have said!
"Very helpful, kept it at the pace I found it easiest to work through. Brilliant "
White Line Break
"I Should have done this years ago - John made it really easy to understand. I had one to one coaching and now - Dashboards here I come!!!"
White Line Break
"John was really great. Made everyone feel at ease."
White Line Break
"Really enjoyed the course and learned loads. Can't wait to get back to work and try it out."
White Line Break
Self-service business intelligence brings the power of analysis and visualisation of data to today’s managers. The tools required to retrieve, discover and present the findings have now been assembled and added to the newest version of Excel. This means todays managers can create their own analysis shortening the process and thus making the business more agile.
Excel BI
Pivot Tables have long been a part of Excel but now the added functionality of PowerPivot means linked tables open up a whole new world of possibilities. PowerView allows the creation of really clear interactive reports while PowerMap allows you to create a geo presentation of your data and display it over time.
The real benefit of adding this functionality to Excel is because it is already a familiar working environment. This means that you only need to learn the new functionality and how it works. This course aims to show you all the functionality to enable you to work with greater efficiency and better business insights
There has been a critical error on this website.