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
- Open the CV data input file in Microsoft Excel
- Populate the four worksheets based on your experiences, skills, education, and certifications that you have obtained
- 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
- Select “Excel Workbook” and find the CV data file that you have downloaded and click open. It will open a “Navigator” dialog box
- 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
- Rename those four queries accordingly as working experience, skills, education and certification L&D based on the worksheet name that it is connected to
- Add another query which is from the education worksheet of the CV Data Input file
- Remove other columns from the query except University and University logo columns
- Rename this query as “University”
- Add another query which is also from the education worksheet of the CV data input file
- Remove other columns from the query except University, subjects, skills learned columns
- Rename this query as “University subject”
- Add another query which is from the skills worksheet of the CV data input file
- Remove other columns except software and software logo columns
- Rename this query as “Software”
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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)]
- 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
- 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)
- 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
- Select “Specific” and enter the email address as shown below
- Click the “Apply” button
- Enter their email address and add a message saying that this is your interactive CV
- Click the “Send’ button
Publish your interactive Power BI workspace as a public website
- Open the interactive Power BI CV from your workspace
- Click “File” in the menu bar and click “Embed Report” > “Publish to web (public)”
- If your Power BI admin has not allowed you to create embed codes, you need to contact them.
- Review the dialog content and select the “Create embed code” button
- 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
- In the “Success” dialog box, you can preview how your interactive Power BI CV will look like. Select the size and default page.
- 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
- Open your workspace that the interactive Power BI CV resides in
- Select the settings gear icon
- Select “Manage embed codes”
- The embed codes for the interactive Power BI CV in the workspace will appear.
- 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
- Go to the “File” ribbon tab
- Find “Export”
- Click “Export to PDF”.
- It will export the interactive Power BI CV as a PDF and you can share it to the employer.
B. Power BI service
- Open your workspace that the interactive Power BI CV resides in
- Click the “Export” in the menu bar
- Click “PDF”
- 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:
- Find these three columns and click them
- Click on column Tools
- 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:
- Click on the LinkedIn or website icon under [Name]
- Go to format image and find “Action”
- 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.
