Scalable enterprise reporting with Excel & Power BI

Speaker:

Paul Martin

Find on Linkedin

About the session

As Power BI models and Data Warehouses get forever larger in size and complexity, scalability is no longer a backend issue, it is very much how to deliver the same scalability using that data in front end tools such as Excel. How can Excel add value when you have terabytes of data and how can you harness standard Excel functionality to drive Power BI queries such as top n sales, but only where sales are greater than 1m? EiB has developed a freemium Excel 365 addin called ReportStudio to allow you to do all the above and more.

With Paul Martin

Related sessions

View All

5 Feb

9:30 am

–

9:30 am

The Power Stack

Don't panic! A guide to error handling in Power Query

Tackle Power Query errors head-on by turning frustrating mistakes into learning moments, plus learn about priceless debugging methods.

Melissa de Korte

5 Feb

10:50 am

–

10:50 am

The Power Stack

From mockups to masterpiece: Designing Power BI reports that delight stakeholders

Explore the importance of mockup creation in Power BI, capturing stakeholder needs early to align expectations before the final report.

Gustaw Dudek

5 Feb

10:10am

–

10:10am

The Power Stack

The magic of the CONCATENATEX function in Power BI

Uncover the power of CONCATENATEX in Power BI to enhance reports with visuals, itemised breakdowns, and simplified calculations.

Chandeep Chhabra

Explore our Team Training Offer

Our CPD-accredited training programs are designed to enhance productivity and streamline operations. Fully customizable to align with each organization’s unique needs.

Explore Corporate Training