The following tutorial will walk you through the steps to access various visualization and analysis tools provided to UW students for FREE. Follow the steps below to gain access to SPSS, SAS, Stata, Tableau, and more.
The best part? You won't use space on your device, because it's all available via remote access to a UW server!
On this page, scroll down on the page until you see the "Apply for a CSDE Account"
A new window will open, sign in with your UW NetID.
You should receive an email confirming your application.
For Windows:
If you're on a Windows device, you should already have this installed.
For Mac:
You'll have to download the Microsoft Remote Connection application Here.
This is the final step! Go to this page and expand the section on "Connecting to Windows Terminal Servers". Follow the steps listed there and sign into your newly created CSDE account (uses NetID) and you'll have access!
When you access the CSDE server, you will be prompted to enter a username and password. For username enter "NETID\-YourNetID-" (you need to add the "NETID\" part), then for password enter your NetID password.
If you’re working with large data sets, visualization tools can help you quickly make sense of what the data is telling you. This section is broken into three parts: Programs, Usage, and Learning. The Programs section lists software (click to go to company documentation), Usage overviews the main benefits of each tool, and Learning provides additional resources to help you learn each tool in greater depth.
A desktop and cloud based data visualization tool allowing users to quickly create powerful visuals from any dataset. Great for quickly presenting geographical trends, sales data, and much more. Allows you to create stylish dashboards to track your most important data. If you’re into coding, Tableau integrates with R and Python, giving you much more power over the tool.
SPSS allows you to quickly visualize large data sets and model them with click-and-run commands (no need to code). You can run anything from simple regressions to Bayesian and ARIMA models with the tool. Used in Marketing Mix Modeling, Biological research, Market research, and more. Capable of producing predictive models for advanced analytics work. You can perform all popular statistical methods within SPSS.
Stata is a command line-based analysis tool primarily used in academia (Economics). The language requires knowledge of syntax (link to syntax provided in Learning below), and allows users to regress large data sets and generate graphs. The software is separated into two main functions: Graphics and Statistics. There is an excellent forum community where users posts solutions to various functions. Stata syntax here.
A Microsoft-built application allowing users to create custom visualization dashboards locally and from the cloud. Easy to learn the basics and upload datasets to visualize. Integrate with automatically updating databases so you can track your performance in real time. Power BI also has a slider feature to test different hypotheses and see the outcomes.
The languages and tools below are used in the data science fields in multiple areas. Python is used in computer science for artificial intelligence and predictive modeling (...and seemingly infinite other things). R is used in the business analysis world for data visualization, modeling, and analytics. You’ll find usage overviews for each programming language under the “Usage” section and tutorials and other resources under “Learning”. Included at the bottom is a section titled “Tools”. These tools are useful for the languages listed.
Also, searching "Data analytics projects for beginners" on Google will give you some great examples to try out!
Used for Deep Learning, Artificial Intelligence, Neural Network Construction, Application building, Analytics, and more. It’s an extremely powerful programming language with lots of support for anything you’ll want to do. For analytics, IDEs like Jupyter and PyCharm (see below) are excellent choices.
Used for analysis, modeling, data visualization, and more. Primarily used in business applications for statistics and data analytics in combination with data visualization tools such as Tableau. R is primarily used with RStudio.
Stands for Structured Query Language. SQL is used to navigate and select data within large relational databases.
This tutorial walks through some of the most basic SQL queries you can perform. It's a general tutorial perfect for learning basic syntax.
Our GitHub
AACUW GitHub Repository
Basics
Intro Python Demo
R Workshop(2018)
Intro to R(2023)
Intro to SQL(2020)
Intro to SQL(2023)
Data Collection Techniques: Web-scraping, APIs
Data Collection Workshop
Web Scraping (from CSE 163)
Data Cleaning and Preprocessing
Data Cleaning & Processing
Data Cleansing in R
Data Cleaning with Python
Exploratory Data Analysis(EDA)
Intro to Analyzing a Dataset
Data Visualization
Intro to Data Visualization
COVID-19 Visualization Using Tableau Example
Presidential Election Visualization in R Example
Intro to Tableau
Intro to Machine Learning
Intro to Analysis and Modeling in R
Intro to Linear Regression & ML
Intro to Linear Regression and Stata
Titanic Modeling in R Example
Advanced Machine Learning
AI Ethics Open Forum Slides
Finance Analytics
Accounting & Finance Analytics
Stock/Finance Analysis in R Example