5 Days Power Platform Specialisation

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

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

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

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.