tutorbin

data warehousing homework help

Boost your journey with 24/7 access to skilled experts, offering unmatched data warehousing homework help

tutorbin

Trusted by 1.1 M+ Happy Students

Recently Asked data warehousing Questions

Expert help when you need it
  • Q1:PK DimDate DateKey FullDate EnglishDayName EnglishMonthName CalendarYear Quarter DayOfWeek IsWeekend int date time varchar(10) varchar(10) int int int boolean The following criteria will be used to grade the assignment: • Codes are run with detail comment, accurate, and answers are correct. ***********NOTE ********* Please feel free to consult your instructor by email or phone, if you have questions or need assistance!!/nAssignment 3 - ETL for Simple Dimension Tables Summer 2023 It must be submitted through the "Assignment 3 - ETL for Simple Dimension Tables" in Assignment Submission Folder provided in the D2L. It is important that you specify your name in the SQL Server Integration Service DTSX file. The attachment name should follow the following convention: BUSA532_ASSIGNMENT3_FIRSTNAME_LASTNAME.DTSX. Overview: Now that we have learned to create dimensional model for enterprise data warehouse. The next phrase is ETL process that we are going to load our data from OLTP database to our OLAP database. In this assignment, your goal is to load data from DateKey CSV file into your Date dimension table in OLAP by using SSIS. Business scenario: Please install AdventureWorks database, read the AdventureWorks case study, and analyze the ERD OLTP schema before starting this assignment. The CEO of AdventureWorks wants a data warehouse to keep track of sales performance. The figure below shows the date dimension table of AdventureWorks's OLAP. Import CSV file from D2L, then create SSIS package solution that can perform ETL process to load data into your Date dimension table (10 points).See Answer
  • Q2:PK SalesPerformanceFact FK Sales Personkey FK OrderDateKey TotalTaxAmount TotalSubTotal HighestTaxAmountForOrder DimDate DateKey Full Date int datetime int int int int int SalesPersonDim SalesPersonKey BusinessEntityID Marital Status Gender SalesQuota int int varchar(25) varchar(25) int/nAssignment 4 - ETL for Simple Enterprise Data Warehouse Summer 2023 It must be submitted through the "Assignment 4 - ETL for Simple Enterprise Data Warehouse" in Assignment Submission Folder provided in the D2L. It is important that you specify your name in the SQL Server Integration Service DTSX file. The attachment name should follow the following convention: BUSA532_ASSIGNMENT4_FIRSTNAME_LASTNAME.DTSX. Overview: Now that we have learned to load data into Date dimension in assignment 3. In assignment 4, we are going to repeat the ETL process for other dimension and fact tables. In this assignment, you goal is to load data from OLTP database to create dimension and fact table using SSIS. Business scenario: Please install AdventureWorks database, read the AdventureWorks case study, and analyze the ERD OLTP schema before starting this assignment. The CEO of Adventure Work Inc. wants a data warehouse to keep track of sales' performance. The figure below shows tables of Adventure Work Inc.'s OLAP. Three fact metrics that he wants to have for his data warehouse: TotalTaxAmount, TotalSubTotal, and HighestTaxAmountForOrder. Create SSIS package solution that can perform ETL process to load data into OLAP database (10 points). Please note that Sales PersonDim should handle Slowly Changing Dimension issues. The following criteria will be used to grade the assignment: • Codes are run with detail comment, accurate, and answers are correct. *** NOTE Please feel free to consult your instructor by email or phone, if you have questions or need assistance!!See Answer

TutorBin Testimonials

I found TutorBin Data Warehousing homework help when I was struggling with complex concepts. Experts provided step-wise explanations and examples to help me understand concepts clearly.

Rick Jordon

5

TutorBin experts resolve your doubts without making you wait for long. Their experts are responsive & available 24/7 whenever you need Data Warehousing subject guidance.

Andrea Jacobs

5

I trust TutorBin for assisting me in completing Data Warehousing assignments with quality and 100% accuracy. Experts are polite, listen to my problems, and have extensive experience in their domain.

Lilian King

5

I got my Data Warehousing homework done on time. My assignment is proofread and edited by professionals. Got zero plagiarism as experts developed my assignment from scratch. Feel relieved and super excited.

Joey Dip

5

TutorBin helping students around the globe

TutorBin believes that distance should never be a barrier to learning. Over 500000+ orders and 100000+ happy customers explain TutorBin has become the name that keeps learning fun in the UK, USA, Canada, Australia, Singapore, and UAE.