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. Click the My Network icon at the top of your LinkedIn homepage.
  2. Click Your connections on the left rail.
  3. Click Manage synced and imported contacts near the top right of the page.
  4. Under Advanced actions on the right rail, click Export contacts.
    • You may be prompted to sign into your account.
  5. Click Request Archive.
  6. You will receive an email to your Primary Email address which will include a link where you can download your list of connections.
  7. In the archive, there is a file titled connections.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