Date(s) - 28/05/2019
1:00 pm - 4:00 pm
DAT206x – Analysing and Visualising Data with Excel
This half-day course for Excel is one of the most widely used solutions for analysing and visualising data. It now includes tools that enable the analysis of more data, with improved visualizations and more sophisticated business logics. In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016 from an expert on the Excel Product Team at Microsoft.
Learn how to import data from different sources, create mashups between data sources, and prepare data for analysis. After preparing the data, find out how business calculations can be expressed using the DAX calculation engine. See how the data can be visualised and shared to the Power BI cloud service, after which it can be used in dashboards, queried using plain English sentences, and even consumed on mobile devices.
It is assumed attendees have good general computing skills and are familiar with the Windows environment.
At Course Completion
After completing this course, students will be able to:
• Gather and transform data from multiple sources
• Discover and combine data in mashups
• Learn about data model creation
• Explore, analyse, and visualize data
Data Analysis in Excel
Create an Excel Table (optional)
Using VLOOKUP (optional)
The Excel Data Model
Importing Data from a CSV file
From PDF to Data Model using Flash Fill
Importing Data from Databases
Importing Data from Multiple Files
Create a Date Table in Excel Data Model
Creating and Formatting Measures
Using Advanced DAX Functions
Importing Data from a Formatted Excel Report
Visualising Data in Excel
Cube Functions (optional)
Treemap Chart using Cube Functions (optional)
Using Excel with Power BI
Power BI Mobile App
Bookings are closed for this event.