Demo Scenarios
These scenarios are based upon Examples of the use of the semantic hub and semantic model catalog capabilities in the product.
One example is the ability for the intelligent feature of the semantic model catalog to merge various models with related metadata which are derived from a reporting tool (e.g., Tableau) and:
- Include various tables, columns, metrics and joins from each of the complementary source report models
- Identify and isolate differences in definitions between these, such as two metrics with the same name but with different expressions and thus meeting.
Data Warehouse Reverse Engineering
Steps
- Open the Semantic Model Catalog
- Click the BI Tool reverse engineering
- Search or Browse for the reports to import
- Click IMPORT
- Once completed go to the Editor tab.
Self Service BI Reverse Engineering
Overview
In this scenario we reverse engineer two model from Self Service BI sources (initially Tableau and Azure Power BI) and demonstrate how metrics (defined in the BI tools) are merged in several cases
Metrics Overview
| Use Case | Metric Name | Query / Formula |
|---|---|---|
| Identical metrics in each workbook | Net Sales Amount | [Sales Amount]-([Tax Amount]+[Discount Amount]) |
| Metric only in Workbook One (Date) | Defunct Customers | ({Effective To] < Today) |
| Metric only in Workbook Two (Customer) | High-Value Customer | ([Is Current] AND [[Customer Status]="GOLD") |
| Different metrics with same name in each workbook | Discount | ([Sales Amount]-[Discount Amount])/100 [Discount Amount]/100 |