1 / 47

Sofia Event Center 21-22 ноември 2013 г.

Sofia Event Center 21-22 ноември 2013 г. Faster Insights from Any Data. Маги Наумова/ Боряна Петрова. About me. Certificates MVP – Excel MCT MCTIP MOS – Master Focuses on education and mentoring Contacts boriana.petrova@itraining.bg 08862680055 @ borianapetrova.

zarola
Download Presentation

Sofia Event Center 21-22 ноември 2013 г.

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. Sofia Event Center 21-22 ноември 2013 г. Faster Insights from Any Data Маги Наумова/ Боряна Петрова

  2. About me • Certificates • MVP – Excel • MCT • MCTIP • MOS – Master • Focuses on education and mentoring • Contacts boriana.petrova@itraining.bg 08862680055 @borianapetrova

  3. Faster Insights from Any Data Easy access to data, big & small Search, access, and shape internal and external data, and combine with unstructured data Powerful insights with familiar tools Speed up analysis and time to insight with the familiarity of Excel in Office and Office 365 and access via mobile devices Complete BI platform Scale your BI models and enrich and secure your data with a complete platform spanning cloud and on-premises

  4. Easy Access to Data, Big and Small Key features Search, access and shape Simplify access to public and corporate data Easily preview, shape, and format your data • Project code name “Data Explorer” • Windows Azure Marketplace • Windows Azure HDInsight Service & Microsoft HDInsight Server (preview) • 100% Apache • Parallel Data Warehouse with Polybase Combine with unstructured Combine and refine data across multiple sources Gain insight across relational, unstructured, and semi-structured data Easily manage and query Common management of structured and unstructured data Query across relational DB and Hadoop with single T-SQL Query

  5. Microsoft Power BI for Excel and 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. Target Audiences Get Data Explore Analyze Insights Personalize Tell a Story Information Worker Authors the visual data environment Decision Maker Consumes the data visually to create her own insight & tell her story

  7. Power Query

  8. Power Query

  9. Powerful Self-Service BI with Excel 2013 Power Query – formerly project “Data Explorer” Discover & Combine Search and access internal & external data Clean, transform, and shape data Merge and combine data from multiple sources Analyze & Model Lightning fast analytics with in-memory technology Model relationships, custom measures, hierarchies, and KPI’s Visualize & Explore Bring your data to life with interactive visualization Explore data in new ways to discover hidden insights

  10. Power Query Enable self-service data discovery, query, transformation and mashup experiences for Information Workers, via Excel and PowerPivot Discovery and connectivity to a wide range of data sources, spanning volume as well as variety of data. Highly interactive and intuitive experience for rapidly and iteratively building queries over any data source, any size. Consistency of experience, and parity of query capabilities over all data sources. Joins across different data sources; ability to create custom views over data that can then be shared with team/department.

  11. Excel add-in to enhance self-service BI Identify and import external data: Relational dB Excel Text XML Odata Web pages Hadoop HDFS Discover relevant data by using search Combine and transform multiple data sources Power Query Discover, combine, and refine Big Data, small data, and any data with Data Explorer for Excel.

  12. S Data Sources Azure SQL Database Azure HDInsight Windows Azure Marketplace Windows Active Directory

  13. PowerPivot

  14. PowerPivot

  15. Powerful Self-Service BI with Excel 2013 PowerPivot Discover & Combine Search and find internal & external data Clean, transform, and shape data Merge and combine data from multiple sources Analyze & Model Lightning fast analytics with in-memory technology Model relationships, custom measures, hierarchies, and KPI’s Visualize & Explore Bring your data to life with interactive visualization Explore data in new ways to discover hidden insights

  16. Power Map

  17. Power Map

  18. Powerful Self-Service BI with Excel 2013 Power Map – formerly project “Geoflow” Discover & Combine Search and find internal & external data Clean, transform, and shape data Merge and combine data from multiple sources Analyze & Model Lightning fast analytics with xVelocity in-memory technology Model relationships, custom measures, hierarchies, and KPI’s Visualize & Explore Bring your data to life with interactive visualization Explore data in new ways to discover hidden insights

  19. What Is Power Map? Power Map for Microsoft Excel enables information workers to discover and share new insights from geographical and temporal data through three-dimensional storytelling.

  20. Power Map: Steps to 3D insights

  21. Map Data • Geospatial and temporal data in Excel • Calculated Fields and Hidden Columns • Geo-code and Themed maps with Bing • Visualize multiple layers at once • 3D Columns, Bubble/Pies, Heat Maps • Regions for geopolitical boundaries

  22. Discover Insights • Play your data over time • Make direct comparisons in 2D charts • Flat 2D map for comparison of 3D columns • Annotate insights with metadata • Can add images to annotations. • Capture “Scenes” like slides in a show

  23. Share Stories • Weave scenes with cinematic effects • Interact and resume during presentation • Share broadly within the workbook • Export to Video for Viral!

  24. Map data, discover insight, and share stories Power MapExcel Add-in to Enhance Data Visualization

  25. Power BI Site

  26. Power BI Site

  27. Collaborate and Stay Connected with Office 365 Power BI Site in Office 365 Share Data & Insights Easily setup powerful BI sites Share live reports with data refresh from on-prem sources Manage and share data sets and monitor usage Ask Questions & Get Answers Ask questions in the natural language speech bubble Get back answers as the system generates data visualizations Q&A Connect from Anywhere View Power View reports on any device with HTML5 support Discover and explore all your favorite reports with the mobile BI app

  28. Power View

  29. Power View

  30. Powerful Self-Service BI with Excel 2013 Power View Discover & Combine Search and find internal & external data Clean, transform, and shape data Merge and combine data from multiple sources Analyze & Model Lightning fast analytics with xVelocity in-memory technology Model relationships, custom measures, hierarchies, and KPI’s Visualize & Explore Bring your data to life with interactive visualization Explore data in new ways to uncover hidden insights

  31. Introducing Power View • Power View is an interactive data exploration, visualization, and presentation experience • Highly visual design experience • Rich meta-driven interactivity • Presentation-ready at all times • It delivers intuitive ad-hoc reporting for business users • Reports can be based on tabular data models, including PowerPivot data models • It is now also available in Excel 2013, and with new features: • Maps • Pie charts • Hierarchies • KPIs • Drill down/Drill up • Report styles, themes and text resizing • Backgrounds with images • Hyperlinks • Printing

  32. Power View for Multidimensional Models • Power View on Analysis Services via BISM • Native support for DAX in Analysis Services • Better flexibility: Choice of DAX on Tabular or Multidimensional (cubes)

  33. BI Semantic Model: Architecture Reporting Services (Power View) Third-party applications SharePoint Insights Excel PowerPivot BI Semantic Model Data model Tabular Multidimensional Business logic MDX DAX Queries MDX/DAX MDX/DAX Direct Query Data access VertiPaq ROLAP MOLAP Databases Files OData Feeds LOB Applications Cloud Services

  34. Hands on Lab

  35. Connection Instructions • Plug the network cable • Set a static IP : 10.10.10.10 • Set subnet mask: 255.0.0.0 • Lunch remote desktop and connect to server: 10.10.10.1 • Login as Contoso\LabUser, pass@word1

  36. HDInsight

  37. HDInsight

  38. Key Trends Device Explosion Social Networks Cheap Storage $100 gets you 3million times more storage in 30 years) >5.5 billion (70+% of global population) >2Billion users Ubiquitous Connection Sensor Networks Inexpensive Computing Web traffic 2010130 Exabyte (10 E18) 20151.6 ZettaByte (10 E21) >10 Billion 1980 10 MIPS/$ 200510M MIPS/$

  39. Modern Data Warehousing Operational Data New user registry New purchase New product Data Warehouse Logs Logs Raw Data “Store it All” Cluster How much do views for certain products increase when our TV ads run? Raw Data “Store it All” Cluster

  40. Hadoop Distributed Architecture Task tracker Task tracker MapReduce Layer Job tracker Name node HDFS Layer Data node Data node Reference: http://en.wikipedia.org/wiki/File:Hadoop_1.png

  41. MapReduce: Move Code to the Data Server Server Files Server Server

  42. So How Does It Work? Second, take the processing to the data Runtime // Map Reduce function in JavaScript varmap = function (key, value, context) { var words = value.split(/[^a-zA-Z]/); for (var i = 0; i < words.length; i++) { if (words[i] !== "") context.write(words[i].toLowerCase(), 1);} }}; varreduce = function (key, values, context) { var sum = 0; while (values.hasNext()) { sum += parseInt(values.next()); } context.write(key, sum); }; Code Server Server Server Server

  43. HDInsight and Hadoop Ecosystem Legend Red = Core Hadoop Blue = Data processing Gray= Microsoft integration points and value adds Orange = Data Movement Green = Packages JavaScript C#, F#, .NET Data Integration ( ODBC / SQOOP/ REST) Stats processing (RHadoop) Machine Learning (Mahout) Relational (SQL Server) Pipeline / workflow (Oozie) Graph (Pegasus) PDW Polybase Metadata (HCatalog) Event Driven Processing Query (Hive) Scripting (Pig) NoSQL Database (HBase) Event Pipeline (Flume) Distributed Processing (MapReduce) Business Intelligence (Excel, Power View, SSAS) Distributed Storage (HDFS) Active Directory (Security) Monitoring & Deployment (System Center) World's Data (Azure Data Marketplace) Azure Storage Vault (ASV)

  44. Microsoft Hadoop VisionInsights to all users by activating new types of data Differentiation Insights Integrate with Microsoft business intelligence Choice of deployment on Windows Server + Windows Azure Integrate with Windows components (Active Directory, Microsoft System Center) Enterprise-ready Easy installation and configuration of Hadoop on Windows Simplified programming with Microsoft .NET and JavaScript integration Integrate with SQL Server Data Warehousing Broader access Contributions proposed back to community distribution

  45. Data Insights

  46. Complete and Consistent Data Platform SQL Server 2014 Mission-critical performance Faster insights from any data Platform for hybrid cloud Customer Service Provider Windows Azure 1 CONSISTENTPLATFORM Development Management Data Identity Virtualization

  47. Споделете вашата обратна връзка за тази сесия и за цялостната организация на конференцията http://aka.ms/incharge и участвайте в томболата за HTC 8S и други награди!

More Related