Data Dashboards

• Report designing

1. 1. What is Report/ Dashboard
   2. Principles of reporting
   3. Using Advanced formulas to create dynamic data
   4. Merging multiple datasets
   5. Hands on exercises

• Using advanced visual techniques for reporting

1. 1. 1. Various ratios and reporting KPI’s to showcase data graphically for quick decision making
      2. Cashflow charts
      3. Waterfall charts

• Creating advanced Pivot table reports

1. Creating complex Pivot charts
2. Creating summaries in Pivots
3. Using Slicers in Pivot Table
4. Creating graphical representations through pivots
5. Customizing pivot data
6. Creating reports out of pivot tables
7. Introduction to Power Pivots

• Creating advanced reports and dashboards

1. Using data extracts from variety of sources like SAP, XERO, TALLY, etc as data sources
2. Data cleaning and making it useful for further creation of dashboards

• Learning advanced dashboard capabilities

1. Convert raw data to useful management reports / dashboards for Management Monthly Presentations
2. Creating Sample dashboards using dynamic charts and tables using dropdowns

• Some additional functionalities to create intuitive dashboards

At the end of the workshop the participants will be able to increase productivity and enhance efficiency in their day to day work by Analyzing their excel files much better, will be confident on using multiple formulae’s, Gain expertise of excel functions and its features, and self-confident on data cleaning and slicing and dicing the data for further analysis and interpretation.

In addition participants will be able to express the data graphically in a way that helps them to represents complex data sets through best visual representations and work on large and complex reports and dashboards

The training is ideal for who use excel in their day to day work and use data to create simple and complex reports and analysis.