Development Course

course overview

Click to View dates & book now


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.


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

Talk to an expert

Thinking about Onsite?

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

Please Note: All courses are availaible as Live Virtual Classes

Trusted by over 1/2 million students in 15 countries

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.