How does one manage a team facing real data analysis? In this one-week course, we contrast the ideal with what happens in real life. In this way, you will learn key concepts that will help you manage real-life analysis.
Data driven decision-making
Learn about data science and how you can use it to strengthen your organisation. This course will teach you about the skills you need on your data team, and how you can structure that team to meet your organisation's needs. It will also provide you with an understanding of data sources your company can use and how to store that data.
This class is for anyone who wants to learn what all the data science action is about, including those who will eventually need to manage data scientists. The goal is to get you up to speed as quickly as possible on data science. We've designed this course to be as convenient as possible without sacrificing any of the essentials.
This course will cover the basic ways that data can be obtained: from the web, from APIs, from databases and from colleagues in various formats. It will look at the basics of data cleaning and how to make data tidy. The course will also cover the components of a complete data set, including raw data, processing instructions, codebooks and processed data, and the basics needed for collecting, cleaning and sharing data.
In this course, you will learn the many ways to import data into Python: from flat files such as .txt and .csv; files native to other software such as Excel spreadsheets, Stata, SAS and MATLAB files; and from relational databases such as SQLite and PostgreSQL.
Practical data cleaning is a thorough introduction to the basics of data cleaning. It is perfect for beginners and takes you through data collection, data cleaning, data classification and data integrity.
This course covers the essential exploratory techniques for summarising data. These techniques are typically applied before formal modelling starts and can help inform the development of more complex statistical models. Exploratory techniques are also important for eliminating or sharpening potential hypotheses about the world that can be addressed by the data.
Build data analysis and business modelling skills. Gain the ability to apply statistics and data analysis tools to various business applications.
Statistics you need in the office: descriptive and inferential statistics, hypothesis testing and regression analysis.
Master statistics with R. Statistical mastery of data analysis including inference, modelling and Bayesian approaches.
Acquire new skills fast in courses that combine short expert videos with immediate hands-on-keyboard exercises. A collection of courses using Python, from an introduction, to modules and data importing, data cleaning, and data visualisation all using Python.
This course will give you a full overview of the data science journey. Upon completion, you will know: how to clean and prepare your data for analysis; how to perform basic visualisation of your data; how to model your data; how to curve-fit your data; and how to present your findings.
In this course, you will learn how to communicate analytics results to stakeholders who do not understand the details of analytics but want evidence of analysis and data. You will be able to choose the right vehicles to present quantitative information, including those based on principles of data visualisation. You will also learn how to develop and deliver data analytics stories that provide context, insight and interpretation.
Learn the general concepts of data mining along with basic methodologies and applications. Then dive into one subfield in data mining: pattern discovery. Learn in-depth concepts, methods and applications of pattern discovery in data mining. We will also introduce methods for pattern-based classification and some interesting applications of pattern discovery.
In this course you will learn how to become a master at communicating business-relevant implications of data analysis. By the end, you will know how to structure your data analysis projects to ensure they yield results for your stakeholders. You will also know how to streamline your analysis and highlight implications efficiently using visualisations in Tableau.
Further courses on data analytics can be found on the sites of these suppliers:
ICAEW accepts no responsibility for the content on any site to which a hypertext link from this site exists. The links are provided ‘as is’ with no warranty, express or implied, for the information provided within them. Please see the full copyright and disclaimer notice.
Courses from the ICAEW Academy of Professional Development
This course will introduce you to the topic of big data and analytics. In a practical and insightful workshop, you will get an up-to-date overview of big data and how to apply it to your organisation.
This one-day course from ICAEW introduces delegates to statistics and analysis and takes them through the six key concepts that underlie all statistical thinking and analysis: probability, risk, distribution, expectation, variance and correlation. The course shows delegates how to apply these concepts using Microsoft Excel.
This one-day course introduces delegates to statistical forecasting. It is designed for anyone involved in business planning and performance analysis. The course uses a mixture of stimulating discussions and real-life case studies. Each concept will be carefully explained, its relevance to forecasting highlighted and show how the relevant calculations can be done in Excel.
The objective of this one-day training class is to enable you to use your data to communicate a story and insights to an audience, through a mix of data visualisation and storytelling. The class is focused on best practices based on scientific evidence and current theory, and has the business-oriented audience in mind.
Academy eLearning modules
Get to grips with fundamentals of data planning with this eLearning resource from ICAEW's Academy of Professional Development. Learn how to: better plan and more efficiently analyse your data, as well as apply the three principles of good spreadsheet design to your work
Learn the key skills at the heart of being an effective finance business partner by completing this eLearning resource from ICAEW's Academy of Professional Development. The module outlines: what finance business partnering means; how finance partners generate influence; and how to start building your influence with ICAEW's top 10 tips.
This eLearning resource from ICAEW's Academy of Professional Development outlines the difference between data, information and insight, explains why it is important to deal in insight and demonstrates how to translate data into insights using a simple process.
Finance in a Digital World
FDW has an eLearning module entitled Analytics and visualisation for finance
There are now eight different suites of Excel online training available to Excel Community members as part of their membership subscription – this is a major benefit of Community membership.