Agenda

Data Files
Opening data files - File information - Saving data files - Comparing datasets - Data View - Variable View - Entering data - Editing data - Finding cases, variables, or imputations - Finding and replacing data and attribute values - Working with Multiple Data Sources
Data preparation and transformation
Variable properties - Defining Variable Properties - Setting measurement level for variables with unknown measurement level - Multiple Response Sets - Copying Data Properties - Visual Binning - Count Occurrences of Values within Cases - Identifying Duplicate Cases - Computing Variables - Recoding Values - Rank Cases - Time Series Data Transformations
Outputs
Viewer - Export output - Viewer printing - Saving output
Pivot Tables
Manipulating a pivot table - Workingwithlayers - Showing and hiding items - Table properties - Cell properties - Footnotes and captions
Working with Command Syntax
Syntax Rules - Using the Syntax Editor
Trainer

Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.
Publications
- MS SQL Server - XML und SOAP-Webservices ISBN 978-3-939701-03-3
- MS SQL Server - T-SQL Programmierung und Abfragen ISBN 978-3-939701-02-6
- SQL und relationale Datenbanken ISBN 978-3-939701-52-1
- Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen ISBN 978-3-939701-23-1
- System und Systematik von Fragebögen ISBN 978-3-939701-26-2
- MS SQL Server - XML und SOAP-Webservices ISBN 978-3-939701-03-3
- MS SQL Server - T-SQL Programmierung und Abfragen ISBN 978-3-939701-02-6
- SQL und relationale Datenbanken ISBN 978-3-939701-52-1
- Grundlagen empirische Sozialforschung - Befragung und Fragebogen im Unternehmen ISBN 978-3-939701-23-1
- System und Systematik von Fragebögen ISBN 978-3-939701-26-2
Projects
He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining.
Research
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
