Welcome to the Data & Analytics Course 2022-2023!

ProServeIT Academy 2022-2023 will have two semesters. Semester 1 runs from July to December 2022. Semester 2 runs from January to June 2023.

The first semester of our Data & Analytics Course for 2022-2023 is comprised of 3 classes:

Class 01: Dimensional Modeling & the Star Schema

Class 02: Data Warehousing Architecture Patterns

Class 03: Power BI Reporting

These classes are designed for leaders in IT, Marketing, Sales, Finance, and Operations. These live classes will be delivered virtually on Tuesdays from 1:30 pm to 2:30 pm. For the specific dates, please see below.

What You'll Learn

Class 01: Dimensional Modeling & the Star Schema

This class will explore:

  • OLTP (transactional) vs OLAP (analytic) data systems
  • Brief history of data modelling
    • Started in the 90s (Kimball vs Inmon)
    • Somewhat abandoned due to the velocity and variety of big data in the data lake
    • #bringbackdatamodelling - data modelling is making a come back now that systems are able to handle ingestion and transformation of big data faster and with the data lakehouse architecture
  • Data modeling in the context of Data Warehousing (OLAP) systems
  • Kimball Dimensional Modeling
    • Benefits of Kimball Dimensional Modeling
  • 4-Step Dimensional Modeling Process

When: Tuesday, August 16th, 2022
Duration: 1:30PM - 2:30PM ET (1 hr)
Course Delivered: Online

📊 Class 02: Data Warehousing Architecture Patterns

This class will explore:

  • Functions of a Data Warehouse
    • Extraction
    • Cleaning
    • Transformation
      • Integration
      • Mapping
    • Loading
    • Refreshing
  • Brief history of data warehousing
    • 1990s - Data warehousing
    • 2010s – Advent of the data lake
      • Benefits of data lake
    • 2020s - Transition to data lakehouse (combines data warehousing and data lake)
      • Benefits of data lakehouse architecture

When: Tuesday, October 18th, 2022
Duration: 1:30PM - 2:30PM ET (1 hr)
Course Delivered: Online

📈 Class 03: Power BI Reporting

This class will explore:

  • Live demo of Power BI Reporting in Power BI Desktop
    • Ingest data to Power BI
    • Transform data in Power BI Query Editor
    • Visualize data
    • Natural Language Q&A
    • Built-In AI/ML Visuals
    • Custom Visuals

When: Tuesday, December 13th, 2022
Duration: 1:30PM - 2:30PM ET (1 hr)
Course Delivered: Online

Scott Sugar, ProServeIT


About the Instructor

Scott Sugar

Practice Lead, Data & Analytics, ProServeIT


From the 1980's, when his father used to hand down old computer equipment, to now, Scott Sugar has always had a fascination with technology. The ability to communicate with people, regardless of distance or location, is, in Scott's opinion, one of the best things about tech. With over 20 years of experience in the IT industry, and 17 years at ProServeIT, Scott's areas of expertise include data & analytics, and IT operations, monitoring, and alerting. Scott heads up ProServeIT's Ho Chi Minh City, Vietnam office. He has spent the majority of his adult life in Asia, and speaks 3 languages.

Where does the Data & Analytics Course Fit within Your Technology Strategy?

The roof, potentially the most important element of the Framework, is insights and automation. This is what allows us to make actionable decisions from our own data.

Everything below the roof in this framework is an asset. The data that we capture in our core business applications, or the data that we capture from our employees or our customers will enable us to make better decisions. Like any asset, we need to be able to activate it.

Join Scott to learn ways to turn your own data into actionable insights.

ProServeIT Academy Homepage



Other Courses Designed for IT Leaders

Azure Course          Modern Work Course          Microsoft Licensing Course

Cybersecurity Course          Integrations Course