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:
Additions Marketing New [Marketing] DataMart is designed to support Customer Acquisition and Campaign Management efforts. It provides a centralised, standardised structure for analysing marketing activities, optimising campaign performance, and understanding customer engagement across multiple channels. 12 standardised views. This structure allows for seamless integration and analysis of marketing performance across platforms (e.g., Advertising, Traffic, Email … Read more
The Marketing_Campaign_Details_Plus view provides an enriched and detailed representation of campaign metadata, serving as a foundational dataset for analysing and managing marketing campaigns. This view is designed to offer a structured, high-level summary of campaign attributes, ensuring clarity and consistency for reporting and decision-making. Key Features: Use Cases: The Marketing_Campaign_Details_Plus view offers a solid foundation … Read more