100% tevredenheidsgarantie Direct beschikbaar na betaling Zowel online als in PDF Je zit nergens aan vast
logo-home
Data Analytics & Professional Skills (Lectures Summary) €6,49
In winkelwagen

Samenvatting

Data Analytics & Professional Skills (Lectures Summary)

 41 keer bekeken  0 keer verkocht

All summaries for data analytics & professional skills.

Laatste update van het document: 2 jaar geleden

Voorbeeld 5 van de 46  pagina's

  • 12 december 2021
  • 28 december 2021
  • 46
  • 2021/2022
  • Samenvatting
Alle documenten voor dit vak (5)
avatar-seller
louist
Data
Analytics &
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

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

Snel en makkelijk kopen

Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.

Focus op de essentie

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 52510 samenvattingen verkocht

Opgericht in 2010, al 14 jaar dé plek om samenvattingen te kopen

Start met verkopen
€6,49
  • (0)
In winkelwagen
Toegevoegd