DSCI 5330 - Exam 1 Questions With Explanations Of Answers.
16 vues 0 fois vendu
Cours
DSCI
Établissement
DSCI
What is BI/BA? - correct answer The term BI/BA can be used interchangeably. BI is an umbrella term that combines architecture, tools, databases, analytical tools, applications, and methodologies. It is content free expression (means different things to different...
DSCI 5330 - Exam 1
What is BI/BA? - correct answer The term BI/BA can be used interchangeably. BI is
an umbrella term that combines architecture, tools, databases, analytical tools, applications, and
methodologies. It is content free expression (means different things to different people). It's objective is
to enable easy access to data (and models) to provide business managers the ability to conduct analysis.
It helps transform data, to information, to decisions (and knowledge), and to action.
What is Analytics? - correct answer Process of developing actionable decisions or
recommendations for actions based upon insights generated from historical data
What is ETL? - correct answer ETL is a data integration framework to extract,
transform, and load data to a DW. Most useful when you need to produce a data warehouse of well-
documented and reliable data for historical analyses such as time series analysis or multidimensional
queries.
- Extract - reading data from one or more databases.
- Transform - converting the extracted data from its previous form into the form in which it needs to be
so that it can be placed into a DW or another database.
- Load - Putting the data into DW.
What is EAI? - correct answer Enterprise application integration - integrated
application functionality (focused on sharing functionality rather than data) across systems, enabling
flexible use. Can be used via API or SOA via web services. EAI is most useful when you need to connect
applications in real time for business process automation.
What is EII? - correct answer Enterprise information integration - A mechanism for
pulling data from source system to satisfy a request for information. i.e. populated views. Can be
physical or virtualized. Currently evolving promising real-time data integration. (Federated approach). EII
is most useful when you need to create a common gateway with one access point and one access
language to disparate data sources
What is BPM? - correct answer Business Performance Management - Refers to the
business process, methodologies, metrics, and technologies used by enterprises to measure, monitor,
and managed business performance.
, - A set of integrated, closed-loop management and analytic processes (supported by technology) that
addresses financial as well as operational activities
- Tools for businesses to define strategic goals and then measure and manage performance against
those goals
- A core set of processes, including financial and operational planning, consolidation and reporting,
modeling, analysis, and monitoring of key performance indicators (KPIs), linked to organizational
strategy
What is OLAP? - correct answer A database design fo efficiently conduct data
analysis. Give management ability to scour data for information, provide tactical or operational decision
support. Allowing the end-user to slice and dice. Effectiveness and efficiency to provide correct
information in a timely manner. Whereas OLTP is designed for everyday operations to efficiently
insert/update/delete from a relational database on a transactional basis.
Explain real-time BI. - correct answer Also known as right time BI. It means different
things for different processes. (Example - Cold-chain requires real-time BI with must up to date data
within minutes to keep the storage at an optimal state). Can be enabled via EII/EAI.
Explain true real-time BI. - correct answer True real-time BI means data are
provided instantaneously (may be case depending on the process).
- Pros: Provides most up to date data
- Cons: Expensive infrastructure. Can have multiple versions of the truth from the user's perspective.
What is data mining? - correct answer The nontrivial process of identifying valid,
novel, potentially useful, and ultimately understandable patterns in data stored in structured databases.
How can OLAP be used? - correct answer - Converting data into information for
decision support
- Data cubes, drill-down / rollup, slice & dice, ...
- Requesting ad hoc reports
- Conducting statistical and other analyses
- Developing multimedia-based applications
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur RealGrades. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €12,30. Vous n'êtes lié à rien après votre achat.
