Purpose
Welcome to the EH Nexus Data Science Software Skill Building Core Curriculum page. Each module starts with a core curriculum, which features foundational courses to help you get started with a specific software platform.
Power BI
Learn about the basics of data analysis and visualization in Power BI.
Learn how to connect to data, create visuals and analyses, publish dashboards and reports, and collaborate with your colleagues.
Courses
Get Started Building with Power BI
47 mins — This course introduces new users to the fundamentals of Power BI, including the interface, value, and flow of work.
Quickstart: Connect to Data
10 mins — This course demonstrates how easily users can connect to data sources with Power BI.
Use Visuals in Power BI
76 mins — This course illustrates how users can create and customize visuals to present data in compelling ways.
Explore Data in Power BI
53 mins — This course covers creating dashboards and reports and asking questions of your data.
Publish and Share in Power BI
64 mins — This course shows users how to publish and share reports and dashboards both internally and externally.
Posit/RStudio
Learn the basics of programming in R and how to navigate Posit's RStudio integrated development environment (IDE). Understand how to effectively leverage RStudio, complete data analysis tasks, and utilize R packages to complete your data operations.
Courses
R Basics: R Programming Language Introduction
246 mins — This course, made for true Posit novices, is a comprehensive introduction to the RStudio IDE interface and the basic principles of programming in Posit.
Posit Recipes: Visualization Basics
60 mins — These courses cover the basics of creating publication-ready visualizations using the ggplot2 package and the programming basics of R.
R Packages: A Beginner's Guide
60 mins — This course dives deeper into the need-to-know of R packages, including how to find, select, and install them.
Swirl
180 mins — Experiment with the R Swirl package to learn beginner programming and data science interactively.
Tableau
Learn to navigate the tool interface, create simple visualizations and dashboards, and share your work with others.
Courses
Free training videos
Learners will likely benefit from a number of the freely-available courses Tableau has to offer.
The Tableau Workspace
8 mins — A documentation walkthrough of Tableau’s Server Interface.
Azure Data Factory
Learn about Azure Data Factory's (ADF) components, data ingestion methods, integration runtimes, and pipeline management. Take note of the security considerations.
Courses
Introduction to Azure Data Factory
35 mins — This course provides an overview of Azure Data Factory's components. You’ll learn to orchestrate big data, ingest data from a variety of data sources, and evaluate how ADF can help you integrate your data sources.
Integrate Data with ADF or Azure Synapse
62 mins — This course provides an overview of data integration patterns, linked services, pipelines, security measures, and integration runtimes.
Petabyte-scale ingestion with ADF or Azure Synapse
43 mins — This course provides an overview of data ingestion methods, Azure Data Factory connectors, the Copy Activity, and data ingestion security considerations.
Microsoft Synapse Analytics
Learn about your agency's dedicated and serverless SQL pool's high-level capabilities, the differences between the SQL pools, and how to use T-SQL in each of the pools.
Courses
Introduction to Transact-SQL
60 mins — This Microsoft course introduces relational databases, the SQL language, and Transact-SQL (T-SQL). You will apply your understanding of these concepts by using simple T-SQL commands to complete common activities.
SAS Viya
Learn about SAS Viya's features, learn about the differences between existing SAS 9.4 and SAS Viya, and learn how to access SAS Viya through your agency's platform.
Note: To get the most out of the training, you will need to access your agency's SAS Viya sandbox/training environment.
Courses
Getting Started with SAS Studio
9 mins — Get started using SAS Studio on SAS Viya. In this video, you get started with programming in SAS Studio. You view a data table, write and submit SAS code, view the log and results, and use interactive features to quickly generate graphs and statistical analyses.
Databricks
Learn about Databricks’ Lakehouse components and how to start developing notebooks.
Courses
Intro to Data Lakehouse
6 mins — This course provides an overview of the origins and purpose of a data lakehouse as well as explaining the challenges of managing and utilizing big data.
Intro to Databricks Lakehouse Platform
4 mins — This course provides an overview of the Databricks Lakehouse platform. You will learn how to describe the fundamental concepts of the Databricks Lakehouse platform.
Databricks Notebook Basics
5 mins — This course introduces you to Databricks notebooks. You will learn how to attach to a cluster, run a cell, set a default notebook language, utilize Databricks’ magic commands, and render markdown.