How to do Free LinkedIn Connection Analytic with Power BI Desktop

Hi Friends,

Hi all, this is my first LinkedIn blog so I wanted to dedicate this to LinkedIn, That’s why I have blogged about this in LinkedIn too, Click here to see LinkedIn Post !

After exciting Power BI GA release every one of us want to get hands on easy, powerful yet free analytics, so thought of blogging about Power BI experience here!

clip_image029

In this article you are going to learn how easily you can use Power BI to analyze all your LinkedIn connection easily, fast and do some immediate action.

At the end of this post you will be able you will be able to analyze LinkedIn connection for free, on your own.

Note – All example I have mentioned here are dummy, I have shared nothing, but you all can spread this message to everyone, let’s make everyone Data Analytics Rich which is at no cost !

I am going to explain in this article in faster way, without getting into detail.

Faster way is for One who are Power user, who don’t have much time for going into to detail step and just wanted to analyze linked connection without reading more details

Let’s Start IT!

Follow following three steps blindly to analyze and get insight of your all LinkedIn Connection Analytics.

Step 1 – Download Power BI Desktop, It’s free and all installation details are on my blog here, or go to Microsoft website here to direct download!

Step 2 – Export your LinkedIn connection in CSV format.

If you know how to download all connection in CSV format, please move strait to step 3.

 

clip_image002clip_image004

Click on Connection and then click setting after that on Export LinkedIn Connection, as shown in below image –

This page will appeared, where you can Export and download all your LinkedIn connection in CSV format

clip_image006

Once clicking export, it will ask you Security Verification to verify you are not robot! Prove it , I think it’s also your eye test !

clip_image008

Done! You have downloaded all your connection, Conformed from following similar screen –

clip_image010

Don’t forget to locate your downloaded file and its address, For example, here is my file which can be seen from browser, but we need actual path in which folder it is downloaded

clip_image012

For example, file which I have downloaded is in location – C:\Users\Downloads\linkedin_connections_export_microsoft_outlook.csv

Please remember this address, most important in our LinkedIn Connection Analytics

clip_image014

And this file is your Source Data, I will prefer to move this in secure location so that I even if I will delete anything from Download folder I will have data in my dashboard, But again most important please remember address where you are storing/moving this CSV file.

Step 3 – Click here Download free Power BI file (.PBIX), which has existing dashboard and everything ready for your analytics.

This File contains three different page with different analytics such as for Job title analysis, Name analysis and Company Analysis.

When you will download Power BI file (.PBIX), open same on double clicking, First time you will see following screen, Just click on Edit Queries without doing anything here as shown in bellow image

clip_image029

clip_image016

Just click on Edit Query at top

clip_image018

Next image is nothing but what you will actually see in your Power BI Desktop, Also Click on Advance Editor as shown.

clip_image020

Don’t get scared with M language, You don’t have to do coding here, you just need replace one address, which is physical file path complete address of your downloaded LinkedIn File, CSV Export.

clip_image022

This text is nothing but sequential steps in M language.

Click ok and then once you will see table, just click on Close & Load

clip_image023

LinkedIn Connection dashboard is ready for you

clip_image025

What you can do in this LinkedIn Connection Dashboard

Actually sky is limit, but I will show in simple way how I have done my analysis

è Have filter and Job title you are interested in , As I am most interested in BI, SQL and DBA I have this in my filter

clip_image026

è Have pia chart whenever you want

clip_image027

è Following image is worth of explaining everything about this

clip_image029

You can add or remove filter as you want by just adding custom column.

Additionally you will also find two different page for Name and Company analysis.

Hope this helps!

Let me know if you have any question !

6 thoughts on “How to do Free LinkedIn Connection Analytic with Power BI Desktop

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: