Data Warehouse Characteristics And Definition Information Technology Essay

Data Warehouse Characteristics And Definition Information Technology Essay A data warehouse provides an integrated view of the customer and their relationship with the organisation by bringing together the data from a number of operational systems. A data warehouse provides a complete picture of the enterprise by focusing on its enterprise-wide components like profits, sales and customers by looking beyond the traditional information view structure. These components require information from various sources as they have both organisational and process boundaries. The data warehouses are made up of large databases. These databases store the integrated data of the enterprise. This data may be obtained from both, internal as well as external sources. Internal sources of data refer to the data that is obtained from the operational systems of the enterprise. External data sources are the government bodies, third party organisations, business partners, customers etc. These databases also store the metadata that gives a description of the content of data that is st ored in the data warehouse. The data warehouses are designed and constructed in a denormalized manner. This is done to replicate the dimensional view of the business by the user. This makes it possible to better analyze, examine and summarize the data. This can be done over different periods of time and at different levels of detail when the data structure is denormalized. The data warehouses have a time dimension where all the data is time stamped. This is done so that the data can support the reports that are used to compare the figures from the earlier months or years. It is helpful for the decision takers of the organisation to better understand the trends and patters of the market and customer behaviour over the period of time. The data warehouses contain both atomic as well as summarised data. The atomic data is the data that provides a great level of detail. This makes responding to queries a faster process when the tasks are at the highest level of detail. As the name sugges ts, the summarised data provides a quick summary of data and does not go much into detail. Thus only storing summarised data is not an option. However, the storage of atomic data requires much larger space. 2.2 Purpose Previously, the data was not easily accessible because it was stored in environments which were unfriendly and not easy to access. The data warehouses solve this problem by providing access to the integrated organisational data that was stored in such environments. The data warehouses provide security either by their front-end applications or from the database servers. As a result, the users can now have a secure connection to the warehouse from their personal computers. Because the data warehouses provide integrated data, the need for users to understand and access operational data is greatly reduced. The information provided by the data warehouses is consistent and is of high quality. They are the common source of information for the organisation. Due to this there is consistency in the data and the organisations decision making process becomes much easier. They are also used to store historical data. Actual historical data is not stored on operational systems but is simply loaded and integrated with the other data in the warehouse so that it can be accessed quickly. Data warehouses provide the ability to their users to view the data at different levels of detail and go through it as and how they require. Such freedom to view the data from different angles improves the analysis process by reducing the time and effort required to collect, format and present the information from the data. To make the information technology infrastructure of the organisation stronger, the data warehouses distinguish between analytical and operational processes. They provide additional system archite cture to execute the decisions. With the focus of the data warehouses on achieving the requirements for business decisions, they are the best suited systems for the redesigned decision-making business processes. 2.3 Trends in data warehousing Data warehousing is no longer just a concept or used for educational purposes only. It has become mainstream. Almost 90% of the multinational corporations either use data warehousing or are planning to implement it. Data warehousing has transformed the way business analysis and decision making takes place. The organisations that already use it have witnessed the enormous benefits that it has to offer. Web technologies have only added to the benefits provided by data warehousing and has paved the way for easy delivery of critical information. There have been many changing trends in the field of data warehousing since its evolution. Scientists have always felt that technology has been the driving force behind data warehousing. But now, the softwares being used have had a significant progress rate and in the years to come, we can expect data warehousing to take a major leap not only in software but also in optimising queries, indexing big tables, improved data compression and expanding dimensional modelling. Real-time warehousing Real -time data warehousing is increasingly becoming the focus of top executives in the organisations. As compared to conventional data warehousing, real-time data warehouses provide the most recent views of the business and are dynamic in nature. A conventional data warehouse is more passive in nature and provides historical trends. The tools of business intelligence along with the data warehouse have been mainly used to make strategic decisions. But now they are required more for making tactical decisions on a day to day basis. There is a lot of pressure in the companies as they are expected to come up with real-time information with everyone connected to important business processes. Providing real-time information has increased the productivity of the companies tremendously. However, there a number of challenges that the company has to face while trying to do so. Data types Previously the companies included mostly numeric structured data in their data warehouses. This divided the decision support systems in to two parts, one that worked with structured data and the other one that worked with knowledge management involving unstructured data. Most of the structured data is numeric and most of the unstructured data is in the form of images. Now, if we were to consider a situation where the decision maker of the company has to perform an analysis in order to find out about the top-selling products, where he/she would like to take a look at the images of the products for further decisions, then this wouldnt have been possible. This fact has been realised by the organisations and therefore the need is felt to integrate both the structured as well as the unstructured data in the data warehouses. In order to include the unstructured data in the data warehouses, the vendors are considering multimedia like images and texts as just another data type. They are stor ed as binary large objects and are considered to be a part of the relational data. They are defined as user-defined-types by the user-defined-functions. But it is not possible to simply consider all binary large objects as relational data type. That is because, if we were to consider video clips, there would be a need for a server that is able to support delivery of multiple video streams at a given rate along with audio synchronisation. After having included unstructured data in the data warehouses, there should also be a way to search for this data. Without proper ways to search for this data, the integration of unstructured data will prove rather useless. Vendors have now started providing search engines so that the user is able to search for all the information that he/she requires. The example of such a mechanism would be the query by images mechanism. Its purpose is to let the user search for pre-indexed images on the basis of their shape, size and colour. For text-data, the s earch engine retrieves the documents based on words, characters, phrases etc. The use of search mechanisms for audio and video data is still in the research stages. Another data-type would be the spatial data. Including the spatial data-type in the data warehouses adds a great deal of value to the data warehousing systems. Spatial data answers questions like average income of the people living near the store, average driving distance for the people coming to the store etc. Examples of spatial data include address, city, county, state etc. The database vendors do realise the importance of this type of data and some of them do add special SQL extensions to their products in order to include such data. Data visualisation Data visualization is necessary to improve the performance of the user in terms of analysis. The users expect to see the query results in the form of charts or graphics. If the query results are in the form of spread sheets, it affects the quickness and ease by which the users can carry out the analysis. It also means that the data warehouse is outdated. If we consider the last few years, there have been many trends in the way the data visualization softwares work. Now, the variety of charts to view different types of data has increased. For example, there are pie charts available to view the numerical results. Dynamic charts are available which allow the users to see the results, manipulate it and check for the new views online. The newer versions of the data visualization softwares make it possible to see a large number of results at once and complex data structures. Some of the more advanced visualization techniques available today are the chart manipulation technique, drill down technique and the advanced iteration technique. Companies have also started adopting scorecards and dashboards as a means to view the performance. Different types of users have different needs. The business users require bar charts, the scientific users require constellation graphs, and the analysts require three dimensional views and so on. The latest trends in the softwares have made it possible to fulfil the ever changing needs of the current users of the data warehousing systems. Parallel processing One of the most important aspects of data warehousing is delivering top-quality performance. The users of the data warehouses are constantly performing large complex queries. These queries read enormous amounts of data to give out the results. Again, to analyse these results, a large number of queries are executed one after the other by individual users. Some of the other functions involved are the loading of data and creating indexes for the data. Both the processes can be slow because of the huge amounts of data and large number of indexes. For the data warehouses to give out quality performance, it is necessary to speed up these processes like query processing, data loading and indexing. An efficient way to do this is to achieve parallel processing. This is done by utilising both hardware options as well as software techniques together. For parallel processing, the hardware options may include multiple CPUs, many server nodes, memory modules, high speed links between interconnecte d nodes etc. In the software implementation of parallel processing, the hardware configuration needs to be chosen properly. The reason for this is that if the hardware configuration is not proper, then the operating systems and the databases will be unable to use the hardwares parallel features. Parallel server and parallel query are the two options that the database vendors generally provide for parallel processing. The parallel server option makes it possible to have separate database instances for each of the hardware nodes. The database instances are also allowed to access a common set of database files. On the other hand, the parallel query option supports the important functions like query processing, data loading and index creation. Considering the current technology, executing the data warehouse without parallel processing is not at all an option to be considered. Tools for query processing The tools that are required for query processing are the most important set of tools in data warehousing. The success of a data warehouse is not possible without them. Because of this, the vendors have started coming out with new and improved query tools since the past few years. Some of the query tools that are of most importance and have undergone significant changes by the vendors are flexible representation, aggregate awareness, crossing subject areas, multiple heterogeneous sources, overcoming SQL limitations etc. Browser tools Here the term browser is not restricted to the use of web browsers alone. One of the major advantages of data warehousing is that the users are able to execute queries in the data warehouse that generate reports without any help or assistance from someone who is in the I.T. field. Here, the browser tools come in handy when the users want to go through the metadata and search for specific chunks of information. This allows the users to directly go to the data warehouse. Their need is also felt when a data warehouse for the company is being developed and the I.T. team has to go through all the data structures, data sources and business rules. Some of the major improvements that the browser tools have gone through in the past few years are: extensible tools that allow to define any type of data or information objects, open APIs, navigation through hierarchical groupings, web browsing and search techniques to go through information catalogues etc. Data Fusion In order to provide an integrated view of the enterprise, the data warehouse stores data collected from a number of sources. The data may be taken from different operational systems running on different platforms, each using a different DBMS. Data may also be taken from a number of external sources. Data fusion is the technology that fuses together all this different types of data from multiple sources and stores it in the data warehouse. It provides a wider scope and the real-time integration of data from the monitoring systems. A vast amount of research is being carried on in order to improve this technology as it has a direct application in the field of data warehousing. Apart from the integration of data from multiple sources, the data fusion technology is also expected to address the problem of finding the right information at the right time as it can be a difficult task due to the vast amounts of data that is stored. The data fusion technology as for now is still in its researc h phase and therefore the vendors are not hurrying to develop the tools for data fusion. Integrating ERP and Data Warehouses Enterprise resource planning was introduced in the markets in the 1990s. The goal of ERP was to help in the decision making as well as the taking of necessary actions from one integrated environment. It was also supposed to provide the companies with the integrated corporate data repositories. For this, the data was cleansed, transformed and integrated in one place. But soon, the companies that implemented these systems realised that the relational databases that were designed and normalised to carry out the business operations were not able to provide the necessary strategic information. Also the data from the external sources and the operational systems was not included in the ERP data repositories. As a result, the companies that were planning to acquire the ERP systems started to consider the integration of ERP systems with data warehousing. There are three major options that are available that allow the companies to do so. They are the ERP data warehouse, the custom developed data warehouse and the hybrid ERP data warehouse enhanced with third party tools. The ERP data warehouse option allows the companies to implement data warehousing with the current available functionality and wait for further enhancements. But the only negative about this option is that the enhancements may take a long time to come. The 2nd option that is the custom-developed data warehouse allows the companies to have a customized data warehouse along with the use of 3rd party tools to get the data from the ERP datasets. Although reclaiming and loading the data from the ERP datasets is not an easy task. The 3rd option that is the hybrid ERP data warehouse enhanced with 3rd party tools allows the combination of the functionalities of the existing data warehouse with the additional functionalities from the third party tools. The companies need to sel ect the option that will be most suitable for their corporation. Data Warehousing and CRM The benefits of having a CRM-ready data warehouse are substantial. Now-a-days, there is an increasing competition among the companies and also, there is a need to retain the existing customers and attract new ones. The companies have now started targeting individual customers and fulfilling their needs instead of having a mass focus group. To achieve this, the companies have adopted customer relationship management. To build a data warehouse that is customer ready, there is a need to develop CRM-ready data warehouses. But, doing so is by no means an easy task. The data warehouses need to have all the information of every transaction with every individual customer. What this means is that each unit of each sale of every product to each customer must be recorded in the data warehouse. Not only the sales data, but also, information regarding every other type of interaction with the customer needs to be recorded. The CRM-ready data warehouse becomes flexible with such detailed recording of data. There is a huge amount of increase in the volumes of data. These large amounts of data can be stored across multiple storage management devices. They are accessed by using common data warehouse tools. Also, there is a need to improve functions like cleansing and transformation functions that are more complex in nature. These are some of the major efforts to achieve a CRM-ready data warehouse. Although, the previous tools of data warehousing are not quite capable of adopting the specialized requirements of customer-focused applications. The Web and Data warehouse The introduction of internet has deeply affected the way in which computing and communication has been taking place previously. From its start in 1969 with only four host computers, it has come a long way with a huge amount of increase in the host computers, almost up to 95 million hosts by 2000. And it still continues to grow with exponential speeds. In the year 2000, there were almost 26 million web-sites and 150 million users using the available web technologies for one reason or the other. Now, the companies have come up with intranets (private networks) and extranets (public networks) in order to properly communicate with their employees, customers and business partners. The web has transformed itself in to a universal information delivery system. Today, there is no business that can survive without making use of the available web technologies. E-commerce has now become the main focus of the businesses and there is an annual investment of 300 billion dollars which is soon expected to cross the 1 trillion mark. Therefore, it has become extremely important for the companies to transform their data warehouses to make them web-enabled in order to make use of the tremendous potential that the web technologies have to offer. But while doing so, the companies need to bring the data warehouses to the web and also bring the web to the data warehouses. Bringing the warehouse to the web: During the early times of the evolution of data warehousing, the data warehouses were developed only for the top-level management such as the managers, analysts and a few others to help them with critical analysis and decision making. The necessary information was delivered to this user group by making use of the client/server environment. But today, the needs of the businesses have increased tremendously. The warehousing technology has been made available to all the members included in the corporations value chain. It is not just confined to a select group of people. Important information is not only provided to employees alone but also to the customers, business partners and the suppliers. In todays highly competitive times, these changes are necessary to increase the productivity of all the members of the company. This can only be possible with the help of internet along with web technology. The way the users of the data warehouse retrieve, analyse and share the information is changed drastically with the help of the new information delivery mechanism that is the web technology. The information delivery will be a little different having new components and the internet interface will provide a browser, search engine, a homepage, hypertext links, downloadable Java etc. The important requirements of the users while bringing the data warehouse to the web are strict security, self data access, unified metadata, high performance etc. Bringing the web to the warehouse: In order to bring the web to the warehouse, the company needs to collect the number of clicks the company website gets from all the visitors and then perform the traditional data warehousing functions. This must be accomplished in real-time and involves extraction, transformation and loading of the number of clicks to the data warehouse. Dimensional schemas are then developed from this data and the information delivery systems are launched. The click data helps in analysing how exactly the visitors went about through the company web-site. Also important information like what made the visitors purchase the company product, how they were attracted and what made the visitors come back to the web-site can also be recorded. The web-house as it is known has become an extremely important tool for retaining, identifying and prioritising the e-commerce customers. The combination of data warehousing and web technology has become very important to all the businesses in the 21st century. Using web technologies for information delivery and integrating the click data from the company web-sites for analysis has become the need of the day.

Learning Team Skills Assessment Paper and Matrix

Learning Team Skills Assessment Paper and Matrix Team A is made up of skilled individuals. The team is researching business ideas for a consulting firm. The team’s plan is to review the members’ strengths and weaknesses and evaluate what type of consulting firm would best suited for the qualities of the team members. In addition, Team A will review the opportunities and qualifications the team believes are required to strengthen the management team and company. Team A believes the general management skills and the strengths of the partners will provide the team with advantage and opportunities to convince potential customers that the team has the necessary skills to be successful. Team Skills Summary/Analysis The pool of individuals who will develop this organization is comprised of dynamic talent and energy. Every corporate officer has obtained a college degree in business administration demonstrating discipline and motivation. Within experiential categories, which are characterized by skills and strengths, the team brings together qualities that complement and build on those of other members. The skills are comprised of management level proficiency within accounting, employee development, human resources, business law, computers and information processing, marketing, and E-business. Strengths are centered on personal relations within human resources and organizational competence. These skills and strengths will combine well to develop a consulting firm that will uphold our team commitment to our client providing the best-qualified candidates to meet and exceed their requirements and expectations. Consulting Firm Options for Team A Medical Staff / Personnel Consulting Two of Team A’s members have work experience in the medical field which would benefit a Team decision to pursue a firm to provide consultation for medical staff or personnel. Kellie Wolinski currently works for the United Health Group as a Territory Developer. Kellie’s job function involves educating providers, facilities, and senior groups about Medicare Plan Options that will provide the consulting background for our medical staffing and personnel-consulting firm. Mary Ann Senatore is currently employed at JFK Medical Center as Resource Coordinator of Cardiovascular Services, allowing er to assume the administrative role for payroll, purchasing, and human resource functions. Performing the function of medical staff or personnel consultation would require identifying and recruiting candidates for employment. Team A could use knowledge of industry needs to help fill essential positions in the medical field. The consulting company would develop a database of professional s able to fill clients’ needs. Team A would provide background checks, accreditation checks, and confirm any specialized training or certification prior placing professionals in the database. Professionals in the system would be encouraged to pursue advanced training in specialized fields to meet the demand of the firm’s clients. Team A would provide the professionals with resume services, coaching through the interview process, salary negotiations, and provide relocation assistance services. Internet Advertising/Marketing Consulting Tracy Schneider has experience working with Internet marketing through work experience with her own business. Team A could use Tracy’s experience and educational background of the team’s members to start an Internet marketing consultation firm. The goals of the firm would be to help clients attract, retain, and convert Internet traffic into viable business leads. The firm would provide Internet public relations, brand management, and product reputation management. Jessica Mazakas marketing skills will be an asset in obtaining and retaining clients. The firm would work with clients to identify individual target markets and establish business goals by combining off line and online business activities. Proper branding and brand recognition services retain consumers through brand loyalty initiatives. Broadcasting Technology Consulting Team A is also considering consultation services in the field of broadcast technology and online training programs for broadcasting professionals. Team A’s members could apply experience from the online training environment at the University of Phoenix to the online training needs of this sector. Ryan Bierbaum’s experience in gaming networks may be beneficial to the inner workings required for broadcasting technology. The firm could also provide consultation and project management for system integrations and technology system upgrades by collaborating with product suppliers. One other area of interest is the design of content specific software design technologies. Plans to Develop Skills As indicated, Team A has a diverse mixture of skills. Each team member has identified his or her own strengths, skills, and weaknesses. Through our combined strengths, we will be able to provide our clients with the services they require. Our weaknesses will allow those team members to benefit, learn, and grow through other member’s strengths. This complement of skills allows us able to move forward with our consulting firm.

Essay on Babies in the Workplace - 927 Words

Babies in the Workplace As we move into the new millennium more and more employers are allowing, some are even encouraging, their employees to bring their newborn babies to work with them. This is probably one of the greatest changes in child care norms that this country has seen in the past 30 years. Once upon a time, when a woman had a baby she almost always quit her job to raise her child, depending on her husband to support her and her child. Then along came the idea of maternity leave. This is when a woman takes a certain amount of time off to be with newborn. Once this time period was up, the woman still had a job to go back to. This meant that women no longer had to rely on their husbands for support. Unfortunately it also†¦show more content†¦The change in policy that allows women and men to bring their newborn children to work with them is, in a sense, just one more change in our country norms and values. At one point leaving your child with a baby sitter or at a daycare center all day was considered being a bad parent, meaning it was the norm to stay home and take care of your child yourself. Then, as divorce rates went up and more women were forced to raise their children on their own, that changed and it became the norm for women to go back to work after a set time for maternity leave. This also made sending you child to a daycare center or leaving them with a babysitter the norm since you couldn’t be there to take care of your child. With women being allowed to bring their babies into work with them, that is again changing the norms of society, specifically those having to do with the care of children. Women used to be given a hard time when they brought their children into work with them, even if it was only for a matter of minutes. Now many of them are allowed to bring their children in for a whole day, every day. This is enabling women to care for their own children and raise them in their own way with their own values, instead of entrusti ng those important responsibilities to someone else. Mothers are also forming a closer bond with their children in an important time in a child’s development. This will lead to a stronger bond laterShow MoreRelatedThe Workforce Today Encompasses Four Distinct Generations,1151 Words   |  5 Pagesencompasses four distinct generations, and each of these generations brings its own characteristics and values to work. According to Kevin, problems in the workplace can result, because these different generations bring their varying views and expectations to work, potentially creating dilemmas. In Managing Multiple Generations in workplace, a generation is defined as a cohort of people who share common knowledge, assumptions, and beliefs. A generation is a group of people who have grown up in sameRead MoreManaging A Team Of Multi Generational Workers Essay1565 Words   |  7 Pages In today’s world, the problems of managing a team of multi-generational workers can be best described by the difference in the generation in the workforce. This usually is the main reason for conflicts in the workplace but sometimes can be a boon for the employers for the development of an organisation to be more efficient and productive. Authoritative approaches to deal with these inadequate nowadays as these are of differing values and attributes with varying ambitions to either compete or collaborateRead MoreThe Legacy Of The Vietnam War934 Words   |  4 Pages Upon reflecting on the three main generations that comprise the workplace today, a few differences emerge. â€Å"Baby Boomers† grew up in a time when movements were prominent, the Vietnam War occurred, key figures were assassinated, the Watergate Scandal occurred, and television was introduced (Twenge et al., 2010; Schullery, 2013). Overall, â€Å"Baby Boomers† seem to exhibit a distrust of authority, value hard work, and want to enjoy their achievements (Robbins Judge, 2015; Twenge et al., 2010). As suchRead MoreGenerational Affects in Business Ethics Essay1597 Words   |  7 PagesGenerational Affects in Business Ethics We are experiencing in our work force a changing of the guard, currently there are three generational groups that make up our workforce: The Baby Boomers, Generation X, and the Millennials, who for the past few years have begun to work together. However, what we are discovering is that because of the time frame of their births and the life altering affects during those times, it has influenced the values and objectives of each of these groups, ultimatelyRead MoreBaby Boomers And Millennials796 Words   |  4 Pageson politics. Two of the largest generations in the world are Baby Boomers, people born from 1946-1964, and Millennials, people born from 1981-1998. As Baby Boomers continue their last couple years of work before retirement, and as Millennials continue to join the working community, these generations are increasingly interacting with each other. The Baby Boomer and Millennial generations may have some similarities, but in the workplace these two generations function compl etely differently, which canRead MoreWorking With A Diverse Age Of Employees Essay1559 Words   |  7 PagesToday’s workforce environment is comprised of a wide variety of Millennials, Generation Xers, Baby boomers, and even some Traditionalist. Organizations are learning that there can be challenges when working with a diverse age of employees. Every age and generation has different and unique characteristics and values that prove to be challenging and advantageous. What motivated one generation of workers will not necessarily motivate another. In an organization age has an impact in many aspects suchRead MoreBaby Boomer s Goals And Goals1500 Words   |  6 Pagesbeing brought into the world, the world was severely affected by these dubbed â€Å"baby boomers†. Baby Boomers, in a sense, were consider part of the growing middle class we know today. What were these baby boomer’s goals and aspirations? What were their values? What actions did they take to make s ure they had a good life for themselves and their families? Were their decisions based in politics? Some would say that these baby boomer’s goals and actions contributed to the success of America’s middle classRead MoreMulti-Generational Workforce888 Words   |  4 Pagesdominating the workforce, they are made up of Silents, Baby Boomers, Generation X and Generation Y. It is expected that in the coming decades there will be further changes with emergence of newer generations, and slower removal of older generations from organizations as pension age increases. Understanding differences between the generations, and learning to adapt their management practices is critical to building a successful multigenerational workplace. I would like farther explain each generation’s attributesRead MoreHistory Of Participatory Management ( Rau Foster, 2017 )1533 Words   |  7 PagesBaby Boomers believed in something called participatory management (Rau-Foster, 2017). They fe lt they should have say in how the workplace flowed and how it was run. Below is a list is common characteristics of the Baby Boomers leadership styles: †¢ Democratic †¢ Believed in chain of command †¢ Goal oriented †¢ Create stability †¢ Respect Loyalty Generation X Generation X (1965-1980) are taking hold in the workforce today (Schullery, 2013, p.235). The current age range for this generation is 28-43.Read MoreThe Tv Show How I Met Your Mother Essay1501 Words   |  7 Pagesstatement. Society is faced with a question of can women be as successful as men in the workplace? Women are unable to thrive in the workplace because they’re expected by society to be submissive and servile. Society is changing how women are raised, and not for the better. People often genderize babies from the moment they are born. Right from birth, hospitals make it a point to identify the gender of a baby by wrapping the newborn in either a blue blanket for a boy or a pink blanket for a girl