Data Analytics and Creating Excel dashboards

Outsourcingwise is a professional services firm which specialises in providing consulting services on technical accounting and reporting problems tailored for businesses of all sizes – right from sole-proprietors to small, medium and large firms.

Divya Arora from OutsourcingWise.com

Workshop to help you deal with huge data, create meaningful dashboards and summarize with the help of tables, graphs and charts

Chye Sing Building

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
<ul><li>Usage of graphs and tables as per the data requirements
</li><li>Pivot tables and its usage
</li><li>Advanced Excel techniques
</li><li>Using developer options to make dynamic excel reporting as web reporting
</li>Using Power- Point for data analysis
</ul>Usage of templates and Animations for Board presentations in Power-point
<ul><li>Using Graphs and tables to represent facts and figures
</li><li>Calculating measures
</li><li>Embedded tools in MS office applications
</li><li>Usage of smart art and formatting options
</li><li>Advanced pictorial options and presentations for senior leaderships
</li></ul>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
<ul><li>
Cleaning and Mining of data to make it in a format easy to work with
</li><li>Using functions and formulae
</li><li>Using nesting functions
</li><li>Address and Match the references to link up multiple files together
</li><li>Working with text and relate the same with figures
</li></ul>Charting Options
<ul><li>
Overview of different 2 dimensional charts
</li><li>Principles of using different charts
</li><li>Difference between charts used in board presentations and internal reporting
</li><li>Creating 3 Dimensional charts
</li><li>Defining and working in different axis, sources and references
</li><li>Creating dynamic charts
</li></ul>Graphical and tabular representation
<ul><li>Principles to use graphs and tables
</li><li>Analyzing tricks and techniques for quick insight generation
</li><li>How to do industry analysis and competitor analysis
</li></ul>Dashboard designing
<ul><li>
Why do we need a dashboard!
</li><li>How to build a dashboard!
</li><li>Dashboard layout and designing
</li><li>Functionalities to be shown in dashboard
</li><li>Coloring techniques used for strategic reporting
</li><li>Inserting charts and text
</li><li>Creating dynamic functionalities using graphs, tables and charts
</li><li>Embedding objects if any
</li></ul>Data Warehousing techniques
<ul><li>Overview of Data warehouse design – Modern day principles and Methodologies
</li><li>Data warehouse Architectures
</li><li>Understanding different terms and technology and its usage in modern world
</li><li>Introduction to ETL and Data marts
</li><li>Understanding of Presentation Layer
</li><li>How does data transfer to Dashboards for use by the business!
</li><li>Preparation to be a Functional Manager
</li></ul>Learning about Business Intelligence and Tools used in modern world
<ul><li>
Business Intelligence Tools features and capabilities
</li><li>Snapshot of current BI tools
</li><li>Understanding the costing and Logistics
</li><li>Quick Overview of Qliksence and SAP Business Objects
</li><li>Principles of choosing a BI tool for the organization</li></ul>Who should attendThis 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-requisitesParticipants are expected to bring their laptop with pre-installed MS Office

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Data Analytics and Creating Excel dashboards

More events from Divya Arora from OutsourcingWise.com

Discover more events from Divya Arora from OutsourcingWise.com, from Business to other experiences you might love.

Data Analytics and Creating Excel dashboards

More events from Divya Arora from OutsourcingWise.com

Discover more events from Divya Arora from OutsourcingWise.com, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.