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

Who should attend

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.

Pre-requisites

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