Difference between revisions of "CEM Economy Intelligence"

From Catglobe Wiki
Jump to: navigation, search
m
Line 1: Line 1:
 
== Introduction  ==
 
== Introduction  ==
  
−
Page for CEM&nbsp;Economy<br>  
+
Page for CEM&nbsp;Economy<br>
  
−
=== Questionnaires ===
+
=== Questionnaires ===
  
 
== To do  ==
 
== To do  ==
  
−
{| border="1" class="CGTable"
+
{| class="CGTable" border="1"
 
|-
 
|-
 
! Description  
 
! Description  
Line 23: Line 23:
 
#Data is exported, cleaned and imported into the old MS Access database
 
#Data is exported, cleaned and imported into the old MS Access database
  
−
| <br>  
+
| <br>
 
| 1  
 
| 1  
−
| <br>  
+
| <br>
 
| Half
 
| Half
 
|-
 
|-
 
|  
 
|  
−
Zero data problem. Where are we with a decision for zero data?  
+
Zero data problem. Where are we with a decision for zero data?
  
−
| <br>  
+
| <br>
 
| 2  
 
| 2  
−
| <br>  
+
| <br>
 
| Paused
 
| Paused
 
|-
 
|-
Line 39: Line 39:
 
Update dashboard: Catinét opinion. By default no parties are shown in the tracking diagram.  
 
Update dashboard: Catinét opinion. By default no parties are shown in the tracking diagram.  
  
−
The customer must select which parties to view the tracking diagram for, and then click the Update button to show the tracking diagram.  
+
The customer must select which parties to view the tracking diagram for, and then click the Update button to show the tracking diagram.
  
−
| <br>  
+
| <br>
 
| 3  
 
| 3  
−
| <br>  
+
| <br>
 
| Start
 
| Start
 
|-
 
|-
 
|  
 
|  
−
Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data.  
+
Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data.
  
−
| <br>  
+
| <br>
 
| 3  
 
| 3  
−
| <br>  
+
| <br>
 
| Half
 
| Half
 
|-
 
|-
 
|  
 
|  
−
Moving periods.<br>  
+
Moving periods.<br>
  
 
Casper send us a document with updates related to periods for all diagrams, some diagrams are predicting what will happen the following 3 months based on respondents answers.  
 
Casper send us a document with updates related to periods for all diagrams, some diagrams are predicting what will happen the following 3 months based on respondents answers.  
  
−
Project needed in order to solve the skewed periods, this is also the reason we do not use time sets.<br>  
+
Project needed in order to solve the skewed periods, this is also the reason we do not use time sets.<br>
  
−
| <br>  
+
| <br>
−
| 3<br>  
+
| 3<br>
−
| <br>  
+
| <br>
 
| Start<br>
 
| Start<br>
 
|-
 
|-
 
|  
 
|  
−
Period selection should be implemented.<br>  
+
Period selection should be implemented.<br>
  
 
User should be able to select start and end data as a start.<br>Later on selections on point size will be an obivious addition.  
 
User should be able to select start and end data as a start.<br>Later on selections on point size will be an obivious addition.  
Line 73: Line 73:
 
Thắng is working on a modification for time set which might already be uploaded.  
 
Thắng is working on a modification for time set which might already be uploaded.  
  
−
The new time set type is already available on version 5.7, next step is to create a project for version 5.9 which will make it possible to use time sets with tracking diagrams.<br>  
+
The new time set type is already available on version 5.7, next step is to create a project for version 5.9 which will make it possible to use time sets with tracking diagrams.<br>
  
−
| <br>  
+
| <br>
−
| 4<br>  
+
| 4<br>
−
| <br>  
+
| <br>
 
| Start<br>
 
| Start<br>
 
|-
 
|-
Line 87: Line 87:
 
We need a status from Report on a development project.  
 
We need a status from Report on a development project.  
  
−
The feature is implemented in version 5.8, making a merge back now would probably be a bad idea.<br>  
+
The feature is implemented in version 5.8, making a merge back now would probably be a bad idea.<br>
  
−
| <br>  
+
| <br>
−
| 5<br>  
+
| 5<br>
−
| <br>  
+
| <br>
 
| Paused<br>
 
| Paused<br>
 
|-
 
|-
Line 99: Line 99:
 
Review diagram style sheet, diagrams must be less Excel like.  
 
Review diagram style sheet, diagrams must be less Excel like.  
  
−
More details needed about what is good and what is bad?<br>  
+
More details needed about what is good and what is bad?<br>
  
−
| <br>  
+
| <br>
−
| 5<br>  
+
| 5<br>
−
| <br>  
+
| <br>
 
| Paused<br>
 
| Paused<br>
 
|}
 
|}
  
−
== Diagram status ==
+
== Diagram status ==
 +
 
 +
{| class="CGTable" border="1"
 +
|-
 +
! Description
 +
! Responsible
 +
! Priority
 +
! Deadline
 +
! Status
 +
|-
 +
|
 +
Politik og bekymring - Tillid til regering/opposition
 +
 
 +
Missing data that are not missing in IFKA report
 +
 
 +
IFKA report: Page 7
 +
 
 +
| Anh Duc
 +
| 3&nbsp;
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Politik og bekymring - Bekymring for udviklingen i den globale økonomi
 +
 
 +
Diagram are to start when data collection starts in 08/09
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Politik og bekymring - Bekymring for fødevarernes kvalitet
 +
 
 +
REMOVE THE DIAGRAM
 +
 
 +
| Luan
 +
| 2&nbsp;
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Husstandens økonomi - Husstandens økonomiske situation
 +
 
 +
Discrepancy between IFKA report and konjunktur on "forurening" in 89-99. IFKA data vener goes beyond -10, but ours do not
 +
 
 +
IFKA report: Page 18
 +
 
 +
| Luan
 +
| 3&nbsp;
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Husstandens økonomi - Penge til forbrug
 +
 
 +
Missing data in several periods
 +
 
 +
IFKA report: Page 19
 +
 
 +
| Anh Duc
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Forbrug - Ferie
 +
 
 +
There are only one period of data for "Ferie i Danmark", so please delete the yellow line up the point where we have data
 +
 
 +
IFKA report: Page 50
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Forbrug - Køb af musik/film på cd/dvd
 +
 
 +
No data before september 2000 - Remove 0-data and let trhe diagram start in sep 2000
 +
 
 +
IFKA report: Page 49
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Paused
 +
|-
 +
|
 +
Opsparing, pension, låntagning og investering - Opsparing
 +
 
 +
Data for the last period must be wrong??
 +
 
 +
IFKA report: Page 21
 +
 
 +
| Luan
 +
| 2
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Opsparing, pension, låntagning og investering - Investering i aktier
 +
 
 +
The diagram are not to start before data collection begins which is for september 2009
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Opsparing, pension, låntagning og investering - Investering i obligationer
 +
 
 +
The diagram are not to start before data collection begins which is for september 2009
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Opsparing, pension, låntagning og investering - Investering i anparter
 +
 
 +
The diagram are not to start before data collection begins which is for september 2009
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Opsparing, pension, låntagning og investering - Forbrug på kredit
 +
 
 +
Missing data for some periods, but the data is present in the IFKA reports
 +
 
 +
IFKA report: Page 24
 +
 
 +
| Anh Duc
 +
| 2
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Personbiler - Antal biler i husstanden
 +
 
 +
REMOVE THE DIAGRAM
 +
 
 +
| Luan
 +
| 2
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Flytning, bolig og realkredit - Kreditforeningslån
 +
 
 +
Question tekst is wrong. Again there are shown 0-data for some years in the beginning.
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Flytning, bolig og realkredit - Afdragsfrie kreditforeningslån
 +
 
 +
Question tekst is wrong. Only show diagram from the time data collection began in December 2003
 +
 
 +
| Luan
 +
| 3&nbsp;
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Boligens indretning - Gennemførelse af større til- eller ombygninger
 +
 
 +
The first word in the menu and in the headline "Gennemføring" is to be changed to "Gennemførelse". I am not sure that the newest collected data are correct!
 +
 
 +
IFKA report: Page 33
 +
 
 +
| Luan
 +
| 2
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Boligens indretning - Køb af nyt køkken
 +
 
 +
I am not sure that the newest collected data are correct!
 +
 
 +
IFKA report: Page 35, Figure 21
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Boligens indretning - Køb af nyt badeværelse
 +
 
 +
I am not sure that the newest collected data are correct!
 +
 
 +
IFKA report: Page 35, Figure 22
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Seere til nyhedsudsendelser
 +
 
 +
There are shown 0-data for some years in the beginning.
 +
 
 +
IFKA report: Page 61 (DR1 and TV2)
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Reklameindslag på radiostationer
 +
 
 +
There are shown 0-data for some years in the beginning. But no data to compare with
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Læser avis
 +
 
 +
Something wrong with the blue line. It shoots to 100%. Othervise, it looks good
 +
 
 +
IFKA report: Page 63 ("Hverdagsavis" and "Søndagsavis")
 +
 
 +
| Mai
 +
| 1
 +
| 2009/12/04
 +
| DONE
 +
|-
 +
|
 +
Medieforhold og Internet - Daglig læsning af gratisaviser
 +
 
 +
Remowe 0-data from "24-timer" and let the diagram start when there are data. Data does not match IFKA data
 +
 
 +
| Luan
 +
| 1
 +
| 2009/12/04
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Læsning af ugeblade og magasiner
 +
 
 +
This Diagram have severe problems for both Datalines when you compare with IFKA data.
 +
 
 +
| Luan
 +
| 1
 +
| 2009/12/04
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Læsning af tilbudsaviserne
 +
 
 +
Remove legend
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Internetanvendelse
 +
 
 +
Remove 0-data from the lines where no data exists - and IFKA has data older than 2003
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Medieforhold og Internet - Anskaffelse af internetadgang
 +
 
 +
IFKA has data for Sep 07
 +
 
 +
IFKA report: Page 46 (But the grey line in IFKA report&nbsp;is wrong)
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads
 +
 
 +
The diagram has the same shape as the one in tha IFKA report, but the level seems to be higher than IFKas level. Se eg the lowest point in the diagrams and you will find a difference of 4 points
 +
 
 +
IFKA report: Page 14
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|-
 +
|
 +
Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads - Virksomhedstype
 +
 
 +
This diagram looks good - but it is created of data from the above diagram, so perhaps the shares are slightly of
 +
 
 +
IFKA report: Page 15
 +
 
 +
| Luan
 +
| 3
 +
| <br>
 +
| Start
 +
|}

Revision as of 04:54, 3 December 2009

Introduction

Page for CEM Economy

Questionnaires

To do

Description Responsible Priority Deadline Status

Import data for 2009 Q4 back to Access database

We decided to use the old approach one more time for the Q4/2009 report:

  1. Data is collected in Catglobe
  2. Data is exported, cleaned and imported into the old MS Access database
1
Half

Zero data problem. Where are we with a decision for zero data?


2
Paused

Update dashboard: Catinét opinion. By default no parties are shown in the tracking diagram.

The customer must select which parties to view the tracking diagram for, and then click the Update button to show the tracking diagram.


3
Start

Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data.


3
Half

Moving periods.

Casper send us a document with updates related to periods for all diagrams, some diagrams are predicting what will happen the following 3 months based on respondents answers.

Project needed in order to solve the skewed periods, this is also the reason we do not use time sets.
3
Start

Period selection should be implemented.

User should be able to select start and end data as a start.
Later on selections on point size will be an obivious addition.

Thắng is working on a modification for time set which might already be uploaded.

The new time set type is already available on version 5.7, next step is to create a project for version 5.9 which will make it possible to use time sets with tracking diagrams.
4
Start

Segmentation must be multiple.

It must be possible to select multiple age groups and regions.

We need a status from Report on a development project.

The feature is implemented in version 5.8, making a merge back now would probably be a bad idea.
5
Paused

Stylesheet for diagrams.

Review diagram style sheet, diagrams must be less Excel like.

More details needed about what is good and what is bad?
5
Paused

Diagram status

Description Responsible Priority Deadline Status

Politik og bekymring - Tillid til regering/opposition

Missing data that are not missing in IFKA report

IFKA report: Page 7

Anh Duc 3 
Start

Politik og bekymring - Bekymring for udviklingen i den globale økonomi

Diagram are to start when data collection starts in 08/09

Luan 3
Start

Politik og bekymring - Bekymring for fødevarernes kvalitet

REMOVE THE DIAGRAM

Luan 2 
Start

Husstandens økonomi - Husstandens økonomiske situation

Discrepancy between IFKA report and konjunktur on "forurening" in 89-99. IFKA data vener goes beyond -10, but ours do not

IFKA report: Page 18

Luan 3 
Start

Husstandens økonomi - Penge til forbrug

Missing data in several periods

IFKA report: Page 19

Anh Duc 3
Start

Forbrug - Ferie

There are only one period of data for "Ferie i Danmark", so please delete the yellow line up the point where we have data

IFKA report: Page 50

Luan 3
Start

Forbrug - Køb af musik/film på cd/dvd

No data before september 2000 - Remove 0-data and let trhe diagram start in sep 2000

IFKA report: Page 49

Luan 3
Paused

Opsparing, pension, låntagning og investering - Opsparing

Data for the last period must be wrong??

IFKA report: Page 21

Luan 2
Start

Opsparing, pension, låntagning og investering - Investering i aktier

The diagram are not to start before data collection begins which is for september 2009

Luan 3
Start

Opsparing, pension, låntagning og investering - Investering i obligationer

The diagram are not to start before data collection begins which is for september 2009

Luan 3
Start

Opsparing, pension, låntagning og investering - Investering i anparter

The diagram are not to start before data collection begins which is for september 2009

Luan 3
Start

Opsparing, pension, låntagning og investering - Forbrug på kredit

Missing data for some periods, but the data is present in the IFKA reports

IFKA report: Page 24

Anh Duc 2
Start

Personbiler - Antal biler i husstanden

REMOVE THE DIAGRAM

Luan 2
Start

Flytning, bolig og realkredit - Kreditforeningslån

Question tekst is wrong. Again there are shown 0-data for some years in the beginning.

Luan 3
Start

Flytning, bolig og realkredit - Afdragsfrie kreditforeningslån

Question tekst is wrong. Only show diagram from the time data collection began in December 2003

Luan 3 
Start

Boligens indretning - Gennemførelse af større til- eller ombygninger

The first word in the menu and in the headline "Gennemføring" is to be changed to "Gennemførelse". I am not sure that the newest collected data are correct!

IFKA report: Page 33

Luan 2
Start

Boligens indretning - Køb af nyt køkken

I am not sure that the newest collected data are correct!

IFKA report: Page 35, Figure 21

Luan 3
Start

Boligens indretning - Køb af nyt badeværelse

I am not sure that the newest collected data are correct!

IFKA report: Page 35, Figure 22

Luan 3
Start

Medieforhold og Internet - Seere til nyhedsudsendelser

There are shown 0-data for some years in the beginning.

IFKA report: Page 61 (DR1 and TV2)

Luan 3
Start

Medieforhold og Internet - Reklameindslag på radiostationer

There are shown 0-data for some years in the beginning. But no data to compare with

Luan 3
Start

Medieforhold og Internet - Læser avis

Something wrong with the blue line. It shoots to 100%. Othervise, it looks good

IFKA report: Page 63 ("Hverdagsavis" and "Søndagsavis")

Mai 1 2009/12/04 DONE

Medieforhold og Internet - Daglig læsning af gratisaviser

Remowe 0-data from "24-timer" and let the diagram start when there are data. Data does not match IFKA data

Luan 1 2009/12/04 Start

Medieforhold og Internet - Læsning af ugeblade og magasiner

This Diagram have severe problems for both Datalines when you compare with IFKA data.

Luan 1 2009/12/04 Start

Medieforhold og Internet - Læsning af tilbudsaviserne

Remove legend

Luan 3
Start

Medieforhold og Internet - Internetanvendelse

Remove 0-data from the lines where no data exists - and IFKA has data older than 2003

Luan 3
Start

Medieforhold og Internet - Anskaffelse af internetadgang

IFKA has data for Sep 07

IFKA report: Page 46 (But the grey line in IFKA report is wrong)

Luan 3
Start

Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads

The diagram has the same shape as the one in tha IFKA report, but the level seems to be higher than IFKas level. Se eg the lowest point in the diagrams and you will find a difference of 4 points

IFKA report: Page 14

Luan 3
Start

Arbejdsmarkedet - Beskæftigelsesforventninger på egen arbejdsplads - Virksomhedstype

This diagram looks good - but it is created of data from the above diagram, so perhaps the shares are slightly of

IFKA report: Page 15

Luan 3
Start
Retrieved from "http://wiki.catglobe.com/index.php?title=CEM_Economy_Intelligence&oldid=9271"