Samenvatting
Summary Data Analytics
Samenvatting van alle lesstof van het vak Data Analytics, MSc Accountancy & Control. Summary of all lectures of the subject Data Analytics, MSc Accountancy & Control.
[Meer zien]Voorbeeld 3 van de 16 pagina's
Voorbeeld 3 van de 16 pagina's
In winkelwagengesponsord bericht van onze partner
1 beoordeling
Door: jelmervanbeek • 7 maanden geleden
Door: BramNorder • 7 maanden geleden
Bedankt voor je beoordeling!
Voorbeeld van de inhoud
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
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, creditcard of Stuvia-tegoed 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 BramNorder. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €2,99. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 67474 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen