2 Power BI and Its Components Introduction PDF [PDF]

Citation preview

Introduction to Power BI



Introduction to Power BI Evolution of BI



What is Power BI ?



Power BI Component List



Power Query



Power Pivot



Power View



Power Map



Q & A (Natural Language)



Power BI Desktop



Power BI Service



Data Management Gateway



Power BI Combined



Evolution of BI Traditional BI



Self-Service BI



Provision Analysis



Reports Dashboards & Scorecards



End Users



Data Staging ETL/Data Quality



Analysis Data Warehouse Cubes



Specialized Tools Spreadsheets



Existing Data LOB Applications Data Marts



Files



IT Pro



To But provision Rapidly ITbusiness hasHarvesting breaking been reports, Isisitbusy outpacing possible dashboards down existing keeping the to ITdata, balance barriers and up& with scorecards End cleaning Control of the Users Control growing it and are to with meet with demanding staging Agility? demand Self-Service EnditUser for …Agility BI… demand. BI!…



Power BI Component List Power Query Power Pivot



Power View Power Map Q & A (Natural Language) Power BI Desktop Data Management Gateway Power BI Service



What is BI, Power BI Get Data



Transform Data



Visualize Data



Power BI Desktop



Share Data



New



Power BI -Excel -Power Query -Power Pivot



-Power Pivot -Power Query



-Power View -Power Map -Power Pivot



-Office 365 -Share point -Excel



Old



Immersive insights Share



Report



Clean



Visualize



Mash-up



Explore



PowerQuery Find and connect data across a wide variety of sources prepare it for further analysis and modelling by tools such as Power Pivot and PowerView



Pull data into Power Pivot from new data sources, such as XML, Facebook, and File Folders as refreshable connections. You can share and manage queries as well as search data within your organization. Search Data, Many Sources, Share to Power BI Data Catalogue



Performe transformations, Extensible by code (lagunage M)



PowerPivot AddIn for Excel 2010 and 2013



Data Modelling



Allows you to relate tables with each other, Row limits larger than excel



Powerful DAX Formula language



Time intelligence (Parallel Periods, Fiscal Years)



Cross-join data, Calculated columns, Measures, KPI, Hierarchies, Semantic model



Power View Data Visualization (bar, pie, map, scatter, etc.)



Filters & Slicers HTML5 preview online Available on Mobile App Dynamic analysis from Power Pivot Data Model Bubble Chart with time line Animation



Power Map Microsoft Power Map for Excel is a three-dimensional (3-D) data visualization tool Overlay Data on Maps (Bing)



Create Tours, Videos, Export a video



3D Geographical visualization & navigation, Story-telling



Automatic geocoding



Q & A (Natural Language) Instantaneous natural language querying, Q&A interprets your question



Immediately serves up the correct answer on the fly Visualizations change dynamically as you modify the question Truly interactive experience with your data



Power BI Desktop Simple, Easy, Interactive and User Friendly



Power BI Desktop puts visual analytics at your fingertips



Drag-and-drop to place content exactly where you want it on the plan



Quickly discover patterns as you explore a single unified view



Is an elegant end-to-end solution for building analytics



It has all the capabilities to quickly connect, shape, visualize, and share data insights



Free downloadable version with some limitation



Power BI



Website / Portal



Simple, Easy, Interactive and User Friendly



Online service where you can quickly create dashboards, share reports, and directly connect to (and incorporate) all the data that’s important to you



Reach user experience and fast speed



Find and connect data across a wide variety of sources



Various Visualization types available in Power BI reports



Also know as The Power BI Service



How to use “The



Power”



Use online PowerBI.com Use Power BI Desktop



Use Mobile apps for the iPad, iPhone, and Windows tablets Integration of all experience Step 1 - Get data Step 2 - Explore your dataset



Data Management Gateway A Windows Service that is installed OnPrem Can Connects to SQL and provides an OData feed Clients will use a O365 Url to connect This redirects locally if on the local network Refresh the data from the Cloud Most Configuration done in the Power BI Portal Feeds can be searched via PowerQuery



Who will use Power BI? According to me – Everyone who work on any DATA Even old Microsoft blog which mentioned about “Data Stewards” is no more exist and as of now again its everyone



Why should everyone use it



What is Cost involved – Zero investment 100 % return



Data for Everyone



Power BI Experience What is Power BI Experience ?



Will this Power BI experience Change ? What are different types of Power BI Experience? Which one is Important Power BI Experience? How should I keep in touch with this change and different experience Which Power BI experience is right for me? The original Power BI experience



Power BI – Combined If you are not sure what you are going to use ! What to Do?



Use one easy and currently freely available to you All are having own pros and cons , surely less cons and more pros Microsoft working hard to make every experience perfect



Unified and Combine experience



What NEXT