Data:

Utilization, Analytics, Visualization & Communication Virtual Training Courses

Each course below is designed to be delivered as a virtual, instructor-led course.  Courses are approximately 10% lecture, 45% hands-on lessons (completing samples with the instructor) and 45% individual or team exercises.Each participant will receive instructions to install the appropriate software prior to the session.Instructions will also include manuals and data sets required for the course.The virtual sessions can be delivered via the organization’s online meeting software (WebEx, Zoom, Microsoft Teams, etc.).

There are two delivery options available.

Option 1: Two half-day sessions on consecutive days (e.g., Tuesday 8:30 – 12:00 and Wednesday 8:30 – 12:00)

Option 2: A one day delivery from 8:30 – 4:30 Eastern.  The time can be adjusted to account for time zones differences.

Courses

Tableau – I:This course focuses on learning the core functionality of Tableau.Knowing the core functionality will provide participants with the ability to produce many of the most common data visualizations.

Topics covered include:

Tableau – II:Building on skills learned in Tableau I, additional Tableau functionality is introduced.Working with dates, line charts and scatterplots supports looking for trends in data.Maps and bubble charts are used for providing broad overviews of data.The remaining functionality supports the need to reorganize data into more meaningful or effective structures.

Tableau – III:The first half of this course focuses on introducing advanced topics to create visualizations that are not part of the standard Tableau portfolio.The second half examines principles of visualization that can be used to more effectively communicate data findings.

Power BI - I: Power BI’s capabilities for analysis and communication creates deeper understanding of the techniques and results that are effective in explaining the data.This training session will enable participants to work with all key functionalities in Power BI - analyze data, create interactive reports and communicate/share findings throughout the organization.

Power BI – II: Data is not always in an easily usable format.This session teaches participants how to change challenging data structures into usable sources of information and to create advanced reports and visualizations.

SQL – I: SQL is the standard programming language used to create and manage relational databases.In this course, participants learn the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques.

SQL – II: To take full advantage of relational database capabilities

Fundamentals of Data Analytics:

Even a few short years ago, Data Analytics was a specialized skill set.Since then much has changed.Data analysis techniques have improved, and new tools have the capacity and capability to move analytics from specialist to business users.This course is designed to bring managers and analyst up to speed with the current thinking and techniques used to guide data analytics projects by linking the seven types of analytic questions to the work required for answering.

Communicating with Data: (This is a ½ day course)

Data visualizations are graphical means of summarizing and describing data.This course describes various types of visualizations and teaches participants how to link the data they have and the message they want to deliver.