Pls consider just to develop a plugin to access Moodle database data per course or student or period, to download or connect to Excel or Power Bi directly.
I already have been working with Power BI to inform my customers with some analítical data to assure completeness
We download activities data from a course, make some process in Excel, add information, load it to Power BI and publish the results.
Since you are already able to do this for your customers, what functionality would you be looking for in a plugin?
Elizabeth, we mainly provide online courses to enterprises.
Once a week we send a report to Human Resources department with information about the status of the training that includes:
The objective of this report is to get support from Human Resources to fulfill on time the training of each individual.
We actually proceed this way to get all the information for each course:
It would be great to just make one query, get all the information from all the courses/active students and directly connect it to Power BI (Big data analysis).
Actually Power Bi manages the concept of Content packs, software that can be developed to allow access (query) to external database information (Moodle), and this is the explicit solution I suggest.
In this way, every teacher, corporation, college or university can have live statistical data about each course or student.
Hope it helps the explanation. I also have prepared for you an example of the file I actually use to manage the data.
Best regards and if you need any more information, please let me know.
Carlos
(Edited by Elizabeth Dalton - original submission Thursday, March 2, 2017, 12:10 PM)
Carlos,
This is outside the scope of Project Inspire at present, though we do hope to support interoperability standards like xAPI in the future.
For your immediate needs, however, have you considered automating this process using the ad hoc queries plugin? See the contributed ad hoc queries page for examples that may help you. You can configure this to send a weekly email with your summary for n CSV, Excel, or Open Office format. If Power BI can accept emailed files, this could complete your process. If not, at least you will have reduced the manual steps to importing a single file.
I hope this helps. For further help in this area, you might want to post to the Learning Analytics and Reporting forum.
Elizabeth
Elizabeth,
Thanks for your suggestion to use the ad-hoc queries plugin. I have already installed.
Sorry if I misunderstand the main objetive of your project.
Anyway, thanks.
Best regards,
Carlos
Elizabeth, I was informed that the excel file I attached to the message had some personal information, so I kindly ask you to pls deleted it.
Thanks and best regards,
Carlos
Hi Carlos, I've deleted the file for you. I hope you will stay in touch with us about your needs. We may be able to support you better in future phases.
Elizabeth, thanks for you support.
I will be in touch and wish you the best with your project.
Carlos