Icon

Eindopdracht

Data cleaning
Data access

Is er sprake van samenhang tussen het aantal emplyees en de sales?

Nee

Of hoe lang de reseller voor Pedalpeak verkoopt?

Nee

Data merging
Data aggegration

Antwoord op 4a, de factor die het meeste meetelt is het aantal medewerkers dat het bedrijf heeft

De voorspellaar is goed! hij staat namelijk op een R^2 0,937 dit is heel dicht bij de 1 en een stuk hoger dan het minimale van 0,8

de variabele businesstype en aantal werknemers zijn de beste variabele om te gebruiken voor de voorspelling

Voor de voorspelling is er eigenlijk geen goede correlatie te vinden tussen variabele en sales amount

De voorspellaar is niet goed, de R^2 is namelijk lager dan 0,2 en het minimale voor een goede voorspellaar is minimaal 0,8

Data modeling

Is er sprake van samenhang tussen het aantal emplyees en de sales?

Nee

Of hoe lang de reseller voor Pedalpeak verkoopt?

Nee

Filter unnecessaryColumns
Column Filter
Euro's in sales to production costs
Line Plot
Data Acces: ProductCategory
File Reader
Remove Duplicated rows
Duplicate Row Filter
Filter unnecessaryColumns
Column Filter
Character removed: €
String Cleaner
Filter unnecessaryColumns
Column Filter
Date Acces:ProductSubcategory.txt
File Reader
Joiner: ProductCategoryKey to ProductCategoryKey
Joiner
GroupBy: EnglishProductCategoryName toJaar
GroupBy
Top 5 resellers
Top k Row Filter
GroupBy:ProductKey ToEnglishProductName
GroupBy
Change "String" to "Number"
String to Number
Joiner: ProductSubcategoryKey to ProductSubcategoryKey
Joiner
Groupby: ResellerKey
GroupBy
Remove Duplicated rows
Duplicate Row Filter
Sales vs first order year
Scatter Plot
Resellers who needattention
Top k Row Filter
sales vs emplyees
Scatter Plot
Worst 10 gross margin category
Top k Row Filter
Top 10 gross margin category
Top k Row Filter
Yearly sales per catergory
Table View
Top 5 resellers
Table View
Top 10 gross margin category
Table View
Resellers who need attention
Table View
Top 10 gross margin category
Table View
Data Acces: "Sales territory"
File Reader
Formula: PedelpeaksSalesPct
Math Formula
Data Acces: "Geography"
File Reader
Joiner: Productkey To product key
Joiner
Data Acces: "Product"
File Reader
Data Acces: "Currency Rate2025"
Excel Reader
Data acces: ''Total Sales2025''
File Reader
Removing "#" fromString
String Cleaner
Change "string"columnto "number" colomn
String to Number
Change "String" to "Number"
String to Number
Column "String" to Date&Time
String to Date&Time
Change "string"to Date&Time
String to Date&Time
Filter unnecessaryColumns
Column Filter
Joiner: GeographyKey to GeographyKey
Joiner
Joiner
Filter unnecessaryColumns
Column Filter
Cell Splitter
Worst 10 Gross margin city
Top k Row Filter
Cell Splitter
Filter unnecessaryColumns
Column Filter
GroupBy: EnglishCountryRegionName
GroupBy
GroupBy: City
GroupBy
Column Sorter: ResellerKey
Sorter
Numeric Scorer
GroupBy: ResellerKey
GroupBy
Top 10 gross margin city
Top k Row Filter
Worst 10 Gross margin city
Table View
Table View
Scatter Plot
Scatter Plot
GroupBy: ResellerKey
GroupBy
Linear Regression Learner
Table View
Table Partitioner
Numeric Scorer
Regression Predictor
Top10 Gross margin city
Table View
Table view per Reseller
Table View
Sales per country
Table View
GroupBy: Jaar
GroupBy
Table Partitioner
Removing MissingValues
Missing Value
Pivot: Jaar
Pivot
Linear Regression Learner
Date&Time extractorNew Column: Jaar
Date&Time Part Extractor
Change "Number" columnto String
Number to String
Change "String" to "Number"
String to Number
Internetsales %
Line Plot
Joiner
Joining: OrderDateKey to Datkey
Joiner
Formula: "Sales in euro's"
Math Formula
Reseller VS Internet Sales
Bar Chart
File Reader
Remove Duplicated rows
Duplicate Row Filter
Formula: InternetSalesPct
Math Formula
Regression Predictor
Table View
Filtering unnecessary Columns
Column Filter
Formula: TotalSales
Math Formula
Data Acces: "Rreseller"
File Reader
Column Resorter
Joiner: ResellerKeyto ResellerKey
Joiner
GroupBy
Formula: "Brutomarge in %"
Math Formula
Yearly sales, revenue, costs Gross profit margin in %
Table View
Scatter Plot
Table view: Marge
Table View
Scatter Plot

Nodes

Extensions

Links