search CPD courses
Search

 

Excel BI - Power ViewProduct Code : Excel2017-06

Excel BI - Power View

Power View is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers

COURSE SUMMARY

Power View is available in Excel 2013 and SharePoint Server 2010. In Power View, you can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. For every visualization you want to create, you start with a table, which you can then easily convert to other visualizations, to determine which one best illustrates your data.

LEARN TO USE POWER VIEW CHARTS AND MAPS OF ALL TYPES TO VISULAISE DATA TO AID BUSINESS DECISIONS AND SET UP HIREARCHY TO MAKE VISULAISATIONS MORE INTERACTIVE

MICROSOFT'S EXCEL, WHICH INCLUDES POWER VIEW, IS NOW PART OF A SELF SERVICE BI SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND THE BASIC LEVEL THEN THIS COURSE IS FOR YOU

CONTENTS AND OVERVIEW

In this course you will learn how, with Power View, and when to visualise data using

  • Column and Bar Charts
  • Pie Charts
  • Line charts
  • Scatter/bubble charts

You will learn how to set up hierarchy and make these charts more interactive to give deeper analysis and how to visualise data on Maps

In addition to this through the sample data, will look at how trends in data are easily spotted using visualisation, making business decisions easier and actionable.

Who Should Attend?

This course is suited to those with an interest in Excel, Data Analyst's, Data Mining, BI and Reporting  This course is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.

  • This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.
  • This course is for you if you are looking to learn Excels Self Service BI functions.
  • This course is not for you if you are new to Excel.

What’s included?

Instruction by an expert

12 months access 24/7

Certificate of completion

How long will it take and how much does it cost?

Completion Time 2 Hours

€56

*please note that you cannot use your €50 CPD voucher for the Excel Club online courses
€ 56