Session12-INFS1000-S2-2016-preview [Slides Format].pdf

Operational databases used by various information

Info icon This preview shows pages 6–16. Sign up to view the full content.

View Full Document Right Arrow Icon
An Important distinction from last week! Operational Databases : Used by various Information Systems across the organisation on a daily basis (whenever we talked about Databases so far, we meant Operational Databases!) Data Warehouse : Large storage container, which collects regularly data from operational databases Need to clean up data when doing this Data Cleansing Contains historical data which doesn't change! Used for BI DWs are optimised for running large scale analyses; doing analyses on operational databases might slow them down and affect day-to-day business.
Image of page 6

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Business Data Architecture Business Data Architecture BI Methods Reporting OLAP Data Mining
Image of page 7
Online Analytical Processing (OLAP) OLAP: Very quick (in real time) Enables executives to make timely decisions Often decision-makers need to view information in different configurations: Quantities of each product sold in each region Quantities of each product sold within each city of a region Quantities sold of a specific product in all cities of a region Users can rotate virtual “cubes” according to the dimensions needed!
Image of page 8

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Example methodology: Market-Basket Analysis (MBA) Market-basket analysis is a data-mining technique for determining sales patterns Uses statistical methods to identify sales patterns in large volumes of data Shows which products customers tend to buy together Helps identify cross-selling opportunities, e.g. ‘Customers who bought book X also bought book Y’ Used to estimate probability of customer purchase, e.g., in 20% of transactions where product ‘A’ was purchased, products ‘B’ and ‘C’ were purchased
Image of page 9
Agenda for today 1. Repetition W11: Data Warehouse & Bus. Intelligence 2. Activity: MCQ 3. Collaboration systems 4. Activity: Consulting @ $RU (Shadow Boxing) 10 INFS1000: Digital Business Innovation
Image of page 10

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Activity W12: Multiple Choice Repetition 11 INFS1000: Digital Business Innovation
Image of page 11
Learning objectives: At the end of this workshop you will have a much better understanding of… Characteristics of Collaboration Systems How to analyse collaboration scenarios, select suitable systems and justify your decisions. Enterprise 2.0 and the emerging role of Social Media in the workplace Reading guide: Textbook chapter extension 2 12 INFS1000: Digital Business Innovation
Image of page 12

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Why Use Information Systems for Collaboration? Collaboration Systems Collaboration is critical in business Work is increasingly distributed People are not located in the same place (Virtual Teams) Collaboration systems (Groupware): No need for face-to-face meetings Won’t lose or misplace work Able to know who contributes and who is not Create better results 13 INFS1000: Digital Business Innovation
Image of page 13
List of collaborative systems eMail Telephone / Skype Teleconference Instant Messaging Discussion boards Wikis Blogs File Sharing (Sharepoint) Team surveys Team calendar Video conference Desktop conference (with presentation capabilities) Project management solutions Workflow systems Microblogging There is a wide variety of collaborative systems… 1 INFS1000: Digital Business Innovation
Image of page 14

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
How do we select the right tool for the job?
Image of page 15
Image of page 16
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern