1 - day course
Print this page
Course Code: S1M34Een
Who should attend?
This course is intended for users who are familiar with Microsoft Excel desktop.
Prerequisites
Excel for Microsoft 365/2021 - Level 3 - Data Management
Course Objectives
Upon completion of the course, participants will be able to accomplish the following:
  • Understand the course flow to obtain a better sense of what will be accomplished in this class.
  • Understand the ELT process and perform it manually and using Power Query, using different data types, cleaning and shaping transformations, and loading options.
  • Understand dashboard layout and design considerations, as well as analyze data to create visual dashboard objects used to populate a dashboard.
  • Create and customize Slicers to extend filtering capabilities and enhance the usage and appearance of a dashboard, as well as update the default data folder path for data files with external connections (if required).
Course Content  
    Course Overview
    Course Flow ; Course Flow Graphical Objectives ;
    Working with Data Extraction, Transformation, and Loading
    Understanding the Extract, Transform, and Load Process ; Power Query Overview ; Getting Started with Power Query ; Managing Query Results ; Reorganizing Data ; Combing Data ; Working with Web Data ;
    Working with Data Analysis and Dashboards
    Data Analysis and Dashboard Overview ; Getting Started with Dashboards ; Data Analysis for Dashboard Objects ; Completing and Using Dashboards ;
    Supplemental Topics
    Working with Slicers in Dashboards ; Course Data Folder Location ;