CONTACT US FOR A FREE DISCOVERY CALL

Insights

How to create your own interactive Power BI CV

One of our BI Consultants – Irene Christina, was inspired by seeing an interactive CV on a LinkedIn post created in Tableau. She wondered if she could create her own CV in Power BI where she could showcase her work experiences, skills, and her Power BI skills.

Irene created a data input file in Microsoft Excel, which this will be used for as the dataset for the interactive Power BI. There are four worksheets in the data input file which are working experience, skills, education, and certifications L&D.

Below is detailed information of each worksheet and how you can populate them.

Worksheet Name Columns Name Description Notes
Working Experience Start Date The date when you started working at the company This will be duplicate for the same organisation, role project.
End Date The date when you left working at the company. If you are currently working at the company, you can put it as “current”.

 

This will be duplicate for the same organisation, role project.

Year The year when you worked or currently work at the company This will be duplicate for the same organisation, role project.
Type The type of employment. You can put either Full-Time, Part-Time, Contract or Internship. This will be duplicate for the same organisation, role project.
Role The role or title of your job This will be duplicate for the same organisation, role project.
Company The company name that you worked or currently working This will be duplicate for the same organisation, role project.
Company Logo This will be the logo of the company.

 

You can copy the link of the company’s logo and paste it in the Company Logo column.

 

This will be duplicate for the same organisation, role project.

Industry This will be the industry type of the company This will be duplicate for the same organisation, role project.
Project The project name that you have worked on or currently working
Responsibility The responsibility that you have working in the company Please add each of the bullet point or each responsibility one row at a time
Skill The skill that you use to work on the project at the company
Software The software that you use (e.g. Power BI)
Performance Reviews Any reviews or feedbacks received from your colleagues or senior managers
Skills Software The software that you use If you add interpersonal skills in this worksheet, you can leave the Software as blank
Software Logo The logo of the software You can copy the link of the software logo and paste it in this Software Logo column.

 

If you add interpersonal skills in this worksheet, you can leave the Software Logo as blank

 

Skills This can be technical or interpersonal skills
Skills (Value) From 1-10, how do you rate your skill (e.g 10 –Very Advanced) If you use 100 as the maximum, you can rate from 1-100 based on your skill
Skills (Max) This will always be 10 as the maximum or 100 as the maximum
Education Year The year when learn the subjects at the University This will be duplicate for every subject that you learn at University
Degree The degree either Diploma, Bachelor, Master (e.g Bachelor of Information Technology) This will be duplicate for every subject that you learn at University
Major Major or specialisation of your degree This will be duplicate for every subject that you learn at University
University The University name This will be duplicates for every subjects that you learn at University
University Logo The logo of your University This will be duplicates for every subjects that you learn at University.

 

You can copy the link of the University logo and paste it in the column.

 

Subjects The subject name that you learned from your degree (e.g Introduction to Data Analytics) You can enter each subject in each row of the table
Skills Learned The skills that you learn through the subject (e.g R Programming Language) You can enter the skills that you learned in each row of the table
Software The software that you use (e.g R Studio)
Software Logo The logo of the software You can copy the link of the software logo and paste it in this Software Logo column.
Certifications L&D Date Issued The date when you received the certificate
Year The year when you received the certificate
Issuing Organisation The organisation that issued the certificate
Certification Name The certificate name (e.g Power BI Data Modelling with DAX)
Software The software name that you use when learning the skill (e.g Power BI)
Credential URL The certificate credential If the certificate that you received provides the credential URL, you can paste it in this column

Your step-by-step guide to creating an interactive CV in Power BI

A.    Update and Import the CV Data Input file to Power BI

  1. Open the CV data input file in Microsoft Excel
  2. Populate the four worksheets based on your experiences, skills, education, and certifications that you have obtained
  3. Once you have updated the CV data input file, connect the CV data input file to Power BI in the Power BI desktop by clicking “Get Data” in the home ribbon
  4. Select “Excel Workbook” and find the CV data file that you have downloaded and click open. It will open a “Navigator” dialog box
  5. Select the four worksheets which are working experience, skills, education, and certification L&D and click “Transform data”. It will direct you to the Power Query
  6. Rename those four queries accordingly as working experience, skills, education and certification L&D based on the worksheet name that it is connected to
  7. Add another query which is from the education worksheet of the CV Data Input file
  8. Remove other columns from the query except University and University logo columns
  9. Rename this query as “University”
  10. Add another query which is also from the education worksheet of the CV data input file
  11. Remove other columns from the query except University, subjects, skills learned columns
  12. Rename this query as “University subject”
  13. Add another query which is from the skills worksheet of the CV data input file
  14. Remove other columns except software and software logo columns
  15. Rename this query as “Software”
  16. Go to the home ribbon tab and click “close & apply” to upload all the queries created in the Power Query

 

B.    Create the data model

  1. As we do not have a date table,  create a date calculated table using DAX

Date = CALENDAR (“01/01/2010”, TODAY())

Note: The DAX code above is creating a list of dates from 1 January 2010 until today’s date. You can change the start date to 2016

  1. Create another column in this date calculated table called “Month” using DAX

Month = FORMAT(‘Date’[Date], “MMM”)

Note: The DAX code above is creating a list of Month (long month) using the date [Date] as the reference

  1. Create another column in this date calculated table called “Year” using DAX

Year = FORMAT(‘Date’[Date], “YYYY”)

Note: The DAX code above is creating a list of year using the date [Date] as the reference

  1. Create another “Year” calculated table using DAX

Year =

DISTINCT (

    SELECTCOLUMNS (

        CALENDAR ( DATE ( YEAR ( TODAY () ) – 11, 1, 1 ), TODAY () ),

        “Year”, YEAR ( [Date] )

    )

)

Note: This code will give us a list of year from 11 years back to today. You can change the -11 to -5 which will be from 5 years back, to today

  1. Once we have the date table, we can create the data model for this Interactive CV. Below are the tables’ connection and the data model

C.    Create DAX measures

  1. Date slicer

In the interactive Power BI CV has the date slicer. I have created a DAX which is used to filter the date slicer. Below is the DAX code:

Year Slicer = IF(SELECTEDVALUE(‘Year'[Year]) = SELECTEDVALUE(‘Working Experience'[Year]), 1)

Note: This DAX code is to check if the ‘Year’[Year] column is equal to the Year column in the Working Experience table. If it is “YES” or “TRUE”, it will show as 1. We drag this measure to the filter pane of the visual and filter the visual to only show Year Slicer that is 1

  1. Skill usage

Skill Usage = DIVIDE(SELECTEDVALUE(Skills[Skills (Value)]), SELECTEDVALUE(Skills[Skills (Max)]))

Note: This DAX code is to give percentages of our skill by dividing the skills[Skills Value] by skills[Skills (Max)]

  1. Performance

Performance = IF(ISBLANK(SELECTEDVALUE(‘Working Experience'[Performance Reviews])), “-“, SELECTEDVALUE(‘Working Experience'[Performance Reviews]))

Note: This DAX code is to show “-“ if there is no performance reviews captured in the CV data input file. Otherwise, it will show the performance review received from the colleagues or senior manager

 

D.   Share the interactive Power BI CV

There are three ways on how you can share your Interactive Power BI CV to your employer, either share them through a link or a PDF file

Share the interactive Power BI CV through a link

  1. You need to publish the interactive Power BI CV to the Power BI Service in your workspace

Note: You need a school or work account to open the app.powerbi.com (Power BI Service)

  1. Once you have opened the interactive Power BI CV in the Power BI Service, click the share button at the top of the menu bar and it will open a “Send Link” dialog bar
  2. Select “Specific” and enter the email address as shown below
  3. Click the “Apply” button
  4. Enter their email address and add a message saying that this is your interactive CV
  5. Click the “Send’ button

Publish your interactive Power BI workspace as a public website

  1. Open the interactive Power BI CV from your workspace
  2. Click “File” in the menu bar and click “Embed Report” > “Publish to web (public)”
  3. If your Power BI admin has not allowed you to create embed codes, you need to contact them.
  4. Review the dialog content and select the “Create embed code” button
  5. Review the warning as shown below and confirm that the data is okay to embed in a public website. If you are sure that you can share the interactive CV and there is no data-sensitivity, you can select the “Publish” button

  1. In the “Success” dialog box, you can preview how your interactive Power BI CV will look like. Select the size and default page.
  2. Copy the link that is shown in the “Success” dialog box to a website and share it to your employer or post it in your LinkedIn account

Note: To manage this embed codes, please follow the steps below

  1. Open your workspace that the interactive Power BI CV resides in
  2. Select the settings gear icon
  3. Select “Manage embed codes”
  4. The embed codes for the interactive Power BI CV in the workspace will appear.
  5. Note: You can either retrieve or delete the embed code

Download the interactive Power BI CV as PDF

 

You can download the interactive Power BI as PDF either from Power BI desktop or Power BI service

A. Power BI desktop

  1. Go to the “File” ribbon tab
  2. Find “Export”
  3. Click “Export to PDF”.
  4. It will export the interactive Power BI CV as a PDF and you can share it to the employer.

 

B. Power BI service

  1. Open your workspace that the interactive Power BI CV resides in
  2. Click the “Export” in the menu bar
  3. Click “PDF”
  4. It will export the interactive Power BI CV as a PDF

 

 

Additional notes:

Convert Company, Software, University logo as image URL

To convert those three columns as image URL, please follow the steps:

  1. Find these three columns and click them
  2. Click  on column Tools
  3. In the data category section, click on it and select “Image URL” as shown below

4.Those three columns will be converted as image when it is dragged to the dashboard

 

Add your LinkedIn and website URL

To add your LinkedIn and website URL, please follow the steps:

  1. Click on the LinkedIn or website icon under [Name]
  2. Go to format image and find “Action”
  3. Add your link under Web URL as shown below

 

When you click in the LinkedIn or website icon or image, it will direct you to the website stated in the Web URL

 

Below is a screenshot of how your interactive Power BI CV should look like!

You can download these files for Creating your Interactive CV with Power BI to help you get started!

 

 

Irene Inge Christina has extensive experience creating Power BI reports that help businesses understand their data and solve business problems. This experience includes creating automation flows that provides email notifications regarding data updates using Power Automate. Aside from this, Irene has successfully replicated Row Level Security in Power BI which displays organization hierarchies based on user credentials.

 

 

 

 

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Contact Us

Receive a FREE 30-minute consultation with one of our BI Consultants

Find Out