You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
Domain 1 Maintain a data analytics solution (27.5%)
Implement workspace-level, item-level, row-level, column-level, object-level, and file-level access controls
Apply sensitivity labels to items and endorse items
Configure version control for a workspace and manage Power BI Desktop projects (.pbip)
Create and configure deployment pipelines
Perform impact analysis of downstream dependencies (lakehouses, warehouses, dataflows, semantic models)
Deploy/manage semantic models via the XMLA endpoint; create 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; ingest/access data and choose between data stores
Implement OneLake integration for Eventhouse and semantic models
Create views, functions, and stored procedures; enrich data with new columns/tables
Implement a star schema; denormalize, aggregate, merge/join data
Identify and resolve duplicate data, missing data, or null values; convert column data types; filter data
Query and analyze data using the Visual Query Editor, SQL, KQL, and DAX
Domain 3 Implement and manage semantic models (27.5%)
Choose a storage mode; implement a star schema and relationships (bridge tables, many-to-many)
Write DAX calculations using variables and functions (iterators, table filtering, windowing, information functions)
Implement calculation groups, dynamic format strings, and field parameters
Configure large semantic model storage format; design and build composite models
Implement performance improvements in queries/report visuals and improve DAX performance
Configure Direct Lake (default fallback, refresh behavior, Direct Lake on OneLake vs SQL analytics endpoint); implement incremental refresh
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:
free Microsoft Azure account (https://azure.microsoft.com/en-us/) hereHardware: Window or Mac Laptops
Job Roles
Job Roles
- Microsoft Fabric Analytics Engineer
- Data Warehouse Engineer
- Power BI Data Modeler
- Data Architect (Fabric)
- Business Intelligence Developer
- Data Platform Engineer
- Fabric Solutions Consultant
- Data Integration Engineer
- Analytics Consultant
- Spark Developer (Fabric)
- Delta Lake Data Engineer
- Real-Time Analytics Engineer
- Power BI Optimization Specialist
- Enterprise Data Analyst
- DataOps Engineer
- Semantic Model Developer
- Fabric Administrator
- Data Governance Analyst
- Cloud Data Engineer
- Analytics Platform Consultant
Trainers
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.
Review
Write Your Own Review
- Recommended Courses
WSQ - Data Analytics and Visualization with Power BI
$800.00 (GST-exclusive)
$872.00
(GST-inclusive)
WSQ - Microsoft Power BI Data Analyst Associate (PL-300)
$1,200.00 (GST-exclusive)
$1,308.00
(GST-inclusive)
