Find Jobs
Hire Freelancers

Database management for business intelligence

$30-250 USD

Cerrado
Publicado hace casi 10 años

$30-250 USD

Pagado a la entrega
Connect Excel to a marketing database to produce a customized report that will show leads by sales person WTD, MTD and YTD
ID del proyecto: 5837793

Información sobre el proyecto

21 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
21 freelancers están ofertando un promedio de $131 USD por este trabajo
Avatar del usuario
Hi, I'm very interested helping you creating your database, I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database assignments. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please send me all other details if you have about your database, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$210 USD en 7 días
4,6 (32 comentarios)
5,4
5,4
Avatar del usuario
hey eadri, what is the database format ?
$66 USD en 3 días
4,9 (63 comentarios)
4,9
4,9
Avatar del usuario
Hello Eadri, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server Business Intelligence, i have more than 8 years in IT projects with 5 years working around Microsoft Excel database and VBA on several projects . My last job was senior BI consultant within Accenture ,for more than 4 years .I worked for several BI projects relating with Microsoft databases on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in MS Excel and Business intelligence tools to develop all types of requirements related ,and given my experience, i am persuaded to give you to give High quality of work delivery withing budget and time Best regards,
$89 USD en 1 día
5,0 (10 comentarios)
4,7
4,7
Avatar del usuario
Hi I have more than 10 years experience in database administration and data warehousing with Business Intelligence report. If you want to see some example I can provide you. thanks.
$100 USD en 3 días
4,9 (15 comentarios)
4,2
4,2
Avatar del usuario
Doing it with Excel isn't the best way but if that's what you want, we can do it. It would be better to connect with a .NET app so you can view it from anywhere, then copy-into-Excel if you need To, but we can do it this way if it works. I am American, live in NYC, have a BS and a day job; I need extra projects this month. I am free to talk on the phone as well anytime. I'm free tonight if you want to do it. Regards, Joe
$172 USD en 3 días
5,0 (2 comentarios)
3,3
3,3
Avatar del usuario
I have connected Excel ro SQL to produce report information that was automatically displayed on a TV display in a sales bullpen. I am confident I can produce the report desired. Cheers, Brent McCaw
$222 USD en 3 días
5,0 (2 comentarios)
3,3
3,3
Avatar del usuario
Hi Eadri, This type of functionality should be straight forward, the main issues will be amount of data within the database (if you have a big database, we would need to implement some stored procedures/views, it would be good practice to do this anyway). To complete this project I will need a few bit of information/pieces of data. 1) A desired report layout (if you have one, else it will be quite basic). 2) The type and version of the database the marketing system runs on. 3) A copy of the database and if possible documentation to explain what data is in which table (with some test/demo data, not live data). 4) Quantity of data expected to be reported on, this is so I know whether to do a straight Excel report or need to design some views/stored procedures. 5) What report filters (you've mentioned sales person, year) or are you just expecting it based on the date it's run. So you are aware, I'm a database developer, and I'm currently studying for my MCSE in Business Intelligence for SQL Server. If you have any questions, please don't hesitate to ask. Regards Chris Pugh
$80 USD en 5 días
5,0 (2 comentarios)
2,0
2,0
Avatar del usuario
Hi there, I can help you with this. I do this daily. Yes, we can put it in Excel for you, but since the data is already in Access, it would actually be easier to keep it there. The report writing in Access is better. The only reason to take it to Excel is if you have specific needs. but even calculations can be done in Access very nicely. Either way, i can help you and will do a proper job in decent time. Hoping to hear from you soon. Regards, Albert Barnes
$155 USD en 3 días
5,0 (1 comentario)
0,9
0,9
Avatar del usuario
Experienced Excel and database professional with 20 years in software industry providing solutions to business problems. What is the version of excel you have and also what database you have (oracle, sql server etc)
$100 USD en 1 día
5,0 (1 comentario)
0,8
0,8
Avatar del usuario
Hello, I have a strong academic field in database management, since I've been studying finance and banking. I worded as a Financial Analyst at the Ministery of Finance from Romania, and now I work at OTP Bank, but I thought about starting a freelance career. Since I am pretty new on this website, I offer you the chance to test me without any cost, and only hire me for this job after testing me. I assure you I am highly qualified for what you need. I am looking forward to hearing from you. Thank you!
$111 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, The idea of ​​the project clear to me. First, I should get the information that enables me to connect to your database or provides a copy of database to me. Second, I will establish the connection from Excel to your database. Then, I will design your requested report for weekly, monthly, and yearly sales, the reports could include tables report, pivotTable report, and PivotChart report, or combined many kinds of them. please contact me to discuss further details Skype: amabhouh mobile: +972592558880
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
My extensive knowledge in Excel, databases and experience of more than 6 years as database administrator will allow me to fulfill the objectives of this project. I am a MCP (Microsoft Certified Professional) 461 - Querying Microsoft SQL Server 2012. 462 - Administering Microsoft SQL Server 2012 Databases. I just need details about marketing database and the version of Excel, you provide me the requirements and I performed the task. Please contact me by email and we define the details.
$188 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Specialist IT Infrastructure Casablanca Morocco DBA senior Oracle (9i,10g,11g), Informix(IDS 9.40, IDS 11.50), SQLServer. Administrateur système sénior: IBM AIX, RHEL, Windows server Sauvegarde/Restauration: TSM5, TSM6, RMAN Administrateur VMWare infrastructure (ESXi5) Administrateur SAN et Baies de stockage (DS) Administrateur serveurs d'application: JBOSS, TOMCAT, Websphere, OAS Gestion de projets d'infrastructures et Datacenter Phone Number: +212665153993
$111 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I have developed hundreds of reports for sales representatives, showing their QTD and YTD sales and targets. I have generated and automated those reports, connecting to the database and pulled the required figures on excel and presenting the results in the form of beautiful dashboards. I am developing such reports for MNCs for two years now. Please provide me a chance to work with you and you will definitely be pleased with my work. Feel free to contact me in case you need any further information. Thanks, Bhushan
$60 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$55 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi i will integrate your data as you want.I have worked on SSIS and SSRS,I wont disappoint you. thank you
$166 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Expertise: - Monitoring the production environment ETL Jobs Cognos Data Manager - Responsible for performance improvements Cognos - Creating capabilty Cognos Planning environment. - Creation of Load Balance (Tunning) Cognos environment. - Organization and best practices publication (Cognos Connection) - Standards and best practices development (Cognos Framework Manager) - Best practices for development (Cognos Transformer) - Cognos SIM (Solutions Implementation Methodology) - Customization of the portal according to the visual identity of the Customer - Migrating Cognos 8.2 to Cognos 10 - Installation and configuration of Cognos Mobile - Responsible for Cognos production environment - Tools: DataManager, Transformer, ReportStudio, Inisght, Mobile
$155 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I understand you need to connect the excel worksheet to a database. This can be done using excel VBA. Will need the connections strings to the database and the type of database and i/p address etc. to connect to the database and then we can get the data onto the excel sheet and complete the work. Please message me in case you need any more details. Thanks Venkat
$100 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
0,0
0
Miembro desde abr 21, 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.