Excel Basics for Data Analysis

Take some time this New Year to become more proficient in Microsoft Excel. Coursera offers a 11 hour course (which you can enroll for free) to gain a working knowledge of Excel for data analysis. You will learn how to import and clean data, perform spreadsheet tasks and analyze data.

Learn more and enroll

One Seattle Data Strategy

The City of Seattle in Washington recently released a new comprehensive data strategy to optimize the city's use of data to make better decisions, enhance collaboration, protect privacy, standardize best practices and address the complex challenges faced by the city.  The strategy recognizes that data is one of the most critical assets public sector leaders have.  Although it is a city level strategy, it offers an example to learn from.

Access the One Seattle Data Strategy

US GAO Report on Artificial Intelligence

Artificial intelligence is rapidly changing the world and could improve government operations. For example, federal agencies can use AI to analyze drone photos and large datasets. But safeguards are needed to manage AI risks.

Access the GAO Report

Data Spotlight

Closed Discrimination Complaint Cases in Iowa 

Department of Inspections, Appeals & Licensing

This dataset contains information on discrimination complaint cases processed by a local agency, the Iowa Civil Rights Commission or the Equal Employment Opportunity Commission (EEOC) in Iowa. Data includes type of closure, dates when case was opened and closed, and basis of complaints received.

View asset 

January Online Live Data Skills Training

All courses are 60 to 90 minutes in length.  Go to the data & insights training portal to sign up for the following courses as well as on-demand training.

Table lists all live online classes scheduled during January 2024.
CourseDate & Time
Clean and Tidy DataMon, Jan 8, 12 PM
Create and Manage Your Dataset
  • Wed, Jan 10, 10 AM
  • Mon, Jan 29, 12 PM
Transform Data with Socrata Query LanguageWed, Jan 10, 3 PM
Map Your DataWed, Jan 17, 10 AM
Explore Data with ChartsWed, Jan 17, 3 PM
Create Performance MeasuresFri, Jan 19, 3 PM
Tell a Story with PerspectivesMon, Jan 22, 10 AM
Collaborate with Enterprise DataWed, Jan 24, 10 AM
Data Automation with Gateways and APIsFri, Jan 26, 3 PM
Shape & Join Data in the Exploration CanvasWed, Jan 31, 3 PM