Premium Essay

Database Workshop

In:

Submitted By philgarlichs
Words 964
Pages 4
Amsterdam Business School Academic Year 2014 - 2015

Course Outline
Course: Thesis Workshop Database Research - 6314M0226(F)Y Lecturer: Dr Niccolò Pisani Office: M 2.14 Telephone: 020-525-4360 Term: Sem.1 - Block 1 Email: n.pisani@uva.nl

Consultation Hour during the course:

Monday 17:30 – 18:30

Course Coordinator: Corine Boon

M 2.26

020-525-4181

c.t.boon@uva.nl

Lectures Dates Mon 01/09/2014 Mon 08/09/2014 Mon 15/09/2014 Time 15:00-17:00 15:00-17:00 15:00-17:00 Room REC-JK 1.90 REC-JK 1.90 REC-JK 1.90

Assessment:

Individually Written Research Proposal

100%

1

COURSE DESCRIPTION This course is meant to support students in learning how to obtain and utilize data from WRDS platform for their thesis.

Most students lack real world experience working with data, above and beyond the basics of spreadsheet analysis. As a result, students either do not know where to find the data they need or do not know how to handle data properly. This workshop is intended to increase your comfort level working with databases. Areas of topics that use WRDS database include, for example, corporate social (ir)responsibility (KLD), consensus and forecasts from security analysts (IBES), abnormal returns for specific corporate actions or events (Eventus), detailed audit information between accounting firms and corresponding companies (Audit Analytics), and any topic concerning firm financial performance (COMPUSTAT/CRSP/AMADEUS).

The workshop consists of three parts (Each assessed in a different lecture): 1. Introduction to the most commonly-used databases in both academia and business. 2. Familiarization with the process of assembling and analysing a dataset. 3. Overview of the WRDS platform with regard to what WRDS consists of and how to work with it.

COMMUNICATIONS You should always check the blackboard site for announcements and other postings,

Similar Documents

Premium Essay

Schneider

...account manager workshop. Some management issues have been exposed regarding not only the relationship between Schneider and Calchem but also the effectiveness of Schneider’s communication network and the cooperation from its subsidiaries. This report aims to analyse the challenges Schneider is facing in depth with the focus on cultural differences to figure out the solutions for this company to promote system of global account management, to gain support from local subsidies and to build the reliable long term relationship with new clients. The report identifies the challenges Schneider is facing at current. Firstly, the internal communication channel across organizations, relationships between subsidiaries and head quarters (HQ) and customer relations is considered as the core issues. Due to the matrix structure and the larger number of cultures involved in the net work communication, effective information feeding and sharing is difficult to be achieved. Secondly, different cultural orientations of different subsidiaries have made the goal of GAM hard to be gained. This is presented by the resistance to develop GAM in some subsidiaries and the reluctance to attend workshop. Furthermore, different cultural orientations of the clients raise different interpretation of Schneider Electric’s actions bringing misassumption about control power in the strategic alliances between Schneider and Calchem as well as challenges in convincing this account to attend the workshop. Some recommendations...

Words: 338 - Pages: 2

Free Essay

Small Time

...watch the Career Services No ce Board for changes in the schedule.  Tuesday 22.1   Tuesday 29.1  Thursday 31.1  Friday 1.2  Tuesday 5.2  Friday 8.2  Thursday 14.2  Thursday 21.2  Tuesday 26.2  26.2‐22.3  Tuesday 5.3  Wednesday 6.3  Company Presenta on Cognizant  Company Presenta on Microso   Company Presenta on Swisscom  Case Study Workshop Accenture (a ernoon, by applica on only)  Company Presenta on UBS  Interview Training  Workshop at Deloi e (Zurich, all day, by applica on  only)  Company Presenta on Roche  Company Presenta on Rocket Internet with Interviews Opening Panel of the HSG TALENTS Conference (18:15‐20:00, audimax  HSG)  HSG TALENTS Conference (workshops, presenta ons at the HSG)  Case Study Workshop Bertelsmann (a ernoon, by applica on only)  MBA Lounge at the HSG TALENTS Conference—main recrui ng event  for PT and FT MBA Students, 12:00—16:00 OLMA conference centre  St.Gallen The corporate presentations and workshops are a part of the Career Development Programme at the St.Gallen MBA. The companies are briefed to give an authentic picture of what it is like working for the particular company and what MBA level entry positions might look like. Each presentation or workshop is normally followed by a Q&A session in class or in form of an informal apéro (coffee, small bites, wine in the evenings) outside the Lecture Hall. Dress code: business....

Words: 280 - Pages: 2

Free Essay

Other Topics

...Me and my job as shipfitter My name is Lasse Mosebo I am 19 years old. I live in vindeby and have done so my whole life. I live together with my mum Gitte, my dad Bjarne and my little brother Mathias. But I just got my own apartment in Svendborg and I’m planning to move in next month. Almost every member from my father side of the family have been working with ships, My dad also works with ships and so did almost every member from his side of the family have been working with ships as well. When I was a kid he used to take me along to work and I found it very interesting. So like my dad working with ships and its engines has always been what i wanted to do for a living. Also I feel like it’s a tradition I have to carry out, since my little brother don’t like to get his hands dirty like I do. While he sits on the computer in his spare time I like to spend my spare time working on my boat and its engine. Whenever my friends have trouble with their car or scooter its me they call for help because they don’t know what to do and they know i always want to help them out. I’ve always knew what I wanted to do for a living but after 9th grade I took a 10th grade, not because I needed it but because I could take my education as shipfitter while I took my 10th grade. So it was a win win situation. Then one of my teachers found a internship at Svendborg Motorværksted for me. I was going to be working there for 2 weeks. When my internship was over the boss of Svendborg Motorværksted...

Words: 674 - Pages: 3

Premium Essay

Art Survey

...help the student services department to understand workshops and seminars suitable for art students. To achieve this purpose, this survey was done by collecting data from 22 art students in art school. Data collection was by the use of a survey questionnaire containing two questions. The first question sought to rate how students were interested in undertaking different workshops. The last question was open ended seeking to understand other workshops that students would like to attend. To avoid getting blank responses, each participant was asked the questions and the researcher wrote the response on their behalf. The results indicated that 17 students were interested in attending the creativity workshop. However, most participants were not interested in the “wordpress” workshop. For the second question only nine participants identified other workshops in which they wish to attend. A Survey was done in an Art School to find out which Workshops and Seminars would be helpful for Art Students Introduction/Problem Statement Educational institutions recognize the need of students’ involvement in decision making. This attribute is seen as vital because it helps students select what they think would benefit them and help improve on their educational outcomes (Murphy 56). In particular, education institutions have been using seminars and workshops as tools to improve on the development of their students. In designing these workshops, evaluating learning needs are significant in determining...

Words: 1184 - Pages: 5

Free Essay

Buisness

...used 2.In which ways do you engage or interact with customers attending your promotional/educational events? We have workshops for kids (4-12), Do-It-Yourself workshops for the general public, Do-It-Herself workshops for women, and online videos and tricks to guide customers through a project. Our workshops last from one to two hours, during which we work side by side the participants to guide them through simple DIY projects. Kids workshops require an attending adult, where we demonstrate simple safety and construction skills like how to use a hammer and wood glue in order to construct simple projects like stools and bird houses. At adult workshops we show attendants how to preform simple home improving projects properly and safely. We work side by side and demonstrate easy tasks like tiling a backsplash or laying laminate flooring. At these workshop we show participants how to safely complete these types of jobs, which tools are needed for specific jobs, how to care for and protect your tools, and give advice on ways to make many projects easier. 3. In which ways do you feel it is important to tie the types of events you hold to the image of the store? If it is not why? It is very important to keep events clean, safe and enjoyable, just like the atmosphere we provide in our stores. We genuinely care about the success of the attendants of these workshops, as we genuinely care about the customers shopping experience in our stores. 4.Do you feel customer satisfaction...

Words: 1048 - Pages: 5

Premium Essay

Brown Johnson's Sesame Street Workshop

...Brown Johnson, the creative director and vice president of “Sesame Street Workshop” said that kids are discriminating viewers. For him, if kids do not like the characters or understand the story, they simply just walk away or change channels. Which is why “Sesame Street” is a success even until this day. When the creators of “Sesame Street” thought about making a television for kids, they made their research based on the age and comprehension level of their target audience, cites The Creators Project. When the show began in 1969, “Sesame Street’s” main goal was education. They wanted to exhibit values that would make kids everywhere smarter, stronger and kinder - such is the motto of the show. They did their research and consulted a team...

Words: 333 - Pages: 2

Free Essay

Sesame Street

...- its a detailed - feels real - to the point - it doesnt have any climax - short senteces which dialouge format - into intro, started in the middle on the scene and you are trying to figure out whats going on. - it requires the the reader to read between the lines. - saying her dad is old, sad, loving, alone, depressed - descriptive language - appealing to senses - crums felt, heating from the vent, - not being explicit about everything - double meaning dialogues - leaving things unsaid to lead the reader into the story and making the reader understand the story in their own way. - short sentences, simple language, detailing, easy to read, short sentences, childs honesty, - time was the center of attension since the writer merely described 13 minutes so beautifully. - i like the ending since it left me to wonder if she was on time, or how the rest of the day was, and what happend after that. - I would like to see an introduction rather than a story which starts in the middle of the scene. The writer does not being the story with an introduction rather the writer just starts the story in the middle of a scene. The major attraction in the first paragraph is the detailing of the scene. The writer uses very simple and easy language yet the writer is very detailed about what is happening. The writer does a very good job on making the reader imagine the scene. As you progress with the story it's noticeable that the sentences are very short and to the point. The...

Words: 480 - Pages: 2

Free Essay

Story

...Vandita Manyam Professor Daniel Lao Engl 1A/ Section 05 12 April 2012 Fantasy and Reality Sesame Street (NET/PBS 1969-1992/1992-Present) has been one of the many reasons for equality and assisted to educate children from a young age. However, today Sesame Street has inspired many other children worldwide. The groundbreaking friendly show increased recognition of the diverse population by including various individuals to be a part of one team, known as Sesame Street. The program uses a combination of fantasy and reality by using monsters and puppets to stimulate real life situations and to create an educational program that educates preschoolers. Michael Davis’ Street Gang illustrates not only the ways in which Sesame Street was conceived of as a learning tool for urban American kids, but how it grew to influence global audiences. In 1969, Sesame Street initially aired on National Education Television (NET), which ultimately increased the respect and recognition of minorities in America. Joan Ganz Cooney and Lloyd Morrisett the creators of Sesame Street mentioned their central focus was to create a children's television show that would “master the addictive qualities of television and do something good with them” (Davis 157). When depicting a scene from any television series, a deeper message is hidden beneath the surface of the screen. Although there are not many controversies in the show, the guests that come on the show to help creatively engage the children are selectively...

Words: 907 - Pages: 4

Free Essay

Sesame Street

...first to include a curriculum "detailed or stated in terms of measurable outcomes".[1] Initial responses to the show included adulatory reviews, some controversy and high ratings. By its 40th anniversary in 2009, Sesame Street was broadcast in over 120 countries, and 20 independent international versions had been produced.[2] The show was conceived in 1966 during discussions between television producer Joan Ganz Cooney and Carnegie Corporation vice president Lloyd Morrisett. Their goal was to create a children's television show that would "master the addictive qualities of television and do something good with them",[3] such as helping young children prepare for school. After two years of research, the newly formed Children's Television Workshop (CTW) received a combined grant of $8 million from the Carnegie Corporation, the Ford Foundation and the U.S. federal government to create and produce a new children's television show. By the show's tenth anniversary in 1979, nine million American children under the age of six were watching Sesame Street daily, and several studies showed it was having a positive educational impact. The cast and crew expanded during this time, including the hiring of women in the crew and additional minorities in the cast. In 1981, the federal government withdrew its funding, so the CTW turned to other...

Words: 452 - Pages: 2

Premium Essay

Case Study Lego

...LEGO - EMBRACING CHANGE BY COMBINING BUSINESS INTELLIGENCE WITH A FLEXIBLE INFORMATION SYSTEM History of LEGO Company The LEGO Group was founded in 1932 by Ole Kirk Kristiansen. The company has passed from father to son and is now owned by Kjeld Kirk Kristiansen, a grandchild of the founder.   It has come a long way over the past almost 80 years - from a small carpenter’s workshop to a modern, to a global enterprise that is now, in terms of sales, the world’s fourth-largest manufacturer of toys. The name 'LEGO' is an abbreviation of the two Danish words "leg godt", meaning "play well". The original Lego toys started with a wooden duck. But the first LEGO automatic binding brick is their most important product. The products have undergone extensive development over the years – but the foundation remains the traditional LEGO brick. The Lego Group began in the carpentry workshop of Ole Kirk Christiansen, in Billund, Denmark in 1916.  In 1961, Lego wished to expand sales to North America, but did not have the logistical capabilities to do so. Lego made an arrangement allowing Samsonite to begin producing and selling Lego products in the United States and Canada.  On 7 June 1968, the first Legoland Park was opened in Billund. This theme park featured elaborate models of miniature towns built entirely from Lego bricks. The three acre (12,000 m²) park attracted 625,000 visitors in its first year alone. During the next 20 years, the park grew to more than eight times...

Words: 1468 - Pages: 6

Premium Essay

Database Environment

...The Getty Provenance Institute’s database (The Gettys research institute, 2012) contains 1.1 million records. All of these records can be used for a wide variety of research. According to the institute the database can be used for assistance in finding information for Projects, and for the Study of Collecting. According to the Database, “The J. Paul Getty Museum acquired The Entombment (ca. 1612) by Peter Paul Rubens in a Christie's sale in 1992. At that time, the provenance of the painting could only be traced as far back as the mid-19th century. The number 146, located on the face of the painting, appeared to be an inventory number (the Getty Research Institute, 2012). A search in the Provenance Index's Archival Inventories database retrieved a single record in which the artist name (Rubens) and item number (146) matched. The search lead to a 1651 inventory preserved in the Archivo de la Casa de Alba, Palacio de Liria in Madrid, which lists this Rubens painting. Possibly its first owner was Gaspar de Haro y Guzmán Carpio (1629–1687)”. Other Institutions are not as lucky some. Some Museums are not so fortunate to find the item number associated with the picture. When it is time to introduce the collections into a database, curators of small museums find themselves in a little bit of trouble. The features and capabilities offered by the newer commercial and professional collection systems are more than they will ever need, more than they can support and more than they...

Words: 1164 - Pages: 5

Free Essay

Alumni Mangement System

...members to have a firm link between collage and its members. The alumni can provide the present college students with job opportunities like recruitment. This system will help alumni members to effectively communicate with their old friends, seniors, juniors and their batch mates and will also provide latest news and updates about the system activities. Alumni Online community will provide benefit to the organization by giving great leaders with commitment who upholds ideas and goals further in society of their organization. Alumni Management system provides internet services to remain in touch, feel nostalgic about their past memories. It will help to promote exchange of skills and experience amongst the members and to conduct seminars, workshop and guest lectures. It will also promote social and cultural activities useful to the members and society in general. These programs include reunions, luncheons and receptions, professional sports events, educational programs, and distinguish alumni awards. Overall Description Goals of proposed system Actions Measurable Outcomes Communicate strategically with graduates to create and enhance affinity with the campus · Increase e-newsletter open rate to 20% · Increase participation in social media · Obtain sponsors for printed newsletter · Increase participation in special events Invest in affinity-based programming to engage graduates · Develop alumni engagement program for each college (and for departments as...

Words: 1184 - Pages: 5

Premium Essay

Logical Design

...LOGICIAL DESIGN PART 1 Jon Jones Professor Segura CIS111 Intro to Database Mgt Systems April 20, 2013 The ACME Global consulting will provide software development solutions, offer advice and support and structure within a company. From short to long term project as well as small to large sized businesses and corporations. The main components that apply to this are having a set of domains and sets that represents data structure, Integrity of rules that ensures data protection and operations that will carry on data. The company needs to have an understanding of data and functional needs of the company. The relational model can be used with both databases and the management systems. The relational model would allow the designer to develop the logical structure and specify what needs to be done and provide options for the design. The advantages of the relational model would be simplicity of the concept, implementation design and Ad hoc capability of query implementations. The purpose of E-R model for the ACME global consulting is to inform clients of a powerful database design that the relational model can show. The E-R model consists of components like entities, attributes and relationships for example. The model helps provide a visual representation of the data needs. The relational model can apply to databases and the management systems. By seeing the visual diagrams Acme global consulting would be able to see clearly and understand the data requirements of the...

Words: 641 - Pages: 3

Premium Essay

Online Register

...Two- Week ISTE Workshop for teachers on ‘Database Management Systems’ (21st – 31st May, 2013) Course Coordinator: Prof. S. Sudarshan Day / Date Tue 21 May 2013 09:00 – 10:30 Inaugural remarks (15 mins) Relational Model, SQL Part 1: Relations and Relational Algebra, Basic SQL, Joins, Set operations (Chapters 1, 2 and 3) SQL Part 2: Aggregate functions, Nested Subqueries, Database modification (Chapters 3 and 4) Tea Break 11:00 – 13:00 Session Continues.. (last 30 min discussion/quiz) Lunch 14:00-17:00 Tea Break 5:15-6:00 10:30 – 11:00 13:00 – 14:00 Lab 1: Basic SQL Installing, administering and using PostgreSQL and pgAdmin3; Basic SQL queries Lab 2: Intermediate SQL Aggregation, nested subqueries, database modification 17:0017:15 No Session Wed 22 May 2013 Session 10:30 – Continues.. 11:00 (last 30 min discussion/quiz) 13:00– 14:00 17:0017:15 Linux System Admin. (IITB CSE Sysadms) Thu 23 May 2013 Fri 24 May 2013 Sat 25 May 2013 Sun 26 May 2013 SQL Part 3: Session Outerjoins, Transactions, Integrity 10:30 – Continues.. constraints, Triggers, 11:00 (last 30 min Authorization, JDBC discussion/quiz) (Chapters 4 and 5) ER Design (Chapter 7) Session 10:30 – Continues.. 11:00 (last 30 min discussion/quiz) 10:30 – 11:00 Session Continues.. (last 30 min discussion/quiz) 13:00 – 14:00 Lab 3: Advanced SQL Outerjoins, DDL: integrity constraints, authorization Lab 4: ER Design Tutorial (Last 45 mins for solutions discussion, broadcast)...

Words: 591 - Pages: 3

Premium Essay

Wildwood

...discover relevant entities and attributes for database * Prepare interview questions and follow up * Prepare questionnaires * Observe work flow for process and exceptions Outline I. Gathering Information A. Initial Interviews with Chief Stakeholders B. Review of Business Documents C. Interviews with Stakeholders D. Questionnaires E. Job Shadowing II. Review of Business Documents A. Reasons for Review B. Forms C. Reports D. Other Business Documents III. Types of Databases A. Transaction Database B. Management Information Systems C. Business Intelligence Systems D. Cloud Databases IV. Interviews with Stakeholders A. Preparing for the Interview B. Conducting the Interview C. Note Taking and Evaluating the Interview V. Questionnaires A. When to Use Questionnaires B. Advantages and Disadvantages C. Comparison with Interviews VI. Work Shadowing A. Reasons to Observe Stakeholders at Work B. Looking for Exceptions VII. Documentation A. Business Documents B. Interview Questions and Answer Summaries C. Questionnaires and Summaries Vocabulary 1. Closed-Ended Question | g. A multiple choice question | 2. Domain | o. The purpose or subject of a database | 3. Business Intelligence | g. A Set of tools for analyzing business trends | 4. Exception | j. An Alternate way of doing a process | 5. Form | b. A document for gathering input | 6. Transaction Database | m. A database optimized for storing and processing real...

Words: 6806 - Pages: 28