SQL-Based Information Management Solutions

The business intelligence market is booming as companies are looking for ways to become more competitive in a tough economy. The number one business intelligence vendor, Microsoft, outpaced the Business Intelligence software market with a 23% growth in 2010. SQL Server is the leader in unit market shares. Many other partners already realized this opportunity. Mare sure you get your fair share of the 4 billion dollar SQL Server opportunity and work with the leader.

Microsoft provides a complete BI solution for all types of customer need and has three layers:

  • First of all, Microsoft BI works with and sits on a heterogeneous stack, regardless of the customer’s current system. It is NOT just about SQL Server but also about getting insights from other data sources, such as Oracle, SAP, Line-of-Business systems and a wide array of structured, unstructured, internal and external data sources.
  • Second,  a set of services like Analysis Services, Data Quality Services sit on the data sources and provide Enterprise Information Management EIM and BI Platform services based on the customers’ needs.
  • Third,  Microsoft business intelligence provides tools for end users, such as Excel Workbooks,  PowerPivot Solutions, SharePoint Dashboards, and Scorecards. These capabilities are delivered through the productivity and collaboration tools that customers are most familiar with and in most cases already have and use—Office and SharePoint.

So the simplified view of what is Microsoft BI boils down to the capabilities that you see on the left hand side and the products that deliver these capabilities on the right hand side.

Let’s take a closer look at the new and enhanced Enterprise Information Management and BI Platform services SQL Server 2012 provides. With SSAS, analysts can gain insights through millions of rows of data quickly via PowerPivot for Microsoft Excel. The new DQS allows profiling, cleansing, and matching company data to ensure that it is suitable for business usage. SSIS enables data integration from both Microsoft and non-Microsoft sources. SSRS enables the new Power View for rich visualization and helps customers recognize business risks with alerts about specific changes within a report. MDS democratizes data management and reduces the dependency on IT. The new BI Semantic Model provides a consistent view of reports and dashboards from different data sources.

SQL Server 2012 extends organizations beyond the database with a cloud-ready information platform that delivers mission critical confidence, breakthrough insight, and cloud on your terms.

SQL Server’s BI capabilities can be grouped into four major benefits for customers. It helps unlock new insights with rapid data exploration and managed self-service BI across the organization while providing tools for IT to deliver credible, consistent data, and large scale analytic and data warehouse capabilities.

Breakthrough Insight is about delivering new insight to all users through familiar and collaborative, self-service tools. This is about managing and protecting data without hampering creativity. And this is about harnessing the power of all data to drive innovation and identify new business opportunities, and providing access to any data of any size, across relational and non-relational sources. Non-relational or in other words unstructured data consist of new, complex data types, such as e-mail content, videos, images, graphics, social media messages, and public data to differentiate it from structured or relational data which is data stored in traditional databases in an organized fashion.

Today, IT faces new challenges, there is an entirely new scale and scope to the kinds of data users are trying to gain insights from across both relational and non-relational sources.

This growth is coming from:

  • Transactional growth in businesses.
  • Non-relational data growing at an exponential rate vs. the traditional relational data growing at a more linear rate .
  • Growth in online business.

There is a lot of discussion about “Big Data” in the world today, and how technologies such as map reduce have emerged as a method to process lots of unstructured data in a distributed storage system.

Ultimately what we see here is an opportunity to activate data that lives outside the traditional data platform.   And consistent with our strategy of supporting all types of data and the methods to process them, we announced a Big Data strategy that embraces Hadoop for activating this ambient data from sensors, clickstream, social media, location-based or other data.

 

 

There is a lot of discussion about “Big Data” in the world today.  So what do people mean?   Is it about scale and large volumes?  Not exclusively.  Is it about processing unstructured data like web logs?  No not exclusively.    Is it about a specific computational pattern or method that gives you real-time insight? No, not exclusively. These are all things SQL Server supports today.

Often what people are talking about are new specific computational patterns including map reduce, which emerged as a method to process lots of unstructured data in a distributed storage system.  Now, this doesn’t have a monopoly on “Volume”, “Variety” or “Velocity” but does provide some unique capabilities.

Microsoft has a unique perspective on Big Data – We are the only major Data Platform vendor who is also in the 100PB club of Cloud providers. We have invested heavily in building and running a big data platform to fuel and drive our business. Microsoft is managing 100’s of Petabytes of data across our online properties.  Adding 8 PBs per month, running 20k jobs per day to run the business.

We are also integrating SQL Server with Big Data and completing the solution by enabling developers to build applications on this data; and connect it through to our end users with our BI tools. So we have a pretty good understanding of how to build and operate one of these infrastructures and connect it thru to developers and end users.

Ultimately what we see here is an opportunity to activate data that has lived outside the traditional data platform.   And consistent with our strategy, deliver immersive insights over all data to all users in the tools they are familiar with.

Last fall we announced a Big Data strategy that embraces Hadoop for activating this ambient data being born outside the traditional data platform.  Hadoop is the open source implementation of MapReduce parallel computation engine and environment, and it’s used (quite widely now) in the processing of streams of data that go well beyond even the largest enterprise data sets in size. Whether it’s sensor, clickstream, social media, location-based or other data that is generated and collected in large gobs, Hadoop is often on the scene in the service of processing and analyzing it.

Here’s Microsoft’s Big Data strategy:

Enterprise Ready – delivering an enterprise class implementation or distribution of Hadoop for Windows Server and Windows Azure, integrated with SQL Server 2012, Active Directory and System Center makes it dramatically easier, efficient and cost effective for your organization to capitalize on the opportunity Big Data can bring to your business.

 

And with the Hadoop distribution for Windows Azure, customers can instantly begin taking advantage of the benefits of Big Data without capital infrastructure or operational costs.

 

Connected with the World’s Data – Microsoft’s Big Data solution enables customers to augment their analysis with publicly available data from social media sites such as Twitter and Facebook, and hundreds of trusted data providers on Windows Azure Marketplace.  Azure Marketplace also exposes hundreds of applications and data mining algorithms to help unlock new insights for customers.

 

Delivering Insights for Everyone with MS BI – Through deep integration with its BI (PowerPivot and PowerView) and EDW tools, Microsoft’s Big Data solution offers customers deep insights on all their structured and unstructured data with the tools they use every day.

 

Today, IT faces new challenges, there is an entirely new scale and scope to the kinds of data users are trying to gain insights from across both relational and non-relational sources.

 

This growth is coming from:

1)Transactional growth in businesses. 2) Non-relational data growing at an exponential rate vs. the traditional relational data growing at a more linear rate .3) Growth in online business.

 

There is a lot of discussion about “Big Data” in the world today, and how technologies such as map reduce have emerged as a method to process lots of unstructured data in a distributed storage system.

 

Ultimately what we see here is an opportunity to activate data that lives outside the traditional data platform.   And consistent with our strategy of supporting all types of data and the methods to process them, we announced a Big Data strategy that embraces Hadoop for activating this ambient data from sensors, clickstream, social media, location-based or other data.

 

Let’s take a look at how SQL Server provides a complete platform to store, scale, manage and govern data for the expanding needs of the modern enterprise.

 

 

There is a lot of discussion about “Big Data” in the world today.  So what do people mean?   Is it about scale and large volumes?  Not exclusively.  Is it about processing unstructured data like web logs?  No not exclusively.    Is it about a specific computational pattern or method that gives you real-time insight? No, not exclusively. These are all things SQL Server supports today.

 

Often what people are talking about are new specific computational patterns including map reduce, which emerged as a method to process lots of unstructured data in a distributed storage system.  Now, this doesn’t have a monopoly on “Volume”, “Variety” or “Velocity” but does provide some unique capabilities.

 

Microsoft has a unique perspective on Big Data – We are the only major Data Platform vendor who is also in the 100PB club of Cloud providers. We have invested heavily in building and running a big data platform to fuel and drive our business. Microsoft is managing 100’s of Petabytes of data across our online properties.  Adding 8 PBs per month, running 20k jobs per day to run the business.

 

We are also integrating SQL Server with Big Data and completing the solution by enabling developers to build applications on this data; and connect it through to our end users with our BI tools. So we have a pretty good understanding of how to build and operate one of these infrastructures and connect it thru to developers and end users.

 

Ultimately what we see here is an opportunity to activate data that has lived outside the traditional data platform.   And consistent with our strategy, deliver immersive insights over all data to all users in the tools they are familiar with.

 

Last fall we announced a Big Data strategy that embraces Hadoop for activating this ambient data being born outside the traditional data platform.  Hadoop is the open source implementation of MapReduce parallel computation engine and environment, and it’s used (quite widely now) in the processing of streams of data that go well beyond even the largest enterprise data sets in size. Whether it’s sensor, clickstream, social media, location-based or other data that is generated and collected in large gobs, Hadoop is often on the scene in the service of processing and analyzing it.

 

 

Here’s Microsoft’s Big Data strategy:

Enterprise Ready – delivering an enterprise class implementation or distribution of Hadoop for Windows Server and Windows Azure, integrated with SQL Server 2012, Active Directory and System Center makes it dramatically easier, efficient and cost effective for your organization to capitalize on the opportunity Big Data can bring to your business.

 

And with the Hadoop distribution for Windows Azure, customers can instantly begin taking advantage of the benefits of Big Data without capital infrastructure or operational costs.

 

Connected with the World’s Data – Microsoft’s Big Data solution enables customers to augment their analysis with publicly available data from social media sites such as Twitter and Facebook, and hundreds of trusted data providers on Windows Azure Marketplace.  Azure Marketplace also exposes hundreds of applications and data mining algorithms to help unlock new insights for customers.

 

Delivering Insights for Everyone with MS BI – Through deep integration with its BI (PowerPivot and PowerView) and EDW tools, Microsoft’s Big Data solution offers customers deep insights on all their structured and unstructured data with the tools they use every day.