Page 63 - DCAP606_BUSINESS_INTELLIGENCE
P. 63

Business Intelligence




                    Notes          8.  Give some examples of expression and descriptions.
                                   9.  Discuss about the spread sheet formulas.
                                   10.  What is the analysis services speed?
                                   11.  Explain the concept of metadata.

                                   12.  What are the various types of metadata?
                                   13.  Discuss about the metadata functions.
                                   14.  What are the advantages of metadata?

                                   Answers: Self Assessment

                                   1.  Averages                          2.   Cube

                                   3.  Measure                           4.   Calculated member
                                   5.  Hierarchy                         6.   OLAP
                                   7.  Learning curve                    8.   True
                                   9.  False                             10.  Metadata
                                   11.  Name/value pair                  12.  Metadata query expression

                                   13.  Zero                             14.  Lowercase
                                   15.  Cross dimensional calculations   16.  OLAP Aware Functions
                                   17.  False                            18.  True

                                   19.  True                             20.  True
                                   4.11 Further Readings




                                   Books       Carlo Vercellis (2011). “Business Intelligence: Data Mining and Optimization for Decision
                                               Making”. John Wiley & Sons.
                                               David Loshin (2012). “Business Intelligence: The Savvy Manager’s Guide”. Newnes.

                                               Elizabeth Vitt, Michael Luckevich, Stacia Misner (2010). “Business Intelligence”.
                                               O’Reilly Media, Inc.
                                               Rajiv Sabhrwal, Irma Becerra-Fernandez (2010). “Business Intelligence”. John
                                               Wiley & Sons.
                                               Swain Scheps (2013). “Business Intelligence for Dummies”. Wiley.



                                   Online links  dublincore.org/metadata-basics/

                                               www.guardian.co.uk › Technology › Data protection
                                               www.newyorker.com/.../verizon-nsa-metadata-surveillance-problem.html
                                               www.sas.com/technologies/bi/olap/






          58                                LOVELY PROFESSIONAL UNIVERSITY
   58   59   60   61   62   63   64   65   66   67   68