Summary
Summary Data Analytics
- Course
- Institution
Samenvatting van alle lesstof van het vak Data Analytics, MSc Accountancy & Control. Summary of all lectures of the subject Data Analytics, MSc Accountancy & Control.
[Show more]
1 review
By: jelmervanbeek • 8 months ago
By: BramNorder • 8 months ago
Thanks for your review!
Seller
Follow
BramNorder
Reviews received
Content preview
InhoudData Analytics.........................................................................................................................................2
Topic 1 – Introduction to Data Analytics.............................................................................................2
Topic 2 – Database Concepts and Data Modelling..............................................................................5
Topic 3 – Data Retrieval and Mining...................................................................................................7
Topic 4 – Text Mining.......................................................................................................................11
Topic 5 – Process Mining..................................................................................................................13
1
,Data Analytics
Topic 1 – Introduction to Data Analytics
What is meant with a model?
A simplified representation of reality.
What are the benefits of models?
- Manipulating a model is much easier than manipulating a real system;
- Simulation is easier and does not interfere with the organization’s daily operations;
- Compression of time, years of operations can be simulated in minutes or seconds;
- The cost is much lower than experiments conducted on a real system;
- The consequences of making mistakes are less severe;
- Mathematical models enable the analysis of a very large number of possible solutions;
- Models enhance and reinforce learning and training;
- Models and solution methods are readily available.
What is a System?
A set of two or more interrelated components interacting to achieve a goal (ex. Solar system, school
system).
What are the characteristics of a System?
- Has a boundary;
- Has inputs and outputs;
- Interacts with its environment;
- Is governed by processes, rules and procedures.
What is the difference between data and information?
Data are facts that are collected, recorded, stored and processed. Information is processed data used
in decision making.
What is meant with Decision Support Systems (DSS)?
Interactive computer-based systems which help decision makes utilize data and models to solve
unstructured problems.
What is the objective of Business Intelligence (BI)?
To enable easy access to data (and models) and business managers to analyze it.
What are the four components of a Business Intelligence System?
- A data warehouse with its source data;
- Business analytics (a collection of tools for manipulating, mining, and analyzing the data);
- Business performance management (BPM) capabilities for monitoring and analyzing
performance;
- A use interface (ex. dashboard).
2
, What are the differences between Decision Support Systems and Business Intelligence Tools?
What is meant with OLTP (online transaction processing)?
Term used for transaction processing systems such as ERP, CRM, POS, etc. for capturing and
storing data. Used to process routine operational business tasks.
What does OLTP (online transaction processing) focus on?
Processing and recording data in operational data base systems.
What is meant with OLAP (online analytical processing)?
Converting data into information for decision support.
What does OLAP (online analytical processing) focus on?
Analyzing data stored in a data warehouse.
What is the difference in purpose between OLTP and OLAP?
OLTP is used to carry out day-to day business functions while OLAP is used to support decision
making and providing answers to business and management queries.
What is the difference in data source between OLTP and OLAP?
OLTP uses transaction databases (a normalized data repository primarily focused on efficiency
and consistency) while OLAP uses data warehouses (a non-normalized data repository primarily
focused on accuracy and completeness).
What is the difference in the reporting and speed of OLTP and OLAP?
OLTP is fast, routine, periodic and narrowly focused reports, while OLAP is slow, ad hoc, broadly
focused reports.
What is meant with Slice (OLAP operation)?
Taking a subset of a multidimensional array.
What is meant with Dice (OLAP operation)?
Taking a slice on more than two dimensions.
3
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 or Stuvia-credit 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 BramNorder. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $3.21. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53340 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now