| 1 |
"E-tailing" - Click analysis for online shopping profiling |
Bernd Drewes |
Presentation |
proc freq, group by, link analysis |
source |
24 |
| 2 |
A crystal ball for forecasting cellular sales |
Adrian Mattioli, Margie van Straten |
Presentation |
data warehouse, sql server |
source |
20 |
| 3 |
A Design Framework for Combining Click Stream and Customer Data for an e-CRM Solution |
Mark Ansell |
Presentation |
dimension table, fact table, staging area, foreign key, txt, lookup, key |
source |
21 |
| 4 |
A dynamic approach to the segmentation of financial customers |
Paolo Frassetto, Valeria Severini |
Presentation |
customer segmentation |
source |
23 |
| 5 |
A FMCG Company embracing the new challenges of CRM and Marketing Automation |
Kerstin Plehwe |
Presentation |
service provider, data mining, cross-sell, data cleaning |
source |
22 |
| 6 |
A New Decision-Making Support Analysis for the Auditing Area at Banca Monte Dei Paschi Di Siena |
Francesco Marzocchi, Renato Coppi, Roberto Tognazzi |
Presentation |
data mining, credit risk, covariance, regression analysis, proc princomp, correlation |
source |
28 |
| 7 |
A prototype of Quality Data Warehouse in Steel Industry |
Camilo De Vecchis, Maria Murri |
The final product quality is one of the fundamental aspects in steel industry. Because of this it became more and more important to prove the product quality, to look for the causes of all quality defects and to discover the relationships between product properties and production process parameters. Further, in order to verify the product quality in terms of 'customer satisfaction', it is important to investigate the relationships between product properties and sold/refused products. To solve these tasks it is on one hand necessary to handle information and data factory in a wide form and on the other hand to have powerful tools to analyse and interpret them. The work describes a Quality Data Warehouse (QDW) prototype, developed using SAS/WAREHOUSE Administrator V8, realised for a steel plant of tinplate production |
fact table, data warehouse, dimension table, star schema |
source |
5 |
| 8 |
A retrospective evaluation of a data mining approach to fetal asphyxia at delivery in a hospital database |
Olavi Kauhanen, Seppo Heinonen |
Presentation |
neural network, logistic regression, data mining, sample, logistic distribution, regression analysis, proc hpsplit |
source |
53 |
| 9 |
A simple SAS-based search engine |
Hayo Hasselmann |
Presentation |
order by, macro loop, output delivery system |
source |
12 |
| 10 |
A System for Monitoring and Analysing Legal Actions |
Roberto Noceta |
Presentation |
data science, forecast, sas consultant, trend analysis, sensitivity analysis, excel |
source |
18 |
| 11 |
A web interface for portfolio risk optimisation with SAS System |
Giuseppe Marcon, Maria Rita Pepe |
This article wants to illustrate an ongoing project by Simbologica S.r.l./Up-Tecno group (SIMBOLOGICA) implemented using the SAS System, whose goal is to optimise a client portfolio controlling its risk through the selection of investing funds offered by a single bank. A number of web pages are dynamically created with the intention of including them in the banks web sites currently developed and maintained by SPF SpA (Soluzioni e Prodotti per la Finanza) . Results for the evaluation of portfolios by means of various indicators (e.g. monthly returns, value at risk, Sharpe index) are presented in table formats and through CSF style-like images. A web page allows the selection of optimisation criteria, like the choice to retain funds or discard them, the choice of categories of investments and the maximum level of risk permitted in the resulting portfolio |
numeric functions, variance, portfolio risk, proc step, standard deviation, available balance, sas risk engine, time series analysis, proc reg |
source |
14 |
| 12 |
A Web-based application for Bosch Siemens: European Price Monitoring (EPM) |
Bernd Brodersen, Clemens Kraus |
Presentation |
business intelligence, master data management |
source |
18 |
| 13 |
Account profiling for improved collection results |
Sharief Allie |
Presentation |
macro flow control |
source |
26 |
| 14 |
Achieving Profitable Credit Management Strategies |
Sharief Allie |
Presentation |
customer profitability |
source |
22 |
| 15 |
Advantages and Disadvantages of Using SAS/MDDB, HOLAP, and SAS/IntrNet in the Development of an Interactive System |
Lori A. Guido |
Presentation |
format statement, view |
source |
64 |
| 16 |
Air Deal Manager: an end-to-end travel & expense management solution with SAS Software |
Dionino Di Florio, Fabio Luzzi, Giuseppe Marcon, Jennifer Leech, Maria Rita Pepe |
This paper describes a series of advanced functions in Air Deal Manager (ADM), a software application developed using the SAS System to provide decision support for the Travel and Expense's (T&E) air travel purchasing management processes. ADM was developed by the Consulting Services group at American Express Europe Ltd. London (Amex), with the leading support of Simbologica S.r.l./Up-Tecno group (S IMBOLOGICA), an Italian SAS System Quality Partner with a long experience in the exploitation of the power of the SAS System. Evolved over the last two years, Air Deal Manager automates most of the air travel purchasing management decision process and finds the best air travel solutions for Amex Corporate Clients to achieve optimal goals in term of expense reduction and quality of service |
discriminant analysis, dataset, proc discrim, proc step, variable, linear programming, by group processing |
source |
20 |
| 17 |
An approach to the risk management of structured financial products |
Marco Cammi |
The core of any risk management information system is always an analytical engine working according to a specific approach to calculate value-at-risk indicators. In this paper a description of relevant financial modeling issues and their implementation in the context of the risk management information system of Gruppo Monte dei Paschi di Siena will be presented |
sas risk engine, mis, management reporting |
source |
5 |
| 18 |
An Ark on the sea of data of the small and medium sized company |
Annarosa Busetto, Luisa Agostinis, Simonetta Finoli |
Presentation |
excel, business intelligence, data mart, batch job, sas data integration studio |
source |
41 |
| 19 |
An End To End Personalisation Framework For Multi Channels |
Turlough Fitzpatrick |
Presentation |
|
source |
23 |
| 20 |
And The CRM myth becomes reality |
Christophe Bonnart, Colpin Philippe |
Presentation |
business intelligence, data mart, key performance indicator, customer profitability, customer retention, excel |
source |
40 |
| 21 |
Asset and Liability Management |
Sanja Vuckovic |
Presentation |
sas risk engine, excel, proc step, proc sql, risk exposure, dataset, create table |
source |
38 |
| 22 |
AstraZeneca's AWACS IntraNet: Remote sensing of the sales force |
Johan Velema, Willem Boersma |
Presentation |
pharmaceutical industry, put statement |
source |
27 |
| 23 |
Balanced Scorecard with "Strategic Vision" - the story of Samsung Corning Germany |
Joachim Esser |
Presentation |
|
source |
23 |
| 24 |
Being the biggest - Becoming the best |
Michał Michalak |
Presentation |
data wrangling, business intelligence, data mart, data mining |
source |
20 |
| 25 |
Beyond the Chip - Building Solutions for the Customer |
Giovanni Chiabrando |
Presentation |
data mining |
source |
21 |
| 26 |
BNL's experience in building an internal rating system for domestic corporate customers |
A. Pellegrini, G. Parrillo, G. Porcelli |
The original approach of the Basel Committee, in its revision of banks' minimum capital requirements, tended to favour the use of ratings by international rating agencies. This approach would have favoured the Anglo- American banks penalising banks based in countries where the ratings of external agencies have a limited diffusion (i.e. emerging economies or countries, like Italy and Japan, characterised by an economic structure dominated by small enterprises, which have a preference for bank debts rather than other types of financing). Recently, the Basel Committee has changed its position, putting the Internal Rating Systems (IRS) of the banks on par with the products of the rating agencies, on condition that the former were validated by the national control authorities |
credit risk, mcr |
source |
4 |
| 27 |
Broadcasting Network WEB site Traffic Analysis |
Donatella Gandino |
Presentation |
key performance indicator, format statement, data science, web service, correlation |
source |
37 |
| 28 |
Building a Balanced Scorecard in Banca 121 |
Alessandra Turi |
Presentation |
financial services, liquidity gap, phase i, phase ii, phase iii |
source |
23 |
| 29 |
Building a compelling case for Enterprise Miner Within The Bank of Scotland |
Simon Hughes |
Presentation |
data mining, proc hpsplit, neural network, sample, model deployment, txt, data cleaning |
source |
33 |
| 30 |
Building JSP based MDDB viewers with webAF 2.0 |
Anton Fuchs |
Presentation |
|
source |
26 |
| 31 |
Business Process Management: A Key IT Management Challenge |
Daniel J. Squillace |
Presentation |
capacity planning, insurance claims, correlation |
source |
28 |
| 32 |
Capacity planning for your telephone systems: A case study from Den Danske Bank Or From 5 weeks to 1 minute |
Morten Halver |
Presentation |
capacity planning |
source |
20 |
| 33 |
Chronographic Segmentation - a new life cycle approach to banking customer data analysis |
Furio Camillo, Stefano Zecchi |
Presentation |
customer profitability, customer lifetime value, probability distribution, proc lifereg, proc step |
source |
22 |
| 34 |
Closing the Loop - Using SAS to drive CRM Integration |
Anton Hirschowitz |
Presentation |
customer lifetime value, data warehouse, campaign response, data mining, data mart, sas enterprise guide |
source |
32 |
| 35 |
Common tool for the Purchasing Headquarters applications |
Gerard Vignaud, Serge Vanborre |
Presentation |
excel, data cleaning |
source |
23 |
| 36 |
Configuring a SAS Data Campus Using an EMC E-Infostructure |
Freda Cameron, Martin Stiegler, Paul Padley |
Presentation |
sas log, data protection, sas library, dataset, data warehouse, libname statement, permanent library |
source |
66 |
| 37 |
Constructing a time series using PROC SUMMARY and a multi-label format |
Hans Thomsen |
Presentation |
proc means, proc step, account, proc format, time series analysis, transaction data, work library |
source |
23 |
| 38 |
Cross-selling of insurance products |
Flavio Bonifacio, Oreste Porreca |
The information owned by an Insurance Company is frequently appreciated and used for CRM, from target analysis to customer satisfaction. Last year we spoke about the use of this kind of information by a Bank. Now we will speak about its exploitation by the Insurance Company itself. The cross-selling mode points to the identification of customers of new products (for example the Target Product) among clients based on characteristics well known to the company. One of the characteristics being the insurance products already purchased. This study presents two complementary ways of identifying the most potential customers: the first one, which we refer to as the external way, compares two selling channels in order to identify differences in customers due to the selling channel. This kind of analysis uses information related to the clients that RMA acquires by means of another selling organisation. The second way analyses data that Reale Mutua Assicurazioni acquires by means of its own selling network (internal channel) in order to identify which pattern of products already owned is the best predictor for future buying behaviours. |
proc freq, sample |
source |
6 |
| 39 |
Current and Future Directions for Analytical Solutions |
Alan Eaton |
Presentation |
|
source |
44 |
| 40 |
Customer Profiling as an integrated system in order to know and interact with the customers |
Angelo Marvaldi |
Presentation |
confidence level |
source |
20 |
| 41 |
Customer Profiling System in Telecom Italia Mobile |
Claudio Bocci, Gianni Santerini |
Presentation |
excel, load, data standard, binary variable, scoring, raw data, data science |
source |
44 |
| 42 |
Customer Segmentation and retail product assortment |
Barry Young |
Presentation |
data mining, customer segmentation, euclidean distance, liquidity gap, numeric variable |
source |
18 |
| 43 |
Customer's service and technical point of view: the mix of two worlds |
Olivier Wilm |
Presentation |
quality of service, oracle, data step, dataset, capacity planning, capacity utilization, flat file |
source |
25 |
| 44 |
D.R.I.V.E.R. |
Barbara Brusegan |
Presentation |
distribution channel, data mart, correlation, sas base, batch job, customer segmentation, group by |
source |
14 |
| 45 |
Data Mining as Method to Streamline the Drug Discovery Process |
Markus Duerring |
Presentation |
sample, confidence interval, sample size, correlation, data mining, poisson distribution, phase iii |
source |
20 |
| 46 |
Data Mining at CDG Bank: an advantage or a requirement? |
Elisabete Silva, Henrique Nicola |
Presentation |
data mining, credit card, business intelligence, neural network, market basket analysis, current account, churn |
source |
25 |
| 47 |
Data Mining In a Zero Latency Enterprise |
Philip Bosinoff |
Presentation |
data mining, credit card, card fraud, confusion matrix, sample, neural network, outlier, data validation rules, response variable, proc hpsplit, network optimization, prior probability, model deployment |
source |
36 |
| 48 |
Data Warehouse and Strategic Management - How to Sustain Competitive Advantage |
Karin Nischk, Wolfgang Hofbauer |
Presentation |
insurer, loss ratio, data standard, data warehouse, health insurance |
source |
31 |
| 49 |
Data Warehouse Evaluation: Reliability in the Aircraft MRO Industry |
Philipp Mengis |
Presentation |
sas enterprise guide, ledger, service provider |
source |
31 |
| 50 |
Data Warehouse Implementation in Financial Statistics using SAS at State Statistical Office of Republic of Macedonia |
Lidija Petkovska, Valentina Jankovik |
Presentation |
health insurance, data science |
source |
49 |
| 51 |
Data Warehouse Technology As The Main Building Block of the Modern IT Strategy of the Polish Customs Adminstration |
Andrzej Tyrowicz |
Presentation |
data warehouse, sas risk engine, metadata management, business intelligence, data mining, data standard |
source |
34 |
| 52 |
Delivering Clinical Study Data Using SAS/IntrNet |
Barrie Nelson, Robert Davis |
Presentation |
macro variable, clinical data, clinical trial |
source |
28 |
| 53 |
Detecting Procurement Fraud |
Jennifer Major |
Presentation |
output delivery system, random sampling, payment fraud, logistic distribution |
source |
33 |
| 54 |
Develop The Enterprise Data Warehouse as a New Instrument For a Banking Governance |
Gianni Fuolega, Mario Migliori |
Presentation |
management reporting, mis, credit risk, db2 |
source |
29 |
| 55 |
Developing Wireless Applications using AppDev Studio 2.0 |
Stephan Haux |
Presentation |
|
source |
14 |
| 56 |
Driving CRM with Customer Intelligence |
Adrian Reynolds |
Presentation |
sample, customer profitability, quality of service, customer retention, insurer, profitability analysis |
source |
28 |
| 57 |
Dynamic behaviour profiling to derive cusomter management |
Bayan Dekker |
Presentation |
customer retention, customer satisfaction |
source |
19 |
| 58 |
Dynamic Budgeting & Plannin |
Peter Bull |
Presentation |
cash management, customer profitability, customer satisfaction, data standard, financial reporting, product profitability, profitability analysis |
source |
33 |
| 59 |
e-Intelligence and e-CRM in a competitive new economy |
Dorte Ransby |
Presentation |
data mining, proc freq, business intelligence, market basket analysis, data validation rules, customer retention, customer satisfaction |
source |
27 |
| 60 |
E-Intelligence and Nokia Online Services |
Rosemarie Ruotto |
Presentation |
phase i, phase ii, phase iii, phase iv, web service |
source |
19 |
| 61 |
E-St@rt (Statistics in the Net) |
David Christian Dayan, Guiseppe Marcon, Simona Vezzosi |
We are just coming out of a revolution. A revolution carried into effect as quickly as if it seems that the whole scenery of a society was not changed: a deep rebuilt, needed before the same traditional Market impose it. Let's think about all the tools which are today within the reach of everybody; could we propose a "yesterday newspaper"? Well, this is our contribution to the revolution: canalize the information and make it "alive": share all the main sources of analysis (in credit and finance), presenting them to all users in an electronic, drillable, exhaustive and above all continually updated format. Reset of the distances, satisfaction, evolution, freshness, no shock for the users, mould ability: this is our formula to go beyond papers and their well known logistic and cost problems. Our belief in e-warehousing success, the balance between costs and benefits, the need of a fast, safe, efficient and reliable tool have made us choose SAS Web solution once again |
|
source |
6 |
| 62 |
Economical monitoring and forecasting system of Russian railways |
Konstantin Lista |
Presentation |
data mart, econometrics |
source |
16 |
| 63 |
eDiscovery: The SAS Solution for eCRM |
Alan Gormley |
Presentation |
data warehouse |
source |
30 |
| 64 |
Electronic Information System (EIS) - Past, Present, Future |
Ruth Brogan |
Presentation |
management reporting, phase i, phase ii, phase iii, phase iv |
source |
34 |
| 65 |
Empowering the purchasing professional: The SAS solution for Supplier Relationship Management |
Brigitte Ley |
Presentation |
data mining, data mart, extract |
source |
17 |
| 66 |
End to end datawarehousing with SAS at steel rolling company ALZ |
Kris Vranken |
Presentation |
proof of concept, business intelligence, sql server, excel, proc sql |
source |
17 |
| 67 |
Enriching Click Stream data from other sources - What are the benefits and how is it done |
Ismo Saukkonen |
Presentation |
management reporting |
source |
19 |
| 68 |
Ensuring SLOs and SLAs - How to commit computer resources to SAS applications, jobs and users |
Udo Schmitt |
Presentation |
resource allocation, %if-%then-%else, batch job, cpu time |
source |
24 |
| 69 |
Enterprise cancer registry |
Romor Pierantonio, Vicario Gianni |
The purpose of this project was the analysis of the requirements necessary for the realization of an automated system to determine the cancer incidence starting from the data available in the medical information database. The example given refers to the accomplishment of a population cancer registry in Friuli Venezia-Giulia, a region in the north-east of Italy. The starting information base consists of an epidemiological data warehouse, realized with SAS , where both the reference source and their report are kept. The quality controls have been carried out by using interfaces developed in SAS/AF . The results show that, thanks to pre-existent data base, the development of computerized algorithms to determine the incidence, and the realization of computer programs for the assisted resolution of the cases, new opportunities are given to cancer registration at lower cost and more timely than in the past |
record linkage, data warehouse |
source |
4 |
| 70 |
Enterprise Guide: Delivering Information to the People Who Need to Know |
Adrian Bruty |
Presentation |
sas enterprise guide, format statement, business intelligence, random sampling, proc sql, data cleaning, flat file |
source |
21 |
| 71 |
Enterprise Wide Information Delivery with ODS |
Achim Granzen, David W. Kelley, Paul Kent |
Presentation |
sas base, proc step, sas output |
source |
13 |
| 72 |
Evolution of the Data Warehouse at the Russian Railways |
Igor Movchikov |
Presentation |
irregular component, prediction interval, seasonality, data science, time series analysis, proc freq |
source |
24 |
| 73 |
Expanding SAP capabilities in maintenance |
Henning Lillejord, Pål Navestad |
Presentation |
data mart, order by |
source |
13 |
| 74 |
Exploiting and extending the Multi Vendor Architecture |
Achim Granzen |
Presentation |
proc step, proc sort, proc means, data wrangling, data mining, data mart, proc reg |
source |
52 |
| 75 |
Fast integration of Enterprise Guide and Enterprise Miner with WebHound |
Klaus-Peter Huber, Rainer Urbahns |
Presentation |
data mining, sas enterprise guide, group by, phase i, phase ii, phase iii, response variable |
source |
12 |
| 76 |
First Aid for Legacy Data Warehouses - Common Symptoms and their remedies |
David Porter |
Data warehousing has been around for long enough to be seen as part of the same problem that it set out to cure. Legacy warehouses are slowing down to walking pace under the weight of years of stored data, front-end screens once state-of-the-art are now being criticised for not being 'windowy' enough. In these days of faster is better, batch driven warehouses are seen as arcane, the future is seen as live warehouses with the database being both transactional and historical. In this short paper I would like to offer a few tips to those nursing legacy systems and who want to 'pep' them up a bit, and hopefully save a few systems from being replaced unnecessarily. |
data warehouse, data mart |
source |
3 |
| 77 |
Football and data mining: a statistical system for a "real-time" monitoring of players' performance in the European Championships |
Furio Camillo, Stefano Sforza |
The paper aims to present various statistical models for the monitoring in real time of what happens in a football match. In particular, we discuss an evolution in terms of data-mining of the Digital Soccer System which has been used from some RAI journalists to discuss and to give a commentary on the games of the last European Football Championships. The research, and the experimentation of the used statistical models, have been entirely carried out in SAS environment, beginning from Software specific of "real-time survey" of what happens during the games, and of geo-reference, on the field, of all the noticeable athletic gestures according to previously defined technical codes. We try to show how it has been possible, working within the SAS environment and moving with a "Data-Mining approach" to implement models of synthetic appraisal and monitoring of the performance of a single soccer player during one sport competition like Euro2000 |
|
source |
6 |
| 78 |
Framework for setting up a self-organizing portal through Web Mining |
Christine Schweizer, Frank Sauberlich, Klaus-Peter Huber, Rainer Dorfler |
Presentation |
|
source |
37 |
| 79 |
Fraud Detection in Healthcare - MBF's successful approach through SAS South Pacific Data Mining Discovery Centre |
Jolie Reichel |
Presentation |
data mining, outlier, correlation, missing value, stratified sampling, feature selection, health insurance |
source |
14 |
| 80 |
From data warehouse to reports warehouse: a case study |
Gady Kotler |
Bank Tefachot, Israel's largest mortgage bank is using SAS for it's entire financial reporting, branch analysis and risk management for many years. SAS v8 has been installed on the bank's UNIX server during 2000 and immediately has created a need for Web reporting in all branches around the country. The Data warehouse team from EIS Ltd. has built a unique solution called SIGMA/Web that maintains a Reports Warehouse. Users can view reports generated periodically using SAS ODS and to send, via a web browser interface, requests for the SAS Unix server to be processed on-line. Each user can publish a SAS report to be viewed by other members under certain security limitations. A SAS published report can be enhanced by up-loading a WORD or EXCEL documents or other web formats. These documents along with the SAS reports, formulates a complete publication that is cataloged under Sigma/Web SAS application |
stored procedure, ods html, excel |
source |
5 |
| 81 |
From e-data to web mining |
Said Nechab |
Presentation |
customer segmentation, market basket analysis |
source |
46 |
| 82 |
From GaAs to Mobile Phones: the Implementation of a Quality Warehouse |
Paul Burgess |
This paper describes the experiences of Filtronic Compound Semiconductors LTD in implementing a data-driven yield management system to support the delivery of its RF products fabricated in Gallium Arsenide to customers in the telecommunications sector. Key business requirements were the rapid delivery of working prototypes to prospective customers, followed by a rapid stabilisation of the production process. In spite of the need to utilise manufacturing technology that is out of the mainstream of semiconductor manufacturing, this paper shows how these requirements were successfully supported through the development and deployment of a custom solution built using SAS technology for data warehousing and exploitation. Implementation was achieved in a relatively short time frame and in a cost effective manor, to successfully achieve the initial business requirements |
data warehouse, proc freq |
source |
6 |
| 83 |
From Oracle to SAS: converting a large data warehouse |
Clare Somerville |
In January 1996, the New Zealand Ministry of Social Policy implemented its data warehouse. The data was stored in Oracle; SAS was used for all data manipulation, cleansing, verification, analysis and reporting, and for updating the Oracle database. Since that time, the warehouse has grown. There are now multiple data sources, with more users from more government departments. Two Oracle databases are in production, and they total around 500 GB in size. In this environment there are many features of Oracle that we don't use; and a couple of features that we do: views to set security levels, and the ability to update and query at the same time. But there are serious drawbacks to the use of Oracle - like query performance times that are up to ten times slower than SAS. This paper covers some of the issues encountered in converting a large Oracle based data warehouse into SAS |
dataset, proc step, proc sql, view, oracle, attrib statement, key, modify statement |
source |
8 |
| 84 |
Fuzzy key linkage: robust methods for real databases |
Sigurd W. Hermansen |
Results of data mining depend heavily on the quality of linkage keys within a search dataset and within its database target. Linkage failures due to errors or variations in linkage keys have few symptoms, and can hide or distort what data have to tell us. More robust methods have promise as remedies, but require careful planning and understanding of specialized technologies. A tour of fuzzy linkage issues and robust linkage methods precedes a review of the results of a recent linkage project. Sample SAS programs include tools and tips ranging from SOUNDEX() and SPEDIS() functions to hash indexing macroprograms. |
proc sql, dataset, key, record linkage, %if-%then-%else, proc step, macro variable, data cleaning, parallel processing, macro definition, proc freq |
source |
13 |
| 85 |
GIS IP Web: enchancing customer serive via Internet |
Lucien Hofmann, Torsten Rosenkraenzer |
Presentation |
business intelligence, phase i, phase ii, phase iii, property insurance |
source |
20 |
| 86 |
Giving the Users what They Expect |
Jeremy Gurney |
SAS/AF software provides an applications development environment for the creation of Graphical User Interface (GUI) applications for the SAS system. AF applications can provide both the convenience of the GUI environment and the full functionality of the SAS system. This paper presents a discussion of how AF applications can be modified to mimic the presentation and functionality of common desktop applications |
sample, dataset |
source |
9 |
| 87 |
Globization and National Language Support for Your Release 8.2 SAS Environment |
Manfred Kiefer, Steve Beatrous |
Presentation |
|
source |
54 |
| 88 |
Group Services Portal Project Web Warehousing - Suppliers |
Angela Rinaldi |
The Consorzio Cooperative Costruzioni (Group of Construction Cooperatives) is one of the primary groups in the national construction sector. There are more than 240 associated cooperatives who operate in the fields of construction, transport, services, industry, and construction materials. They include large, nation-wide cooperatives, and small and medium sized cooperatives, and give an overall occupation to more than 20,000 operators, for an annual turnover of more than 6,000 billion lira. This portal represents the tool prepared by the CCC to promote, through the Web, the exchange of information and the comparison of opportunities with other operators in the field. The Web project is addressed in general to the construction field, from Public Bodies to Contracting Stations, from the Banking System to the Insurance System, from design companies to the individual practitioners, from the representative structures of the construction companies to the individual companies which can, in turn, become partners or potential competitors of the Group itself. |
|
source |
8 |
| 89 |
Having trouble with your strategy? ... then map it! |
Helmut Maderbacher |
Presentation |
|
source |
26 |
| 90 |
How our local vision can change the strategy in Copenhagen from buying solutions for local development |
Sven Gaffron |
Presentation |
excel |
source |
22 |
| 91 |
How Strategic Vision Successfully Increases the Quality of a Balanced Scorecard System |
Markus Laub |
Presentation |
liquidity gap, key performance indicator |
source |
15 |
| 92 |
How the Output Delivery System made UCAS Data 'Sing' |
Gaie Davidson-Burnet, Liz Peters, Richard Coleman |
Presentation |
output delivery system, proc step, ods html |
source |
27 |
| 93 |
How to approach a segmentation project for ten million customers with SAS Enterprise Miner |
Luis Miguel Muruzabal |
Presentation |
data mart, sample, data mining, missing value, data cleaning, sample size, imputation |
source |
26 |
| 94 |
How to benefit from SAS investments over time |
Nicolas Bull |
Presentation |
proc report, proc step, data cleaning, customer satisfaction, db2 access, ods excel, phase ii |
source |
26 |
| 95 |
How To Find Your Way Around A Customer Database |
Alberto Saccardi, Fabio Marchetti |
Presentation |
data mart, data mining, account, credit card, data standard, consumer loan, data warehouse |
source |
24 |
| 96 |
How we implemented balanced scorecard with the company's strategy, together with follow-up programme |
Anders Finckenhagen |
Presentation |
|
source |
24 |
| 97 |
Implementation of e-intelligence Solutions for Internet Service Providers |
Enzo Ferrari |
Presentation |
quality of service |
source |
19 |
| 98 |
Implementing a BSC in a changing environment of Social Security |
Grieko Enter |
Presentation |
quality of service, premium, quality assurance, proc freq |
source |
26 |
| 99 |
Implementing a Service Level Management Framework - A Case Study |
Andreas Moren |
Presentation |
service provider |
source |
17 |
| 100 |
Implentation of an outlier detection method for hihg throughput screening in drug discovery |
Ronny Schrijvers, Rudi Verbeeck |
Presentation |
outlier, type ii error, proc freq, proc univariate, dataset, sas base, output delivery system |
source |
23 |
| 101 |
Improvements Made with Output Delivery System in Data Processing |
Maja Ledic Blazevic |
Croatian Bureau of Statistics (CBS) prepares and carries out majority of statistical surveys in Republic of Croatia, which are described in the 'Act on the National Statistics'. This paper will discuss some experiences and improvements made with SAS in processing, analysis and publishing of statistical data in some surveys. Methodologies used for statistical surveys in CBS are based on such principles and standards that ensure comparability of statistical indicators with other countries. For some of surveys CBS took over methodology of EUROSTAT. Two of them that have significant importance are Labour Force Survey and Household Budget Survey. Main goal for those two surveys was to prepare publications with results comparable to other European countries. SAS was chosen as most suitable tool to reach that goal. This paper will not discuss any aspect of methodologies for those surveys and it will focus only to usage of SAS. |
proc tabulate, proc step, output delivery system, excel, dataset, sample |
source |
5 |
| 102 |
Improving Datamining Results Through Data Selection and Preparation |
Hein Lochner, Nigel Wigram |
Presentation |
sample, response variable, regression analysis, neural network |
source |
49 |
| 103 |
INFACT: a web-based solution to meeting the demands for public access to data collected at the public's expense |
Carol Calvert |
Presentation |
dataset, sas programming |
source |
7 |
| 104 |
Integrated Customer Call Information |
John Nysse |
Presentation |
churn prediction, cell site, cluster analysis, staging area, data validation rules, dropped call, call records |
source |
45 |
| 105 |
Integration of campaign management and data mining at MTN South Africa |
Marcelle Georgiev, Mohan Namboodiri |
Presentation |
data mart, churn prediction, data mining, confidence level, campaign response, credit card, marketing mix |
source |
22 |
| 106 |
Intelligently screening New Business |
Paull Lawrence |
Presentation |
lapse rate, sample, excel |
source |
30 |
| 107 |
International Mail Order Business |
Wil Amian |
Presentation |
data mining |
source |
22 |
| 108 |
Intranet-based Information Delivery at Central-European International Bank |
Eva Habori |
Presentation |
data warehouse, management reporting, customer profitability, data wrangling, raw data |
source |
25 |
| 109 |
Introducing SAS Data Quality |
Matthias Boge |
Presentation |
|
source |
35 |
| 110 |
IT Management Solutions - Strategic Directions |
Richard Seery |
Presentation |
capacity planning, output delivery system, data governance, management reporting, service provider, sample |
source |
22 |
| 111 |
IT Service Management - Case Study |
Jani Pusenjak |
Presentation |
proof of concept |
source |
26 |
| 112 |
IT Service Vision: pushing back the limits of the Quick-Start Wizard |
Julien Vanhemmens, N. Lanaerts, T. Le Tri |
Presentation |
output delivery system, batch job, capacity planning |
source |
25 |
| 113 |
IT Service Vision: Strategic Business Reporting |
Brian Watts |
Presentation |
reporting, elapsed time, sas enterprise guide |
source |
45 |
| 114 |
Kaleidos - A Splash of Colour for the "Silvery Haired" |
Guido Cuzzocrea, Ignazia Vitali, Linda Pimpinelli, Salvina Piccarreta |
Presentation |
sample, cluster analysis |
source |
32 |
| 115 |
Knowledge Solution for Credit Scoring |
Henrik Wagner |
Presentation |
data mining, credit scoring, logistic regression, proc hpsplit, logistic distribution, regression analysis, consumer loan |
source |
26 |
| 116 |
Knowledge Solution for the SAP R/3 IT Management |
Christine Ritter |
Presentation |
dataset, data dictionary, extract, data warehouse, sas base, sample |
source |
24 |
| 117 |
Kompass 24 - A Balanced Scored of Deutsche Bank 24 |
Jorg Hohling |
Presentation |
investment banking |
source |
26 |
| 118 |
linked objectives: CRM and e-CRM as part of the information network |
Fabian Doring |
Presentation |
credit card, loan |
source |
30 |
| 119 |
Liquidity Monitoring and Analyses System |
V. E. Sorokoumov, V. V. Konuzin, V. V. Pakhomov |
The Savings Bank of Russian Federation is the largest financial institution in the country and is believed to be the largest retail bank in the world in terms of number of customers (more than 100mln private clients), branches (12 000) and employees (more than 200 000). It has a spread across the entire Russian Federation from Vladivostok to Kaliningrad covering 8 time zones. Variety of services provided by Sberbank has made it a truly universal financial institution. The range of services by Sberbank includes FX, equity and commodity trading, financing domestic industries, corporate and private credit services, account management, credit card servicing, internet trading, etc. |
proc sql, data wrangling |
source |
6 |
| 120 |
Macro encapsulation add-in tool for SAS/Warehouse Administrator |
Anders Holte |
The tool has four main functional areas: Simple job flow control, dynamic naming of input and output tables and variable names, simple source browser / editor, and a utility class. An add-in code generator builds the job stream a related add-in defines necessary extended attributes and features. Separate job steps or table load steps, user written or WA generated, are all covered by the tool. Fetures: Simple job flow control is obtained by putting some intelligence before and after the job step in the job stream. The job step should run depending on the success of another step. Return codes for job steps may be stored in a log data set for job control. Dynamic naming of tables and variables is done by inserting macro variables containing the names retrieved from the metadata into the job stream |
macro variable, sysrc, exception handling, macro definition |
source |
17 |
| 121 |
Magellano-Statistics on-line |
A. C. Catitti, A. Tazzi, L. Cococcia |
Presentation |
output delivery system |
source |
36 |
| 122 |
Management Information and Balanced Scorecard in Arhus Kommune (Municipality) |
Henning Pedersen |
Presentation |
|
source |
18 |
| 123 |
Managing Legal Reporting Requirements: A Total Financial Management Strategy |
Peter Bull |
Presentation |
financial reporting, management reporting, audit trail |
source |
32 |
| 124 |
Measuring and Managing Human Capital for Improved Performance |
Betty Silver |
Presentation |
|
source |
17 |
| 125 |
Mining the earth's diamonds: SAS' role for information delivery and knowledge advancement |
Dave Apter |
Presentation |
proc gplot, sample |
source |
34 |
| 126 |
Minng-Driven Marketing - Penetrating Telco-Markets Successfully |
Gunter Witsch, Markus Ehl |
Presentation |
customer segmentation, business intelligence, data mining, regression analysis |
source |
19 |
| 127 |
Modelling web trajectories of portal customers by mining clickstream data |
Angela Rinaldi, Furio Camillo |
Presentation |
sample |
source |
23 |
| 128 |
Multi-objective modelling of decision making problems using SAS software |
J. Pietrzykowski, J. Granat, P. Witan |
Presentation |
data science, output delivery system, proc step, data governance, data standard |
source |
30 |
| 129 |
Navigating the New Economy - How analytics and strategy Keep your business on course and moving forward |
Jonathan Hornby |
Presentation |
kyc, correlation |
source |
19 |
| 130 |
New Features and Future Directions for Enterprise Miner |
David R. Duling, Gerhard Held |
Presentation |
data mining, time series analysis, link analysis, model deployment, outlier, k-nearest neighbors, proc princomp |
source |
31 |
| 131 |
New Visualisation in 8.2 |
Stuart A. Nisbet |
Presentation |
ods rtf, time series analysis, ods html, ods pdf, response variable, series plot, time variable |
source |
32 |
| 132 |
Nokia activating m-Intelligence |
Jukka Riivari |
Presentation |
|
source |
27 |
| 133 |
OLAP Best Practices - What You Need to Consider When Building and Deploying an OLAP Application |
Adrian Bruty |
Presentation |
business intelligence, proc sql, sas enterprise guide, sql server, star schema, proc step |
source |
35 |
| 134 |
Overcoming Cross-Platform Issures using SAS/Connect and Java |
John M. LaBore, Michael J. Pell, Randy Curnutt |
Integrating multiple hardware/software technologies is a problem common in large organizations. End users often must be technically savvy to accomplish tasks requiring transactions on more than one platform. For example, statisticians may spend a great deal of time with 'systems programming', when they should be doing what they were hired to do: analysis and experimental design. We explore different methods using SAS/CONNECT and Java to simplify day-to-day tasks of end users. Java enables business applications and SAS/CONNECT can easily connect disparate systems to one another. One such solution is a web- based Java applet that provides a point and click user interface for seamlessly transferring SAS or non-SAS data from one platform to another. Java applets can dynamically generate SAS/CONNECT programs to run on the most appropriate platform (OS/390, UNIX, NT, PC, Linux, etc) |
dataset, proc step, delimited file, raw data, txt, macro definition, excel |
source |
5 |
| 135 |
Overview of Risk Dimensions |
Rik van de Weerthof |
Presentation |
market risk, credit portfolio, portfolio risk, credit risk, sas risk engine, variance, data governance |
source |
34 |
| 136 |
Phillips Petroleum Company-Norway |
Henning Lillejord, Pål Navestad |
Presentation |
|
source |
5 |
| 137 |
Planning and Budgeting with Total Financial Management: How we are automating the budgeting process within SAS International Headquarters |
Jonathan Jones |
Presentation |
crosswalk, excel, data cleaning |
source |
29 |
| 138 |
Portable Strategy |
Andrew Pleming, Stephan Haux |
Presentation |
|
source |
17 |
| 139 |
Practical SAS/IntrNet 8.2 - Point and Click Web Pages with Design-Time Controls amongst other things! |
Ingrid Hertel |
Presentation |
data step, proc step, capacity planning, file statement, resource allocation, sas programming, sample |
source |
30 |
| 140 |
Preventing surrender by holders of life insurance policies |
Gerhard Braas |
Presentation |
lapse rate, life insurance, data mining, policy, customer satisfaction, data wrangling, do over |
source |
20 |
| 141 |
Productivity and strategy in Portuguese banks: a qualitive and quantitative approach for IT investment analysis |
Luis Valadares Tavares, Manuel Joao Pereira |
Presentation |
scenario analysis, financial services |
source |
22 |
| 142 |
Profiling Your Customers in One Click with SAS: An Automotive Industry Case Study |
Andrea Dorigo, Corrado Marozzo, Giovanni Lux |
Presentation |
data mart, access control, customer segmentation, source count, output delivery system |
source |
41 |
| 143 |
Providing SAS with a Voice |
Pankaj Mistry |
Presentation |
credit risk, proc sql |
source |
22 |
| 144 |
Querying Star and Snowflake Schemas in SAS |
Bart Heinsius |
Star schemas, and sometimes snowflake schemas, are often used in Data Warehouses as the storage structure for dimensional data that is to be queried efficiently. In Data Warehouses built using SAS Software, star and snowflake schemas can also be implemented. Star and snowflake schemas in SAS can be queried using SAS SQL or the SAS DATA STEP. Tests have shown that using the DATA STEP can result in significant performance gains over SQL. This paper will discuss the use of star and snowflake schemas in SAS and will look into the performance issues that arise. Then, a number of techniques are discussed that address these issues. They involve bitmap indexes and DATA STEP code generation from dedicated metadata. Then, the Star Class is introduced, which implements these techniques. This paper should be of interest to Data Warehouse architects and builders and to OLAP application builders working with SAS Data Warehouses used for dimensional querying |
proc sql, fact table, star schema, sample, snowflake schema, dimension table, proc step, sas base, index, foreign key, lookup, bitmap |
source |
5 |
| 145 |
Rapid Development of an ALM System |
Irmantas Kamienas |
Presentation |
interest rate, data mart, alm, capital adequacy, interest rate risk, net interest income, variance, interest, market risk, excel |
source |
20 |
| 146 |
Realization of DataWareHouse in the Sector of the Building |
Patrick Duchateau |
Presentation |
sas base, sas enterprise guide, macro loop, excel |
source |
28 |
| 147 |
Reporting in OS/390 Intranet |
Antoni Canals, Esther Remiro |
Presentation |
proc gchart, capacity planning, ods html, ods listing, output delivery system, proc step |
source |
21 |
| 148 |
Reporting on Broadvision data: what are the advantages and how is it done? |
Christine Le Bras |
Presentation |
bank transaction, log |
source |
13 |
| 149 |
Repsol YPF - a complete implementation model of balanced scorecards in the oil and gas sector |
Antonio Arce |
Presentation |
data visualization, profitability analysis |
source |
24 |
| 150 |
Risk management and IAS reporting at Deutsche Postbank AG |
Harmut Komme, Jan Olaf Weber |
Presentation |
credit risk, savings account, financial reporting, liquidity gap, interest rate, market risk, correlation |
source |
23 |
| 151 |
Risk Simulation with SAS/IML - Corporate Insurance Solutions for Fortune 2000 companies |
Boris Weimann, Gero Niessen |
Presentation |
business intelligence, outlier |
source |
20 |
| 152 |
S-Vertrieb Control (SVC) - A report platform for the savings banks' active distribution control |
Peter Wolpers, Timo Holtig |
Presentation |
|
source |
19 |
| 153 |
SA Nostra: Total CRM With SAS - One Step Forward from analytical to operational |
Antoni Canals, Javier Rojas |
Presentation |
output delivery system |
source |
34 |
| 154 |
Sales Force Management Through Intranet |
Anna Surova, Jan Maly, Jaroslav Kafka |
Presentation |
data mart, best response, outlier, management reporting, actuarial reserve, data cleaning |
source |
21 |
| 155 |
Sales Tools in BANCAJA For A Multi-Channel And Customized Distribution of Financial Services |
Jose M. Narciso |
Presentation |
credit card, distribution channel, life insurance, sas risk engine, sample |
source |
16 |
| 156 |
SAS "Eternity" Project |
Leonardo Flora |
Presentation |
|
source |
10 |
| 157 |
SAS & IUT of Vannes: 15 years of Partnership for Higher Competences in the Business Intelligence Economy |
Ariane Liger-Belair Sioufi, Jean Le Nouvel |
Presentation |
business intelligence, data governance, data mining, pharmaceutical industry, sas/stat |
source |
21 |
| 158 |
SAS 8e Release 2: An Overview |
Achim Granzen |
Presentation |
sas base, data mining, sas enterprise guide, output delivery system, proc report, proc sql, proc step |
source |
29 |
| 159 |
SAS and CFMS Integration - Attacking Fraud in Next Generation Networks |
Augusto Argento |
Presentation |
data mining, quality of service, confidence level, proc hpsplit, type i error, missing value, neural network |
source |
35 |
| 160 |
SAS and Lotus Notes, an ideal combination for webpublication |
Erwin van Dongen |
Presentation |
output delivery system, proc step, excel, proc tabulate, ods html |
source |
26 |
| 161 |
SAS as a Financial Controller of day-to-day business |
Andrei Trifonov, Roman Volynets |
Presentation |
balance, interest rate, data warehouse, sas base, retail banking, management reporting |
source |
34 |
| 162 |
SAS Data Warehouse in the MKB |
Szekeres Csaba |
Presentation |
data warehouse, current account, data cleaning, data audit, data mining, customer profitability, completeness |
source |
15 |
| 163 |
SAS Information Delivery Portal - Delivering Information to the Masses! |
Don Hatcher |
Presentation |
access control, role-based access control, business intelligence, data validation rules, sas programming, data cleaning |
source |
36 |
| 164 |
SAS Integration Technologies - Yes we Can! |
Craig Stires |
Presentation |
sas enterprise guide, dataset, business intelligence, access control, spk file |
source |
64 |
| 165 |
SAS Process Intelligence: Closing the "Knowing-Doing" Gap to Deliver Value Through Process Efficiency, Effectiveness and Adaptability |
Ian D. Cox |
Presentation |
key performance indicator, data mining, data science, sas enterprise guide |
source |
38 |
| 166 |
SAS/ACCESS to R/3, Release 8.2: Ways to Access SAP BW |
Dietrich O. Banschbach |
Presentation |
sas enterprise guide, change data capture, dataset, flat file, star schema |
source |
13 |
| 167 |
SAS/IntrNet Software - What is it, what has been added with release 8.2 and what can it do for your business? |
Ingrid Hertel |
Presentation |
data cleaning, sas programming, proc sql |
source |
34 |
| 168 |
Scalable Performance Data Server - features of v3.0 |
David Annis |
Presentation |
proc step, parallel processing, proc sql, where statement, implicit sql pass-through, parallel group, by group processing |
source |
26 |
| 169 |
Send in the Clones |
Philip Whittall |
Presentation |
proc step, proc transpose, class variable, data mining, data cleaning, sample, proc hpsplit, cdisc |
source |
22 |
| 170 |
Servire al meglio ... la migliore clientela |
Giovanni Pietrobelli |
Presentation |
staging area, excel, customer segmentation, phase i, phase ii, phase iii, weighted mean |
source |
49 |
| 171 |
Setting new Standards in Customer Satisfaction Measurement |
Henrik Helmholt |
Presentation |
customer satisfaction, sample |
source |
19 |
| 172 |
Silcon.com - The who, what, when, where and why of e-business |
Tom Bureau |
Presentation |
data mining, sample |
source |
27 |
| 173 |
Simulation of risk values as a powerful tool of risk management optimization |
C. Windolph, E. Honak |
Presentation |
credit risk, default rate, variance, sas base, parallel processing, data science, stress testing |
source |
19 |
| 174 |
Social Security spreads information on the Web |
Antonio Alonzi, Claudia Carletti |
Presentation |
proc download, proc tabulate |
source |
32 |
| 175 |
Software Validation in Clinical Trial Reporting: Experiences from the Biostatistical & Data Sciences Department |
Andrea Baker |
Presentation |
data cleaning, quality control, clinical trial, clinical data, adverse events, raw data, validation documentation |
source |
25 |
| 176 |
Statistical Analysis for analytical methods validations |
A. Vanassia, E. Tizzani, Nguyen Van Danh, R. Corneo, V. Nanni |
In analytical chemistry every new analytical method, after the development step, must be validated before routine use. The validation process consist to evaluate the method results obtained with some statistical approaches in order to define the systematic errors and application limits. |
data cleaning, confidence interval |
source |
9 |
| 177 |
Strategic Financial Management at PZU Life: Business Benefits from Data Warehouse and CFO Vision Integration |
Marek Wilczewski |
Presentation |
life insurance, data cleaning, data warehouse, load, distribution channel, ledger, management reporting |
source |
42 |
| 178 |
Strategic Vision - Implementation Challenges - Speartek Update |
Henning Dekant, Stefan Gossler |
Presentation |
cross-sell, sas enterprise guide |
source |
22 |
| 179 |
Successful certification program - successful projects with certified personnel |
Bernd Steinmetz |
Presentation |
business intelligence, customer segmentation, sas programming |
source |
23 |
| 180 |
Supplier Relations Management - A knowledge based approach to e-procurement |
Jennifer Major |
Presentation |
|
source |
35 |
| 181 |
Supplier Relationship Management |
Steve Oestreicher |
Presentation |
flat file |
source |
20 |
| 182 |
System OPENK - Corporate Customers Profitability Analysis |
Krzysztol Marczak |
Presentation |
corporate banking, mis |
source |
2 |
| 183 |
Taming the CRM Information Explosion - The Power of Two: EMC & SAS |
Marco Lang |
Presentation |
business intelligence, dataset, data governance |
source |
12 |
| 184 |
Teaching statistics and the SAS System |
Barbara G. Schneider |
This presentation offers ideas and examples for using the SAS System in teaching statistics to students in medicine and to physicians. Two parts will be discussed. The first part describes features already available in the SAS System. The second part introduces an educational application. This application is a visual demonstration of elementary statistical notion. Topics such as the influence of changing the parameters of a distribution on the shape of the distribution and the variability of a point estimator are discussed. The demonstration is developed on a PC (Windows) using Base SAS , SAS/GRAPH , SAS/INSIGHT and SAS/AF. SAS Version 8.1 SAS code will be shown. The presentation is aimed at people who are interested or involved in teaching statistics |
sample, binomial distribution, normal distribution, probability functions, regression analysis |
source |
10 |
| 185 |
Test On Line: reusing SAS code in WEB applications |
Carlo Ramella |
The Proway System is a powerful complete system for Process and Testing Data Analysis in IC industry environment. The system, based on a classical client-server architecture, is designed to access several databases at the same time, placed in different sites all around the world, moving and computing very large sets of data. A complete set of statistical analysis (tools) have been written using SAS procedures (histogram, box plots, scatter plots, bar charts, statistical reporting, and so on). The increasing number of users (more than 3000, on four continents), with different levels of skill in different application areas, led to design a new generation of tools dedicated to fast, light and very specific analysis. The new architecture includes the classic client-server tools for "heavy" analysis (SAS datasets of 1 Gigabyte are not so unusual in these cases) and a new set of WEB tools for quick reporting |
connection string, proc sql |
source |
7 |
| 186 |
Testing for the geographic representativeness of data subsets - The Nugget Effect or Degress of Difficulty |
Frederick D. Busche |
Presentation |
sample, frequency analysis, data mining, sample size, proc freq, sas base, test set |
source |
21 |
| 187 |
The << Net Interest Margin >> of the BBL Bank Controlled, Analysed and Justified using SAS OLAP Solutions |
Ida R. Carapelle, Michael Berton |
Presentation |
net interest margin, business intelligence, data mart, beta distribution, financial services, crosswalk, excel |
source |
30 |
| 188 |
The Automated Scoring Application Project |
Carl A. Touchie |
Presentation |
data mining, sas base, credit card, cross-sell, customer profitability, extract, numeric functions |
source |
22 |
| 189 |
The data mining process and SAS Enterprise Miner in Elisa Communications Corporation |
Jaana Jarvelainen |
Presentation |
data mining, communications service provider, service provider |
source |
20 |
| 190 |
The Data Warhousing Process in the Development of Traffic Emission Information System of ATENA Project in Naples |
Giovanni Meccariello, Livia Della Ragione, Mario Rapone |
The aim of this paper is to outline solutions related to access, management, analysis and presentation of data coming from a consistent data base in the development of a traffic emission information system carried on within the ATENA Project. This is a large car fleet test started in the 1999 in the urban area of Naples, realized in cooperation between FIAT Research Center, Naples City Hall, ELASIS, the University "Federico II" and the Istituto Motori of National Research Council of Italy. The scope of this project is to create a decision support system for urban traffic management based on a traffic monitoring system. The information acquired on the road by cars is analyzed to determine typical driving behavior related to a combination of traffic conditions and road characteristics. This presentation shows the data warehousing process in the development of the Traffic Information System. Raw data base, SAS dataset and statistical codes are presented as well |
data science, output delivery system, data warehouse, proc step, raw data, scatter plot, proc means, bar chart, contour plot, line chart, multivariate analysis, histogram, proc freq, proc princomp |
source |
12 |
| 191 |
The Dynamic Scorecard Lifecycle - Balanced Scorecard ING Bank |
Joost Muller, Popko de Vlugt |
Presentation |
business intelligence, financial services, management reporting |
source |
30 |
| 192 |
The Intelligence Layer - an Organized Approach to Business Intelligence |
Allan Russell, Stefan Gossler |
Presentation |
business intelligence, data cleaning, customer profitability, model deployment, correlation, proc freq |
source |
57 |
| 193 |
The Managing Information System (S.I.D.) of the Civil Servants' Health Insurance |
Isabelle Richard, Joseph Garacoits |
Presentation |
output delivery system, insurer, extract, dataset, health insurance, production run |
source |
48 |
| 194 |
The Municipality of Venice Data Warehousing Project |
Francesco Negrato |
Presentation |
data science, extract |
source |
43 |
| 195 |
The Portfolio Forecasting System |
Paul Alton |
Presentation |
loan, sample, retail credit risk, net interest income, credit risk, current account, economic capital |
source |
25 |
| 196 |
The R in CRM Stands for Risk & Respect from Customers, not Relationships |
Huw Davis |
Presentation |
customer segmentation, product profitability |
source |
37 |
| 197 |
The Risk Control Process in the Management of a Diversified Banking Group: the case of Monte Paschi di Siena Group |
Pierfrancesco Cocco |
Presentation |
credit risk, interest rate, liquidity risk, market risk, risk exposure, interest rate risk, data warehouse, counterparty risk, operational risk |
source |
28 |
| 198 |
The SAS Solution for Enterprise Marketing Automation - Opening Session Demo |
Nelle Schantz, T. Randall Betancourt |
Presentation |
data mining, propensity score, data wrangling, data warehouse, credit card, response variable |
source |
43 |
| 199 |
The SAS Text Mining Solution |
Bernd Drewes, Wayne Thompson |
Presentation |
data mining, numeric variable, nominal variable, parsing, dataset, data cleaning, neural network |
source |
22 |
| 200 |
The SAS/UK Clinical Data Management Knowledge Solution |
Ian Pimblett |
Presentation |
data cleaning, dataset, 21 cfr part 11, clinical data, audit trail, clinical trial, proc print |
source |
23 |
| 201 |
The spider in the Web for your everyday HR business - Corporate human resources data warehouse for logistical service provider |
Niels Stout |
Presentation |
service provider, business intelligence, data warehouse, management reporting, sas base, raw data |
source |
25 |
| 202 |
The sweet side of web warehousing |
Alan Buda, Daniele Frisoni, Leonardo Modeo |
Presentation |
data mart, natural key, logistic distribution |
source |
21 |
| 203 |
The Use of Enterprise Miner with Large Volumes of Data, for Forecasting in an Automated Batch Process |
Justine Eastman |
Presentation |
data mining, regression analysis, feature selection, oracle, score code, time series analysis, outlier |
source |
12 |
| 204 |
Total Financial Management beyond the new economy |
Suzanne Palkoski |
Presentation |
customer profitability, financial reporting, product profitability, cash management, internal audit, management reporting, profitability analysis |
source |
34 |
| 205 |
Trade Customer Intelligence |
Massimo Fabris, Stefano Lanzoni |
Presentation |
data mart, data warehouse |
source |
24 |
| 206 |
Two e-intelligence case studies - a ank on line and a financial information portal |
Christine Le Bras |
Presentation |
correlation |
source |
22 |
| 207 |
Uncovering Service Levels |
Fabio Veronese |
Presentation |
data wrangling, ods html |
source |
26 |
| 208 |
Unique utilisation of new business opportunities through integration with traditional channels: Experience and expectations |
Mik Kristensen |
Presentation |
output delivery system |
source |
36 |
| 209 |
Use of SAS V8 and SAS Enterprise Guide in the Federal Statistical Office of Germany |
Ernst Schrey |
Presentation |
sas enterprise guide, seasonal adjustment, data warehouse, sas base, sas programming, excel, regression analysis |
source |
18 |
| 210 |
Using OLAP and the Web for information about local governments in Lombardy |
Antonio Lentini |
Presentation |
business intelligence, structured data |
source |
28 |
| 211 |
Using SAS Enterpise Miner Analytical CRM in Finance |
Sascha Schubert |
Presentation |
attrition, next best action, data mining, cluster analysis, credit card, financial services, resource allocation |
source |
33 |
| 212 |
Using Version Control and Configuration Management in a SAS Data Warehouse Environment |
Steve Morton |
Presentation |
data warehouse, catalog |
source |
45 |
| 213 |
WAP! WAP! Know Your Network Performance! Anywhere! Any time! |
Marc-Andre Bumann |
Presentation |
access control, trouble ticket, sample |
source |
25 |
| 214 |
Web and Data Warehouse technology combined in a pharmaceutical decision support system |
Christine Vander Vorst |
Presentation |
business intelligence, clinical trial, data cleaning, clinical research, sas consultant, star schema, normalization |
source |
29 |
| 215 |
Web clickstream analysis to understand customer behaviour |
Erika Blanc, Paolo Giudici |
Presentation |
odds ratio, data mining, confidence interval, association rules, estimate, sample size, sample |
source |
21 |
| 216 |
Web Enabling SAS Output |
Darryl Lawrence |
Presentation |
ods html, macro variable, macro definition, macro facility, sas enterprise guide, proc sql, term life |
source |
29 |
| 217 |
Web Performance Management: A SAS Solution Approach |
Frank C. Lieble |
Presentation |
correlation, cell congestion, structured data |
source |
27 |
| 218 |
Web warehousing and data exploitation of accidents in working environments - ISPESL |
Paolo Montanari |
Presentation |
proc freq, data wrangling, vertical bar chart, data warehouse, dataset, standard deviation, excel |
source |
33 |
| 219 |
Web-Based OLTP System Using SAS |
Haidong (Don) Tang |
Presentation |
proc sql, sysrc, constraint, macro conditional, data warehouse, proc step, key |
source |
75 |
| 220 |
Web-enabled inquiries on operational data store at KBC |
Jurgen Druyts, Pascal Verschaeve |
Presentation |
ledger, temporary dataset, work library, exposure management, permanent library, private banking, data cleaning |
source |
26 |
| 221 |
WebHound: Your Best Friend for Tracking Web Traffic |
Frank C. Lieble |
Presentation |
customer satisfaction, link analysis, data cleaning |
source |
37 |
| 222 |
WebMining |
Goncalo Abreu, Pedro Marques |
Presentation |
data mining, proc hpsplit, correlation, data cleaning |
source |
15 |
| 223 |
WELFARE - Wells, Field Analysis, Reservoir Evaluation |
C. Mouret, J. F. Coste, J. P. Valois |
Presentation |
proc step, dataset, hierarchical clustering, raw data, excel, regression analysis, sas output |
source |
50 |
| 224 |
What is missing in campaign management today? |
Shaun Doyle |
Presentation |
data mining, customer profitability |
source |
18 |
| 225 |
What's new in AppDev Studio 2.0 |
Anton Fuchs |
Presentation |
production run, excel |
source |
41 |
| 226 |
What's New in SAS/Warehouse Administrator Software |
Wilbram Hazejager |
Presentation |
mp connect, sample, star schema, data warehouse, proc sort, proc means, proc step |
source |
43 |
| 227 |
Windows NT Server Configuration and Tuning for Optimal SAS Server Performance |
Carl E. Ralston, Susan E. Davis |
Presentation |
bufsize |
source |
25 |
| 228 |
Wireless, hype or reality, can you really apply it to the business? |
Stephan Haux |
Presentation |
quality of service, logistic distribution |
source |
20 |