business inteligence in ifs applications
TRANSCRIPT
© 2013 IFS
© 2013 IFS
3
BUSINESS INTELLIGENCE IN IFS APPLICATIONS Håkan Claesson, Senior Advisor IFS R&D
© 2013 IFS
4
GARTNER DEFINITION “Business Intelligence is a broad category of applications and
technologies for gathering, storing, analyzing, and providing access to information to help enterprise users make better business decisions.”
© 2013 IFS
5
© 2013 IFS
6
WHY BI?
ERP RELATIONAL DATA STRUCTURE
© 2013 IFS
7
• Optimized for data input and transaction processing
• Data-oriented and complex
• Not fast enough for interactive analysis
© 2013 IFS
8
WHY BI? Better Business Decisions & Insight
• Structured Information • Fast Information Delivery • Data Transformation
• Visualization • Interactive Analysis • Time Series Analysis • Ad Hoc Data Access • User-Defined Reports
SOLUTION—BUSINESS-ORIENTED VIEW STAR SCHEMA MODEL
© 2013 IFS
9
DIM SALES PART
DIM SHIP VIA CODE
FACT CUSTOMER
ORDER LINES
DIM DELIVERY
TERMS
DIM CUSTOMER DIM
SITE
DIM PROJECT
DIM INVENTORY
PART
• Optimized for information output—reporting and analysis
• Easy to understand
DIMENSION FACT
SOLUTION—FAST INFORMATION DELIVERY THE OLAP CUBE
© 2013 IFS
10
OLAP: Online Analytical Processing
An OLAP cube is a set of data, organized in a way that facilitates non-predetermined queries for aggregated information. OLAP is one of the computer-based techniques for analyzing business data that are collectively called business intelligence. Source: Wikipedia
In simple terms: - The physical representation of the Star Schema - High performance engine for data delivery - Pre-aggregated data and predefined measures
© 2013 IFS
11
© 2013 IFS
12
BI TRENDS – DATA VOLUMES
BI TRENDS—BROADER AUDIENCE
© 2013 IFS
13
© 2013 IFS
14
BI TRENDS—SPEED
© 2013 IFS
15
BI TRENDS—BUILT-IN
IFS BI OFFERING
© 2013 IFS
16
IFS BI OFFERING—4 LAYER ARCHITECTURE
© 2013 IFS
17
IFS Applications Database Transactional data
Open information architecture—Information Sources
External DW/App
MS SQL Server
Data Warehouse/OLAP Cubes
Operational Reporting IFS Business Analytics
Operational Reporting IFS EE/Microsoft Report Builder
Pivot Analysis Microsoft Excel
Dashboard Analysis Microsoft SharePoint/Excel
Relational Layer
Star Schema Layer
Analysis/OLAP Layer
Visualization Layer
IFS BI OFFERING—COMPONENT PERSPECTIVE
© 2013 IFS
18
IFS Applications Database Transactional data
Open information architecture—Information Sources
External DW/App
MS SQL Server
Data Warehouse/OLAP Cubes
Pivot Analysis Microsoft Excel
Dashboard Analysis Microsoft SharePoint/Excel
Operational Reporting IFS Business Analytics
Operational Reporting IFS EE/Microsoft Report Builder
Operational Strategic
TRADITIONAL BI PROJECTS
© 2013 IFS
19
Time
Cost
Data model validation
User interface
Mapping, Integration, Data models
IFS BI BUILT-IN & PREPACKAGED CONCEPT
© 2013 IFS
20
Compared to a traditional BI project
License- based
Content Time
Cost
Added content
New interface
Optional
Learning phase/Trial
and error
Business Analytics
Analysis Panel
Excel Dashboard with OLAP Cubes
DEMO
© 2013 IFS 21
MANUFACTURING VISUALIZER-NEW INITIATIVE
© 2013 IFS 22
THE TRADITIONAL OPERATIONAL VIEW
MANUFACTURING VISUALIZER-NEW INITIATIVE
© 2013 IFS 23
BUILT-IN INTERACTIVE ANALYTICS
• Scenario-driven visualization based on a query
• User-configurable visualizations • Actions and navigations
AN END TO END SOLUTION—BUILT-IN INTO IFS APPLICATIONS
Technology, tools and integration
Information model and content
EFFICIENT IMPLEMENTATION
Prepackaged content—lower cost and faster
SOLUTION BREADTH AND DEPTH
Operational, analytical and strategic use
Broad solution coverage
IFS BI SOLUTION—SUMMARY PREPACKAGED CONTENT FOR QUICK RESULTS
© 2013 IFS
24
Industry standard tools : Microsoft Excel, SQL Server, Report Builder, SharePoint
Information Sources: +70 in different areas
Business Analytics
Data warehouse with OLAP Cubes Sales, Procurement, Finance, Maintenance, HR, Project, Sales Contract Example dashboards and reports
IFS EE integration – MS Report Builder, Analysis Panel, other BI applications
Coming soon – The Manufacturing Visualizer
YOU GET BUILT-IN ANALYTICS
© 2013 IFS
25
© 2013 IFS
26
BRING DATA TO LIFE WITH IFS APPLICATIONS
BUILT-IN ANALYTICS
THANK YOU!
THIS DOCUMENT MAY CONTAIN STATEMENTS OF POSSIBLE FUTURE FUNCTIONALITY FOR IFS’S SOFTWARE PRODUCTS AND TECHNOLOGY. SUCH STATEMENTS OF FUTURE FUNCTIONALITY ARE FOR INFORMATION PURPOSES ONLY AND SHOULD NOT BE
INTERPRETED AS ANY COMMITMENT OR REPRESENTATION. IFS AND ALL IFS PRODUCT NAMES ARE TRADEMARKS OF IFS. THE NAMES OF ACTUAL COMPANIES AND PRODUCTS MENTIONED HEREIN MAY BE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.
www.IFSWORLD.com
© 2013 IFS