Samenvatting
Data Analytics & Professional Skills (Lectures Summary)
All summaries for data analytics & professional skills.
[Meer zien]Voorbeeld 5 van de 46 pagina's
Voorbeeld 5 van de 46 pagina's
In winkelwagengesponsord bericht van onze partner
Voorbeeld van de inhoud
DataAnalytics &
Professional
Skills
Summary of the Lectures
Given in: 2021/2022 | Summary by LouisT
,Contents
Chapter 1. Introduction to Data Analytics ............................................................................................. 3
1.1 Course...................................................................................................................................... 3
1.2 Development .......................................................................................................................... 3
1.3 Managerial Decision Making .................................................................................................. 4
1.3.1 Decision-Making Process ................................................................................................ 4
1.4 Model ...................................................................................................................................... 5
1.4.1 Benefits of Models ................................................................................................................. 5
1.5 Data Vs Information ............................................................................................................... 7
1.6 Business Analytics ................................................................................................................... 8
1.7 Big Data ................................................................................................................................... 9
1.8 What is a Data Scientist? ........................................................................................................ 9
Chapter 2. Data Warehousing & Visual Analytics................................................................................ 11
2.1 What’s a Data Warehouse? .................................................................................................. 11
2.2 Why do we need databases?................................................................................................ 11
2.3 Databases vs Data Warehouse ............................................................................................. 11
2.4 Data Mart .............................................................................................................................. 12
2.5 Data Extraction, Transformation, and Load (ETL)................................................................ 12
2.6 OLTP VS OLAP ....................................................................................................................... 12
2.7 Data Lakes ............................................................................................................................. 14
2.8 Data Visualization ................................................................................................................. 14
Chapter 3. Database Concepts and Data Modelling ............................................................................ 15
3.1 Relational Database .............................................................................................................. 15
3.2 Data Modelling ..................................................................................................................... 15
3.3 Entity-Relationship Modelling .............................................................................................. 15
3.3.1 Cardinalities .................................................................................................................. 17
3.4 Developing E-R Diagrams ..................................................................................................... 21
3.5 Dealing with Big Data ........................................................................................................... 21
Chapter 4. Database Concepts and Data Modelling ............................................................................ 22
4.1 Design Requirement ............................................................................................................. 22
4.2 Implementing Relationships................................................................................................. 22
4.3 SQL Overview (Structured Query Language) ....................................................................... 24
Chapter 5. Data Mining ........................................................................................................................ 26
5.1 Data Mining Characteristics and Objectives ........................................................................ 26
5.2 A Taxonomy for Data Mining Tasks ..................................................................................... 27
A Summary by LouisT on Stuvia.nl | Thank you for your purchase | Version 2.0 (Final)
, 5.3 Data Mining and Statistics .................................................................................................... 27
5.4 Training and Testing Classification Methods ....................................................................... 29
5.5 Cluster Analysis ..................................................................................................................... 32
5.5.1 Why do we have Clustering? ........................................................................................ 32
Chapter 6. Process Mining .................................................................................................................... 34
6.1 System Documentation ........................................................................................................ 34
6.1.1 Why do we need System Documentation?.................................................................. 35
6.2 Process Mining (The Basics) ................................................................................................. 35
6.3 Process Mining (Terminology) .............................................................................................. 35
6.4 Process Mining (Input).......................................................................................................... 35
6.5 Process Mining (Algorithms) ................................................................................................ 36
6.6 Process Mining (Output)....................................................................................................... 37
Chapter 7. Text Mining ......................................................................................................................... 43
7.1 Data mining versus Text mining ........................................................................................... 43
7.2 Text Mining Tasks ................................................................................................................. 43
7.3 Natural Language Processing (NLP)...................................................................................... 44
7.4 Text Mining Process .............................................................................................................. 44
7.4.1 Step 1: Establish the Corpus (Collect data) .................................................................. 44
7.4.2 Step 2: Create the term-by-document Matrix (TDM) .................................................. 44
7.4.3 Step 3: Text Mining ....................................................................................................... 45
4
A Summary by LouisT on Stuvia.nl | Thank you for your purchase | Version 2.0 (Final)
,Chapter 1. Introduction to Data Analytics
1.1 Course
The course is split into two parts, which are Data Analytics and Professional Skills.
Data analytics will not be very theoretical, it will be more about applying the theory.
There will be two tutorials (DA) and three workshops (PS). These will be mandatory and if not
attending, an automatic fail for the exam. Workshops it is advised to install the program beforehand
as this is also important for the final exam. If you have any questions, the contact hours are 5-6 PM
on Wednesday and Thursday.
There will be an example exam before the final exam. The exam will consist of multiple-choice
questions and open questions.
Furthermore, group exercises will be given. You have to Conceptualize and describe a data analysis
solution for a specific type of company, and this must be a recorded group presentation. 3 minutes
for every group member.
Why do we need this course?
Big Data is causing information overload among decision-makers. In addition, someone must be able
to understand the data by using suitable techniques capable of dealing with Big Data via advanced
data analytics. The people with this understanding are currently very lacking in the accounting
profession.
1.2 Development
Many developments have been made in technologies that are affecting accounting. This is because
of BI, Warehouses, and audit firms that have started using data analytics. This means it makes a shift
from traditional accounting to new accounting.
Thanks to these technological innovations, it is possible to have cloud-based services which are very
accessible, from anywhere and saved digitally. The software also took over the majority of
transactions in bookkeeping activities.
3
A Summary by LouisT on Stuvia.nl | Thank you for your purchase | Version 2.0 (Final)
, 1.3 Managerial Decision Making
Decision-making is nearly the same as management as this is a process by which organizational goals
are achieved. Decision-making consists of selecting the best solution from two or more alternatives.
If the management wants to make the right decision, which I bet they do, they require sufficient
information.
1.3.1 Decision-Making Process
Normally four steps are taken to make a decision. These are Intelligence, design, choice, and
implementation. A quick explanation of these four steps:
1. Intelligence
First, we define the problem or opportunity, what or why do we need to make a decision
should be determined beforehand.
2. Design
After we understand why or what decision to make. We must construct a model that
describes the situation and find alternative solutions.
3. Choice
Here we compare, evaluate, and make the decision. Or we advise the manager what to do
and then the manager makes the decision.
4. Implementation
We implement the chosen solution.
4
A Summary by LouisT on Stuvia.nl | Thank you for your purchase | Version 2.0 (Final)
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 louist. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €6,49. Je zit daarna nergens aan vast.
Is Stuvia te vertrouwen?
4,6 sterren op Google & Trustpilot (+1000 reviews)
Afgelopen 30 dagen zijn er 75057 samenvattingen verkocht
Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen