Epicor EPM The Future for Common Reports
“The more people within a business who have access to the benefits of quality BI, the better equipped organizations will be to respond to, and take advantage of, opportunities and shifts in their business environment.”
Evolution and Tradition • Reports – Uses report software to create reports from one system at the time. – Reports are adjusted in Report configuration tool. – If reports need to be augmented they are imported into Excel where adjustments are made.
• Business Intelligence – Data replicated from the core systems (often more than one) and re-organized to be easy to understand and fast to retreive – Nice and management friendly software is used to retreive the data creating a platform for analysis and view.
• Budgets, Plans and Forecasts – Are mostly made in Excel, then later punched back into the ERP system to be used for Reports. – Some companies are using separate systems for the purpose of Planning. Most often these systems are not used for Reports.
A New Kind of Report
Reports ?
BI
Plans
Reporting and Analysis
EPM PERFORMANCE CANVAS
Trend visualization
Canvas Usage
Finding a Canvas There are several ways to find a canvas. The basic places you find your canvas are: • in the list in your canvas homepage • in your corporate intranet or MS Share point portal • as an answer on a search in your corporate search engine • in your mobile phone canvas page
EPM Education – How to Deploy a Content Pack © 2010 Epicor
Using Filters With filters you “slice” the information to highlight the values and ranges that are interesting for you to view.
The dialogue box gives you several ways to select information either through multiple or single select.
EPM Education – How to Deploy a Content Pack © 2010 Epicor
Using Viewpoints Viewpoints is a way to save a specific canvas settings so its easily returned to and able to share with relevant people.
EPM Education – How to Deploy a Content Pack © 2010 Epicor Software Corporation.
Creating and Reading Annotations
• A global annotation is a general comment you make on a graph or table in the canvas. • A local annotation is a comment you make on a specific filter setting on graph or table in the canvas.
EPM Education – How to Deploy a Content Pack © 2010 Epicor
Exporting Performance Canvas supports this in basically four ways: • Downloading the data to a Microsoft Excel Spreadsheet • Exporting to a “live” pivot table in Microsoft Excel • Exporting to a PDF file • Exporting to a Image file
EPM Education – How to Deploy a Content Pack © 2010 Epicor
Summary What we learned: • Using Filters • Using Viewpoints • Creating and Reading Annotations • Exporting
EPM Education – How to Deploy a Content Pack © 2010 Epicor
EPM Education Creating a Canvas
Example of Creating a Canvas
Summary What we learned: • Adding Cubes • Creating Canvas • Creating Gems • Creating Slicers
EPM Education – How to Deploy a Content Pack © 2010 Epicor
Business reporting with Key Performance Indicators
EPM CANVAS COMPLETE
Planning for the Future with Excel & the Web • • • •
• •
•
Create all your financial reports in one system Drill through, drill down and drill across to relational data Formula based and matrixbased reporting Track account movement for cash flow analysis and forecasting Foreign currency translation Create and maintain dimensions, attributes, cubes and hierarchies Input forecast data via the web – Perfect for multinational corporations working in different domains 18
Management Planning
Smart navigation With chart support and overlays • Coloring to display values directly in the map • Pop up that shows additional charts to get further drilldown details on hover over
Smart Navigation Using tree structures navigation can be tailored further
Going Mobile •
Powerful BI and Analytics right in your mobile phone
•
Can be used on ANY web enabled mobile device
•
Extensive graphing capabilities
•
Extensive IPAD support including touch based BI
•
Input Schedules for mobile input
•
Ease of use for deployment with Zero foot print clients
iPad - Support With pre built guides where it helps you to design proper navigation for tablets. It can guide you trough either horizontal or vertical screens.
Windows 8 Tail support
Resoruces Website: www.DSPanel.com Mobile BI demo site: http://demo.performancecanvas.com/m
Demo site: http://demo.performancecanvas.com Videos: http://www.youtube.com/DSPanel Håkan Ebersjö:
[email protected] Jan Morath:
[email protected] Jennifer Howell:
[email protected]
25
Epicor EPM The Future for Common Reports