Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

BUSINESS INTELLIGENCE

No description
by

Jan Dewitte

on 11 June 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of BUSINESS INTELLIGENCE

BUSINESS INTELLIGENCE
What is BI?
BI Architecture
Something is missing between Transactions and Analytics
Approaches
Traditional vs. Modern BI
A Conclusion
BI has own spot in Enterprise Architecture
BI is there to generate value
User should not be forgotten
BI NIRVANA is INTEGRATED BI:
Enterprise Architecture
Two Opposite Worlds
OLTP vs. OLAP
On Line Transactional Processing vs. On Line Analytical Processing
Traditional BI
What we looked at so far...
IT driven
Proven Technology:
Relational DB
Multi-Dimensional Cube
Data Quality
Master Data Management
BI New Style
User oriented
Data Discovery
Self Reporting
Integration of Big Data
New tools: QlikView, Tableau
Business Intelligence = 'Informatique décisionnelle'
Système à la française
IN
OUT
Système décisionnel
Système opérationnel
Système d'information
SYSTEM
Système décisionnel
Système opérationnel
Système d'information
IN
OUT
Table of Content
Enterprise Architecture
Business Intelligence Architecture
Approaches
A Conclusion
Business intelligence (BI)
is an umbrella term that includes
the applications
infrastructure and tools
best practices
that enable access to and analysis of information to improve and optimize
decisions
and performance.
Transactional World
Data Entry Oriented
Big user group produces:
orders
invoices
monitor visits
patients
etc.
Analytical World
Business Intelligence
Problem solving
Reporting, Measuring
Planning
Budgeting, Forecasting
Decision making
Small user group

Relational Database
CRUD operations
Multiple queries
Low data volume queries
Simple queries
Backup & Recovery
SQL
Multi Dimensional Database
Read operations
Fewer queries
High data volume queries
Complex queries
No Backup & Recovery
Multi Dimensional Expression Language (MDXL)

Totally Different Types of DBs!
Example of Transactional Records
IT Incident Data Sample
Visualization Associated to the Data Sample
How can we get to these results?
Aggregated Values
Need to be stored and updated somewhere
Resulting Architecture
Possible BI Architecture
Source Systems
OLTP
Staging Area
Data Quality
Enterprise Data Warehouse
Central Data Store
Reporting Layer
What does the BI end user want to see in the reports?

Key Performance Indicators
Domains: sales, finance, operations, HR, etc.
Clinical Development World: Risk Based Monitoring, Site Quality Management, Site Selection
Aggregated values/figures PER month quarter, country, region, etc.
E.g. :
How many subjects randomized per site, country or trial
.
Financial system
CRM
ERP
Clinical Trial Management System
Electronic Data Capture
ETL
Upload
Master Data Management
Star Schema
Dimensions and Facts (Measures)
Principal Investigator
FACT
Trial
Time
Geography
Alfavit
Subject Randomized
Paul Smith
France
20-Jan-15
ETL
Or None of these!
Totally unstructured 'BI'
More or less advanced Excel sheets
Reports in Source Applications
People
Processes
Tools
Full transcript