IT440 - Business Intelligence Fundamentals Homework 1 20 Points | Due: Session 5 Submit your assignment on Blackboard using the \"attach files\" dialog in the assignment submission form associated with this assignment. You will have a Word document and 3 PDF reports to submit for this assignment. You should attach all 4 attachments in one submission. The PDF reports get created in the MicroStrategy exercise. You can use this Word document to supply you answers or create your own. Assignments turned in late, without prior approval, will be assessed a penalty of 1 point for each day late. If you haven't submitted an assignment on Blackboard before, you might find this brief video helpful. 2.5 min video: http://youtu.be/obnSlX5d2Rk Using Business Intelligence to Recognize, Understand, and Address Business Opportunities and Issues (7.5 points) For each of the cases below, in your own words (don't copy and paste), provide a description the business issues (or opportunities) that were being addressed in the case. Define any business terms used. After describing the business issues, provide a description of the BI software tools used and what techniques were applied in the case. Define any BI terms used. You may need to do a bit of research outside the case to define the business terms and BI terms. Andersen Windows http://www.qlik.com/solutions/customers/customer-stories/andersen-windows Business Issues/Opportunities: How BI Applied: Kiva.org https://www.pentaho.com/sites/default/files/micro-lender-visionary-kiva-org-taps-thepower-of-real-time-information-using-pentaho-reporting-and-analytical-software.pdf Business Issues/Opportunities: How BI Applied: Paypal https://rapidminer.com/resource/paypal/ Business Issues/Opportunities: How BI Applied: IT440 - Business Intelligence Fundamentals Homework 1 1 Dana-Farber Cancer Institute http://spotfire.tibco.com/assets/bltfcc5395d519bb9a9/dana-farber.pdf and http://spotfire.tibco.com/assets/bltbaf83cd7a2ac102a/dana-farber-ddd.pdf Business Issues/Opportunities: How BI Applied: Whole Foods Market https://www.microstrategy.com/Strategy/media/downloads/about-us/case-studies/microstrategycustomer-success-story_wholefoods.pdf Business Issues/Opportunities: How BI Applied: IT440 - Business Intelligence Fundamentals Homework 1 2 Data Warehousing Architectures (8 points) For each of the data warehouse architectures listed in the table below, provide the salient features, and the advantages and disadvantages. (Hint: Among other things, your list of features should always include how ETL is implemented and how the meta-data is managed.) Refer to the following sources to complete the table below. Session 2 slides on DW Architecture options Chapter 6 of your course text Ariyachandra, T., & Watson, H. J. (2008). Which Data Warehouse Architecture is Best? Communications Of The ACM, 51(10), 146-147. http://ezproxy.smumn.edu.xxproxy.smumn.edu/login? url=http://search.ebscohost.com/login.aspx?direct=true&db=buh&AN=34540776&site=eds-live Ariyachandra T, Watson H (2006), \"Which Data Warehouse Architecture Is Most Successful?\" Business Intelligence Journal, Vol. 11, No. 1. URL: http://www.teradata.com/t/assets/0/206/276/b24763b1-acd3-45a3-bd4a-b81590d8c9c3.pdf Ariyachandra, T., & Watson, H. (2010). Key Organizational Factors in Data Warehouse Architecture Selection. Decision Support Systems, 49200-212. doi:10.1016/j.dss.2010.02.006 http://ezproxy.smumn.edu.xxproxy.smumn.edu/login? url=http://search.ebscohost.com/login.aspx? direct=true&db=edselp&AN=S0167923610000436&site=eds-live Data Warehouse Architecture Main Features Primary Advantages / Disadvantages Independent Data Marts Data Mart Bus Architecture Hub and Spoke Architecture Centralized Data Warehouse Virtual Architecture IT440 - Business Intelligence Fundamentals Homework 1 3 MicroStrategy OLAP Reporting Exercise (4.5 points) Use the instructions in the associated file provided: \"IT440_HW1_Microstrategy_Exercise_Instructions.pdf\". The \"MicroStrategy 9 Quick Warm-Up Exercise\" instructions were created by Nenad Jukic, Loyola University Chicago, and made available to the Teradata University Network. Add Your Initials for Identification The instructions will have you create 3 reports. We will name our reports just slightly differently than instructed so that your initials will appear in the report heading. When you name your reports (as you save the report definition), add your initials in the report name. By doing this, your initials will be included in the PDF file name as well. For example, for Doug Olson's reports: DO_Qry1, DO_Qry2, DO_Qry3 Attach separately the 3 report PDFs you create to your homework assignment submission on Blackboard. IT440 - Business Intelligence Fundamentals Homework 1 4