Assignment A11 — Ship It
Skills assessed. RLS roles with verified filtered values · mobile layout ·
the deployment plan.
Submit: A11_LastFirst.pbix plus a one-page deployment plan. Worth 20
points. Everything graded is checkable in the .pbix — Service-tenant steps appear in the
plan, not the file, so the assignment works in every licensing lane.
Requirements
- Two static RLS roles (Modeling → Manage roles), exact names:
Midwest Manager— filter on the Regions dimension:[Region] = "Midwest"Online Manager—[Region] = "Online"
- Verify with View-as and record in the plan: under Midwest Manager, the all-time revenue card reads $8,706,946.00; under Online Manager, $29,892,682.72. If your numbers differ, a relationship is leaking — find it before submitting (the returns card is the classic tell).
- Mobile layout for your Briefing page: answer card first, one claim per screen-height, slicer last.
- The deployment plan (one page): for the scenario "2 builders, 40 sales readers, 5 regional managers, nightly SharePoint data" — answer the four questions: who builds (roles), who reads and how (app), how data arrives (refresh + reachability, gateway or not), who sees what (your RLS design, static now, dynamic when). Include your two View-as verification figures.
Checklist (what the grader checks)
| # | Check | Points |
|---|---|---|
| 1 | Both roles exist by exact name with correct DAX filters on the Regions table | 6 |
| 2 | Role-filtered evaluation: Total Revenue = $8,706,946.00 (Midwest) / $29,892,682.72 (Online) | 5 |
| 3 | Mobile layout exists for Briefing with the card leading | 3 |
| 4 | Deployment plan answers all four questions correctly for the scenario (instructor-graded; SharePoint = no gateway is the checkable detail) | 5 |
| 5 | File named A11_LastFirst.pbix | 1 |
Before you submit
- View-as each role and read every card — not just revenue. A card that ignores the role is a leak with a page number.
- Read your plan as the IT person who will implement it. Any step they couldn't execute from your words needs rewriting.
- Save, close, reopen, verify.