Brochure download
Fill in your details
  • +91-80-42188793

Mega Package : Essential Skills for Data Science, Data Analytics, Business Analytics, MIS Reporting --> 26 Courses, 350+ Videos, 150+ Hours Video Contents, Downloadable Practice Files, 300+ Downloadable E-Books, 150 MS Excel Editable, Reusable templates, 300+ Excel, CSV Data Sets, 100000+ Infographics, Graphics & Images Library, 1000+ Sample Editable Resumes, 70000+ Designer Fonts, Instagram, YouTube Thumbnails & Stories


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.


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
  • 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


  • M: +91 9066068793, 9066078793, 9902058793
  • E:


  • M: +91 7619483672
  • E:

Copyright ©2018 iTAS. All Rights Reserved