Q2. Using Sumner (2005) read the article on pages 149 – 150. Answer the following:
A. What aspects of BI have been employed in this case example?
The case study of Dow Corning states that in Phase 2, Dow Corning’s business intelligence strategy, takes advantage of SAP’s business information warehouse (BW).
SAP Netweaver Business Intelligence (SAP BI) is the more recent name of the analytical, reporting and data warehouse solution developed by SAP AG. The name was originally SAP BIW (Business Information Warehouse) and abbreviated to SAP BW as noted in Sumner’s featured article, but is now known as “SAP BI” at the end user level. BW is used to describe the underlying data warehouse area and accelerator components and is an operational system used to run the business.
The layers that make up the structure of the SAP BI solution are as follows:
- Extraction, Transformation and Load (ETL) layer – this layer extracts the data, applies rules and loads the information into the data warehouse. The (middle layer) BW Server administers the BW system, stores the data and retrieves data upon user request.
- Data Warehouse Area – (bottom layer) R/3 source systems – this area stores information in various types of structures, for example, Data Store Objects, InfoObjects and multidimensional structures called InfoCubes (middle layer) star schema design. Many analysis cubes for specific business purposes may be very costly and time-consuming.
- Reporting – (top layer) uses Business Explorer to access the information in the data warehouse and presenting it in a user-friendly format to the user.
- Planning and analysis – (middle layer) Data Mart – provides tasks such as budget calculation capabilities for the user
- Data warehousing with SAP BW provides integration, consolidation, storage, transformation, cleanup and retrieval for analysis and interpretation. The tool used for data warehousing tasks in SAP BW is the Administrator Workbench.
In summary, Dow Corning uses SAP BW that is a data warehouse that has a data mart which is a subset of the data warehouse information. A data warehouse will not work if information is missing, inconsistent or inaccurate. Data integrity is assured through resolving inconsistencies, performing a gap analysis and using consistent formats for data entry. Business analysts at Dow Corning may use SAP BI data mining to predict product and market trends in the future.
B. What would you expect to be the challenges facing the development of a BI approach for such a large organisation?
According to Atre (2003), “Organizations must understand and address these 10 critical challenges for BI success”.
Business Intelligence (BI) projects fail for the following reasons:
1. Failure to recognize BI projects as cross-organisational business initiatives and understand the differences from typical standalone solutions;
2. Unengaged business sponsors;
3. Unavailable or unwilling business representatives;
4. Lack of skilled and available staff, or sub-optimal staff utilisation;
5. No software release concept (no iterative development method);
6. No work breakdown structure (no methodology);
7. No business analysis or standardisation activities;
8. No appreciation of the impact of dirty data on business profitability;
9. No understanding of the necessity for and the use of meta-data;
10. Too much reliance on disparate methods and tools (i.e the silver bullet syndrome).
Naveen identifies the following BI system critical success factors for business intelligence implementation:
a. Business driven methodology & project management;
b. Clear vision & planning;
c. Committed management support & sponsorship;
d. Data management & quality issues (change management);
e. Mapping the solutions to the user requirements;
f. Performance considerations of the BI system;
g. Robust & extensible framework.
The folllowing are points to increase benefits for a BI project.
- determine the tangible benefits such as eliminated cost of producing a legacy report;
- Enforce access to data for the entire organisation;
- BI project be driven by other business initiatives with the business cases supported by an organisations Enterprise Architects that can identify suitable business projects.
Dow Corning has many large business units and subsidiary units to integrate internal data and has more than half of its global operations with external data that may differ in code and context from each geographical location. BI may be complex and time-consuming if the data structure of the internal data and external data is inconsistent, but if not, BI will provide managers with good decision making information.
C. Would Dow Corning be a suitable candidate for a shared services approach using an ASP? Justify and argue your answer.
It is not likely that Dow Corning will be a suitable candidate for shared services approach using an Application Service Provider (ASP) because the shared service approach is more suited to small to medium sized (SME) companies that have simple and flexible operations. The ASP provides cost efficiencies and ERP products off the shelf for a monthly fee or is rentable over the web, but do not come without risks (i.e. upgrades, stability, reliability, authenticity, privacy, security, downtime, errors, contracts) and with robust ERP solutions that are suited to large organisations such as Dow Corning. In netsourcing, the ERP system runs the business and the IT department maintain responsibility for the ERP development which may be a leadership, control and security risk in a large organisation. Overall, due to the size of Dow Corning, the risks may outweigh the purported cost efficiencies.
Post an entry to your blog that answers the following questions:
Reflections on Course 12073
1. What was the most difficult assessment item you completed so far in COIS12073 this term?
Assignment three (3) was the most exhausting piece of work.
2. What was difficult about it and how would you suggest it could be improved?
Time management for research and finding ERP scholarly information from magazines and publications applicable to Cisco was somewhat difficult and challenging. A suggestion would be to start research in week 1.
Acronyms were too plentiful throughout the course and in many cases had to be reviewed from previous articles/ weeks work for memory. There are many acronyms in context of a particular workplace that become familiar to one in time, but it is difficult to learn and remember so many in such a short time frame. This situation resulted in more time required to complete the work with a comfortable level of understanding.
In a real world, cases would need to be done in a short timeframe, however it would not be as difficult if one was a practicing consultant in this type of industry. Improvements would be to narrow the case study for students, as the direction was too broad and therefore involved over extensive research and time needed to collate useful information for justifying a real and meaningful argument for the chosen option.
3. If you could provide three (3) pieces of advice to a student who will be doing this course next term what would they be?
1. Start research in Google Scholar, Emerald and Proquest in week one (1) for your annotated bibliography and relate it to the case study criteria using excellent time management skills.
2. A few extra hours per week for reading, research and blogs are critical to your success in this course.
3. Read the lecturer weekly notes for additional useful information prior to completing your weekly blogs. Read the chapters, module notes, course profile and case study marking schedule outline before attempting assessable pieces of work and try not to be overwhelmed by acronyms. Perhaps develop a glossary of terms/ acronyms for your benefit.
4. How will you be able to use this knowledge/these skills in your future career?
The knowledge and skills gained in this course will be valuable in my current workplace. It will be interesting to watch the organisation opting for an ERP solution to reengineer the business processes, develop a project management plan and progress further along after the vendor and their best practices have been selected. The IT enterprise architect of the organisation suggests a vanilla ERP solution, however after research and investigation and the knowledge gained from this course, it is the writer’s thoughts that the organisation is more suited to the ERP module approach. In the long term, the benefits will exceed the costs. Further, it will be interesting to further research and compare new ERP technology systems models, development and business trends in future years.
Atre, S 2003, The Top 10 Critical Challenges for Business Intelligence Success, White Paper, Computer World Custom Publishing, viewed 30 December 2009,
http://www.computerworld.com/computerworld/records/images/pdf/BusIntellWPonline.pdf
Burns, M: 2005 Business Intelligence Survey, CA Magazine, vol.138, no. 5, p.18, Toronto viewed 30 December 2009,
http://proquest.umi.com.ezproxy.cqu.edu.au/pqdweb?index=7&did=865601201&SrchMode=1&sid=2&Fmt=4&VInst=PROD&VType=PQD&RQT=309&VName=PQD&TS=1262132642&clientId=20863
van Dyk, L & Conradie, P 2007, Creating Business Intelligence from Course Management Systems, Campus-Wide Information Systems, vol.24, no.2, pp.120-133, Emerald Group Publishing Limitedviewed 30 December 2009,
http://www.emeraldinsight.com.ezproxy.cqu.edu.au/Insight/viewPDF.jsp?contentType=Article&Filename=html/Output/Published/EmeraldFullTextArticle/Pdf/1650240204.pdf
Wikipedia 2009, Business Intelligence, viewed 30 December 2009,
http://en.wikipedia.org/wiki/Business_intelligence
Wikipedia 2009, SAP NetWeaver Business Intelligence, viewed 30 December 2009,
http://en.wikipedia.org/wiki/SAP_NetWeaver_Business_Intelligence
