Pinpoint 515 P2 Business Intelligence

1
Pinpoint 515 P2 Business Intelligence

• Pinpoint BI Welcome to Cognos

2
Pinpoint BI Welcome to Cognos

• What is Business Intelligence?
• Business intelligence refers to the
  technologies, applications and practices used to
  collect an organizations data to provide
  meaningful information and analysis to, end users
  partners for more effective decision making.

3
How can BI help your warehouse

• Access to
• information
• provides a better
• understanding
• of the business
• BI empowers users of the information
• Allow information to be more useful, more dynamic

4
The Power to Build Your Own Reports

• File structure
• Filtering
• Joins for the mortal
• Finding the info you want

5
Who uses Cognos?

• Consumers
• Warehouse Manager
• Shipping Manager
• Shift Lead
• Report Designers/Power Users
• Business analyst
• Server Administrators
• Organization IT

6
Cognos Studios

• Cognos Portal
• Displays Studios in Cognos

7
Cognos Studios

• Cognos is made
• up of a number of
• tools called studios
• Each studio corresponds
• to a type of user and
• which tools they normally use
• Licensing will determine how many users have
  access to which studio

8
Cognos Studios

• Warehouse Manager Consumers
• Query Studio
• Event Studio
• Report designer- Power User
• Report Studio
• Analysis Studio
• Metric Studio
• Database Managers Server Admins
• Manages Meta Data
• Ensure Cognos has access to source data

9
Query Studio

• Easiest to use
• Accessible by
• the front lines
• Still requires
• knowledge to use
• Pinpoint File structure

10
Query Studio-Sample Report

• Task Manager Simplified

• This report shows
• The task number
• Task_id (pi, pu, co etc)
• Task Status

11
How We Arrived at the Sample Task View Report

• File Structure
• Data Package

Table
The data package contains all the tables
(information) from the Pinpoint
Warehouse Expand the warehouse package to view
all the available tables (wm_task_queue will be
used for the example)
12
How We Arrived at the Sample Task View Report
Tables
Data Items

• Within the tables are data items, columns or
  fields
• Data Items used by the example include
  Task_No, Status and Task_Id

13
How We Arrived at the Sample Task View Report
Adding data Items to the Report
14
How We Arrived at the Sample Task View Report

• Filtering

After the desired data is added to the report a
user may still want to tweak the report and
filters can be set
In this example the user defined a conditions
stating which task_ids were to be included in the
report
15
Adding Data Items from other Tables

• Not all data is contained
• in the same table
• We need to find the
• Product ID field for our
• sample report
• Cognos allows this to
• be done quickly

16
Adding Data Items from other Tables

• Want to add product_id to report
• Locate the other table
• easier and easier with practice

• wm_request_d and wm_task_queue both contain
  request no
• This relationship allows tables to share data
  from other tables

17
Adding Data Items from other Tables
Adding data from other tables
18
Chart Views of Reports

• Data on reports can be viewed using charts or
  graphs

19
Standard Reports

• Excel to Cognos
• Back to Excel
• (Exporting Your Reports)
• Still can be
• manipulated for
• the most critical
• data to be visible

20
Standard Reports

• Not all reports will need to be made by consumers
• Many reports will be stored as standard reports
• Located in directory

21
Standard Reports

• Standard reports will consist of many existing
  Excel reports that are available with P2 today
• These reports can still be modified on an ad hoc
  basis

22
Exporting Reports

• Reports Can be viewed in
• Excel
• PDF
• CSV
• XML

23
Dashboard

• Customize how you want to your view your Pinpoint
  data
• Allow a user to view
• multiple reports
• from the Cognos portal
• Set up rss feeds
• Have reports that
• you need at your finger tips

24
Dashborad

• Access to the Dashboard is located on the
  Cognos login portal, click the Cognos connection
  link

25
Dashborad
26
Dashboard

• Once you are familiar with tools you can start
  adding them to your dashboard
• Cognos Navigator
• Cognos Viewer
• RSS feeds

27
Cognos Navigator

• Allows a portlet on the dash board that allows
  user to list reports in a specified location in
  Cognos

28
Cognos Viewer

• Allows to add portlets that display the output
  of a report

29
RSS Feeds

• Websites in XML format
• Can be set up for viewing is dashboards
• Can contain info important to operations or user

30
Any Questions????