Course Details
Topic 1: Get started with Power Apps canvas apps
- Introduction to Power Apps
- Power Apps building blocks
- Create your first app in Power Apps
- Ways to build Power Apps
- Power Apps related technologies
- Additional Power Apps related technologies
- Designing a Power Apps app
Topic 2: Customize a canvas app in Power Apps
- Improve apps by making basic customizations in Power Apps
- Create a navigation model for your canvas app
- Explore screens and controls in Power Apps
- Get started with functions in Power Apps
Topic 3: How to build the UI in a canvas app in Power Apps
- Use themes to quickly change the appearance of your app
- Branding a control
- Icons
- Images
- Personalization
- Using the tablet or phone form factors
- Create UI for a new canvas app
Topic 4: Navigation in a canvas app in Power Apps
- Understanding navigation
- The navigation and back function
- Create navigation functions
- More ways to use the navigation function
Topic 5: Manage apps in Power Apps
- Manage app versions in Power Apps
- Share apps in Power Apps
- Understand environments in Power Apps
- Power Apps review
Topic 6: Build a mobile-optimized app from Power Apps
- Learn about mobile-optimized apps
- Identify components to make a canvas app mobile-optimized
- Create a mobile-optimized app that uses responsive designs
- Identify performance considerations for a mobile-optimized canvas app
- Monitor the performance of a mobile app
Topic 7: How to build your first model-driven app with Dataverse
- Introduction to Dataverse
- Introduction to model-driven apps
- Model-driven apps, powered by Microsoft Dataverse
- Explore sample apps
Topic 8: Create tables in Dataverse
- Introduction to Microsoft Dataverse
- Table characteristics
- Create a Microsoft Dataverse table
- Import data into your Microsoft Dataverse database
- Table relationships
- Create table relationships
- Dataverse logic and security
- Create a custom table and import data
- Dataverse auditing
- Dual-write vs. virtual tables
Topic 9: Get started with model-driven apps in Power Apps
- Introducing model-driven apps
- Components of model-driven apps
- Design model-driven apps
- Control security when sharing model-driven apps
- Create a model-driven app
Topic 10: Configure forms, charts, and dashboards in model-driven apps
- Forms overvie
- Form elements
- Configure multiple forms
- Use specialized form components
- Configure views overview
- Configure grids
- Create and edit views
- Configure charts overview
- Dashboards overview
- Use interactive streams and tiles
Topic 11: Manage Microsoft Power Platform deployments
- Strategy and vision
- Plan your deployment
- Secure deployments
- Determine storage requirements
- Manage authentication
- Connect and authenticate to data source
Topic 12: Administer Microsoft Power Platform subscriptions
- Manage users with Microsoft 365 admin center
- Manage your environment with Power Platform admin center
- Manage storage
- Manage updates
- Manage apps with Power Platform admin center
- Provision a portal
Topic 13: Get started with Power Automate
- Introducing Power Automate
- Create your first flow
- Create recurring flows
- Monitor incoming emails
- Share flows
Topic 14: Build approval flows with Power Automate
- Provide solutions to real-world scenarios.
- Build an approval request
- Build a flow that processes an approval request
- Learn to build a flow that runs at recurring time intervals
- Create a business process flow
- Create a business process flow that has conditions
Topic 15: Build flows to manage user information
- Build a flow that uses information like locations or date
- Build a flow accepts user input when run
- Create a flow that blocks time on your calendar
Topic 16: Power Automate's deep integration across multiple data sources
- Build a flow that runs when an event in Dynamics 365 occurs
- Build a flow that uses SQL
- Integrate Power Apps, Power Automate, and SharePoint
- Monitor flows
Topic 17: Use the Admin center to manage environments and data policies in Power Automate
- Administer flows
- Export and import flows
- Learn how to distribute button flows
Topic 18: Use AI Builder in Power Automate
- Introduction to AI Builder usage in Power Automate
- AI Builder in Power Automate saves time
- Use AI Builder actions in Power Automate
- Advanced usage of AI Builder in Power Automate
Topic 19: Optimize your business process with process advisor
- Get familiar with process advisor
- Create your first recording
- Edit recordings and group actions
- Analyze recordings and interpret results
- Automation recommendations
Topic 20: Get started building with Power BI
- Use Power BI
- Building blocks of Power BI
- Tour and use the Power BI service
Topic 21: Get data with Power BI Desktop
- Overview of Power BI Desktop
- Explore Power BI Desktop
- Connect to data sources
- Get data from Excel
- Transform data to include in a report
- Combine data from multiple sources
- Clean data to include in a report
Topic 22: Model data in Power BI
- Introduction to modeling your data
- How to manage your data relationships
- Create calculated columns
- Optimize data models
- Create measures
- Create calculated tables
- Explore time-based data
Topic 23: Use visuals in Power BI
- Introduction to visuals in Power BI
- Create and customize simple visualizations
- Create slicers
- Map visualizations
- Matrices and tables
- Create scatter, waterfall, and funnel charts
- Modify colors in charts and visuals
- Page layout and formatting
Topic 24: Explore data in Power BI
- Introduction to the Power BI service
- Quick insights in Power BI
- Create and configure a dashboard
- Ask questions of your data with natural language
- Create custom Q&A suggestions
- Share dashboards with your organization
- Display visuals and tiles in full screen
- Edit tile details and add widgets
- Get more space on your dashboard
Topic 25: Publish and share in Power BI
- Introduction to using workspaces
- Publish Power BI Desktop reports
- Print and export dashboards and reports
- Introducing Power BI Mobile
- Create workspaces in Power BI
- Build apps
- Use apps
- Integrate OneDrive for Business with Power BI
- Publish to web
Final Assessment
- Written Assessment - Short Answer Questions (WA-SAQ)
- Practical Performance (PP)
Course Info
Promotion Code
Promo or discount cannot be applied to WSQ courses
Minimum Entry Requirement
Knowledge and Skills
- Able to operate using computer functions with minimum Computer Literacy Level 2 based on ICAS Computer Skills Assessment Framework
- 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.
- Minimum 18 years old
Minimum Software/Hardware Requirement
Software:
You can download and install the following software:
You can also sign up a Power BI account
Hardware: Window Laptop
About Progressive Wage Model (PWM)
The Progressive Wage Model (PWM) helps to increase wages of workers through upgrading skills and improving productivity.
Employers must ensure that their Singapore citizen and PR workers meet the PWM training requirements of attaining at least 1 Workforce Skills Qualification (WSQ) Statement of Attainment, out of the list of approved WSQ training modules.
For more information on PWM, please visit MOM site.
Funding Eligility Criteria
Individual Sponsored Trainee | Employer Sponsored Trainee |
|
|
SkillsFuture Credit:
PSEA:
|
Absentee Payroll (AP) Funding:
SFEC:
|
Steps to Apply Skills Future Claim
- The staff will send you an invoice with the fee breakdown.
- Login to the MySkillsFuture portal, select the course you’re enrolling on and enter the course date and schedule.
- Enter the course fee payable by you (including GST) and enter the amount of credit to claim.
- Upload your invoice and click ‘Submit’
SkillsFuture Level-Up Program
The SkillsFuture Level-Up Programme provides greater structural support for mid-career Singaporeans aged 40 years and above to pursue a substantive skills reboot and stay relevant in a changing economy. For more information, visit SkillsFuture Level-Up Programme
Get Additional Course Fee Support Up to $500 under UTAP
The Union Training Assistance Programme (UTAP) is a training benefit provided to NTUC Union Members with an objective of encouraging them to upgrade with skills training. It is provided to minimize the training cost. If you are a NTUC Union Member then you can get 50% funding (capped at $500 per year) under Union Training Assistance Programme (UTAP).
For more information visit NTUC U Portal – Union Training Assistance Program (UTAP)
Steps to Apply UTAP
- Log in to your U Portal account to submit your UTAP application upon completion of the course.
Note
- SSG subsidy is available for Singapore Citizens, Permanent Residents, and Corporates.
- All Singaporeans aged 25 and above can use their SkillsFuture Credit to pay. For more details, visit www.skillsfuture.gov.sg/credit
- An unfunded course fee can be claimed via SkillsFuture Credit or paid in cash.
- UTAP funding for NTUC Union Members is capped at $250 for 39 years and below and at $500 for 40 years and above.
- UTAP support amount will be paid to training provider first and claimed after end of class by learner.
Job Roles
- Power Platform Developer
- Software Developer
- Application Developer
- Systems Analyst
- Data Analyst
- Business Intelligence Developer
- IT Consultant
- Solutions Architect
- Database Developer
- CRM Developer
- Cloud Developer
- Full Stack Developer
- Mobile App Developer
- Front End Developer
- Back End Developer
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.
Alec Tan: Alec Tan is a ACTA certified trainer, He has a number of Comptia certifications. Since 2002, starting off from IT technical background to pre-sales, sales account manager, system integration, operate IT retail / repair shop business in Sim Lim Square 2008 ~ 2012, and back to IT industry employment, freelance IT Trainer till present.
Kishan Raaj: Kishan Raaj is a seasoned Data Science and SAP Program Manager with over 15 years of experience, currently leading all end-to-end training and projects for Data Science across Asia at LITHAN, Singapore. With expertise in machine learning, data analytics, and cloud technologies, he is well-versed in techniques such as regression, decision trees, clustering, and text mining. He has hands-on experience with tools like Python, R, Tableau, PowerBI, and Microsoft Azure Machine Learning Studio.
As an ACTA certified trainer, Kishan has designed and delivered comprehensive courses for SAP and Data Science programs, managing teams and training in multiple countries, including Singapore, Malaysia, China, India, and Vietnam. His background in SAP, particularly in S4/HANA and ABAP, combined with his expertise in machine learning libraries such as TensorFlow and Keras, positions him as a highly capable leader in technical education and project management across various industries.
Quah Chee Yong: Quah Chee Yong is a ACTA certified trainer. Quah Chee Yong Chee Yong is an experienced professional who has held various Technical, Operations and Commercial positions across several industriesA firm believer that AI can create a better world, he has equipped himself with the Knowledge and Skills in the fields of Data Science, Machine Learning, Deep Learning and Cloud Deployment
He has a deep passion for training & facilitating and is currently a Singapore WSQ certified Adult Educator. He particularly enjoys the interactive engagements with his fellow trainers and learners
Peter Cheong : Peter is a ACLP certied trainer. Specialise In IT related knowlege and conduct IT Training which Include Microsoft Window Server Technology (Wintel) and Linux - Centos/Red Hat. Comptia ,ITIL , Motorola Solution Trunking System and Cisco Networking. I was worked in Motorola Solutions Conduct Motorola Astro 25 Trunking System For Police Force Malaysia (RMPnet),Taiwan Navy, Indonesia METRO POLDA (Police Force). After that Peter Join As IT Group Manager For W-Group which include 17 subsidiaries Companies in Real Estate Developer,Plantation, Building Management Services ,Contruction and also Fiber Opti Service Provider in Sabah,Malaysia.
Dr. Alfred Ang: Dr. Alfred Ang is ACE-certified developer, and ACTA-certified facilitator. As an experienced adult educator and lifelong learner, I am passionate about helping training providers, IHL, and CET centres develop high-quality Skills Framework-aligned WSQ and IBF curricula. At Tertiary Infotech Pte Ltd, I serve as the Founder, Managing Director and Chief Training Officer, overseeing a team of associate DACE/DDDPL certified curriculum developers and associate ACTA/ACLP facilitators who share my mission of upskilling people to stay relevant in today's rapidly changing world. In addition, I am GCWPL Certified Workplace Learning Consultant (from IAL), CAIEG Certified AI Ethics and Governance Professional (from NTU) , Microsoft Certified Power BI Data Analyst (PL-300), Power App Maker (PL-100), Data Scientist (DP-100) and AI Engineer Associate (AI-102).