MSBI # 69 – BI #6 – SQL Server 2012 – Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2000 – 2012

Hi Friends,

Now days everyone is very excited and getting more use  to with SQL server 2012 , The main aim behind every action is to have complete insight for SQL server 2012 from every angle i.e. for understanding for Developer , Business User , Architecture everyone in BI platform .

I have already started some article based on SQL server 2012 recently , if you have miss any can go to following links :

• MSBI # 68 – SSIS # 28 – SQL Server 2012 – New Features , SSDT Introduction and links
• MSBI # 67 – BI# 5 – SQL Server 2012 – Installation, Problem, Support and Help !
  

  In this blog post we are going to cover following aspect for SQL server 2012

  Microsoft Business Intelligence Overview

  Discussion point on Breakthrough Insight

  Rapid Data Exploration & Visualization

  Credible, Consistent Data

  Scalable Analytics  & DW Solution

  SQL Server Evolution from 2005 – 2012

Now lets go through point by point for more detailed explanation

Microsoft Business Intelligence Overview

Now Microsoft  BI stack is more powerful and more Clare.

Following four are workspace where we are using BI stack more collaboratively

1. Social CRM
2. BI
3. Collaborating Insights
4. Unified Workspace

In above four important we use following techniques
1. Microsoft Dynamic CRM
2. Microsoft Office
3. Microsoft SQL server  
4. Microsoft SharePoint
5. Microsoft Lync Server

Lets represent everything on single plane what it look like :

Complete and integrated work flow design as shown 

 

Discussion point on Breakthrough Insight

The most important aspect here is to for Planning Agility and Control

We can focus with feature such as

• Discussion point on Breakthrough Insight
• Rapid Data Exploration & Visualization
• Credible, Consistent Data

Rapid Data Exploration & Visualization

• Familiar data exploration and visualization with Project Power View
• Inspire innovation with powerful data mash-ups in Power Pivot
• Greater IT oversight and management through SharePoint

Credible, Consistent Data

• Consistent view of your data through a single BI Semantic Model
• Ease of integration and management with Integration Services and Master Data Services
• Quickly manage, analyze, and cleanse data across sources in Data Quality Services

Scalable Analytics  & DW Solution

• Engine tuning for high-scale analytics in Analysis Services
• Enhanced capabilities for high-scale data warehousing with Parallel Data Warehouse
• Comprehensive offerings for Data Warehouses of all sizes

SQL Server Evolution from 2000 – 2012

I just found following image in one of slide where we can easily identify evolution of SQL Server 

We will have all more update , Links , images on further posting on same ..

For more interesting information on SQL we can also look into similar topics such as

• MSBI #45 – SQL Server 2012 #1 – Now SQL Server ‘Denali’ is 2012 !
• BISQL # 51 : SQL Server Denali Feature # 2 – Sequence number –All Explanation !!
• BISQL # 53 : SQL Server Denali Feature # 3 – Always On (Concept ,Architecture)
• BISQL # 50 : SQL Server Denali Feature # 1- File Tables # 2 – Demo and Scripting
• BISQL # 49 : SQL Server Denali Feature # 1–File Tables #1 – Introduction & Theory

Hope you will like this post on Breakthrough Insight SQL Server 2012 , SQL Server Evolution 2005 – 2012.

If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.

If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :

Link Resource Website

For More information related to BI World visit my Mentalist Blog

Link Resource Blog >> Daily Interesting links

SQL Server Mentalist >> SQL Learning Blog

Business Intelligence Mentalist >> BI World

Connect With me on

| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |