...Jacob Moore GBA 673 Business Intelligence Jacob Moore GBA 673 Dr. Lara Preiser-Houy, CDP August 20th, 2013 1|Page Jacob Moore GBA 673 Table of Contents Abstract ....................................................................................................................................................... 3 Introduction ............................................................................................................................................... 3 Background ................................................................................................................................................ 4 Conceptualization ..................................................................................................................................... 4 BI 1.0 ......................................................................................................................................................... 4 BI 2.0 ......................................................................................................................................................... 5 BI 3.0 ......................................................................................................................................................... 5 Opportunities ............................................................................................................................................ 6 Challenges ........................................
Words: 6695 - Pages: 27
...Business Objects Developer Internal Req #: 5216 Client Req #: ST7080 Client: State of WI – DOT Location: Madison, WI The desired candidate will possess an advanced knowledge and skill with Business Objects Reporting Tools including Universe Designer, WEBI & DESKI Report Development and Dashboard Designer. They will possess strong analysis and design skills and be familiar with Business Intelligence and Data warehousing concepts. A solid understanding of relational data structures and proficiency in SQL development is a requirement. Prior experience with Business Objects XI Version 3 is preferred. This position will work directly with the DMV (Division of Motor Vehicles) Business Area to develop standard reports and universes for various projects. Mentor the business area on universe design and reporting. Excellent oral and written communication skills to be able to interact with staff at all levels of the DOT organization are a requirement. Additional skills should include: * Experience with dimensional models, Informatica ETL, Oracle, DB2, and MS Access * Collaborates with the team to define and follow DOT reporting standards and industry best practices * Strong problem solving and testing skills, and successful project leadership experience is a necessity * The selected contractor will show proof of experience in designing and implementing Business Objects Universes, reports and dashboards and have knowledge and experience in working on...
Words: 518 - Pages: 3
...中國工業工程學會九十年度年會暨學術研討會，高雄，民國九十年十二月八日 整合企業流程與物件導向分析方法於工程變更與物料需求之查詢系統 歐陽超* 黃群賀** 鄭宇雄*** 羅盛雄*** *國立台灣科技大學工業管理系 **國立台灣科技大學工程技術研究所自動化與控制學程 ***財團法人中衛發展中心電子商務部 ouyang@im.ntust.edu.tw 解決這個複雜的問題。 摘要 在目前大多以顧客需求導向環境中，發生工 2.文獻探討 程變更是無法避免的。生產製造作業能否順利進 行，唯有將物料需求計劃系統與產品資料管理系統 工程變更（Engineering Change）主要目標就 作整合，解決傳統工程變更的問題，提升工程變更 是針對產品、零組件材料製程、組裝順序做出變更 的效率。本研究之主要目的是將產品資料管理與物 修正，以使其在生產製造過程更有效率，或者滿足 料需求計劃之整合流程元件化以達到提升工程變 顧客的要求。但是頻繁過多的的工程變更會導致排 更的效率。 程計畫上的不穩定性而造成生產效率降低，而因工 本研究在建構模型系統方面，係以產品資料 程變更所引起的零件變更版本的型態管理也會造 管理及物料需求計畫為背景，採用企業流程塑模工 成產品資料庫管理上的問題出現，要如何對零件變 具對產品資料管理與物料需求計劃之整合流程建 更版本作有效的型態管理，使得工程變更的流程合 構模型，並配合利用代物件導向技術---統一模式化 理化、標準化，以提升工程變更的管理效率，正是 語言 （UML，Unified Modeling Language） 作為工具， 我們所需探討的課題。 將產品資料管理與物料需求計劃之整合流程模型 Ho 認為工程變更在製造工廠中為了保持競 轉換成 UML 模型，分析工程變更流程中的元件， 爭力、增加生產力所無法避免且需要的過程[1]。同 從分析結果中建構產品資料管理與物料需求計劃 時頻繁的工程變更是導致物料需求規劃系統績效 整合系統模組，使設計變更順利進行，提高生產系 惡化的主要因素之一，因為工程變更所引起的物料 統執行效率。 表更動，會使得物料表內所有階層下的元件及其他 關鍵字：產品資料管理、物料需求計劃、工程變更 使用相同零件的產品均會影響到物料需求系統的 展開。因此，減少不必要的工程變更對於整個企業 的發展是相當重要的。 1.研究背景與動機 在企業內繁雜的產品相關文件資料，產品資 工程變更對工程活動及相關資訊影響非常的 料管理(Product Data Management，PDM)系統將產品 大，工程變更的成因可以分為兩方面來探討，第一 資訊透過電腦化作有效的系統性的控制管理 PDM ， 為企業製造者反應所產生的內在因素如產品重大 管理範圍包含數量需求、產品規格、研發設計、製 瑕疵、安全問題、新增產品功能及降低成本等；第 造等相關資料，PDM 的出現與 MRP 相互整合會加 二方面為市場競爭者、顧客反應的外在因素如客戶 速資訊的流通與正確性，無疑地提供生產製造與設 特殊需求、市場趨勢因素等[2]。 計研發一個系統整合環境。以目前來說產品發展與 Albers 認為產品工程變更的理由有四點[3]： 規格數量大多是以顧客需求為導向，在這樣的環境 ...
Words: 1087 - Pages: 5
...1) You need to design a new Access database. The first step is to organize the smallest to largest data, also called: D) Hierarchy of data. 2) Access is a relational database, which means that the data are organized into a collection of related: C) Tables. 3) In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called: C) A field. 4) A pre-designed database that contains various pre-built objects is called: A) A template. 5) Tables and forms are examples of database: D) Objects. 6) Each major subject or grouping of information you will store in your database should have a separate E) Table. 7) When you need to create an interface to view, add, update, and delete data in Access, you should use a: A) Form. 8) If you want create a formatted, professional way to present and print the contents of your database, you use a: D) Report. 9) The last row in an Access table is called the: A) Append Row. 10) In a database, the special field that contains a unique value for each record is the: E) Primary key. 11) If any of your database columns display the ###### symbols, you need to: B) Widen the column. 12) When you first open a table in Datasheet view, Access uses the first field to sort the data records: C) In ascending order. 13) When you want to view only certain database fields such as product type, use this function: B) Filter 14) You need to find both a particular...
Words: 305 - Pages: 2
...1. Definition of privatize verb [with object] * transfer (a business, industry, or service) from public to private ownership and control: they were opposed to plans to privatize electricity and water 2. Definition of service noun * 1 [mass noun] the action of helping or doing work for someone: 3. Definition of harmonize verb [with object] * 1add notes to (a melody) to produce harmony: 4. Definition of exchange noun * 1an act of giving one thing and receiving another (especially of the same kind) in return: 5. Definition of market noun 1a regular gathering of people for the purchase and sale of provisions, livestock, and other commodities: they wanted to brows 6. Definition of currency noun (plural currencies) * 1a system of money in general use in a particular country: * e around the street market 7. Definition of devastating adjective * 1highly destructive or damaging: a devastating cyclone 8. Definition of productivity noun [mass noun] * the state or quality of being productive: the long-term productivity of land 9. Definition of graduate noun Pronunciation: /ˈgradʒʊət, -djʊət/ * a person who has successfully completed a course of study or training, especially a person who has been awarded an undergraduate or first academic degree. * North American a person who has received a high-school diploma. 10. Definition of influence noun * 1 [mass noun] the capacity to have an effect...
Words: 642 - Pages: 3
...Oracle9i: Program with PL/SQL Instructor Guide • Volume 2 40054GC11 Production 1.1 October 2001 D34008 Authors Nagavalli Pataballa Priya Nathan Copyright © Oracle Corporation, 1999, 2000, 2001. All rights reserved. This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation is delivered to a U.S. Government Agency of the Department of Defense, then it is delivered with Restricted Rights and the following legend is applicable: Restricted Rights Legend Use, duplication or disclosure by the Government is subject to restrictions for commercial computer software and shall be deemed to be Restricted Rights software under Federal law, as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights in Technical Data and Computer Software (October 1988). This material or any portion of it may not be copied in any form or by any means without the express prior written permission of Oracle Corporation. Any other copying is a violation of copyright law and may result in civil and/or criminal penalties. If this documentation is delivered to a U.S. Government Agency not within the Department of Defense, then it is delivered with “Restricted Rights,” as defined in FAR 52.227-14, Rights in Data-General, including Alternate III (June 1987). The information in this...
Words: 41259 - Pages: 166
...will not affect the accessibility of data. • Ad hoc capability of query implementation: This model provides a simple method to implement and manipulate data. Purpose of the entity – relationship model The entity – relationship model is a conceptual level model that facilitates database design. From the vantage point of acme global the ER model will provide great assistance in visual representations. They will be able to understand the required data of their clients. The ER model will also increase all productivity with the integration of relational database model. Overall your client’s solution and file design will be implemented in a safe and simple model. Essential components of an ER Model • Entity: Object that exists and that can be distinguished from other objects. • Attributes: The properties related to a particular entity are known as attributes. • Relationship: The term defines how two or more entities are related to each other. There are variations of relationships exist in ER model. o One to one relationship: Only one...
Words: 252 - Pages: 2
...1. What is the simplest SQL retrieval? The simplest versions of the most important SQL command are SELECT, FROM statement. Then if you need to limit the result you introduce the WHERE clause. In the WHERE clause you can use operators such as LIKE, AND, OR, EQUAL, BETWEEN and IN. 2. What is the purpose of the Where clause when using SELECT? The purpose of this clause is to be able to list any conditions that are to be applied to the data retrieved. 3. What are data types and why are they important? A data type is a classification identifying one of various types of data, they are important because assigning data types gives meaning to collections of information 4. Provide an example of the GROUP by clause, when would you use this clause? SELECT Salesperson, SUM(Revenue) AS ‘Total’, MIN(Revenue) AS ‘Smallest’, MAX(Revenue) AS ‘Largest’, AVG(Revenue) AS ‘Average’, COUNT(Revenue) AS ‘Number’ FROM Orders GROUP BY Salesperson You use this clause when you need to see the information in a certain order 5. What is an aggregate function (provide 4)? How are they used? An aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement AVG() - Returns the average value (average) COUNT() - Returns the number of rows (count) FIRST() - Returns the first value LAST() - Returns the last value 6. Provide example using the COUNT()...
Words: 363 - Pages: 2
...done separately prior to using the database. 2. Summarize in your own words the purpose of an E-R model specific to ACME Global Consulting. The E-R model can provide ACME Global with a specific, but open-ended design that is tailored to the company’s needs. This also allows us to sketch the design of a database informally and incorporate changes in order to avoid problems later on. The E-R model allows for growth beyond its ideas at inception. It lays the groundwork for later database relational designs. 3. List and describe essential components of the model such as entities, attributes, keys, relationships, roles, and dependencies specific to ACME Global Consulting. Entity: real-world object or thing with an independent existence and which is distinguishable from other objects. Examples are a person, car, customer, product, gene, book etc. Attributes: an entity is represented by a set of attributes (its descriptive properties), e.g., name, age, salary, price etc. Attribute values that describe each entity become a major part of the data eventually stored in a database. A key is a set of attributes for one entity set such that no two entities in this set agree on all the attributes of the...
Words: 313 - Pages: 2
... Term Paper Name: MANILA M V Roll No: CS08M028 Title: ThreeDimensional Password for More Secure Authentication Goal The goal is to design a multi factor authentication scheme that combines the the various authentication scheme into a single 3D virtual environment which results in a larger password space. The design of 3D virtual environment, the selection of object inside the environment, and the object type reflect the resulted password space. User have freedom to select whether the 3D password will be solely recall, recognition, or token based, or combination of two schemes or more. Brief Description of the System The proposed system is a multi factor authentication scheme. It can combine all existing authentication schemes into a single 3D virtual environment. This 3D virtual environment contains several objects or items with which the user can interact. The user is presented with this 3D virtual environment where the user navigates and interacts with various objects. The sequence of actions and interactions toward the objects inside the 3D environment constructs the user’s 3D password. The 3D password can combine most existing authentication schemes such as textual passwords, graphical passwords, and various types of biometrics into a 3D virtual environment. The choice of what authentication schemes will be part of the user's 3D password reflects the user's preferences and requirements. A user...
Words: 3177 - Pages: 13
...Case Study 1- Jenson Shoes The story begins with an African-American man named Lyndon Brooks, an employee at Jensen Shoes. Recent trends have identified a shortcoming in the company’s casual wear department. Brooks is therefore reassigned under the leadership of Jane Kravitz, much to his dismay. Several strategic objectives are formed to handle this shortcoming. Of these, two of the strategic objectives were assigned to Brooks, the Latino and African American markets. He was given a four month period to complete both objectives. According to a report pertaining to Brooks’ thoughts and impressions, he felt as if both the time allotted and the quality of manpower assigned to these two tasks were unreasonably lacking. Therefore the completion of both strategic objectives within the given timeframe to Brooks was infeasible. After several heated discussions between Brooks and Kravitz, Jane agreed to reassign the African-American strategic objective leaving only the Latino vertical markets to Brooks. Identifying the problem: Brooks vs. Jensen Shoes An important aspect to remember is that this case may contain a slight bias due to the fact that it is represented through merely Brooks’ perspective. Lyndon Brooks, a well educated Sociology graduate, is assigned to work under Jane Kravitz, manager of casual wear at Jenson Shoes. We see from analyzing the given report that Brooks had expressed disdain from the beginning. Initially assigned as a “Product Promotions Manager,” Brooks had...
Words: 1982 - Pages: 8
...HOME WORK # 4 REVIEW QUESTIONS 4.4 In the context of access control, what is the difference between a subject and object. A subject is an entity capable of accessing objects (eg. user, application, process). A subject is typically held accountable for the actions they have initiated, and an audit trail may be used to record the association of a subject with security relevant actions performed on an object by the subject. An object is resource to which access is controlled. An object is an entity used to contain information. Any user or application actually gains access to an object by means of a process that represents that user or application. The process takes on the attributes of the user, such as access rights. In general, object is an entity used to contain and or receive information. Examples include records, blocks, pages. Segments, files, portion of files, directories, directory trees, mail boxes, messages and programs. 4.9 List and briefly define the four types of entities in a base model RBAC system. *USER: An individual that has access to this computer system. Each individual has an associated user ID. *ROLE: A named job function within the organization that controls this computer system. *PERMISSION: An approval of a particular mode of access to one or more objects. *SESSION: A mapping between a user and an activated subset of the set of roles to which the user is assigned. PROBLEM: 4.8 Assume a system with N job positions. For job position...
Words: 305 - Pages: 2
...5 Marks each) Short Answers: 1. Write differences between CLS and CLR CLS specifies a set of rules that needs to be adhered or satisfied by all language compilers targeting CLR. It helps in cross language inheritance and cross language debugging. .Net Framework provides runtime environment called Common Language Runtime (CLR).It provides an environment to run all the .Net Programs. 2. Write a function that takes any number of strings and an integer. Write only prototype and call this function using named argument Public void myFunc(int num, params string[] args); myFunc(1,”Ali”,”Ahmad”); 3. What is return type of following methods? ExecuteNonQuery() | int | ExecuteScalar() | object | ExecuteReader | SqlDataReader | 4. fill in the following table for n-tier architecture only write yes or not Scalability | Yes | Better security | Yes | Fault tolerance | Yes | Performance | No | Maintenance | Yes | 5) suppose a data table student(id,name,email) exist in...
Words: 757 - Pages: 4
...Forum 4 REDO S-M-A-R-T Specific- are your objectives stated in a way that is precise about what you are hoping to achieve? Measurable – Can you quantify each objective, i.e. can you use a unit of measure such as market share in percentage or dollars or other to provide a way to check your level of success? Achievable- Are your objectives reasonable in terms of what you can actually achieve or are you setting your sights too high? Realistic- Do you have objectives you have seet, if you don’t then they are likely to be unrealistic? Time specific – When are you hoping to achieve these objectives, you need to define a timing plan with target timing for each specific objective? Example: A goal is a broad primary outcome A strategy is the approach you take to achieve a goal An objective is a measurable step you take to achieve a strategy A tactic is a tool you use in pursuing an objective associated with a strategy Goal: increase sales revenue by 25% by end of year Objectives: Increase awareness of our website to TA by 100% by the end of the year Increase traffic to website by 50%compared with last year. Increase repeat purchases by 10% compared with last year Increase average order value from 50% compared with last year Example strategy: 1. engage TA at key touch points in their day when receptive to brand messaging 2. Drive traffic from new unique visitors to your website 3. encourage repeat purchases form existing customers ...
Words: 318 - Pages: 2
...{Module} | {Direktiven} | {FAQ} | {Glossar} | {Seitenindex} Apache HTTP Server Version 2.2 {[ {HTTP-Server} > {Dokumentation} > {Version 2.2} Anbindung Verfьgbare Sprachen: { de } | { en } | { fr } | { ja } | { ko } | { tr } Diese Ьbersetzung ist mцglicherweise nicht mehr aktuell. Bitte prьfen Sie die englische Version auf die neuesten Дnderungen. Konfiguration der vom Apache verwendeten Adressen und Ports. * {Ьberblick} * {Betrachtung von IPv6-Besonderheiten} * {Das Zusammenspiel mit virtuellen Hosts} Siehe auch * {Virtuelle Hosts} * {Probleme bezьglich DNS und Apache} {[top]} Ьberblick Referenzierte Module Referenzierte Direktiven * {core} * {mpm_common} * {} * {Listen} Beim Start bindet sich der Apache an bestimmte Adressen und Ports der lokalen Maschine und wartet auf eingehende Anfragen. StandardmдЯig lauscht er an allen Adressen des Systems. Es muss ihm jedoch mitgeteilt werden, an bestimmten Ports zu lauschen oder nur an ausgewдhlten Adressen, bzw. einer Kombination aus beidem. Dies wird oft mit der Funktionalitдt virtueller Hosts kombiniert, die bestimmt, wie der Apache auf verschiedene IP-Adressen, Hostnamen und Ports reagiert. Die Direktive {Listen} weist den Server an, eingehende Anfragen nur an bestimmten Ports oder Adress/Port-Kombinationen zu akzeptieren. Wenn bei der {Listen}-Direktive nur eine Portnummer angegeben wird, dann lauscht der Server auf allen Netzwerkinterfaces an dem angegebenen Port. Ist auch eine IP-Adresse...
Words: 805 - Pages: 4
