Request Call Back
Please Contact Us
  • +91-80-42188793
  • enquiry.itas@gmail.com

NEW BATCHES : Check Batch Schedules for New Batches | Early Bird Offers available for all the courses

>

Dashboard Designing, Automation and Reporting

Fees : Rs 10,000 Only

Duration : 24 Hours

A business dashboard is an information management tool that is used to track KPIs, metrics, and other key data points relevant to a business, department, or specific process. Through the use of data visualizations, dashboards simplify complex data sets to provide users with at a glance awareness of current performance.

Prerequisites:

Good knowledge on Excel and Macro is required

Course Objectives:

After the course, you will be able to:

  • Develop Simple to Dynamic Dashboards
  • Perform Automation with other MS office Tools

Course Contents

  • Introduction
  • Understand Dashboard Concepts
  • Understand Client Requirements
  • Data Visualization Techniques
  • Designing Cover Page, Buttons, Banners
  • Navigation Techniques
  • Understanding Raw Data
  • Understanding Reporting
  • Creating Calculation Sheets
  • Data Modeling
  • Working on Charts & Tables
  • Standardization of Table & Charts
  • Reports using Advanced Charting Techniques
  • Working with Active X Controls
  • Working with User Form Controls
  • Reports Using Pivot Table, Pivot Charts
  • Creating Dashboards using Slicers
  • Working with External Data
  • Exporting Data to Excel, Access, PPT, TXT, CSV
  • Importing Data from Excel, Access, PPT, TXT, CSV
  • Exporting Charts, Tables to PowerPoint
  • Updating Charts, Table in PowerPoint
  • Linking Charts, Tables in PowerPoint
  • Converting Reports into PDF
  • Protecting VBA Macros
  • Protecting Worksheets & Workbook
  • Limiting Access to specific Users
  • Securing Dashboards and Reports
  • Projects
  • Tips & Tricks

iTAS (iTech Analytic Solutions) is a complete Analytics Solution provider with. unparalleled value-optimizing Information Insight to client organizations through the use of cutting-edge, customized reporting systems, analytical models, and database applications

iTAS (iTech Analytic Solutions) provides data driven business decisions with quantitative modeling expertise & deep understanding of business needs and state-of-the-art technologies to solve complex problems.

Contact Us

  • +91-80-42188793
  • enquiry.itas@gmail.com
  • Branch 1:No. 9, 1st Floor, 8th Main, 9th Cross, SBM Colony, Brindavan Nagar,Mathikere, Bengaluru, Karnataka, India - 560054
  • Branch 2:#403, 11th Cross,19th Main, 1st Block, Rajajinagar, Bengaluru - 560 010

Copyright ©2018 iTAS. All Rights Reserved

Brochure download