ISM540: Introduction to Business Intelligence
Credit Hours: 3Contact Hours: This is a 3-credit course, offered in accelerated format. This means that 16 weeks of material is covered in 8 weeks. The exact number of hours per week that you can expect to spend on each course will vary based upon the weekly coursework, as well as your study style and preferences. You should plan to spend 10
week in each course reading material, interacting on the discussion boards, writing papers, completing
Course Description and Outcomes
This course provides students with an overview of Business Intelligence (BI) for an enterprise, establishing the foundation for using data in cross-functional key areas
and other elements, to assist with generating actionable intelligence data for decision making in order to achieve or maintain competitive advantage in the workplace and evaluate how well corporate key performance indicators are being met.
The course covers all of the details involved in of which is a data warehouse database.
evaluating sources of transaction data, data cleansing, refreshing the data wa delivery of the outputs. Finally, the course investigates the
spectrum of BI system users throughout the enterprise. Course Learning Outcomes:
1. Gain an overview of business intellig
2. Analyze business data and recommend techniques to transform data into a form used by organizations to gain business advantage.
3. Demonstrate the ability to provide data analysis and find appl
Participation & Attendance
Prompt and consistent attendance in your online courses is essential for your success at CSU
Failure to verify your attendance within the first 7 days of this course may result in your withdrawal. If for some reason you would like to drop a course, please contact your advisor.
Online classes have deadlines, assignments, and participation requirements just like on
your time carefully and keep an open line of communication with your instructor. If you are having technica problems, problems with your assignments, or
instructor know as soon as possible.
Introduction to Business Intelligence
credit course, offered in accelerated format. This means that 16 weeks of material is covered in 8 weeks. The exact number of hours per week that you can
to spend on each course will vary based upon the weekly coursework, as well as your study style and preferences. You should plan to spend
10-week in each course reading material, interacting on the discussion boards, writing papers, completing projects, and doing research.
Course Description and Outcomes
This course provides students with an overview of Business Intelligence (BI) for an enterprise, establishing the functional key areas, such as accounting, sales, production, customer data, th generating actionable intelligence data for decision making in order to achieve or maintain competitive advantage in the workplace and evaluate how well corporate key performance The course covers all of the details involved in planning for, constructing, and evaluating a BI system, the heart of which is a data warehouse database. It also covers in detail the importance of gathering user requirements, evaluating sources of transaction data, data cleansing, refreshing the data warehouse, and various modes of
Finally, the course investigates the differing needs and expectations of the wide spectrum of BI system users throughout the enterprise.
Gain an overview of business intelligence and uses of BI in organizations to meet strategic objectives. Analyze business data and recommend techniques to transform data into a form used by organizations Demonstrate the ability to provide data analysis and find applicable business intelligence solutions.
rompt and consistent attendance in your online courses is essential for your success at CSU
Failure to verify your attendance within the first 7 days of this course may result in your withdrawal. If for some ourse, please contact your advisor.
nline classes have deadlines, assignments, and participation requirements just like on-campus classes. your time carefully and keep an open line of communication with your instructor. If you are having technica problems, problems with your assignments, or other problems that are impeding your progress, let your
credit course, offered in accelerated format. This means that 16 weeks of material is covered in 8 weeks. The exact number of hours per week that you can
to spend on each course will vary based upon the weekly coursework, as -25 hours per week in each course reading material, interacting on the discussion boards, writing
This course provides students with an overview of Business Intelligence (BI) for an enterprise, establishing the such as accounting, sales, production, customer data, th generating actionable intelligence data for decision making in order to achieve or maintain competitive advantage in the workplace and evaluate how well corporate key performance
planning for, constructing, and evaluating a BI system, the heart importance of gathering user requirements,
rehouse, and various modes of differing needs and expectations of the wide
ence and uses of BI in organizations to meet strategic objectives. Analyze business data and recommend techniques to transform data into a form used by organizations
icable business intelligence solutions.
rompt and consistent attendance in your online courses is essential for your success at CSU-Global Campus. Failure to verify your attendance within the first 7 days of this course may result in your withdrawal. If for some
campus classes. Budget your time carefully and keep an open line of communication with your instructor. If you are having technical
Course Materials
Textbook Information is located in the CSU
Course Schedule
Due DatesThe Academic Week at CSU-Global begins on Monday and ends the following Sunday. • Discussion Boards: The original
Responses posted by Sunday 12 midnight MT.
• Mastery Exercises: Students may access and retake mastery exercises they achieve the scores they desire.
• Critical Thinking Activities: Assignments are due Sunday at 12 midnight MT. Wee
k #
1
• Chapters 1-2, 21 in Business Intelligence • Mulcahy, R. (2013). Business
Retrieved from
http://www.cio.com/article/40296/Business_Intelligence_Definition_an d_Solutions
2
• Chapters 3-5 in Business Intelligence • The University of Arizona. (2009).
Retrieved from http://mosaic.arizona.edu/files/files/BI_3
3
• Chapters 6-7 in Business Intelligence • Green, W. (2008). Automating
system [White paper]. Retrieved from
http://www.meritalk.com/uploads_legacy/whitepapers/Automating_d ata_flows_to_your_business_intelligence_system_whitepaper.pdf
4
• Chapters 8-9 in Business Intelligence
• Datawarehouse4u.info. (2009). OLTP vs. OLAP. Retrieved from http://datawarehouse4u.info/OLTP
• Pro Business Systems LLC. (2012). Star Retrieved from
http://www.learndatamodeling.com/star.php
5
• Chapters 10-13 in Business Intelligence • Scott Ambler & Associates. (2012). Business
http://www.agilemodeling.com/artifacts/businessRule.htm • Patel, S. (2012). Requirement to cleanse DATA in ETL process and
data cleansing in business application Engineering Research and Applications
http://www.ijera.com/papers/Vol2_issue3/EN23840842.pdf
6
•• Chapters 14-15 in Business IntelligenceCloudera Inc. (2013). Hadoop and
Textbook Information is located in the CSU-Global Booklist on the Student Portal.
Global begins on Monday and ends the following Sunday.
riginal post must be completed by Thursday at 12 midnight MT Responses posted by Sunday 12 midnight MT. Late posts may not be awarded points.
udents may access and retake mastery exercises through the last day of class they desire.
Critical Thinking Activities: Assignments are due Sunday at 12 midnight MT.
Readings Business Intelligence
Business intelligence definition and solutions. http://www.cio.com/article/40296/Business_Intelligence_Definition_an
•
Business Intelligence
The University of Arizona. (2009). Business intelligence implementation. Retrieved from http://mosaic.arizona.edu/files/files/BI_3-2-09.pdf
• Business Intelligence
Automating data flows to your business intelligence Retrieved from http://www.meritalk.com/uploads_legacy/whitepapers/Automating_d ata_flows_to_your_business_intelligence_system_whitepaper.pdf • • Business Intelligence
Datawarehouse4u.info. (2009). OLTP vs. OLAP. Retrieved from http://datawarehouse4u.info/OLTP-vs-OLAP.html
Pro Business Systems LLC. (2012). Star schema: General information. http://www.learndatamodeling.com/star.php
• •
Business Intelligence
Scott Ambler & Associates. (2012). Business rules. Retrieved from http://www.agilemodeling.com/artifacts/businessRule.htm
Patel, S. (2012). Requirement to cleanse DATA in ETL process and why is business application? International Journal of
Engineering Research and Applications, 2(3), 840-842. Retrieved from http://www.ijera.com/papers/Vol2_issue3/EN23840842.pdf
• • •
Business Intelligence
Cloudera Inc. (2013). Hadoop and big data. Retrieved from
• •
ost must be completed by Thursday at 12 midnight MT and Peer Late posts may not be awarded points.
through the last day of class until
Assignments Discussion (25 points) Discussion (25 points) Discussion (25 points) Critical Thinking (100 points) Discussion (25 points) Critical Thinking (100 points) Discussion (25 points) Critical Thinking (100 points) Portfolio Outline (0 points) Discussion (25 points) Critical Thinking (150
http://www.cloudera.com/content/cloudera/en/why cloudera/hadoop-and-big-data.html
• Manyika, J., Chui, M., Brown, B., Bughin, J., Dobbs, R., Roxburgh, C., & Hung Byers, A. (2011, May). Big data:
competition, and productivity. Retrieved from
http://www.mckinsey.com/insights/business_technology/big_data_the _next_frontier_for_innovation
7
• Chapters 16-17 in Business Intelligence
• Stein, J. (2011, March 10). Data mining: How companies now know everything about you. Time Magazine
http://www.time.com/time/magazine/article/0,9171,2058205 3,00.html
• Andrew. (2011, April 8). Difference between
Retrieved from http://www.differencebetween.com/difference
between-data-mining-and-8
• Chapters 18-20 in Business Intelligence • Hall, O. P. (2013). Using dashboard
Graziadio Business Review, 6
http://gbr.pepperdine.edu/2010/08/using intelligence-systems
• Meyer, A. (2013, August 10 new and old data. Retrieved from
http://www.workingknowledge.com/blog/tag/publicly
Assignment Details
This course includes the following assignments/projects: Module 1
Portfolio Project
Read the Portfolio Project Description on the Week 8 Assignments page. The Portfolio Project requires that you put yourself in the position of a manager for a passenger ship company and create a business intelligence system to meet the organization’s needs. Look also at the rubric for this project, found under the Course Information, for how the work will be graded. You must submit an outline of your work in Week 5.
The Portfolio Project will be due at the end of Sunday midnight of Week 8.
Module 3
Critical Thinking
Business Processes and Requirements
Write 1 to 2 page responses each to any 2 of the following 3
Discuss the advantages of the business process modeling approach for system development.
http://www.cloudera.com/content/cloudera/en/why-data.html
Manyika, J., Chui, M., Brown, B., Bughin, J., Dobbs, R., Roxburgh, C., & ). Big data: The next frontier for innovation, competition, and productivity. Retrieved from
http://www.mckinsey.com/insights/business_technology/big_data_the _next_frontier_for_innovation
Business Intelligence
). Data mining: How companies now know Time Magazine. Retrieved from
http://www.time.com/time/magazine/article/0,9171,2058205-). Difference between data mining and OLAP.
http://www.differencebetween.com/difference--vs-olap/
•
Business Intelligence
Using dashboard based business intelligence systems. Graziadio Business Review, 6(4). Retrieved from
http://gbr.pepperdine.edu/2010/08/using-dashboard-based-business-, August 10). Innovation in analytics: New value from new and old data. Retrieved from
http://www.workingknowledge.com/blog/tag/publicly-available-data/ • •
This course includes the following assignments/projects:
Read the Portfolio Project Description on the Week 8 Assignments page. The Portfolio Project requires that you put yourself in the position of a manager for a passenger ship company and create a business intelligence system
rganization’s needs. Look also at the rubric for this project, found under the Course Information, for how the work will be graded. You must submit an outline of your work in Week 5.
The Portfolio Project will be due at the end of the course, to be submitted through the assignment link dropbox by
Business Processes and Requirements (100 Points)
2 page responses each to any 2 of the following 3 topics (2 to 4 pages total): advantages of the business process modeling approach for system development.
points)
Discussion (25 points)
Discussion (25 points) Portfolio (350 points)
Read the Portfolio Project Description on the Week 8 Assignments page. The Portfolio Project requires that you put yourself in the position of a manager for a passenger ship company and create a business intelligence system
rganization’s needs. Look also at the rubric for this project, found under the Course Information, for
ted through the assignment link dropbox by
Describe the different types of data processing that can be utilized in a business intelligence system and the advantages of using each type.
Explain the importance of gathering adequate data requirements for an effective business intelligence system and the best methods to accomplish this.
Your responses must make reference to the course material and outside academic sources from the CSU-Global Library and should be well written and in conformity with CSU-Global APA and writing expectations. CSU-Global APA guidelines can be found in the Library under "APA Guide & Resources" under the Library Resources section.
Module 4
Critical Thinking: Forward Contracts
Data Warehousing and Metadata (100 points)
Perform research to locate a commercial business that has successfully developed and utilized a business intelligence system to improve their bottom line profit or market share.
Write a case-study paper that describes the following: 1. the vertical market of this business
2. the horizontal processing types that were utilized and the return on investment
3. any problems that were encountered planning for, developing, or executing the system and how these were handled
4. the cost of the system
5. the development methodology used 6. the total development time
7. the competitive advantage gained by the business processing system in the particular vertical marketplace
8. the return on investment and any future expansion plans for the system
Your paper should be 3 to 5 pages and refer to outside academic sources from the CSU-Global Library and the course materials. It should be well written and in conformity with Global APA and writing expectations. CSU-Global APA guidelines can be found in the Library under "APA Guide & Resources" under the Library Resources section.
Module 5
Critical Thinking
Managing Organizational Data (100 points)
Perform research to locate a government organization that has successfully developed and utilized a business intelligence system to improve their bottom line profit or market share.
Write a case-study paper that describes the following: 1. the vertical market of this business
2. the horizontal processing types that were utilized and the return on investment
3. any problems that were encountered planning for, developing, or executing the system and how these were handled
4. the cost of the system
6. the total development time
7. the competitive advantage gained by the business processing system in the particular vertical marketplace
8. the return on investment and any future expansion plans for the system
Your paper should be 3 to 5 pages and refer to outside academic sources from the CSU-Global Library and the course materials. It should be well written and in conformity with Global APA and writing expectations. CSU-Global APAguidelines can be found in the Library under "APA Guide & Resources" under the Library Resources section.
Portfolio Outline (0 points)
Submit an outline of your portfolio. Review the requirements of the portfolio in Module 8. The outline should reflect the topic you chose in Module 3 and cover all the required elements of the assignment. Submit your outline in the assignment dropbox.
Include with your outline a draft of your proposed sources, listed in correct APA format.
No points are assigned for this deliverable, but points will be deducted from your final grade on the Portfolio Project if you fail to submit this item as required (see the Portfolio Project Rubric for grading details). Additionally, you will be expected to account for the instructor's feedback in the final version of the Portfolio Project
assignment.
Module 6
Critical Thinking
System Architecture (150 points)
You are the CIO of a large organization that has been suffering a declining market share for the last several years. You realize the importance of a business intelligence system and how this can help your organization regain their competitive advantage, but your upper management is reluctant to allocate the funding or resources for what they consider a risky venture and yet another data processing system since there are already so many in your
organization.
Develop a critical essay proposal paper to your CEO explaining that a business intelligence system is not a waste of time and money and how it might actually turn the business around.
Your paper should be 5 to 7 pages, refer to outside academic sources from the CSU-Global Library and course materials, be well written and in conformity with CSU-Global APA and writing expectations. CSU-Global APA guidelines can be found in the Library under "APA Guide & Resources" under the Library Resources section.
Module 8
Portfolio Project
A Business Intelligence System (350 points)
You are an IT project manager at LECAL Cruises, Inc. Your company owns 10 cruise ships but hopes to increase their fleet in the next five years through increased bookings, improved destinations and on-shore excursions, and more on-board amenities.
LECAL’s ships currently have between 500- and 2,000-passenger capacities. They are looking to build two new ships in the next five years but are unsure of the best size.
Recently there have been some problems with engine room f
LECAL is concerned about the harm these incidents may have done to their reputation in the industry. They suspect that postings on Facebook and Twitter, as well as online blogs
passengers are saying to others about their positive and negative experiences. Your company has five legacy systems that have a
1) past bookings from passengers 2) past on-shore excursions
3) records of on-board entertainment and 4) records of LECAL employees serving as both on
at the headquarters office.
LECAL attempted to create a data warehouse a few years ago
management now wants to create a business intelligence system that would best serve their needs. They are unsure if a data warehouse would be best, a business analytics system for big data would be better, or perhaps a combination of both. They have no clue as to
what the best outputs would be to achieve their goal of a 50% increase in revenue in the next five years. They have tasked you to create a detailed proposal for a comprehensive business inte
strategic goal. The initial phase of the project must start producing actionable intelligence in six months most of the system is to be in place in the next year. It is anticipated that the system will constantly evo time to process additional inputs and produce different types of outputs.
For your portfolio assignment, submit a proposal for a business intelligence system for LECAL. Determine the best strategy for input data, processing types, and output reporting.
You will submit an outline of your proposal in Week 5, together with a list of proposed sources. You shoul for your instructor’s feedback in Week 5 in your final project.
Your proposal should reference at least five credible sources written, and in conformity with CSU
in the Library under "APA Guide & Resources" under the Library Resources section.
Course Policies
Course Grading
20% Discussion Participation 45% Critical Thinking Activities 35% Final Portfolio Paper
Recently there have been some problems with engine room fires and temporary loss of power on cruises LECAL is concerned about the harm these incidents may have done to their reputation in the industry. They suspect that postings on Facebook and Twitter, as well as online blogs, may provide evidence of what passengers are saying to others about their positive and negative experiences.
Your company has five legacy systems that have a 10-year history of: past bookings from passengers
board entertainment and sales
records of LECAL employees serving as both on-board staff from captain to dishwasher and support staff at the headquarters office.
LECAL attempted to create a data warehouse a few years ago, but the project failed miserably. Your upper ow wants to create a business intelligence system that would best serve their needs. They are unsure if a data warehouse would be best, a business analytics system for big data would be better, or perhaps a combination of both. They have no clue as to what the required inputs to a business intelligence system may be or what the best outputs would be to achieve their goal of a 50% increase in revenue in the next five years.
They have tasked you to create a detailed proposal for a comprehensive business intelligence system to meet their strategic goal. The initial phase of the project must start producing actionable intelligence in six months
most of the system is to be in place in the next year. It is anticipated that the system will constantly evo time to process additional inputs and produce different types of outputs.
submit a proposal for a business intelligence system for LECAL. Determine the best strategy for input data, processing types, and output reporting.
You will submit an outline of your proposal in Week 5, together with a list of proposed sources. You shoul for your instructor’s feedback in Week 5 in your final project.
Your proposal should reference at least five credible sources from the CSU-Global Library, be 15 written, and in conformity with CSU-Global APA and writing expectations. CSU-Global APA in the Library under "APA Guide & Resources" under the Library Resources section.
20% Discussion Participation 45% Critical Thinking Activities
Grading Scale and Policies
A 95.0 – 100 A- 90.0 – 94.9 B+ 86.7 – 89.9 B 83.3 – 86.6 B- 80.0 – 83.2 C+ 75.0 – 79.9 C 70.0 – 74.9
ires and temporary loss of power on cruises, and LECAL is concerned about the harm these incidents may have done to their reputation in the industry. They
may provide evidence of what past cruise
board staff from captain to dishwasher and support staff
but the project failed miserably. Your upper ow wants to create a business intelligence system that would best serve their needs. They are unsure if a data warehouse would be best, a business analytics system for big data would be better, or perhaps a
the required inputs to a business intelligence system may be or what the best outputs would be to achieve their goal of a 50% increase in revenue in the next five years.
lligence system to meet their strategic goal. The initial phase of the project must start producing actionable intelligence in six months, and then most of the system is to be in place in the next year. It is anticipated that the system will constantly evolve over
submit a proposal for a business intelligence system for LECAL. Determine the best
You will submit an outline of your proposal in Week 5, together with a list of proposed sources. You should account
, be 15 to 20 pages, well guidelines can be found
D 60.0 – 69.9
F 59.9 or below
In-Classroom Policies
For information on late work and Incomplete grade policies, please refer to our In-Classroom Student Policies
and Guidelines or the Academic Catalog for comprehensive documentation of CSU-Global institutional policies.
Academic Integrity
Students must assume responsibility for maintaining honesty in all work submitted for credit and in any other work designated by the instructor of the course. Academic dishonesty includes cheating, fabrication, facilitating academic dishonesty, plagiarism, reusing /re-purposing your own work (see CSU-Global Guide to Writing and APA Requirements for percentage of repurposed work that can be used in an assignment), unauthorized
possession of academic materials, and unauthorized collaboration. The CSU-Global Library provides information on how students can avoid plagiarism by understanding what it is and how to use the Library and Internet resources.
Citing Sources with APA Style
All students are expected to follow the CSU-Global Guide to Writing and APA Requirements when citing in APA (based on the APA Style Manual, 6th edition) for all assignments. For details on CSU-Global APA style, please review the APA resources within the CSU-Global Library under the “APA Guide & Resources” link. A link to this document should also be provided within most assignment descriptions on your course’s Assignments page. Netiquette
Respect the diversity of opinions among the instructor and classmates and engage with them in a courteous, respectful, and professional manner. All posts and classroom communication must be conducted in accordance with the student code of conduct. Think before you push the Send button. Did you say just what you meant? How will the person on the other end read the words?
Maintain an environment free of harassment, stalking, threats, abuse, insults or humiliation toward the
instructor and classmates. This includes, but is not limited to, demeaning written or oral comments of an ethnic, religious, age, disability, sexist (or sexual orientation), or racist nature; and the unwanted sexual advances or intimidations by email, or on discussion boards and other postings within or connected to the online classroom.