Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

SQL Server 2012: New Business Intelligence features

SQL Server 2012 has many new Business Intelligence (BI) features and enhancements.  Here are my top 12, in order of importance:

  1. Power View.  A fun, visual, and powerful drag-and-drop ad-hoc reporting tool.  It is a web-based end-user BI tool based on Silverlight.  See SQL Server 2012 (“Denali”): Power View (“Project Crescent”)
  2. Tabular Model.  A new data model that along with the multidimensional model fall under the single unified platform called Business Intelligence Semantic Model (BISM).  The tabular model uses xVelocity, DAX, and is built on your existing relational model, making it faster, easier to use, and quicker to develop than the multidimensional model.  See SQL Server 2012 (“Denali”): Details on the next version of SSAS
  3. Columnstore Indexes.  An xVelocity memory optimized columnstore index that groups and stores data for each column and then joins all the columns to complete the whole index. For some types of queries, the SQL Server query processor can take advantage of the columnstore layout to significantly improve query execution times.  Especially suited for data warehousing.  See SQL Server 2012 (“Denali”): Project Apollo/Columnstore Indexes
  4. Data Quality Services (DQS).  A brand-new product that enables you to build a knowledge base and use it to perform a variety of critical data quality tasks, including correction, enrichment, standardization, monitoring, and de-duplication of your data.  See Microsoft Data Quality Services in SQL Server 2012
  5. Integration Services (SSIS) enhancements.  Tons of new features, such as a new project deployment model, undo/redo, shared connection managers, project parameters, SSIS catalog with automatic logging and reporting, and version control.  See SQL Server 2012 (“Denali”): Details on the next version of SSIS
  6. SQL Server Data Tools (SSDT).  Its purpose is to provide a single development environment for all database-related project types by bringing BIDS (Business Intelligence Development Studio), “Data Dude” tools in Visual Studio 2010 Premium and Ultimate editions, and SSMS (SQL Server Management Studio) into the same IDE.  It is based on the Microsoft Visual Studio 2010 shell.  See SQL Server 2012 (“Denali”): SQL Server Data Tools (SSDT), codename ‘Juneau”
  7. Master Data Services enhancements.  New features include an improved web user interface, Excel add-in, integration with DQS, and entity-based staging.  See SQL Server 2012 (“Denali”): Master Data Services
  8. Business Intelligence Edition.  A brand-new SKU that includes all of the Standard editions capabilities, plus Power View, reporting and analytics, data-quality services and master-data services.  So you get all the BI-related features without having to purchase the Enterprise edition.  See Business Intelligence Edition
  9. PowerPivot enhancements.  New features include diagram view, KPI creation, hierarchies, perspectives, sort by other column.  See SQL Server 2012 (“Denali”): PowerPivot
  10. Reporting Services (SSRS) enhancements.  The new Data Alerts is like a subscription driven by changes in the source data,  Excel and Word rendering for 2010, and SharePoint Mode.  See SQL Server 2012 (“Denali”): Details on the next version of SSRS
  11. Analysis Services (SSAS) enhancements.  NUMA is now supported, allowing for more than 64 processors, support for SQL Server Extended Events, new profiler and trace events, improved processing time.  See SQL Server 2012: SSAS enhancements
  12. Table Partitioning enhancements.  Enhancements include support for 15,000 partitions, statistics generation footprint, and enhanced wizard options. See Introducing SQL Server 2012 Table Partitioning Improvements

More info:

My Top 5 BI Features in SQL Server 2012

SQL Server 2012 and Business Intelligence E-book

SQL Server 2012 Business Intelligence Innovations

What’s New for Business Intelligence in SQL Server 2012

What’s new in SQL Server 2012? Highlights of new Business Intelligence functionality in the latest release

Evolved BI

Video Business Intelligence and Data Visualization: Microsoft SQL Server 2012

Competitive Advantage Through BI Capabilities


Leave a comment on the original post [, opens in a new window]

Loading comments...