Find Jobs
Hire Freelancers

Write some Software

$30-250 USD

En curso
Publicado hace más de 7 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 11424694

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
3 freelancers están ofertando un promedio de $70 USD por este trabajo
Avatar del usuario
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 en 5 días
4,7 (12 comentarios)
4,1
4,1
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de SWEDEN
jonkoping, Sweden
5,0
7
Forma de pago verificada
Miembro desde sept 1, 2016

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.