CPAP · Data Analysis
Certified Power BI & Analytics Professional
Build Power BI reports that answer real business questions.
Enroll Now
Course overview
Build Power BI reports that answer real business questions. The course covers power Query data preparation, Relationships and DAX measures, Report design and interaction.
Create an interactive Power BI report and verify its calculations against source totals. Participants explain their choices, test assumptions and identify what evidence would support implementation in their organization.
Who should attend
Reporting teams, analysts and operations managers.
Prerequisites Basic spreadsheet skills; Power BI Desktop for labs.
Learning outcomes
- Explain power Query data preparation in a workplace scenario.
- Use methods for relationships and DAX measures in a workplace scenario.
- Evaluate decisions about report design and interaction in a workplace scenario.
- Design an approach to validation, publishing and governance in a workplace scenario.
- Create an interactive Power BI report and verify its calculations against source totals.
- Present your evidence, assumptions and recommendations to relevant stakeholders.
Course Content
Power Query data preparation
6 hoursConnect sources, transform data in Power Query and document refresh assumptions.
Relationships and DAX measures
6 hoursBuild a simple model, define relationship cardinality and write measures in DAX.
Report design and interaction
6 hoursCreate accessible visuals, filters, drill-downs and a clear report navigation path.
Validation, publishing and governance
6 hoursReconcile report totals, plan publishing access and document refresh and governance.
Practical work
Create an interactive Power BI report and verify its calculations against source totals.
Mode of study
Study independently with SDC USA’s preparation materials, on your own schedule.
- Submit your enrolment request. Select Enroll Now and share your details for this program.
- Receive and pay your invoice. The SDC USA team will email your invoice and payment instructions.
- Work through your preparation materials. Once payment is confirmed, SDC USA will assign your self-study materials. They include study guides, practical exercises and practice questions.
- Schedule your assessment. When you’re ready, reply to the email that confirmed your materials so the SDC USA team can arrange your exam.
Certification and assessment
Accredited by Skill Development Council USA. The assessment is multiple-choice, with a 70% passing mark and up to two retakes. The certificate has no expiry or renewal requirement. This program carries 24 CPD hours.
Verify an issued certificate using its ID or the QR code where provided. Open Certificate Verification
Registration and cancellations
Paid enrolments are non-refundable, subject to applicable law. If you have questions about cancellation or exam scheduling, ask the SDC USA team before paying.
Course enrolment request
Fields marked * are required.