Difference between revisions of "CEM Economy Intelligence"
(→To do) |
(→To do) |
||
Line 9: | Line 9: | ||
{| class="CGTable" border="1" | {| class="CGTable" border="1" | ||
|- | |- | ||
− | ! Description | + | ! Description |
− | ! Comments from Copenhagen | + | ! Comments from Copenhagen |
! Responsible | ! Responsible | ||
! Priority | ! Priority | ||
Line 24: | Line 24: | ||
#Data is collected in Catglobe | #Data is collected in Catglobe | ||
#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> | ||
| Anh Duc | | Anh Duc | ||
Line 33: | Line 34: | ||
| | | | ||
A special data file for Casper to compare IFKA data with Catglobe data | A special data file for Casper to compare IFKA data with Catglobe data | ||
+ | |||
| <br> | | <br> | ||
| Luan | | Luan | ||
Line 43: | Line 45: | ||
Zero data problem. Where are we with a decision for zero data? | Zero data problem. Where are we with a decision for zero data? | ||
− | Luan: This project will solve the problem: ''VN2798REP - Report style sheet - Setting to display or hide zero values in diagrams''. | + | 2009/12/22 Luan: This project will solve the problem: ''VN2798REP - Report style sheet - Setting to display or hide zero values in diagrams''. The plan is to finish the project on the 4th of January 2010. So the deadline for this task must be put off to at least 3 days after that, thus 2010/01/08. |
+ | |||
| <br> | | <br> | ||
| Thomas, Luan | | Thomas, Luan | ||
| 2 | | 2 | ||
− | | | + | | 2010/01/08 |
| <br> | | <br> | ||
| Start | | Start | ||
Line 56: | Line 59: | ||
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. | ||
− | Luan: Currently, it is impossible to do this! | + | 2009/12/22 Luan: Currently, it is impossible to do this, and there're no plans for making it possible! This explains why this task is on pause. |
+ | |||
| <br> | | <br> | ||
| Luan | | Luan | ||
Line 66: | Line 70: | ||
| | | | ||
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> | ||
| Luan | | Luan | ||
Line 80: | Line 85: | ||
Project needed in order to solve the skewed periods, this is also the reason we do not use time sets. | Project needed in order to solve the skewed periods, this is also the reason we do not use time sets. | ||
− | Luan: A proper project might come later. For now, we will convert all the cross diagrams that show predictions about different periods in the same graph to static diagrams. | + | 2009/12/22 Luan: A proper project might come later. For now, we will convert all the cross diagrams that show predictions about different periods in the same graph to static diagrams. I have received a list of these diagrams, but I won't finish this task before the 31st of December 2009 since some tasks with higher priority just came along. |
+ | |||
| <br> | | <br> | ||
| Luan, Thomas | | Luan, Thomas | ||
| 3 | | 3 | ||
− | | 2009/12/ | + | | 2009/12/31 |
| <br> | | <br> | ||
| Start | | Start | ||
Line 96: | Line 102: | ||
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> | ||
| Luan | | Luan | ||
Line 111: | Line 118: | ||
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> | ||
| Luan | | Luan | ||
Line 124: | Line 132: | ||
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> | ||
| Luan | | Luan | ||
Line 132: | Line 141: | ||
|- | |- | ||
| | | | ||
− | Same Y-axis for weekly/monthly and quarterly data | + | Same Y-axis for weekly/monthly and quarterly data |
+ | |||
+ | 2009/12/22 Luan: One style sheet for one diagram is a bad idea, imagine changing the chart background color, for example, would take a day! In order to finish this task, Casper needs to group similar diagrams together as much as possible based on the fact that they can have the same y-axis scale. Until I have this information, this task is on pause. | ||
+ | |||
| <br> | | <br> | ||
| Luan | | Luan | ||
Line 142: | Line 154: | ||
| | | | ||
Cross tabulation for CEM Economy | Cross tabulation for CEM Economy | ||
+ | |||
| <br> | | <br> | ||
| Luan | | Luan | ||
Line 151: | Line 164: | ||
| | | | ||
Cross tabulation - Adjust width of axis selection boxes to show full text | Cross tabulation - Adjust width of axis selection boxes to show full text | ||
+ | |||
| <br> | | <br> | ||
| Luan | | Luan | ||
| 5 | | 5 | ||
− | | | + | | 2009/02/28 |
− | |||
| <br> | | <br> | ||
+ | | Start | ||
|} | |} | ||
Revision as of 05:52, 22 December 2009
Introduction
Page for CEM Economy
Questionnaires
To do
Description | Comments from Copenhagen | Responsible | Priority | Deadline | Date completed | 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:
|
Anh Duc | 1 | 2009/12/25 | Half | ||
A special data file for Casper to compare IFKA data with Catglobe data |
Luan | 1 | 2009/12/11 | 2009/12/11 | DONE | |
Zero data problem. Where are we with a decision for zero data? 2009/12/22 Luan: This project will solve the problem: VN2798REP - Report style sheet - Setting to display or hide zero values in diagrams. The plan is to finish the project on the 4th of January 2010. So the deadline for this task must be put off to at least 3 days after that, thus 2010/01/08. |
Thomas, Luan | 2 | 2010/01/08 | Start | ||
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. 2009/12/22 Luan: Currently, it is impossible to do this, and there're no plans for making it possible! This explains why this task is on pause. |
Luan | 3 | Paused | |||
Drill down to monthly and weekly data. Add a button which will show weekly data instead, showing 10 weeks of data. |
Luan | 3 | 2009/12/25 | 2009/12/16 | DONE | |
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. 2009/12/22 Luan: A proper project might come later. For now, we will convert all the cross diagrams that show predictions about different periods in the same graph to static diagrams. I have received a list of these diagrams, but I won't finish this task before the 31st of December 2009 since some tasks with higher priority just came along. |
Luan, Thomas | 3 | 2009/12/31 | Start | ||
Period selection should be implemented. User should be able to select start and end data as a start. 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. |
Luan | 4 | 2010/02/26 | 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. |
Luan | 5 | 2010/01/15 | 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? |
Luan | 5 | 2010/01/29 | Paused | ||
Same Y-axis for weekly/monthly and quarterly data 2009/12/22 Luan: One style sheet for one diagram is a bad idea, imagine changing the chart background color, for example, would take a day! In order to finish this task, Casper needs to group similar diagrams together as much as possible based on the fact that they can have the same y-axis scale. Until I have this information, this task is on pause. |
Luan | 5 | 2010/01/22 | Paused | ||
Cross tabulation for CEM Economy |
Luan | 1 | 2009/12/18 | 2009/12/18 | DONE | |
Cross tabulation - Adjust width of axis selection boxes to show full text |
Luan | 5 | 2009/02/28 | Start |
Diagram status
Description | Responsible | Priority | Deadline | Date completed | Status |
---|---|---|---|---|---|
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: I set this to DONE since the diagram doesn't show data in that period. Detecting discrepancy in data is something Casper has started and that should cover the problem here. |
Luan | 3 | 2010/01/08 | 2009/12/17 | DONE |
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: 0-data problem |
Luan | 3 | 2010/01/08 | Paused | |
Opsparing, pension, låntagning og investering - Opsparing Data for the last period must be wrong?? IFKA report: Page 21 Luan: No discrepancies found |
Luan | 2 | 2010/01/08 | 2009/12/21 | DONE |
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: The expressions are correct, and the data doesn't seem unreal. |
Luan | 2 | 2010/01/08 | 2009/12/21 | DONE |
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: The expressions are correct, and the data looks absolutely normal. |
Luan | 3 | 2010/01/08 | 2009/12/21 | DONE |
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: The expressions are correct. Besides, some changes in the past are even more dramatic (e.g. Dec.99) and 2.7 is not the lowest index in history, so the data looks fine to me. |
Luan | 3 | 2010/01/08 | 2009/12/21 | DONE |
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 | 2010/01/08 | Paused | |
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 | 2010/01/08 | Paused | |
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 |
Anh Duc, Luan | 1 | 2009/12/04 | Paused | |
Medieforhold og Internet - Internetanvendelse Remove 0-data from the lines where no data exists - and IFKA has data older than 2003 |
Luan | 3 | 2010/01/08 | Paused | |
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) Series 1: D_Internet_Access Series 2: QQ462_Plan_For_Internet_At_Home |
Anh Duc | 3 | 2010/12/25 | 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 | 2010/01/08 | 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 | 2010/01/08 | Start | |
Politik og bekymring - Bekymring for udviklingen i den globale økonomi Diagram are to start when data collection starts in 08/09 |
Luan | 3 | 2009/12/04 | 2009/12/04 | DONE |
Politik og bekymring - Bekymring for fødevarernes kvalitet REMOVE THE DIAGRAM |
Luan | 2 | 2009/12/03 | 2009/12/03 | DONE |
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: 0-data problem, but hiding the unnecessary periods can do the trick |
Luan | 3 | 2009/12/04 | 2009/12/04 | DONE |
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 | 2009/12/04 | 2009/12/04 | DONE |
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 | 2009/12/04 | 2009/12/04 | DONE |
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 | 2009/12/04 | 2009/12/04 | DONE |
Personbiler - Antal biler i husstanden REMOVE THE DIAGRAM |
Luan | 2 | 2009/12/03 | 2009/12/03 | DONE |
Flytning, bolig og realkredit - Kreditforeningslån Question tekst is wrong. Again there are shown 0-data for some years in the beginning. Luan: Question text was fixed. I didn't see 0-data here. Probably, the problematic periods are hidden. |
Luan | 3 | 2009/12/03 | 2009/12/03 | DONE |
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 | 2009/12/04 | 2009/12/04 | DONE |
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/03 | 2009/12/03 | DONE |
Medieforhold og Internet - Læsning af tilbudsaviserne Remove legend |
Luan | 3 | 2009/12/03 | 2009/12/03 | DONE |
Husstandens økonomi - Penge til forbrug Missing data in several periods IFKA report: Page 19 Series 1: WQ527_Household_Allowance_Compared_To_Last_Year |
Anh Duc | 3 | 2009/12/11 | 2009/12/14 | DONE |
Politik og bekymring - Tillid til regering/opposition Missing data that are not missing in IFKA report IFKA report: Page 7 Series 1: WQ060_Government_Confidence Series 2: WQ140_Opposition_Confidence |
Anh Duc | 3 | 2009/12/11 | 2009/12/14 | DONE |
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 Series 1: QQ025_Purchases_On_Credit_Last_3_Months Series 2: QQ026_Purchases_On_Credit_Next_3_Months |
Anh Duc | 2 | 2009/12/11 | 2009/12/14 | DONE |
Medieforhold og Internet - Læsning af ugeblade og magasiner This Diagram have severe problems for both Datalines when you compare with IFKA data. Series 1: QQ172_Weekly_Magazines Series 2: QQ215_Magazines |
Anh Duc, Luan | 1 | 2009/12/04 | 2009/12/14 | DONE |