İETT – PASSGATE Success Story

Galata Transportation Carries Out Their Internal Communication Processes With Velocity!

Galata Transportation is the leading company in the sector that has been producing logistics solutions with more than 100 business partners and more than 200 employees in 5 continents since 1997.  With 25 years of experience in international transportation; innovative, dynamic, customer-oriented and people-oriented Galata Transportation has maximized employee and customer satisfaction by moving their office to the digital environment with Velocity. 

Listen to the privileges of Velocity Intranet from Galata Transportation.

How did Velocity Intranet affect the business processes of Human Resources and Corporate Communications departments? 

Velocity created the opportunity for all our employees to access information simultaneously during the pandemic. It has been a convenient channel for us to share information. At the same time, being able to documents anytime and anywhere made workflows practical. By feeding employees from a common source, people and units became independent from Human Resources in many processes. Gettings answers to one’s question became way more faster and having to reply for a request got way easier. In other words, everything had just one single address. This way, time losses caused by outdated information and documents in different channels have been prevented. 


Which processes were improved with Velocity Intranet?
 

It was a product we added to our company as one of our digitalization projects. Thanks to the fast installation and implementation in terms of project management experience, we saw that the teams working on the project gained the competence to identify the problem faster and take quick action based on this experience regarding the issues that may be encountered in similar projects later. We were able to find creative solutions to the changing and evolving needs of our company through Velocity. Thanks to the continuous access of our suggestion collection, CV suggestion, legal compliance and awareness trainings through this channel, it provided practicality and sustainability in our Total Quality Management processes.

How was the process of generalization across the organization and the company? 

We conducted our orientation trainings as an activity of “giving keys” to employees instead of one-sided information transfer in the classroom. We introduce Velocity to every newcomer. 

While introducing it, we define it as a key that develops through access to the company’s general information sources and the contributions they provide with their suggestions.

We would like to thank PEAKUP for introducing us to Velocity and always supporting us.

Gülşen Şengül- Human Resources Manager 

 

Abdi İbrahim Power BI Success Story

During the consultancy processes we carried out with Abdi İbrahim, we conducted various projects so that they can visualize the data they have and present it to their users accurately.

With our knowledge and experience in Power BI, we continue to support Abdi İbrahim with the right solution for their reporting needs.

Balparmak Office Training Success Story

We carried out our Microsoft Excel trainings with Balparmak to support the improvement of their employees and to make their work processes easier. We continue to support Balparmak in the trainings we provide with our knowledge and experience in Microsoft Office programs, both to increase the knowledge of their employees in their careers and to facilitate their business processes. Listen to the privileges of Microsoft Excel from Balparmak in our success story.

WHAT IS POWERAPPS?

WHAT IS POWERAPPS?
.

As each day goes by, new programs keep getting introduced for applications that will make our lives easier.

And one of those very programs is PowerApps itself, but what exactly is PowerApss?

 Let’s talk about what it is not first. I can say that you do not get to develop applications without any code at all -unlike how many people think. So it is not as easy as people make it to be.😊

At the end of the day, we are trying to learn something that has already been invented, not trying to invent something new, right?

So, like I said, it doesn’t go without writing any code. But what kind of code are we talking about here? As Microsoft suggests, we are talking about the possibility to develop applications with the low-code technology. 

I pay my respects to this definition and would like to explain it a little more.

With PowerApps, you can design mobile applications that meet your needs or those of your company. PowerApps runs in the Cloud, so you don’t need to install an app on your computer.

I hear you ask so what do you mean, I can run it anywhere and anytime?😊

The answer is yes, but you do need to have an Office365 account.

You don’t need to be a software developer to build applications in PowerApps, but of course it will be way easier if you already have some software knowledge.

With PowerApps, you can develop applications that can follow many of your needs such as Vehicle tracking application, Leave request, and Inventory Management.

You can customize these applications to run on Mobile devices or Tablets.

Whatever you do, try to keep what you plan to do in PowerApps simple, that is, the less screen design you prepare your programs with, the better. Power Apps can connect with other data sources, especially those that work on the Cloud, for example, we can say that SharePoint is the best friend of PowerApps because SharePoint also roams on the cloud like PowerApps… since both programs have no feet on the ground, they are very well connected 😊

Office365 continues to evolve rapidly, PowerApps too, of course.

Me? For those who think that I can’t do it, I’ve never made an application before, I don’t know anything about writing code, let’s end our article with Nelson Mandela’s beautiful words.

.

It always seems impossible until it’s done._ N.Mandela

INSERT AN IMAGE INTO AN EXCEL CELL WITH A FORMULA!

 INSERT AN IMAGE INTO An EXCEL CELL WITH A FORMULA! 

I want to react to this title with 4-year-old my son’s words: “oh come on, don’t exaggerate like this.” 😊

So, what does it exactly do? What do we use it for?

The IMAGE function has been designed to add an image into a cell from a URL.

Which file extensions does it support?

BMP, JPG/JPEG, GIF, TIFF,ICO,PNG are the extensions that it supports as of now.

Since it is brand new, I want to talk about it in detail:

The function has 5 parameters. Our regular readers here know this but for those with whom our paths have never crossed, I want to reiterate:

In a function, the parameters that with write in [] are optional. But those that are not written in square brackets must be written.

Now let’s go ahead and take a look at our formula:

=IMAGE(source, [alt_text], [sizing], [height], [width])

 SOURCE                  : URL path of the image file, using an “https” protocol
 ALT TEXT (Optional)    : Alternative text that describes the image
 SIZING (Optional)      : Defines the size.
 HEIGHT (Optional)          : Defines the height.
 WIDTH (Optional)         : Defines the width.

.

For example, if you write the formula down below into a cell in Excel,

=IMAGE(https://cdn.ablebits.com/_img-blog/image-function/items/water.jpg;Okyanus)

you will see a picture of an ocean.

Let’s say that you have a list consisting of Product Names, Stock Information and Prices. It wouldn’t be so bad to have the images of these products next to them using the IMAGE function, would it? 😊

A not-so-famous philosopher (That is no one but me😊) once said: “ Visualizing the data is just as important as preparing it.”

.

.