Power BI Feature Agenda 1 2 3 4
Power BI Feature Agenda 1. 2. 3. 4. 5. 6. Jump Start Survey DEMO – Data streaming + Microsoft Flow Power of Power Platform – Power Apps, Microsoft Flow & Power BI Power Apps Demo ODI, CDM, CDS for Apps Data Democratization and Citizen Developer Power BI History Pradeesh Mathew Database Development Manager, Data Scan MCP, MCAD, MCSA, Power BI Certified
DEMO - Survey Feature Collect Save Push Stream Visualize Setup 1. Website to collect data 2. Azure SQL Server DB Table to store survey information 3. Create Power BI Stream Dataset in Power. BI. com 4. Create Report in Power BI Desktop 5. Publish to Power BI. com and Create Dashboard in Power. BI. com 6. Create Microsoft Flow to stream the data to Power. BI. com Dashboard 7. Test it pradeeshmathew. com
Microsoft Power Platform Feature One connected PLATFORM that empowers everyone to innovate • Build web and mobile apps fast and without limits • Gain insights from data regardless of where it lives • Enterprise-ready security and governance
Microsoft Power Platform Feature
Power Apps Power. Apps is a rapid application development platform which enable you to build apps in hours—not months— Feature that easily connect to data. It uses Excel-like expressions to add logic, and can be run on the web, i. OS, and Android devices.
Microsoft Flow provides a new way to automating business process and running them in reliable way in cloud. Feature It's a Saa. S services that helps you work smarter by automating workflow across your apps and services that business users rely on. Video : https: //us. flow. microsoft. com/en-us/
Power BI service Data sources Saa. S solutions e. g. Marketo, Salesforce, Git. Hub, Google analytics Content packs Natural language query Sharing & collaboration On-premises data e. g. Analysis Services Live dashboards Organizational content packs Corporate data sources or external data services Visualizations Azure services Azure SQL, Stream Analytics… Reports Excel files Workbook data / data models 01001 10101 Power BI Desktop files Data from files, databases, Azure, and other sources Datasets Data refresh Power BI Desktop Prepare Power BI REST APIs Explore Report Share
Evolution of Power Platform from Microsoft CRM Microsoft Dynamics 365, itself formerly known as “Microsoft CRM”, has been both folded into and extended Feature by the Power Platform. This distinction is tricky, because Microsoft has gradually migrated application development tools out of Dynamics and re-platformed them in Power. Apps.
DEMO Feature DEMO – POWER APPS
Business Challenges Feature Building application to digitally transform your business is challenging
Data Democratization Data democratization means that everybody has access to data and there are no gatekeepers Feature that create a bottleneck at the gateway to the data Data democratization is an evolution Data was “owned” by IT Departments. Business units such as marketing, business analysts and executives used the data to make business decisions, but they always had to go through the IT department to get the data. Need strong data governance in place to ensure the data is carefully managed
Citizen Developers Feature A Citizen developer is a user who creates new business applications for consumption by others using development and runtime environments sanctioned by corporate IT v They don’t know code, but they know the business v No-code is the next generation of app development, democratizing the app-building process and giving IT and the business a platform to collaborate
Who Propels Data Democratization Feature Tech innovation that propels data democratization Incredible amount of data that is created, BIG Data Tech innovation • Data Virtualization software • Data Federation Software – uses metadata to aggregate data from a variety of sources in a virtual database • Cloud Storage – Centralized location to store data • Self Service BI Applications – These applications make it easier for non-technical users to interpret data analysis
Open Data Initiative - ODI Feature Adobe, Microsoft, and SAP are partnering on the Open Data Initiative to enable data to be exchanged—and enriched—across systems, making it a renewable resource that flows into intelligent applications. https: //www. microsoft. com/en-us/open-data-initiative
Common Data Model - CDM What is the Common Data Model? – Meta Data System Feature The Common Data Model (CDM) is the shared data language used by business and analytical applications. It consists of a set of a standardized, extensible data schemas published by Microsoft and partners that enables consistency of data and its meaning across applications and business processes.
Common Data Model - CDM Feature
Common Data Model – CDM in Action Feature CDS for Apps : which supports Dynamics and Power. Apps Industries such as healthcare working closely with Microsoft to extend the CDM to their specific business concepts such as Patient, Care Plan through Industry Accelerators Power BI Dataflows allows you to ingest data into the CDM from a variety of sources such as Dynamics 365, Salesforce, Azure SQL Database, Excel or Share. Point. Azure Data Lake Storage Gen 2(preview) – CDM brings Semantic consistency to data with in the lake so that Applications and services can interoperate more easily when data is in the same format
Common Data Service for Apps- CDS Feature Today, the CDM is used within Common Data Service (CDS) for Apps, which supports Dynamics 365, Power. Apps, and the data-preparation capabilities in Power BI dataflows to create schematized files in Azure Data Lake. The CDM definitions are open and available to any service or application that wants to use them.
CDM Folders – Azure Data Lake Storage Gen 2 Feature CDM Folder - A folder in a data lake that conforms to specific, well-defined, and standardized metadata structures and self-describing data. These folders facilitate metadata discovery and interoperability between data producers and data consumers. Model. json - A metadata file in a folder in an Azure Data Lake Storage Gen 2 Preview instance that follows the CDM metadata format. If this file exists in such a folder, it's a CDM folder Data Producer - A service or app that creates data in CDM folders in Azure Data Lake Storage Gen 2 Preview Data Consumer -A service or app that consumes data in CDM folders in Azure Data Lake Storage Gen 2 Preview https: //docs. microsoft. com/en-us/common-data-model/data-lake
Power Apps Champion – Samit Saini Feature Samit Saini was a security guard at London Heathrow Airport who enjoyed tinkering with technology like Excel and VBA. When he got access to Power. Apps, he used it to digitize some of the paper-based processes at Heathrow such as providing translations for common questions asked by international passengers, performing customer experience audits, and supporting passengers with reduced mobility. Watch Samit’s Journey Heathrow has benefitted greatly from this level of substitution, having already saved more than 11, 000 sheets of paper, 850 hours of time, and $460, 000 in potential app costs. They cite that every 25, 000 sheets of paper saved equals about 3 trees. But as Samit puts it, "In Heathrow, we're not trying to save trees, we're trying to save the forest. " With this type of implementation, Power. Apps is reducing the consumption of resources of paper, time, and money. https: //powerapps. microsoft. com/en-us/blog/powerapps-champions
Power. History Feature BI 2006 2009 2010 2012 2013 2015 2017 Project In Memory Gemini Power Pivot Project Self-Service Cresent BI Power View Power BI for Query Power. BI. co Power m BI Premium Engine Add-in to Excel capabilities in Excel Part of Share Point Office 365 Service Embedded Power BI Report Server
Power BI Components and Products Overview Feature Components Languages Products Services M Power. BI. com Power BI Gateway DAX Power BI Desktop Power BI Visuals Market Place Power View Power BI Premium Machine Learning Power Map Power BI Embedded Cognitive Service Power Q & A Power BI Report Server Power Query Power Pivot Power BI Mobile Apps
CDS DEMO Feature CDS DEMO
The End Feature Feedback / Questions ?
- Slides: 24