Introduction to Excel 2013 Power Business Intelligence Alison Course GLOBAL - Digital Certificate

Learn how to use Excel 2013 Power Business Intelligence features and functions. Introduction to Excel 2013 Power BI will teach you about the Power Business Intelligence (BI) tools you can add to Excel 2013. You will learn about using power query to import data from the Internet, and add that data to your Excel worksheet. This course also teaches you to display your data with Power Views and Power Maps.The course begins by introducing you to the Power BI tools and setting them up in Microsoft Excel 2013. It teaches to create a power query to get data from a web page, where you will also learn about modifying your power query and adding the data from the query to your Excel worksheet. This course also includes learning about preparing your data model for creating a power view and adding an url image to your data tables.You will learn about the different visualizations you can use to display your data in power view and interacting with reports in power view to get them to display different data. You will also learn about tiling a card report so it won’t affect your other reports in the same power view, and how to add a simple map to display in your power view.Finally, this course will teach you to create power maps and about data you need to modify in your data model to activate it. You will learn that power maps uses Bing maps and you will need geographical information in your data model for power maps to work properly. You will also learn about creating new scenes and displaying your data on a power map. You will learn about setting the transition between your scenes and creating a video out of your finished power map.This course will be of great interest to business, accounting and finance professionals who wish to expand their knowledge of Microsoft Excel 2013 and learn about displaying their Excel worksheet data for more dynamic and engaging presentations.