Forum Discussion

Apen's avatar
Apen
New Member
1 year ago

Create LinkedIn Learning Dashboard using Power BI

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

Need Help

2 Replies

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    Apen  
    Can you please share LinkedIn Learning using the API link to have a closer look?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.