1 / 24

Miguel Llopis Principal Program Manager Matthew Roche Senior Program Manager

Microsoft Power BI: Unify all your data and deliver powerful insights with self-service data prep capabilities for big data. Miguel Llopis Principal Program Manager Matthew Roche Senior Program Manager. BRK2061. Where we are: a quick review. Reviewing Business Intelligence solutions.

leighw
Download Presentation

Miguel Llopis Principal Program Manager Matthew Roche Senior Program Manager

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. Microsoft Power BI: Unify all your data and deliver powerful insights with self-service data prep capabilities for big data Miguel Llopis Principal Program Manager Matthew Roche Senior Program Manager BRK2061

  2. Where we are: a quick review

  3. Reviewing Business Intelligence solutions Self-Service BI Data Warehouse Reports and dashboards OLTP systems Data Lake OLAP / Analytics Models Data Preparation / ETL

  4. Modern BI challenges • Fragmented, incomplete data • Pulling together data from traditional and cloud data sources, and figuring out how to enrich it is extremely difficult. Requires a team of specialists Creating E2E BI solutions requires multiple BI tools. This requires specific knowledge of each of the tools and complex integration to build and maintain an E2E BI solution. Business data has no structural or semantic consistency  Different applications, departments, and analysts define data in different ways, which makes data exploration, and reuse of data and apps extremely challenging. Complex system integration Traditional BI solutions span multiple applications and services. Sharing data across systems requires each system to understand the location, structure and meaning of the data.

  5. Demo A quick tour of self-service data prep in Power BI

  6. Evolving Power BI

  7. Self-service low code/no code • Integral part of Power BI stack Cloud and on-premises connectors Power BI introduces self-service data-prep capabilities Standard schema (Common Data Model) In-laketransformations Data reuse

  8. Power BI introduces self-service data-prep capabilities Self-service low code/no code • Integral part of Power BI stack Cloud and on-premises connectors Standard schema (Common Data Model) Dataflows • In-laketransformations Data reuse

  9. Power BI introduces dataflows Reports & dashboards Visualizations Datasets  BI models Dataflows Data prep Storage Data (Azure Data Lake) Gateways and connectors

  10. Modern BI challenges • Fragmented, incomplete data • Pulling together data from traditional and cloud data sources, and figuring out how to enrich it is extremely difficult. Requires a team of specialists Creating E2E BI solutions requires multiple BI tools. This requires specific knowledge of each of the tools and complex integration to build and maintain an E2E BI solution. Business data has no structural or semantic consistency  Different applications, departments, and analysts define data in different ways, which makes data exploration, and reuse of data and apps extremely challenging. Complex system integration Traditional BI solutions span multiple applications and services. Sharing data across systems requires each system to understand the location, structure and meaning of the data.

  11. Demo A deeper look at dataflows

  12. Power BI Dataflows: Bigger Picture

  13. Recap Reports & dashboards • Datasets • Dataflows • Storage

  14. But what if… …we want to leverage the data created by the dataflow in applications or services outside of Power BI? Reports & dashboards • Datasets • Dataflows • Storage

  15. Data + AI professionals can use the full power of the Azure Data Platform  Reports & dashboards Azure SQL DW Azure Data Factory Azure Databricks Azure ML Datasets Dataflows • Azure Data Lake Storage Gen2 CDM folder CDM folder CDM folder Data scientists Data engineers Low to high code Business analysts Low/no code

  16. But what if… …we want to leverage the data created by the dataflow in applications or services outside of Power BI? …or to provide an easy way to consume analytical data created outside of Power BI, in Power BI? Reports & dashboards • Datasets • Dataflows • Storage

  17. Deliver ready-made insights to Power BI users from Azure Dynamics 365 for Finance & Operations Self service customizations in Power BI Azure SQL DW Azure Data Factory Azure Databricks Azure ML • Dynamics 365 data • Dataflow • Azure Data Lake Storage Gen2 CDM folder

  18. But what if… …we want to leverage the data created by the dataflow in applications or services outside of Power BI? …or to provide an easy way to consume analytical data created outside of Power BI, in Power BI? …or to eliminate the complexity of data prep orchestration? Reports & dashboards • Datasets • Dataflows • Storage

  19. Power BI Dataflows are like Excel The difficult part of data preparation is usually not the individual job, package, or query – it is ensuring all of the jobs, packages, and queries run as a logical and reliable system Each Dataflow Entity has a formula The Power BI Dataflow calculation engine understands the relationships between all entities Update one, the rest update automatically and consistently – just like Excel

  20. Power BI Dataflows are like Excel Sources 20 Ingest from Dynamics Sales 22 entities Clean and enrich sales data 10 entities 8 CRM – Production Dynamics 365 10 Final Business View 11 entities 4 1 1 Product Telemetry in Azure 5 entities Add Telemetry Customer Attributes 6 entities IoT Signal Azure Data Lake Storage 4 1 Azure Analysis Services Sales/Telemetry Reference Data Dataflow

  21. Business Applications Communities Learn • Connect • Share • Inspire Join the Microsoft Business Applications Communities where you can connect with peers and experts. Get answers to complex questions, learn from engaging discussions, read informative blogs, view webinars, and find product use examples in galleries. https://community.dynamics.com https://community.powerapps.com https://community.powerbi.com https://community.flow.microsoft.com Benefits Engagement Recognition Join for free Access tips, answers, and shared knowledge from experts Expand your network by engaging with peers Need help? Ask questions and join in on business or technical discussions in the forums Share your expertise by hosting a blog or syndicating your existing blog Earn badges for participation and engagement Become a Community Star and earn appreciation from peers

  22. Please evaluate this sessionYour feedback is important to us! Please evaluate this session through MyEvaluations on the mobile appor website. Download the app:https://aka.ms/ignite.mobileApp Go to the website: https://myignite.techcommunity.microsoft.com/evaluations

More Related