Transcript Bild 1 - GADD knowledge base

Release information 5.9 – (GADD NET R5.9 WP PPT Publ 2013-08-02_prel.ppt)
This presentation is for
GADD release 5.9
Final information will be available in September.
5.9 is scheduled for September 2013
page 1
Content of this PowerPoint
 GADD Software “at one of Sweden's largest multinational companies”
 Concept and Products

Concept

Products
 Highlights on

GADD Query & Dashboard on the web

GADD Analytics for Retail
page 2
GADD Software
“at one of Sweden's largest
multinational companies”
page 3
GADD Software “at one of Sweden's largest …”
• GADD is used in all countries where the
company has business.
• GADD is used for several business areas;
sales, logistics, purchase, finance.
• More than 20.000 registered users, 1.000.000
queries/reports every month, 300 data
sources.
• No education needed.
• Pre-defined reports & ad-hoc analysis.
• Windows & Web.
• 100% automated via AutoGADD and
Scheduler.
• 100% integrated with IT Infrastructure,
processes and procedures.
• Integrate with MS Excel, MS Access and MS
SQL Server.
page 4
Concept
page 5
Concept, our vision
With our products and solutions,
information is made available for all employees,
catalysing quicker decisions and actions,
leading to continuous improvements in the daily operations.
We enable customisation that moves “Business Intelligence”
from “monolithic tools” to “composite intelligence”.
page 6
Concept, cover the complete scope of operational BI
• Retrieve and consolidate data in real-time from unlimited number of data sources.
• Automation of data retrieval and information publishing using Scheduler and AutoGADD.
• Predefined reports for operational use that secures information quality, steering and super easy to use for anybody.
• Ad-hoc analysis using predefined or user created queries and views for the advanced user.
• Automatic web publishing on Intranet of reports, dashboards, KPI using WebGADD.
• Ad-hoc data analysis via web browser using pivot, tables, charts, gauges, pies, cards etc. that are interactive and “drillable”.
• User directory to steer access and authentication and Query statistic to monitor follow up all usage.
• Integrated with Microsoft Excel and other MS Office desktop tools, using Microsoft technology and an extendable architecture that
enable unlimited and efficient customisation.
page 7
Concept – see, know and make it happen
 Monitor daily operations. Publish
automatically dashboards, KPI on the web.
Monitor
Predict
Detect
Inspect
 Detect deviations. Let the system detect
deviations and patterns and find the articles
and product areas that need to be
inspected.
 Inspect detailed article facts, trends,
relations and compare between sales units,
suppliers, countries.
 Predict the future. Use historic data,
weather, vacation, activities, campaigns etc.
and let the system make the best
prediction.
Do Monitor, Detect, Inspect and Predict on any device; PC (Windows), PC Tablet, iPad, Phone (Android, iPhone).
HTML based and using responsive design.
page 8
Products
page 9
Products, component overview
Data
Source
GADD User
Directory
•
•
•
•
•
GADD Query
Library
Oracle
SQL Server
Data files
Excel
Any type
ADO.NET, OLE
DB, ODBC, Web
Service, HTTP,
Customised API
Data Storage
GADD Web Server
(GADD Query, Dashboard Viewer)
GADD Web
Client
Web Browser
Microsoft Excel
GADD Desktop
(GADDxl, AutoGADD, GADD Scheduler, Query & Dashboard Builder, Dashboard
Viewer, GADD Query)
GADD Monitor, Detect, Inspect & Predict
Database
GADD ETL (data exchange; export, transform, load)
Data file
page 10
Products, list and short description
 GADD Desktop
Includes applications GADDxl, AutoGADD, Query & Dashboard Builder, Dashboard Viewer and additional tools for e.g.
dashboards, pivot.
 GADD User Directory
Includes web application for user administration and the application AdmGADDUser.
 GADD Web Server
Includes web client applications Dashboard Viewer and GADD Query.
 GADD ETL
Includes components and framework for data exchange and data storage. (Extract Transform Load.)
 GADD Monitors, Detects, Inspects & Predicts
Includes applications for basket analysis and detection of sales trends on article, product area and business area.
Includes applications for local sales forecast and budget simulation for short and long term.
 GADD Analytics for Retail
Plug & play solution that includes automatic monitoring, ad-hoc analysis, data consolidation and archiving, basket analysis, sales
activity follow up and more.
page 11
Products, highlights & misc. notes
GADD Query & Dashboard
• Use predefined queries, reports, interactive dashboards for
analyses and KPI publishing.
• Extend them and build your own.
• Creating queries, reports and dashboards cannot be easier.
• Publishing on the web cannot be easier.
page 12
Products, highlights & misc. notes
 GADD Analytics for Retail
•
Monitor, Detect, Inspect and Predict.
•
Covers real-time sales monitoring, sales activity follow-up, stock analysis, quality analysis (damages &
returns), basket analysis (add-on and cross sales).
•
Web applications (WebGADD Server) for publishing queries, reports, dashboards, KPI and enabling
query execution and add-hoc data analysis via any web browser. (TV-screens, Laptop, Tablets/IPad,
Mobile phone, etc).
 GADD ETL
•
GADD ETL (Extract Transform Load) makes it possible to automatically save data that is retrieved from
a query.
•
It cover both GADD Data Exchange and GADD Data Storage.
•
Use it as data cache or/and for data archiving.
•
Create your own data mart.
 GADD Query Library Web version
•
Create your own Query Library.
•
Use GADD Data Storage as the data mart.
•
Publish queries via GADDxl Web version.
page 13
Products, dashboard builder and viewer
GADD Query & Dashboard Builder
GADD Q & D Viewer for Windows & Web
page 14
Products, GADD Query
page 15
Products, visualizations, charts & gauges
page 16
Products, basket analysis – chord & matrix
Customized & business oriented
• Sales activities
• Add-on Sales
• Cross-sales measurements
• Basket Analysis
• Customers that purchased X also purchase Y
• Measure result on campaigns and product display in store
• Recommendations based on what is in the customer basket
page 17
Products, technology overview
 GADD Software




GADD Software products are built using Microsoft .NET and selected Third Party Components.
We take advantage of existing BI technology and components and make it Plug & Play.
Reuse and extend instead of re-build and replace.
Composite instead of monolithic.
 Microsoft .NET & HTML
Microsoft development framework. Interact with Excel, MS Access, Power Pivot, Power BI for Office 365.
HTML for the Web client for all devices and responsive design.
 Third Party Components
Third Party Components to extend calculation and visualisation capabilities.
Data
Source
•
•
•
•
•
Oracle
SQL Server
Data files
Excel
Any type
ADO.NET, OLE
DB, ODBC, Web
Service, HTTP,
Customised API
HTML & Java
GADD
script
Web
Client
GADD User
GADD Web Server
Microsoft
Directory
• .NET development
• ASP.NET
GADD Query
• Winforms, WPF
•Library
IIS
• SQL Server
(GADD Query, Dashboard Viewer)
Data Storage
Web Browser
Microsoft Excel
GADD Desktop
(GADDxl,
GADD
Scheduler,
Query & Dashboard Builder, Dashboard
ThirdAutoGADD,
Party
Third
Party Components
Viewer,
GADD
Query)
Components
Dashboard
• Big data
• Chart
• Algorithm
• Map
GADD
Monitor, Detect,
Inspect & Predict
• Cache
• Gauges
GADD ETL (data exchange)
Database
Data file
page 18
GADD Analytics for Retail
page 19
GADD Analytics for Retail – on all devices and for all users

Cover the scope of monitor, detect, inspect and predict.

Covers sales activity follow-up, stock analysis, damages & returns, basket analysis, add-on and cross sales.

Auto update dashboards, KPI and do add-hoc data analysis via any web browser.

Use on TV-screens, Laptop, Tablets/IPad, Mobile phone.

Pre-defined dashboards, calculations, queries that can be used as is and be extended.

Automatic data archiving and data storing and web server publishing.
page 20
GADD Analytics for Retail – Plug & Play
Data
Source
Web Browser
Business rules &
configuration
Microsoft Excel
Monitor
GADD Analytics
for Retail
Predict
Inspect
Detect
DB
Data file
page 21
GADD Analytics for Retail – content overview
 Monitor
Monitor
 Web dashboards to display and make available on all decides via web browser and responsive design.
Automatic update of dashboards on TV-screens.
Predict
Detect
Inspect
 Sales, returns, damages, recovery and stock and other article numeric facts is retrieved from several data
sources and consolidated. External data e.g. sales goals and budget saved locally in Excel files can be included
to monitor sales activities goal and budget fulfilment.
 Detect
 Let the system detect based on common or customised algorithm.
 Products that has most significant sales increase, decrease, damaged, returned etc.
 Detect and understand customer purchase patterns using basket analysis:
 Customer that purchase product X what other products are they most likely also to purchase?
 What is the probability for add-on sales for a product?
 What was the result on the campaign in aspect of cross-sales and add-on sales?
 Inspect
 Get all facts, trends and related products superfast via your web browser.
 One click and on any device. Drill down, up and side ways.
 Use pre-defined queries for ad-hoc analysis or create your own.
 Predict
 Use detected sales patterns that apply for your local store; season variation, weekdays, vacations, sales
activities, geographic location, weather, salary days.
 Do local sales forecast using historic sales, sales patterns, weather forecast to predict sales coming days.
 Use prediction when defining budget for next month, quarter and year.
page 22