Register training material
10 material found

Keywords: Data Analysis 


Beyond Basics: Conditionals and Visualisation in Excel

After cleaning your database, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements. This course will cover conditional syntax, nested...

Keywords: Data Analysis, Excel

Beyond Basics: Conditionals and Visualisation in Excel https://dresa.org.au/materials/beyond-basics-conditionals-and-visualisation-in-excel After cleaning your database, you may need to apply some conditional analysis to glean greater insights from your data. You may also want to enhance your charts for inclusion into a manuscript, thesis or report by adding some statistical elements. This course will cover conditional syntax, nested functions, statistical charting and outlier identification. Armed with the tips and tricks from our introductory Excel for Researchers course, you will be able to tap into even more of Excel's diverse functionality and apply it to your research project. #### You'll learn: - Cell syntax and conditional formatting - IF functions - Pivot Table summaries - Nesting multiple AND/IF/OR calculations - Combining nested calculations with conditional formatting to bring out important elements of the dataset - MINIFS function - Box plot creation and outlier identification - Trendline and error bar chart enhancements #### Prerequisites: Familiarity with the content of Excel for Researchers, specifically: the general Office/Excel interface (menus, ribbons/toolbars, etc.) workbooks and worksheets absolute and relative references, e.g. $A$1, A1. simple ranges, e.g. A1:B5 **For more information, please click [here](https://intersect.org.au/training/course/excel201).** training@intersect.org.au Data Analysis, Excel
Cleaning Data with Open Refine

Do you have messy data from multiple inconsistent sources, or open-responses to questionnaires? Do you want to improve the quality of your data by refining it and using the power of the internet?

Open Refine is the perfect partner to Excel. It is a powerful, free tool for exploring, normalising...

Keywords: Data Analysis, Open Refine

Cleaning Data with Open Refine https://dresa.org.au/materials/cleaning-data-with-open-refine Do you have messy data from multiple inconsistent sources, or open-responses to questionnaires? Do you want to improve the quality of your data by refining it and using the power of the internet? Open Refine is the perfect partner to Excel. It is a powerful, free tool for exploring, normalising and cleaning datasets, and extending data by accessing the internet through APIs. In this course we'll work through the various features of Refine, including importing data, faceting, clustering, and calling remote APIs, by working on a fictional but plausible humanities research project. #### You'll learn: - Download, install and run Open Refine - Import data from csv, text or online sources and create projects - Navigate data using the Open Refine interface - Explore data by using facets - Clean data using clustering - Parse data using GREL syntax - Extend data using Application Programming Interfaces (APIs) - Export project for use in other applications #### Prerequisites: The course has no prerequisites. **For more information, please click [here](https://intersect.org.au/training/course/refine101).** training@intersect.org.au Data Analysis, Open Refine
Mastering text with Regular Expressions

Have you ever wanted to extract phone numbers out of a block of unstructured text? Or email addresses. Or find all the words that start with “e” and end with “ed”, no matter their length? Or search through DNA sequences for a pattern? Or extract coordinates from GPS data?

Regular Expressions...

Keywords: Data Analysis, Regular Expressions

Mastering text with Regular Expressions https://dresa.org.au/materials/mastering-text-with-regular-expressions Have you ever wanted to extract phone numbers out of a block of unstructured text? Or email addresses. Or find all the words that start with “e” and end with “ed”, no matter their length? Or search through DNA sequences for a pattern? Or extract coordinates from GPS data? Regular Expressions (regexes) are a powerful way to handle a multitude of different types of data. They can be used to find patterns in text and make sophisticated replacements. Think of them as find and replace on steroids. Come along to this workshop to learn what they can do and how to apply them to your research. #### You'll learn: - Comprehend and apply the syntax of regular expressions - Use the http://regexr.com tool to test a regular expression against some text - Construct simple regular expressions to find capitalised words; all numbers; all words that start with a specific set of letters, etc. in a block of text - Craft and test a progressively more complex regular expression - Find helpful resources covering regular expressions on the web #### Prerequisites: Comprehend and apply the syntax of regular expressions Use the http://regexr.com tool to test a regular expression against some text Construct simple regular expressions to find capitalised words; all numbers; all words that start with a specific set of letters, etc. in a block of text Craft and test a progressively more complex regular expression Find helpful resources covering regular expressions on the web **For more information, please click [here](https://intersect.org.au/training/course/regex101).** training@intersect.org.au Data Analysis, Regular Expressions
Regular Expressions on the Command Line

Would you like to use regular expressions with the classic command line utilities find, grep, sed and awk? These venerable Unix utilities allow you to search, filter and transform large amounts of text (including many common data formats) efficiently and repeatably.

You'll learn:

  • find to...

Keywords: Data Analysis, Regular Expressions

Regular Expressions on the Command Line https://dresa.org.au/materials/regular-expressions-on-the-command-line Would you like to use regular expressions with the classic command line utilities find, grep, sed and awk? These venerable Unix utilities allow you to search, filter and transform large amounts of text (including many common data formats) efficiently and repeatably. #### You'll learn: - find to locate files and directories matching regexes. - grep to filter lines in files based on pattern matches. - sed to find and replace using regular expressions and captures. - awk to work with row- and column-oriented data. #### Prerequisites: This course assumes prior knowledge of the basic syntax of regular expressions. If you're new to regular expressions or would like a refresher, take our Mastering text with Regular Expressions course first. This course also assumes basic familiarity with the Bash command line environment found on GNU/Linux and other Unix-like environments. Take our Unix Shell and Command Line Basics course to get up to speed quickly. **For more information, please click [here](https://intersect.org.au/training/course/regex201).** training@intersect.org.au Data Analysis, Regular Expressions
Data Entry and Processing in SPSS

This hands-on training is designed to familiarize you with the interface and basic data processing functionalities in SPSS. We will examine several “must know” syntax commands that can help streamline data entry and processing. In addition, we will explore how to obtain descriptive statistics in...

Keywords: Data Analysis, SPSS

Data Entry and Processing in SPSS https://dresa.org.au/materials/data-entry-and-processing-in-spss This hands-on training is designed to familiarize you with the interface and basic data processing functionalities in SPSS. We will examine several “must know” syntax commands that can help streamline data entry and processing. In addition, we will explore how to obtain descriptive statistics in SPSS and perform visualization. This workshop is recommended for researchers and postgraduate students who are new to SPSS or Statistics; or those simply looking for a refresher course before taking a deep dive into using SPSS, either to apply it to their research or to add it to their arsenal of eResearch skills. #### You'll learn: - Navigate the SPSS working environment - Prepare data files and define variables - Enter data in SPSS and Import data from Excel - Perform data screening - Compose SPSS Syntax for data processing - Obtain descriptive statistics, create graphs & assess normality - Manipulate and transform variables #### Prerequisites: In order to participate, attendees must have a licensed copy of SPSS installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software. **For more information, please click [here](https://intersect.org.au/training/course/spss101).** training@intersect.org.au Data Analysis, SPSS
Exploring Chi-Square and correlation in SPSS

This hands-on training is designed to familiarize you further with the SPSS data analysis environment. In this session, we will traverse into the realm of inferential statistics, beginning with linear correlation and reliability. We will present a brief conceptual overview and the SPSS procedures...

Keywords: Data Analysis, SPSS

Exploring Chi-Square and correlation in SPSS https://dresa.org.au/materials/exploring-chi-square-and-correlation-in-spss This hands-on training is designed to familiarize you further with the SPSS data analysis environment. In this session, we will traverse into the realm of inferential statistics, beginning with linear correlation and reliability. We will present a brief conceptual overview and the SPSS procedures for computing Pearson's r and Spearman's Rho, followed by a short session on reliability . In the remainder of the session, we will explore the Chi-Square Goodness-of-Fit test and Chi-Square Test of Association for analysing categorical data. #### You'll learn: - Perform Pearson’s Correlation (r) Test - Perform Spearman’s Rho Correlation (⍴) Test - Carry out basic reliability analysis on survey items - Perform Chi-Square Goodness-of-Fit test - Perform Chi-Square Test of Association #### Prerequisites: In order to participate, attendees must have a licensed copy of SPSS installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software. This workshop is recommended for researchers and postgraduate students who have previously attended the Intersect’s [Data Entry and Processing in SPSS](https://intersect.org.au/training/course/spss101/) workshop. **For more information, please click [here](https://intersect.org.au/training/course/spss102).** training@intersect.org.au Data Analysis, SPSS
Getting Started with Tableau for Data Analysis and Visualisation

Tableau is a powerful data visualisation software that can help anyone see and understand their data. With the features to connect to almost any database, drag and drop to create visualizations, and share with a click, it definately makes thing easier.

This course is suitable for all researchers...

Keywords: Data Analysis, Tableau

Getting Started with Tableau for Data Analysis and Visualisation https://dresa.org.au/materials/getting-started-with-tableau-for-data-analysis-and-visualisation Tableau is a powerful data visualisation software that can help anyone see and understand their data. With the features to connect to almost any database, drag and drop to create visualizations, and share with a click, it definately makes thing easier. This course is suitable for all researchers and research students from any discipline. It provides step by step guides on how to visualise your research data on an interactive dashboard. #### You'll learn: - Import and combine data - Filter data - Create cross tabulation table - Create interactive plots including graph map - Create and design an interactive dashboard #### Prerequisites: The course has no prerequisites. **For more information, please click [here](https://intersect.org.au/training/course/tableau101).** training@intersect.org.au Data Analysis, Tableau
Getting Started with Excel

We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors.

This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool,...

Keywords: Data Analysis, Excel

Getting Started with Excel https://dresa.org.au/materials/getting-started-with-excel We rarely receive the research data in an appropriate form. Often data is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. This webinar targets beginners and presents a quick demonstration of using the most widespread data wrangling tool, Microsoft Excel, to sort, filter, copy, protect, transform, aggregate, summarise, and visualise research data. #### You'll learn: - Introduction to Microsoft Excel user interface - Interpret data using sorting, filtering, and conditional formatting - Summarise data using functions - Analyse data using pivot tables - Manipulate and visualise data - Handy tips to speed up your work #### Prerequisites: The webinar has no prerequisites. **For more information, please click [here](https://intersect.org.au/training/course/excel001).** training@intersect.org.au Data Analysis, Excel
Excel for Researchers

Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. We'll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise,...

Keywords: Data Analysis, Excel

Excel for Researchers https://dresa.org.au/materials/excel-for-researchers Data rarely comes in the form you require. Often it is messy. Sometimes it is incomplete. And sometimes there's too much of it. Frequently, it has errors. We'll use one of the most widespread data wrangling tools, Microsoft Excel, to import, sort, filter, copy, protect, transform, summarise, merge, and visualise research data. While aimed at novice Excel users, most attendees will walk away with new tricks to work more efficiently with their research data. #### You'll learn: - 'Clean up’ messy research data - Organise, format and name your data - Interpret your data (SORTING, FILTERING, CONDITIONAL FORMATTING) - Perform calculations on your data using functions (MAX, MIN, AVERAGE) - Extract significant findings from your data (PIVOT TABLE, VLOOKUP) - Manipulate your data (convert data format, work with DATES and TIMES) - Create graphs and charts to visualise your data (CHARTS) - Handy tips to speed up your work #### Prerequisites: In order to participate, attendees must have a licensed copy of Microsoft Excel installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software. **For more information, please click [here](https://intersect.org.au/training/course/excel101).** training@intersect.org.au Data Analysis, Excel
Getting started with NVivo for Windows

Does your research see you working through unstructured and non-numerical data? With the ability to collect, store and analyse different data types all in the one location makes, it's easy to see why NVivo is becoming the tool of choice for many researchers.

NVivo allows researchers to simply...

Keywords: Data Analysis, NVivo

Getting started with NVivo for Windows https://dresa.org.au/materials/getting-started-with-nvivo-for-windows Does your research see you working through unstructured and non-numerical data? With the ability to collect, store and analyse different data types all in the one location makes, it's easy to see why NVivo is becoming the tool of choice for many researchers. NVivo allows researchers to simply organise and manage data from a variety of sources including surveys, interviews, articles, video, email, social media and web content, PDFs and images. Coding your data allows you to discover trends and compares themes as they emerge across different sources and data types. Using NVivo memos and visualisations combined with the ability to integrate with popular bibliographic tools you can get your research ready for publication sooner. #### You'll learn: - Create and organise a qualitative research project in NVivo - Import a range of data sources using NVivo's integrated tools - Code and classify your data - Format your data to take advantage of NVivo’s auto-coding ability - Use NVivo to discover new themes and trends in research - Visualise relationships and trends in your data #### Prerequisites: In order to participate, attendees must have a licensed copy of NVivo installed on their computer. Speak to your local university IT or Research Office for assistance in obtaining a license and installing the software. This course is taught using NVivo 12 Pro for Windows and is not suitable for NVivo for Mac users. **For more information, please click [here](https://intersect.org.au/training/course/nvivo101).** training@intersect.org.au Data Analysis, NVivo