Send the link below via email or IMCopy
Present to your audienceStart 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.
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.
Transcript of BUSINESS INTELLIGENCE
What is BI?
Something is missing between Transactions and Analytics
Traditional vs. Modern BI
BI has own spot in Enterprise Architecture
BI is there to generate value
User should not be forgotten
BI NIRVANA is INTEGRATED BI:
Two Opposite Worlds
OLTP vs. OLAP
On Line Transactional Processing vs. On Line Analytical Processing
What we looked at so far...
Master Data Management
BI New Style
Integration of Big Data
New tools: QlikView, Tableau
Business Intelligence = 'Informatique décisionnelle'
Système à la française
Table of Content
Business Intelligence Architecture
Business intelligence (BI)
is an umbrella term that includes
infrastructure and tools
that enable access to and analysis of information to improve and optimize
Data Entry Oriented
Big user group produces:
Small user group
Low data volume queries
Backup & Recovery
Multi Dimensional Database
High data volume 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?
Need to be stored and updated somewhere
Possible BI Architecture
Enterprise Data Warehouse
Central Data Store
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.
How many subjects randomized per site, country or trial
Clinical Trial Management System
Electronic Data Capture
Master Data Management
Dimensions and Facts (Measures)
Or None of these!
Totally unstructured 'BI'
More or less advanced Excel sheets
Reports in Source Applications