Find Jobs
Hire Freelancers

Create the fact table of a test database.

$10-30 USD

Lukket
Slået op over 1 år siden

$10-30 USD

Betales ved levering
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?
Projekt-ID: 35853075

Om projektet

14 forslag
Projekt på afstand
Aktiv 1 år siden

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme
Bliv betalt for dit arbejde
Oprids dit forslag
Det er gratis at skrive sig op og byde på jobs
14 freelancere byder i gennemsnit $34 USD på dette job
Brug Avatar.
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 på 7 dage
5,0 (4 anmeldelser)
4,5
4,5
Brug Avatar.
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 på 3 dage
4,9 (12 anmeldelser)
4,5
4,5
Brug Avatar.
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 på 4 dage
5,0 (20 anmeldelser)
4,3
4,3
Brug Avatar.
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 på 2 dage
4,5 (30 anmeldelser)
4,0
4,0
Brug Avatar.
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 på 1 dag
4,9 (11 anmeldelser)
3,1
3,1
Brug Avatar.
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 på 1 dag
4,9 (8 anmeldelser)
3,3
3,3
Brug Avatar.
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 på 1 dag
3,8 (1 bedømmelse)
2,0
2,0
Brug Avatar.
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 på 7 dage
4,9 (2 anmeldelser)
1,7
1,7
Brug Avatar.
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 på 1 dag
0,0 (0 anmeldelser)
0,9
0,9
Brug Avatar.
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 på 7 dage
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
⭐⭐ 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 på 1 dag
0,0 (0 anmeldelser)
0,0
0,0
Brug Avatar.
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 på 7 dage
0,0 (0 anmeldelser)
0,0
0,0

Om klienten

Flag for MEXICO
Cuauhtemoc, Mexico
5,0
1
Betalingsmetode verificeret
Medlem siden okt. 30, 2022

Klientverificering

Andre jobs fra denne klient

I need to improve my logo
$10-30 USD
Tak! Vi har sendt dig en e-mail med et link, så du kan modtage din kredit.
Noget gik galt, da vi forsøgte at sende din mail. Prøv venligst igen.
Registrerede brugere Oprettede jobs i alt
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Indlæser forhåndsvisning
Geolokalisering er tilladt.
Din session er udløbet, og du er blevet logget ud. Log venligst ind igen.