Skip to main content

How to create a comprehensive overview of job postings

Managing information about two or three job postings at your company is easy and can be done even in some simple tool or spreadsheet. However, as the number of postings, candidates and other information grows, it becomes increasingly difficult not to get lost in the data and maintain a clear overview. There are candidates with their names, addresses and positions they are applying for. There are also job postings with salaries and managers who want to hire people for those positions. Those pieces of information are related to each other and we will show you how to effectively manage and view them with Lumeer.
As Lumeer allows us to put similar data to collections, we will want to store information about candidates, job postings and company’s employees in separate collections. It’s the most intuitive way because candidates have similar attributes, e.g. name, address, phone number or the date they applied for a job at the company. On the other hand, postings have their names and salaries that are offered for them and hiring managers are employees of the company.



Let’s have a look at current situation - we want to see only candidates that applied after a certain date. That can be easily done by selecting Candidates collection and adding a filter to search box. Right now, we don’t need to see candidates’ contact information, so we hide those columns. We also sort rows by date of application, just by clicking on the column title.
There can be of course multiple candidates for one posting, and, on the other side, some of our candidates have a broad range of skills and have applied for multiple postings. We easily created links between Candidates and Postings collections and now we want to see linked records. Just after entering first characters, Lumeer gives us relevant suggestions.


After choosing one of suggested values, we now see data from both collections in one table. If there are more postings connected to one candidate, they are wrapped in one line, but we expanded Eric’s and can do the same with Graham’s by clicking on small green plus sign in top right corner of the cell.

Salaries in postings are in different currencies, but to make comparison simpler, we would like them to be in one currency. That can easily done, as Lumeer understands the meaning of the salary column, offers us a list of currencies we could use and recalculates values based on currency we’ve chosen.
Let’s also add information about hiring managers to our perspective. Postings collection is linked with Employees collection in similar way that Candidates is linked to Postings, and we gave the link a name Hiring Manager, because there can be also other links between those collection, but with different meaning (e.g. Interviewer link says which employees should be present at interview for the posting) and we want them to be easily understandable.



Now we would like to know what budget do our hiring managers need. With few clicks and without hard work, we reverse the link and add aggregation function. Of course, we can write our own function, but there are some commonly used and Lumeer suggests them to us to make the process quicker.



And that’s it! We gained so many insights with just a few clicks, because this is Lumeer’s goal – to allow you to work with your data intuitively and effectively. Of course, there is a lot more that Lumeer can accomplish, e.g. looking at your data from map or calendar perspective, displaying them as a nice pivot table or making sure that you contact every candidate on time.

Comments

Favorites

How to track tasks for employees?

When multiple employees work on multiple projects, even in a small company it can easily happen that you lose track of who is doing what and on which project. However, it is very important to have quick and easy access to this kind information: you want to know progress on a project to plan for the future release, or you want to see if employees have some spare capacity or are too overwhelmed by the workload. 
Maybe you feel that all that information is being lost in a pile of spreadsheets and emails. They are all there, but to access them means to spend precious minutes or even hours on searching the documents, every time. You wish to have everything in one place, with every question about current status or capacity answered within seconds and with just a few clicks. You want to easily make changes that are smoothly and automatically propagated to relevant people in the company. In this article, we will show you how to achieve this with Lumeer.
After we login into Lumeer, we create …

How to effectively search and publish townhall meeting's resolutions

In previous posts, we created invitation to a townhall meeting and added minutes and comments. The collections are now filled with data and we will show you how to search those data and easily export them into publishable form.

After every townhall meeting, the municipality has to publish the resolutions which were approved during the meeting. To achieve that, we first search for the data we need by using Lumeer’s search box. We adjust the filters, hit enter and immediately see all resolutions from particular meeting.

We see the result of the search in table perspective, but we switch it to smart document perspective and produce the list of resolutions in a similar way that we have created the invitation.



Of course, we can choose how we want to export the document. Do we want to print it? Then we use export to PDF. Do we want to publish it on municipality’s website? We can put the PDF there, or, even simpler, we just put there the link to document which points directly to Lumeer, where t…

How do you search for your data in company IS?

“I need to look up that information.” This situation comes countless number of times every day and it’s not something people are used to look forward to. Looking for a particular piece of information often becomes a stressful and time-consuming procedure with uncertain result. You need to go through a number of systems – e.g. email, wiki, document server and other sources which are independent and not connected in any way. What’s more, in every of these sources, you have to be very concrete about what and where are you going to search for. Even if the data is stored in a typical information system or a spreadsheet, you need to specify the table and only after that you can get to the right report and finally see the data in the context.

But what can you do in the case you are not so sure about what exactly you are looking for and where it is stored? How can you do it without spending precious time trying to work out all the details?

Lumeer provides a solution to all these problems with …