Free Essay

Business Data

In:

Submitted By makarandwaghle
Words 2889
Pages 12
HBR.ORG

How I Did It…

Bart Becht is the CEO of Reckitt Benckiser, headquartered in Slough, England.

Building a Company Without Borders
AN ITALIAN IS RUNNING THE UK BUSINESS A DUTCHMAN IS RUNNING THE U.S. BUSINESS AN AMERICAN IS RUNNING THE GERMAN BUSINESS

by Bart Becht
A FRENCHMAN IS RUNNING THE RUSSIAN BUSINESS

AN INDIAN IS RUNNING THE CHINESE BUSINESS

A BELGIAN IS RUNNING THE BRAZILIAN BUSINESS

T
THE IDEA

You may never have heard of Reckitt Benckiser, but in the past few years the company has outperformed its rivals P&G, Unilever, and Colgate in growth—even during the downturn. Here’s how.

hey say you can’t go home again. If you work for Reckitt Benckiser, you can go home—but you may not want to, and you certainly won’t have to. Many companies, when they describe themselves as global, mean they have operations around the world, they work virtually and in all time zones, and their key people are developed through stints in other markets. Our version is more comprehensive. Most of our top managers haven’t held jobs in their countries of origin for years and view themselves as global citizens rather than as citizens of any given nation. We have operations in more than 60 countries. Our top 400 managers represent 53 different nationalities. We’ve spent the past 10 years building this culture of global
April 2010 Harvard Business Review 103

HOW I DID IT

mobility because we think it’s one of the best ways to generate new ideas and create global entrepreneurs. And it has paid off. Products launched in the past three years—all the result of global cross-fertilization—account for 35% to 40% of our net revenue. For example, Finish, an all-in-one dishwasher tablet you drop into your machine, is now the leader in its market category. Recently we successfully introduced QuantuMatic—an automatic dispenser of dishwasher detergent that doesn’t need to be refilled for up to a month. With constant innovation like this we’ve enjoyed steady, profitable growth, even during the downturn. Since 2005 we’ve outpaced all our big competitors. During the recession

we’ve invested more than ever in marketing, and we grew at a rate of 8% (at constant exchange rates) in 2009.

A Company Without a Country
Reckitt Benckiser resulted from a merger in 1999 of Reckitt & Colman—a British purveyor of household cleaning products with a great stable of brands—and the Dutchlisted Benckiser, a much smaller but betterperforming consumer goods company. But we don’t want to be known as an AngloDutch enterprise, or by any other label based on our operations or history. We’re not any country’s company—we’re a truly multicountry company. That is by design. Postmerger we mixed the national cultures quickly in every corner of our operations. Premerger many of the local businesses had been running themselves more or less independent of the rest of the world and without regard to overall corporate priorities. We transferred people who embodied RB’s values into key positions in new markets. Managers from one side of the merger were purposely moved to another territory, and then moved again. Now in every country we have people of many nationalities as well as local citizens. Today an Italian is running the UK business, and an American is running the German business. A Dutchman is running the U.S. business, an Indian the Chinese business, a Belgian the Brazilian business, and a Frenchman the Russian business. It’s not that you can’t advance at RB in your local company. You can. But we also offer unique global mobility and experience to people who want to grow their careers on a world stage. To facilitate this mobility, we established compensation rules that apply equally to our top 400 managers in all markets, making international transfers easy. We have just one employment contract, and our salary ranges were developed with global benchmarking. Our annual cash bonus structure and long-term incentive plans are the same for everyone, as are our pensions, medical plans, and other benefits. We have no expatriates in the traditional

The RB “Powerbrands”
Though the company’s corporate brand recognition is very low, its products are well-known. RB focuses on 17 powerbrands:

Air Wick Calgon (water softener) Cillit Bang Clearasil Dettol Finish French’s (PREVIOUSLY ELECTRASOL Gaviscon AMERICA) IN NORTH Harpic Lysol Mortein Mucinex Nurofen Strepsils Vanish Veet Woolite
104 Harvard Business Review April 2010

sense, no tax equalization or guarantee of a job back in one’s home country. When employees take jobs in other countries, they’re transferred as “local hires.” We’ve built in standard protocols to make it easier for people with families to move. For example, we fund whatever school the employee chooses for his or her children because we understand how important that is to a family’s adjustment. That way, we can instantly accomplish a transfer—we don’t have to negotiate a lot of convoluted contractual nonsense. We have moved people to new countries in as little as two days. We also do something pretty rare with graduates. In some markets we help foreign students to get work permits in the countries where they’ve been studying. The very fact that they have traveled to study means they are internationally minded and thus likely to be keen to work in other countries as well. At a lot of companies it’s assumed that employees, having “seen the world,” will sooner or later return to their home countries to continue their careers. Our idea is that you focus primarily on the best job possible for you, regardless of country. That kind of life isn’t for everyone, and not everyone has to follow that path. But those who love it really love it. It’s exciting, and it gives pace, challenge, learning, and a buzz to people’s careers—along with the satisfaction of being able to be entrepreneurial and innovative. We try to put our high potentials in stretching situations around the globe. For example, we had one excellent employee who wanted to be moved to an international marketing job. We had an opening in India, but that would have been a poor choice for him—he’s Indian. Our previous three marketing people in India were German, French, and British. If this employee wanted to grow, he needed to acquire different experiences and learning, so a better development opportunity would be for him to work in Brazil or Mexico. Our high potentials have to find their footing very quickly, and most of them grow tremendously when we take them out of their familiar zone.

HBR.ORG

1999 9
£3,054 £357 Total
Operating Profit (£M) Net Revenue (£M)

Reckitt Benckiser at a Glance
A DECADE OF GROWTH
£ MILLIONS 8,000 7,000 6,000 5,000 NET REVENUE 4,000 3,202 3,000 2,000 1,000 OPERATING PROFIT 1,891 7,753

2009 9
£7,753 £1,891 Total
Operating Profit (£M) Net Revenue (£M)

2003

2001

2004

2005

2006

2007

2000

2002

2008

2009

20,200

Employees

Employees
451

24,933
SOURCE RECKITT BENCKISER

Even their failures in new markets are important learning experiences for our high potentials. One of our top managers, who is Dutch, still talks about the hard lesson he learned when we transferred him to Turkey. In The Netherlands, where he had worked before, billing and receivables were predictable and orderly. In Turkey the currency suddenly collapsed by 70%—while he was focusing on market share rather than on delinquent receivables. As he puts it, there’s nothing like a currency failure to change your views on tight financial management.

If you don’t express your opinion, you don’t have an opinion, and that’s a fatal weakness for people who want to do well at Reckitt Benckiser.
That means our meetings are a bit chaotic. Everybody wants to be heard, so it’s more like an Italian family dinner than a nicely organized board meeting. What takes over in our meetings is an intensity and a feeling that we have to fight for better ideas. Conflict is good. We don’t care about consensus. Not having it doesn’t slow us down and doesn’t mean that people aren’t aligned. We make decisions fast and then all stand behind them. What isn’t tolerated is conflict that simply slows down decision making or is for political or personal gain. Almost every key decision is made in the meeting at which it’s first discussed. We expect people to come armed with facts, be prepared to argue their point of view, and be willing to live with the decision we ultimately make. Get 80% alignment and 100% agreement to implement. And move quickly. But I also don’t believe in crushing minority views. If we have 10 people in a room, eight of them agreeing on one thing and two passionately believing something else, we don’t try to resolve it to everyone’s satisfaction. We allow those two to experiment with their ideas—even if everyone else thinks they’re wrong. At the end of the day, what counts is not what the 10 people in that room think, it’s what the consumer thinks. So we let them run maverick smallscale experiments to get consumer feedback. Sometimes our biggest ideas come that way. About six years ago we had a huge internal debate about a product called Air Wick Freshmatic, which automatically releases freshener into the air on a schedule. It originated when one of our brand managers in Korea observed a new kind of automatic scent dispenser in stores there. In his opinion it was not a well-designed product, but he thought the idea was intriguing, so he brought it to a group meeting at our headquarters. Vigorous debate ensued.
April 2010 Harvard Business Review 105

Conflict Is Good
With so many different native languages in our company, it was necessary to make English the official language for all meetings. I’m Dutch, but I don’t speak Dutch with any of my Dutch colleagues, because if others are around, it excludes them. We are one team with one language. English isn’t most people’s native language, and often our English isn’t pretty. But the way we see it, it doesn’t matter as long as you give a view. If you don’t express your opinion, you don’t have an opinion, and that’s a fatal weakness for people who want to do well at Reckitt Benckiser. You have to stand for something, no matter how bluntly you communicate it.

HOW I DID IT

HBR.ORG

RB’s Performance-Based Remuneration
Reckitt Benckiser believes it has designed a compensation plan to foster its innovative and entrepreneurial culture. The company has touted performance-oriented pay in its annual report as key to RB’s strong growth. According to a 2006 Harvard Business School case study, the plan, which applies to the company’s top managers (including the CEO), consists of three parts: base salary, short-term incentives, and long-term incentives. Base salaries are set near the median for competitors’ pay. The real benefit comes in the form of bonuses. A manager who meets all targets will typically receive 40% of his or her base salary as a bonus that year. A manager who blows the targets out of the water

A manager who blows the targets out of the water can earn a bonus of up to 144%.

(usually that means doubling the target numbers) can earn a bonus of up to 144%. Long-term compensation, in the form of options and performance-related restricted stock, depends on meeting three-year corporate growth targets for earnings per share. New long-term goals are put into place each year. —Karen Dillon

A couple of our managers believed it should be a consumer product in Europe, but a lot more thought that made no sense— it might work in Korea on a very small scale, but it would never work in Western markets. For one thing, it would have to be priced well above the standard air freshener, and it wasn’t clear that the market would support that. Also, this would be our first foray into something electronic, with wires, batteries, interval switches—a complex technology combination. The product would require new manufacturing facilities if it went to any scale. But two people

meant we had to source materials we had no prior experience with. Today Air Wick Freshmatic is sold in 85 countries, with a wide range of options for consumers. It generates well in excess of £200 million annually. That product had the most successful launch in our history. Of course, things don’t always work out that well. We’ve launched some beautifully thought-out products that we were passionate about—but consumers weren’t. A few years ago we introduced a wonderful product to clean your microwave: You put a little sachet into the oven and start it. While

If someone wants to stand up under stress and say, “No, I passionately believe in this,” then I’m willing to take a chance. saw the potential and were willing to fight for the chance to prove it. If somebody wants to stand up under stress and say, “No, I passionately believe in this. You guys are all wrong! We’ve got to do this,” then I’m willing to take a chance. So in this case I said fine, here’s the money— go figure it out, but do it on a small scale. And that’s what they did. In January 2004, initial testing of the idea with consumers in the UK produced extraordinary results. By the end of the year the product was in more than 30 other countries, and we’d overseen the building of a new factory in China to make it—which
106 Harvard Business Review April 2010

the oven is heating, the sachet pops and spreads cleaner around. When it’s finished, the sachet has become a cloth to wipe your cleaner away. It was a beautifully designed product. But it turns out that people don’t actually want to clean their microwaves all that often, so we pulled it from the market. If we are going to fail, we want to fail small and quickly. Failure is actually a huge incentive for the kind of people who fit well with our company, because they’re so personally competitive that they’ll work even faster for the next success. Everyone wants to do something to get on the map.

I just moved one manager from Chile to Turkey. He earned that move because he had done something very challenging in his market—he’d launched one of our “powerbrands,” the sanitizer Dettol, in Latin America. It wasn’t the biggest success we’ve ever had, but the point is that he did it. He was the guy who brought Dettol to Chile and created a platform for its growth. That’s his mark on the business. That kind of thing earns you a promotion in this company, and the promotion will probably take you to another part of the world. Some people look at us and think they’d have to be nuts to work here. We’re looking for people with a certain level of maturity, intensity, and competitiveness. If you bring all of that to Reckitt Benckiser, it will be rewarded. (See the sidebar “RB’s Performance-Based Remuneration.”) As the CEO who has guided the company for more than a decade, I’d like to take credit for having a brilliant strategy or unique insights into the global marketplace. But in reality the “vision” slide we use today is the exact same one we’ve used since the merger. We have a very simple approach to the business: Focus on 17 powerbrands in fast-growing categories, innovate and invest behind them—and do so in every market. At the end of the day, what is most distinct about Reckitt Benckiser is its people and culture. I can tell in three minutes if someone would be a good fit for our company. We’d rather have a position open for a long time, if necessary, than put the wrong person in place. It’s that important. HBR Reprint R1004K

Harvard Business Review Notice of Use Restrictions, May 2009 Harvard Business Review and Harvard Business Publishing Newsletter content on EBSCOhost is licensed for the private individual use of authorized EBSCOhost users. It is not intended for use as assigned course material in academic institutions nor as corporate learning or training materials in businesses. Academic licensees may not use this content in electronic reserves, electronic course packs, persistent linking from syllabi or by any other means of incorporating the content into course resources. Business licensees may not host this content on learning management systems or use persistent linking or other means to incorporate the content into learning management systems. Harvard Business Publishing will be pleased to grant permission to make this content available through such means. For rates and permission, contact permissions@harvardbusiness.org.

Similar Documents

Premium Essay

Business Data Warehouse

...diagram, the following: Primary Data Warehouse and Data Mart. In this connection, explain the difference between ROLAP and MOLAP. A Primary Data Warehouse is a central repository of a database of a complete organization. It holds multiple subject areas and very detailed information. A Data Mart is a subset or an aggregation of the data stored to a primary data warehouse. It often holds only one subject area – for example, a specific department, finance or sales. It may hold more summaried data, and is typically smaller than a warehouse because of its employment on a different grain. Figure 1.1 illustrates the difference between data mart and a primary data warehouse. Since the data mart typically holds one subject area, it is much smaller than a primary data warehouse. These data marts can be viewed as small, local data warehouses replicating the part of primary data warehouse which is required by a specific domain or department. Data Warehouse Data Mart Data Warehouse Data Mart Figure 1.1 A data warehouse does not necessarily use a dimensional model, since it is partly normalized RDBMS, but data marts are multidimensional cubes. This connection gives arise to two concepts, ROLAP and MOLAP. ROLAP is an implementation based on a relational database, in our case which is a primary data warehouse, and MOLAP is an implementation based on a multidimensional database which are data marts. ROLAP tools use the relational database to access the data and generate SQL queries to calculate...

Words: 685 - Pages: 3

Premium Essay

Data Mining for Business Intelligence

...Introduction to Data Mining 3 2. Characteristics and Objectives of Data Mining 3 3. Data type in Data Mining 3 4. Patterns of Data Mining 4 5. Applications of Data Mining 5 6. Data Mining Process Models 6 7. Classification of Techniques 7 8. Common Data Mining Mistakes 8 9. Data Mining softwares 8 10. References 8 Data Mining for Business Intelligence Introduction: Business Intelligence (BI)is defined as the set of techniques and tools that transform the raw data into meaningful and useful information for business analysis. The main goal of business analyses is to...

Words: 1668 - Pages: 7

Premium Essay

P1: The Importance Of Organizing Data In Business

...It is easy to create lots of data and then become disorganised very quickly. There are many different ways as to how data can be organised. You need to consider your other work colleagues who may need to find specific files at a later date, therefore it is important to decide on an effective way that works best for you and your team. To ensure your data is understood, you should try these different ways of organising data that are listed below:  Name and organise your files. This allows you and others to have the ability to easily locate them.  Organise e-mails. You should try to have different folders for specific projects and so on, by creating individual folders, this again allows easy access when it comes to finding the files and it shows you have capable organisational skills and helps to maintain the department in some ways. ...

Words: 628 - Pages: 3

Free Essay

How Big Data Become Business Opportunities

... Companies then can utilize the data internally in the light of customer analyzing, marketing strategies developing or even business forecasting. Let’s consider an insurance company as an example. If a father wants to buy a juvenile saving insurance plan for his child, he needs to provide his personal information to the insurance company, such as name, gender, age, contact number, income and health status etc. This facilitates the process of premium calculating and policy approving by the underwriter. On the other hand, data is collected during this buying process. As insurance company had grasped information from many customers, it is easily to carry out data analysis. Clients are classified into different segments according to their total amount of annualized premium, age, marital status, product type and so on. Analysts can interpret the current situation of the company from the summary of the data. For instance, what products sold the most last quarter? Which age group of people is our target customers? What is the buying behavior of a specific group of people? Use the above example again, if the company wants to enhance the father’s total product experience and increase customer retention, companies can perform data analysis to find out which product can be recommended to him. Besides, various marketing campaigns can be worked together in order to increase the loyalty and satisfaction of customers. Apart from the description of data,...

Words: 426 - Pages: 2

Premium Essay

Assignment 3: Business Intelligence and Data Warehouses

...3: Business Intelligence and Data Warehouses Kevin Sloley Professor Dammlash Gebre CIS-111 Intro to Related Database Management Systems Due March, 2016 Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data. The primary difference between your application database and a data warehouse is that while the former is designed (and optimized) to record, the latter has to be designed (and optimized) to respond to analysis questions that are critical for your business. Application databases are OLTP (On-Line Transaction Processing) systems where every transaction has to be recorded, and super-fast at that. Consider the scenario where a bank ATM has disbursed cash to a customer but was unable to record this event in the bank records. If this started happening frequently, the bank wouldn't stay in business for too long. So the banking system is designed to make sure that every trasaction gets recorded within the time you stand before the ATM machine. This system is write-optimized, and you shouldn't crib if your analysis query (read operation) takes a lot of time on such a system. A Data Warehouse (DW) on the other end, is a database (yes, you are right, it's a database) that is designed for facilitating querying and analysis. Often designed as OLAP (On-Line Analytical Processing) systems, these databases contain read-only data that...

Words: 1350 - Pages: 6

Premium Essay

Assignment 3 Business Intelligence and Data Warehouses

...August 29, 2015  Business Intelligence and Data Warehouses Student’s name: Professor’s name: Course title: 1. Differences between the structures of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data Data Warehouse is a database which is designed to process for query and analysis rather than for transaction processing, and it is usually contains historical data derived from transaction data, but can include data from other sources while relational database optimized for online transaction which includes insertions, updates and deletion. Basically Data Warehouse is defined as a subject-oriented, non-volatile and time –variant collection of database which support management’s decisions. Data Warehouse is very distinct from online transaction systems. Some of distinctions are given below: * One of main difference, a data warehouse you can do separate analysis workload form transaction workload which makes it very much read-oriented systems. * They deal higher amount of volume in comparisons to online transaction database. * They have a far higher amount of data reading versus writing and updating. This enables far better analytical performance and avoids impacting your transaction systems. * A data warehouse system can be optimized to consolidate data from many sources to achieve a key goal. * it prevents many disputes and enhances decision-making efficiency ...

Words: 763 - Pages: 4

Premium Essay

Business Analytics Using Secured Data Forwarding

...Business Analytics using Secured Cloud Storage System M Swetha Chandra1, M Suma Latha2, KODAVATIKANTI S M Aditya Kumar3, S K R Swamy4 1,2,3,4 Department of CSE, TRR College of Engineering, Inole, Patancheru, Hyderabad, AP, India 1 sweet.smily99@gmail.com 2 msumalathacse@gmail.com 3 smaditya@gmail.com 4 kramas2004@yahoo.com | | | ABSTRACT Business analytics go far beyond reports, dashboards, and scorecards. Analytic impact occurs after the numbers are delivered, and analytic value is driven by the kinds of questions that are answered. Ordinary analytics tell you what has already happened. Good analytics provide insight into why things happen, and great analytics provide foresight to see what lies ahead. Today’s business climate demands extraordinary analytics. Business managers need to know more than what. The hard questions today are why, what if, and what next. According to Gartner, BI and Analytics is a $12.2 billion market with 16.4% growth in 2011. Gartner's 2012 CIO survey showed that analytics/BI is the No. 1 technology priority for CIOs. The mega vendors such as Oracle, SAS, IBM etc., are already having major portion of the revenue with their packaged applications in these areas. It is estimated by Gartner that Analytics will be touching 75% of potential users by 2020. This is proven by the growth rate of new vendors such as QlickTech and Tableau by 45% (as per Gartner report). Cloud Storage: Cloud Storage, also referred as Data Storage as a Service, is...

Words: 2222 - Pages: 9

Premium Essay

What Business and Social Problems Does Data Center Power Consumption Cause?

... What business and social problems does data center power consumption cause? Data center power consumption economically affects businesses and environmentally affects society. Operating costs for data centers is very expensive. In the article, "Ubiquitous Green Computing Techniques for High Demand Applications in Smart Environments," the total operating costs, concerning electricity, of all data centers within the U.S. alone exceeded 7 billion dollars in 2010 (Ayala, J., Moya, J., Risco-Martín, J., Sanchez, C., Zapater, M. 2012). The article then explains that data centers consumed 61 billion kilowatt-hours in 2006;the Environmental Protection Agency provided this statistic to the US Congress in a report from 2007 (Ayala, J., Moya, J., Risco-Martín, J., Sanchez, C., Zapater, M. 2012). With this amount of energy being consumed by data centers, it is a cause for concern; consequently, data centers have an impact on the cost of business and negatively impact the environment via carbon footprint. As the carbon footprint grows, there is a need to realign the way businesses looks at managing their data centers. Several companies including Cisco, Dell, Google, HP, IBM, and Intel have announced efforts to reduce the environmental footprint of their product offerings (Chang et al., 2012). Large technology companies are starting to understand that being environmentally friendly is good for the wallet and good public relations. Understanding how to manage and build better data centers...

Words: 4296 - Pages: 18

Premium Essay

The Importance of Data in Business

...The Importance of Data in Business The Importance of Data in Business Information is a subset of data, including data that possess context, relevance, and purpose (Sabherwal, & Becerra-Fernandez, 2011, p.5). Information more than likely involves the manipulation of raw data to obtain a more well-rounded indication of patterns or trends in the data itself. Humans are social animals that depend on interaction with others for daily needs, this interaction is possible through a mutual data network between them (Uddin, 2010). As with every advance in communication technology, the creation and interconnection of robust data networks are having a profound effect. Early data networks were limited to exchanging character based information between connected computer systems. Today’s current data networks have evolved right in front of our eye’s in to something spectacular, now we can carry voice, video streams, text, music and photos over many different devices (Uddin, 2010). In 1990 the use of the internet to gather data spread faster than anyone ever imagined, it once was used for a way for researchers at university’s to exchange information, but when people and businesses figured out how to take advantage of this web based communication the internet grew to limits we never thought imaginable. This sparked the creation of a new age with many new businesses and careers. Data exchange over the internet can and has also saved lives. In the year of 2008 a mother saved her sons...

Words: 480 - Pages: 2

Premium Essay

The Importance of Data in Business

...The Importance of Data in Business The Importance of Data in Business Information is a subset of data, including data that possess context, relevance, and purpose (Sabherwal, & Becerra-Fernandez, 2011, p.5). Information more than likely involves the manipulation of raw data to obtain a more well-rounded indication of patterns or trends in the data itself. Humans are social animals that depend on interaction with others for daily needs, this interaction is possible through a mutual data network between them (Uddin, 2010). As with every advance in communication technology, the creation and interconnection of robust data networks are having a profound effect. Early data networks were limited to exchanging character based information between connected computer systems. Today’s current data networks have evolved right in front of our eye’s in to something spectacular, now we can carry voice, video streams, text, music and photos over many different devices (Uddin, 2010). In 1990 the use of the internet to gather data spread faster than anyone ever imagined, it once was used for a way for researchers at university’s to exchange information, but when people and businesses figured out how to take advantage of this web based communication the internet grew to limits we never thought imaginable. This sparked the creation of a new age with many new businesses and careers. Data exchange over the internet can and has also saved lives. In the year of 2008 a mother saved her sons...

Words: 480 - Pages: 2

Premium Essay

Business Data Warehouse

...MIS 6309, Prof. A. Lahiri Team Homework #2 ------------------------------------------------- 1. The answers are as follows: a) E-R diagram: M Location Positions Industry Has Located in Belongs to M 1 M Employer 1 1 M Location Positions Industry Has Located in Belongs to M 1 M Employer 1 1 b) Physical Layout (primary keys underlined, foreign keys double-underlined): Position PositionID int PositionTitle varchar(50) EmployerID varchar(5) Wage Money HoursPerWeek int Experience bit Openings int Employer EmployerID varchar(5) EmployerName varchar(50) StreetAddress varchar(50) City varchar(50) StateProv varchar(2) PostalCode varchar(7) Country varchar(50) ContactFirstName varchar(50) ContactLastName varchar(50) Position varchar(50) Phone varchar(10) Website bit NAICSCode varchar(6) Comments varchar(255), must allow NULL NAICS NAICSCode varchar(6) NAICSDesc varchar(50) Location Abv varchar(2) Location varchar(50) c) Create table statements: CREATE TABLE Location( Abv varchar(2) PRIMARY KEY NOT NULL, Location varchar(50) NOT NULL ); GO CREATE TABLE NAICS( NAICSCode varchar(6) PRIMARY KEY NOT NULL, NAICSDesc varchar(50) NOT NULL ); GO CREATE TABLE Employer( EmployerID varchar(5) PRIMARY KEY NOT NULL, EmployerName varchar(50) NULL, StreetAddress varchar(50) NULL...

Words: 1260 - Pages: 6

Premium Essay

Business Data Analysis

...Give an interval based on your data so that you are 95% confident that the true value of the unknown proportion lies inside it. How would you explain 95% confidence to a layman? Suppose a professor of IIMA thinks that true proportion is 0.3. Are you ready to accept the professor’s perception based on your data at 99% confidence level? Solution – 1 Sample Size n = 100 (male smokers) p = 0.2 Sd (P) = √(pq / n) = .04 95% confidence interval of p = 0.2 ± 2 x 0.04 = 0.08 to 0.32 Explanation to a layman – 95% confidence means that if the sampling experiment i.e. selection of random samples of 100 male smokers in the present problem, is repeated large no of times, 95% of the times the interval will include the true value of p (0.2) or the sample proportion of smokers in present example and 5% of the times the interval may not include the true value of p (0.2) or the sample proportion of smokers in present example. 99 % confidence interval of p = 0.2 ± 2.58 x .04 = .04 to 0.35 Based on our data, as the true proportion of 0.3 thought by the IIMA professor lies in the 99% confidence interval, we can accept IIMA Professor’s perception. 2. A week before presidential election in USA, suppose a news agency wants to predict who is going to win (Democrat or Republican)? In order to predict, they collected a random sample of size 10000 individuals nationally and found 5100 of them intend to vote for Democrat. Based on the data could you claim with 95% confidence...

Words: 2356 - Pages: 10

Premium Essay

Findings on Big Data for the Business

...Building An Analytical Roadmap : A Real Life Example Dr Ahmed Khamassi Chief Data Scientist & Principal Consultant 1 © 2014 WIPRO LTD | WWW.WIPRO.COM | CONFIDENTIAL The Issue Environment: Outcomes Big data analytics is probably going to be remembered as a technological, if not, an industrial revolution Paralysis by analysis New technologies are rolling off the assembly line daily They keep revisiting the same issues over and over again New terminologies and approaches The delve into technological questions before answering the what and why questions. What matters seems to changes quite frequently I hear stories from my competitors, am I behind? Do I need this stuff? How do I know which are the new opportunities these technologies allow me to win? Skills are short Which skills do we need anyway? How do we organise them? How do we ensure we are compliant? 2 Many customers do not know where to start? Many organise several ‘vendor’ contests without a clear end insight They lack coherent approach that leads to faster results They involve either too many or too few stakeholders Where do I start and how do I plan for big data analytics? © 2014 WIPRO LTD | WWW.WIPRO.COM | CONFIDENTIAL Establishing An Analytical Capability Business Layer Principles: Analytics is a business outcome enabler What needs to be optimised, prioritisation, alignment with overall strategy, process changes etc. It bridges commercial management and IT expertise Analytical Layer There are four...

Words: 1343 - Pages: 6

Free Essay

Data Protection for Business Continuity

...Outline Database 2 Data Protection for Business Continuity Introduction Motivation Recovery Objective Data Protection Techniques Classes of Data Mapping of Company Size, Classes of Data, and Techniques Denny (denny@cs.ui.ac.id) International Bachelor Program Faculty of Computer Science 2004/2005 Version 1.0 - Internal Use Only DB2/DP/DN/V1.0/2 Introduction Why do we need data protection? SEPTEMBER 11, 2001 = 100 MEGABYTES OF DATA MORE THAN US$ 1 MILLION DATA PROTECTION DB2/DP/DN/V1.0/3 DB2/DP/DN/V1.0/4 1 Why do we need data protection? Causes of unplanned outages (Disaster Recovery Journal, 2001) Why Do We Need High Data Availability? CAN COST 1 HOUR OF DOWNTIME US$ 6.5 MILLION DB2/DP/DN/V1.0/5 DB2/DP/DN/V1.0/6 Why Do We Need High Data Availability? Data Protection and Business Continuity So, in this topic, we will see: techniques to protect data and ensure business continuity when disaster occurs. GLOBALISATION DB2/DP/DN/V1.0/7 DB2/DP/DN/V1.0/8 2 Recovery Objective LAST BACKUP DISASTER OCCURRED SYSTEM BACK TO OPERATION Data Protection Techniques Overview 1. TIME DATA LOSS RECOVERY POINT OBJECTIVE (RPO) RECOVERY TIME OBJECTIVE (RTO) 2. 3. 4. 5. 6. Vaulting Physical: backup to tape Electronic: backup over the Internet Server fortification RAID: same copies, or split into several disks Dual power supplies Network cluster NAS: independent disks connected directly to network SAN: a network...

Words: 1858 - Pages: 8

Free Essay

Business Statistics Data Project

...Business Statistics Group Project Restaurants Serving Times Red Lobster | 7 minutes | 16 minutes | 18 minutes | 21 minutes | 15 minutes | 14 minutes | Olive Garden | 12 minutes | 16 minutes | 14 minutes | 18 minutes | 15 minutes | 12 minutes | Logan’s Steakhouse | 9 minutes | 11 minutes | 10 minutes | 8 minutes | 13 minutes | 13 minutes | Ruth Chris Steakhouse | 16 minutes | 14 minutes | 20 minutes | 19 minutes | 10 minutes | 15 minutes | Foosackly’s | 2 minutes | 3 minutes | 1 min 45 sec | 2 minutes | 2 mins 30 secs | 2 minutes | Five Guys | 6 minutes | 4 minutes | 11 minutes | 9 minutes | 6 minutes | 4 minutes | Our group decided to research food service response times for our group project. We timed customers at 6 different restaurants: From the time they ordered their food till it was delivered. We also took note of the appearance of the restaurant, employee attitude and over-all cleanliness. Red Lobster and Olive Garden were chosen because of their similar styles of service, casual dining restaurants. Logan’s and Ruth Chris were chosen because they’re both steak-houses. Foosackly’s and Five Guys were chosen because of similar service styles, grab and go. Devon recorded the food service response times on Saturday March 24, 2012. His data was collected from 4:00 pm to 6:00 pm, at the Red Lobster on Airport Blvd in Mobile, Alabama. Devon noted that upon entering Red Lobster that a pleasant smell of butter biscuits was wafting in the lobby and he was greeted...

Words: 1166 - Pages: 5