Impact of a data warehouse model for improved decision-making process in healthcare

The health system is one sector dealing with a deluge of complex data. Many healthcare organisations struggle to utilise these volumes of health data effectively and efficiently. Also, there are many healthcare organisations, which still have stand-alone systems, not integrated for management of information and decision-making. This shows, there is a need for an effective system to capture, collate and distribute this health data. Therefore, implementing the data warehouse concept in healthcare is potentially one of the solutions to integrate health data. Data warehousing has been used to support business intelligence and decision-making in many other sectors such as the engineering, defence and retail sectors. The research problem that is going to be addressed is, "how can data warehousing assist the decision-making process in healthcare". To address this problem the researcher has narrowed an investigation focusing on a cardiac surgery unit. This research used the cardiac surgery unit at the Prince Charles Hospital (TPCH) as the case study. The cardiac surgery unit at TPCH uses a stand-alone database of patient clinical data, which supports clinical audit, service management and research functions. However, much of the time, the interaction between the cardiac surgery unit information system with other units is minimal. There is a limited and basic two-way interaction with other clinical and administrative databases at TPCH which support decision-making processes. The aims of this research are to investigate what decision-making issues are faced by the healthcare professionals with the current information systems and how decision-making might be improved within this healthcare setting by implementing an aligned data warehouse model or models. As a part of the research the researcher will propose and develop a suitable data warehouse prototype based on the cardiac surgery unit needs and integrating the Intensive Care Unit database, Clinical Costing unit database (Transition II) and Quality and Safety unit database [electronic discharge summary (e-DS)]. The goal is to improve the current decision-making processes. The main objectives of this research are to improve access to integrated clinical and financial data, providing potentially better information for decision-making for both improved from the questionnaire and by referring to the literature, the results indicate a centralised data warehouse model for the cardiac surgery unit at this stage. A centralised data warehouse model addresses current needs and can also be upgraded to an enterprise wide warehouse model or federated data warehouse model as discussed in the many consulted publications. The data warehouse prototype was able to be developed using SAS enterprise data integration studio 4.2 and the data was analysed using SAS enterprise edition 4.3. In the final stage, the data warehouse prototype was evaluated by collecting feedback from the end users. This was achieved by using output created from the data warehouse prototype as examples of the data desired and possible in a data warehouse environment. According to the feedback collected from the end users, implementation of a data warehouse was seen to be a useful tool to inform management options, provide a more complete representation of factors related to a decision scenario and potentially reduce information product development time. However, there are many constraints exist in this research. For example the technical issues such as data incompatibilities, integration of the cardiac surgery database and e-DS database servers and also, Queensland Health information restrictions (Queensland Health information related policies, patient data confidentiality and ethics requirements), limited availability of support from IT technical staff and time restrictions. These factors have influenced the process for the warehouse model development, necessitating an incremental approach. This highlights the presence of many practical barriers to data warehousing and integration at the clinical service level. Limitations included the use of a small convenience sample of survey respondents, and a single site case report study design. As mentioned previously, the proposed data warehouse is a prototype and was developed using only four database repositories. Despite this constraint, the research demonstrates that by implementing a data warehouse at the service level, decision-making is supported and data quality issues related to access and availability can be reduced, providing many benefits. Output reports produced from the data warehouse prototype demonstrated usefulness for the improvement of decision-making in the management of clinical services, and quality and safety monitoring for better clinical care. However, in the future, the centralised model selected can be upgraded to an enterprise wide architecture by integrating with additional hospital units’ databases.

The growth and international expansion of an emerging market retailer in Latin America

This study contributes to the literature on international retailing by addressing a gap in the literature as to how retailers from emerging markets expand internationally. This historical case study analyzes the growth and internationalization process of Chilean retailer Falabella, one of the largest in Latin America and has been able to compete with multinationals from developed countries. The research is based upon primary and secondary data sources including 33 oral interviews with company managers and family executives, as well as industry data, corporate reports, and trade journals. Drawing on institutional theory, the findings show that by belonging to a family conglomerate, engaging in networks and partnerships, organizational learning, and having an experienced management team helped Falabella gain legitimacy in all international markets.

Internationalisation of emerging market firms : an exploratory study of Chilean companies

Purpose This paper explores how firms from a Latin American market internationalise using the resource-based view (RBV) of the firm as a theoretical foundation. Specifically, it examines the internationalisation process of three Chilean companies that have become relevant international players. Design/methodology/approach Drawing on interviews with company managers, as well as industry data and corporate reports, this paper provides insights into the successful internationalisation process of emerging market firms. Findings The findings of this study suggest that specific capabilities and resources, such as belonging to a family conglomerate, domestic and foreign partnerships and networks, innovation and market orientation, and an experienced management team, are required for emerging market firms to internationalise and improve their performance in foreign markets. Originality/value This study is one of the few to address the internationalisation process of Chilean companies.

Management characteristics and the decision to internationalize : Exploration of exporters vs. non-exporters within the Chilean wine industry

The objective of this exploratory study was to identify the key factors that enhance and inhibit the export activities of wineries and identify differences between exporters and non-exporters. Based on data collected from Chilean wineries, the findings of this study suggest that the major constraints for non-exporters are the lack of financial resources, limited quantities of stocks for market expansion, management’s lack of knowledge and experience, and the high cost of travelling and participating in trade shows. In addition, the main international markets for Chilean wineries were not psychically close markets as has been found for Australian or other wine industries. For domestic market oriented wineries cellar door sales were an important source of revenue. Finally, the results show that managers have educational levels and international experience exceeding those of other comparable New World wineries.

Developing a framework for Six Sigma in financial service institutions : empirical evidence from expert interviews

Six Sigma is considered to be an important management philosophy to obtain satisfied customers. But financial service organisations have been slow to adopt Six Sigma issues so far. Despite the extensive effort that has been invested and benefits that can be obtained, the systematic implementation of Six Sigma in financial service organisations is limited. As a company wide implementation framework is missing so far, this paper tries to fill this gap. Based on theory, a conceptual framework is developed and evaluated by experts from financial institutions. The results show that it is very important to link Six Sigma with the strategic as well as the operations level. Furthermore, although Six Sigma is a very important method for improving quality of processes others such as Lean Management are also used This requires a superior project portfolio management to coordinate resources and projects of Six Sigma with the other methods used. Beside the theoretical contribution, the framework can be used by financial service companies to evaluate their Six Sigma activities. Thus, the framework grounded through literature and empirical data will be a useful guide for sustainable and successful implementation of a Six Sigma initiative in financial service organisations.

A first stage test of Dunning's framework on multinational contracting into Australia : reviewing secondary data.

In response to the need to leverage private finance and the lack of competition in some parts of the Australian public sector infrastructure market, especially in the very large economic infrastructure sector procured using Pubic Private Partnerships, the Australian Federal government has demonstrated its desire to attract new sources of in-bound foreign direct investment (FDI). This paper aims to report on progress towards an investigation into the determinants of multinational contractors’ willingness to bid for Australian public sector major infrastructure projects. This research deploys Dunning’s eclectic theory for the first time in terms of in-bound FDI by multinational contractors into Australia. Elsewhere, the authors have developed Dunning’s principal hypothesis to suit the context of this research and to address a weakness arising in this hypothesis that is based on a nominal approach to the factors in Dunning's eclectic framework and which fails to speak to the relative explanatory power of these factors. In this paper, a first stage test of the authors' development of Dunning's hypothesis is presented by way of an initial review of secondary data vis-à-vis the selected sector (roads and bridges) in Australia (as the host location) and with respect to four selected home countries (China; Japan; Spain; and US). In doing so, the next stage in the research method concerning sampling and case studies is also further developed and described in this paper. In conclusion, the extent to which the initial review of secondary data suggests the relative importance of the factors in the eclectic framework is considered. It is noted that more robust conclusions are expected following the future planned stages of the research including primary data from the case studies and a global survey of the world’s largest contractors and which is briefly previewed. Finally, and beyond theoretical contributions expected from the overall approach taken to developing and testing Dunning’s framework, other expected contributions concerning research method and practical implications are mentioned.

Identification of key competences of design-builders in the construction market of the People’s Republic of China (PRC)

Design-builders play a vital role in the success of DB projects. In the construction market of the People’s Republic of China, most of the design-builders, however, lack adequate competences to conduct the DB projects successfully. The objective of this study is, therefore, to identify the key competences that design-builders should possess to not only ensure the success of DB projects but also acquire the competitive advantages in the DB market. Five semi-structured face-to-face interviews and two rounds of Delphi questionnaire survey were conducted to identify the key competences of design-builders. Rankings have been assigned to these key competences on the basis of their relative importance. Six ranked key competences of design-builders have been identified, which are, namely, (1) experience with similar DB projects; (2) capability of corporate management; (3) combination of building techniques and design expertise; (4) financial capability for DB projects; (5) enterprise qualification and scale; and (6) credit records and reputation in the industry. The design-builders can make use of the research findings as guidelines to improve their DB competence. These research findings will also be useful to clients during the selection of design-builders.

Identification of key competences of DB clients in the construction market of China

The design-build system has been demonstrated as an effective delivery method and gained popularity worldwide. Although there are an increasing number of clients adopting DB method in China, most of them remain inexperienced with method. The objective of this study is therefore to identify the key competences that a client or its consultant should possess to ensure the success of DB projects. Face-to-face interviews and a two-round Delphi questionnaire survey were conducted to find the following six key competences of clients, which include the (1) ability to clearly articulate project scope and objectives; (2) financial capacity for DB projects; (3) capability in contract management; (4) adequate staff or consulting team; (5) effective coordination with contractors and (6) experience with similar DB projects. This study will hopefully provide clients with measures to evaluate their DB competence and further promote their understanding of DB system in the PRC.

Individuals in a mass market environment: Australian bequest donors seek better communication from charities

Swelling social need and competing calls on government funds have heightened the philanthropic dollar’s value. Yet, Australia is not regarded as having a robust giving culture: while 86% of adults give, a mere 16% plan their giving with those who do donating four times as much as spontaneous givers (Giving Australia, 2005). Traditionally, the prime planned giving example is a charitable bequest, a revenue stream not prevalent here (Baker, 2007). In fact, Baker’s Victorian probate data shows under 5% of estates provide a charitable bequest and just over 1% of estate assets is bequeathed. The UK, in contrast, sources 30% and the US 10% of charitable income through bequests (NCVO, 2004; Sargeant, Wymer and Hilton,2006). Australian charities could boost bequest giving. Understanding the donor market, which has or may remember them in their will is critical. This paper reports donor perceptions of Australian charities’ bequest communication/ marketing. The data forms part of a wider study of Australian donors’ bequest attitudes and behaviour. Charities spend heavily on bequest promotion, from advertising to personal selling to public relations and promotion. Infrastructure funds are scarce so guidance on what works for donors is important. Guy and Patton (1988) made their classic call for a nonprofit marketing perspective and identify the need for charities to better understand the motivations and behaviour of their supporters. In similar vein, this study aims to improve the way nonprofits and givers interact; and ultimately, enhance the giving experience and thus multiply planned giving participation. Academically, it offers insights to Australian bequest motivations and attitudes not studied empirically before.

An exploratory study of the factors enhancing and inhibiting export growth in the Chilean wine industry

The objective of this exploratory study is to investigate the main drivers that enhance and inhibit the export performance of Chilean wineries. Based on survey data collected from Chilean wineries, the findings of this study suggest that the main constraints within the Chilean wineries in developing exports is the lack of financial resources, limited quantities of stocks for market expansion, management’s lack of knowledge and experience, and the high cost of travelling and participating in trade shows. The main drivers of wine export performance according to the respondents are high quality of the wines, well established network of international distributors, and marketing skills. The major inhibitors of developing wine exports are exchange rate variability, problems in selecting a reliable international distributor, and limited government support to promote wine exports. This study also shows that export managers of Chilean wineries have high educational levels and have international experience. The findings have important implications for export development efforts of both governments and managers.

Costco and the Aussie shopper : a case study of the market entry of an international retailer

Retailing is a globalized industry yet retailers must respond to local shopping habits if they are to be perceived as legitimate by the host country customers. However, some retailers may be unable or unwilling to respond to all customer requirements. Costco, the membership warehouse club retailer, has been successful in its international expansion efforts, establishing its first Australian store in Melbourne in 2009. In the first twelve months of operation, the store became one of Costco’s top five stores in the world. We investigate this success focussing on the customer, and use institutional theory to analyze what concessions were made by the customer and the company. Data were collected from consumer interviews, site visits and secondary media and industry sources. Analysis revealed negotiations based on the rejection, acceptance or adaptation of the regulative, normative and cultural cognitive aspects of the Australian shopper and the Costco business model. Customers made concessions to accommodate the new business model, and Costco responded to entrenched Australian shopping habits. This case is the first to explore the outcome of retail internationalization from the customers’ perspective, revealing the concept of mutual concessions. The interaction and subsequent adaptation by both customer and retailer have resulted in the institutionalization of new shopping norms in the host country and success for the international retailer.

Reviewing the impact of the 2008/2009 global financial crisis (GFC) on international property markets and property professions

The global financial crisis that impacted on all world economies throughout 2008 and 2009. This impact has not been confined to the finance industries but has had a direct and indirect impact on the property industry worldwide from both an ownership and investment perspective. Property markets have experienced various levels of impact from this event, but universally the greatest impact has been on the traditional commercial and industrial property sectors from the investor perspective, with investment and superannuation funds reporting significant declines in the reported value of these investments. Despite the very direct impact of these declining property markets, the GFC has also had a very significant indirect impact on the various property professions and how these professions are now operating in this declining property market. Of particular interest is the comparison of the property market forecasts in late 2007 to the actual results in 2008/2009.

Alleviating poverty by engaging in microenterprise : how can INGOs in Vietnam help microenterprises overcome market constraints?

Microenterprise programs (MEPs) that aim to help poor communities engage in micro businesses have contributed significantly to poverty reduction in developing countries. However, a review of the literature suggests that the current approach adopted by MEPs has mainly provided services to microenterprises (MEs) based on what MEPs can supply rather than on what MEs actually need and what the market demands. Therefore, MEPs’ approaches are more likely to be supply driven. Yet when there are market constraints, such as high competition or low demand, this approach has been linked to the failure of MEs in their infancy. The alternative is a demand driven approach, in which MEPs provide MEs with support based on what MEs need, and what markets demand. However, research examining the application of this approach is limited. In order to gain an understanding of the approaches of MEPs, to identify whether these approaches are demand or supply driven, and to discover how these approaches are used to help MEs operate under market constraints, this study examined the operation of International Non-Government Organisations (INGOs) operating in Vietnam. This exploratory study involved in-depth interviews with senior executives from 10 INGOs. Thematic analysis was used to analyse data collected from the in-depth interviews. The results were further verified with publicly available data from the INGOs. The findings of this research indicate that the demand driven approach is dominant in most approaches of INGOs in Vietnam, and has become a key approach in helping MEs deal with market constraints. Further, rather than explaining the demand and supply driven dichotomy, the findings highlight that MEPs’ approaches can be viewed in two dimensions: a participant-demand driven approach focusing on the basic needs and capabilities of the extremely poor, irrespective of market demands; and a market-demand driven approach focusing on the capabilities of poor communities, while also accommodating market demands. This research provides contemporary and practical insights into the DD and SD approaches, and a better understanding of MEPs’ approaches to MED in Vietnam.

Not-for-profit ratios for financial resilience and internal accountability : a study of Australian international aid organisations

Not-for-profit (NFP) financial ratio research has focused primarily on organisational efficiency measurements for external stakeholders. Ratios that also capture information about stability, capacity (liquidity), gearing and sustainability, enable an assessment of financial resilience. They are thus valuable tools that can provide a framework of internal accountability between boards and management. The establishment of an Australian NFP regulator highlights the importance of NFP sustainability, and affirms the timeliness of this paper. We propose a suite of key financial ratios for use by NFP boards and management, and demonstrate its practical usefulness by applying the ratios to financial data from the 2009 reports of ACFID (Australian Council for International Development)-affiliated international aid organisations.

Comparison of key competences of DB clients and contractors in the construction market of the People’s Republic of China

Clients and Design-build (DB) contractors are two key stakeholders in DB projects, and contribute significantly to the successful project performance. This study aims to identify and compare such key competences in the construction market of the PRC. After the survey of available literature and face-to-face interviews, a two-round Delphi questionnaire survey was conducted to identify the key competences of clients and DB contractors in DB projects. Relative importance of these identified competences were ranked and compared. The questionnaire results indicated distinct differences between the key competences of clients and that of contractors. The contractor’s key competences emphasize on DB experience, corporate management capability, building and design expertise, financial capability, enterprise qualification and reputation. While the client’s competences focus on the ability to clearly define the project scope & requirements, financial capacity, contract management ability, adequate staff, effective coordination with DB contractor and similar DB experience. Both clients and DB contractors should clearly understand the competence requirements in DB projects and possess all the necessary competences for the successful outcome of DB projects. The identification of these key competences provides clients and DB contractors with indicators to assess their capabilities before going for the DB option. Furthermore, the comparison of competences for clients and DB contractors will result in better understanding of DB system and improve the communication between these stakeholders.