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
Requirements & Design This document is used to outline details related to reporting requirements of the project. Specifically, this document captures the technical specifications that are required for the successful design and development of business reports. Report Technical Specifications This section is used to describe the detailed specification related to how NUIT will develop a … Read more
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
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
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
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 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 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
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