Power BI – Create Data Alerts

Hi there BI Fans,

Do you use a stock report and are you in constant need of renewing the report and keeping up with it in order to not go stock out? Do you want to receive a notification immediately when one of the IOT devices you follow with Power BI reports get too hot? Then it is safe to say that data alert is your jam!

Data alerts is a feature exclusive to the cards on the Power BI dashboards. The values are checked for being over or below a certain level and if the limit is exceeded, then the person who created the data alert gets notified by Power BI regarding the situation.

 

Now, let’s take a look at how we can create one.

 

 

1- Pin the card to the dashboard

First thing first, we need to pin the card on the relevant report to the dashboard. As you know, we can make this card be shown on the dashboard we want by clicking the pin icon on the upper right of the cards.

Pin to Dashboard dialog

2 – Click “Manage Alerts”

Once we pin the card on our report to the dashboard, we will go to the relevant dashboard and click the ellipsis icon on the upper right of our card. Here, we choose the “Manage alerts” option.

Diğer Seçenekler menüsünde uyarıları yönetme ekran görüntüsü.

3- Determine the Conditions for Data Alert

Now, we enter the information regarding the data alerts in the window that pops up on the right of the page. The title of the alert, our condition, if it will be over or below a certain value and that will this value be… You need to enter this value manually. Then, we will choose the frequency of this alert. And since we want to get an e-mail about the subject, we leave the mail option checked. Then, we “Save and Close”. This way, we get to complete the action.

 

From now on, once all the data is updated an evaluation with the comparison to the determined value will be executed. And we will receive a notification when it is necessary. Here is an example of one of the e-mails:

Depending on the urgency of the situation, it is also possible to design different flows for when the e-mail arrives. We will talk about this in our other articles. You can take a look at the other articles here.

Good game well played.

What is Power Automate? – An Overview

Hi there dear readers! Today, we will talk about Microsoft’s Power Automate (formerly called Flow). Power Automate is a member of Microsoft’s Power Platform family, and allows you to automate your business processes and design them with as little code as possible. It integrates with nearly 300 connectors and handles your work automatically without the need to visit multiple sites or run multiple programs. To begin with, I recommend reading this article and then looking at the templates on Power Automate’s site. These are ready-made templates that you can get started with right away. Here I leave a few of them for you to review:

POWER AUTOMATE FOR EVERYONE

One of the best parts of Power Automate is that you can perform a variety of business processes in the simplest level possible, even without having the tiniest idea of how to code. Of course, every now and then you will need formulas here as well when appropriate, And for that kind of situations, Power Automate has its own formulas. Many of these formulas, referred to as “Expressions”, are similar to those of Excel.

FUNDAMENTAL COMPONENTS

Flows have 2 main components:

  1. Trigger
  2. Action

The main question when it comes to the trigger title would be “What will be required to happen for this flow to run?”

The titles like:

  • When an e-mail is received,
  • At 10 o’clock every day,
  • When a new task is created,
  • When a new line is added to the Sharepoint list,
  • When a button (Power Automate button, Power Apps button, Power BI button) is pushed,

etc. are all triggers. A flow doesn’t work without a trigger.

The main question when it comes to the action title would be “Which actions will be executed once this flow starts running?”

Here, we will select the actions we want to execute and connect them one after the other.

  • Send an e-mail.
  • Create a task.
  • Send a message on Teams.
  • Add a new record to the Sharepoint list.
  • Create a new file on Sharepoint.

etc. are all actions.

As a matter of fact, most of our business processes depend on various conditions and approvals. For example, you will save the files to a folder, but your administrator must approve these files first. Here the process gets a little more complicated and you have to apply various conditions to the processes as well. Since these situations are quite normal, Power Automate also has a solution for this situation: Flows can be designed to create special reactions to the results of certain conditions by selecting conditions as an action and working according to these conditions.

Everything goes step-by-step in the Power Automate flow. Thus, one of the main points to know here is that when you add an action, you can use the outputs of the actions or triggers from the previous steps. In the Dynamic Content area, Power Automate already shows you what and which titles you can use.

 

Below you can see an image of a conditional process.

The steps here are as follows:

  1. We have created a survey, and we want this flow to be triggered when a new answer comes in.
  2. We get the details of the answer that caused the trigger.
  3. In the survey, we’ve got the question of: “Did you like our event?”. We will execute 2 different actions depending on the answer to this question. For this very reason, we add a condition.
  4. We choose the title to which we will apply the condition: “Did you like our event?”. We want it to check if the answer here is equal to 5. 5 is the highest value.
  5. If it is equal to 5, then we send an e-mail to the sender saying “Thanks”.

 

You can click here to check out our other articles about Power Automate. And if you ever have a question, feel free to let us know. See you in other articles.

Good game, well played.

OFFICE INSIDER – WHAT HAPPENED IN MAY?

NEW FEATURES/FIXES

 

You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻  Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of May.

May 2021

May 14, 2021 , Version 2106 (Build 14107.20000)

word new iconWord

Notable fixes

  • We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.

  • We fixed an issue where pressing key combinations such as ctrl + shift + @ would not produce the expected accented character( in this case, ‘å’).

  • We fixed an issue related to z-order of SVG objects when converted to shapes.

  • We fixed an issue related to image compression.

  • We fixed an issue where copying a mail attachment to an application other than Word would fail if the filename included DBCS characters.

  • We fixed an issue where Word sometimes displayed a border around text that should have not been there.

Excel

Notable fixes

  • We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.

  • We fixed an issue related to z-order of SVG objects when converted to shapes.

  • We fixed an issue related to image compression.

PowerPoint

Notable fixes

  • We fixed an issue where OneDrive would display a merge error message when there was indeed no merge conflict.

  • We fixed an issue related to z-order of SVG objects when converted to shapes.

  • We fixed an issue related to image compression.

outlook new iconOutlook

Notable fixes

  • We fixed an issue that caused users to see actionable messages either constantly refreshing or reverting back to headers after download when running in Download Headers Only mode.

  • We fixed an issue that caused the people picker in Outlook to expand upwards rather than downwards for users with a perpetual license.

  • We fixed an issue that caused users of custom domains to see a warning message about permissions when pasting a link into an email message.

May 7, 2021 , Version 2106 (Build 14029.10000)

Excel

Notable fixes
  • We fixed an issue that prevented the Name Manager from opening books with a large number of hidden names.

outlook new iconOutlook

Notable fixes
  • We fixed an issue that caused users to see copies of all of their sent items appearing in their Outbox folder.
  • We fixed an issue that caused Outlook to close unexpectedly when using Read Aloud with other versions of Windows.

word new iconWord

Notable fixes
  • We fixed an issue that caused Word to close unexpectedly when using Read Aloud with other versions of Windows.

May 3, 2021 , Version 2105 (Build 14026.20052)

Excel

Linked data types: Real data for real life

We’re excited to announce brand new data types in Excel, resulting from our partnership with Wolfram. Have you ever tried to get data from the web into Excel and keep it up to date? Then, you’ll know it’s not for the faint of heart. These new linked data types and smart templates not only save you time but also make keeping data up-to-date a breeze.

Learn more >Şehir ve Üniversite veri türleri özelliği

 

Create content that works for everyone

We’ve heard your feedback! We’ve created a contextual Accessibility ribbon that offers one consolidated place to look for tools that make authoring accessible content easier. To try it out, open the Accessibility Checker on the Review tab and the Accessibility ribbon will open automatically.

Learn more >  Erişilebilirlik Denetleyicisi

 

 

We compiled all the new features and fixes in May in Office insider.
Hope to see you in our other articles, bye bye. 🙋🏻‍♂️
You can share this article with your friends and family to help them get information about Office insider updates released in the month of May. 👍🏻 

 

OFFICE INSIDER – WHAT HAPPENED IN APRIL?

NEW FEATURES/FIXES

You can find and follow all monthly Office insider new features and fixes (updates) on our blog. 👍🏻  Officer insider gets updates and new features regularly. It is important to follow these Office insider updates and use them in terms of increasing your knowledge. Now let’s take a look at what kind of changes happened in Office insider in the month of April.

 

April 2021

April 30, 2021 , Version 2105 (Build 14026.20000)

Visio

AWS stencils and shapes

You can now use stencils with the latest AWS shapes to help you create diagrams and represent your AWS architecture more accurately.

AWS şekilleri

 

outlook new iconOutlook

Ensure accessibility of your content

When composing an email to large audiences or external users, for example, accessibility violations will now be brought up to your attention, through a mailtip.

To turn off this feature, select File > Options > Ease Of Access > Accessibility checker options and select the Run the accessibility checker only when I open it option.

Notable fixes
  • We fixed an issue where using High Contrast mode for extended periods of time would cause Outlook to crash.

Excel

Notable Fixes
  • We fixed an issue which could cause Excel to crash when using Paste Special with formats in certain situations.
  • We fixed an issue that cause Excel to crash when moving through comments in the Comments pane.
  • We fixed an issue that caused date formatting to be displayed incorrectly in some languages when using add-ins.
  • We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.

word new iconWord

Notable fixes
  • We fixed an issue that caused the ability to collapse margins in a document containing multiple columns to be available.
  • We fixed an issue where text formatting remains after removing hyperlinks.
  • We fixed an issue where users would not be prompted to save documents when using a command (rather than the CTRL+S keyboard shortcut).
  • We fixed an issue where Word was unable to perform a Mail Merge with an Access database.
  • We fixed an issue where the sensitivity label disappears from a file in Word after uploading the file to SharePoint Online.
  • We fixed an issue where comments are not displayed after filtering by people.
  • We fixed an issue where Word would become unresponsive when editing fields.
  • We fixed an issue where some characters are not displayed correctly in table cells when there are comments in the document.
  • We fixed an issue where the file format changes occurred when saving documents with the AIP add-in enabled.
  • We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
PowerPoint
Notable fixes
  • We fixed an issue that caused the Dictation button to be misaligned when adding comments to a document.
msproject new iconProject
Notable fixes
  • We fixed an issue where changes done through Planning Wizards weren’t always captured by change events.
  • We fixed an issue where users were unable to remove projects from the resource pool.

April 23, 2021 , Version 2105 (Build 14014.20002)

Excel

Import data from dynamic arrays

You can now import, shape and refresh data from dynamic arrays in the current workbook.

Notable fixes
  • We fixed an issue to support backward compatibility with older versions of Excel. The issue may cause a file that is saved in a more recent version of Excel fail to load properly in older versions of Excel due to functions such as IFERROR and XLOOKUP added to Excel since Office 2007.
  • We fixed an issue where some files would occasionally fail to open in Protected View.
  • We fixed an issue that caused the status bar to not indicate a Ready state for some users.

outlook new iconOutlook

Notable fixes
  • We fixed an issue that caused name resolution to fail when sending on behalf of another user and resolving against an address book that is not the Global Address List.
word new iconWord
Notable fixes
  • We fixed a issue where placeholder text was clipped in comments when using right-to-left languages.
Office 
Notable fixes
  • We fixed an issue where hyperlinks including digits would be broken when composing a message in Outlook in a right-to-left language.
  • We fixed an issue where some Scalable Vector Graphics (SVG) did not render correctly.

April 16, 2021 , Version 2105 (Build 14007.20002)

Excel

Notable fixes
  • We fixed an issue that caused Excel to crash when using 32 bit Office on 64 bit Windows.
  • We fixed an issue that caused Narrator to incorrectly read the properties of two buttons on the Header/Footer tab in the Page Setup dialog box.
PowerPoint
Notable fixes
  • We fixed an issue related to linked pictures.

April 9, 2021 , Version 2105 (Build 14002.20000)

Excel

Accessibility ribbon

Find all of the tools you need to create accessible content in one place – the Accessibility ribbon!

word new iconWord
Proofing for selected text within the Document

With these changes you can now review spelling, grammar and other intelligent writing suggestions for just the selected text. Additionally you can also review suggestions for the whole document.

April 2, 2021 , Version 2104 (Build 13926.20000)

outlook new iconOutlook

Turn on shared calendar improvements

For shared calendars in Office 365, Outlook can update these calendars using the REST API. Turn on the preview for faster and more reliable updates to shared calendars.

word new iconWord
Notable fixes
  • We fixed an issue that prevented specific policies from being honored.
  • We fixed an issue in auto save.
  • We made a fix in Application.OnTime where it might not trigger correctly.
Access
Notable fixes
  • We fixed an issue when an external application requests an accessibility interface, it will prevent us from shutting down until they release their reference.
We compiled all the new features and fixes in April in Office insider.
Hope to see you in our other articles, bye bye. 🙋🏻‍♂️
You can share this article with your friends and family to help them get information about Office insider updates released in the month of April. 👍🏻 

 

 

How to measure marketing success with E-maıl Sıgnatures

E-mail signatures are one of the most targeted digital marketing tools. Especially in our work routine, all e-mails sent by all employees in line with their communication needs can be used as marketing endpoints. But, how? In this article, you can see the integration steps of the interaction reports via e-mail signatures to the Google Analytics platform and discover the market potential.

Google Analytics uses two basic methods to collect data on website traffic from 3rd party domains.

  1. Connectors on Google Analytics
  2. UTM and similar routing parameters

The Google Analytics connectors are sections that you can integrate with your Google Analytics properties by connecting with your authorized user information through channels such as Google Ads and Youtube. These integrations include your Google Ads advertisements on Google Analytics screens, the traffic and feedback generated by these advertisements. It allows you to create your digital marketing strategy by viewing how much of your total traffic it has generated and its total impact in a segmented manner with the traffic from these channels.

On the other hand, in order to link your website to Google Analytics screens, you need to add the Tracking Code page tags under the Admin > Tracking Info tab to thesection of all the pages of your website.

UTM (Urchin Tracking Module) parameters are used to define where and for what purpose the traffic directed to the website from influencer marketing, social media advertisements, newsletters and all similar content from third party domains. It basically means creating a custom redirect URL by adding additional text to the URL you use to redirect your website. You need to add 4 parameters to have the access from this link reflected well on Google Analytics reports.

  • Website URL
  • Campaign Source
  • Campaign Medium
  • Campaign Name

Here is an example:

The new URL: https://peakup.org/global/signgo/?utm_source=signngo&utm_medium=emailbanner&utm_campaign=emailsignature

The redirection created by these parameters transmits the description of the information contained in the other items while
directing the users to the site defined in the URL section.

While editing your e-mail signatures with the Sign&Go application, you can create corporate signatures similar to the designs below. Allowing you to define links to banner advertisements while creating signatures, Sign & Go creates a template that includes special UTM parameters as defined above for all emails sent throughout the company.

After this step, all individuals who click the banners in your mail signature will be anonymously reflected in your Google Analytics reports and your e-mail signatures’ contribution to the website traffic will be reflected in your reports.

When you go to your Google Analytics panel, Medium and Source sections of all report fields, especially of the Traffic Sources section under the Realtime tab under the Reports section, appear as defined just like in the 4th line of the table in the visual above.

With Sign&Go, you can turn your company-wide signatures into the most effective direct marketing tool and make sure that you use digital media effectively while creating quality signatures that reflect your brand’s power.

E-mail signature management: SIGN&GO WEBINAR with ÇÖZÜMPARK

What is the contribution of e-mail signatures in the digital business environment? Do they really acts as a business card of the companies? In these times where we feel that we are moving into the digital age, according to Statista’s research, approximately 306.4 billion e-mails were sent and received every day in 2020, while the number is expected to increase to 376.4 billion per day by 2025. In recent years, the importance of professional e-mail signatures around the world has turned into a powerful marketing tool, benefiting companies’ success and brand recognition on a large scale. As Seth Godin said, “Marketing is a contest for people’s attention.” You can also get more attention by adding innovative differences to your e-mail signatures such as colorful designs or the GIF playback feature.

But, what is SIGNandGO and how does it contribute to your company?

E-mail signatures are the closure of messages. Considering that each employee represents your company, it provides information about your company, connects with your brand and creates trust. By adding information texts such as advertisements, campaigns or announcements to your e-mail signatures, you can transmit your campaigns according to dates and generate traffic to your company’s website. The advantage within your company is that it provides an easy-to-use interface to different departments and takes this burden off the IT department. The best part is that it doesn’t even cost you a lot.

We held our SIGNandGO webinar with Çözümpark, where we talked about the steps that will facilitate your e-mail signature management without the need for server installation with a cloud-based central e-mail management solution.

  • Scheduled signatures
  • Cloud signature structure
  • Web based management
  • Mobile friendly management
  • Defining signatures and rules from the web-based easy admin screen
  • System Architecture: Exchange online and local exchange
  • Easy setup: SaaS and o365
  • Security measures: IP restriction, TCP communication, domain name filter

 

We planted saplings for International Women’s Day

PEAKUP donated saplings on behalf of their employees on March 8, International Women’s Day.

PEAKUP organized a meaningful organization on March 8, International Working Women’s Day this year, just like every year and donated saplings on behalf of their teammates. The team planted the saplings in Kağıthane Hasbahçe with the participation of the Mayor of Kağıthane, Mevlüt Öztekin, for the International Women’s Day.

PEAKUP wants to leave a mark that can be passed on from generation to generation, and for this, has brought its saplings to the soil with the support of Kağıthane Municipality with the planting of Ginkgo Biloba trees, which represent durability, originality and eternity on behalf of the entire team.

PEAKUP CEO Ahmet Toprakçı said, “As PEAKUP, we support women in every aspect and continue our activities as much as possible to set an inspiration and example for our company. In our company, we always ensure the balance of the number of female and male employees and equal rights. This year, we hope that the trees we donated on March 8, International Working Women’s Day, will continue to live by reflecting our women with their originality and all their elegance.”

INFRASTRUCTURE TRAINING: INTRODUCTION TO INFRASTRUCTURE

We began our new content series “Introduction to Infrastructure” trainings. In this training that is planned to last for 8 weeks, the PEAKUP CEO Ahmet Toprakçı, who previously provided consultancy and training in various institutions, will be sharing his knowledge with you, our esteemed audience. The goal of our training is to start from the most basic level of infrastructure services and technologies and to touch on more professional subjects over time. The general topics of our event, which will take place every Wednesday at 17: 30-19: 00, are as follows:

. System and Network
. Introduction to Infrastructure Technologies
. History of Computer Networks
. The Concept of Internet
. IP
. Bit / Byte
. IP Network
. IP Subnetting / Supernetting
. Network Hardware (Router, Switch, Firewall, AP)
. VPN and more.

You can watch the training for free via the link below or in the bio.. 👇

 

How to Subcrıbe to a Hıdden Page ın Power BI Reports?

 

Hello dear reader! Today we bring you an important study topic that hasn’t been solved for the Power BI users yet. What if we want to subscribe to a hidden page in Power BI reports? What do we do? Actually, there was a poll in the community page for this feature to come and it has been approved, but hasn’t been added to the roadmap yet. With the “Hide Page” feature of Power BI, we can prefer not to show certain pages to some users in the reports uploaded to the portal. These pages usually consist of the detail pages. What is on these detail pages? The detail pages consist of very detailed information -usually charts- that we don’t directly need in the report but that is highly requested by some users.

And at some points, these hidden pages might be pages that have been directed from a navigation screen or it might be a completely unique situation to your company. Long story short, there are some pages and you do not want their name to appear or to be accessed directly by the users while browsing through the report! So what if you want to subscribe users to these pages that you do not want to be accessed directly in the report?

Power BI does not offer this as a default feature, meaning we cannot subscribe users to the hidden page. While researching the details of this, I found out that this is because of the design. After doing a few experiments on how to do this, we figured out how to subscribe to the hidden page in Power BI reports! If you please, let’s see how we can do it now:

1- Upload the said page to the portal without hiding it.

Gizli sayfa görünüyor2-Define the necessary subscriptions to the page.

Gizli sayfaya abonelik3- Click on “Edit Report” and hide the page.

Sayfayı gizleyin

Go back to the review mode and that’s it!

Now, let’s wait for out mail to come at the hour we have defined. Here it is!

mail

It is quite simple to do, but there is a something that you need to pay attention to. Never turn on the subscription feature for the hidden page! When you turn it on, you will see that the report page field will be blank and this subscription will no longer work and you will need to repeat the steps above all over again. If you want to edit the subscription, first make the hidden page visible, then edit the subscription.

We can explain the reason of this situation like this: We had said that the report pages didn’t completely get lost in the back, and that were just not shown in the design on the front. So, actually, the information of the page is kept this way on the subscription page. However, when we turn the subscription back on, the values in this field start to work according to the current situation and explode when you cannot find the page! If you do not do such a thing, you can use this smoothly without any problems.

See you in the next article,

Good game well played!

 

Online Education in the New Digital

We have proudly contributed to the preparation of digital classes by supporting online education through our projects with educational institutions during the distance education process.

We carried out our free webinar, where we talked about Microsoft Teams and its uses, which is used as infrastructure in online education, Azure Labs, which you can use for unlimited laboratory experiences, and the student management system Moodle Integration.

Our topics:

  • Microsoft Teams: Everything including online lectures, assignments, digital quizzes and effective digital learning with Microsoft Teams, the structure that brings students, teachers and all academic staff together digitally.
  • Azure Labs: The Lab experience where you can find Microsoft Project, Adobe Photoshop, After Effects, Matlab, Autocad, Solidworks and more and where you can have unlimited lab experience regardless of location and hardware
  • Moodle Integration: Methods to integrate student management system Moodle with Microsoft Teams and Office 365, automation steps for creating automatic classes and effective learning

We kindly thank everyone who has participated.