NTUC LearningHub

What's In It for Me

Self-service BI, an end-user’s ability to analyse data and create complex visual reports without the aid of someone with technical expertise, has been a growing demand in many companies as it drives productivity and efficiency. The course will walk you through the powerful features of Self-service BI using a data analytical tool.

Course Overview

 

The course is designed to equipped students with the basic skills needed to create visual reports with data analytics using Power BI.  Upon course completion, learners will be able to consume and transform data using the Power BI desktop application, create models from raw data sources and configure Dashboards using the Power BI Service.

Course Objectives

Upon course completion, learners will be able to:

  • Perform Power BI desktop data transformation.
  • Describe Power BI desktop modelling.
  • Create a Power BI desktop visualization.
  • Implement the Power BI service.
  • Describe how to connect to Excel data.
  • Describe how to collaborate with Power BI data.
  • Connect directly to data stores.
  • Describe the Power BI analytic and visual API. • Describe the Power BI mobile app.

Pre-requisites

Required Prerequisites:

  • Familiarity with Microsoft Office applications – particularly Excel.

Suggested Prerequisites:

  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).
  • Some exposure to basic programming constructs (such as looping and branching).
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.
  • Hardware & Software
    This course will be conducted as a Virtual Live Class (VLC) via Zoom platform. Participants must own a zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. This can be downloaded from https://zoom.us/download
System Requirement
Must Have:

Please ensure that your computer or laptop meets the following requirements.

  • Operating system: Windows 10 (MacOS is not supported)
  • Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher
  • Minimum 20 GB hard disk space.
  • Minimum 8 Gb RAM
  • Webcam (The camera must be turned on for the duration of the class)
  • Microphone
  • Internet Connection: Wired or Wireless broadband
  • Latest version of Zoom software to be installed on computer or laptop prior to the class.

Good to Have:

  • Wired internet connection
    Wired internet will provide you with stable and reliable connection.
  • Dual monitors
    Using a dual monitor setup will undoubtedly improve your training experience, enabling you to simultaneously participate in hands-on exercises and maintain engagement with your instructor.

Not Recommended:

Using tablets is not recommended due to their smaller screen size, which could cause eye strain and discomfort over the course of the program's duration.

Course Outline

Module 1: Get Started with Microsoft Data Analytics

Lessons

  • Data Analytics and Microsoft
  • Getting Started with Power BI

 

Module 2: Prepare Data in Power BI

Lessons

  • Get data from various data sources
  • Optimize performance
  • Resolve data errors

 Module 3: Clean, Transform, and Load Data in Power BI

 Lessons

  • Data shaping
  • Enhance the data structure
  • Data Profiling

Module 4: Design a Data Model in Power BI Lessons

  • Introduction to data modeling
  • Working with tables
  • Dimensions and Hierarchies

Module 5: Create Model Calculations using DAX in Power BI

Lessons

  • Introduction to DAX
  • DAX context
  • Advanced DAX

Module 6: Optimize Model Performance

Lessons

  • Optimze the model for performance
  • Optimize DirectQuery Models
  • Create and manage Aggregations

Module 7: Create Reports

Lessons

  • Design a report
  • Enhance the report

Module 8: Create Dashboards

Lessons

  • Create a Dashboard
  • Real-time Dashboards
  • Enhance a Dashboard

Module 9: Create Paginated Reports in Power BI

Lessons

  • Paginated report overview
  • Create Paginated reports

Certificate Obtained and Conferred by

Upon completion of the course and assessment, students will also be awarded with Statement of Attainments (SOAs) from SSG.

ICT-DIT-3006-1.1 Data Visualization

Categories
More Information
  • NTUC LearningHub
  • No comments yet.
  • Add a review
    error: Content is protected !!