5 Days Power Platform Specialisation

Day 1 and Day 2: Power BI Business Analytics Training

Topic 1 Get Started on Power BI

• Overview of Power BI Desktop and Service
• Import/Connect Data into Power BI
• Transform Data
• Combine Data
• Filter Data

Topic 2: Create Data Visualization

• Create Data Visualizations
• Format Visuals
• Create Power BI Reports

Topic 3 Create Dashboard and Scoreboard

• What is Dashboard and Scoreboard
• Create Dashboard
• Customize Dashboard

Topic 4: Create Dynamic Visualization

• Create Dynamics Charts
• Create Interactions
• Create Visual Hierarchies

Topic 5 Create Data Model

• Overview of Data Model
• Data Relationships
• Calculation and Measures

Topic 6 Data Analytics with DAX

• Overview of DAX Language
• Perform Data Queries and Analytics

Day 3: Microsoft Power Automate Essential Training

Topic 1. Get Started on Microsoft Automate

• What can you do with Power Automate
• Connectors
• Types of Flows
• How Flows Work

Topic 2. Creating Flows from Blank

• Create a Trigger
• Add an Action
• Test the Flow
• Create a Scheduled Flow
• Create a Flow Trigger with Condition
• Add a Condition Action
• Test a Condition Flow

Topic 3. Create Flow from a Template

• Create a Flow with a Recent Trigger
• Create a Task to Trigger a Flow
• Test a Push Notification
• Create a Mobile Flow

Topic 4. Manage Flow

• Approval and Action item
• Share a Flow
• Export a Flow

Day 4: Microsoft Power Apps Essential Training

Topic 1: Get Started with Power Apps

• Overview of Power Apps
• Login to Power Apps
• Explore Power Apps Interface
• Create a Simple Power Apps from template
• Use Power Apps Studio
• Publish and share the apps

Topic 2: Create a Power Apps from Scratch

• Upload Excel source data to OneDrive
• Manage theme
• Manage layout
• Manage 
• Create a Power Apps on Sharepoint List

Topic 3: Using Dataverse with Power Apps

• Basics of Dataverse
• Create a Power apps on Dataverse

Day 5: Microsoft Power Virtual Agent Essential Training

Topic 1 Get Started with Power Virtual Agent

• Setting Up Power Virtual Agent
• Create a Bot
• Create Topics and Dialog

Topic 2 Work with Conservation Path

• Nodes and Conversation Path
• Create Custom Entity
• Add a Condition

Topic 3 Publish and Monitor Bot

• Publish the Bot
• Analyse Bot Performance

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

• Positive Learning Attitude
• Enthusiastic Learner

Experience

• Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

• Microsoft Office users
• Anyone who is interested in Power Platform

Wayne Lim: Wayne Lim is a ACTA trainer. An Agile practitioner and Scrum Master, part of a start-up in the Maritime sector, and involved in family’s’ food and beverage business. Wayne graduated from RMIT University with a bachelor’s in construction management. Having 11 years in project management experience in the construction and marine sectors. Lectured in tertiary institutions in topics like management, marketing, engineering, mathematics, and customer service. His current interest includes R and Python programming languages, DevOps, and Agile methodologies.

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Sanjiv Venkatram: Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers

Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.