Things to pay attention to while working from home / Hürriyet

In Turkey most workers are following their work from home because of the pandemic, just like in the whole world. This obliged employers to switch to remote working on digital platforms and to adapt. So, what should we be careful about while working from home?

We had to quickly adapt to working from home with the corona virus pandemic. Companies who didn’t want to put people’s lives into danger but still had to keep doing their work started to sustain their work with different platforms. And this reminded us the “Digital Workplace” notion that we started to hear a lot. The way companies did their work changed with the sudden change to remote working. One of the most important topics during this process was making the communication between employees continuous and constant and to keep their motivation alive.  PEAKUP told about how right and efficient work will be on online systems with the Velocity and Microsoft Teams experiences and included recommendations about sharing files, video call, chat rooms and teleconference in their guide.

What features are we looking for the most while working from home?

PEAKUP COO Kadircan Toprakçı stated that first the most waited features on digital platforms should be detected and sorted those out like this: “An activity field where notifications are received and filtered, a chat room where files and images can be shared, accessing archived files easily, co-authoring on files with teammates at the same time, video call, sharing announcements and organizing meetings. What is need to do all these correctly is a good internet connection and a secure computer, tablet or phone. Tips and tricks start from right here.

Computer: If your personal computer is not protected well with a good system we recommend you to use your company computer. Using Wi-Fi or 4G/5G connections on a weakly protected computer might let you down. If you believe that your office computer is not safe enough either, it is better to contact the IT department right away. If not, all your company information might be accessed and your archived files might get damaged. The password security of company accounts you connect on your office computers is very important for your data. You need the keep you password security as high as possible, update as much as possible and avoid simple passwords.

Internet connection: The most unpleasant part of digital workplace is internet going down or slowing down in the middle of an important meeting. Increasing the upload quota of internet packages of people who need to share files a lot or video call might be a solution. Apart from that, it is possible to activate the “Personal Hotspot” feature of 4.5G internet access via mobile phones in case of a problem with WiFi networks. The safest way to access resources containing accounting, human resources and similar company data would be choosing the Virtual Desktop applications provided by the IT departments. You have to use VPN for the whole team to connect to the corporate network securely and for the network traffic to go through one tunnel.

Operating Systems: Always prefer to use the latest versions of operating systems and applications. The latest operating system will provide protection against cyber threats with new updates as well as being efficient with new features.

Archiving: You might need to access a file on your work computer or you might have deleted a necessary file while working from home. Your files need to be transportable anytime and anywhere while working remotely. You can securely store all your files with cloud storing solutions like OneDrive and take important actions like going back to previous versions or recovering a deleted item.

Common workplace: You could work with your colleagues while working at the office. But now while remote working, you cannot physically  be together if you need to get something done together. Applications like MS Teams help you out during this process. You can move all your office environment to a common workplace, co-author on documents and files with your colleagues, track a lot of actions that were in your daily routines like video call, chat, office documents through one single platform.

Security for the little ones: This one is especially for the workers with kids. To prevent your curios child deleting the files you are working on when you are on a break, you need to put a screen lock and a password. You can use the free Dynamic Lock feature that comes with Windows 10 at this point. Dynamic Lock you have synchronized with your phone will lock your computer the moment you get away from it.

Meetings: Meetings, activities and trainings have started to be cancelled with switching to online working. But meetings or trainings necessary for you workflow getting sidetracked might cause problems for your work. You can sustain your work program without any ado with video meetings and live activities on MS Teams. For example, you can join the meeting from your phone, tablet or computer, chat during the meeting and share a file or your screen.

Socializing with colleagues: This one is both for the workers and the employers. During this process where we are home all time and cannot socialize, it is important to increase the motivation of your workers with platforms that keep the intranet strong like MS Teams or Velocity, not just to keep doing your job. You can create groups where you can recommend movies and make video calls, and have some coffee together. You can make your communication sustainable and fun on digital platforms.

Microsoft Office 365 New Updates and Improvements

Microsoft Teams Update: Group chat up to 250 participants

As you know the maximum participant number was 100 on chat groups. Microsoft increases this number to 250 with the request from customers.

Tasks: Outlook Tasks, Planner and To do

The Planner app in Microsoft Teams is changing as the Tasks app! Tasks will enable you to manage personal tasks and tasks assigned to you in a team through one place by consolidating the Microsoft To-do, Planner and Outlook tasks and channels. It will unite the messy tasks all together and group them by importance and due date, and even present them in Teams as lists, pinboards and charts. We think that Teams accepting all application within itself is very exciting!

Teams Meetings Video Display is Now 3×3

Teams displaying maximum 4 participants on screen during the meeting was highly criticized compared to their rivals in teleconference. Microsoft has announced that for now this number is 9, and that they are trying to increase this number to display more participants at the same time.

Raise Hand in Teams Meetings!

The new Raise Hand feature in Microsoft Teams enables the participants to indicate that they want to speak by changing the hand icon on the control bar, this way facilitates participating to meeting more efficiently. Participant themselves  or the presenter can lower their hands. With this feature, we will indicate that we have a question without interrupting the person who is doing a presentation. Just like in a class. 😊

No More People Timelines in Stream

If the people detection feature is active on Microsoft Stream, it detects people’s faces automatically to improve the Microsoft Stream play experience. If the video owner has turned on people timeline for a video, this feature would be displayed for the video.

This feature will be removed because of low usage. It will be removed permanently by July 15.

You Can Add Videos to Your Forms

When you choose the checkbox below, you can add videos with YouTube URLs or images from Bing to you forms. This way, you can make your polls more lively and effective!

SharePoint Lists, or Formulas with Condition in Libraries:

Users can show or hide columns in library form or in a SharePoint list depending on the value on another column. You can choose between formulas and columns. For example, you can hide a column depending on the values on another column.

PowerPoint Live Presentations

The upcoming “Live Presentations for PowerPoint for web” feature will enable the people who give a presentation to see their slides and words, and even live translations on their device as transcript!

Microsoft Bookings is coming as an Office 365 Application!

Microsoft Bookings is a self-service meeting organization tool that enables you to organize corporate and non-corporate meetings. Microsoft Bookings app can be used as add-on for Office 365 Corporate E3 and Office 365 Corporate E5 users. Microsoft is turning Booking into an Office 365 app from an add-on in the last update. It is possible to activate or turn off Booking as an organization. User-based restrictions will be available in time.

Meeting Experience Improvements

  • Instant Channel Meetings Experience is Changing:

Users will see the “Meet Now” button next to the channel name, on top-right. This way this feature that gets to be ignored as an icon below will be understood more clearly.

  • Participating to the Meeting is Being Improved:

More clear options will be offered to the users while they are joining a Microsoft Teams meeting through a link concerning how/where they want to join the meeting.

We achieved being the first by getting the “Change Management Advanced Specialization””

We are the first corporation to get the Adoption & Change Management Advanced Specialization in the Middle East and Africa region (MEA) and the 4th worldwide with Change Management Services we give on services like Microsoft Teams, Azure, Office 365 in order to enable right integration of new generation work places and technology to workflow.

We added another one to our achievements, and with our knowledge and experience proved that we are the best in this matter by ranking first in MEA.

We help more than 700.000 end users migrate to cloud technologies and keep achieving even more every day while providing help for our partners to change to new processes with our expert staff in America, Europe, Middle East and Africa with our solutions.

We are proud to be the first one in MEA to have this specialization status that Microsoft gives to limited number of partners worldwide, and kindly thank everyone who supported and believed us during this period.

Auto-Incrementing Build Numbers in Xcode

There are a lot of non-code related hardships we come across while developing a software. One of them is the test. On which server will the Beta distribution be? How will be the CI-CD processes? Where will the code be stored? How will the technical information be distributed in the team? What is versioning? What is Build Number? Is it just the number that Apple Store  wants us to increment and that goes to 2.0 from 1.0 as the app is published? And many more questions come up in our minds.

One of the problems we come across while developing a software is versioning. We come across it frequently in our daily lives. Numbers like v1.4.3 or x.y.x must have caught our eyes in the menu of the software products, profile page, settings page, on the left or right… But, how and relative to what is done this so called versioning? What it is done relative to and how it is done depends on the position of the company in the industry, what it does and whatever the developer wants. There is not a fixed versioning technique in the world, that being said, the techniques used are very similar to each other. And the most commonly used one is semantic versioning. And we, as Peakup Labs mobile developers, use this type of versioning. You can learn the details of semantic versioning here.

What is a Build Number?

I will just go over the basic details. While developing a software product we usually don’t put forward the whole product at a time. We start, get something done and then send it to the user/tester/manager. The receiver checks it and gives feedback like “can we add this, can we change this, there is an error here” etc. We do it and resend it.

But how the person who we send it to will distinguish these 2 products? Well, here comes the build number into the play. If the second product’s number is 1.1, while the first product’s number is 1.0, it can easily be recognized that the second product came out later. For example , when someone is using the first product instead of the second product and talk about a bug we fixed in 1.1, we can tell them to download the 1.1 version and that we have fixed that bug there.

Both build numbers and version numbers are numbers used to identify a product.

These numbers for sure don’t just help to distinguish versions. Also, the builds that have the same version number are not published since AppleStore and Google Play Store don’t see them as an update. Build number and version number should be incremented in a certain way. Version number can be incremented manually. Because the system can’t know or determine the size of our update, who knows it is the developer himself/herself so it is more convenient for the developer to increment it manually. But you don’t need to increment the Build number manually all the time. As befits the name, it is a Build number. It is incremented in every Build. I think manually incrementing it is against the spirit of being a developer. It is contradictory to manually increment the build number all the time while trying to automatize the system and the app we are developing. 🙂

IOS Versioning System

And now let’s get down to the business. In this article I will talk about how we can automatize the build number or set it to git commit. iOS applications have 2 different types of version numbers like we mentioned above.

  • Short bundle version string CFBundleShortVersionString (e.g. 1.12)
  • Build Number CFBundleVersion (e.g. 190)

Each “Short version” contains more than one build. And each build corresponds to “Bundle Version.” Which means that while the build number is incremented in every build, the version number is incremented after a few builds. As you can see on the screenshot below, the version with the 1.4 version number contains two different builds of numbers of 34 and 35.

Now that we have talked about version and build number way too much, let’s talk about how to auto-increment the Build number without further ado. We can achieve this by using a very simple Shell script.

buildNumber=$(/usr/libexec/PlistBuddy -c "Print CFBundleVersion" "${PROJECT_DIR}/${INFOPLIST_FILE}")buildNumber=$(($buildNumber + 1))/usr/libexec/PlistBuddy -c "Set :CFBundleVersion $buildNumber" "${PROJECT_DIR}/${INFOPLIST_FILE}"

The script above takes the build number in the plist file, increments it 1 and rewrites it to the plist file by using the PlistBuddy feature of XCode.

  • ${PROJECT_DIR} :  Full path of the main project
  • ${INFOPLIST_FILE}:  Full path of the info.plist file

Auto-Incrementing the Build Number in XCode

It’s all well but how do we do this in XCode? First of all, this article is written with the XCode 11.4 version. If in new versions of XCode something changes, the article will be updated. If it not updated, it is enough for you to reach out to us and it will be updated immediately. As long as you follow our instructions step by step, you can auto-increment the Build number.

    1. Choose the Application Target field, and then the Build Phases tab.
    2. Click the + button above to add a new Script.
    3. Choose New Run Script Phase in the new tab
    4. When the new Script screen is open, write the script piece we see in the screenshot below. By the way, you can change the name of the script. Naming… Boy, do I love it!
    5. When you build the project your Build number will automatically increment.

As well as this method of incrementing the Build number is, I just can’t get myself to like it. 🙄

I hear you guys saying “For God’s sake dude, did you just write this for nothing, and did I read this for nothing so far, how would you like us to increment the build number your majesty?” This method is not the best practice when it comes to incrementing the Build number. So, what is the best practice concerning this?

It is, of course, to connect the Build number to the Git commit number.

How Can I Connect the Build Number to the Git Commit Number

If you connect the build number to the git commit number, the build not will go high to the sky. And it is guaranteed to always be more than the previous version just like Apple Store and our colleagues want. Incrementing this number in every build can cause this number to be too high in time. Well, does it harm anything when it is too high? Nope. I connect it to the git commit number just because I want to 🙂

https://gist.github.com/alparslandev/51ad5bc0192ad4d52ffcac02d5e3b541

I wrote the necessary script in the gist I shared above. As you can see it is possible to increment the Build number depending on the commit number. You can write the script in gist to the space I showed on the 4th step like I said above.

Click here for our other articles about iOS Developemnt
Click here for our articles on Android and Kotlin.

Alex is a good software developer. He likes to improve himself and learn new things. He is not one of those who learn the build number when the app is to be published on Apple Store. He had already learned the value of versioning and build number a long time ago. Alex is not one of those who say “oh dear the build number stayed as 1.0, let me make it 2.0” when he can’t send an update to Apple Store. Alex automatizes the build number and pays good attention to the versioning number.

Version notes are very important for Alex. He always writes comprehensible and well-liked version notes. Even if he is writing a very small application, he builds the versioning system well and increments it. A good beginning makes a good ending in the end, right? Alex knows that if he says “Ah, never mind!” even once, it bodes no good.

Be like Alex. Work hard.

Resources

https://developer.apple.com/library/archive/technotes/tn2420/_index.htmlhttps://crunchybagel.com/auto-incrementing-build-numbers-in-xcode/https://www.mokacoding.com/blog/automatic-xcode-versioning-with-git/https://fuller.li/posts/versioning-with-xcode-and-git/

PEAKUP Working from Home Guide / ICT Media

PEAKUP WORKING FROM HOME GUIDE HAS BEEN RELEASED!

In Turkey most workers are following their work from home because of the pandemic, just like in the whole world. This obliged employers to switch to remote working on digital platforms and to adapt. PEAKUP has prepared a guide for both people who work from home and the employers. Here are some interesting points of the guide…

The Importance of Digital Workplace notion has increased

We had to quickly adapt to working from home with the corona virus pandemic. Companies who didn’t want to put people’s lives into danger but still had to keep doing their work started to sustain their work with different platforms. And this reminded us the “Digital Workplace” notion that we started to hear a lot. The way companies did their work changed with the sudden change to remote working. One of the most important topics during this process was making the communication between employees continuous and constant and to keep their motivation alive.  PEAKUP told about how right and efficient work will be on online systems with the Velocity and Microsoft Teams experiences and included recommendations about sharing files, video call, chat rooms and teleconference in their guide.

What features are we looking for the most while working from home?

PEAKUP COO Kadircan Toprakçı stated that first the most waited features on digital platforms should be detected and sorted those out like this: “An activity field where notifications are received and filtered, a chat room where files and images can be shared, accessing archived files easily, co-authoring on files with teammates at the same time, video call, sharing announcements and organizing meetings. What is need to do all these correctly is a good internet connection and a secure computer, tablet or phone. Tips and tricks start from right here.

Computer: If your personal computer is not protected well with a good system we recommend you to use your company computer. Using Wi-Fi or 4G/5G connections on a weakly protected computer might let you down. If you believe that your office computer is not safe enough either, it is better to contact the IT department right away. If not, all your company information might be accessed and your archived files might get damaged. The password security of company accounts you connect on your office computers is very important for your data. You need the keep you password security as high as possible, update as much as possible and avoid simple passwords.

Internet connection: The most unpleasant part of digital workplace is internet going down or slowing down in the middle of an important meeting. Increasing the upload quota of internet packages of people who need to share files a lot or video call might be a solution. Apart from that, it is possible to activate the “Personal Hotspot” feature of 4.5G internet access via mobile phones in case of a problem with WiFi networks. The safest way to access resources containing accounting, human resources and similar company data would be choosing the Virtual Desktop applications provided by the IT departments. You have to use VPN for the whole team to connect to the corporate network securely and for the network traffic to go through one tunnel.

Operating Systems: Always prefer to use the latest versions of operating systems and applications. The latest operating system will provide protection against cyber threats with new updates as well as being efficient with new features.

Archiving: You might need to access a file on your work computer or you might have deleted a necessary file while working from home. Your files need to be transportable anytime and anywhere while working remotely. You can securely store all your files with cloud storing solutions like OneDrive and take important actions like going back to previous versions or recovering a deleted item.

Common workplace: You could work with your colleagues while working at the office. But now while remote working, you cannot physically  be together if you need to get something done together. Applications like MS Teams help you out during this process. You can move all your office environment to a common workplace, co-author on documents and files with your colleagues, track a lot of actions that were in your daily routines like video call, chat, office documents through one single platform.

Security for the little ones: This one is especially for the workers with kids. To prevent your curios child deleting the files you are working on when you are on a break, you need to put a screen lock and a password. You can use the free Dynamic Lock feature that comes with Windows 10 at this point. Dynamic Lock you have synchronized with your phone will lock your computer the moment you get away from it.

Meetings: Meetings, activities and trainings have started to be cancelled with switching to online working. But meetings or trainings necessary for you workflow getting sidetracked might cause problems for your work. You can sustain your work program without any ado with video meetings and live activities on MS Teams. For example, you can join the meeting from your phone, tablet or computer, chat during the meeting and share a file or your screen.

Socializing with colleagues: This one is both for the workers and the employers. During this process where we are home all time and cannot socialize, it is important to increase the motivation of your workers with platforms that keep the intranet strong like MS Teams or Velocity, not just to keep doing your job. You can create groups where you can recommend movies and make video calls, and have some coffee together. You can make your communication sustainable and fun on digital platforms.

Free Distance Learning: The guide doesn’t end with all this. PEAKUP offers free remote lectures for everyone to facilitate remote working where we learn something new everyday and come across a lot of problems and questions. PEAKUP offers “Working from Home Practices” training every Tuesday, Wednesday and Thursday and is open to new education content. You can ask questions to the lecturers during the lectures and get support by sharing your screen.

You can follow the trainings here.

‘Malls will become digital life centers’

One of the things that have the share of everything digitalizing rapidly after the pandemic is the malls, the vital point of the retail economy. According to PEAKUP COO KadirCan Toprakçı, the malls around the world will become technology bases where artificial intelligent is used and that give contactless services. And shop-lovers will be like Sims players. Even though the change in malls remind us of sci-fi movies, it is pretty soon for these movies to become reality.

Malls, a must of shopping and the representer of socializing, where the retail economy revolves have gone through a lot of changes after the pandemic. We entered a new era where in the entrance our temperature is taken, where we have to walk on lines and cannot get out of circled areas, where we are kind of guided like robots. Technology, the definer of our life standards in the new normal, have taken the leading role in malls and introduced us to a lot of new things we didn’t see much before. PEAKPUP COO KadirCan Toprakçı believes that we are just in the beginning of the road. Malls that will concentrate on technological investments will become advanced space stations soon. Here is what we will see in the future Malls…

Contactless Malls

Today, online and offline shopping go together. In the future, this will leave its place to online shopping only. Online usage that will develop with the zero contact concern will be with us from the enter to the exit of the mall. We will see the condition of the mall on all our smart devices with artificial intelligence and virtual reality based developments, and manage and guide ourselves in the mall like an avatar.

Malls will be managed with separated sections

The quality of air we breathe indoors have a great importance. It is vital to sterilize the air inside in order to make malls go back to their old days the safest way possible. Thanks to the artificial intelligence to be used in malls, the quality of air density of each point, air temperature and other changes will be analyzed momentously. There will be an automatic management system to optimize the environment by keeping track of the density of harmful gases in the air and airflow. This system will be managed by the authorities on their cell phones and also the warning and guidance systems for alarming areas will step in with just one button. It will be possible to quarantine the risky zone in the mall and to stop the contact with the other zone automatically.

Video processing technologies will go into the pocket

It is possible to take people’s temperature contactless with video processing technologies. But in this new age, it will be possible to send the body temperature information to registered phones of clients and store authorities with facial recognition systems. But this system that is very beneficial concerning taking precautions fast and minimizing the interaction will be used when social distance is not applied. System will activate the alarms in case of suppressing the limit by counting people inside the defined zone. Shift systems and entries-exists will be controlled with video technologies and will be sent to the employees’ phone by being managed by the artificial intelligence.

Robot security staff, hologram store workers

Images taken by the security camera will be analyzed with smart software, risky situations among the images will be send to authorities in the remote monitoring center, it will be possible to interfere threatening situations with drones or robot security guard will accompany the suspect. Stores in the malls that want to give service 24/7 will be represented with hologram sales personnel.

Our temperature will be taken when we are washing our hands 

Shared areas in malls like bathrooms, praying rooms and cinema saloons have higher risk compared to the other areas. With technology, it is possible to eliminate contact completely from door handles to light switches, from taps to all other contacted areas. It will be possible to track the crowdedness in the bathroom, last cleaning date and clean air. Smart mirrors will take the temperature of the person washing their hands.

Physical stores will stand up with integrated systems

Stores will stop physical contact thanks to payment technology without a cashier and virtual fitting rooms, and augmented reality supported mirrors. This shows that physical stores will be facing different experiences. There will be a lot of cameras strengthened with artificial intelligence, it will be possible to track what clients have taken from she shelves with the artificial intelligence system, money will be taken from the registered credit cards automatically as they exit the store. Since physical stores will be preferred just to touch, look, choose and compare the products; brands will be in a race concerning service.

Attention, you might become a Sims player

PEAKUP COO KadirCan Toprakçı who said “In this new order, shop-lovers feel like Sims players” stated that these changes will take place in Turkey soon. Toprakçı told that they are producing new solutions concerning this with the Nova IoT Platform as Peakup and that there are still a lot of projects on which their R & D department is working on and that they are developing artificial intelligence programs for a lot of places from malls to offices, houses and even shelters.

MAKE WORKING FROM HOME FUN

Some People Like Working from Home

People who like working from home cannot imagine anything better than a day with their laptop any comfy clothes. Some workers might miss being at the office, their colleagues and chatting with them. Doesn’t matter if we like it or not, it seems like we will need to work remotely for a little longer because of the pandemic.

There a lot of recommendations about how to be productive and keep sane while working from home like “take a shower, don’t spend too much time on social media, if you have a pet walk it, don’t skip your lunch time.” So we compiled a few articles for you about how to create the workplace that will make working from home a fun and sustainable experience and how we can create a routine. Let’s be honest, we all have missed our office a lot.

Create a Sensory View

It has been proved that people who work in areas enriched with art, plants and more sensory stimulation work more efficiently. The minimum example we can give about this can be a family photo on your desk or pinboard. For this reason, to create a more sensory work environment for yourself, you can open some nature sounds if it is noisy around, adjust the temperature as you want, choose a shiny mug for your morning coffee, have an essential oil on your desk to keep one of your senses under control and make your environment green with plants. This way, you will eliminate the feelings that are unpleasant to you.

Take Good Care of Your Body 

Even though it sounds simple, working from home makes it easy to forget the basic needs of our body. When we don’t take regular breaks for our brain and body, it affects our health negatively. Yes, you probably had an ergonomic desk and chair at your office. One of your advantages being home rather than office is changing your position often. You can change to a sofa while sitting on a chair or sit on your yoga mat. Testing different positions will help you to find physical comfort faster.

Another thing to pay attention to is movement. You used public transportation while going to work and used to walk between 8.000-10.000 steps a day when you were going between meetings or even just for a coffee break. But now you can work out with your family and dance with your children for the time you spent going to work and coming from work. It would be fun.

Specify Stimulators to Start Working

It has been detected that during this pandemic, a lot of workers’ sleep schedules have been messed up and that they have a hard time adapting. So, specify some stimulators to work.  Things that have become a ritual while starting your day at the office like a cup of hot tea or a song that stimulates your senses will put you into action. One of the key parts is isolating yourself to keep focused after you take action. If you are a parent and your children are not going to follow these rules, you can ask for help from other individuals at home that remind us that life is mutual.

Don’t Forget to Socialize

While we were at work, we saw our families for a short time and now we get to spend really short time with our colleagues. Although we chat online during the day with online programs, we cannot do any activities together. For that, specify some time you can spend as happy hour. As an example to this, we as PEAKUP, keep doing our FridayTalks activity online which takes place every Friday at the end of our shift. We, as all workers, come together on Microsoft Teams with interesting, fun and informative topics. Of course we don’t forget about moving and work out together.

Keep your patience and motivation and don’t stop dreaming about the days we’ll come together, have a safe and healthy day at home.

Duo that Opens the Doors of Future: Data and Algorithm

The Duo that Opens the Doors of the Future: Data and Algorithm

British economist Ronald Coase say: “If your torture the data long enough, it will confess.” And the way of ‘torturing’ the data goes through algorithms. As long as you don’t know how to use and what actions to take, data is condemned to stay as a value you keep under your hand and don’t use. And the algorithm that defines the action is the place under which the real value lies.

“WE WILL ACHIEVE A DATA SIZE OF 143 ZB IN 2024”

Peakup COO Kadircan Toprakçı stated:” In the projection of 10 years, parallel to ever-increasing data size and complexity of problems to be analyzed; the value of human resources with experience about statistics, data-science, machine learning expertise and deep learning will keep increasing. We can say that genetic algorithms, election forecasting algorithms, financial recommendation algorithms and early diagnosis in health algorithms are trends worth being worked on alongside with the algorithms like convolutional neural network.”

Power BI DAX Functions: the FILTER function

Hello dear reader! In this article we will be analyzing a Power BI DAX Function, the FILTER function. It is one of the most frequently used ones. In our previous articles we talked about most frequently used basic functions like this one. You can read the details here.

Let’s talk about the data set we will be using first. The data set that we will import from kaggle.com again contains top 50 songs on Spotify and their details. You can download it here.

The FILTER function allows us to create datasets filtered by the criteria we desire. It gives a table as a result of the function. Therefore it is among the table functions. If we are going to use the FILTER function only, if we are not going to use it in any other function, we have to use it with the New Table command. The syntax of the FILTER function goes like that:

=FILTER( , )

Both of these parameters have to be written, or the function will fail. If we are to explain the filtering a bit more, we can put it like this: True or false statements should be obtained as a result by using mathematical signs like <“, “>”, “=”, “<>”. You can use logical operators (And & Or) for more a complex filtering.

Let’s start with transferring this data set to Power BI. For this we will go Home > Get Data > Text/CSV.  To get the .csv file you click OK and it will recognize the separator between texts and show the version divided into columns in the Navigation window. We go Load here and make it load to Power BI.

We will create 2 new tables with the FILTER function in this data set. For this we click on the New Table command under the Modelling tab.

1-Filtering by Numbers

Out first table is going to be of those songs we just want to dance to! The column that will enable us to run this query is the Dancebility column. We will list the values over 80 on this column. To write this filtering statement we will be using the “>” mathematical operator. Since we will be filtering rows on a column, it is going to be enough for us to write the name of that column. The syntax we will write goes like this:

Dance over 80 = FILTER(top50, top50[Danceability]>80)

2-Filtering by Text

Our second table is going to be listing the Pop songs. For this we will be using the Genre column.

Pop_Songs = FILTER(top50,top50[Genre]="pop")

So we filtered by both text and number. If you paid attention, we didn’t put the numbers in double-quote. Double-quote is used for texts only. And never forget that:

Two single quotes don’t make a double-quote!

I mean apostrophe by single quote. Sometimes some people try to do the action by using two apostrophes. Since this statements has a different meaning in computer language, even though it looks write you will face an error as the result of the function. So I recommend you to always be careful about this.

We came to the part where we move the new tables we obtained from these actions to the report. I moved the columns we filtered first, and then put the non-filtered array to the left. You can get the file here if you want.

spotify top 50 report

We analyzed the the Filter Function which is a Power BI DAX Function. We will keep analyzing other functions, various issues, dead-ends, and possibilities in other articles. Take care!

Good game well played.

Power BI – 2020 April Favorites

Hello dear reader! We will be talking about Power BI April updates in this post. They expressed these month’s updates by saying “There are a ton of new features”. But now everything will come to the light! I compiled everything below to give you an idea about this.

Personalize Visuals (Preview)

It has been forever since they talked about this feature, they told that it was coming. Turns out that the month in which this feature is presented to the users is this month. We are facing a different feature. Normally the process while creating a report goes like that: Report designer creates the report, certain people that will use it share their ideas, charts, their places etc. get readjusted accordingly and report is opened to the users. Of course after all this process there are people saying “This chart would be better that way,” “I don’t understand anything from this chart, can we change it to a bar chart?” And right at this point this feature steps in running with the hare and hunting with the hounds and says “Well you change it the way you want dear” to those who are not happy with the chart.

Of course for this, this feature has to be activated in report settings in app.powerbi.com. You can also activate it on the power bi desktop application. And as a chart all the ones that the report contained while preparing come as an option. The more interest you don’t just change the chart, you also get to change the fields added to the chart. Thus at the end of the day, users of this report might see something completely different than the report you created in the first place. I think that it will become a need for the report designers to know who used this feature and made changes in the future.

Relative Time Filter

We usually use year and month for filtering in Power BI, and prefer charts for day-based view. Sometimes we want to use filter slogans that we are use in the spoken language: “Last month”, “Last 3 months”, “Next 1 week” etc. These filters are called relative filters. With the update this month, Relative Time filter comes in addition to all these filters. With this we can add hour, minute filters.

relative time filter

Rectangular lasso select across visuals

We have been waiting for such a long time! Where have you been, where?! :'( We shed a lot of tears while creating reports, but finally it is here. Being able to drag everything with mouse on PowerPoint and not being able to choose here… it did offend me I’ll be honest. Pardon my excitement. Now we can choose by pressing control on Power BI Desktop as well. In my opinion this is the best Power BI April update. 😁

rectangular lasso select

Improved discoverability for conditional formatting

You remember how we were looking for visual titles and colors as if we were looking for happiness? They decided to make them visible and put them right next to the related area. That’s it for this feature. 😊

conditional formatting

Conditional formatting for totals and subtotals in table and matrix

Let’s be honest, we do apply conditional formatting and we are pretty fond of it. On the other hand, every single time we would ask questions like: “Why can we not apply it in totals?” We welcome this highly-voted feature this month. If we want, we can apply it to values and totals together or just to totals. Excellent!

Suggest Questions to Q&A

I wrote about the Q&A title in details in this article about updates. In addition to this, they are adding a new feature to the Q&A visual. Now we can suggest questions. We define some recommend titles for the report users when we put a Q&A field to the report.

Measure conditions in Q&A

In the first version of Teach Q&A, we could only use columns. Now there is measure support as well. Now we can use expressions like “Bigger than a certain value” or “Smaller than a certain value” by using measure conditions. Thus, it is more useful.

Change Detection for Page Refresh

This month, a new feature for the automatic page refresh is presented. If you are wondering what the automatic page refresh, you can take a look at this article about updates. It is a practical feature for frequent refresh scenarios. When you set the page refresh as 1 second, even though the data didn’t change, page refreshed continuously and when you think about it, since data change that frequently, it is an inefficient action. For this very reason, they have created a new approach. With the approach, you create a special measure named “Change detection”.

In this measure you choose the calculation method and the field you will watch the change of and frequency. The diamond we see on the left of “Change Detection” tells us that it is Premium only. 😢 You need to add this feature to this field when you turn on the “Page Refresh” feature. Apart from that, this feature can be used only in Direct Query. You can create a measure for each .pbix file. Premium capacity admin must turn this on in the admin portal.

New Visualizations

Radar Chart

I love using Radar Charts. I think they are very practical when it comes to showing strong and weak areas. There are new visualizations concerning this.

Comicgen

An interesting visualization that can be visualized as emotion and pose in accordance with each KPI has been created.

 

So much for Power BI April updates. You can click here to download April updates. I am excited to see what awaits us. Take care.

Good game well played.