Broadspectrum Power BI SAP Shaun Loke Reporting Analytics

Broadspectrum - Power BI & SAP Shaun Loke – Reporting & Analytics Manager

Broadspectrum – Ferrovial Services Company About Us We deliver a diverse range of essential infrastructure, operational and other services that support thriving communities and economic and social development across Australia and New Zealand. Our community-centred, future-focused solutions set international benchmarks for public and private infrastructure in the transport, resources, utilities, social infrastructure and defence sectors. Our global workforce allows our clients to access a comprehensive catalogue of construction, facilities maintenance, asset management, operations and upgrade services and expertise. Industries 2

Broadspectrum – Power BI Solution Current Landscape • 8, 000+ Consumers (Internal & Clients) • 200+ Developers (Pro license) • Supported by P 1 Premium Capacity • Enterprise Gateway – data connectivity across multiple enterprise solutions including SAP BW, m. SQL, Amazon Redshift Client Reporting • 133 App Workspace with 1, 500+ Reports Management Reporting Ad-Hoc Analysis

Broadspectrum – SAP & Power BI Interface Power BI Premium Planning and Deployment Whitepaper

Broadspectrum – Power BI Demonstration Employee Counts • Based on BW standard content of 0 PA_C 01 “Headcount and Personnel Actions” • Connect through to BW Query and select variables and data items • Creation of PBI reports including the use of custom visuals • Publishing of reports to Power BI Service and refreshing of data through gateway Additional Steps • Applying formatting schemes • Manipulation of variables through PBI parameters • URL link back into ECC web • Addition of Key influencer visual

Broadspectrum – Current Transformation Project • Using Dataflows to create a self-service Datamart - Data Governance applied at this layer • Dataflow allows us to remove the technical aspects of datasource connections whilst providing the users with a normalized dataset ready for consumption • Dataflow allows us to enable citizen developers working on governed data so accurate & consistent insights are achieved

Broadspectrum – Our learnings so far Learnings • Be agile in approach and deployment – technology is unlocking new approaches. Help your organization to embrace the change to reap the rewards • Educate your organization and leverage their skills – embrace citizen developers, protect them with education, enable them with data • Build your community internally with community of practice, workshops and forums • Work with your IT group – there are often reasons that systems may not be integrated, understand the reason and work together to get the data you need Accomplishments 1. Capability • Blending data from a variety of system in an automated fashion • Native connections for core BRS application • Proven capability for rapid deployment • Web based GUI through commonly understood mechanism of o 365 • Monthly updates to PBI provides new features and data connections 2. Flexibility 3. Adoption • Architecture is innately flexible allowing publishing within local client, local network, public cloud or private cloud • Low code/No code offering enables a wide variety of users to develop and use PBI • Majority of IT administration and processes are already established as part of o 365 • Enterprise Gateway enables secured connections through to a variety of data-source with minimal effort • Premium Capacity removes licensing requirement for end-users • B 2 B connectivity through AD allows for client sharing outside of BRS o 365 tenancy

Q&A • Questions? • Shaun. Loke@broadspectrum. com Thank You https: //agile-analytics. com. au Iman Eftekhari Matt Allington