Data Essay

775 words - 4 pages

Business Analytics for Managers
Import Data from CSV into Framework Manager
1. Save all your tables or .csv file under one folder. In our case we will use the Test folder saved on blackboard with three .csv files named TestData_Agent.csv, TestData_Customer.csv, TestData_InsuranceCompany.csv.
2. Now , locate the correct ODBC exe at “C:\Windows\SysWOW64\odbcad32.exe”
3. Once the ODBC Data Source Administrator is open, go to the “System DSN” tab and click “Add”.

4. Select “Microsoft Text Driver (*.txt, *.csv)” if you want to import from csv files.
5. Unclick the “Use Current Directory”, and then click Select Directory to define the path of your data source. Give data ...view middle of the document...

18. Close the window after succeeded. Hit Finish and Select the datasource that you have just created-“TestData” and hit Next.

19. Select the Schema and tables you created in the above steps and click next.
20. Keep the Generate Relationships page as default and click import and then hit Finish.

21. Test the query objects in Framework Manager. Select any table, in this case “TestData_Customer.csv”. Right click and go to edit definition and go to Test tab. Click Test Sample in the right corner and examine the result.

22. Rename TestData_agent.csv, TestData_Customer.csv, TestData_InsuranceCompany.csv to Agent, Customer and Insurance Company respectively.
23. Under Data Sources Select the data source ‘TestData’ and go to the property pane window on the right hand side. Make sure Limited Local is selected for query Processing option.
24. Create Cardinalities/Relationship between query objects or tables from Framework Manger. To do this, Select TestData Namespace and click Diagram on the right hand side pane.

25. Select any two tables to start. In this case Select Insurance Company and Customer together by pressing ctrl+click and right click and got to CreateRelationships.
26. We will set up M:N relationship between Insurance Company and Customer and validate relationship and click ok. Make sure to connect InsCompanyID columns in both of the...

Other assignments on Data

Data Center Essay

932 words - 4 pages 26.11.13 Xavier Muñoz Assignment 1a – Google Data Center 1. What is PUE, and why is it an important place to start when considering how to reduce data center power consumption? What value of PUE should data center managers strive for? Power Usage Effectiveness (PUE) is a measure to determine the energy efficiency of a data center. It is the ratio between the energy of the system and the

Data Security Essay

8305 words - 34 pages minimize the security risks of transmitting sensitive data across the Internet. 2.2.1. Security Definition (Security Properties) Protecting information from unauthorized access, use, disclosure, disruption, modification, inspection, recording or destruction in order to provide confidentiality, integrity, and availability is the main goal of information security [NIST 2009]. Security is the ability of a computer system to withstand

Big Data Analytics

7653 words - 31 pages Challenges and Opportunities with Big Data A community white paper developed by leading researchers across the United States Executive Summary The promise of data-driven decision-making is now being recognized broadly, and there is growing enthusiasm for the notion of ``Big Data.’’ While the promise of Big Data is real -- for example, it is estimated that Google alone contributed 54 billion dollars to the US economy in 2009 -- there is

Kudler Foods Data Tables

599 words - 3 pages Kudler Foods Data Tables Kudler Fine Foods was founded in 1998 by Kathy Kudler as an upscale specialty food store. The first location of Kudler was in La Jolla, CA, followed by stores opened in Del Mar and Encinitas. Kudler Fine Foods offers its customers selections in bakery and pastry products, fresh produce, fresh meat and seafood, condiments and packaged foods, as well as cheese and specialty dairy products. This brief will evaluate the

The Big Data Challenge

763 words - 4 pages Companies face many challenges when it comes to capturing, storing, searching, and analyzing Big Data. Big Data is a term used to describe the voluminous amount of structured and semi-structured data generated by companies. This paper will focus on The Volvo Car Corporation and how they were able to face this problem due to its voluminous amounts of data being streamed for their vehicles. I will go over how Volvo was able to integrate Cloud

Data Mining Term Paper

5913 words - 24 pages FINAL REPORT DATA MINING Reported by: Nguyen Bao An – M9839920 Date: 99/06/16 Outline In this report I present my study in the Data mining course. It includes my two proposed approaches in the field of clustering, my learn lessons in class and my comment on this class. The report’s outline is as following: Part I: Proposed approaches 1. Introduction and backgrounds 2. Related works and motivation 3

Data Resource Of Evaluation

612 words - 3 pages Governance and Management in Education at IIEP. Recently, he focuses on the fields of institutional reorganizing of higher education and private higher education. These main areas are closely related to the topic of text. Based on these information, it can be stated that the paper is authoritative. * Reliability / Validity The paper contains five tables to illustrate comparison clearly. These data comes from three different sources: a. UIS (UNESCO

Salem Telephone Data Corp

2617 words - 11 pages -even Analysis 12 Appendix H- “What if” Analysis 13 Executive Summary Since 2001, Salem Data Services has been operating at a net loss. After review the reports from first quarter 2004, it has become apparent that action will be necessary. Through our examination of the first quarter 2004 reports, we have concluded three key areas to focus on. These include utilization of computer usage hours, how the results of the operations have been

Target Data Breach

441 words - 2 pages What exactly happen? Over 40 million credit cards and debit cards that were swiped at a US Target store may have been exposed. The stolen data includes customers’ names, credit card debit card numbers, expiration date and the security code. What was the impact from this happening? The Impact from the data breach was customer information was stolen and card numbers. What was the monetary loss? Each cards that was stolen was taken 18-37

Data Collection Techniques

476 words - 2 pages Data Collection Techniques The data collection technique I have chosen is observational research otherwise known as field research. The generalizability would be to ascertain how a certain group reacts to, or is motivated by certain social settings to obtain a desired outcome. What causes certain people to behave a certain way or react differently from others in different social settings and what the effect it may have on a social standing. My

Data Base Esign

483 words - 2 pages Stephen Favor (CPD121) Assignment Lab 2-3 TR10 1. What is an entity? * An entity is something about which we want to keep data. There are physical entities; something physical in our universe (e.g., a person, place, thing, etc.). There is also a logical entity; something non-physical (e.g., a relationship).Three examples of an entity could be a gun, Airline, and a camera. 2. What is a relationship? * A relationship is a logical

Similar Documents

Data Essay

621 words - 3 pages Introduction to the HR area being investigated Over the past few years, my organisation has had a reluctance to recruit permanent labour. To combat this, for every permanent member of staff that leaves, either due to ill health, age or other governing reasons, we are instructed to backfill with temporary labour. The collated data is being used to investigate the effect of this shift in labour pattern, paying particular attention to staff

Data Essay

324 words - 2 pages base Database Design Paper DBM 380 A database system arrange information in a computer, enforced by a set of computer programs. An organization of this kind should offer simplicity an easy way to access connect, display and collect information. A database management system allows users the capability to enter data within the database by the use software. This software is designed

Data Dictionary Essay

653 words - 3 pages Data Dictionary There are several advantages for aggregated data being used in health care. Aggregated data is the consolidation of data relating to multiple patients. This data is used to establish information about groups of patients. It allows to identify common components that can help to anticipate the course of the disease or provide information about the most useful way to treat the disease. Aggregated data is a great way to educate

Big Data Essay

1070 words - 5 pages streaming music etc.) or in professional environments (cloud data centers in various corporate operations). This case study takes a brief look into how Volvo took advantage of this technology to create value. Also, related issues with how data and information is utilized in this company are discussed as well. Integrating cloud infrastructure Understanding cloud technology is important to understand its implementation and integration for business needs