course overview
Overview
Welcome to our comprehensive course on data analysis and visualization! In today's data-driven world, the ability to work with data effectively is a crucial skill. Whether you're a beginner or looking to enhance your data analysis skills, this course is designed to provide you with a solid foundation and practical knowledge.
Outline
Introduction to data
• Collect, extract and load data in different formats
• Use Excel’s powerful Get & Transform Data functions to import, query and transform our
• data
• Install and use Excel’s Analysis Toolpak to explore the key features of our data
• Communicate the stories in our data using PivotTable
• Build an interactive dashboard that will allow users to query the data
• Types of data
• Algorithms
• Data citizenship
• Data transformation Current Industry Status
Statistics and Data Techniques
• Use conditional formatting to identify and communicate characteristics of data
• Understand the principles of good data visualisation and when it is appropriate to use
various tools
• Create a variety of visualisations in Excel including scatterplots, line graphs, combo charts
• and histograms
• The data analyst
• Descriptive analysis
• Data warehousing
• Line of business users
Dashboards & Statistics
• Build a dashboard using Excel
• Understand the concept of the central tendency and its application to data analysis
• Understand measures of spread and their application to data analysis
• Analyse correlation and its implications
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.
All $ prices are in USD unless it’s a NZ or AU date
SPVC = Self Paced Virtual Class
LVC = Live Virtual Class
Our clients have included prestigious national organisations such as Oxford University Press, multi-national private corporations such as JP Morgan and HSBC, as well as public sector institutions such as the Department of Defence and the Department of Health.
