You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
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
Course Info
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
Job Roles
Job Roles
- Microsoft Office users
- Anyone who is interested in Power Platform
Trainers
Trainers
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.
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.