Project 2.2

Operations Dashboard with Row-Level Security

A 10-page Power BI report on orders, SLA compliance, stock and consumption across 100+ sites, where each user sees only their own sites.

Video 1Highlight (38 s).Home, Orders, the Chart / Summary switch, a slicer, stock and staff output, then the report viewed as one supervisor.

Stack: Power BI, Power BI Embedded
Role: Report design, measures, row-level security, custom visuals

report pages: 10
measures: 70+
sites: 100+

1Walkthrough and screens

Recorded in Power BI Desktop's editing view, so small hover icons and a selection outline appear in the videos.

Video 2Full walkthrough (4 min 39 s).All ten pages in twelve captioned parts, with cross-filtering and slicers, then row-level security viewed as one supervisor.

Dark green landing page titled "Pantry Performance Executive Report" with three KPI tiles and four white cards named Pantry Logs, Orders, Inventory and Staff Performance. — Fig. 1Home: the executive landing page.Three headline figures and four section cards lead into the nine content pages.

Dashboard page with four KPI cards, a table of pantries with green and red status labels, a grid of green and red squares, and an area chart peaking around midday. — Fig. 2Pantry Logs.Each pantry's latest lunch break, the lunch-limit breaches, and how many pantries are on break through the day.

Dashboard page with four KPI cards with small trend lines, a percentage ring, a line chart, a donut, a green heatmap, a three-step arrow diagram, a scatter chart and a treemap. — Fig. 3Orders.Delivered orders against the SLA target: monthly trend, order size, day and hour, delivery stages, pantry and department.

Dashboard page with four KPI cards, a segmented status bar, a bar chart with a rising cumulative line, six small area charts and a table with status labels. — Fig. 4Wrong Orders.Wrong-order reports by handling status, a Pareto of reasons and each reason month by month.

Dashboard page with four KPI cards, three red bars with target markers, a green matrix of monthly counts with a total column, and a long table of order lines. — Fig. 5Order Transactions.Share of orders inside target by order size, and delivered orders by pantry and month.

Dashboard page with four KPI cards, seven battery shapes filled amber or green, a board of red, amber and green tiles with counts, and a table with stock status labels. — Fig. 6Inventory: Raw Items.Stock above minimum per category, and the pantries to restock first.

Dashboard page with four KPI cards, colored squares with a category legend, six ranked horizontal bars and a table of menu items. — Fig. 7Inventory: Finished Items.The menu by category and the most ordered items.

Dashboard page with four KPI cards, a stacked area chart across seven months, a flow diagram from three movement types to ten reasons, and a table of movements. — Fig. 8Inventory: Stock Transactions.Weekly stock movements by type, and a flow from movement type to recorded reason.

Dashboard page with four KPI cards, a three-step podium with names, red bars measured against a target line, and a table with small progress bars. — Fig. 9Staff Performance: Output.Who delivered the most orders and who is furthest below the SLA target.

Dashboard page with four KPI cards, a two-sided bar chart by weekday, a calendar grid in shades of green and a table with on-time and left-early labels. — Fig. 10Staff Performance: Logging Sessions.Late logins and early logouts by weekday, with a calendar of late logins.

Card titled "Volume against SLA, by pantry" with a Chart / Summary toggle set to Summary, four colored count tiles and a ranked list of seven pantries with order counts and percentages. — Fig. 11Orders: the Chart / Summary switch, in Summary.The scatter card switches to a summary: four quadrant counts and the pantries that are busy and off target.

Pantry Logs page showing 100 total pantries, a table listing pantries with several different supervisor names, and a grid of 100 squares. — Fig. 12Row-level security, before: no role.No role applied: 100 pantries, 13 breaches, every supervisor in the table.

Pantry Logs page showing 8 total pantries, a table of eight rows all with the same supervisor name, and a grid of eight squares. — Fig. 13Row-level security, after: viewed as one supervisor.Viewed as one supervisor: 8 pantries, 3 breaches, only her pantries in the table.

2The problem

Orders, SLA compliance, stock and consumption had to be reported across 100+ sites, to users who should each see only their own sites.

3What I built

I built a 10-page Power BI report with 70+ measures. Row-level security limits each user to their own sites. The Home page, header, navigation and filter panel are my design, and each content page has four KPI cards and custom visuals.

4How it works

Power BI. One report, 10 pages, 70+ measures.
Row-level security. One dynamic role limits a supervisor to their own pantries. It is shown here with View as in Power BI Desktop.

5What it shows

Home. Headline figures and section cards that lead into nine content pages.
Pantry Logs. Lunch-limit breaches, and how many pantries are on break through the day.
Orders. SLA compliance by month, order size, day and hour, pantry and department, plus wrong orders and order lines.
Inventory. What to restock first, the most ordered items, and stock movements by reason.
Staff Performance. Output against the SLA target, late logins and early logouts.
Per-user view. With no role, Pantry Logs shows 100 pantries. Viewed as one supervisor, it shows 8.