LimeSurvey Reporting Solution “Data Analysis Layer” Development Approach

$30-250 USD

Imefungwa

Imechapishwa

about 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa

[A] LONG-TERM [Context of Reporting Solution] I am looking for a long-term reporting solution for our LimeSurvey driven assessments. LimeSurvey does not have the capabilities I need so a reporting solution that can work with LimeSurvey and work behind the scenes will be necessary. It will need to be seamless behind the scenes but interfacing with our LineSurvey front-end UIX. Currently we have the logic and report design working within MSExcel which imports a LimeSurvey CSV file (exported from the LimeSurvey admin interface. So I need to design this so that it is user-driven rather than the manual process that is in place today. You do not need to know LimeSurvey as I posses the understanding of all our assessments as well as the LimeSurvey data model. However here is what you need to know in order to be considered for this initial design approach: (1) MySQL [[login to view URL]] (2) R [[login to view URL]; [login to view URL](programming_language)] (3) VBA [[login to view URL]] (4) MS Excel (5) Server-side Scripting languages (Python, Perl, Java, Ruby…) ----------------------------------------------------------------------------------------------------------------- [B] DEVELOPMENT APPROACH [Requirements for this project] For this project I need you to review the current “MS Excel Report Generator” and determine if the formulas within this program are (1) salvageable or (2) whether they have to be redesigned so that they can be transferred over to R. If they have to be redesigned I will redesign them. Once we determine this part of the project then I need you to determine how we get to the next step. Currently LimeSurvey and it’s database (MySQL-PQI) are working fine for our needs. We would like to minimize any programming and/or connections directly to the LimeSurvey overall solution so we have designed a separate Database (MySQL-DSH) that includes all the necessary tables needed for the overall reporting solution (an it’s associated data) and we have created triggers to insert, update or delete the data from these tables. So the MySQL-DSH database should be the only database we need to connect to. *see attached document for full description of this section ----------------------------------------------------------------------------------------------------------------- [C] TO BE PROVIDED [Information necessary to determine an approach] *see attached document for full description of this section ----------------------------------------------------------------------------------------------------------------- [D] OUTCOME [What I need from you in order to move this forward] *see attached document for full description of this section ----------------------------------------------------------------------------------------------------------------- [E] OPPORTUNITY [Opportunity to be part of developing this solution] *see attached document for full description of this section ----------------------------------------------------------------------------------------------------------------- NOTE: There is no development necessary for this project just your research, expertise and design of an approach for developing this layer. Development will come after this along with a new bid on that development effort.

R Programming Language

Kitambulisho cha mradi: 19161639

Kuhusu mradi

7 mapendekezo

Mradi wa mbali

Inatumika 5 yrs ago

Unatafuta kupata pesa?

Barua pepe

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa

Pata malipo kwa kazi yako

Eleza pendekezo lako

Ni bure kujiandikisha na kutoa zabuni kwa kazi

7 wafanyakazi huru wana zabuni kwa wastani $328 USD kwa kazi hii

@MasterKym

Hello, I am a data analyst and R/Python programmer with good SQL/MySQL background. I have taken the time to read your project's description and I would like to address a few points in my proposal. Mainly, what you need here is to connect to your Mysql DSH upon the user's will and display the data, aka report it. So as long as you have the data stored in the database connecting to the database in R should be quite straight forward, but R might not be the best reporting tool out there, so it depends on what you want to report and how. I also would like to take a look at the Excel report generator. Thank you

$277 USD ndani ya siku 7

4.9

(11 hakiki)

4.5

@umg536

Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks . .

$155 USD ndani ya siku 3

5.0

(2 hakiki)

3.7

@thenuv

Hello! I am proficient in R programming and passionate in data visualization. I went through your document and the reference portal and could understand you are looking for a Dash board to be built with MS SQL for backend and R for analytical computing. We can migrate from Excel report generator to R based web application called R Shiny. All the questions in [B] can be addressed with R, which you have already thought about. I will be using packages (RMySQL, shiny, shinydashboard, ggplot, plotly, dplyr etc...). There is a Shiny server which is open source to host the app and we may need a VPS hosting. I have built R shinny apps for multiple projects. Previously have developed a reporting for Survey project for which input was in JSON and output in html/pdf using R Markdown. I can work on the coming up with design approach and further develop a user friendly interactive web app for your project (will bid latter for other work). We can discuss and take it forward. Regards, Thenappan.V

$250 USD ndani ya siku 3

5.0

(6 hakiki)

3.8

@Valuesolutions

Hello, I have read the details provided and i am positive i can provide quality work,please contact me to discuss more on the project deadline and some other few things

$150 USD ndani ya siku 3

4.8

(6 hakiki)

3.8

@aifisolutions

Firtsly we had an overview on your project description and the Project requirement attached. We have knowledge on R but have not worked much on it, We are experts in Python , Django , MySQL , Javascript, PHP , Web development and well versed with reporting requirements. We have exposure to Splunk Insgiht development for BI earlier. We Aifi Solutions Pvt Ltd based in Navi Mumbai , India and have 20 years of experience in Desktop/Web/Mobile application development. We provide our expert service in the following areas: • Artificial Intelligence • Automation Solutions • Analytics & statistics • Data Science • Machine Learning • Software development Technologies/Languages: Python, Django, C#, PHP, Mongodb, Mysql, MS Sql, Aws, Azure etc. We Delivered following projects based on Machine learning and Automation. 1. Security Lab project - creating a mimic of attack analyzing tools like OWASP and ZAP this includes UI ( PHP , Javascript) , Backend in Python and Django etc.. 2. BlockCert ( Block chain certificate issue) : Creating Cert-issuer, Cert-Verifier and Cert-Viewer UI & Backend development using Python, Flask , PHP. & Many More. We do possess a proficient in-house team working for us( Full-Time) having expertise in Python, PHP , ML, AI, Analytics and software development . We are capable to work on your project but at a cost . Lets further discuss on a quick chat.

$1,111 USD ndani ya siku 20