Write some Software

$30-250 USD

W trakcie realizacji

Opublikowano

ponad 7 lat temu

$30-250 USD

Płatne przy odbiorze

Modeling a data warehouse schema Assignments From the description of the domain, given below, elaborate the following tasks: • Model a data warehouse (dw) schema that consists of a set of star-join schemas • Implement the dw schema in a database management system, e.g. MS ACCESS or MS SQLServer and populate the database. And formulate two SQL-queries. • Answer (discuss) four questions Task-description: Model a dw schema In this task you shall model a dw schema consisting of a set of star-join schemas. Each star-join schema consists of a fact and several dimensional tables, see fig. 1. The fact table shall represent a business event and consists of foreign keys (FK) from the surrounding dimension tables and attributes representing facts with values that can be summarized on the fly, see the figure 1 below. The dimension tables represent different multidimensional views or perspectives on the business event. For each dimension table you shall create a primary key (PK), see the figure 1 below. Please notice that the dimension tables are not necessarily normalized to 3NF.

Data Warehousing

Identyfikator projektu: 11424694

Informację o projekcie

3 ofert

Zdalny projekt

Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@iqmax99

Hello, I would like to work with you on this project. I am currently available and can start immediately. I have read your description and I see that It is easy to build required start schema and data model. I could not find the figures you mentioned in the text, please attach them. I promise excellent quality and your complete satisfaction. If you have any questions or have a suggestion for me to make my bid better suite your needs, please let me know. Thank you. Regards, EK MCP (Microsoft Certified Professional), MCAD (Microsoft Certified Application Developer), MCT (Microsoft Certified Trainer) and B.Sc. In Mathematical Statistics and Computer Science 18+ years In Software Development in Fortune 100 Companies such as Texas Instruments UK, EDS Canada, GM Canada Quality is key

$66 USD w 3 dni

0,0

(0 opinii)

0,0

3 freelancerzy składają oferty o średniej wysokości $70 USD dla tej pracy

@point5nyble

Hello, I have been working with a MNC based company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: Expert in SQL Server, Oracle and MS Access Databases Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script Expert in excel Macro Expert in C & C ++ Programming I have experience in all the above areas which I have gained during execution of project work As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble

$77 USD w 5 dni

4,7

(12 opinii)

4,1

@esbecozayed

i have experience to deal with data warehousing specially as i'm graduated from computer science college . I have studied it on college and getting excellent mark (95%) on it . I have doing projects on data warehousing.

$66 USD w 3 dni