Executive Summary 

BMT strives to deliver clarity through complexity and, with this, we start at home. This Reporting Strategy provides the framework on how we will deliver internal reporting that is clean, accurate and best in class.  Purpose and Vision  The Reporting Strategy is designed to unify BMT’s approach to internal reporting, embedding consistent standards for quality, … 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

My first Power BI

Create Parameters Create two parameters… Use a Token on myBMT The token allows the Datawarehouse to identify with the source of the report, as PowerBI cannot send environment details. (answers on a postcard please, if you know how) So the token is used to give the report a unique identifier myBMT | Token (bmt-dwh-uks-app-my.azurewebsites.net) Navigate … Read more

Understanding product delivery

Product delivery involves ensuring that a product or service is developed in a timely and cost-effective way, meeting the user needs. Skill level Description Awareness You can:manage your contribution to tasks to fit in with the work of your wider team Working You can:show an awareness of the differences between delivery methods, such as Agile … Read more

Agile and Lean practices

Agile delivery involves encouraging teams to build incrementally, test and iterate their work based on regular feedback and other useful data. Skill level Description Awareness This skill level is currently not defined. Working You can:demonstrate experience in applying Agile principles in practiceprovide a clear, open and transparent framework in which teams can delivershow an awareness … Read more

Project management

Project management involves understanding the life cycle of a project to achieve its objectives within the agreed parameters. Skill level Description Awareness You can:show an awareness of project management techniques, and an appreciation of how they are applied in the environment Working You can:apply your knowledge and experience of project management methodologies, including tools and … Read more

Logical and creative thinking

You can apply logic and creativity to approach a problem. Skill level Description Awareness You can:identify problems in databases, data processes, data products and services, with an understanding of the level of a problem (for example, strategic, tactical or operational)contribute to the implementation of remedies and preventative measures Working You can:respond to problems in databases, … Read more

Statistical methods and data analysis

Applied mathematics and statistics involves applying analytical methods including exploratory data analysis, visualisation and statistical testing to help make accurate recommendations. Skill level Description Awareness You can:understand the theoretical basis for applied practicesbegin to apply the theory to practical examples Working You can:understand how and when to practically apply existing best practice solutions Practitioner You … Read more

Data visualisation

Data visualisation involves producing graphical representations that communicate data, such as charts and graphs. Skill level Description Awareness You can:work under direction to use the most appropriate medium to visualise data to tell a story, relevant to the fully defined goals and able to be acted uponpresent, communicate and disseminate analysis and recommendations appropriately, under … Read more

Data management

You can understand data sources, data organisation and storage. Skill level Description Awareness You can:show an awareness of organisational data governance, and how it works in relation to other organisational governance structures Working You can:understand data governance and how it works in relation to other organisational governance structuresparticipate in or deliver the assurance of a … Read more