Business Intelligence Analysis Solution Based on IBM Cognos

Business Intelligence Analysis Solution Based on IBM Cognos

Someone recommended me a course on big data. I feel very good. I would like to share it with you!

Cognos report studio is a complex professional reporting tool designed for users in the IBM Cognos BI product suite.

Cognos is a service-oriented architecture built on the core bi platform. It is the only solution that provides complete business intelligence functions through a single product and a single reliable architecture. It provides

Seamless and integrated reporting, analysis, scorecard, dashboards, and other solutions simplify the way employees process information by providing all system and data resources.

Currently, IBM Cognos ranks first in the Bi market in China. Its brand influence makes future development even more limitless.

Consult QQ: 1609173918

Objective:

1. Familiar with the basic functions of report studio, and able to design reports of different types such as list, crosstab chart, icon, and map

2. You can use grouping, header, footer, and other formatting options to customize the report format.

3. Use the prompt page and its components to filter report data

4. Use computing and functions to process other derivative values for the report

5. Use Condition types and variables to customize report formats

6. Set the drilling-through access feature and design the drilling-through report.

All English teaching materials are described in Chinese to help you improve your English proficiency and familiarize yourself with foreign company thinking.

Course outline

 

(1) IBM Cognos Bi Overview

 

1-1 IBM smart Analysis

1-2 Expected observation, prediction and building of business results

1-3 Functions of IBM Cognos bi

1-4 IBM Cognos 10 Family

1-5 IBM Cognos Bi Enterprise Edition

1-6 IBM Cognos BI architecture

1-7 IBM Cognos Bi Security

1-8 IBM Cognos Bi groups and Roles

1-9 extended IBM Cognos Bi Enterprise Edition

 

(2) Introduction to report applications

 

2-1 What is report studio?

2-2 explore the development environment

2-3 view the browser bar

2-4 view the Report Template

2-5 Generate Reports

2-6 change Object Attributes

2-7 dimension model and Dimension Data Source

 

(3) create a list Report

 

3-1 understand the list

3-2 group data

3-3 format the list Field

3-4 contains the list header and footer

3-5 understand fact/metric data

3-6 understand summary data

3-7 understand differences in summary

3-8 use shared dimensions to create multi-fact queries

3-9 Add duplicate information to the report

 

(4) use filters to focus on reports

 

4-1 create a filter

4-2 use the enhanced detail filter to filter your data

4-3 determine when to use the summary Filter

4-4 filter data

4-5 use pre-defined filters

 

(5) create a cross tabulation report

 

5-1 create a cross report

5-2 add measurement to cross report

5-3 create a complex cross tabulation report

5-4 create a cross table node and a cross table node Member

5-5 format the cross tabulation report

5-6 Add irrelevant items to the crosstab chart

 

(6) display data through charts

 

6-1 create a chart report

6-2 different chart options

6-3 create a chart that contains parallel items and nested items

6-4 Create and reuse custom chart templates

6-5 add data-driven baselines and labels to Charts

6-6 compare the value and use the dashboard chart and pie chart to highlight the proportion

6-7 display items on the separated axis

6-8 custom charts

 

(7) use tips to follow reports

 

7-1 understand parameters and prompts

7-2 create a parameter in the report

7-3 create prompt page

7-4 Add a prompt item to the report

7-5 define the prompt type

7-6 Add the page to the report

7-7 create a cascade prompt

 

(8) Use computing to expand reports

 

8-1 get additional information from the data source

8-2 add running time information to the report

8-3 Add the date/time function to the report

8-4 add string functions to the report

8-5 display prompt query on the report title

8-6 additional information: some common functions

 

(9) Use a map to display data

 

9-1 use a map report to display data: overview

9-2 add data to the map report

9-3 specifies whether the map file data matches the data source

9-4 Use the zoom-in function to focus on Map Information

 

(10) Other Report creation skills

 

10-1 enhanced report Design

10-2 add an object

10-3 Use tables to organize objects

10-4 SPLIT reports

10-5 convert the list to a crosstab chart

10-6 reuse objects in the same report

10-7 Share layout controls in different reports

10-8 use any package to create a template report

10-9 Report Processing without data

 

(11) customize reports using Conditional Formatting

 

11-1 Change Report Display Based on conditions

11-2 3-step Conditional Formatting

Step 1 create a variable

Step 2 assign variables to objects in the report

Step 3 apply the condition format in the object based on the condition Value

11-3 select the object to be displayed

11-4 format another table based on a cross table Metric

 

(12) drill-through between reports

 

12-1 allows users to drill data between the associated data

12-2 configure drilling-through access

12-3 pass the specified value to the target parameter

12-4 allow users to drill data between multiple reports

 

(13) Definition of penetration Drilling

 

13-1 allows users to drill data between the associated data

-2 configure drilling-through access

13-3 package-based drilling

13-4 pass the specified value to the target parameter

13-5 set the package-based drill Definition

13-6 source data items restricted for user Drilling

13-7 Measurement-based range

13-8 drilling Assistant

13-9 Dynamic Drilling

13-10 dynamic drilling after matching conditions

 

(14) Enhanced report layout

 

14-1 view the report structure

14-2 force page splitting

14-3 Horizontal page number

14-4 add horizontal page number

14-5 modify the structure

14-6 change the direction of the pdf page to fit the report object

14-7 set PDF Security Options

14-8 format objects in reports

Business Intelligence Analysis Solution Based on IBM Cognos