Data Engineering and Tools Workshops

Available Workshops

Programming Fundamentals for Research Professionals
Statistics for Computer Specialists
Introduction to Power BI
Beyond the Basics: Getting the Most Out of Power BI




Programming Fundamentals for Research Professionals

Although scientists are very familiar with data and statistical techniques, computer programming, data pipeline and data management techniques may be less familiar. In this workshop we will review programming basics and fundamental concepts.

Details


Although scientists are very familiar with data and statistical techniques, computer programming, data pipeline and data management techniques may be less familiar. In this workshop we will review programming basics and fundamental concepts. You will also put these to use through hands-on examples in Python and R. Coding examples will incorporate and demonstrate basic data science techniques where possible. We will also learn about the programming infrastructure surrounding code – code libraries, command line interfaces, development environments, databases and internet protocols – again with an emphasis on data science examples.

Length: 2 days
Level: Intermediate

Pre-requisites and Requirements:This workshop is suitable for people who have never programmed before, but have some background in working with data (e.g. scientific data, data in Excel spreadsheets). If you are already writing R scripts, VB scripts, or Python scripts, this workshop is not for you.


Statistics for Computer Specialists

In this workshop we will explore statistical concepts and techniques using simulated datasets and data visualization libraries. The emphasis will be on relating statistical and mathematical concepts to familiar programming techniques and concepts.

Details


Along with programming and data management, statistics plays an important part in data science. But statistics has traditionally been taught in the context of scientific experiments and the scientific method. Computer scientists and programmers can benefit from a different approach. In this workshop we will explore statistical concepts and techniques using simulated datasets and data visualization libraries. The emphasis will be on relating statistical and mathematical concepts to familiar programming techniques and concepts.

Length: 2 days
Level: Intermediate

Audience and Requirements:
This workshop is suitable for people who have a programming background but have little or no background in statistics. If you
regularly use statistical tests, have already delved into Bayesian statistics, or feel comfortable with the traditional approach to
statistics, this course is not for you.


Introduction to Power BI

This course is aimed at taking participants through the initial stages of inputting data and creating their first interactive charts, reports and visualizations.

Details

This course is aimed at taking participants through the initial stages of inputting data and creating their first interactive charts, reports and visualizations. It is a foundation course for “Beyond the Basics – Getting the most out of Power BI”. This course will help you to:

  • Understand the importance of clean data
  • How to import data from single and multiple data sources
  • Manipulating the data as it is imported into Power BI
  • Creating our first calculations
  • Creating our first custom columns
  • Creating our first charts
  • Basic interactive filtering
  • Creating basic hierarchies of data
  • How to layout a report and dashboard
  • How to publish reports and dashboards to end users

To get the most out of this course we highly recommend participants take our “Best Practice in Creating Data Visualizations and Dashboards course)

Length: One day
Level: Novice

Audience and Requirements: For those people who want to learn about the basic functionality in Power BI and want to create their first interactive charts, reports and dashboards.


Beyond the Basics: Getting the Most Out of Power BI

this course is aimed at taking participants past their first chart creation in Power BI and to shortcut the user to some relatively sophisticated visualizations that are not technically difficult to create.

Details

Length: 1 day
Level: Intermediate

Outline: The course will help you to:

  1. Get a head start on Data Modeling:
    • Where to use M and where to use DAX
    • Best practice in setting up data relationships
    • Columns vs Measures
    • Overview of Quick Measures
  2. Get up to speed in DAX – effective and easy top tips
    • Introduction to DAX for the newbie
    • Similarities and differences to Excel
    • Getting started, easy to use but useful DAX functions
  3. Show how to overcome common data analysis issues
    • Tricks and tricks with date and time fields
    • Basics of filtering
    • Sorting and bucketing
    • Drill through filtering
  4. Get on the Power User track with some useful beginner Power BI ‘hacks’
    • How to dynamically highlight values and over / under limit data points (particularly in line charts)
    • Effective use of colour to highlight values in tables and matrices
    • Setting targets using guages and kpi visualizations
    • Dynamic text – using dynamic cards to tell a story
    • Digging into weeds with the most commonly used charts
    • Getting the most out of maps – simple rules for geo data
  5. Introduction to non-standard charts (Microsoft Store add-in charts)
    • Using custom shapes in dynamic charts (using synoptic panel & MS Visio)
    • Overview of a selection of interesting add-in charts, including but not limited to Dot Plot, Bubble Chart, text filter, infographic designer, sparkline, box and whisker, ultimate waterfall (and a few others)

Audience and Requirements: for those people who have used Power BI and are moving beyond the creation of their first charts. Also for people who are thinking about switching to Power BI from other BI tools and want to find some ‘beyond the basics’ details.