1 / 19

In a cube in the office there lived an information worker…

In a cube in the office there lived an information worker…. Power BI Self-Service Information Management. Power Query and Data Stewardship. Matthew Roche @ SQLAllFather Microsoft Corporation. Range- er. Emailrond. IT- dalf. Information Worker.

arden-glenn
Download Presentation

In a cube in the office there lived an information worker…

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. In a cube in the office there lived an information worker…

  2. Power BI Self-Service Information Management Power Query and Data Stewardship Matthew Roche @SQLAllFather Microsoft Corporation

  3. Range-er Emailrond IT-dalf Information Worker IT-dalf Dark Data steward

  4. Power BI Review

  5. Microsoft Power BI for Office 365Self-service BI with the familiarity of Office and the power of the cloud Insights in Excel1 Billion Office Users Collaborate in Office 3651 in 4 enterprise customers on Office 365 Discover Analyze Visualize Share Find Mobile Q&A Scalable | Manageable | Trusted

  6. Demo SSIM in Power BI

  7. Challenges and Target Audiences Information Workers Data Stewards (supported by ) IT Pros (in midsize to very large organizations) “…only business users close to the content can evaluate information in its business context” -- Gartner • Information Workers spend too much time searching for data, and preparing it for use instead of focusing on actually analyzing the data • IT spends too much time and resources servicing data requests from the business while trying to secure and govern data access and use • The lack of trust in information continues as a significant inhibitor to businesses

  8. Power BI SSIM Main Modules Data Catalogue • Stores and processes metadata about data sources, users and their relationships • Provides data & metadata search functionality across multiple sources • Connects to corporate data through data integration layer Power Query in Excel Data Management Portal • For Information Workers: • to discover and access relevant data • to filter and re-shape data • For query authors and Data Stewards • to define repeatable data queries that acquire and transform data consistently • to publish/share and annotate queries for other IWs to find • For Data Stewards and query authors: • to manage metadata, shared queries, and published data sources • to see data telemetry (usages, search etc.) • to gain insight on data lineage Admin Center • For IT Administrators: • To setup, monitor and govern the cloud solution and data integration layer

  9. SSIM in Power BI – Hybrid Data Publishing Public data published by Microsoft Data Catalogue of corporate data Catalog of Public data Publish via Power Query Publish via Admin Center IW (query author) Data Steward IT Admin Corporate Data Data Management Gateway Legend: Publish Federated (automatically) Refer to data source Use tool

  10. Fostering a collaborative virtuous cycle for the Data Value Chain Enabling the Information Management Ecosystem The world’s data Web data • Refine • Combine • Annotate • Share Curated Public data Data Analysts (Producers) Corporate tenant Public tenant Information Workers (Consumers) • Discover • Connect IT Admin • Provision • Configure The organization’s data Data Stewards • Secure • Monitor • Operationalize • Discover • Combine • Clean • Annotate • Publish/Share • Arrows Legend: • Provision/configure service • Publish/Share data Metadata/Data flow • Discover data /Get data search results • Access data directly • Get telemetry • Certify • Categorize • View usage analytics and feedback

  11. Delivering Tangible Benefits for Customers Information Workers • A self-service and collaborative way to: • Seamlessly find and access relevant data • Easily enrich and reshape data to make it useable Data Stewards • Improve quality, usefulness and discoverability of data • Promote the correct usage of trusted data • Foster a community of productive data users • Balance self-service data discovery for the business with IT need for visibility and control • Reduce human and infrastructure resources required for data discovery and enrichment IT Professionals

  12. Defining the Data Stewardship Experience • The Data Steward Role • The Virtuous Cycle of Data Stewardship • Query sharing, management and telemetry

  13. The Data Steward “ I’m a business subject matter expert, sitting in IT or LOB as a liaison between the two. Depending on the size and type of the business, I may do part of someone else’s job (e.g. Anna or Vicki). Skills Accountabilities • 5+ years of industry experience • Proficient with Office (Excel, Word, PowerPoint). Can learn to use Power Pivot • Understands data relationships, data process flows. May know SQL. • Making data useful to the business • Consistent use of data across the business • Promoting and achieving high data quality standards • Resolving data integrity issues across stakeholders ” Perspectives Work Activities • Analyzes data for quality (particularly as part of BI work), reconciles data issues • Identifies and acquires new data sources • Actively analyzes data for ‘semantic’ quality • Drives resolution of data integrity issues across business and technical stakeholders. Leads and / or participates in MDM / EIM / DQ initiatives • Creates and maintains business metadata, references data values and meanings, and / or master data values and meanings • Process and detail oriented with great organizational skills • Prides himself on his creative resourcefulness, passion for quality and great interpersonal skills • A ‘de facto’ steward because of deep industry expertise and understanding of his organization’s data sources Stewart Data Steward Provisions & distributes high quality data

  14. Data Stewardship Experience Overview Patrick Provisions Tenant Patrick Assigns Role Membership Patrick Configures Data Management Gateways The Data Stewardship Experience represents a virtuous cycle of data augmentation, quality, awareness and availability. The more value the steward puts into the system, the more value the customer receives from the system. Patrick Monitors, Manages and Reacts

  15. Demo Stewart managing shared queries and analyzing usage telemetry data

  16. Review One does not simply walk into data discovery…

  17. Three Workbooks for the Analysts under the sky, Seven for the Report Writers in their halls of stone, Nine for Information Workers doomed to die, One for the Executive on his dark throne In the Land of Corporate where the Shadows lie. One Query to rule them all, One Query to find them, One Query to bring them all and in the meeting bind them In the Land of Corporate where the Shadows lie.

  18. Sometimes you don’t need a king. Sometimes aSteward is exactlywhat you need.

  19. Thank you for attending this session and supporting the MNW SQL User Group

More Related