This balanced one day course starts by showing you how to import and connect to data from a variety of different sources, including Excel, CSV files and the web.
It then focuses on the process of transforming and cleaning data, and appending and merging data tables together. You will learn how to run queries across tables by implementing table relationships know as Data Models.
Then we look at outputting the resulting data sets in a range of visualisations to create detailed reports. The course finishes by looking at the process of sharing those reports on the web.
An intermediate knowledge of Microsoft Excel and access to Office 365 is preferable.