Welcome to Live Chat

Welcome to LiveWebTutors Services, World's leading Academic solutions provider with Millions of Happy Students.

Call Back
logo

24x7 Support Available

To Get the Best Price Chat With Our Experts

chat now

In A Hurry? Get A Callback

shopping cart 0

Subject Solutions Code Description Price Delete

Amount Payable : $0

continue shopping proceed to checkout

World's Leading Assignment Library

Master of Business Analytics                   BUS5WB  La Trobe Business School  1 BUS5WB - Data Warehousing and Big Data  Assignment 01: Data Warehouse Design  Marks: 40%  Assignment Type: Individual

Question Preview:

MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 1 BUS5WB‐DataWarehousingandBigData Assignment01:DataWarehouseDesign Marks:40% AssignmentType:Individual DueDate:11:59PMSunday16thApril23rdApril2017(LMSdropbox). Thefirstassignmentaimstotestyourknowledgeandskillsindatawarehousedesign.Aswehave discoveredinlecturesandfromreadingmaterial,thedesignstageiscrucialforthesuccessofany warehouseandoverallorganisationalBIstrategy. TheCase Vigourisafictitioushealthcareproviderspecialisingingeriatrics.Itsmissionstatementistoimproveeach andeveryclient’squalityoflife.Thistranslatesintotw...

View Complete Question >>

Question Preview:

MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 1 BUS5WB‐DataWarehousingandBigData Assignment01:DataWarehouseDesign Marks:40% AssignmentType:Individual DueDate:11:59PMSunday16thApril23rdApril2017(LMSdropbox). Thefirstassignmentaimstotestyourknowledgeandskillsindatawarehousedesign.Aswehave discoveredinlecturesandfromreadingmaterial,thedesignstageiscrucialforthesuccessofany warehouseandoverallorganisationalBIstrategy. TheCase Vigourisafictitioushealthcareproviderspecialisingingeriatrics.Itsmissionstatementistoimproveeach andeveryclient’squalityoflife.Thistranslatesintotwoprimarybusinessobjectives:promotehealthand wellbeing,diagnoseandtreatchronicdiseaseconditions. Vigouroperatesonasubscription‐basedmodel,whereclientskeentoobtainthehealthservicespayan upfrontmembershipfeeandamonthlysubscription.Havingbeeninbusinessforthepasttenyears,the CEOatVigourisconfidentthatthesubstantialaccumulationofdataintransactionsystemscanbe capitalisedtoimprovetheeffectivenessandefficiencyofeachbusinessoperation.He’skeentoimplement anorganisation‐widedatawarehousingsolutiontoexplorethispotential.He’sapproachedananalytics consultancyfirmtostartonthisproject.Thebusinessrequirementsanalysisandfeasibilitystudywere completedonapositivenoteandnowyouhavebeenrecruitedasthedimensionalmodelspecialistto completethedatawarehousedesignphase. Consultations ServicesofferedbyVigouraremodelledaroundacircleofsupportforeachclient.Clientscanbe individualswithacondition(ormultipleconditions)orhealthyindividualsconcernedabouttheirhealthas theygrowold.PotentialclientsareeitherreferredbyaGPordirectlygetintouchwithVigour.Clients keentosubscribetoVigour servicesundergoaninitialconsultationwithageneralmedicalpractitioner. Soonafter,theclient’spersonalinformationisrecordedintheconsultationsystem.Thegeneralmedical practitionerlooksaftertheclientduringtheentireconsultationphaseandhe/sherecordsthediagnoses, medicalreportsandanycurrentmedication.Thefirstconsultationwilldetermineifaclientrequires furtherspecialistconsultation,medicaldiagnosticortreatment.Inthefirstinstanceoneormany consultations(dependingonthenumberofconditions)arescheduledwithrelevantspecialists.Specialists areundercontractwiththeorganisationandcomeinwheneverthere’sarequirement. Inthecaseofmedicaldiagnosticorclinicaltreatmentabookingismadewithoneofthethirdpartyhospital partnerstoprovidethistreatment.Uponcompletingtheprocedure,thehospitalgetsbacktothe consultantwiththediagnosis,costandrelevantreports.Basedonthereports,anewspecialist consultationmaybescheduled.Theclientisofferedtheoptiontomeetalternativeandholistichealth specialistsduringtheconsultationphase.Giventhepopularityofholisticmedicine,clientalwayspreferto meetwithoneofthesespecialists.Priortoexitingtheconsultationphase,theclientmeetswiththegeneral medicalpractitionerwhoreviewstheentirediagnosisalongsiderecommendedmedication. MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 2 Careplanmanagement Soonaftertheconsultationphase,theclientisassignedtoacareplanbythesamegeneralpractitioner. Thecareplanisessentiallyaninstrumenttomeasuretheclient’sprogressovertime–itissimilartoan electronichealthrecordbutcarriesspecificinformationpertainingtotheclient’sillnessesand progress/recoveryovertime.Thecareplanhasanestimatedenddate(whichmaychange)andthe managementteamlooksaftertheclientduringthisphase.Eachclientisassignedacarerwhousually remainswiththeclientfromstarttoend.Aclientexitsthecareplanwhenthecondition(s)haveimproved andareatastagewheretheycanbemanagedindependently.Thecarerandtheclientmeetatregular intervals(careplanconsultations(CPC))toreviewandupdatethecareplanandalsotakeanyadditional stepsrequired.ThefrequencyofCPCsandupdatestothecareplanvarydependingontheclient’s condition‐minimumweekly,monthlytobi‐monthly. AteachCPCthecarerrecordsvitalmeasurementsoftheclient.Thisincludesbodymassindexandablood profile(bloodglucoselevel,lipidprofile,levelsofvitaminsetc)andconditionspecificmarkerssuchas eyesight,hearingandsodiumlevels.Inadditiontothemeasurements,thecarerasksaseriesofquestions todeterminetheclient’smentalandemotionalwellbeing.Theclient’smedicationisalsoreviewedand anyside‐effects,after‐effectsarerecorded.Iftheclient’sconditionhasdegradedsincethelastvisit,the carerhastodecideifit’snecessarytosendtheclientbacktoconsultationphaseorinexceptionalinstances immediatedispatchtoahospital.MostoftenaftereveryCPCtheclientmeetswiththeresidentdietician whogoesthroughtheclient’scurrentdietplanandmakesamendmentsifneeded.Allchangesarenoted onanelectroniccareplanlog. Eachcareplanmaintainsoverallnumericalscoresoftheclient’sprogresstowardsachievingthisgoal.The carerdecideswhenthescorescanbeincreasedordecreased.Thescoresarephysicalhealth(stateofthe illness(es)),mentalhealth,client’sawarenessoftheillness(es)andclient’sawarenessoftheirdiet. Pharmacy Vigourrunsitsownpharmacytoaddressthediversetypesofmedicationrequiredbyitsclientele.The pharmacystocksmedicinefromdifferentpharmaceuticalcompaniesforeachtypeofmedication.The quantitysold,sellingpriceandcostpricearerecordedforeachsuchtype.Themedicationrecordis maintainedseparatetothecareplanandlookedafterbythepharmacyteam.Thisrecordmaintainsaone‐ to‐onelinkbetweentheclientandthemedication,itdoesnotrecordmedicalconditions.Theconsultation reportinitiatesthepharmacyprocessandreturnstobereviewedaftereachCPC. Billing Asmentioned,clientsobtainhealthservicesonasubscriptionbasis.Hospitalchargesfordiagnosticsand clinicaltreatmentaswellasmedicationfromthepharmacyareadditionalchargestothemonthly subscription.ExceptionalcircumstancesthatmayariseduringtheCPCmeet‐upsarealsoadditional expenses.Thebillingsystemmaintainsarecordofbothsubscriptionsandadditionalexpensesforevery client.Clientsthatchoosetopaythesubscriptionannuallyreceivea10%discount.Billingalsomaintainsa recordofthechargestoeachthirdpartyhospitalpartnersfortheservicestheyprovide.Vigourinternal expenses,suchasemployeesalariesandoverheadsaremanagedbyFinanceandnottheBilling department. ITsystems Eachbusinessfunctionelaboratedabovehasitsowntransactionsystemwithaback‐enddatabase. SnapshotsofselectedERdiagramsfromthesedatabasesareprovidedbelow.Theyshouldaidyouto understandthenatureofthesystemsandtheworkflowatVigour.Itwasobservedthatsomeofthe databasewerenotentirelynormalisedandattimesusesummaryattributestostoreanumberofvalues (e.g.bloodprofile–glucoselevels,lipidprofilestoredasafreetextcolumn). MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 3 Consultations Careplanmanagement MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 4 Pharmacy Billing MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 5 Arole‐playexampleofaclientpathwaywithintheorganisation’shealthservicesisgivenbelow. Rayisa60yearoldmankeentosubscribetoVigourhealthservices.Hehasseveralmedicalconditions, diabetes,hypertensionandglaucoma.InhisfirstvisittoVigourhemeetsageneralpractitionerwhogoes throughhisconditionhistoryandcurrentmedication.HerecommendsRayundergoseveralmedical diagnostics(eyetest,glucoseprofileandECG)atanearbyhospitalandalsoschedulesconsultationswith ageneralphysicianandcardiologist.Aftercoupleofweeksforexaminationsandconsolationshe’sbackto meetthegeneralpractitioner.Again,thegeneralpractitionergoesthroughconsultantrecommendations, reviewshismedicationandplaceshiminacareplan. Afteraweek,Raymeetswithhisassignedcarerwhochecksandrecordshisbiomarkers(bloodprofile,BMI). Shealsoreviewshismedicationandnotesdownresponsestoasetofquestions.Shealsorecordscareplan measuresforRay.NextRayisintroducedtoadieticianandtheysittogethertodiscussthedietplan.The nextcareplanconsultationisscheduledintwoweeks’time. TheCEOhasprovidedseveralexamplesofthetypesofinformationhe’sinterestedtoextractfromthe warehouse.Trynottorestrictyourdesigntotheseexamples,keepinmindtheoverallmotivationof increasedeffectivenessandefficiency(andsingleversionoftruth)whendesigningthemodel.Healso spokeatlengthofanewproject,anonlinecollaborationplatform,conceptualisedbytheITdepartment. Thisonlineplatform,stillinitsinfancy,willfacilitatecommunicationandinformationexchangeamong clientswithsimilarconditions.Someofthefeatureshementionedwereasocialnetwork,blogpostsand discussionforums. Consultation  Numberofclientsbynumberofmedicalconditions(single‐morbidity,multi‐morbidity)  Demographicdistributionandtypesofmedicalconditionsofclientswhodonotreturnafterthefirst consultation  Demographicdistributionofclientswhoexpressinteresttomeetholisticmedicinepractitioners  Numberofclientswithmultipleconditionsthatrequireforclinicalprocedures  Mostreliablehospitalpartners  Mostcost‐effectivehospitalpartners  Mostdedicatedgeneralmedicalpractitionersandmedicalspecialists(withconsistentperformance) Careplanmanagement  Successfulandunsuccessfulcareplanfiguresbynumberofmedicalconditionsofeachclient  Demographicdistributionofclientscompletingthecareplanon‐time  Progressmeasuresbyclientdetailscomparedbyyear  Correlationbetweenblood‐gasmeasuresandclient’sprogressmeasuresovertime  Typesofmedicationcloselyassociatedwithsuccessfulcareplans  Profileofclientswhosehealthdegradedtoexceptionalcircumstances(hospitalisation,diagnostics) duringacareplanperiod  Mostdedicatedcarersandtheirsuccessrate MasterofBusinessAnalyticsBUS5WB LaTrobeBusinessSchool 6 Pharmacy  Revenuebymedicationtypebysupplier  Quantitysoldbycustomerdemographicsbymedicationtype  Toptenmedicinesandsuppliers  Mostprescribedmedicinebymedicalcondition  Costbreakdownofthesamemedicationbydifferentsuppliers  Toptenconsistentlyin‐demandmedicine Billing  Revenuebyyearbymedicalcondition  Distributionofsubscriptionsovertimebyclientdemographics  Typesofsubscriptionsthatrequireadditionalcharges  Demographicsofcustomerspayingannual  Mostactive/leastactiveperiodofbusinessduringtheyear Whatyouarerequiredtodo 1. Requirements:Identifycurrentandfuturedecision‐makingneedsandinformationrequirementsof theorganisation.Determinethenumberofdimensionalmodelsrequired(withjustification). 2. SQL:CompileSQLstatements,basedongiveninformationandERdiagrams,toaddressfivedecision makingneedsidentifiedabove. 3. Design:FollowKimball’sdimensiondesignprocesstocreatetheidentifiedmodels.Reviseeachmodel byapplyingthefacttableanddimensiontabletechniques.Provideadatadictionary(adescriptionof eachtableineachmodeloutliningthepurpose,attributesanddatatypes). 4. Demonstration:Demonstratehoweachdimensionalmodelcanbeusedtorespondtocurrentand futurebusinessquestionsanddecision‐makingscenarios.Articulatehowthedimensionalmodelcan leadtoeffectivedecisions. Deliverables AprofessionallywrittenreportonthedimensionaldesignactivitiesundertakenforVigour.Thiscanbe compiledasaseriesoftopicsoftheabovementioned‘todo’listorformattedasadesigndocument.  ThereportshouldbecompiledinMicrosoftWord,fontsize11.  Reportcontentshouldnotexceed8‐10pages(includingdiagrams).Diagramshavetobeinthemain bodyasitisadesigndocument.Ifthenumberofpagesareinsufficient,youmayincludethedata dictionaryasanappendix.  Youarefreetomakeanyassumptionswithjustification.Includetheseinthereport,whereapplicable.  Makerealisticassumptionsonanyinformation(schemaorbusinessrequirements)thatmaybe missingintheabovedescription. acrossentiredesign.

View Less >>

Solution Preview

Executive Summary:
Vigour Company provides the healthcare services mainly for old patients. They are mainly
involved for improving health and wellbeing as well as treating chronic diseases. Its
subscription-based model offers the services to the clients by connecting with hospitals as
consultations, care plan management and a total pharmacy solution. So, its CEO decides to
implement the system as organization-wide data warehousing solution.

question Get solution

$15

Orginal Price : $19.50

Pay Now

Upload Assignments

250 words

side

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

logo

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide