{"id":2958,"date":"2012-11-13T08:30:00","date_gmt":"2012-11-13T07:30:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/"},"modified":"2012-11-13T08:30:00","modified_gmt":"2012-11-13T07:30:00","slug":"office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/","title":{"rendered":"Office 2013 and SQL Server 2012: an integrated, powerful BI solution"},"content":{"rendered":"<p>I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"office2013.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/office2013.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg\" alt=\"\" \/><\/a><\/p>\n<h3>First, what are PowerPivot and Power View?<\/h3>\n<p>PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks.<br \/>\nMore information <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ee210644.aspx\">here<\/a>.<br \/>\nPower View is a feature of SQL Server 2012 Reporting Services Add-in for an interactive data exploration, visualization, and presentation experience.<br \/>\nMore information <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/hh213579.aspx\">here.<\/a><\/p>\n<h3>Office 2013, a native Business Intelligence tool<\/h3>\n<p>Don&#8217;t download additional add-ons anymore, with Office 2013 these 2 Business Intelligence add-ons are directly present in the Office edition.<br \/>\nFor the license, no problem, it\u2019s included in the Office price!<br \/>\nTo see all new features in Office 2013, go to this <a href=\"http:\/\/msdn.microsoft.com\/en-us\/office\/fp142390.aspx\">web site<\/a>.<\/p>\n<h3>Excel 2013 configuration<\/h3>\n<p>The first thing we can see are the new Office icons with Outlook in blue (before, it was yellow).<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"office20132.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/office20132.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office20132.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Now, run the Excel 2013 Preview.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl2013.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl2013.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl2013.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Select a blank workbook, then go to the FILE tab.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20132.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20132.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20132.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Click on Options.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20133.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20133.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20133.jpg\" alt=\"\" \/><\/a><\/p>\n<p>In Add-Ins, you can see the 2 cCom Add-Ins (PowerPivot and Power View). This is just to verify that they are installed.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20134.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20134.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20134.jpg\" alt=\"\" \/><\/a><\/p>\n<p>HOHOHO! I was talking about Add-on in my introduction and now about Add-in&#8230;<\/p>\n<p>Do you see the difference? \ud83d\ude2f<\/p>\n<p>No! Ok, I explain it to you:<\/p>\n<ul>\n<li>Before Office 2013 &#8211;&gt; Separated installation\u00a0 &#8211;&gt; Add-On term is used<\/li>\n<li>Since Office 2013\u00a0\u00a0 &#8211;&gt; Included in Office setup &#8211;&gt; Add-In term is used<\/li>\n<\/ul>\n<h3><\/h3>\n<h3>Power View Reports in Excel 2013<\/h3>\n<p>Go to INSERT tab and you can see two sections:<\/p>\n<ul>\n<li>PowerPivot with<strong> PivotTable<\/strong> and <strong>Recommended PivotTables<\/strong><\/li>\n<li>Power View with <strong>Power View Reports<\/strong><\/li>\n<\/ul>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20135.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20135.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20135.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Click on Power View Reports.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20136.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20136.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20136.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Enable the add-in.<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20137.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20137.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20137.jpg\" alt=\"\" \/><\/a>Continue and wait&#8230;<a title=\"cafe.png\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/cafe.png\"><img decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_cafe.png\" alt=\"\" \/><\/a><\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20138.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20138.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20138.jpg\" alt=\"\" \/><\/a><\/p>\n<p>And Oops, a warning is displayed!<\/p>\n<p><a class=\"easyblog-thumb-preview\" title=\"Excerl20139.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl20139.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl20139.jpg\" alt=\"\" \/><\/a><\/p>\n<p>Indeed, Silverlight is a requirement for PowerView, so you have to install it.<span class=\"hps\"><br \/>\n<\/span><\/p>\n<p><span class=\"hps\"><a class=\"easyblog-thumb-preview\" title=\"Excerl201310.jpg\" href=\"http:\/\/dbi-services.com\/blog\/images\/easyblog_images\/88\/Excerl201310.jpg\"><img decoding=\"async\" style=\"margin-left: auto;margin-right: auto\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_Excerl201310.jpg\" alt=\"\" \/><\/a><\/span><\/p>\n<p>Now, we can unleash our creativity for our reports.<\/p>\n<h3>Conclusion<\/h3>\n<p>I&#8217;m very impressed with the easy integration of SQL BI in Office. I hope that this short article gives you the desire to try it as well, go further and create great reports.<\/p>\n<p>Your boss will be impressed if you use these news features from Microsoft Office&#8230;:-D<\/p>\n<p><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\"><span class=\"hps\">\u00a0<\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are PowerPivot and Power View? PowerPivot is an add-on to Excel which is used for adding and integrating large amounts [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":2959,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[294],"tags":[210,49,264,51,54],"type_dbi":[],"class_list":["post-2958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","tag-business-intelligence","tag-microsoft","tag-reporting-services","tag-sql-server","tag-sql-server-2012"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Office 2013 and SQL Server 2012: an integrated, powerful BI solution - dbi Blog<\/title>\n<meta name=\"description\" content=\"I have recently read that PowerPivot and Power View were natively in Office 2013 and especially in Excel 2013. I found this very fun and I go to install the Preview of Office 2013!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Office 2013 and SQL Server 2012: an integrated, powerful BI solution\" \/>\n<meta property=\"og:description\" content=\"I have recently read that PowerPivot and Power View were natively in Office 2013 and especially in Excel 2013. I found this very fun and I go to install the Preview of Office 2013!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-13T07:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"490\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"Office 2013 and SQL Server 2012: an integrated, powerful BI solution\",\"datePublished\":\"2012-11-13T07:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\"},\"wordCount\":370,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg\",\"keywords\":[\"Business Intelligence\",\"Microsoft\",\"Reporting services\",\"SQL Server\",\"SQL Server 2012\"],\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\",\"name\":\"Office 2013 and SQL Server 2012: an integrated, powerful BI solution - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg\",\"datePublished\":\"2012-11-13T07:30:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"I have recently read that PowerPivot and Power View were natively in Office 2013 and especially in Excel 2013. I found this very fun and I go to install the Preview of Office 2013!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg\",\"width\":490,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Office 2013 and SQL Server 2012: an integrated, powerful BI solution\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Office 2013 and SQL Server 2012: an integrated, powerful BI solution - dbi Blog","description":"I have recently read that PowerPivot and Power View were natively in Office 2013 and especially in Excel 2013. I found this very fun and I go to install the Preview of Office 2013!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/","og_locale":"en_US","og_type":"article","og_title":"Office 2013 and SQL Server 2012: an integrated, powerful BI solution","og_description":"I have recently read that PowerPivot and Power View were natively in Office 2013 and especially in Excel 2013. I found this very fun and I go to install the Preview of Office 2013!","og_url":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/","og_site_name":"dbi Blog","article_published_time":"2012-11-13T07:30:00+00:00","og_image":[{"width":490,"height":400,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"Office 2013 and SQL Server 2012: an integrated, powerful BI solution","datePublished":"2012-11-13T07:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/"},"wordCount":370,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg","keywords":["Business Intelligence","Microsoft","Reporting services","SQL Server","SQL Server 2012"],"articleSection":["Business Intelligence"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/","url":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/","name":"Office 2013 and SQL Server 2012: an integrated, powerful BI solution - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg","datePublished":"2012-11-13T07:30:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"I have recently read that PowerPivot and Power View were natively in Office 2013 and especially in Excel 2013. I found this very fun and I go to install the Preview of Office 2013!","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/b2ap3_thumbnail_office2013.jpg","width":490,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/office-2013-and-sql-server-2012-an-integrated-powerful-bi-solution\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Office 2013 and SQL Server 2012: an integrated, powerful BI solution"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2958"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2958\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2959"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2958"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2958"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2958"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}