Business Reporting System + DB setup
Steps:
1. Imports all the data feed via XML/API.
5 - 50 inputs. XML / API schema will be provided. Important that you build this system so it can scale.
2. Store all aggregate feeds in mySQL Database. Database preference will be on AWS*
3. Once data is stored in database, then we require reporting software to query the database and display a number of fields.
Report will display
- Performance Variables: Impressions, Clicks, CTR, Spend, etc (additional fields will be provided)
- Arranged by: Account ID, Campaign Name, Campaign ID, etc (additional fields will be provided)
Additional Features:
- Flags: In the form of performance indicators, which can be set as good or bad (numeric input), campaign over/under-spending, either actual $ amount or % amount,
- sort by all and any variables (highest/lowest first), filter report by campaign, lifetime, dates, today/yesterday, custom etc,
- ability to export all reports to excel via csv.
Extra conditions:
- Delivery of software will include installation of software and database on Amazon Web Services. AWS account will be provided.
- All input feeds will be provided.
- An example excel (CVS) file of all the fields in the report will be provided. Reporting software must match this structure.
- Preference is to use PhalconPHP because we will be dealing with a lot of real-time data, and important to maximize number of queries per second both on the data coming into the database and the when querying the database to display the reports.
Any questions please ask.
Hi, I can help you on this. I will setup reporting system , DB and XML/Feed processing script as needed. It would be nice if you provide more details on the xml feed need to be read. Thanks
Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time.
I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No subcontractors.
see my recent work for the technical expertise along with reviews & feedback on my profile page.
Hello,
With 99% completion rate, 700 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :)
I look forward to your reply.
Thanks.
Kind Regards,
Rajesh Soni
Hi
I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce, Zen cart-Drupal I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
Dear sir,
I have just done similar job like your requirements.
I have ever done similar job like your requirements.
https://www.freelancer.com/projects/PHP-Website-Design/PHP-Assessment-Quiz-Site-with.html
There are data feed logic like your requirements.
It speaks for itself.
Please open chat to discuss further detail.
Sincerely,
An
I am an expert web developer with 8+ years of developing dynamic web applications and websites.
I have experience in PHP, MySQL, Ajax, Javascript etc.
You can see feedback against my profile they are always awesome.
I am able to understand and visualize what you are looking for.
Based on additional information you provided, I can understand that the project consist of following :
1) Import data from XML/API, there will be several such XML/APIs each having its own schema, so a solution needed that will be flexible to import such different XML/APIs.
2) Storing this imported data in our own database
3) Generating a logical view out of that data from database to help make business decisions?
I am highly interested in your project.
Greetings, Thank you for giving us a chance to bid on your project. We have looked at your project specs and we are confident that we can deliver you robust and reliable solution. We have successfully completed more then 250 websites in past few years. Please send a message on PMB and i will send you our portfolio so that you can see how many satisfied customers we have also and we can discuss the project in more detail. Thanks Addy
We've understood all your requirements pretty well. We'll develop this business reporting system as per your requirements-
1. Imports all the data feed via XML/API.
5 - 50 inputs. XML / API schema
2. Store all aggregate feeds in mySQL Database
3. Once data is stored in database, then we require reporting software to query the database and display a number of fields.
We're PHP specialist and have worked on lots of projects.
You can check our reputation here:
http://www.freelancer.com/u/marketingmindz.html
We're confident that you'd be getting ideas about our capabilities.
Looking forward to hearing from you soon.
Hi, I (Myself a senior PHP, ASP.NET programmer using C# and VB) have a team having experience of more than 10 years in developing web and mobile applications. I have a team of expert programmers who write robust and bug-free codes at the very first instance. After seeing our quality of work and the cooperation offered to you even after the work has been delivered to you, you’ll come to us again and again to avail our services. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I can achieve the results that you are asking for within your timeframe and budget. I am confident I can exceed your expectations and I would love to work on your project. Thanks, Priyanka
Hello i have gone through your proposal and got to know that you need to use the api pull the data dumb it int the database and generate a reporting tool which makes your life easy, yes we will surely help you regarding it, but i have some questions, can you spare some time so i can helpm you, waiting for your reply, regards.
If you want something reliable then I can help you.
I have a lot of experience with high capacity/high reliability data capture and reporting systems.
My previous experience with data reporting tools includes building a worldwide performance monitoring system which aggregated all the data into a single database to use for reporting. This was built before cloud computing was readily available.
Another project was a trading platform used by large network of private brokers. SInce the data had to used for reporting which would in turn be used to compensate brokers, it was necessary to ensure that both data capture and reporting were rock solid.
Regards,
Rob.
iSol Services is a professional freelance pioneer in IT consultancy services which develops and maintains niche softwares.
A team of 10+ professionals (having average experience of 7/8 years) are in the practice of taking care of every bit of SDLC (Software Development Life Cycle), starting from project's blueprint to its actualization. Each one is quite proficient and excellent at his/her job like flawless designing, integral application development, user training & application maintenance. Also, we are in the habit of providing Data flow Diagram & Software Requirement Specification along with the deliverables.
We have telephone, email as well as personal communication modes (like Skype) in which the communication is very effective so that we always will be in touch with you, this helps us interacting with the clients to make them comfortable in terms of service and quality and also allows us to update on the progress of the work in a regular interval.