Introduction to Power BI Devin Knight dknightpragmaticworks com

Introduction to Power BI Devin Knight dknight@pragmaticworks. com @knight_devin INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

About Devin • • • Training Director SQL Server MVP Author of 5 books Runs JSSUG User Group Blogs at BIDN. com Twitter: @knight_devin DKnight@pragmaticworks. com INTELLIGENT DATA SOLUTIONS • Popup books about • Will Work for cupcakes maintaining a healthy relationship with your miniature donkeys. • And supporting cult being investigated by the government. • Blogs mainly consist of a collection of internet cat pictures WWW. PRAGMATICWORKS. COM

Agenda What is Power BI Tour of each of the Power BI tools Power BI Pricing INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Power Map BI Overview Power Query Power BI Sites Allows you to extract and transform data from extraneous data sources Share, view and interact with reports in a collaborative site Power Pivot Power BI Q&A Creates data models using mash ups Provides that ability to interrogate your data using natural language queries extraneous data sources Power View Data visualization tool that enables you to quickly gain business insight into your data Power BI App (Mobile BI) Mobile app that allows you to view reports while on the go Power Map 3 -D Mapping Data Visualization Tool INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Self-Service BI Lifecycle Data Extraction INTELLIGENT DATA SOLUTIONS Data Modeling Data Presentation WWW. PRAGMATICWORKS. COM

Data Extraction Data Modeling Databases Power Pivot Files Power. Flat. Query Power Pivot Reporting Services Cloud Relationships Tables Excel Power. Charts View Apps For Office Power Map Hierarchies Calculations Power Query Share. Point Lists Data Presentation Key Performance Indicators Power. Tables View Power. Charts Map Internet Maps Active Directory Exporting Facebook Hadoop INTELLIGENT DATA SOLUTIONS Power Map 3 -D Maps WWW. PRAGMATICWORKS. COM

Power Query Discover INTELLIGENT DATA SOLUTIONS Combine Refine WWW. PRAGMATICWORKS. COM

Demos Discover -> Consume -> Visualize Data Wrangling Putting it all together INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Power Pivot Performance Uses In-Memory Technologies Providing Unmatched Analytical Performance Short Development Cycles Quick and Easy to Create and End to End Solution End User Capable Familiar Tools with Enhanced Capabilities Millions Excel Users Worldwide INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Demos Creating a Data Model Adding Relationships Designing Hierarchies INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Power View Reporting Services Report Builder Power View • Development in Visual Studio • Use by Developers • Highly Customizable • Intended for Power Users • Click-Once Application • Office Look and Feel • Designed for End Users • Silverlight Based • Data Exploration Tool INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Demos Creating Charts in Power View INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Power Map Overview Power Map Features 3 -D Data Visualization Tool for Excel 2013 Plots Geography Data Visually Analyze Data on a 3 -D globe Using Bing Create Visual Tours to Share with Others INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Demos Linking Geographical Data to Power Mapping Data Across Time Creating a Power Map Tour INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Power BI Sites Collaboration Deploy Excel workbooks to share with others Power BI Q&A built in to Power BI site INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM

Power BI Q&A User Experience Uses Natural Query Language to return results Making it Works on Power Pivot models deployed to a Power BI site Use Synonyms in Power Pivot to tune Natural Queries INTELLIGENT DATA SOLUTIONS WWW. PRAGMATICWORKS. COM