Excel BI - Power View

Visualize Data Like Never Before

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 VISUALIZE DATA TO AID BUSINESS DECISIONS AND SET UP HIERARCHY TO MAKE VISUALIZATIONS 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 visualize 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 visualize data on Maps

In addition to this through the sample data, will look at how trends in data are easily spotted using visualization, 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?

Completion Time 2 Hours



Intended Audience: Excel Users, Finance staff, accountants

Turning on Power View and the Ribbons
The Data Set
Course Workbooks
Column Charts
Activity 1
Pie Charts
Activity 2
Line Charts
Activity 3
Maps
Activity 4
Moving Scatter Charts
Activity 5
Using Cards and Tiles
Adding Images to the Data Source and updating the data connection
Activity 6
Working with Tables of Data within Excel
Conclusion.mp4

What's included

  • 11 Video Lessons
  • 7 Text Lessons

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle

Instructor

My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.