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

sunfloweremryologistData Management

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

96 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