Intermediate Visual Analytics Using Power BI (Synchronous e-learning)

Topic:Data Analytics & Visualisation, ICT, Media & Design, Others

Course Type:Short & Modular Courses

Register interest
Download PDF for print

Overview

  • Course Date:

    TBA
  • Registration Period:

    TBA
  • Duration/Frequency:

    16 Hours
  • Mode of Training:

    Face-to-Face (Classroom Teaching)
  • Venue:

    Singapore Polytechnic
  • Funding:

    -

​‘Intermediate Visual Analytics Using Power BI’ is an intermediate-level course compared to the ‘Visual Analytics Using Power BI’ course and it emphasizes more on real time data. Participants can appreciate the use of Power BI Professional licence coupled with Microsoft suite. They can appreciate the strength of power automate and how this may be used to automate processes.

Course Objective

The demand for visual analytics in business processes, for quick and informed decision-making, is ever increasing. Microsoft Power Business Intelligence (Power BI), is one of the solution platforms for a robust dashboard development. The high-end features from Microsoft Power BI and DAX functions, which are “similar” to those offered in Microsoft Excel, have made the process of building dashboards easier.

Visual Analytics is the science of analytical reasoning supported by interactive visual interfaces. Today, data is produced at an incredible rate and the ability to collect and store the data is increasing at a faster rate than the ability to analyse it. Visual Analytics can be seen as an integral approach combining visualization, human factors, and data analysis.

By end of the course, participants will be able to develop a dashboard that answers the problem question, use available functions and features to develop dashboard, learn to organize and plan the items in a dashboard and provide insights, KPI reporting and informed decision making.

Course Outline

By the end of the course, participants will be able to:  

- Perform advanced DAX Functions (Calculate, Groups, Rank, Filter & TopN)    
- Perform advanced Custom Visuals (AI Visual & Text Mining – Word Cloud)                 
- Perform Real-time Data Processing (Real-time Data Entry & Visual, Automate Process & Visual)                                           
- Perform Stream Analytics (Stream Analytics via IoT, Push Notifications & Alerts via SMS) 
- Perform Security & Scheduling (Schedule & refresh reports at x-th hr, row level data security & filter, parameters setting on power query) 

Topics Covered
1. Advance DAX functions 
2. Analytics using custom graphics 
3. Real-time data processing 
4. Real-time stream analytics 
5. Security & scheduling 

Minimum Requirements

Basic computer skills

Certification / Accreditation

• Certificate of Attendance (electronic Certificate will be issued)
A Certificate of Attendance will be awarded to participants who meet at least 75% attendance rate

• Certificate of Completion (electronic Certificate will be issued)
A Certificate of Completion will be awarded to participants who pass the assessment and meet at least 75% attendance rate

Suitable for

Executives, Researchers, Educators, Analysts and participants interested in developing dashboards