Enrich PowerBI Data with Gender and Origin/Ethnicity from Personal Names
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
img
.gitignore
20180130_TheEUDirectory_names.txt
20180130_TheEUDirectory_names_larger.txt
LICENSE
NamSor-PowerBI-Template.pbix
NamSorAPIConnector.mproj
NamSorAPIConnector.pq
NamSorAPIConnector.query.pq
NamSorAPIConnector.sln
README.md
client_secret
deploy_local.bat

README.md

About NamSor PowerBI Connector

Power BI Desktop is a free, stand-alone application from Microsoft. You can download it from the Microsoft Power BI web site at https://powerbi.microsoft.com/. It has rich, easy-to-use analytic capabilities and makes it painless to bring in data from a variety of sources.

Enrich your PowerBI Data with Gender and Origin/Ethnicity : any table that has personal names can be enriched.

Check you this video tutorial on producing a cool dashboard on the gender gap in the Film Industry, from IMDB 5000 dataset in data.world :

NamSor PowerBI Connector Tutorial on YouTube

Installing the Connector

  1. Download and install the Power BI Desktop application, if you haven't done so already.
  2. Start Power BI Desktop and find the "File > Options > Preview Features" section in the program options. Under "Preview features", ensure that "Custom data connectors" is enabled.
  3. Create a "[My Documents]\Microsoft Power BI Desktop\Custom Connectors" directory. Note: In the April 2018 version of Power BI Desktop or later, this directory is "[My Documents]\Power BI Desktop\Custom Connectors" or "[Documents]\Power BI Desktop\Custom Connectors".
  4. Download the NamSor Custom Connector file NamSorAPIConnector.mez and place it in this directory. If Power BI Desktop is running, you'll need to exit the program and restart it for this new connector to be found.
  5. Download the NamSor Power BI template file NamSor-PowerBI-Template.pbix and open it in Power BI Desktop. This template includes sample NamSor reports and data relations. It relies on the Data Connector to load and refresh it's data.
  6. You'll be prompted for a NamSor API Key upon startup. You can get a NamSor API Key from your NamSor Account page (https://api.namsor.com/).
  7. Copy the NamSor API Key from your account page into Power BI Desktop and click save. Once you do that, Power BI Desktop will begin communicating with NamSor API to enrich your data model with Gender and Origin/Ethnicity data.
  8. If you run into a PQ error : Please rebuild this data combination, try Ignoring privacy level in File > Options and settings > Options and then Current File > Privacy.

Appending Gender to your data tables

Names can be genderized either one-by-one, or by pages of a few hundred names. Read the Wiki to get started.

This is a example of data visualization after appending gender to an Excel file.

GenderGap

Appending Origin / Ethnicity to your data tables

NamSor Origin or Diaspora API work in similar way to the Gender API.

Monitoring API Usage

The API usage can be monitored directly from PowerBI. There is an example dashboard in the provided template, NamSor-PowerBI-Template.pbix

Additional Links and Resources