tutortek

/tutortek

About tutortek

Turtortek is founded by IT professionals with more then 20 years experience and having done management certification from IIM Kolkata. We are focused on delivering project based quality IT trainings in Cloud Computing, Big Data & Hadoop, Analytics, Testing, Web Technologies and Android where the emphasis is mainly on real-time project based learning. We provide instructor led class-room, online training and self-learning video tutorials.

Latest update by Microsoft for the Power BI Desktop

June 2017 release is full of new reporting features, new data connectors, accessibility features, and more. A couple of highlights of the June release are the addition of data bars to tables and matrices, markers for line charts, new map themes, and a horizontal image slicer. In addition, to improve the “Add Column from Example” feature in the Query Editor is in progress.
REPORT VIEW
• New visual: Shape Map (preview)

Shape Map is another mapping visual that has been added to Power BI.

Introduction to reports and dashboards

Reports:
A report is defined as “A document containing information organized in a narrative, graphic, or tabular form, prepared on ad hoc, periodic, recurring, regular, or as required basis. Reports may refer to specific periods, events, occurrences, or subjects, and may be communicated or presented in oral or written form”.
The purpose of a report is mainly to convey information. Reports may provide a direct solution to the problem or may just be a record of the past data.

WhatsApp is Emerging as a prominent Digital Marketing channel.

1002x481xWhatsApp-Messenger-Latest-Version-New-Features_thumb.jpg.pagespeed.ic.2t2WNQ4kt8
1. Introduction

Digital Marketing has emerged as a prominent marketing strategy owing to a large number of people getting access to the Internet mainly via mobile phones. Apps are now part of one’s daily life and the amount of time spent online by users is increasing on a daily basis.
Whatsapp, an instant communication messenger is one such app that is topping the charts. Whatsapp id no longer limited to personal communication and is fast turning into a medium of information sharing on mobile phones.

PENGUIN 4.0 UPDATE ROLLS OUT, IT IS NOW REAL-TIME AND MORE GRANULAR

Penguin-4.0-Google-Update

Google’s algorithm relies on more than 200 unique signals that makes
it possible to show the most relevant pages pertaining to a user’s
search query. These signals include things like keyword in title tag,
content length, keyword density, freshness and uniqueness of content and
so on. One such specific signal of the algorithms is called Penguin [1],
which was first launched in 2012.

After almost couple of years of development and testing, 

Nine Super-Effective Step-by-Step process of setting up your first PPC Campaigns

google-adwords-management

Google provides a very powerful tool – Google Adwords for attracting new visitors to your company website using paid search options, it can be very effective if used well. This type of service is also called PPC(Pay-Per-Click), and it is part of the internet marketing form called SEM (Search Engine Marketing), which involves the promotion of websites by increasing their visibility in search engine results pages (SERPs) primarily through paid advertising.
Since this article is for those of you who are new to Google AdWords,

SEO Techniques for a better Ranking

seo techniques for better ranking
SEO Tips – Optimization Techniques for better Ranking

 

Let’s take a look at some IMPORTANT key points to follow while doing SEO for your Website. Tried to cover all the important points in a broader way. Lets get into each & Improve our Website’s SEO ranking.

  1. Improving the page load speed by reducing HTTP Requests:

Here are some techniques for reducing the number of HTTP requests required to render the page,

DIGITAL MARKETING OVERVIEW 2016

 

digital-marketing-skills-bannerblog-16

 

Digital Marketing is not a buzz word anymore. More and more business are investing heavily on Digital Marketing to reach and engage with customers in a meaning full way. A survey by AdvertisingAge shows 80% of the business interviewed are planning to increase their Digital Marketing budget in the years to come. It is very clear that Digital Marketing is here to stay and grow.

Why Digital Marketing is becoming such an important part of the marketing strategy of a business?

Fixing VLookup errors using IFERROR

vlookup-iferror

To hide the #N/A error that VLOOKUP throws when it can’t find a value, you can use the IFERROR function to catch the error and return any value you like. When VLOOKUP can’t find a value in a lookup table, it returns the #N/A error. The IFERROR function allows you to catch errors and return your own custom value when there is an error. If VLOOKUP returns a value normally, there is no error and the looked up value is returned.

VLOOKUP with WILDCARD characters

excel-vlookup-wildcard
Advanced Vlookup with  – wildcard characters “?” and “*”

Why vlookup gives me wrong answer???

Bugs in vlookup???  I am sure it’s not about text vs. number, but it still fails to give the correct answer!!!

2

Wildcard Characters:
Question Mark “?” and asterisk “*” are the wildcard characters in Excel, they can be used in Find/Replace, Search, Match, and lookup functions, just to name a few.

Index and Match Function

INDEX-MATCH-vs-VLOOKUP-06

Index and Match Function :

Match –
Searches for the lookup value in the array and returns the index no (position no)
Index –
Opposite of Match, gets us the actual value in the array when the index no. of the array is passed.

1

Match
Gets the index no. of Ramesh from the list of SalesPerson –  MATCH(A4,A3:A12)
Index
Gets the name of the sales person at the position no.