DSCI 5330 - Exam 1 Questions With Explanations Of Answers.
16 views 0 purchase
Module
DSCI
Institution
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller RealGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £10.40. You're not tied to anything after your purchase.
