Making sense of your data_BI with SQL Server 2012 and ...

sunfloweremryologistData Management

Oct 31, 2013 (3 years and 7 months ago)

79 views

Nikos
Anastopoulos

Territory
Technology
Strategist

Georgia
Psyllidou

Application
Platform
Solution Sales
Specialist


George
Papadakis

Business
Productivity
Solution Sales
Specialist


Don’t hesitate to ask the experts:



at the Microsoft booth in the foyer.


through
the website
http://
www.microsoftlive.gr/add/ask
-
an
-
expert.html
.


There will be time at the end of the session for your Q&A


Evolution of BI



IT has been busy keeping up with the growing demand for BI…

Self
-
Service BI

Traditional BI

IT Pro

Existing
Data

LOB
Applications

Files

Data Marts

ETL/Data
Quality

Analysis

Reports

Dashboards &
Scorecards

Provision

Analysis

Cubes

Data
Warehouse

Data

Staging

Spreadsheets

Specialized
Tools

Harvesting existing data, cleaning it and staging it …

To provision reports, dashboards & scorecards to meet End User demand.

But business is outpacing IT and End Users are demanding Agility …

R
apidly breaking down the barriers of Control with Self
-
Service BI!

Is it possible to balance Control with Agility?

End Users

C
omplete
and
integrated

BI

Transparent Data Encryption

HW Appliances

SQL
Audit


Security

Audit
All

User Actions

Comply with Data
Privacy Regulations

Protect Encryption
Keys

SQL Server Audit

Extensible Key
M
anagement

Transparent Data
E
ncryption

Common Criteria
Certification

o
Organizations operate under rules and regulations that mandate strict data
security, privacy, and integrity controls

o
Prevent unauthorized access to data

o
Protect against lost or stolen backup data

o
Audit access to ensure proper use

Pre
-
packaged appliances and reference architectures

Brian Knight,
Pragmatic Works
Source: InformationWeek Analytics 2010 BI and Information Management Survey

$1,066,348

$220,804

Mega
-
Vendor Average
without Microsoft

Microsoft

55%

45%

MICROSOFT

42%

58%

ORACLE (INCLUDING HYPERION AND SIEBEL)

40%

60%

SAP BUSINESSOBJECTS

38%

62%

IBM COGNOS (INCLUDING TM1)

Using/Planning to Use

Evaluating/Not Using

Are You Using, Planning, to Use or Evaluating BI Products
from the Following Vendors?

Five
-
Year BI Platform Cost

Source: Gartner 2010 BI Platforms Licensing Models & Negotiation Strategies

Cloud


On Your

TERMS

Mission

Critical

CONFIDENCE

through

Insights

Break
-

“Only
28%

of potential
users are using the
standard BI
platform of
choice in organizations


e
can balance our
employees’ need for rich
information and
collaboration with
IT’s need
to
CareGroup

Healthcare System

91%

68%

Under 50%

Semantic
Model

Quality

Master









Third
-
party

applications

Reporting

Services

Excel

PowerPivot

Databases

LOB Applications

Files

OData

Feeds

Cloud Services

SharePoint

Insights



runs
complex
queries about
, providing a
and fully integrates
into a

DirectEdge
, US Stock Exchange

WINDOWS

AZURE



with
options
for both public
and private
deployment,
as well
as combinations
of
both models


.¹”
&

Robust
unstructured

¹Source:
Gartner Symposium Presentation ‘Information
Management Goes 'Extreme':
The Biggest
Challenges for 21st
-
Century
CIOs, Mark Beyer, October 2011

Activate new data

via
non
-
traditional


Data Sources




1.
2.
FTS Support for Czech and Greek