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!
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.
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
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 !
Done! You have downloaded all your connection, Conformed from following similar screen –
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
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
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
Just click on Edit Query at top
Next image is nothing but what you will actually see in your Power BI Desktop, Also Click on Advance Editor as shown.
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.
This text is nothing but sequential steps in M language.
Click ok and then once you will see table, just click on Close & Load
LinkedIn Connection dashboard is ready for you
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
è Have pia chart whenever you want
è Following image is worth of explaining everything about this
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”
Very nice article…
Hi, yes my email is firstname.lastname@example.org.
Thanks David, I am glad it was helpful !
No file is still there, You can send me email i will send you back as attachment
Could not find the .PBIX on your one drive. Please can you share?
Extremely helpful. Thanks for sharing!