{
"id": 64731,
"procurementProjectId": 47728,
"noticeNumber": "2021-064731",
"reducedTimeLimitsForReceiptOfTenders": false,
"corrigendumAdditionalInformation": [],
"creatorSystem": "Cloudia Kilpailutus",
"type": 9902,
"project": {
"id": 47728,
"title": "Tietovarastototeutus ja raportointi (DW\/BI) ",
"contractType": 2,
"procurementCategory": 1,
"referenceNumber": "68\/02.06.01\/2021",
"jointProcurement": false,
"procurementLaw": [],
"centralPurchasing": false,
"coPurchasers": [],
"validationState": 0,
"organisation": {
"id": "a9aca16c-6f91-4029-2e02-08d78deb351a",
"information": {
"officialName": "Kaakkois-Suomen Ammattikorkeakoulu Oy",
"nationalRegistrationNumber": "2472908-2",
"nutsCodes": [
"FI"
],
"postalAddress": {
"streetAddress": "Patteristonkatu 3 D",
"postalCode": "50100",
"town": "Mikkeli",
"country": "FI"
},
"telephoneNumber": "+358 447028976",
"email": "[email protected]",
"contactPerson": "Maiju Kellola",
"mainUrl": "http:\/\/www.xamk.fi",
"validationState": 0
},
"contractingAuthorityType": 64,
"otherContractingAuthorityType": "Kuntien omistama osakeyhti\u00f6",
"contractingType": 0,
"mainActivity": 512,
"mainActivityUtilities": 0,
"validationState": 0,
"dataSource": 0,
"identifierMissing": false
},
"state": 1,
"defenceWorks": 0,
"defenceSupplies": 0,
"publish": 2,
"agricultureWorks": 0,
"isPrivate": false,
"isConcluded": false,
"tendering": 0
},
"lotsInfo": {
"divisionLots": false,
"lotsSubmittedFor": 0,
"lotsSubmittedForQuantity": 0,
"lotsMaxAwarded": false,
"lotsMaxAwardedQuantity": 0,
"lotCombinationPossible": false,
"validationState": 0
},
"objectDescriptions": [
{
"mainCpvCode": {
"code": "72000000",
"name": "Tietotekniset palvelut: neuvonta, ohjelmistojen kehitt\u00e4minen, Internet ja tuki",
"vocCodes": []
},
"additionalCpvCodes": [
{
"code": "72000000",
"name": "Tietotekniset palvelut: neuvonta, ohjelmistojen kehitt\u00e4minen, Internet ja tuki",
"vocCodes": []
}
],
"nutsCodes": [
"FI"
],
"descrProcurement": [
"Kaakkois-Suomen ammattikorkeakoulu Oy pyyt\u00e4\u00e4 tarjouksia tietovaraston, tietomallien ja dynaamisen raportoinnin rakentamiseen sek\u00e4 kokonaisuuden dokumentointiin. ",
"Ratkaisu on kokonaan Microsoft Azuressa toimiva tietoalusta, jonka p\u00e4\u00e4komponentit ovat tietoallas sek\u00e4 automatisoitu Data Vault 2.0 tietovarastoratkaisu.",
"",
"Hankinnan tavoitteena on toteuttaa seuraavat kohdat:",
"",
"1) Tietovaraston k\u00e4yt\u00f6n laajennus (Data Vault 2.0) ",
"",
"2) Tietomallien (Azure Analysis Services Tabular-Model) toteutus sek\u00e4 mittareiden m\u00e4\u00e4rittely ",
"",
"3) Raportoinnin toteutus (Power BI)",
"",
"4) Teknisen toteutuksen dokumentointi, my\u00f6s jo olemassa olevan toteutuksen osalta",
"",
"5) Tietovirtojen automatisointi l\u00e4hdej\u00e4rjestelmist\u00e4 raporteille ja DashBoardeille asti. ",
"",
"6) Lokitusratkaisun suunnittelu ja toteutus ",
"",
"Jatkokehitykselle varataan optioita, jotka kuvataan tarkemmin kohdassa hankinnan kohteen kriteerit. ",
"",
"Yhteen tietovarastoon kootaan tietoja eri tietoj\u00e4rjestelmist\u00e4 ja asiakirjoista\u200b. Sis\u00e4isist\u00e4 tietoj\u00e4rjestelmist\u00e4 mukaan halutaan Peppi, Virta, Justus, Wintime, Vipunen, ARVO, Hansa, Personec FK ja Opintojaksopalautej\u00e4rjestelm\u00e4. K\u00e4yt\u00f6ss\u00e4 oleviin tietoj\u00e4rjestelmiin saattaa tulla muutoksia. ",
"",
"XAMK Oy.n olemassa olevan toimintaymp\u00e4rist\u00f6n kuvaus: ",
"",
"-Tehty MS Azure -ymp\u00e4rist\u00f6\u00f6n",
"Toteutettu Data Vault 2.0 \u2013tietovarasto",
"Tietovarastototeutus tehty vain ARVO:n tietoihin perustuen",
"\u2013Toteutettu kaksi Azure Analysis Services Tabular Model \u2013tietomallia ARVO:n tiedoista",
"1.Tulosseuranta-tietomalli",
"2.Toiminnalliset tavoitteet -tietomalli",
"\u2013Toteutettu tietomalleihin yhteens\u00e4 14 kpl mittareita",
"\u2013Toteutettu yksi raportti, jossa k\u00e4yt\u00f6ss\u00e4 Tulosseurantaan liittyv\u00e4t ARVO:n mittarit ",
"",
"Hankintaa on kuvattu tarkemmin my\u00f6s erillisess\u00e4 liitteess\u00e4 (LIITE 3 - Kuvaus XAMK alusta) ",
" ",
"Hankinnan kohteeseen sis\u00e4ltyy my\u00f6s p\u00e4ivitysten yll\u00e4pitopalvelut, tukipalvelut vikatilanteissa sek\u00e4 k\u00e4ytt\u00e4j\u00e4koulutus (1 pv\u00e4) "
],
"disagreeAwardCriteriaToBePublished": false,
"awardCriteria": {
"criterionTypes": 8,
"qualityCriteria": [],
"costCriteria": [],
"priceCriterion": {},
"criterion": [],
"criteriaStatedInProcurementDocuments": false
},
"estimatedValue": {
"type": 0
},
"timeFrame": {
"type": 2,
"months": 24,
"canBeRenewed": true,
"renewalDescription": [
"Sopimuskauteen sis\u00e4ltyy 24 kk perusjakso ja 12 kk + 12 kk optiojaksot.",
"",
"Mik\u00e4li sopimusta ei irtisanota, sopimus jatkuu optiokausien ajan."
]
},
"candidateNumberRestrictions": {
"envisagedNumber": 0,
"envisagedMinimumNumber": 0,
"envisagedMaximumNumber": 0,
"selected": 0
},
"optionsAndVariants": {
"variantsWillBeAccepted": false,
"partialOffersWillBeAccepted": false,
"options": false,
"optionType": 0,
"optionsDays": 0,
"optionsMonths": 0
},
"tendersMustBePresentedAsElectronicCatalogs": false,
"euFunds": {
"procurementRelatedToEuProgram": false
},
"validationState": 0
}
],
"communicationInformation": {
"procurementDocumentsAvailable": 1,
"procurementDocumentsUrl": "https:\/\/tarjouspalvelu.fi\/xamk?id=328962&tpk=69b478d8-6014-4c4e-b53e-c1149e44fbf1",
"additionalInformation": 1,
"additionalInformationAddress": {
"officialName": "Kaakkois-Suomen Ammattikorkeakoulu Oy",
"nationalRegistrationNumber": "2472908-2",
"nutsCodes": [
"FI"
],
"postalAddress": {
"streetAddress": "Patteristonkatu 3 D",
"postalCode": "50100",
"town": "Mikkeli",
"country": "FI"
},
"telephoneNumber": "+358 447028976",
"email": "[email protected]",
"contactPerson": "Maiju Kellola",
"mainUrl": "http:\/\/www.xamk.fi",
"validationState": 0
},
"otherAddressForProcurementDocuments": {
"nutsCodes": [],
"validationState": 0
},
"sendTendersOption": 1,
"electronicAddressToSendTenders": "https:\/\/tarjouspalvelu.fi\/xamk?id=328962&tpk=69b478d8-6014-4c4e-b53e-c1149e44fbf1",
"addressToSendTenders": {
"nutsCodes": [],
"validationState": 0
},
"electronicCommunicationRequiresSpecialTools": false,
"documentsEntirelyInHilma": false,
"specsAndAdditionalDocuments": 0,
"validationState": 0
},
"contactPerson": {
"name": "Maiju Kellola",
"email": "[email protected]",
"phone": "+358 447028976"
},
"procurementObject": {
"shortDescription": [
"Kaakkois-Suomen ammattikorkeakoulu Oy pyyt\u00e4\u00e4 tarjouksia tietovaraston, tietomallien ja dynaamisen raportoinnin rakentamiseen (Power BI) sek\u00e4 kokonaisuuden dokumentointiin. ",
"",
"Tietovarastoratkaisu on kokonaan Microsoft Azuressa toimiva tietoalusta, jonka p\u00e4\u00e4komponentit ovat tietoallas sek\u00e4 automatisoitu Data Vault 2.0 tietovarastoratkaisu.",
"",
"",
"",
""
],
"estimatedValueCalculationMethod": [],
"mainCpvCode": {
"code": "72000000",
"name": "Tietotekniset palvelut: neuvonta, ohjelmistojen kehitt\u00e4minen, Internet ja tuki",
"vocCodes": []
},
"defence": {
"nutsCodes": [],
"frameworkAgreement": {
"includesFrameworkAgreement": false,
"includesConclusionOfFrameworkAgreement": false,
"frameworkAgreementType": 0,
"frameworkEnvisagedType": 0,
"includesDynamicPurchasingSystem": false,
"dynamicPurchasingSystemInvolvesAdditionalPurchasers": false,
"dynamicPurchasingSystemWasTerminated": false,
"estimatedTotalValue": {
"type": 0
},
"duration": {
"type": 0,
"canBeRenewed": false
}
},
"subcontract": {
"tendererHasToIndicateShare": false,
"tendererHasToIndicateChange": false,
"caMayOblige": false,
"successfulTenderer": false,
"successfulTendererToSpecify": false
},
"optionsAndVariants": {
"variantsWillBeAccepted": false,
"partialOffersWillBeAccepted": false,
"options": false,
"optionType": 0
},
"totalQuantityOrScope": {
"type": 0
},
"renewals": {
"canBeRenewed": false
},
"timeFrame": {
"type": 0,
"canBeRenewed": false
}
},
"validationState": 0
},
"conditionsInformation": {
"economicCriteriaToParticipate": false,
"technicalCriteriaToParticipate": false,
"restrictedToShelteredWorkshop": false,
"restrictedToShelteredProgram": false,
"reservedOrganisationServiceMission": false,
"executionOfServiceIsReservedForProfession": false,
"participationIsReservedForProfession": false,
"obligationToIndicateNamesAndProfessionalQualifications": false,
"validationState": 0
},
"conditionsInformationDefence": {
"restrictedToShelteredWorkshops": false,
"restrictedToShelteredProgrammes": false,
"restrictedToParticularProfession": false,
"staffResponsibleForExecution": false,
"validationState": 0
},
"conditionsInformationNational": {
"validationState": 0,
"reservedForShelteredWorkshopOrProgram": false
},
"complementaryInformation": {
"isRecurringProcurement": false,
"estimatedTimingForFurtherNoticePublish": [],
"electronicOrderingUsed": false,
"electronicInvoicingUsed": true,
"electronicPaymentUsed": true,
"additionalInformation": [],
"validationState": 0
},
"datePublished": "2021-02-12T07:53:41.3601887",
"state": 2,
"tedPublishState": 0,
"tedValidationErrors": [],
"procedureInformation": {
"procedureType": 1,
"acceleratedProcedure": false,
"contestType": 0,
"frameworkAgreement": {
"includesFrameworkAgreement": false,
"includesConclusionOfFrameworkAgreement": false,
"frameworkAgreementType": 0,
"frameworkEnvisagedType": 0,
"includesDynamicPurchasingSystem": false,
"dynamicPurchasingSystemInvolvesAdditionalPurchasers": false,
"dynamicPurchasingSystemWasTerminated": false,
"estimatedTotalValue": {
"type": 0
},
"duration": {
"type": 0,
"canBeRenewed": false
}
},
"reductionRecourseToReduceNumberOfSolutions": false,
"reserveRightToAwardWithoutNegotiations": false,
"electronicAuctionWillBeUsed": false,
"procurementGovernedByGPA": false,
"disagreeCriteriaForEvaluationOfProjectsPublish": false,
"national": {
"transparencyType": 0,
"limitedNumberOfParticipants": false,
"numberOfParticipants": 0
},
"validationState": 0
},
"tenderingInformation": {
"tendersOrRequestsToParticipateDueDateTime": "2021-03-04T12:00:00",
"languages": [
"FI"
],
"tendersMustBeValidOption": 2,
"tendersMustBeValidForMonths": 3,
"tenderOpeningConditions": {
"openingDateAndTime": "2021-03-04T14:00:00"
},
"defence": {
"previousPublicationExists": false,
"hasPreviousContractNoticeOjsNumber": false,
"hasPreviousExAnteOjsNumber": false,
"payableDocuments": false,
"languageType": 0,
"languages": [],
"otherLanguage": false
},
"estimatedExecutionTimeFrame": {
"type": 3,
"canBeRenewed": false
},
"validationState": 0
},
"rewardsAndJury": {
"prizeAwarded": false,
"serviceContractAwardedToWinner": false,
"decisionOfTheJuryIsBinding": false,
"validationState": 0
},
"resultsOfContest": {
"contestWasTerminated": false,
"noPrizeType": 0,
"originalNoticeSentVia": 0,
"participantsContemplated": 0,
"participantsSme": 0,
"participantsForeign": 0,
"disagreeParticipantCountPublish": false,
"disagreeWinnersPublish": false,
"disagreeValuePublish": false,
"validationState": 0
},
"attachments": [],
"hasAttachments": true,
"changes": [],
"isCorrigendum": false,
"isMigrated": false,
"isCancelled": false,
"cancelledReason": [],
"isLatest": true,
"language": "FI",
"proceduresForReview": {
"reviewBody": {
"officialName": "Kaakkois-Suomen Ammattikorkeakoulu Oy\/kirjaamo",
"nutsCodes": [],
"postalAddress": {
"streetAddress": "Patteristonkatu 3 D",
"postalCode": "50100",
"town": "Mikkeli",
"country": "FI"
},
"email": "[email protected]",
"mainUrl": "http:\/\/www.xamk.fi",
"validationState": 0
},
"validationState": 0
},
"attachmentInformation": {
"description": [],
"links": [
{
"url": "https:\/\/vm.fi\/documents\/10623\/307565\/JYSE+palvelut\/564be8e8-8ed1-4b44-a206-701e54f6348e"
}
],
"validationState": 0
},
"modifications": {
"additionalCpvCodes": [],
"nutsCodes": [],
"timeFrame": {
"type": 0,
"canBeRenewed": false
},
"totalValue": {},
"awardedToGroupOfEconomicOperators": false,
"contractors": [],
"reason": 0,
"increaseBeforeModifications": {},
"increaseAfterModifications": {},
"validationState": 0
},
"contractAwardsDefence": [
{
"numberOfTenders": {
"disagreeTenderInformationToBePublished": false,
"total": 0
},
"contractor": {
"nutsCodes": [],
"postalAddress": {},
"isSmallMediumEnterprise": false,
"validationState": 0
},
"estimatedValue": {},
"contractValueType": 0,
"finalTotalValue": {},
"lowestOffer": {},
"highestOffer": {},
"annualOrMonthlyValue": {
"type": 0,
"canBeRenewed": false
},
"likelyToBeSubcontracted": false,
"valueOfSubcontract": {},
"valueOfSubcontractNotKnown": false,
"allOrCertainSubcontractsWillBeAwarded": false,
"shareOfContractWillBeSubcontracted": false,
"validationState": 0
}
],
"hilmaStatistics": {
"energyEfficiencyConsidered": false,
"innovationConsidered": false,
"smeParticipationConsidered": false,
"validationState": 0
},
"isPrivateSmallValueProcurement": false,
"dateCreated": "2021-02-12T07:53:41.307334",
"dateModified": "2021-02-12T07:53:41.3612091"
}