Power BI Analyst Toolkit
A model you can inspect and adapt.
An assembled PBIP project with four report pages, 30 retail measures, source-quality checks, sample data and defect fixtures. Desktop validation is pending.
Read two pages from the included guide (PDF)
What you can do with it
- Revenue, product, customer and source-quality page definitions
- 30 retail DAX measures plus four quality measures
- Clean data, independent controls and 12 defect fixtures
- KPI workbook and a native Desktop validation checklist
Exactly what is included
1 BIM · 40 CSV · 31 DAX · 32 JSON · 18 M · 3 MD · 1 PBIP · 1 PBIR · 1 PBISM · 1 PDF · 6 TXT · 2 XLSX
See every included filename (137 files)
CHANGELOG.txtCONTENTS.txtKNOWN-LIMITATIONS.txtKPI-Catalog-and-Scorecard-Blank.xlsxKPI-Catalog-and-Scorecard.xlsxLICENSE.txtREADME.txtStart-Here-Power-BI-Toolkit.pdfdax/Date-Table.daxdax/measures/01-Gross-Revenue.daxdax/measures/02-Net-Revenue.daxdax/measures/03-Discount-Amount.daxdax/measures/04-Cost-of-Goods.daxdax/measures/05-Gross-Profit.daxdax/measures/06-Gross-Margin-Pct.daxdax/measures/07-Completed-Orders.daxdax/measures/08-Completed-Lines.daxdax/measures/09-Units-Sold.daxdax/measures/10-Active-Customers.daxdax/measures/11-Average-Order-Value.daxdax/measures/12-Units-Per-Order.daxdax/measures/13-Revenue-Per-Customer.daxdax/measures/14-Discount-Rate.daxdax/measures/15-All-Orders.daxdax/measures/16-Cancelled-Orders.daxdax/measures/17-Cancellation-Rate.daxdax/measures/18-Revenue-YTD.daxdax/measures/19-Revenue-Prior-Year.daxdax/measures/20-Revenue-YoY-Change.daxdax/measures/21-Revenue-YoY-Pct.daxdax/measures/22-Revenue-Prior-Month.daxdax/measures/23-Revenue-MoM-Change.daxdax/measures/24-Revenue-MoM-Pct.daxdax/measures/25-Revenue-Rolling-90-Days.daxdax/measures/26-Orders-Prior-Year.daxdax/measures/27-Orders-YoY-Pct.daxdax/measures/28-Revenue-Share-of-Products.daxdax/measures/29-Product-Revenue-Rank.daxdax/measures/30-Latest-Order-Date.daxdefect-fixtures/README.mddefect-fixtures/bad-date/Customers.csvdefect-fixtures/bad-date/Products.csvdefect-fixtures/bad-date/Sales.csvdefect-fixtures/conflicting-status/Customers.csvdefect-fixtures/conflicting-status/Products.csvdefect-fixtures/conflicting-status/Sales.csvdefect-fixtures/duplicate-dimension/Customers.csvdefect-fixtures/duplicate-dimension/Products.csvdefect-fixtures/duplicate-dimension/Sales.csvdefect-fixtures/duplicate-line/Customers.csvdefect-fixtures/duplicate-line/Products.csvdefect-fixtures/duplicate-line/Sales.csvdefect-fixtures/expected.jsondefect-fixtures/fractional-line/Customers.csvdefect-fixtures/fractional-line/Products.csvdefect-fixtures/fractional-line/Sales.csvdefect-fixtures/invalid-discount/Customers.csvdefect-fixtures/invalid-discount/Products.csvdefect-fixtures/invalid-discount/Sales.csvdefect-fixtures/missing-column/Customers.csvdefect-fixtures/missing-column/Products.csvdefect-fixtures/missing-column/Sales.csvdefect-fixtures/missing-customer/Customers.csvdefect-fixtures/missing-customer/Products.csvdefect-fixtures/missing-customer/Sales.csvdefect-fixtures/missing-line/Customers.csvdefect-fixtures/missing-line/Products.csvdefect-fixtures/missing-line/Sales.csvdefect-fixtures/negative-cost/Customers.csvdefect-fixtures/negative-cost/Products.csvdefect-fixtures/negative-cost/Sales.csvdefect-fixtures/orphan-product/Customers.csvdefect-fixtures/orphan-product/Products.csvdefect-fixtures/orphan-product/Sales.csvdefect-fixtures/text-quantity/Customers.csvdefect-fixtures/text-quantity/Products.csvdefect-fixtures/text-quantity/Sales.csvpower-bi-project/Native-Desktop-Validation.mdpower-bi-project/Northstar.Report/definition/pages/customers/page.jsonpower-bi-project/Northstar.Report/definition/pages/customers/visuals/detail/visual.jsonpower-bi-project/Northstar.Report/definition/pages/customers/visuals/kpi0/visual.jsonpower-bi-project/Northstar.Report/definition/pages/customers/visuals/kpi1/visual.jsonpower-bi-project/Northstar.Report/definition/pages/customers/visuals/kpi2/visual.jsonpower-bi-project/Northstar.Report/definition/pages/customers/visuals/period/visual.jsonpower-bi-project/Northstar.Report/definition/pages/customers/visuals/segment/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/page.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/category/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/kpi0/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/kpi1/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/kpi2/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/monthly/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/monthlydetail/visual.jsonpower-bi-project/Northstar.Report/definition/pages/overview/visuals/period/visual.jsonpower-bi-project/Northstar.Report/definition/pages/pages.jsonpower-bi-project/Northstar.Report/definition/pages/products/page.jsonpower-bi-project/Northstar.Report/definition/pages/products/visuals/bars/visual.jsonpower-bi-project/Northstar.Report/definition/pages/products/visuals/detail/visual.jsonpower-bi-project/Northstar.Report/definition/pages/products/visuals/kpi0/visual.jsonpower-bi-project/Northstar.Report/definition/pages/products/visuals/kpi1/visual.jsonpower-bi-project/Northstar.Report/definition/pages/products/visuals/kpi2/visual.jsonpower-bi-project/Northstar.Report/definition/pages/products/visuals/period/visual.jsonpower-bi-project/Northstar.Report/definition/pages/quality/page.jsonpower-bi-project/Northstar.Report/definition/pages/quality/visuals/exceptions/visual.jsonpower-bi-project/Northstar.Report/definition/pages/quality/visuals/qa0/visual.jsonpower-bi-project/Northstar.Report/definition/pages/quality/visuals/qa1/visual.jsonpower-bi-project/Northstar.Report/definition/pages/quality/visuals/qa2/visual.jsonpower-bi-project/Northstar.Report/definition/pages/quality/visuals/status/visual.jsonpower-bi-project/Northstar.Report/definition/report.jsonpower-bi-project/Northstar.Report/definition/version.jsonpower-bi-project/Northstar.Report/definition.pbirpower-bi-project/Northstar.SemanticModel/definition.pbismpower-bi-project/Northstar.SemanticModel/model.bimpower-bi-project/Northstar.pbippower-bi-project/README.mdpower-query/01-Date-Table.mpower-query/02-Import-Sales.mpower-query/03-Clean-Text.mpower-query/04-Parse-Date.mpower-query/05-Duplicate-Keys.mpower-query/06-Unmatched-Customers.mpower-query/07-Validate-Sales.mpower-query/08-Unpivot-Months.mpower-query/09-Import-Dimension.mpower-query/V2-CheckDimension.mpower-query/V2-CustomersSource.mpower-query/V2-DataIssuesSource.mpower-query/V2-DateSource.mpower-query/V2-ProductsSource.mpower-query/V2-ReadCSV.mpower-query/V2-SalesAudit.mpower-query/V2-SalesClean.mpower-query/V2-pFolder.msample-data/Customers.csvsample-data/Expected-Totals.csvsample-data/Products.csvsample-data/README.txtsample-data/Sales.csv
Compatibility and limits
Windows Power BI Desktop is required. The project is supplied as PBIP source, with no binary PBIX/PBIT or preloaded data cache. Definition schemas and field references were checked; DAX, Power Query, refresh and visuals have not yet been executed in native Desktop.
Examples are fictional. Adapt the definitions and validate your own data. Prepared workbook capacities and extension instructions are stated in each guide.