Power BI LMS Templates

[jdmsc88]

Hi

I am very new to using Power BI, I am keen to build some LMS analytics in Power BI. 

Would anyone be kind to sample templates or direct me to where I can find some to work with?

Many thanks.

[rodney_bowder]

Hi @jdmsc88 

Yes, ditto. I am also very keen to start working on a project to get Canvas Data into PowerBI but am struggling even to get to first base at the moment.

I have an admin role in Canvas (and a valid API key to access our data on the Canvas Data Portal) but am currently a novice with this type of work.

I've read through the below *community article relating to downloading the data (which is possible for me, but only by downloading one file at a time!)  but I just need some further guidance on how to correctly authenticate using the suggested scripts and then store and import into PowerBI (again, I'm trying to learn this as I go along).

*Beautifully concise article about getting our hands on the canvas data from Jame Jones [Artical link] (but even so, I'm still trying to work it out).

Would be great to collaborate with you if you wanted to figure out how to make use of Canvas Data and create some usable analytics.

I'm hoping some savvy/knowledgeable soul out there in the community can guide us through with concise download examples and templates for reporting.

Once again, please feel free to reach out to me if you want to collaborate and let's see if the community have an 'idiots guide' for me.

Many thanks for the initial post. Rod.

ps, there was a reply to a post I have read from @a1222679 with some example templates, but I'm not authorized to view the example content [Article link]

pps, I don't have a budget to use AWS, which is another suggestion I've seen

[nhumphries · Accepted solution]

Hi,

   We use Power BI to visualise our canvas data. Id be happy to share some of my experience

[NipaThakker]

Hello, I saw that you are using power BI. Can you share some of your experience. And also if you have some query, for starting point please do share. 

Thank you. 

[rodney_bowder]

@nhumphries Thats very kind of you to offer to share any insights you've learnt along the way.

I will contact you here through your community feed.

Best regards, Rod.

[JonahSharkey]

Hi there,

I'm also in the same boat with PowerBI. I'm as far as unpacked data via CLI, but actually convincing PowerBI to cooperate has been unsuccessful. I'm simply trying to show progress from pre and post quiz results.

Thank you for any help you're able to offer.

Best,

Jonah

[MikeBrinkman]

I'm just starting with Canvas Data with PowerBI as well. Any samples would be welcome!

[Tushal]

HI,

would you please help me out on how to connect powerbi with canvas data services we tried all the methods by the canvas team but their description is pretty vague and tried few things based on community thru which we were able to get the DIM & Fact files but we are unable to find the relations to connect the data.

Thanks & regards

[JagrutiD]

Hi @nhumphries 

Could you please share some ideas on how to go about it.

We tried connecting using the Data Service facility which helps in connecting SQS. But that were only the events and not the actual information of that event. 

The we explored another option - The CLI Data tool which helps in the canvas data export gives all the event details but we are not able to understand the data mapping. https://portal.inshosteddata.com/docs is not so helpful. 

Your help will mean a lot.

Thanks.

[asergay]

Hi I’d love to hear your experience. You can reach me at asergay@columbu.k12.oh.us.

Thanks!

[brian_mullins]

@nhumphries Please do!

[nhumphries]

Hi, we use a SQL database to store our Canvas Data. From that i have created a number of views. Then i connect the Power BI to these views. Below is an example of a report front page

[ScottTurnbull]

Hi all, sorry to open an old tread but we would also love to access the Canvas data to build Power BI reports. Can anyone help or point me in the right direction?

[nhumphries]

Hi, you can contact me via Teams nhumphries@belfastmet.ac.uk and I'd be happy to help