alfresco tech talk n.73 - business intelligence for ecm practitioners
TRANSCRIPT
Francesco Corti
Janus Bifrons (http://en.wikipedia.org/wiki/Janus)
EnterpriseContentManagement
Business Intelligence
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014 �1
Please, interrupt me!http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014 �2
The goal
• What Business Intelligence is
• What Business Intelligence is not
• Taking a look at Alfresco and ECM in general
• From a technical point of view
http://fcorti.com
Tools Theory
Alfresco tech talk n.73 - February 5th, 2014 �3
Busi
ness
que
stio
nsWe all use Alfresco and we would like to know…
• Who is using it? Which are the top users/offices/departments?
• How is the repository growing over time?
• Which are the most viewed contents last week? And in the last quarter? And in the last year?
• I would like to develop interactive analysis on metadata and types/aspects.
• Where are the bottlenecks in my processes and workflows?
• What happens to the duration of my processes if the document flows will increase 15% more than today?
• How can I analyze information like this as a spreadsheet?
• Everything should be shared with my Boss/Collaborators on his/her/their cellphones
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014 �4
And even if we know everything…http://fcorti.com
https://www.youtube.com/watch?v=a3QGwTcyRLQ
Alfresco tech talk n.73 - February 5th, 2014 �5
BI specialist
When reality overtakes fantasyhttp://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
• Business questions cannot be easily satisfied and changes along with the organization and the processes
• Good news: Enterprise BI solutions and architectures is going to help us!
• Let’s see how…
�6
(Probably) everybody knows that BI is…
• Analytics
• Reports
• Dashboards
• Spreadsheets and pivot tables
• KPI
• …a lot of other (useful) tools for the end user!
http://fcorti.com
This is definitely true!
Alfresco tech talk n.73 - February 5th, 2014 �7
Front-end tools are focused on data presentation
• Front-end tools:
• are cool and handsome
• are focused on data enquiry and presentation
• make the end user’s life easier
• could be integrated in other applications
• make the analysis process smarter!
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014 �8
Is this a BI solution?
• Yes, it is a possible solution
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
+
�9
Is this a BI solution?
• Yes, it is a possible solution based on a single level
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
+
Source level Front-end level
�10
Is this a BI solution?
• Yes, it is a possible solution based on a single level
• But we could get more than this for a real Enterprise approach
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
+
Source level Front-end level
�11
Data Warehouse guarantees scalability
• A Data Warehouse is a storage developed specifically for data analysis
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014 �12
• Data Warehouse guarantees scalability in terms of • Business questions • Quantity of data • Data quality • Reliability
Data Warehouse guarantees scalabilityhttp://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014 �13
• A Data Warehouse is a storage developed specifically for data analysis
Is this a BI solution?
• Yes, more complex to manage but more complete*
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
++
(*)
�14
Is this a BI solution?
• Yes, more complex to manage but more complete*
• This solution is based on a two levels approach
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
++
(*)
Source level DWH level Front-end level
�15
A.A.A.R. solution
• A.A.A.R. develops the three levels architecture (DWH is composed by Operational level and Warehouse level)
• A.A.A.R. is, today, based on a pure Open Source stack
http://fcorti.com
Alfresco tech talk n.73 - February 5th, 2014
++
Source level DWH level Front-end level
�16
• Sources, data, business elements, front-end, …
Scalability of …http://fcorti.com
++
DWH level Front-end level
ERPAlfresco tech talk n.73 - February 5th, 2014
Source level
… … … �17
Q&Ahttp://fcorti.com
++
DWH level Front-end level
ERPAlfresco tech talk n.73 - February 5th, 2014
Source level
… … … �18
BI is not magichttp://fcorti.com
https://www.youtube.com/watch?v=s_bQDruxOAI
Alfresco tech talk n.73 - February 5th, 2014 �19