Power BI 12 Days of Dashboards – Day 2 – LinkedIn Connections


LinkedIn Power BI Dashboard

Day #2 – LinkedIn Connections Dashboard

As part of my Power BI 12 Days of Dashboards series, the 2nd day of dashboards brings you a glimpse into your LinkedIn Connections.

For the majority of the dashboards I build and share, my goal is to highlight the process to obtain the underlying data source and the interesting aspects of the data. From this perspective, the LinkedIn contact list is quite different since the exported data contains only a very small subset of the information included in our actual LinkedIn profiles. As an example, after years of working on multiple continents, I was hoping to use a mapping visual in Power BI to chart the locations of my connections throughout the world. However, this data is not included in the built-in export capability provided by LinkedIn, so we’ll focus on other aspects of the exported list.

Here is an example showing the top companies and job titles for my LinkedIn contacts. You can quickly build this with your own LinkedIn connection data by following the steps below.

 

 

The first step to creating this simple dashboard is to export your LinkedIn contact list from http://www.linkedin.com/.

  1. Navigate to http://www.linkedin.com/
  2. Click on My Network -> Connections on the top ribbon menu
  3. Click on the Settings icon in the top right
  4. Click on the link in the top right to “Export LinkedIn Connections”
  5. On the next screen, click on the export button to export to .csv. This is the .csv file that is used as the input for this Power BI Dashboard.

Next, download the Power BI Template from here and continue with the following steps:

  1. Download and open the attached LinkedInTemplate.pbit file and open it in Power BI Desktop
  2. A popup box appears asking for the full path of the .csv file downloads in the above steps. Provide the full path to the .csv file on your computer and click the “Load” button in the bottom right. (TIP: Make sure the .csv file is closed or you’ll hit an error here. If so, close the file and relaunch the Power BI template)

After working at Microsoft for over 15 years, it is no surprise to see that the majority of my contacts are Microsoft employees. However, it is also interesting to see the natural “corporate migration” to other companies, in this case Google, Facebook, Amazon, etc., considering nearly every one of these contacts was added while working at Microsoft.

Thanks,
Sam Lester (MSFT)

Comments (7)

  1. Jason Vogel says:

    Loving the Dashboards! If you want to take this one further, LinkedIn has an extensive extract option available that should provide a wealth of dashboard fodder! Visit this link: https://www.linkedin.com/settings/data-export-page

  2. Hi Sam,

    Is there any AI to detect company names like Microsoft, and Microsoft Corporation to Join them in one Company. “if they are the same company”,

    Thanks.
    Mohamed.

  3. Ray Fleming says:

    Thanks for this. I had a little fun with this, adding back the first names to the dataset, and found that amongst my contacts the first name “Chris” was common name for a CEO, and Dave’s were the most frequent managers.

  4. Sergio Mathias says:

    An error has occurred: “Expression.Error: The path ‘c:\users\sergio.mathias\downloads’ is not a folder path. A file path is expected”

    1. Hi Sergio, are you hitting this error when you supply the path in the template? If so, supply the full file path (including filename.csv). This should get you past the error.

      Thanks,
      Sam

  5. Mahima Bedi says:

    Is there an api we could connect to directly instead, so that we don have to keep downloading the csv for newer data.

    1. Hi Mahima, it looks like there are some LinkedIn APIs available, with more info found at https://developer.linkedin.com/. I didn’t look into what functionality is exposed through the API’s, but you might be able to leverage them for additional data/dashboards.

      Thanks,
      Sam

Skip to main content