Excel BI - Power View (Excel 2013)

Visualize Data Like Never Before

Course Summary

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

Course Curriculum

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

Paula Guilfoyle

After over 10 years in Accounting and Operations Paula turned her career to subject matter expert, consultant, content creation and online education. In 2010 Paula began teaching online and can now boast over 250K students in 186 different countries. In 2016 Paula began her learning journey around Blockchain and Cryptocurrency. By 2022 Paula pivoted her consultancy, content creation and online education to focus on Blockchain, Web3 and Digital Assets.

John Smith

Developer

Highly Recommended Course. Easy to Understand, Informative, Very Well Organized. The Course is Full of Practical and Valuable for Anyone who wants to Enhance their Skills. Really Enjoyed it. Thank you!!