Find Jobs
Hire Freelancers

Create the fact table of a test database.

$10-30 USD

Închis
Data postării: peste 1 an în urmă

$10-30 USD

Plata la predare
I'm looking for someone to help me draw the fact table (with Pentaho or some other tool) from the following database: [login to view URL] This fact table will be used later for the implementation of the data warehouse. (You don't have to implement the data warehouse, just generate the fact table using star or snowflake.) The fact table must be designed so that the company can know how its sales are evolving over time and what type of demand is associated with each of the products. I also need help answering the following theoretical questions (no code or implementation needed). 1. Specifies the steps the company must follow to implement its data warehouse for the sales department. 2. As a business intelligence expert, what guidelines would you give the company to implement its business intelligence model? 3. In your opinion, should the company invest in qualified personnel for the process? 4. What tools do you recommend to the company to implement its business intelligence model?
ID-ul proiectului: 35853075

Despre proiect

14 propuneri
Proiect la distanță
Activ: 1 an în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
14 freelanceri plasează o ofertă medie de $34 USD pentru proiect
Avatarul utilizatorului
Create the fact table of a test database. Hello Josue A., I would like to grab this opportunity and will be dedicated to your work till you get 100% satisfied with the tasks. I have 10+ years of experience on SQL, MySQL, Pentaho, Database Administration, Data Warehousing. You can check out my freelancer portfolio section. I will also share my portfolio on further demand over a chat. Please come over chat and discuss your requirements in a detailed way. Thanks & Regards, Ali K.
$20 USD în 7 zile
5,0 (4 recenzii)
4,5
4,5
Avatarul utilizatorului
Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Expert in data engineering. I will be able to help you with the project. Please ping me offline to discuss further.
$100 USD în 3 zile
4,9 (12 recenzii)
4,5
4,5
Avatarul utilizatorului
Hi There, I have gone through your requirement and willing to help you in creation of fact table and answering theoretical questions. I have 15+ years of experience software architecture, Database and SQL programming . My experience makes me confident to assure you 100 percent accurate solution according to your requirement. ======My clients reviews are proof of my commitment and support ===== Looking forward to discuss details. Thanks for your time. Regards Saima
$30 USD în 4 zile
5,0 (20 recenzii)
4,3
4,3
Avatarul utilizatorului
SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
$60 USD în 2 zile
4,5 (30 recenzii)
4,0
4,0
Avatarul utilizatorului
Creating Facts and Dimensions is my everyday task for analysis and reporting.. I have total 12 plus years of experience especially in Development, DWH, ETL, SSIS, SSRS, SSAS, SQA, Database development & maintenance. • Very strong in Open Interfaces, SQL, PL/SQL, Stored procedures/packages, writing Test Scripts, Windows/Linux environment and both back-end database development and front-end development. Business Intelligence & ETL consultant with sound experience in end to end BI implementation. Sound experience in logical & physical modeling of semantic layer, reports and dashboard development in various BI tools like MicroStrategy, Microsoft Excel, Tableau, Power BI. My experience related to DWH of integratrating more than 300+ systems from multiple OLTPs like Oracle,SQL, MySql, DB2, CSV, excel,notepad... I have created my own SQL custom base CDC inform of procedure, SSIS packages and procedure to complete assigned task... Developed Powerful ETL Using PDI (Pentaho Data Integration). Good knowledge of Big Data Analytic s having worked and successfully delivered on Sentiment prediction of Social Data set. • Business Analysis and Requirement Gathering • Effort Estimation and Planning • Solution Design and Architecture • Logical and Physical Data Modeling (Semantic & Core) • Reports and Dashboard Design and Development • Advance Analytics and Big Data…
$30 USD în 1 zi
4,9 (11 recenzii)
3,1
3,1
Avatarul utilizatorului
I can Create the fact table of a test database. Let me know more about it I am a freelancer with having 6 years of experience. I've gone through your project. I have read your requirements completely and. I am very much sure that. I can do this with full of honesty and complete in very less time and in affordable prices and in a robust way give me a chance to do your work you will get best result and my skills are List of my skills is WordPress Development, WordPress Theme Development, WordPress Plugin Development, WordPress ecommerce websites, Woo commerce integration, WordPress plugin customisation, Core PHP website development, PHP MVC framework websites such as (Laravel, CakePHP, Zend, CodeIgniter).;m having the profound experience in Python, SQL, HTML5, CSS with SAAS framework, JavaScript, jQuery, node.js, react.js, solidity,smart Contract, Blockchain.
$30 USD în 1 zi
4,9 (8 recenzii)
3,3
3,3
Avatarul utilizatorului
No problem. I checked your detail seriously and understand what you want. I have good experiences for your requirement. I will start your work right now and you will get perfect result in short time. Let's connect in chat so that we can discuss this further. Thank you. Tyler
$20 USD în 1 zi
3,8 (1 recenzie)
2,0
2,0
Avatarul utilizatorului
Hello, I am interested in the project you are offering, and for that, let me offer you a project submission proposal to help you solve the problem you. Thank You. Best Regards, Indra Rachman Dewanto.
$25 USD în 7 zile
4,9 (2 recenzii)
1,7
1,7
Avatarul utilizatorului
Hello Client. Very glad to bid your project because my skills are matched in your project very well. I am very familiar with PHP, CSS, Bootstrap, jQuery, JavaScript, MYSQL and so on. As a senior Web Developer and Designer with over 7 years experiences, I have worked lots of jobs like this before. So I can complete your project in a short time perfectly and provide the best satisfaction to you through this project. I am pleasure if i might have a chance to talk with you via chat. I can start to work right now so please give me chance to serve for you. Thanks for reading my bid and giving your precious time.
$20 USD în 1 zi
0,0 (0 recenzii)
0,9
0,9
Avatarul utilizatorului
I can help you draw the fact table using Pentaho or another tool of your choice. I am well-versed in data modeling and have experience working with various data visualization tools. First, I will work with you to understand your specific requirements and the data in your database. I will then use this information to create a detailed data model that clearly defines the relationships between the different tables and the key data elements. Next, I will use Pentaho or another tool to create a fact table that brings together the key data elements from your database in a meaningful way. I will also ensure that the fact table is optimized for performance and can be easily queried for reporting and analysis. Finally, I will provide you with a detailed report on the fact table and how it relates to the rest of your database. Additionally, I will provide you with any necessary documentation and training on how to use the fact table for reporting and analysis. Please let me know if this proposal works for you and I would be happy to discuss further details.
$20 USD în 7 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
⭐⭐ Hello ⭐⭐ I have checked your project description carefully and I think that I can help you to complete this project 100% perfectly sure to satisfy your requirement. I have more than 7 years of experience in Mysql/ SQL Server/Access database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very good experience in Sql/t-sql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with erformance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. My code is going to be clean and neat with good understanding. I am willing to take a technical interview, technical test, or trial project, to verify myself. I'd like to have a brief chat, call to discuss further details about your project soon. Looking forward to working with you together on this project. Thanks!
$50 USD în 1 zi
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
I am a professional data engineer in a IT company with 6 years experience. I can do all kind of ETL work and build Pipelines for Data Transformation and Migration. I have working experience in multiple ETL Tools Like Pentaho,Talend,Alteryx,SSIS. I can write complex SQL Queries and Procedures. I can write Python Scripts by using Azure data Bricks. I can create SSIS Packages. I can build Azure Data Factory Pipelines. I have done multiple projects with multiple technologies.
$30 USD în 7 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul MEXICO
Cuauhtemoc, Mexico
5,0
1
Metoda de plată a fost confirmată
Membru din oct. 30, 2022

Verificarea clientului

Alte proiecte ale acestui client

I need to improve my logo
$10-30 USD
Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.