Home
DP-500 Microsoft Azure Enterprise Data Analyst Associate Training

Sessions 4 days
Duration 30 hrs
Level Intermediate
Assessment NA

Venue

12 Woodlands Square #07-85/86/87 Woods Square Tower 1, Singapore 737715. 5 mins walk from Woodlands (NS9) MRT station.

The venue is disabled-friendly.

Download Course Brochure

Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

DP-500 Microsoft Azure Enterprise Data Analyst Associate Training

Course Code: C389

Be the first to review this product

Our Microsoft Azure Enterprise Data Analyst Associate course is meticulously designed for professionals seeking to elevate their data analysis skills. This comprehensive training will empower you with the knowledge and practical skills required to leverage Microsoft Azure for enterprise-level data analytics.

Engage with expert-led instruction, hands-on labs, and real-world case studies that will solidify your understanding of Microsoft Azure's tools and platforms specific to data analysis. Upon course completion, you will be proficient in analyzing and interpreting complex enterprise data, allowing you to make data-driven decisions that drive business success. Stand out in the competitive field of data analysis by becoming a certified Microsoft Azure Enterprise Data Analyst Associate.

Get exam-ready on our Practice Exam Portal — train in realistic Practice Mode and timed Exam Mode, then retake them as many times as you like before the real exam.

Start Practising →

No funding is available for this course

Course Fee

$1,200.00 (GST-exclusive)

$1,308.00 (GST-inclusive)

Mode of Training

Physical Classroom Training
Synchronised Teaching using ZOOM
Corporate Training at Company Premise

Course Date * Course Date

Include Exam Voucher *

No
Yes +$200.00

Course Time * Course Time: No. of Participants

Sponsorship *

Self-Sponsored
Employer-Sponsored

Name(s) on Certificate *

Additional Message or Emails for Course Notification

* Required Fields

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

We provide free consultation related to the subject matter after the course.
Please email your queries to enquiry@tertiaryinfotech.com and we will forward your queries to the subject matter experts.

You can register your interest without upfront payment. There is no penalty for withdrawal of the course before the class commences.
We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% for any paid amount.
Note the venue of the training is subject to changes due to availability of the classroom.

Course Details

This course prepares you for the DP-600 certification exam, covering all official exam domains and their approximate weightings:

Domain 1 Maintain a data analytics solution (27.5%)

Implement workspace-level, item-level, and row/column/object/file-level access controls
Apply sensitivity labels to items and endorse items
Configure version control (Git integration) for a workspace
Create and manage Power BI Desktop projects (.pbip) and configure deployment pipelines
Perform impact analysis of downstream dependencies across lakehouses, warehouses, dataflows, and semantic models
Deploy/manage semantic models via the XMLA endpoint and build reusable assets (.pbit, .pbids, shared semantic models)

Domain 2 Prepare data (47.5%)

Create data connections; discover data via OneLake catalog and Real-Time hub; choose between data stores
Ingest/access data and implement OneLake integration for Eventhouse and semantic models
Create views, functions, and stored procedures; implement a star schema; denormalize, aggregate, and merge/join data
Enrich data with new columns/tables; resolve duplicate, missing, or null data; convert data types; filter data
Select, filter, and aggregate data using the Visual Query Editor
Select, filter, and aggregate data using SQL, KQL, and DAX

Domain 3 Implement and manage semantic models (27.5%)

Choose a storage mode and implement a star schema for a semantic model
Implement relationships, including bridge tables and many-to-many relationships
Write DAX calculations using variables and functions (iterators, table filtering, windowing, information functions)
Implement calculation groups, dynamic format strings, field parameters, and design composite models
Configure Direct Lake, including default fallback/refresh behavior, and choose Direct Lake on OneLake vs. SQL analytics endpoint
Improve query, report-visual, and DAX performance; implement incremental refresh for semantic models

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

Data Analyst
Business Intelligence Analyst
Database Administrator
Data Scientist
Data Engineer
Azure Solution Architect
Cloud Engineer
Data Architect
Machine Learning Engineer
AI Developer
Business Analyst
Data Consultant
Big Data Engineer
SQL Developer
Data Manager

Trainers

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 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 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.

CY Quah is an ACLP-certified trainer and data science professional with extensive experience in Python, NLP, and machine learning. He has led AI training programs for SAP, Temasek Polytechnic, and IMDA under the SGUnited Mid-Career Pathways initiative, and has delivered corporate workshops on text analytics, recommender systems, and chatbot development. His expertise includes applying NLP tools such as NLTK, spaCy, and Gensim for sentiment analysis, topic modeling, and text classification.

Peter Cheong is an IT and knowledge management professional with strong expertise in networking, cybersecurity, and information systems. He has completed the Cisco Networking Academy Introduction to Packet Tracer course and has participated in international ICT and knowledge management conferences such as the IFLA Knowledge Management Satellite Meeting. With professional experience in IT systems and infrastructure, Peter brings both technical knowledge and global exposure to his training. As an adult educator, Peter focuses on building learners’ foundational skills in cybersecurity, network defense, and risk management aligned to CompTIA Security+ objectives. His sessions emphasize real-world security scenarios, equipping participants to recognize vulnerabilities, manage threats, and implement effective security controls. His combination of practical training and industry exposure ensures learners are well-prepared for both the certification exam and workplace application.