{"id":3463,"date":"2012-05-24T10:37:00","date_gmt":"2012-05-24T17:37:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/"},"modified":"2024-01-22T22:49:42","modified_gmt":"2024-01-23T06:49:42","slug":"the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/","title":{"rendered":"The Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data"},"content":{"rendered":"

We\u2019ve crossed the halfway point in The Fantastic 12 of 2012: Behind the Scenes Blog Series and would be delighted to get your feedback on the series as well as <\/span>The Fantastic 12 of #SQL2012 Twitter Contest<\/span><\/a>. Please share your feedback in the comments section below or send us messages on either <\/span>Facebook<\/span><\/a> or <\/span>Twitter<\/span><\/a>. Your feedback will help us plan future blog series, so please let us know what you think if the series and what else you\u2019d like to see from us!<\/span><\/p>\n

In this week\u2019s episode, Ashvini Sharma, Lead Program Manager, talks about Analysis Services in SQL Server 2012 and the broad scope of a new feature their team developed. Ashvini covers how the team worked really hard to determine what this new feature should support given the timelines they had to work against. So what is this new feature is he\u2019s talking about? Watch the video below to find out as well as hear how the team blew off steam battling each other including trying to use helicopters!<\/span><\/p>\n

C<\/span>atch up on all the previous video episodes <\/span>here<\/span><\/a>. Don\u2019t forget the <\/span>Twitter Contest<\/span><\/a> that accompanies this series happens every Thursday at 10:30am PT, where you could win one of the new SQL Server T-Shirts of your choice!<\/p>\n

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

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

 <\/p>\n

7<\/span><\/strong> Credible, Consistent Data<\/span><\/p>\n

Deliver credible, consistent data to the right users across the organization with a complete end-to-end solution<\/span><\/p>\n

One Single Semantic Model<\/span><\/b><\/p>\n

    \n
  • BI Semantic Model:<\/b> A single, scalable model for Business Intelligence applications, from reporting and analysis to dashboards and scorecards, that helps provide a consistent view across heterogeneous data sources. IT and developers can create a single model to be consumed by front-end tools for their BI Applications across both tabular and multidimensional models.<\/span><\/span><\/li>\n<\/ul>\n

    Seamlessly Integrate Data<\/span><\/b><\/p>\n

      \n
    • Integration Services:<\/b> Help reduce time-to-solution for innovative, team-based data integration across data sources, including the cloud, by utilizing the industry-leading tools in Integration Services (SSIS) that help deliver credible, consistent data reliably and efficiently. New improvements include significant improvements in the user experience for dramatic efficiencies.<\/span><\/span><\/li>\n<\/ul>\n

      Cleanse Organizational Data<\/span><\/b><\/p>\n

        \n
      • Data Quality Services:<\/b> Help improve data quality by using organizational knowledge and 3rd party reference data providers, including cloud-based providers, by enabling data managers to reliably profile, cleanse, and match data \u2014 run as a standalone tool or leverage within SSIS.<\/span><\/span><\/li>\n<\/ul>\n

        Efficiently Manage Data<\/span><\/b><\/p>\n

          \n
        • Master Data Services:<\/strong> Help create, maintain, store, and access master data structures used for object mapping, reference data, metadata management with Master Data Services (MDS), while a new MDS Add-in for Excel makes it easy for end users to manage and maintain central data.<\/span><\/span><\/li>\n<\/ul>\n

          \u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

          We\u2019ve crossed the halfway point in The Fantastic 12 of 2012: Behind the Scenes Blog Series and would be delighted to get your feedback on the series as well as The Fantastic 12 of #SQL2012 Twitter Contest. Please share your feedback in the comments section below or send us messages on either Facebook or Twitter.<\/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-3463","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2012","content-type-thought-leadership","review-flag-7-1593580462-294","review-flag-conte-1593580322-142","review-flag-integ-1593580287-179","review-flag-lever-1593580264-545","review-flag-new-1593580247-437","review-flag-watch-1593580721-697"],"yoast_head":"\nThe Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data - 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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\" \/>\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 Credible, Consistent Data - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We\u2019ve crossed the halfway point in The Fantastic 12 of 2012: Behind the Scenes Blog Series and would be delighted to get your feedback on the series as well as The Fantastic 12 of #SQL2012 Twitter Contest. Please share your feedback in the comments section below or send us messages on either Facebook or Twitter.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\" \/>\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-24T17:37:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/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=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/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 Credible, Consistent Data\",\"datePublished\":\"2012-05-24T17:37:00+00:00\",\"dateModified\":\"2024-01-23T06:49:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\"},\"wordCount\":437,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\",\"name\":\"The Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2012-05-24T17:37:00+00:00\",\"dateModified\":\"2024-01-23T06:49:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/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 Credible, Consistent Data - 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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/","og_locale":"en_US","og_type":"article","og_title":"The Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data - Microsoft SQL Server Blog","og_description":"We\u2019ve crossed the halfway point in The Fantastic 12 of 2012: Behind the Scenes Blog Series and would be delighted to get your feedback on the series as well as The Fantastic 12 of #SQL2012 Twitter Contest. Please share your feedback in the comments section below or send us messages on either Facebook or Twitter.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2012-05-24T17:37:00+00:00","article_modified_time":"2024-01-23T06:49:42+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/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":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/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 Credible, Consistent Data","datePublished":"2012-05-24T17:37:00+00:00","dateModified":"2024-01-23T06:49:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/"},"wordCount":437,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/","name":"The Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2012-05-24T17:37:00+00:00","dateModified":"2024-01-23T06:49:42+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2012\/05\/24\/the-fantastic-12-of-2012-behind-the-scenes-of-credible-consistent-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"The Fantastic 12 of 2012: Behind the Scenes of Credible, Consistent Data"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=3463"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/3463\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=3463"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=3463"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=3463"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=3463"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=3463"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=3463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}