ClickCease

 

Workshop: Data Analytics and Creating Excel Dashboards 

Date:  9th December 2019
Venue: 87 Beach Road, Chye Sing Building, Singapore 189695, Nearest MRT: Bugis
Timing : 9 AM to 5 PM
Fees: S$ 249/ Participant

In today’s economy where the use of technology is growing in leaps and bounds; EXCEL still caters to be the backbone of every tool and technology implemented. Every organization deals with humungous amounts of data; Hence knowing how to build interactive dashboards is the best way to make the data more meaningful and worth interpretation

This workshop will help you deal with huge data and enable you to create meaningful dashboards, synthesize information logically and summarize the information with the help of tables, graphs and charting options

This workshop is specially designed for corporate professionals who work on data in their day to day framework and need to interpret, analyze and present information for further decision making.

At the end of this workshop you will be able to

  • Create complex and dynamic dashboards by using excel tools and formulae’s and analyze data by interactive visual presentation
  • Create analytical presentations for steer committee’s and make board presentations
  • Know dynamics of current Business Intelligence tools and data warehousing techniques that are currently being used in different organizations.

This will be 1 day  exhaustive workshop where there will be classroom teaching followed by case studies and practical application of their work; under the thorough guidance by the trainer

This workshop is specifically designed for both beginners and advanced corporate professionals to help them keep abreast of the new tools and technologies running in the market and also to ensure the expertise of the key MS office applications that are needed on day to day basis to perform their tasks effectively and efficiently  

What will you learn:

By the end of the workshop you will be able to learn the following:

  • Drawing insights from data and understanding of the data and information systems
  • Learn to create an interactive dashboard with best visual presentations through graphical and tabular representation
  • Logically summarize the data to help gather insightful information and present the same for further decision making
  • Understand the use of excel formulae, tools and any Business intelligence tool that you may need basis the requirements from the top leadership
  • Enabling young professionals to be functional experts and making them understand the nuisances of data warehousing techniques in modern world
  • Overview of current Business Intelligence tools available in market and its deployment and costing aspects

Course Outline:

  • Understand the MS office application and the usage of MS Excel, MS Power-point and the functionalities used by corporates
  • Using Excel for data analysis
    • Usage of graphs and tables as per the data requirements
    • Pivot tables and its usage
    • Advanced Excel techniques
    • Using developer options to make dynamic excel reporting as web reporting
  • Using Power- Point for data analysis
    • Usage of templates and Animations for Board presentations in Power-point
    • Using Graphs and tables to represent facts and figures
    • Calculating measures
    • Embedded tools in MS office applications
    • Usage of smart art and formatting options
    • Advanced pictorial options and presentations for senior leaderships
  • Shortcuts: Both in excel and Power-point to enhance the speed and working
  • Dashboard reporting
  • Dashboard design combining all of the above
  • Insight generation for further decision making
  • Introduction to Business Intelligence tools and data warehousing techniques
  • Deployment to Business intelligence tools enterprise wide post understanding cost and usability

Working with Data

  • Cleaning and Mining of data to make it in a format easy to work with
  • Using functions and formulae
  • Using nesting functions
  • Address and Match the references to link up multiple files together
  • Working with text and relate the same with figures

Charting Options

  • Overview of different 2 dimensional charts
  • Principles of using different charts
  • Difference between charts used in board presentations and internal reporting
  • Creating 3 Dimensional charts
  • Defining and working in different axis, sources and references
  • Creating dynamic charts

Graphical and tabular representation

  • Principles to use graphs and tables
  • Analyzing tricks and techniques for quick insight generation
  • How to do industry analysis and competitor analysis

Dashboard designing

  • Why do we need a dashboard!
  • How to build a dashboard!
  • Dashboard layout and designing
  • Functionalities to be shown in dashboard
  • Coloring techniques used for strategic reporting
  • Inserting charts and text
  • Creating dynamic functionalities using graphs, tables and charts
  • Embedding objects if any

Data Warehousing techniques

  • Overview of Data warehouse design – Modern day principles and Methodologies
  • Data warehouse Architectures
  • Understanding different terms and technology and its usage in modern world
  • Introduction to ETL and Data marts
  • Understanding of Presentation Layer
  • How does data transfer to Dashboards for use by the business!
  • Preparation to be a Functional Manager

Learning about Business Intelligence and Tools used in modern world

  • Business Intelligence Tools features and capabilities
  • Snapshot of current BI tools
  • Understanding the costing and Logistics
  • Quick Overview of Qliksence and SAP Business Objects
  • Principles of choosing a BI tool for the organization

This course is specifically designed for all those individuals who use MS office on day to day basis and would want to gain good knowledge on this software to enhance their productivity in work.

All individuals like corporate professional’s, doctors, architects, small business owners, home makers, etc would learn different aspects of this tool and will help them work with enhanced productivity and better expertise

Participants are expected to bring their laptop with pre-installed MS Office

You can discuss your unique requirements at +65 84831463 or simply fill the required details on Enquiry Now Page and send us at divya@outsourcingwise.com

Enquire Now

Course Cancellation / Reschedule Policy

OutsourcingWise reserves the right to cancel or reschedule the course due to unforeseen circumstances. If the course is cancelled from our end, management will refund 100% to its participants

Note: the minimal class size to start the class would be 3 pax