Thursday, 14 September 2017

Tuesday, 12 September 2017

Top 12 Things Not to Say During an Interview : Interview tips

Bio:
Susan Ranford is an expert on job market trends, hiring, and business management. She is the Community Outreach Coordinator for New York Jobs. In her blogging and writing, she seeks to shed light on issues related to employment, business, and finance to help others understand different industries and find the right job fit for them.

Things Not to Say During an Interview
Interviews are places where you have to watch your tongue every second. You don’t want to say too much, the wrong thing, or ramble on incessantly. Some topics should be totally off limits during an interview. Be sure to keep these things on your mind and off your tongue at your next interview.

  • Never admit to being nervous.
Being nervous and admitting it are two different things during an interview.

You should show confidence in yourself first. Hide the case of nerves as best you can, and do not mention being nervous. The interviewer is looking for a confident candidate, and that can be you.

It may seem endearing to admit it, like you’re nervous and excited for the opportunity. But ultimately, it’s better to appear confident and in control of your emotions.

  • Never mention entrepreneurial aspirations during an interview.
Don’t tell an interviewer than you want to be your own boss.

Mentioning that you want to be your own boss puts you in a unique category that you really don’t want to be in. According to Ken Sundheim, it immediately lists you as a threat to the company because you could be there to learn trade secrets or be seen as a potential loss that leads to another day of interviewing. If you want to be hired, don’t tell them you want to work for yourself. Explain why you want to work for them.

  • Don’t be too eager to work.
If you are looking to be hired, being too eager to work can work against you.

Instead of being available for any job, be job specific when you apply. If you are willing to do anything, the interviewer may see you as desperate and not having specialized skills. If you’ll do anything, you’re not necessarily good at something. Make yourself valuable to the company by expressing yourself and your talents well.

  • Don’t Give Apologies for Lack of Experience.
If your resume doesn’t show years of experience in the industry that you are trying to break into, don’t make apologies for this lack of experience.

Build on your strengths rather than dwelling on your weak areas. This advice applies to the mid-career changer as well as the new graduate. If you don’t have the years of experience that the interviewer is requiring, mention any skills that transfer and make you the best qualified person for the job.

  • Don’t tell them to look at your resume.
If you are asked a question, be sure to answer the question.

Don’t refer the interviewer back to your resume. They want to hear an answer directly from you. You are a living, breathing person. Your resume is a piece of paper.

Reminding them that you listed it on your resume is disrespectful, and it is a definite don’t.

  • Don’t talk about your job search.
Let them know how you found them, but don’t talk about the hours you spent looking for other opportunities on local job sites. They don’t care about your job search, they care about potentially hiring you.

Move the focus to you and your skills as much as possible, not your inability to find other opportunities.

  • Don’t wait for questions you want to answer.
Rehearsing and practicing for an interview gives you confidence for answering certain questions, but don’t be listening and anticipating just those questions.

You have to be attentive and able to give answers to all of the questions that are asked. Being able to carry on a conversation without appearing to have it scripted is important to making it past round one in the interview process.

  • Don’t use clichés.
Be original with your words. Always find new and positive ways of saying things. Instead of using buzzwords and clichés, describe yourself with adjectives and phrases will showcase your creativity and ability to think independently.

The interview is the place to set yourself apart from the crowd, and your conversation is the most obvious way to do this.

  • Definitely lose the filler words.
Any word or phrase that you use to fill in a sentence while you are thinking should not be spoken during an interview. These words include ‘like’, and sounds such as ‘um’, and ‘er’. These do not help you communicate your message clearly and succinctly. You should remain silent rather than filling the gaps with these sounds.

Filler words are often words you don’t even remember saying. A pro tip is to record yourself speaking. Then, watch to see which filler words that you need to eliminate from your vocabulary.

  • Stay on topic.
If you have a tendency to ramble, put a lid on it during the interview. Feel free to be a great storyteller around your friends and family, but not during an interview unless the story you are telling is relevant to the job at hand.

If in your work experiences you achieved great success, then definitely share that story when the time is right. However, if you just can’t way to tell someone about your weekend plans, keep that story to yourself. 

  • Never ask what the company does.
If you have to ask what the company does that you are interviewing with, you haven’t done your homework. This question is the biggest turnoff for recruiters and can summarily end what was a great interview up until you asked this fatal question. If you ask this question, odds are really good that you won’t be hired.

  • Realize the power of your words.
Words are powerful, especially during an interview. Choose them carefully, and you’ll increase the odds of landing the job. If you’ve already been to an interview and have said all of the wrong things, learn from your mistakes.

If you slip up and say one of these things, realize it. Next time you’ll know what not to say.

Sunday, 10 September 2017

Top 20 Mixpanel Analytics Interview Questions with Answers

Here we come with very popular analytics tool interview questions with is know as Mixpanel. So lets start.

What is know about Mixpanel, explain?
Ans: Mixpanel is a business analytics service and company. It tracks user interactions with web and mobile applications and provides tools for targeted communication with them. Its toolset contains in-app A/B tests and user survey forms. Data collected is used to build custom reports and measure user engagement and retention. Mixpanel works with web applications, in particular SaaS, but also supports mobile apps. As of January 2016 the company had more than 230 employees, but had to fire 18 people due to overhiring.

In which format Mixpanel store Data?
Ans: JSON

Why Mixpanel even there are many tools in market?
Ans: Mixpanel provide a solution that lets businesses track the specific user actions that are important to your business questions, along with detailed information about these actions and users. We can track these metrics on any platform, and the customer gets maximum flexibility and granularity in terms of what details they track. Once the data is in, our reports let customers ask very complex, specific questions of this data.

Explain People analytics?
People analytics helps you understand and re-engage your customers,Imagine being able to understand who your users are, see what they do before or after they sign up, re-engage them with messages, and dig deep into your customer revenue. Now it’s possible, all in one place, with People Analytics.

Explain what is Segmentation?
Ans: Segmentation allows you to view top events on your app and easily break down complex events in mixpanel. You have the ability to drill down by an unlimited number of properties to gather instant insight into these key actions on your app. You can choose any individual event in MP, compare multiple events and see total events, unique users firing these events and average number of events per user. We also give you multiple options to view this data.

Mixpanel top features to analyse your people?
Ans:
Drill into your data: With Insights and findout where to focus your resources when building your product.
Visualize your data in different ways:Smooth out noisy results to really understand what’s going on.
Discover insights quickly: When digging into complex questions, don’t get slowed down waiting for an answer.
Bookmarks: Let you save reports that you look at a lot so you can save time.

EXAMPLE QUESTIONS MIXPANEL CAN ANSWER, BY WHICH YOU CAN TAKE DECISION
(to know better about Mixpanel)
Which sources have driven the most mobile installations over time?

Which feature should I invest in further to drive up customer conversion?

Was the ROI on my latest ad social spend campaign more or less than previous campaigns?

How is Mixpanel different from Google analytics?
Ans: Mixpanel differs from Google Analytics in one major way: instead of tracking page views, it tracks the actions people take in your mobile or web application.

How can I export my people profiles into a CSV?
Ans: People profiles currently cannot be exported via the Mixpanel UI; however, you can easily export your people profiles either: Within Mixpanel using one simple query in JQL.

Explain JQL(JavaScript Query Language)?
Ans: JQL – JavaScript Query Language – uses the full power of a robust and popular programming language, JavaScript, to let you analyze your data in Mixpanel. It was designed for performance and flexibility so that developers and data scientists can pull the most valuable insights from their data with ease ‐ no matter how complex the question is.

What are the advantages of using JavaScript for analytics over SQL? JAVASCRIPT VS. SQL
Advantages of using JavaScript for analytics:

  • The full power of a programming language powered by V8 ‐ the JavaScript engine in Chrome
  • Easily express & compose queries that are more understandable
  • A modern & popular programming language amongst developers to quickly get started
  • Flexible to use with unstructured, schema less data

Disadvantages of using SQL for analytics:

  • Meant for rigid schemas for traditional relational databases
  • Difficult to manipulate and transform the data
  • Complex queries become unwieldy to read & compose
  • Limited flexibility due to query functions available in SQL


How do I track a page view in Mixpanale, example?

What is distinct_id?
Ans: Mixpanel can keep track of actions in your application right down to the individual customer level. This is done using a property called distinct_id. The property can (and in most cases should) be included with every event you send to Mixpanel to tie it to a user. Distinct_id plays a vital role across most Mixpanel reporting.

Where can I find my project token?
Ans: Click your name in the upper righthand corner of your Mixpanel project and select Project settings to see your project token for only the project you’re currently viewing.

What data types does Mixpanel accept as Properties?
Ans: String
Numeric
Boolean
Date
List

Explain Activity Feed in Mixpanale?
Make better product decisions by seeing the full story of how individual customers use your product. Activity Feed puts customer behavior into an event-based timeline, so you can follow along as people experience your product, seeing where they get stuck along the way.