All you wanted to know about Self-Service Dashboards in Excel

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2 Hours | Lec: 12 | 831 MB

Genre: eLearning | Language: English

Smart techniques and new capabilities to develop instant Dashboards of MS Excel

This course takes a profound look at the new capabilities of MS Excel to develop instant Dashboards. These smart techniques will allow you to design self-service dashboards in minutes. The topics covered in this course primarily focuses on Analysis proficiencies.

At the end of the course, participants would learn/use/acquire the following techniques/knowledge:

Generate Pivot tables and charts to explore data sets

Implement slicers to develop instant dashboards

Appreciate the use of Sparklines to in-cell histograms

Reduce data speculation by using Excel’s data Analysis capabilities

This course is designed for Excel users, project managers, and decision makers who want to fill the gap between an Excel spreadsheet and a complete business intelligence solution. Leveraging Power Bi from Microsoft, candidates will learn how to pull data into an Excel spreadsheet from a multitude of sources, how to format and prepare that data prior to loading into an analytical model, and how to create visualizations and dashboards upon that data.