Data Analytics With Excel & Power BI​

This Data Analytics course gives you the essential knowledge &  skills to analyze data with modern tools like Excel & Visualize Data using Power BI.

Microsoft Power BI Suite Traning in Singapore
Microsoft Power BI Suite Traning in Singapore

Statistical Analysis techniques, Excel Pivot Tables Wizardary and Power BI Data Visualization Dashboards are explored to analyze big data from a diverse dataset. 

WSQ Grants & SkillsFuture can be used for Data Analytics Course.

A great course for Beginners to learn the Fundamentals of Data Analysis with the #1 Business Intelligence tools: Microsoft Power BI & Microsoft Excel.

Data Analytics make it easy to understand past data, and forecast future trends, helping you make sense of and decide on the Best course of action, with our Step-by-step, Practical, Hands-on training!

PowerBI Bar, Line, Column & Donut Charts

This WSQ Funded Data Analytics With Excel & Power BI course in Singapore teaches you how to get started into Data Analysis, use Statistical techniques in Excel, create Pivot Table Reports, and Visualize Data with Power BI Dashboards easily.

Power BI Dashboard training in Singapore

This course provides essential knowledge and skills relating to data analytics concepts, statistical analysis, data set preparation, data set summarization and data visualization successfully.

You will gain expertise in analyzing production data and chart future course of action confidently with these sophisticated Data Analytics Tools

Our objective is to train you to  be able to perform the following Data Analytics Tasks well:

  • Understand the key concepts of data analytics in business
  • Understand and apply key statistical analysis concepts
  • Import data into a spreadsheet and prepare it for analysis using data cleansing and filtering techniques
  • Summarize data sets using Pivot tables and Pivot charts.
  • Understand and apply Data Visualization Techniques & Tools
  • Create and Share Interactive Reports & Dashboards with the Best Data Visualization Tool – Power BI

HIGHLY Recommended for People who want to Upgrade themselves & Move to the Next Level

Go To Top

Course Duration:  2 full days

Course Timings: 8.45 am – 5.45 pm

Target Audience: For beginners in Data Analytics, or even complete newbies to Power BI.

You will learn the initial steps in understanding and analyzing data, using statistical analysis, importing large datasets from Excel, Websites or Databases, shaping data with formulas & functions, aggregate it with Excel Pivot Tables, create Frequency Distributions and finally create Dashboards to visualize it with amazing charts in Power BI.

Go To Top

SkillsFuture Data Analytics Training in SingaporeDATA ANALYTICS FUNDAMENTALS

  • Introduction to Data Science
  • Principles of Data Modeling
  • Data Science Techniques & Applications
  • Data Extraction Methods
  • Data Analysis Tools
  • Data Visualization in Power BI
  • Data Cleansing in Excel

DATA ANALYSIS TOOLS & TECHNIQUES

  • Data Protection & Compliance
  • Extract Data from Multiple Sources
  • Data Science Techniques
  • Application of Data Science Techniques to Excel Data
  • Advantages & Disadvantages of Business Intelligence Tools like Power BI
  • Creation of Data Structures for Data Science
  • Statistical Analysis in Excel & Power BI

Data Visualization for Business Insights

  • Create Dashboards in Power BI
  • Generate Business Insights from published and shared Dashboards
  • Present Business Reports & Insights to Target Audience

Go To Top

Prerequisites: Basic knowledge of PC skills, Microsoft Excel, and Windows and an open mind, interested in exploring and learning new things. Prior knowledge of Power BI is not required.

Certification: Successful trainees will receive the WSQ Certificate of Attainment for Data Analytics from SSG. Students must pass 120 minutes of written and practical assessment at the end of the Data Analytics training course to qualify for the Grants & Certification.

Learners’ Profile:

  1. Any learner with a basic proficiency in reading, writing, and understanding English, basic knowledge of Excel can pick up the Data Analytics Skills with Power BI
  2. We look for participants with Secondary education as a per-requisite
  3. Participants should have completed the Basic PC Skills training, Basic Excel Training and be familiar with Windows operating system.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

Simply fill this Online Registration Form to book your seat.
Our Training Officer will get in touch with you to confirm your seat shortly.

You can call at at +65 6252-5033 or 9066-9991 (Whatsapp now) if you have any questions.

Accelerate Your Career With the Most Effective & Practical Training.

Advanced Power BI MasterClass

Visualization using Advanced Power BI Tips & Tricks

Visualization using Advanced Power BI Tips & Tricks

Unlock the full potential of Power BI with our Advanced Power BI course!

Dive deep into

  • Advanced DAX measures,
  • Explore sophisticated use cases for Power Query, and
  • Master data visualization using advanced settings.

Learn to implement row-level security, keep your data models optimized, and import custom visuals.

Enhance your reports with Python or R visuals, and leverage new KPI cards, Gauges, and more to create Stellar Dashboards for your management.Add Python Visualizations and Scripts in Power BI

This comprehensive two-day WSQ Advanced Power BI course in Singapore is designed for those who already know the basics of Power BI and are ready to elevate their skills to the next level.

Learn From Power BI Experts

Led by Power BI Guru Vinai Prakash, with over 35 years of experience in data analysis and business intelligence, this course promises hands-on, practical learning to empower you with advanced skills.

This course is funded by WSQ Grants for eligible participants, and use of SkillsFuture, UTAP Grants helps to subsidize this course.

This is a very practical, and hands-on course on Power BI that will transform your Data Analysis skills and make you a PRO in using Advanced Power BI Features

  • Master advanced DAX measures for more powerful data analysis.
  • Explore advanced use cases and techniques in Power Query.
  • Learn data visualization best practices and advanced settings.
  • Implement row-level security to protect your data.
  • Optimize your data models to keep them small and efficient.
  • Import and use custom visuals to enhance your reports.
  • Create Python or R visuals for more dynamic data presentations.
  • Utilize new KPI cards, gauges, and other visuals to add value.
  • Understand and apply AI features, Quick Measures, and Advanced Time Intelligence Comparisons.

Master Time Intelligence Function in Power BI Advanced Course at Intellisoft Singapore.

Go To Top

This course is perfect for:

  • Business analysts and data professionals who have a basic understanding of Power BI.
  • Professionals looking to enhance their data visualization and analysis skills.
  • Individuals seeking to implement advanced Power BI features in their work.
  • Anyone interested in taking their Power BI knowledge to an intermediate or advanced level.

Best Advanced Power BI dashboard Course in Singapore

Go To Top

ADVANCED POWER BI – COURSE OUTLINE

Section 1: Data analytics With Power BI

  • Understanding data analytics
  • Explore Roles in data Analysis
  • Key Tasks for a data analyst
  • Introduction to Power BI Desktop Advanced Features
  • Components of Power BI
  • Understanding Power BI Services

Section 2: Design a data model in Power BI

  • Get data from files & folders

    Advanced Analytics in Power BI Class

  • Get data from relational data sources
  • Get data from a NoSQL database
  • Get data from online services
  • Select a storage mode
  • Get data from Azure Analysis Services
  • Fix performance issues
  • Resolve data import errors
  • Understanding Constraints & Performance issues
  • Understand data types mismatch issues
  • Resolving data quality errors

Section 3: Data Cleansing With Power BI

  • Shape the initial data
  • Simplify the data structure
  • Evaluate and change column data types
  • Combine multiple tables into a single table
  • Profile data in Power BI
  • Use Advanced Editor to modify M code

Section 4: Creating Advanced DAX measures in Power BI

  • Using the Calculate function
  • Understanding Filter Context
  • Using IF, SWITCH, FIND
  • Using VALUES, HASONEVALUE, SELECTEDVALUE, and CONCATENATEXUse sophisticated Time Intelligence Functions in Power BI
  • Using ALL, ALLEXCEPT, ALLSELECTED, KEEPFILTERS
  • Creating Virtual Tables
  • Create semi-additive measures
  • Advanced Date Comparisons With Same Period Last Year, Year To Date, Month to date totals,
  • Using Date Functions like DATEADD, FIRSTDATE, LASTDATE, NEXTYEAR
  • Writing Custom Time Intelligence Functions
  • Using RELATED & RELATEDTABLE functions in Power BI

Section 5: Performance Optimization in Power BI

  • Performance optimization Considerations
  • Review performance of Measures, Relationships, and visuals
  • Using variables to improve performance & Troubleshooting
  • Reduce cardinality in the Data Model
  • Optimize DirectQuery models with table level storage
  • Create and manage aggregations

Power BI Dashboard Course for Advanced Users

Section 6: Working with Power BI visuals

  • Introduction to Advanced Power BI visualizations
  • Add visualization items to reports
  • Choose an effective visualization
  • Format and configure visualizations
  • Import a custom visual into Power BI
  • Add an R or PYTHON visual in a reportPython Visuals in Power BI Advanced training course

Section 7: Create a data-driven story with Power BI reports

  • Introduction to create a data-driven story with Power BI reports
  • Design a report layout
  • Add buttons, bookmarks, and selections
  • Design report navigation
  • Use advanced interactions and drill through
  • Configure conditional formatting
  • Apply slicing, filtering, and sorting
  • Publish and export reports
  • Comment on reports
  • Fine Tune report performance
  • Optimize reports for mobile use

Section 8: Create dashboards in Power BI

  • Introduction to dashboards
  • Configure data alerts
  • Explore data by asking questions
  • Add a dashboard theme
  • Pin a live report page to a dashboard
  • Configure a real-time dashboard
  • Configure data classification
  • Explore mobile view & Auto Mobile Layouts

Section 9: Perform analytics in Power BI

  • Introduction to analytics
  • Advanced Power BI Course in Singapore at Intellisoft SystemsExplore statistical summary
  • Identify outliers with Power BI visuals
  • Group and bin data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Use advanced analytics custom visuals
  • Review Quick insights
  • Apply AI Insights

Section 10: Work with AI visuals in Power BI

  • Introduction to working with AI visuals
  • Use the Q&A visual
  • Find important factors with the Key influencers visual
  • Use the Decomposition Tree visual to break down a measure

Section 11: Create and manage workspaces in Power BI

  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection

Section 12: Secure Access With Row-Level Security

  • Configure row-level security with the static method
  • Configure row-level security with the dynamic method

Section 13: Manage datasets in Power BI

  • Create dynamic reports with parameters
  • Create what-if parameters
  • Use a Power BI gateway to connect to on-premises data sources
  • Configure a dataset scheduled refresh
  • Configure incremental refresh settings
  • Manage and promote datasets
  • Troubleshoot service connectivity

Go To Top

  • Basic knowledge of Power BI, including data import and basic DAX measures.
  • Familiarity with creating basic reports and dashboards in Power BI.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

 Register for Advanced Power BI Training Course in Singapore at Intellisoft

  1. Visit Our Website: Go to Intellisoft Training.
  2. Find the Course: Navigate to the “Advanced Power BI” course page.
  3. Fill Out the Form: Complete the registration form with your details & Submit the form

This hands-on, practical course will be taught by Power BI Guru Vinai Prakash, who has over 35 years of experience in data analysis and business intelligence.

Don’t miss this opportunity to learn from the best and transform your data analysis capabilities!

TESTIMONIALS FROM OUR ADVANCED POWER BI COURSE ATTENDEES

“The Advanced Power BI course exceeded my expectations. Vinai’s expertise and practical approach made complex concepts easy to understand. I feel much more confident in my ability to create impactful reports and dashboards now.” Sarah Lim, Data Analyst, Vodafone

“Taking this course was a game-changer for my career. The hands-on exercises and real-world examples provided invaluable insights. Vinai is an outstanding instructor who truly cares about his students’ success.”
John Tan, Director, Business Innovation

Best Advanced Power BI dashboard Course in Singapore

 

Accelerate Your Career With the Most Effective & Practical Training.

Training Course Fees & Funding

Full course fee: S$1,200.00 (before GST & government funding) TGS: TGS-2024050953

Highest Funding
70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

  • SG Citizens aged 40+ (Individual, SME or MNC)
  • SME-sponsored SG Citizens (21+)
  • SME-sponsored PRs (21+)
Course Fee S$1,200.00
SSG Funding (70%) − S$840.00
Nett Fee S$360.00
GST (9%) S$108.00
You Pay S$468.00
SSG Funded
50% Grant

50% SSG Grant

Baseline WSQ Funding

  • SG Citizens aged 21–39 (Individual or MNC)
  • MNC company-sponsored PRs (21+)
  • Individual PRs (21+)
Course Fee S$1,200.00
SSG Funding (50%) − S$600.00
Nett Fee S$600.00
GST (9%) S$108.00
You Pay S$708.00
Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$1,200.00 + 9% GST = S$1,308.00 applies. Contact us for more details.

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Jul 2026.

Power Query & Power Pivot for Deep Analysis with Excel

Power Query and Power Pivot in Excel Course at Intellisoft Singapore

Power Query and Power Pivot in Excel Course at Intellisoft Singapore
Power Query and Power Pivot in Excel Course at Intellisoft Singapore

Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs.

We show you how to use this powerful, time-saving tool to do deep cleansing of data, and then do a deeper analysis of data with Microsoft Excel’s Power Pivot.

This course teaches you how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes.

Power Query Training in Singapore at Intellisoft

Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets.

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course, you will learn how to use the DAX language and Power Pivot to explore and analyze relational data models. You will master how to add calculated columns and measures to data models in Excel.

Power Pivot Options in Excel - Learn Power Pivot with WSQ Funding in Singapore at Intellisoft

We highlight the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.

Full of dozens of tips, tricks & techniques in this comprehensive, practical, hands-on training using Power Query and Power Pivot in Excel for Deep Data Analysis.

The “Power Query & Power Pivot for Deep Analysis with Excel” course is designed to equip participants with advanced skills in data manipulation, analysis, and visualization using Excel’s powerful tools, Power Query and Power Pivot.

Participants will start by mastering Power Query, learning how to import data from various sources, clean and transform it efficiently. Moving into Power Pivot, they will delve into data modeling techniques, establishing relationships between tables, and creating calculated columns and measures using DAX expressions.

Power Query Training in Excel at Intellisoft Singapore - Learn How To Merge in Power Query at Intellisoft

Throughout the course, emphasis will be placed on practical applications through hands-on exercises and real-world case studies, enabling participants to analyze complex datasets, generate insightful visualizations, and optimize performance for large-scale data scenarios.

By the end of the course, participants will have the tools and knowledge to confidently handle diverse data challenges, automate workflows, and enhance decision-making processes using Excel as a robust analytical platform.

Go To Top

The target audience for the “Power Query & Power Pivot for Deep Analysis with Excel” course includes professionals and individuals who work extensively with data in Excel and wish to deepen their analytical capabilities. This course is ideal for:

  1. Data Analysts: Professionals who analyze and interpret data regularly and want to leverage advanced Excel tools for more efficient and insightful analysis.
  2. Business Intelligence Professionals: Individuals involved in creating reports, dashboards, and data visualizations who seek to enhance their skills in data modeling and manipulation.
  3. Financial Analysts: Those responsible for financial modeling, forecasting, and budgeting who want to streamline data handling and improve accuracy in their analyses.
  4. Excel Power Users: Individuals already proficient in Excel who want to expand their toolkit with Power Query and Power Pivot for more sophisticated data transformations and analysis.
  5. Managers and Decision-Makers: Leaders who rely on data-driven insights to make informed decisions and wish to improve their ability to extract and present meaningful insights from data.
  6. IT Professionals and Consultants: Those tasked with managing and optimizing data workflows within organizations who want to leverage Excel’s capabilities for enhanced data management and reporting.

Overall, the course is suitable for anyone looking to advance their Excel skills specifically for data analysis, whether in business, finance, consulting, or other fields where data-driven decision-making is critical.

Go To Top

Power Query & Power Pivot for Deep Analysis with Excel

Course Outline

Day 1: Power Query Essentials and Intermediate Techniques

Power Pivot Data Model Training in Singapore at Intellisoft

Module 1: Introduction to Power Query

  • Understanding the Role of Power Query in Data Preparation
  • Navigating the Power Query Interface
  • Key Use Cases of Power Query in Business Scenarios
  • Differences Between Power Query in Excel and Power BI

Module 2: Data Transformation Basics

  • Importing Data from Various Sources (Excel, CSV, SQL, Web, etc.)
  • Data Cleaning Techniques: Removing Errors, Replacing Values
  • Reordering Columns and Rows for Analysis
  • Splitting and Merging Columns

Module 3: Advanced Data Transformation

  • Advanced Filtering Techniques for Targeted Data Extraction
  • Creating Custom Columns with Conditional Logic
  • Using the Fill Down and Fill Up Features for Missing Data
  • Advanced Grouping and Aggregating Techniques for Summarized Data

Module 4: Introduction to M Language

  • Exploring the M Language Syntax and Structure
  • Editing Queries Directly in the Advanced Editor
  • Creating Custom Functions for Reusable Logic
  • Common M Functions for Data Manipulation (e.g., Table.TransformColumns, Text.Combine)

Module 5: Case Studies and Practical Exercises

  • Real-World Scenario: Preparing Sales Data for Reporting
  • Combining Data from Multiple Files and Folders
  • Practice Exercises with Provided Datasets
  • Group Discussion on Common Data Challenges

Day 2: Power Pivot and Advanced Analytics

Module 6: Introduction to Power Pivot

  • Overview of the Power Pivot Add-in: Activation and Setup
  • Loading Data into the Power Pivot Data Model
  • Understanding Table Relationships: One-to-One, One-to-Many
  • Creating Hierarchies for Advanced Data Navigation

Module 7: DAX Fundamentals

  • Overview of DAX: Syntax and Functions
  • Understanding Row Context vs. Filter Context
  • Creating Basic Calculated Columns and Measures
  • Using Aggregation Functions (SUM, AVERAGE, COUNT, DISTINCTCOUNT)

Module 8: Advanced DAX Techniques

  • Time Intelligence Functions: Calculating YTD, QTD, MTD, and Rolling Averages
  • Advanced Logical Functions: SWITCH, IFERROR, CALCULATE
  • Working with Iterative Functions: SUMX, AVERAGEX
  • Troubleshooting DAX Formulas and Debugging Errors

Module 9: Optimizing Data Models

  • Understanding the Importance of Star and Snowflake Schemas
  • Best Practices for Efficient Data Models: Reducing File Size, Avoiding Duplicates
  • Using the Diagram View for Relationship Management
  • Performance Tuning: Analyzing and Optimizing Query Performance

Module 10: Advanced Analytics and Reporting

  • Creating Slicers and Filters for Interactive Dashboards
  • Designing Effective Power Pivot Reports with Visual Insights
  • Using KPIs to Track and Display Key Business Metrics
  • Integrating Power Query and Power Pivot for Dynamic Reporting

Module 11: Final Project and Review

  • Hands-On Project: Building an Interactive Dashboard from Raw Data
  • Applying Power Query and Power Pivot to Solve Business Problems
  • Course Recap: Key Takeaways and Best Practices

These objectives aim to provide participants with a comprehensive understanding and practical skills in leveraging Power Query and Power Pivot for deep data analysis within Excel, preparing them to handle complex data challenges effectively.

Go To Top

To join the “Power Query & Power Pivot for Deep Analysis with Excel” course, participants should ideally have the following prerequisites:

  1. Proficiency in Excel: Participants should be familiar with basic to intermediate Excel functionalities, including navigating through worksheets & using simple formulas and functions.
  2. Understanding of Data Concepts: A basic understanding of fundamental data concepts such as tables, rows, columns, and data types is recommended.
  3. Familiarity with Data Analysis: Some experience in data analysis tasks like sorting, filtering, and basic data manipulation within Excel will be beneficial.
  4. Motivation to Learn: An eagerness to explore advanced data manipulation techniques and a willingness to engage in hands-on exercises and case studies throughout the course.

These prerequisites will ensure that participants can effectively engage with the course content, grasp advanced concepts in Power Query and Power Pivot, and apply their knowledge to real-world data analysis challenges using Excel.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

Intellisoft offers WSQ funded, UTAP supported SkillsFuture Credits Ready Courses in Singapore
Intellisoft offers WSQ funded, UTAP supported SkillsFuture Credits Ready Courses in Singapore

To register for the “Power Query & Power Pivot for Deep Analysis with Excel” course, you have several convenient options:

  1. Online Registration: Visit our website and navigate to the registration page. Fill out the online registration form with your details and course preferences. You can typically find the registration link under the course description or on our homepage.
  2. Walk-in Registration: Feel free to visit our office during business hours. Our staff will be happy to assist you with the registration process in person. You can find our office address and hours of operation on our website.
  3. Email Registration: Send us an email indicating your interest in the course. Include your name, contact information, and any specific questions you may have. Our team will respond promptly and guide you through the registration steps via email.
  4. WhatsApp: If you prefer to communicate via WhatsApp, send us a message with your name and the course you wish to register for. We will reply with further instructions and assist you through the registration process.
  5. Drop by Our Office: If you’re in the City Area around Bugis, Rochor, Bencoolen, Bras Basah, Dhoby Ghat, you can drop by our office directly at Fortune Centre. Our staff will be available to answer your questions and assist you with completing the registration form on-site.

For more information about the course, feel free to email us at training@intellisoft.com.sg or reach out via WhatsApp at +65-90669991. We look forward to helping you register and start your journey with Power Query and Power Pivot for deep analysis with Excel!

Accelerate Your Career With the Most Effective & Practical Training.

Training Course Fees & Funding

Full course fee: S$1,000.00 (before GST & government funding) TGS: TGS-2024049574

Highest Funding
70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

  • SG Citizens aged 40+ (Individual, SME or MNC)
  • SME-sponsored SG Citizens (21+)
  • SME-sponsored PRs (21+)
Course Fee S$1,000.00
SSG Funding (70%) − S$700.00
Nett Fee S$300.00
GST (9%) S$90.00
You Pay S$390.00
SSG Funded
50% Grant

50% SSG Grant

Baseline WSQ Funding

  • SG Citizens aged 21–39 (Individual or MNC)
  • MNC company-sponsored PRs (21+)
  • Individual PRs (21+)
Course Fee S$1,000.00
SSG Funding (50%) − S$500.00
Nett Fee S$500.00
GST (9%) S$90.00
You Pay S$590.00
Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$1,000.00 + 9% GST = S$1,090.00 applies. Contact us for more details.

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Jul 2026.

ChatGPT, Gemini, Copilot & New AI Tools for Enhanced Productivity

Digital Transformation With AI Tools in Singapore at Intellisoft Systems
Intellisoft offers WSQ funded, UTAP supported SkillsFuture Credits Eligible Courses in Singapore

Learn ChatGPT, Gemini, CoPilot & Other AI Tools
for Content Generation, Digital Marketing
& Transformation of Process

AI Tools Training at Intellisoft Systems Singapore

Our Best & Most Useful AI Tools Course in Singapore

Most people using ChatGPT are getting mediocre results, and they don’t know it. They type a one-line question, get a generic answer, and quietly conclude AI is overhyped. The gap is never the tool. It’s the instruction.

This 2-day WSQ-funded course teaches working professionals in Singapore how to actually direct today’s AI tools — ChatGPT, Google Gemini, Microsoft Copilot and several other emerging AI Tools to do real work. Draft the client email. Summarise the 40-page report. Rewrite the sales proposal. Build the CV shortlisting rubric. Answer the angry customer. Map the process that keeps breaking.

Not just social media captions. Your actual job.

We use a step-by-step framework that starts with the fundamentals of artificial intelligence and generative AI, moves through prompt engineering — the single skill that separates a useful AI answer from a useless one — and ends with feasibility and cost-benefit analysis, so you can tell your management not just what AI can do, but whether it is worth doing.

Along the way you will apply these tools inside the functions that run a business: human resources, sales, marketing, operations, customer service, finance and admin. Yes, that includes newsletters, LinkedIn posts and Facebook content — but content creation is one application among many, not the point of the course.

No coding. No mathematics. No prior AI experience. Bring a laptop and one real task from your working week — you will leave having solved it.

Master ChatGPT, Gemini, Copilot & New AI Tools for Enhanced Productivity

Generative AI now writes, analyses, summarises, codes — and creates images too.

AI tools training in Singapore - ChatGPT, Gemini and Microsoft Copilot course at Intellisoft Systems

Course Objectives

  • Equip participants with a comprehensive understanding of AI’s role in digital transformation.
  • Enable learners to identify, analyze, and implement the most suitable AI tools for their business needs.
  • Foster a practical and strategic mindset for integrating AI technologies effectively and sustainably in business environments.
  • Encourage innovation and continuous learning in the rapidly evolving field of AI.

What You Will Be Able To Do After Two Days

  • Write prompts that work. Apply a repeatable five-part structure — Role, Task, Context, Format, Constraints — and iterate towards the answer you actually wanted, instead of accepting the first mediocre draft.
  • Choose the right tool for the job. Know when to reach for ChatGPT, when Gemini is stronger, when Claude handles the long document better, and when Microsoft Copilot — sitting inside Word, Excel, Outlook, PowerPoint and Teams — beats all three because it can already see your files.
  • Apply AI inside your own function. Job descriptions and interview rubrics in HR. Prospect research and proposal drafts in sales. Campaigns and content in marketing. SOPs and bottleneck analysis in operations. Complaint replies and knowledge-base articles in customer service.
  • Judge whether it is worth it. Run a feasibility and cost-benefit analysis on a proposed AI use case and defend the conclusion — including the conclusion that you should not proceed.
  • Spot a confidently wrong answer. These tools fabricate facts, invent citations and misstate regulations with total fluency. You will leave with the verification habits that make them safe to use on real company work, and a clear line on what must never be pasted into a public AI tool.
  • Take home a prompt library. Tested prompts for your own role, built during the course, ready to use on Monday.

This course blends theoretical grounding with hands-on practice, preparing you to lead and execute AI-driven digital transformation initiatives — and to be the person in the room who knows what these tools genuinely do, and what they only appear to do.

Go To Top

The ideal target audience for a course on “Digital Transformation with AI Tools” encompasses a range of professionals who are either directly involved in or influencing the integration and application of technology in business processes. This includes:

  1. Business Leaders and Executives:
    • CEOs, CTOs, CIOs, and other C-suite executives who are responsible for driving strategic decisions and implementing digital transformation initiatives in their organizations.
  2. Digital Transformation Consultants:
    • Professionals who advise businesses on digital transformation strategies and need to stay abreast of the latest AI tools and technologies.
  3. Marketing Professionals:
    • Digital Marketers, Content Creators, and Social Media Managers who can use AI tools for enhancing digital marketing strategies and content creation.
  4. Entrepreneurs and Startup Owners:
    • Business owners who are looking to leverage AI tools to gain a competitive edge and innovate within their industries.
  5. HR Professionals:
    • Human Resources Managers and Recruiters who can use AI tools for talent acquisition, employee engagement, and analyzing workforce data.
  6. Students in Business and Technology Fields:
    • University students specializing in business, technology, or related fields who are preparing for careers in an increasingly digital and AI-driven world.
  7. Policy Makers and Government Officials:
    • Individuals involved in shaping policies around technology, AI, and digital transformation who need to understand the practical implications of these tools in the business sector.

By targeting this diverse audience, the course can address a wide range of interests and needs, ensuring relevance and applicability across various industries and professional roles. The course will be particularly beneficial for those who are in positions to influence or implement digital strategies and innovations in their organizations.

Go To Top

WSQ Funded Digital Transformation With AI Tools Course in Singapore

ChatGPT, Gemini, Copilot & New AI Tools for Enhanced Productivity

Section 1: Introduction to AI-Driven Digital Transformation

We start with what generative AI actually is — and, more usefully, what it is not. You will see how large language models produce their answers, which explains both why they are so good at drafting and why they occasionally invent things outright. From there we look at where AI genuinely shifts the economics of a business process, and where it merely adds a layer of expensive novelty.

  • Digital transformation driven by AI Tools
  • Overview of Generative AI technologies and applications
  • Enhancing Business Processes with AI Tools like Copilot
  • Improving Customer Experiences with AI Tools like ChatGPT

In practice: we take one process from your own organisation — onboarding a client, closing the month, answering a complaint — and identify precisely where an AI tool removes friction and where a human must stay in the loop.

Section 2: Identify Generative AI Tools for Businesses

There are now hundreds of AI tools and most of them will not exist in three years. Rather than a tour of the app store, this section teaches you to evaluate tools against your own requirements: what data it touches, what it costs at scale, whether it integrates with what you already run, and who is accountable when it gets something wrong.

We compare the four that matter for most Singapore businesses today — ChatGPT for general drafting and reasoning, Google Gemini for research and the Google Workspace stack, Claude for long documents and careful analysis, and Microsoft 365 Copilot, which lives inside Word, Excel, Outlook, PowerPoint and Teams and can therefore work directly on your inbox, your spreadsheets and your meeting transcripts. Most organisations end up using two. We show you which two, and why.

  • Understanding digitization and its applications in business
  • Identify AI tools to improve business

In practice: you build a shortlist for your own department and score it against cost, data sensitivity, integration effort and staff readiness.

Section 3: Conduct Feasibility Analysis and Cost-Benefit Analysis

This is the section that separates a training course from a product demo. Enthusiasm is not a business case. Before any AI tool touches a live process, somebody has to answer the hard questions: what does it cost in licences, time and retraining? What does it save, measured honestly rather than hopefully? What is the failure mode, how likely is it, and what does it cost when it happens?

You will work through a structured feasibility assessment and a cost-benefit model you can reuse — and you will practise reaching the answer nobody wants to hear, which is that a particular use case is not yet worth doing. Knowing when to say no is why finance directors trust the people who say yes.

  1. Viability of using Generative AI tools
  2. Conducting feasibility analysis and weighing the costs and benefits of using Generative AI tools

In practice: you leave with a one-page business case for one AI initiative in your own organisation, in a form you can put in front of management.

Section 4: Implement AI Tools for Businesses

The final section is where the tools meet the work. This is the bulk of Day 2, and it is entirely hands-on.

Prompt engineering comes first, because nothing downstream works without it. A weak prompt — “write an email to the customer about the delay” — returns a weak email. A strong prompt specifies the role the AI should adopt, the task, the context it needs, the format of the answer, and the constraints it must respect. Same tool, same thirty seconds, completely different output. You will learn the structure, practise it, and learn to iterate: the first response is a draft, never the answer.

Prompt engineering examples - writing effective ChatGPT prompts for business

From there we apply the tools function by function, so that whatever your role, at least one hour of Day 2 is about your job specifically:

  • Human Resources — job descriptions, structured interview questions, CV screening rubrics with auditable reasoning, exit-interview themes, policy drafts. Plus where AI screening creates fairness and legal risk, and why a human signs every hiring decision.
  • Sales — prospect research before the call, proposals drafted from discovery-call notes, follow-up emails that do not read like templates, objection-handling scripts, one pitch rewritten for a CFO, a CTO and a founder.
  • Marketing — campaign concepts, ad variants, landing-page copy, EDM subject lines, blog outlines built from real customer questions, and one webinar repurposed into a newsletter, eight social posts and a case study.
  • Operations & Process Improvement — describe a broken process in plain English and have AI map it, name the bottleneck and propose fixes with trade-offs. Draft the SOP nobody has had time to write. Turn a policy document into a decision tree your team can follow.
  • Customer Service — replies that acknowledge without admitting liability, six months of tickets distilled into the five problems worth fixing at source, technical explanations rewritten for non-technical customers.
  • Finance & Admin — contract summaries with unusual clauses flagged for human review, variance narratives, board-paper drafts, memos.
  • Building a culture of innovation
  • Apply AI tools for content creation
  • Apply AI tools for digital marketing
  • Apply AI tools for business processes
  • Apply AI tools for hard skills

In practice: you also learn what these tools get wrong. They fabricate facts, invent citations, inherit bias, and will cheerfully describe a Singapore employment regulation that does not exist. We cover the verification habits, the PDPA line on customer data, and the outputs that always need a second pair of eyes. Confidence without judgement is the fastest way to embarrass your company.

How to use ChatGPT for social media posts, LinkedIn content and marketing newsletters

Go To Top

Please ensure that you and your participants have a sufficient background to grasp the concepts and applications discussed. Here are some basic prerequisites:

  1. Basic Understanding of Digital Technologies:
    • Familiarity with fundamental digital concepts and technologies. This doesn’t require deep technical expertise but a general understanding of how digital tools are used in a business context.
  2. Business Acumen:
    • An understanding of basic business principles and processes. This is important for comprehending how AI can be integrated into various business operations and strategies.
  3. Basic Computer Literacy:
    • Proficiency in using computers and common software applications. While advanced programming skills are not necessary, comfort with technology is essential.
  4. Awareness of AI and Machine Learning Concepts:
    • A basic understanding of what AI and machine learning are. This doesn’t require in-depth knowledge, but a general awareness of these technologies and their potential impact.
  5. Openness to Learning New Technologies:
    • A willingness and enthusiasm to learn about new technologies and their applications in business. This mindset is crucial for fully benefiting from the course.
  6. Problem-Solving Skills:
    • Ability to think critically and solve problems. As the course will cover how AI can be used to address business challenges, these skills will be valuable.
  7. Communication Skills:
    • Good verbal and written communication skills, as the course may involve group discussions, presentations, and collaborative projects.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

To register for this 2-day course on Chat GPT and Generative AI Tools & Technologies at Intellisoft Systems, you can visit our office or simply register on the website.

The Registration form allows you to directly register the participants.

Additionally, you can reach us by phone at +65 6250-3575 for more information or to register directly.

Accelerate Your Career With the Most Effective & Practical Training.


Upto 70% WSQ Funding* from SkillsFuture Singapore

Training Course Fees & Funding

Full course fee: S$750.00 (before GST & government funding) TGS: TGS-2024043430

Highest Funding
70% Grant

70% SSG Grant

Baseline + Enhanced Training Support

  • SG Citizens aged 40+ (Individual, SME or MNC)
  • SME-sponsored SG Citizens (21+)
  • SME-sponsored PRs (21+)
Course Fee S$750.00
SSG Funding (70%) − S$525.00
Nett Fee S$225.00
GST (9%) S$67.50
You Pay S$292.50
SSG Funded
50% Grant

50% SSG Grant

Baseline WSQ Funding

  • SG Citizens aged 21–39 (Individual or MNC)
  • MNC company-sponsored PRs (21+)
  • Individual PRs (21+)
Course Fee S$750.00
SSG Funding (50%) − S$375.00
Nett Fee S$375.00
GST (9%) S$67.50
You Pay S$442.50
Foreigners & other pass holders: Government grants are not applicable. Full course fee of S$750.00 + 9% GST = S$817.50 applies. Contact us for more details.

Need help with funding applications? We'll guide you through the process.

* Terms & conditions apply. Funding subject to eligibility and approval by respective agencies. GST applies on full course fee before subsidy. Fee information is accurate as of Jul 2026.

Azure Data Fundamentals

Azure Data fundamentals Training in Singapore at Intellisoft Systems With WSQ Funding

WSQ Grant of up to 50-70%

This course will enable learners to leverage Azure services for managing and transforming data in various business scenarios, preparing them for the Azure Data Fundamentals certification

This Azure Data Fundamentals course covers the foundational knowledge necessary to use various Azure data services. It includes learning about data types, data management and processing techniques, data sources, and Azure data solutions.

Upon completion of the course, learners will be to Implement data management processes and systems to map data sources, processes and relationships, and transform and process multiple streams of data.

The Microsoft Certification in Azure Data Fundamentals can be attempted and attained by the learners after completing the course and preparing for the Microsoft Certification Test too. Industry Certification helps in job and career progression and improves wages significantly.

This Azure Data Fundamentals course covers the foundational knowledge necessary to use various Azure data services.

It teaches you to leverage Azure services for managing and transforming data in various business scenarios, preparing them for the Azure Data Fundamentals certification.

It includes learning about data types, data management and processing techniques, data sources, and Azure data solutions.

This course will enable learners to leverage Azure services for managing and transforming data in various business scenarios, preparing them for the Azure Data Fundamentals certification

Go To Top

Professionals, managers, executives, technicians, Database Engineers, Data Managers, Senior Leadership.

Managers, Executives, Supervisors, Professional & Technicians involved in leveraging Azure services for managing and transforming data in various business scenarios, preparing them for the Azure Data Fundamentals certification.

Go To Top

Section 1: Explore Core Data Concepts

• Data formats
• File storage
• Transactional data processing
• Analytical data processing
• Data roles and services
• Job roles in the world of data
• Data services

Section 2: Explore Relational Data in Azure

• Overview of relational data
• Normalization
• Explore SQL
• Describe database objects
• Explore relational database services in Azure
• Azure SQL services and capabilities
• Azure services for open-source databases

Section 3: Explore Non-Relational Data in Azure

• Azure blob storage
• Azure DataLake Storage Gen2
• Azure Files
• Azure Tables
• Azure Cosmos DB

Section 4: Explore Data Analytics in Azure

• Overview of relational data
• Normalization
• Explore SQL
• Describe database objects
• Explore relational database services in Azure
• Azure SQL services and capabilities
• Azure services for open-source databases

Go To Top

The learners must declare their working experience and academic qualifications that validates their basic knowledge.

Knowledge and Skills
• Able to operate computer functions with minimum Computer Literacy Level 2 based on ICAS Digital Technologies Assessment
• 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

All applications will be reviewed and vetted by the course administrator to ensure the suitability and authenticity of the documents. If any learner is deemed not suitable, he/she will not be admitted to the course.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

Contact Intellisoft for arranging Corporate Training at your office, or for registering participants for this course.

How To Register For Azure Data Fundamentals Training in Singapore

Register for the 2 Days Azure Data Fundamentals training today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at 6250-3575,  WhatsApp: 9066-9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have any questions regarding Azure Data Fundamentals training.

We have regular public classes For Excel Training each month, and Corporate Training can be arranged at your office too!

Note: This class is a very practical, and hands-on workshop session. It requires you to take part in Azure Fundamentals exercises during the class. A laptop with some required software pre-loaded is provided to each participant for use during this workshop.

SkillsFuture Azure Data Fundamentals Training:

Join today, and begin to Master Azure Data Fundamentals with our Step-by-step instructions and helpful, patient, Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

Accelerate Your Career With the Most Effective & Practical Training.

Microsoft CyberSecurity Architect Certification Training

Microsoft CyberSecurity Architect Certification Training in Singapore at Intellisoft Systems

WSQ Grant of up to 50-70%

The key objective of this certification training is to help learners to understand and assess security risks, threats and vulnerabilities, and recommend security initiatives to mitigate them

You will be ready to take the Microsoft CyberSecurity Risks Certification Training after the successful completion of this training.

The Microsoft Cybersecurity Architect course is meticulously designed to empower learners with a robust understanding of the complexities and nuances of cybersecurity within the Microsoft ecosystem.

Participants will delve deep into the architectural principles and best practices to design secure solutions on Microsoft platforms.

The course also delves into the nuances of cloud security, network security, and endpoint protection within Azure and Microsoft 365, covering topics ranging from identity and access management to advanced threat protection.

By the end of the program, learners will be equipped with the knowledge to design and implement comprehensive security strategies, ensuring that data, assets, and resources are safeguarded across Microsoft’s suite of services and products.

Through theoretical knowledge and practical exercises, participants will also be primed to respond effectively to emerging threats and vulnerabilities in real-world scenarios.

The hands-on approach adopted in this course is designed to produce competent professionals capable of meeting today’s cybersecurity challenges.

The Microsoft Cybersecurity Architect course is designed to equip learners with the knowledge and skills necessary to navigate the complex landscape of cybersecurity. Beginning with the identification and assessment of security risks and their impact on business operations, the course focuses on providing a practical understanding of how to address security control gaps within an organization.

The course transitions into the design and implementation of specific security programs. Learners will be guided through creating effective security guidelines that consider technological and regulatory changes.

They will also learn how to adopt and monitor information security and assurance architectures, ensuring their initiatives align with both internal and external standards.

The key learning objectives of the Microsoft CyberSecurity Architect Preparation Training are:

1. Identify security risks, threats, and assess gaps in controls impacting business processes.
2. Translate security objectives into specific programs considering security program design techniques.
3. Develop a detailed action plan for security programs in line with information security architectures.
4. Deliver advice for adoption of security architectures, monitoring their effectiveness against standards.

Go To Top

Managers, Executives, Supervisors, Professional & Technicians involved in assessing and evaluating cyber security risks, managing them and putting in measures for avoiding them in the first place.

These people are actively involved in planning, managing and implementing cyber risk management plans, and help to ensure that cyber risks are mitigated and contingency plans are in place.

 

Go To Top

Course Outline for Microsoft Cybersecurity Architect Certification Training in Singapore

SECTION 1: Design solutions that align with security best practices and priorities

  • Topic 1 Introduction to Zero Trust and best practice frameworks
    o Introduction to best practices
    o Introduction to Zero Trust
    o Zero Trust initiatives
    o Zero Trust technology pillars part 1
    o Zero Trust technology pillars part 2
  • Topic 2 Design solutions that align with the Cloud Adoption Framework (CAF) and Well-Architected Framework (WAF)
    o Define a security strategy
    o Introduction to the Cloud Adoption Framework
    o Cloud Adoption Framework secure methodology
    o Introduction to Azure Landing Zones
    o Design security with Azure Landing Zones
    o Introduction to the Well-Architected Framework
    o The Well-Architected Framework security pillar
  • Topic 3 Design solutions that align with the Microsoft Cybersecurity Reference Architecture (MCRA) and Microsoft cloud security benchmark (MCSB)
    o Introduction to Microsoft Cybersecurity Reference Architecture and cloud security benchmark
    o Design solutions with best practices for capabilities and controls
    o Design solutions with best practices for attack protection
  • Topic 4 Design a resiliency strategy for common cyberthreats like ransomware
    o Common cyberthreats and attack patterns
    o Support business resiliency
    o Ransomware protection
    o Configurations for secure backup and restore
    o Security updates
  • Topic 5 Case study: Design solutions that align with security best practices and priorities
    o Case study description
    o Case study answers
    o Conceptual walkthrough
    o Technical walkthrough

Section 2: Design security operations, identity, and compliance capabilities

  • Topic 6 Design solutions for regulatory compliance
    o Introduction to regulatory compliance
    o Translate compliance requirements into a security solution
    o Address compliance requirements with Microsoft Purview
    o Address privacy requirements with Microsoft Priva
    o Address security and compliance requirements with Azure policy
    o Evaluate infrastructure compliance with Defender for Cloud
  • Topic 7 Design security solutions for applications and data
    o Introduction to security for Exchange, Sharepoint, OneDrive and Teams
    o Evaluate security posture for collaboration and productivity workloads
    o Design a Microsoft 365 Defender solution
    o Design configurations and operational practices for Microsoft 365
  • Topic 8 Design solutions for identity and access management
    o Introduction to Identity and Access Management
    o Design cloud, hybrid and multicloud access strategies (in-cluding Azure AD)
    o Design a solution for external identities
    o Design modern authentication and authorization strategies
    o Align conditional access and Zero Trust
    o Specify requirements to secure Active Directory Domain Ser-vices (AD DS)
    o Design a solution to manage secrets, keys, and certificates
  • Topic 9 Design solutions for securing privileged access
    o Introduction to privileged access
    o The enterprise access model
    o Design identity governance solutions
    o Design a solution to secure tenant administration
    o Design a solution for cloud infrastructure entitlement management (CIEM)
    o Design a solution for privileged access workstations and bastion services
  • Topic 10 Design solutions for security operations
    o Introduction to Security operations (SecOps)
    o Design security operations capabilities in hybrid and multicloud environments
    o Design centralized logging and auditing
    o Design security information and event management (SIEM) solutions
    o Design solutions for detection and response
    o Design a solution for security orchestration, automation, and response (SOAR)
    o Design security workflows
    o Design threat detection coverage
  • Topic 11 Case study: Design security operations, identity and compliance capabilities
    o Case study description
    o Case study answers
    o Conceptual walkthrough
    o Technical walkthrough

Section 3: Design security solutions for applications and data

  • Topic 12 Design solutions for securing Microsoft 365
    o Introduction to security for Exchange, Sharepoint, OneDrive and Teams
    o Evaluate security posture for collaboration and productivity workloads
    o Design a Microsoft 365 Defender solution
    o Design configurations and operational practices for Microsoft 365
  • Topic 13 Design solutions for securing applications
    o Introduction to application security
    o Design and implement standards to secure application de-velopment
    o Evaluate security posture of existing application portfolios
    o Evaluate application threats with threat modeling
    o Design security lifecycle strategy for applications
    o Secure access for workload identities
    o Design a solution for API management and security
    o Design a solution for secure access to applications
  • Topic 14 Design solutions for securing an organization’s data
    o Introduction to data security
    o Design a solution for data discovery and classification using Microsoft Purview
    o Design a solution for data protection
    o Design data security for Azure workloads
    o Design security for Azure Storage
    o Design a security solution with Microsoft Defender for SQL and Microsoft Defender for Storage
  • Topic 15 Case study: Design security solutions for applications and data
    o Case study description
    o Case study answers
    o Conceptual walkthrough
    o Technical walkthrough

Section 4: Design security solutions for infrastructure

  • Topic 16 Specify requirements for securing SaaS, PaaS, and IaaS services
    o Introduction to security for SaaS, PaaS, and IaaS
    o Specify security baselines for SaaS, PaaS, and IaaS services
    o Specify security requirements for web workloads
    o Specify security requirements for containers and container orchestration
  • Topic 17 Design solutions for security posture management in hybrid and multicloud environments
    o Introduction to hybrid and multicloud posture management
    o Evaluate security posture by using Microsoft Cloud Security Benchmark
    o Design integrated posture management and workload protection
    o Evaluate security posture by using Microsoft Defender for Cloud
    o Posture evaluation with Microsoft Defender for Cloud secure score
    o Design cloud workload protection with Microsoft Defender for Cloud
    o Integrate hybrid and multicloud environments with Azure Arc
    o Design a solution for external attack surface management
  • Topic 18 Design solutions for securing server and client endpoints
    o Introduction to endpoint security
    o Specify server security requirements
    o Specify requirements for mobile devices and clients
    o Specify internet of things (IoT) and embedded device security requirements
    o Secure operational technology (OT) and industrial control systems (ICS) with Microsoft Defender for IoT
    o Specify security baselines for server and client endpoints
    o Design a solution for secure remote access
  • Topic 19 Design solutions for network security
    o Design solutions for network segmentation
    o Design solutions for traffic filtering with network security groups
    o Design solutions for network posture management
    o Design solutions for network monitoring
  • Topic 20 Case study: Design security solutions for infrastructure
    o Case study description
    o Case study answers
    o Conceptual walkthrough
    o Technical walkthrough

 

Go To Top

The learners must declare their working experience and academic qualifications that validates their basic knowledge.

Knowledge and Skills
• Able to operate computer functions with minimum Computer Literacy Level 2 based on ICAS Digital Technologies Assessment
• 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

All applications will be reviewed and vetted by the course administrator to ensure the suitability and authenticity of the documents. If any learner is deemed not suitable, he/she will not be admitted to the course.

Go To Top

Post-Course Support

  • We provide free consultation related to the subject matter after the course.
  • Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Do You Have Any Questions or Need a Quotation?

Simple. Just tell us what you need. We’ll be glad to help you!

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Michele Martin
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Joy Tan
Project Engineer

How To Register

Contact Intellisoft for arranging Corporate Training at your office, or for registering participants for this course.

How To Register For Microsoft CyberSecurity Architect Training in Singapore

Register for the 4 Days Microsoft cyber security Architect training today by simply clicking on the chosen course date available at the top of this page.

Need Help?

  1. Call us at 6250-3575,  WhatsApp: 9066-9991
  2. Send an email  to  training@intellisoft.com.sg  OR
  3. Submit an online enquiry if you have any questions regarding Excel Basic Data Analytics training.

We have regular public classes For Excel Training each month, and Corporate Training can be arranged at your office too!

Note: This class is a very practical, and hands-on workshop session. It requires you to take part in Excel exercises during the class. A laptop with Excel pre-loaded is provided to each participant for use during this workshop.

SkillsFuture Microsoft CyberSecurity Architect Training:

Join today, and begin to Master CyberSecurity with our Step-by-step instructions and helpful, patient, Microsoft Certified Trainers to guide you.

What are you waiting for? Get Started Right away…

Accelerate Your Career With the Most Effective & Practical Training.

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Python, Power BI, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!

Found What You Were
Looking For?

Just Tell us...

We're Here To Help You!