Find Jobs
Hire Freelancers

Analysis SQL Server

$10-30 USD

Cerrado
Publicado hace más de 9 años

$10-30 USD

Pagado a la entrega
Part 1: Develop two data markets; Share dimensions across data markets; Handle semi-additive measures. Requirements: You are asked to use the Foodmart database (file: [login to view URL]) that you should first import in SQL Server Management Studio to develop a sales data market in SQL Server BI Development Studio. The first data market is about the sales business process. Your fact table should be about the sales for 1998 (be careful: not just December 1998). As dimensions, please include: • Product (be careful: product dimension is “snowflaked”) • Time (time by date) • Customer (don’t include the attributes Mi, Address2, …, Address4). • Promotion • Store You may wish to include several of the available attributes for the dimensions and also to introduce hierarchies, when possible. As measures in the fact table, please include: • Store Sales • Unit Sales The second data market is about the inventory business process. Your fact table should be about the inventory for year 1998. As dimensions, please include: • Product • Time (time_by_day) • Store • Warehouse (be careful: warehouse dimension is “snowflaked”) You may wish to include several of the available attributes for the dimensions and also to introduce hierarchies, when possible. As measure in the fact table, please include: • Units ordered Here we make the assumption that after products being ordered (from the supplier), the delivery may not be always successful. Therefore, orders may be repeated over time. This way, you can treat “Units ordered” as a semi-additive measure. Please explain how you can (re-)define1 “Time by Date” as dimension of type “Time” and which Aggregate Function for averaging do you have to use for the “Units ordered” measure. Deliverables As deliverables for Part 1, please make: • A brief report with screen-shots and short description of the steps you followed. • One example of a screenshot from the “Browser” for the sales and one for the inventory data market (please pick just the time dimension). -------- Part 2: Perform OLAP operations such as roll-up/drill-down/slice; Connect MS SQLServer with MS Excel. Requirements You are asked to use the “Sales” cube that you created in Part 1 and generate Excel charts for the following OLAP reports and answer the questions listed below: 1. Profit with respect to Gender and Marital Status. Profit can be defined according to Store Sales (or alternatively according to Unit Sales). • Question(s): Is Marital Status a more important factor for Males or Females with respect to profit? 2. Profit with respect to all Store Cities in USA and the 4 quarters of year 1998. • Question(s): Which Store City had the largest profit for the fourth quarter of 1998? 3. Profit with respect to Promotions in Store State ‘OR’ of USA. Exclude ‘No promotion’ from the result. • Question(s): Which promotion resulted to the largest Profit? Please provide your comment about your answer to the last question. 4. Profit with respect to Customers State Province in USA and their Marital Status for the four quarters of year 1998. • Question(s): In which State (or States) is Profit largest in the fourth Quarter of 1998; and is this happening both for ‘Married’ and ‘Single’ customers or only for one of these categories? How could you interpret this conclusion about the found state (or states), assuming that the fourth quarter of the year includes the pre Christmas (data is up to November) shopping period? Drill-down to the level of Customer City for the found state (or states) and check whether this conclusion (i.e., comparison between ‘Married’ and ‘Single’ in Q4) holds for all or some of the cities. Deliverables As deliverable for Part 2, please make: • Excel charts showing the results of the OLAP queries. ------------------ For part 3 and 4 please look at the uploaded PDF document. Budget can be extended to max. $ 50
ID del proyecto: 6141293

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 10 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
9 freelancers están ofertando un promedio de $101 USD por este trabajo
Avatar del usuario
Dear Sir I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and five years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$55 USD en 1 día
5,0 (60 comentarios)
5,5
5,5
Avatar del usuario
If you agree with my price then we go ahead with your project. your budget suggest is too cheap. noone can do all requirement with that budget.
$263 USD en 5 días
5,0 (1 comentario)
1,3
1,3
Avatar del usuario
I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$15 USD en 3 días
5,0 (4 comentarios)
1,1
1,1
Avatar del usuario
Building the cube->that's what I do for living. I can do that within 2-3 days if you allow me. Thanks
$222 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Your budget is very stiff. Please let me know if that can be extended any further. If you are ok i'll come back with a detailed proposal.
$54 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hello There, It would be great If I get a chance to work on this. As a BI I have extensive knowledge, I worked with Microsoft India, Hyderabad for Multidimensional Cube project. Thanking You.
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de GERMANY
Pöcking, Germany
5,0
1
Forma de pago verificada
Miembro desde jun 27, 2014

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.