This full-day workshop session will provide participants with essential best practice knowledge and practical tools to begin designing enterprise-ready solutions with Power BI. We will design a report, but this session will primarily focus on enterprise data modeling and dataset delivery for reporting & analytics.

Focus:
• Overcoming challenges with data at-scale
• Meeting the needs of data governance, business buy-in and ownership
• Addressing challenges with DevOps, code sharing and multi-developer projects
• Futureproofing Power BI solutions for business, data and user audience growth
• Delivering an enterprise Power BI solution using a best practice checklist
• So many features! OMG, let’s focus on the essentials!

Bring your laptop and together, we will design a business-ready solution, including:
• Fundamental data modeling
• Transformation basics & guidelines
• Designing and building performant queries for data at-scale
• Using parameters to manage source changes and environments
• Naming conventions, annotations, and documentation
• DAX essentials & building blocks
• Deployment planning
• Keeping it real – balancing “ideal” DevOps and realistic BI delivery
• Right-sizing data models for flexibility & expanding requirements

We will also discuss and demonstrate some advanced topics, including:
• When and how to consider using composite models
• Calculation groups – the key to flexible calculations

Laptop requirements:
• Windows 10 or 11
• 8 GB of RAM minumum
• Wifi ready
• Permission to install software from Windows Store & USB drive (if a company-issued machine)
• Latest version of Power BI Desktop