Please come to the Atlanta SQL Saturday BI Edition in February, and join me for a full-day preconference event: Designing and Developing Enterprise-scale Solutions with Power BI
See a complete description of the workshop and register here.
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.
Bring your questions to the webinar for a live Q&A session.
• 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