Release 43

by

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

by

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

by

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

by

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

by

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