Release 43
Release includes 23 improvements and 8 new views, affecting Project, Business Opportunity (Busopp), Customer, and Employee data views. DataMarts Affected 1. Project-related Views: 2. Business Opportunity (Busopp) Views: 3. Customer-related Views: 4. Employee-related Views: Notes Files sql/svw/project/project_activitydetails.sql (DEV) and sql/svw/project/project_activitydetails.sql (PRD) are different.Files sql/svw/project/project_forecast.sql (DEV) and sql/svw/project/project_forecast.sql (PRD) are different.Files sql/svw/project/project_details_plus.sql (DEV) and sql/svw/project/project_details_plus.sql (PRD) … Read more
SSMS with SQLCMD Mode
Using SSMS with a master script is a reliable approach, especially with multiple scripts. By running in SQLCMD mode within SSMS, you can use a single master script to execute multiple scripts in sequence without manual intervention. Step-by-Step Guide for SSMS with SQLCMD Mode Notes and Tips Additional Notes
Release 42
New Versions 202410 Content Reviewed by AI Project Details Removal of legacy Project_Item_ID as HASHADD project [STATUS] Project Details_Plus ADD Project Manager EmailRemove Project Dates (for Project.Dates)Remove FINANCIALLY RESPONSIBLE (for Project.RoleAssignment)Remove CUSTOMER RESPONSIBLE (for Project.RoleAssignment) Project Dates First Version since Beta Project_Cost ADD PRU CodeREMOVE Dates (for Project.Dates)Include Currency (of Company)COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE) AS CURRENCY_CODE Project_Value … Read more
MVC application to Power BI
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
Data & Analytics Stakeholder Domains
1. Base DataViews & DataMart Architecture 2. CRM and Transactional Data 3. Data Security and Governance 4. Signposting of Insights 5. Metadata and Data Lineage 6. Master Data Management (MDM) 7. ETL/ELT and Data Integration Processes 8. Analytics and Data Modelling 9. Data Lifecycle Management & Archiving 10. Data Quality and Stewardship 11. Real-Time Data … Read more
Datamart/Reporting Development Workflow
Objective: Design, develop, deploy, and maintain Datamarts with a focus on performance, security, and usability. Steps: Data Discovery and Requirements Gathering Datamart Design and Security Planning MVP Development and Iteration Deployment and Go-Live Maintenance and Performance Testing
Data Acquisition and Transport Workflow
Objective: Efficiently acquire data from various sources and ensure secure, accurate, and timely transport to the data lakehouse and data warehouse. Steps: Data Source Identification and Mapping Data Profiling and Classification Data Acquisition and Integration Transport to Data Warehouse Testing and Validation
Data Quality Improvement Initiatives
It is essential for BMT to take a holistic approach and adopt a combination of different strategies, such as Data Ops, Data Observability, Data Mesh, and Data Quality Checks to improve the quality of data. Despite the differences in focus, one common thing among the frameworks strategies above is the need for a unified governance … Read more
Data Operating Model with SOP Integration
Standard Operating Procedures (SOPs) guide the DOM’s processes, ensuring efficiency and consistency at each stage. Purpose & Scope of the Data Operating Model Standard Operating Procedures Across Key Stages Data Planning SOPs Data Acquisition SOPs Data Processing & Maintenance SOPs Data Publish & Share SOPs Snapshot & Archive SOPs Data Flow and Governance within the … Read more