{"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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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\/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;&nbsp;<\/p>\n","protected":false},"author":15,"featured_media":2959,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[294],"tags":[49,264,51,54],"class_list":["post-2958","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","tag-microsoft","tag-reporting-services","tag-sql-server","tag-sql-server-2012"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.4 (Yoast SEO v28.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Office 2013 and SQL Server 2012: an integrated, powerful BI solution - dbi services | 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 services | Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\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\/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:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\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\\\/7980252d7d7a521e285e7c66114cf82a\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"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\\\/2022\\\/04\\\/b2ap3_thumbnail_office2013.jpg\",\"keywords\":[\"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 services | 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\\\/2022\\\/04\\\/b2ap3_thumbnail_office2013.jpg\",\"datePublished\":\"2012-11-13T07:30:00+00:00\",\"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\\\/2022\\\/04\\\/b2ap3_thumbnail_office2013.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\"},\"alternateName\":\"dbi Blog\",\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#organization\",\"name\":\"dbi services\",\"alternateName\":\"dbi\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/7980252d7d7a521e285e7c66114cf82a\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/STH_web-min-scaled.jpg\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.\",\"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 services | 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 services | Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","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\/2022\/04\/b2ap3_thumbnail_office2013.jpg","type":"image\/jpeg"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","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\/7980252d7d7a521e285e7c66114cf82a"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"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\/2022\/04\/b2ap3_thumbnail_office2013.jpg","keywords":["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 services | 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\/2022\/04\/b2ap3_thumbnail_office2013.jpg","datePublished":"2012-11-13T07:30:00+00:00","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\/2022\/04\/b2ap3_thumbnail_office2013.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/blog\/#organization"},"alternateName":"dbi Blog","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":"Organization","@id":"https:\/\/www.dbi-services.com\/blog\/#organization","name":"dbi services","alternateName":"dbi","url":"https:\/\/www.dbi-services.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialised in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7980252d7d7a521e285e7c66114cf82a","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/STH_web-min-scaled.jpg","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than 20 years of experience in Microsoft solutions, specializing in the installation, migration, best practices, and performance analysis of Microsoft SQL Server, as well as Microsoft Business Intelligence solutions (SharePoint, Office) and .NET development for the banking sector. A former Microsoft Most Valuable Professional (MVP) and early adopter of Microsoft Team System in France, he has authored several technical articles. He holds Microsoft Certified Solutions Associate (MCSA) and Expert (MCSE) for SQL Server, MCTS, MCITP for SQL Server 2008, and ITIL V3 Foundation certifications. His industry experience covers chemicals and pharma, banking, and financial services.","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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}