Devon and Cornwall Microsoft Power BI User Group

Power BI modelling has traditionally relied on graphical interfaces, but with the introduction of Tabular Model Definition Language (TMDL), developers now have a powerful scripting alternative. This session will introduce TMDL View in Power BI Desktop, explaining how it enables semantic modelling through code instead of the traditional UI without eternal tools support.

We will cover:
- How to enable and use TMDL View in Power BI Desktop
- Scripting and modifying semantic model objects such as tables, measures, and relationships
- Enhancing efficiency with code-based modelling, bulk edits, and reusability

This session is perfect for those new to TMDL or looking for a streamlined way to manage Power BI models.

My name is Cristian Prifti and when it goes to data, I help our clients in the region build solutions that will maximize the effective usage of it.

Luckily for me, data is also a passion, so I like to believe that in any project that we deliver, I get to also affect the data culture of companies we work it.

Enhance your Power BI dashboards with effective UI/UX principles! This session will cover key design strategies to improve user experience, optimize dashboard usability, and create visually compelling reports.

Learn best practices, essential design tips, and explore useful resources to take your Power BI visuals to the next level.

I’m a Data Engineer, BI and UX Consultant with a passion for building end-to-end data solutions that drive business decisions.

Whether it’s on-premise or in the cloud, I design efficient pipelines, craft insightful KPIs, and ensure businesses have the tools they need to unlock the power of their data.

My mission is to make analytics not just functional but intuitive and impactful because great insights deserve great design. 🚀

https://benixbi.com/

Profitability is a key metric; any profits can be distributed back to shareholders (owners) either directly or indirectly. A profit and loss (P&L) statement answers high level questions - such as “what was net profit last year?” - and summarises key revenue (i.e., product revenue) and expense (i.e., Research & Development) items. Unlike static reports, a P&L semantic model contains the detail; this allows end-users to ask questions such as “what was R&D spending broken down by a particular research project, fiscal period, or legal entity?.” A semantic model also allows end-users to consume information using Copilot prompts, Power BI reports, or Pivot Tables and formulas in Excel.

In this session, we will go through:
- Why you should build an income statement semantic model.
- How to use an accelerator to speed up development.
- The key questions you need to ask stakeholders.
- The challenges in building a P&L income statement.

Chris Barber is a chartered accountant (ACMA, CGMA) and Microsoft MVP. He is the author of income statement semantic models, advises Avanade/Accenture clients on building solutions using the Microsoft BI stack, and runs StarSchema.co.uk.