You have no items in your shopping cart.
Course Details
Course Details
What You'll Learn
This course prepares you for the PL-300 certification exam, covering all official exam domains and their approximate weightings:
Domain 1 Prepare the data (27.5%)
- Identify and connect to data sources or a shared semantic model; choose between DirectLake, DirectQuery, and Import
- Change data source settings (credentials, privacy levels) and create/modify parameters
- Profile data (statistics, column properties) and resolve inconsistencies, nulls, and import errors
- Select appropriate column data types; create and transform columns; group and aggregate rows
- Pivot/unpivot/transpose data; convert semi-structured data to a table; create fact and dimension tables
- Identify/create appropriate keys for relationships; merge and append queries; configure data loading
Domain 2 Model the data (27.5%)
- Configure table and column properties; implement role-playing dimensions
- Define relationship cardinality and cross-filter direction; create a common date table
- Identify use cases for calculated columns and calculated tables
- Create DAX measures: single aggregations, CALCULATE, time intelligence, statistical functions, semi-additive measures
- Create quick measures, calculation groups, calculated tables/columns
- Optimize model performance (remove unnecessary rows/columns, use Performance Analyzer and DAX query view, reduce granularity)
Domain 3 Visualize and analyze the data (27.5%)
- Select and format appropriate visuals; apply themes, conditional formatting, slicing/filtering; create visual calculations with DAX
- Use Copilot to create/suggest report pages and narrative visuals; choose when to use a paginated report
- Enhance reports for usability: bookmarks, custom tooltips, visual interactions, navigation, drillthrough, sync slicers
- Design reports for mobile and accessibility; configure export settings and automatic page refresh
- Identify patterns and trends using the Analyze feature, grouping/binning/clustering, AI visuals, forecasting and reference lines
- Detect outliers/anomalies; use Copilot to summarize the underlying semantic model
Domain 4 Manage and secure Power BI (17.5%)
- Create and configure workspaces; publish, import, or update items; create dashboards and apps
- Choose a distribution method; configure subscriptions and data alerts; promote or certify content
- Identify when a gateway is required; configure semantic model scheduled refresh
- Assign workspace roles and configure item-level access and access to semantic models
- Implement row-level security roles and configure RLS group membership
- Apply sensitivity labels
Course Info
Promotion Code
Promo or discount cannot be applied to WSQ courses
Prerequisite
The learner must meet the minimum requirement below :
- At least O levels and above education
- Read, write, speak and understand English
The learner must also have basic Python knowledge. If you don't have Python knowledge, please consider the following WSQ courses:
Mode of Training
Instructor Classroom Training
WSQ Funding Validity Period
15 Aug 2020 - 14 Aug 2024
WSQ Course Fee Funding
Self-Sponsored
- Click here for more info on the funding for self-sponsored.
- Eligible Singapore Citizens can use their SkillsFuture Credit and PSEA funds to offset course fee payable after funding.
Employer-Sponsored
- Click here for more info on the funding for employer-sponsored.
- Absentee Payroll claimable by SMEs: Up to 80%of hourly basic salary capped at $7.50/hr
- Absentee Payroll claimable by Non-SMEs: Up to 80% of hourly basic salary capped at $4.50/hr
WSQ Assessment
- Participants will be assessed through individual assessment
- Passing Criteria – Participants are to answer all questions accurately in the individual written assessment.
- Participants may need to attend additional coaching sessions and re-assessments if they do not pass the required competency standards.
Job Roles
Job Roles
- Data Analyst
- Business Intelligence Specialist
- Business Analyst
- Data Visualization Specialist
- Financial Analyst
- Marketing Analyst
- Reporting Specialist
- Operations Analyst
- Sales Operations Manager
- IT Manager (with reporting focus)
- Product Manager (data-driven products)
- Supply Chain Analyst
- Project Manager (with data reporting needs)
- HR Analytics Specialist
- CRM Administrator
Trainers
Trainers
Saeid is co-founder of Skymics Sdn Bhd. He has 8 years of experience in the field of IoT (Internet of Things) and Information Technology. He is a certified IBM IoT Practitioner and instructor, and a Certified Citizen Data Scientist Train-The-Trainer. He has been co-inventor of 3 inventions during the last 4 years.
Review
Customer Reviews (6)
- Superb training Review by Course Participant/Trainee
-
I found the course extremely useful and relevant to my job. Highly recommend it to others. (Posted on 21/05/2024)1. Do you find the course meet your expectation? 2. Do you find the trainer knowledgeable in this subject? 3. How do you find the training environment
Write Your Own Review
- Recommended Courses
