The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Everyone,
Can somebody help on how to do the cleaning of data from Linkedin Learning using API at Power BI?
I just need the below data to be shown in the report
1. Top learners - based on number of courses completed and highest number of hours viewed
2. Activation Ratio - how many learners per group activated their accounts
Hi @Apen
Pls try:
Connect to LinkedIn Learning API:
Ensure you have your Client ID and Client Secret from LinkedIn Learning.
Go to Get Data and select the LinkedIn Learning connector.
Enter your Client ID and Client Secret to connect.
Load the following tables:
1.For course completions and hours viewed.
2.For activation status.
Open Power Query Editor. After loading the data, click on Transform Data.
Filter and Clean Data:
Sort the Learner Activity Summary by the number of courses completed and total hours viewed.
Use the Group By feature to aggregate data by learner.
Activation Ratio:
From the Learner Summary, calculate the activation ratio by dividing the number of activated accounts by the total number of learners in each group.
Create Measures.
TopLearners =
CALCULATE(
COUNTROWS(LearnerActivity),
FILTER(LearnerActivity, LearnerActivity[CoursesCompleted] > 0)
)
ActivationRatio =
DIVIDE(
COUNTROWS(FILTER(LearnerSummary, LearnerSummary[Activated] = TRUE)),
COUNTROWS(LearnerSummary),
0
)
Create visual objects to present data.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Apen
Can you please share LinkedIn Learning using the API link to have a closer look?