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

Rapid Skillz

Precio a consultar

Información importante

  • Short course
  • Beginner
  • Online
  • Duración:
    1 Year
  • Cuándo:
    A definir

Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features. Microsoft Excel still remains the top Business Intelligence tool in use today, and it will continue its reign despite marketing efforts of other BI technology vendors. Since most of the organizations already have highly skilled Excel users, they migrate swiftly to a self-service BI capability and tend to create their own BI solution intuitively without much dependence on IT. 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.

Información importante
¿Qué objetivos tiene esta formación?

The Objective of this course is to enable understudies to understand and 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.

Requisitos: Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.


¿Dónde se da y en qué fecha?

comienzo Ubicación
A definir

¿Qué aprendes en este curso?

MS Excel


This Course Consists of the following Contents -1.Creating Pivot Tables using complex datasets, 2.Generating Pivot Charts Instantly, 3.Implementing Slicers to build Interactive dashboards, 4.Grouping and Sub Total of Data in Pivots, 5.Beautifying reports / tables using Sparklines, 6.Designing Aged Reports and understanding data bucketing concepts, 7.Reducing speculation with What-If-Analysis - Goal Seek, Data Table, Scenario Manager, 8.Quick Analysis Tools - for Charts, Tables, Formatting etc. (Excel 2013). Through these subjects skills are developed and knowledge is acquired in order to fulfil a position or job efficiently and with confidence. Our online methodology makes it easier to combine your professional and personal life. Even you have a busy day to day live, this course adapts itself to your routine. Should you have any doubts, please do not hesitate to ask for more information through Emagister, leading educational portal.

Información adicional

This Course is made for Students and the Self-service business intelligence tools are becoming more and more desirable, and robust, as companies look for ways to enable all types of users, including casual users, power users, and executives to independently perform new queries, reports, analytics, and dashboards. Self-service BI has been a hot topic for the last several years because of the potential benefits it can offer organizations.