SSBI + Fabric Interview Drill

Power BI default: table Total rows default to Sum for any numeric column — including percentages and rates — unless you change or disable them.
Rule of thumb: never sum a rate measure. Either recalculate the percentage from total numerators and denominators (e.g. DIVIDE() on summed Current and Prior), or hide the Total row entirely.
Training tip: this real −6.91% Total is a stronger teaching demo of “never sum a rate” than any scripted example.

95 practiced answers — Sales SSBI enablement plus Fabric, KQL/T-SQL, JSON→Bronze ingestion, Purview, Snowflake, Spark, Parquet, star schema, and data-engineering debugging.

SSAS → Fabric proposal D365 migration guide Project architecture Data modes infographic Direct Lake limitations Two-source ingestion Medallion architecture Delta schema changes RLS + Direct Lake OneLake + workloads OneLake foundation Lakehouse vs Warehouse Direct Lake mode JSON → Bronze guide Delta Parquet / OneLake Fabric shortcuts Medallion (bottling) Pipelines vs Dataflows Real-Time Intelligence IoT low-latency pipeline Data Activator Purview governance Data Map vs Catalog Fabric flashcards All learning pages

Azure Portal → Fabric architecture Portal provision → local load → Fabric connection → medallion → report. Open the full notes: mermaid flows, layer contracts, and Phases 1–12.

0 / 95 reviewed

No questions match your search.

95 questions · 16 categories · SSBI + Fabric + KQL/T-SQL + JSON Bronze + Purview interview prep
← Back to Learning · Project architecture · Fabric flashcards · Python venv guide

Sales SSBI — Azure Portal → Fabric

Sales SSBI architecture: Azure Portal provisions SQL Server, firewall, and four tables; a local Python script loads an Excel workbook into Azure SQL; Microsoft Fabric connects, ingests Bronze (including Excel Files/raw_excel), then Silver, Gold, Direct Lake plus DAX, and a Power BI report.

Talk track: Portal provision → local load (load_excel_to_azuresql.py) → Azure SQL → Fabric connection → Bronze (plus Excel upload to Files/raw_excel) → Silver → Gold → Direct Lake + DAX → Power BI report.

Open full architecture notes → mermaid diagrams, Bronze/Silver/Gold contracts, dual-track local ↔ Fabric, and runbook phases.