Data Model Overview
The data model at Krux is designed to help clients explore their data easily and build reports quickly. The model uses a star schema where the data is stored in two types of tables:
- Dimensions– non-numerical, descriptive attributes about the data (e.g., Date, Category, Subcategory, Location, Company, etc.)
- Facts – numerical data that is measurable and quantitative (e.g., Charges, Quantity, Penetration, Hours, etc.)
As well, the data model is comprised of Measures and Calculated Columns. These are made available within the data model to make pre-calculated fields available. A Measure aggregates Facts data (e.g., sum, average, count) across many rows of data whereas a Calculated Column is calculated at the row level.
Reporting tool
The Krux data model uses Microsoft Power BI as it's reporting platform. If you are not familiar with Power BI as a tool, here are some great links to help you get started:
Tips/Quick start guidelines
-
Save an existing Dashboard report and look at how it was created
-
Try starting with data that you are familiar with
-
Use filters to reduce the amount of data
-
Start with a table visualization – they are easier to understand
-
Measures (from the ‘Measures Table’) are always used in combination with Dimensions (e.g., DIM_Date, DIM_Category, DIM_Hole)
-
Facts (e.g., FACT_Activity, FACT_Equipment) are always used in combination with Dimensions (e.g., DIM_Date, DIM_Category, DIM_Hole)
-
Hover over a fact or dimension table to see a tooltip appear that describes the data that resides in the table
Need assistance or more documentation? Send a request to support@kruxanalytics.com