...SELECT e.firstName,c.CompanyName FROM Employees e JOIN Orders o ON e.employeeID=o.employeeID JOIN Customers c ON c.customerID=o.customerID ORDER BY e.firstName,c.CompanyName | | Compelling, but we see that there's many repeated entries in the list. We'd like to count up how many sales are at the intersection of each distinct customer and salesperson. To do this we'll add in a COUNT function and GROUP BY clause. SELECT e.firstName,c.CompanyName, COUNT(o.orderID) FROM Employees e JOIN Orders o ON e.employeeID=o.employeeID JOIN Customers c ON c.customerID=o.customerID GROUP BY e.firstName,c.CompanyName ORDER BY e.firstName,c.CompanyName | | Now the real fun begins as we transition this into a query that uses PIVOT. Because we're grouping by not one but two columns, this query is a good candidate for PIVOT. We'll start simple with a query that doesn't JOIN anything, but just references the Orders table. We'll choose to have Employee data put into columns since there are only 9 employees. Much more manageable. In this case the numbers 1 through 9 refer to the ID of employees: SELECT * FROM Orders PIVOT (COUNT(employeeID) FOR employeeID IN ([1],[2],[3],[4],[5],[6],[7],[8],[9])) p In the result set notice that the specific columns returned come from the result of the PIVOT clause and not directly from the Orders table! And that PIVOT clause brings up every column from the Orders table except for employeeID, which gets weeded out since it...
Words: 1353 - Pages: 6
...1 On Demand Business Volkswagen’s world-class procurement strategy produces breakthrough productivity gains. Based in Wolfsburg, Germany, Volkswagen AG (www.volkswagen.de) is Europe’s largest auto manufacturer with worldwide revenues approaching $110 billion and manufacturing facilities on every continent. While perhaps best known for its VW and Audi brands, Volkswagen is also the company behind such storied brands as Bentley, Bugatti and Lamborghini. Amid the everincreasing competition in the worldwide auto industry, Volkswagen has long set itself apart through the design and Volkswagen is the company behind such storied brands as Audi, Bentley, Bugatti and Lamborghini. Overview Challenge Faced with rising complexity within its supplier-facing processes, Volkswagen needed to make its employees more productive to stay ahead of the competition Why Become an On Demand Business? Volkswagen needed to integrate its information and processes to speed decision-making and become more responsive to a rapidly changing supplier environment Solution An On Demand Workplace that includes an enterprisewide portal for employees and suppliers whose sensing, analytic and workflow capabilities have radically streamlined the way employees access and act on information Key Benefits • 20% increase in procurement staff productivity • Expected 100% payback within one year • Significant decreases in materials purchasing and inventory costs “We need knowledgeable ...
Words: 2558 - Pages: 11
...Proposal – Data Warehouse Inventory What is data warehouse? It’s a simple assembling of data gathered from various sources and available to the global customers in a way they can understand to their business level. Statement of Problem: Our intention is to develop inventory application (User interface) so that client can easily track their warehouse. For creating interface we are using ETL and IBM Cognos. Methods to solve problem: * Creating Database for customer * Extract transform and loading the data * Data Mapping * Creating Package from Framework Manager using IBM Cognos * Developing Interface using IBM Cognos Report Studio Tools: IBM DB2, Informatica Power center, IBM Cognos 10.2 Resources: 3 Client: Volvo Trucks. Software Development Life Cycle 1. Requirements 2. Design 3. Development 4. Testing 5. User Signoff Requirements for data warehouse design: A. Goals: 1. To design the flexible data warehouse as per the client requirements. 2. Get the raw data into the centralized repository so that the users can access it in a flexible manner. 3. We should make sure the data cannot be edited by the users. B. Clients Requirements: 1. We need to get all the details of the client products available in their inventory. 2. We need to study the client environment and take down the end to end process. C. Business Questions: 1. Need to discuss about the design duration. 2. Number of resource required for the...
Words: 316 - Pages: 2
...Enterprises-Storefront BTC Model WebSphere 5.0 and Amazon Affiliate Website Integration Managerial Applications of Information Technology – IS535 Devry University, Keller Graduate School of Management May 22, 2014 Enterprises Business to Customer Model, WebSphere 5.0 and Amazon Affiliate website components Topic Enterprises, a small computer repair and IT Consultation Company is proposing a new design for its corporate website. The owner wishes to utilize the Amazon Affiliate model leveraging Amazon’s rapid, real-time processing components connecting to a new storefront engineered with IBM’s WebSphere Storefront software. Problem Enterprises is a low budget start-up with no access to a full-time development staff. The design for the new website needs to be easy to use, easy to maintain, and automated as much as possible without cutting down on the customer experience. The new storefront promises speedy response times with a limited set of services geared towards basic laptop repair, parts ordering, and answers to commonly asked question. The design needs to utilize the Amazon website and WebSphere out-of-the box components as much as possible to eliminate unnecessary coding and maintenance. The website needs to be scalable as the owner anticipates branching out into iPods and other new media technology. Approach IBM offers several out-of-box designs for business startups. The McDonald Deyo Enterprise team members will evaluate several storefront...
Words: 508 - Pages: 3
...this document, please direct them to the author at rsingh@us.ibm.com. Author is not responsible for errors in this document that may result in any kind of inaccuracies. Acknowledgements Thanks to John R Hock, IBM Certified IT Specialist – System p - Advanced Technical Support Americas (ATS) for reviewing this White Paper. Thanks to the customer and IBM team for their contribution and support to this project. Trademarks The following terms are registered trademarks of International Business Machines Corporation in the United States and/or other countries: AIX, AS/400, DB2, IBM, Micro Channel, MQSeries, Netfinity, NUMAQ, OS/390, OS/400, Parallel Sysplex, PartnerLink, POWERparallel, RS/6000, S/390, Scalable POWERparallel Systems, Sequent, SP2, System/390, ThinkPad, WebSphere. The following terms are trademarks of International Business Machines Corporation in the United States and/or other countries: DB2 Universal Database, DEEP BLUE, e-business (logo), GigaProcessor, HACMP/6000, Intelligent Miner, iSeries, Network Station, NUMACenter, POWER2 Architecture, PowerPC 604,pSeries, Sequent (logo), SmoothStart, SP, xSeries, zSeries. A full list of U.S. trademarks owned by IBM may be found at http://iplswww.nas.ibm.com/wpts/trademarks/trademar.htm. NetView, Tivoli and TME are registered trademarks and TME Enterprise is a...
Words: 6610 - Pages: 27
...Mart Design, ETL, BI and Client/Server applications. * Certified in ICS PowerCenter Data Integration Developer Specialist 9.0 and Teradata 12 TE0-121 Certified Professional Program. * Extensively worked on Data Extraction, Transformation and Loading of data from various sources like Oracle, SQL Server, Flat files and COBOL Sources. * Worked extensively with Slowly Changing Dimensions. * Working knowledge of Teradata as a Developer with proficiencies in Teradata SQL Assistant utilities like Fastload, Multiload, BTEQ, FastExport, and Tpump. * Experience in Teradata Data Warehouse architecture. * Proficient in application development and support, for batch processes hosted on an IBM mainframe, with a core focus in COBOL, DB2, JCL and VSAM. * Hands on experience in performance tuning, resolving on-going maintenance issues and monitoring of production runs. * Data modeling using Erwin, Star Schema, Snowflake, FACT and dimension tables. * Hands on experience in UNIX shell scripting. * Excellent communication and interpersonal skills. TECHNICAL SKILLS Frameworks | Informatica Data Director (IDD), Informatica System Integration Framework (SIF), Teradata version 12, Mainframe z/OS | Application Modules | UNIX, Informatica Application Designer, Workflow Manager, Workflow Monitor, Repository Manager, Informatica B2B...
Words: 1062 - Pages: 5
...IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 IBM DB2 Universal Database ® ™ Business Intelligence Tutorial: Extended Lessons in Data Warehousing V ersion 8 Before using this information and the product it supports, be sure to read the general information under Notices. This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/order v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/planetwide To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU (426-4968). When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. © Copyright International Business Machines Corporation 2000 - 2002. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents About the...
Words: 7362 - Pages: 30
...While reviewing the four different databases such as the Oracle 11G, MySQL, IBM DB2, and Microsoft Sql Server 2008 which are all impressive databases, I chose to implement the IBM DB2 database system for Wildwood apartments. The key features that IBM DB2 has are table partitioning, database portioning, massively parallel processing (MPP), Continuous Ingest, Multidimensional clustering (MDC), Aggregates, Multi-Temperature Data Management, Mixed Workload Management, and Control over Workloads. DB2 has a number of performance optimization capabilities that give you the insight and ability to optimize workload execution. (DB2 for Linux, UNIX, and Windows) IBM DB2 meets the requirements for Wild Wood Apartments database so the managers can input the lease information, rent payment, maintenance request and with ease complete there quarterly reports. These capabilities can save you money and lower your risks by helping you to do more work with your existing hardware, ensure Service Level Agreements (SLAs) are met or exceeded and increase DBA productivity. (DB2 for Linux, UNIX, and Windows) The database is user friendly and the apartment managers should have no problem navigating through the system to input the information. This is essential DB2 transparently splits the database across multiple partitions and uses the power of multiple servers to satisfy requests for large amounts of information. (DB2 for Linux, UNIX, and Windows) Another reason why I chose IBM BD2 I because of...
Words: 628 - Pages: 3
...researching the information that you have provided. Behaviorism (grand theory) The theory that I chose was behaviorism. Behaviorism is a grand theory of the human development and studies the observation of behavior. This theory is also a learning theory it explains the laws and the process as to how people learn to behave. According to John Watson, “if psychologists can focus on behavior, they will realize that everything can be learned.” I can apply this theory to several concepts as it relates to my Christian worldview. The first concept is prayer; the very first prayer that is learned is The Lord’s Prayer. Through behavior you learned this either listening to someone recite this prayer or you learned it by reading the bible. The second concept is worship. Worship is first learned and then through maturity you develop your own sense of worship. Worship is learned at home by parents or those whom you live with or it’s learned at your church by those who you attend worship service with. The last concept is praise. Praise just like worship is a very important part of my worldviews. Praise is a learned behavior because it teaches you how to give honor to God. Again just like worship this is learned through watching those who worship. Behaviorism can...
Words: 345 - Pages: 2
...children’s conceptions change during the instructional process and how the social discussion during the experimental exploration can be seen in terms of the cognitive changes in children. Young children’s conceptual change has not been as widely studied as that in older students. The researcher in this case study suggested that conceptual changes as a party of the learning process should be viewed as a life long process, which begins before children enter school. Six-year-old children undergo floating and sinking during their conceptual change process. This article attempted to describe this process and how social discourse during the process of knowledge construction is linked to the change in children’s concepts. Conceptual change had generally been examined only through cognitive functions as a general process without consideration of the context before this case study. The children that were selected for this study were pre-schoolers age six. They all hailed from the city of Joensuu, Finland and were from the kindergarten involved with the ESKO research project. The groups wanted to participate in the study, but the researchers taught the topic after the teachers disagreed. The children came from two different groups in the kindergarten with mixed genders. The research was conducted into three parts: pre-interview, instructional process, and post-interview. The pre-interview consisted of two parts that aimed...
Words: 502 - Pages: 3
...Alienation is a key theme in Peter Skryznecki’s Migrant Hostel and Tim Winton’s Neighbours. The authors use techniques to engage the reader and to teach the responder about alienation and how it affects people. Skryznecki uses symbolism to convey that migrants were alienated from Australian society. Skryznecki says "barrier at the main gate" to emphasize how the migrants were excluded from the outside world. The "barrier" is both literal and symbolic. It is symbolic of the barrier to belonging in Australia, and the alienation of migrants. Skryznecki uses similes to reiterate his point that migrants were alienated. He say "like a homing pigeon" to compare migrants to birds. He does this to show that the migrants don't belong the are constantly moving to survive like birds do. He further develops this idea through a second simile "like birds of passage". He is explaining that nothing was certain, and there was no security or place of belonging. The migrants feel alienated and want to belong but the Migrant hostel won't let them, they are being forced into alienation. Skryznecki uses similes to convey his thematic concern of alienation. Perceptions and ideas of belonging, and of not belonging, vary. There is no definite truth to where someone belongs. A person can belong somewhere different to where they are assumed to belong. and can not be forced on someone. People belong to different groups than others. Perceptions of belonging are shaped by personal, cultural and social...
Words: 385 - Pages: 2
...loved ones, which can be valued by contemporary audiences today due to it being an issue that is faced by everybody in their life at some point. When a loved one is no longer part of an individual’s life, one may experience grief and as a result realise the role and importance of that loved one. From my perspective, Harwood presents the concept of loss of loved ones through MWGML with the euphemism “You left the world so”, which highlights that her mother was not only a loss to her life but also a loss to the world, suggesting that she had great value and respect for her mother. There is a similar significance placed on her mother’s life that is stressed with the use of alliteration in “lived nearly thirty thousand days”. This presents the idea that she lived daily as a mother contributing to the lives of her children. Harwood also introduces a cloth motif in her poem, through the line “when she died she was folding a little towel” to highlight the importance of her day to day life. Harwood then sustains this motif later in her poem with “a fabric of marvels”. This motif, combined with “lived nearly thirty thousand days”, reinforces the concept that every day of her life was important. Also through the use of the...
Words: 854 - Pages: 4
...Cares is currently operating with positive margins based on this goodwill concept. Research shows that while some people cannot pay much or nothing at all, others that can afford to pay typically pay more (Ron Shaich, 2012). Panera Cares illustrates that business models do not always need to follow conventional management concepts. This concept is gaining recognition in the business world, local communities and also challenges other corporations to review their business models and strategies with consideration to the community and people that make them successful. Introduction Panera Bread has decided to take action regarding the slumping economy that has caused many Americans to go hungry. According to the US Department of Agriculture, last year, 17.2 million households faced food insecurity (Martin, 2012). The result of this growing epidemic is Panera Cares, a restaurant cafe where people can eat nutritious food in the same uplifting environment Panera is known for and pay whatever they can afford (Ron Shaich, 2012). Food insecurity in our country is the major concern of Panera Cares and is the heart of the company vision. A menu is available with a slight twist, no prices only suggestions; customers are encouraged to pay whatever they like. Each community cafe is self-sustaining; showcasing the common good in people to do the right thing. The business concept was created with the intent to build a partnership with the community and...
Words: 1397 - Pages: 6
...include: stability and change, individual and team, long and short term, autocratic and participatory and my topic, cost and quality. Any of these pairs are known to counter the other. In my case, it is important to note that when quality improves, cost generally increases and vice versa. Throughout this paper I will discuss managerial approaches to utilize these two concepts to your advantage without ever overlooking either of them. It is important to embrace the fact that there are polarities everywhere we turn and instead of trying to fight against them, we should develop their concepts to make us more complete. Larry Hirschhorn has argued that in order for managers to become proficient in managing polarities, they must develop a set of “rules of thumb” for when they encounter different circumstances. They establish these rules with the hopes of somewhat standardizing their way of thinking as well as how to allocate resources for each instance. The guidelines are generally developed to recognize patterns and opportunities. Hirschhorn recommends managers create a 2 x 2 table to help illustrate this concept and to categorize its different states. Each axis would include a “hi” and “lo” status with the top right box representing the “Hi-Hi” state. The “Hi-Hi” state would represent the situation which required the expert’s immediate attention (Hirschhorn, 2001, p. 12) Below is an example of a polarity map for my argument. Competitive Advantage Goods are manufactured...
Words: 856 - Pages: 4
...In the 1980s the usefulness of the FASB’s Conceptual Framework was soon questioned. Indeed, many researchers have pointed out the incompleteness, the inconsistency, the circular reasoning and non-operationality of the American Framework (Dopuch and Sundern, 1980; Solomons, 1986; Gerboth, 1987; Hines, 1989). Moreover, the decision-useful objective didn’t gather real support when the FASB carried out a survey to determine if constituencies did agree with the Trueblood report objectives of financial reporting (Dopuch and Sunder, 1980). Notwithstanding these issues, the FASB and the IASB go further towards a focus on capital providers needs in their joint project of revision of the Conceptual Framework when writing that financial reporting is not primarily directed to other groups than capital providers. There is a possibility that the objectives assigned to financial accounting as a social activity is directed by a dominant group that imposes its will on all others involved in the activity by making its own objective become the objective of the social activity (Dopuch and Sunder, 1980). Therefore, when criteria are used to justify the identification of primary users, there should be a comprehensive analysis of their definition, their importance for each category of users of financial reporting and if other criteria should be taken into account before reaching strong structuring conclusions on the objective of financial reporting and on identifying their primary users...
Words: 430 - Pages: 2
