{"id":3473,"date":"2012-05-17T09:30:00","date_gmt":"2012-05-17T16:30:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/"},"modified":"2024-01-22T22:49:42","modified_gmt":"2024-01-23T06:49:42","slug":"the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi","status":"publish","type":"post","link":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/","title":{"rendered":"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI"},"content":{"rendered":"

We\u2019re back with a new episode of The Fantastic 12 of 2012: Behind the Scenes Blog Series, where we\u2019re providing unique insights from the SQL Server Engineering Team as they developed SQL Server 2012. <\/span>Be sure to catch the first four episodes <\/span>here<\/span><\/a>.<\/p>\n

In this new episode John Hancock, Principal Program Manager, provides some interesting insights behind a major design decision around the new modeling capabilities including Key Performance Indicators, Hierarchies, and Perspectives and determining where those new capabilities ought to go into SQL Server 2012. Should those capabilities go into the professional environment or is there another approach? Find out how the team addressed and solved this challenge in the episode below!<\/span><\/p>\n

Don\u2019t forget <\/span>The Fantastic 12 of #SQL2012 Twitter Contest<\/span><\/a> is happening every Thursday at 10:30am PT, where we\u2019re giving away the brand new SQL Server T-Shirts selected by the <\/span>SQL Family<\/span><\/a>.<\/p>\n

<\/span><\/p>\n

\n
<\/div>\n<\/div>\n

 <\/p>\n

6<\/span><\/strong> Managed Self-Service BI<\/span><\/p>\n

Gain insight and oversight<\/span><\/b><\/p>\n

    \n
  • PowerPivot for SharePoint:<\/b> Balance the need to monitor, manage, and govern the data and analytics end users create with IT dashboards and controls that help IT monitor end user activity, data source usage, and gather performance metrics from servers.<\/span><\/span><\/li>\n<\/ul>\n

    Enable IT Efficiency<\/span><\/b><\/p>\n

      \n
    • End user created, IT managed:<\/b> SQL Server 2012 bridges the gap between end user created BI applications and IT managed corporate solutions by providing the ability to import PowerPivot models into Analysis Services so that they can be professionally managed and transformed into corporate grade solutions.<\/span><\/span><\/li>\n
    • Ease of administration through SharePoint:<\/b> Enable end user alerting from reports published to SharePoint and benefit from the ease of consolidated management through the SharePoint 2010 Central Administration.<\/span><\/span><\/li>\n
    • SQL Azure Reporting:<\/b> Extend rich user insights to even more people with SQL Azure Reporting that removes the need for deploying and maintaining a reporting infrastructure.<\/span><\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

      We\u2019re back with a new episode of The Fantastic 12 of 2012: Behind the Scenes Blog Series, where we\u2019re providing unique insights from the SQL Server Engineering Team as they developed SQL Server 2012. Be sure to catch the first four episodes here.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2400],"content-type":[2445],"topic":[],"coauthors":[2487],"class_list":["post-3473","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2012","content-type-thought-leadership","review-flag-6-1593580457-144","review-flag-conte-1593580322-142","review-flag-new-1593580247-437"],"yoast_head":"\nThe Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We\u2019re back with a new episode of The Fantastic 12 of 2012: Behind the Scenes Blog Series, where we\u2019re providing unique insights from the SQL Server Engineering Team as they developed SQL Server 2012. Be sure to catch the first four episodes here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2012-05-17T16:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\"},\"author\":[{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI\",\"datePublished\":\"2012-05-17T16:30:00+00:00\",\"dateModified\":\"2024-01-23T06:49:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\"},\"wordCount\":301,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\",\"url\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\",\"name\":\"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-05-17T16:30:00+00:00\",\"dateModified\":\"2024-01-23T06:49:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI - Microsoft SQL Server Blog","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:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/","og_locale":"en_US","og_type":"article","og_title":"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI - Microsoft SQL Server Blog","og_description":"We\u2019re back with a new episode of The Fantastic 12 of 2012: Behind the Scenes Blog Series, where we\u2019re providing unique insights from the SQL Server Engineering Team as they developed SQL Server 2012. Be sure to catch the first four episodes here.","og_url":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-05-17T16:30:00+00:00","article_modified_time":"2024-01-23T06:49:42+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#article","isPartOf":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/"},"author":[{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI","datePublished":"2012-05-17T16:30:00+00:00","dateModified":"2024-01-23T06:49:42+00:00","mainEntityOfPage":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/"},"wordCount":301,"commentCount":0,"publisher":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/","url":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/","name":"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-05-17T16:30:00+00:00","dateModified":"2024-01-23T06:49:42+00:00","breadcrumb":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/2012\/05\/17\/the-fantastic-12-of-2012-behind-the-scenes-of-managed-self-service-bi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"The Fantastic 12 of 2012: Behind the Scenes of Managed Self-Service BI"}]},{"@type":"WebSite","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#website","url":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3473"}],"version-history":[{"count":0,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3473\/revisions"}],"wp:attachment":[{"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3473"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3473"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3473"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3473"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3473"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/newed.any0.dpdns.org\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}