Report Optimisation

Optimise Power BI, cut costs

Boost efficiency with high-performing solutions that meet
Microsoft standards.

  1. Increase user satisfaction
  2. Align with Microsoft best practices
  3. Ensure scalability for future growth
Discuss My Project
We’ll never share your info with anyone
a white circle on a gray background

Are Your Reports Lagging Behind?

a cell phone with a list of items on ita diagram showing the different types of customer satisfaction
Your
Business
a screen shot of a cell phone with a list of featuresa diagram showing the steps in the process of creating a web page

50-Questions to Peak Performance & Best Practices

Are your users frustrated with slow report performance or incomplete overnight refreshes? Are you struggling with report maintenance and sluggish Power BI Desktop performance? My 50 Questions to Peak
Performance and Best Practices can help.

I cover key areas such as the semantic model design, data transformations, DAX, reporting elements,
licensing, security, and more to ensure your solutions are high-performing and scalable for the future.

With extensive optimization experience, I offer tailored solutions that include actionable recommendations,
detailed guidance, or full implementation. My services ensure faster, more reliable, and user-friendly reports
based on your specific needs.

an orange cube is shown on a white backgrounda blue hexagonal object on a white backgroundan orange cube is shown on a white backgroundan image of a yellow cube on a white backgrounda blue cube with a white background

Performance & Best-Practice Approach

Step 1

Data Sources

  1. Understand data sources being used
  2. Review performance of data sources

Step 2

Semantic Model

  1. Evaluate Structure
  2. Connectivity Structure
  3. High Cardinality Columns
  4. Data Types & Encoding
  5. Exploring options enabled
  6. Query Reduction
  7. Bi-Directional & Many-to-Many Relationships
  8. Implicit vs Explicit Measures

STEP 3

Data Transform

  1. Reusable elements
  2. Push Transformations to Source-Side
  3. Remove unused columns/tables
  4. Disable Load to Models
  5. Data Types
  6. Optimise transformations

Step 4

DAX

  1. Write Efficient DAX Queries
  2. Use Variables for intermediate Results
  3. Avoid Row Context When Possible
  4. Optimize Complex Measures
  5. Utilise time-intelligence correctly

Step 5

Reporting

  1. Report Design best Practices
  2. Performance Tuning
  3. Accessibility and Mobile Optimisation
  4. Data Storytelling Principles

STEP 6

Licensing/Capacity

  1. Evaluate Licensing Needs
  2. Capacity Planning
  3. Performance Monitoring

STEP 7

Security

  1. RLS/OLS
  2. Making
  3. Privacy Levels
  4. Sensivity Labels
  5. Endorsements

STEP 8

Gateway

  1. Gateway Configuration
  2. Data Refresh Optimization

Why choose Laz for Performance Optimisation?

There's plenty of great information online about optimizing Power BI. Start with my free "50 Questions to Ask When Optimizing Power BI Solutions." However, if you find it overwhelming, why choose me? I've worked with Power BI since its early days, and have extensive experience with components like Analysis Services and Power Query. I've successfully completed numerous projects focused on improving performance. My comprehensive approach ensures every critical element is optimized, enhancing speed and efficiency.

there is a man sitting at a table with a glass of wine
Discuss My Project
We’ll never share your info with anyone
a computer screen with a wrench and gears on it

Tried & Tested Approach

My approach has optimised performance for organisations across diverse industries, consistently aligning with best practices
a red clipboard with a magnifying glass on top of it

Understand Current State

Effective optimisation begins with assessing the currentmemory usage, compression types, largest tables, and more. I start by evaluating these and then optimise to show improvements
a black and red picture of a line graph on a red background

Maximizing Business Value

My approach goes beyond enhancing performance. I will provide recommendations on how to make your solutions better aligned to answering key business questions
a gearwheel with a red arrow pointing up

Optimisation Experience

With years of experience in Power BI and relatedtechnologies, I bring a deep understanding of best practices and advanced techniques
a red icon of a gear wheel with a person on it

Customisable Approach

Every organisation has unique needs and budgets. My approach is flexible to ensure value is always delivered
a red speech bubble with two people talking

Transparent Communication

I maintain open communication throughout the process. You’ll be informed at every step, with explanations of what’s done and why, ensuring you’re fully aware of the improvements
a red and white logo with the letter g

Ongoing Support

After any work carried out, you will still have access to me for any follow up questions
a red heart with two smaller hearts in the middle

Personal Attention

Work directly with me, Laz – not the second best. You’ll receive my full expertise and attention at a competitive rate
a red icon of a group of people

Community Engagement

Actively involved in the community, not just a remote face
a red square with a white q on it

Challenging the Status Quo

I challenge bad practices and always strive to offer value
Frequently Asked Questions

The answers to your questions.

Discuss My Project
We’ll never share your info with anyone
What areas do you focus on as part of the performance optimisation process?
a close up of a white arrow pointing to the right

I focus on understanding the current state, identifying performance bottlenecks, optimising data sources, refining the semantic model, improving data transformations, and enhancing DAX calculations and reports. Additionally, I review licensing, Premium/Fabric capacity, security, and the data gateway. Each stage is crucial for boosting overall performance and aligning with best practices, prioritising areas with the most impact on existing challenges.

Is your optimisation process customisable?
a close up of a white arrow pointing to the right

Absolutely! During our free consultation call, we discuss your current performance challenges and tailor the approach to meet your specific needs. My flexible approach ensures we deliver the most value within your budget and requirements. We can provide details on what’s causing the performance issues, how to fix them, or implement all changes alongside the recommendations.

I’ve already identified some performance issues; can you still help?
a close up of a white arrow pointing to the right

Certainly! If you’ve already identified specific performance issues, we can dive straight into addressing those problems. My optimisation process is adaptable, allowing us to focus on your immediate concerns while ensuring a comprehensive enhancement of your Power BI environment.

What sets your optimisation process apart from others?
a close up of a white arrow pointing to the right

There is a wealth of information online about performance optimisation, so any data professional should know where to look. However, my extensive experience is what truly sets my approach apart. I have been working with Power BI since its inception and with the core components like Analysis Services, Power Query, and Power Pivot long before Power BI became a tool. This deep background allows me to understand the underlying engine in great detail, utilise advanced tools for optimisation, and deliver results faster.

What are the deliverables of the optimisation process?
a close up of a white arrow pointing to the right

The deliverables can be customised based on your needs. The core deliverable is a detailed document with recommendations on areas that need optimisation and how to fix them. This can include a fully optimised Power BI solution, documentation of changes made, performance benchmarks before and after optimisation, and best practice guidelines for maintaining performance.

How do you handle feedback during the optimisation process?
a close up of a white arrow pointing to the right

Feedback is an essential part of my optimisation process. Between each stage, we will have a review session to ensure we are all aligned and satisfied before moving on to the next step. This iterative approach ensures that the final product meets your expectations and delivers maximum value.

What kind of support do you offer after the optimisation is completed?
a close up of a white arrow pointing to the right

I like to build long-term relationships with my clients. After completing an optimisation engagement, I remain available to answer all questions and address any concerns, ensuring your satisfaction and providing continuity for ongoing improvements.

How long does such an engagement take?
a close up of a white arrow pointing to the right

The duration depends on various factors such as the deliverables (recommendations or implementation), the level of detail (identifying issues or fixing them), the number of solutions (one PBIX file or multiple), and whether the Power BI Service is included. We can discuss your specific requirements and provide a timeline based on your current needs.

Ready to Discuss your Governance Challenges?

Discuss My Project
We’ll never share your info with anyone
a close up of a group of colorful colored pencils