-
Course Date:
TBA
-
Registration Period:
TBA
-
Duration/Frequency:
14 hour / 2 days
-
Mode of Training:
Facilitated Learning (F2F)
-
Venue:
Singapore Polytechnic
-
Funding:
Eligible for SkillsFuture Credit
*Please note that once the maximum class size is reached, the online registration will be closed.
You may register your interest, and would be notified if there is new run.
‘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.
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.
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