DSCI 5330 - Exam 1 Questions With Explanations Of Answers.
16 keer bekeken 0 keer verkocht
Vak
DSCI
Instelling
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
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
√ Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, Bancontact of creditcard voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper RealGrades. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €12,33. Je zit daarna nergens aan vast.
