Purpose The Customer Invoice Item data mart is designed to provide detailed insights into invoice-level transactional data for customers. It organises, validates, and enriches raw data from the source system into a structured and accessible format, enabling comprehensive analysis and reporting. Use Case Owner: Soon Tan Typical Use Case: Style: Fact, Each row represents a unique Invoice … Read more
An interim release with no functional changes Notes 1. 🔴 MISSING IN PRD CONTAINER: customer_details_CAD.sql2. ⚠️ DIFFERENT: customer_details.sql3. ⚠️ DIFFERENT: project_cost_CAD.sql4. ⚠️ DIFFERENT: project_details_plus_CAD.sql5. ⚠️ DIFFERENT: project_details_CAD.sql6. ⚠️ DIFFERENT: project_revenue_CAD.sql Total number of different files: 5Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 1
Notes 1. ⚠️ DIFFERENT: project_cost_CAD.sql2. ⚠️ DIFFERENT: project_cost_USD.sql3. ⚠️ DIFFERENT: project_details_CAD.sql4. ⚠️ DIFFERENT: project_details_plus_CAD.sql5. ⚠️ DIFFERENT: project_details_plus_USD.sql6. ⚠️ DIFFERENT: project_details_USD.sql7. ⚠️ DIFFERENT: project_revenue_CAD.sql8. ⚠️ DIFFERENT: project_revenue_USD.sql Total number of different files: 8Total number of missing files in DEV CONTAINER: 0Total number of missing files in PRD CONTAINER: 0
Additions Employee.Absence This view combines employee data (DIM_EMPLOYEE_OL) with absence details (QFACT_ABSENCE_DETAILS_OL$) to facilitate the creation of a dataset used for tracking and analysing employee absences in detail. It generates structured JSON data for efficient reporting, compliance, and analytical purposes. Employee.AbsenceLimit This view creates a structured dataset for tracking and analysing employee absence limits. It … Read more
Purpose The Global Foreign Exchange Rate view provides a structured dataset for analysing currency exchange rates relative to the British Pound (GBP) as the base currency. This view supports financial and operational use cases requiring reliable exchange rate data for reporting and analytics. Use Case Source DataMart Integration There are no DataMart identifiers Sample Exec … Read more
Purpose This view creates a structured dataset for tracking and analysing employee absence limits. It links employee details (DIM_EMPLOYEE_OL) with their corresponding absence limit information (QFACT_ABSENCE_LIMIT_OVERVI_OL$), presenting the data in JSON format for improved integration and usability. Use Case Owner: Luisa WinderTypical Use Case: Style: Fact, Each row represents a unique Employee Limit Seq with … Read more
Purpose This view combines employee data (DIM_EMPLOYEE_OL) with absence details (QFACT_ABSENCE_DETAILS_OL$) to facilitate the creation of a dataset used for tracking and analysing employee absences in detail. It generates structured JSON data for efficient reporting, compliance, and analytical purposes. Use Case Owner: Luisa WinderTypical Use Case: Style: Fact, Each row represents a unique Employee Absence Seq with … Read more
Treating the Report Designer as the Controller in Power BI makes sense because they are responsible for orchestrating how data (Model) interacts with the user interface (View). The designer’s decisions define how business rules are applied, how data is processed, and how the user interacts with it. In this sense, the Report Designer does act … Read more
1. Model (Data Model in Power BI): 2. View (Report/Visualisation in Power BI): 3. Controller (User Interaction in Power BI): Application of MVC to Power BI Workflow: Practical Example in Power BI: Benefits in Power BI: In conclusion, although Power BI doesn’t directly follow the traditional MVC framework, its architecture of separating the data model … Read more
MVC, which stands for Model-View-Controller, is a design pattern used in software engineering, particularly in web and application development. It divides an application into three interconnected components, which separates internal data logic from the user interface, allowing for more manageable and scalable code. 1. Model: 2. View: 3. Controller: Workflow Example: Benefits of MVC: