Posts

Showing posts from June, 2014

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Excel Analytics: The complete best explained Free Tutorials

Can you do analytics—either kind—using Excel? Sure. Excel has a large array of tools that bear directly on analytics, including various mathematical and statistical functions that calculate logarithms, regression statistics, matrix multiplication and inversion, and many of the other tools needed for different kinds of analytics. But not all the tools are native to Excel.  For example, some situations call for you to use logistic regression: a technique that can work much better than ordinary least-squares regression when you have an outcome variable that takes on a very limited range of values, perhaps only two. Odds ratios are the workhorses of logistic regression, but although Excel offers a generous supply of least-squares functions, it doesn’t offer a maximum likelihood odds ratio function.  The below list makes you strong in Excel analytics Microsoft Excel 2010 Data Analysis With Functions Analytics with Excel - Book Cloud data analytics from Excel Quantitative Analysis

Data science these IT skills you need to learn to get job

Image
The most lucrative analytics skills include MapReduce, Apache Pig, Machine Learning, Apache Hive and Apache Hadoop. Machine learning, big data, and data science skills are the most challenging to recruit for and potentially can create the greatest disruption to ongoing product development and go-to-market strategies if not filled. Image Courtesy|Stockphotos.io Great in demand it skills... Big Data (Information Technology): 3,977% Node.js (Design): 2,493% Tableau (Research and Analysis): 1,581% NoSQL (Information Technology): 1,002% Apache Hadoop (Information Technology): 704% HTML5 (Information Technology): 612% Python (Research and Analysis): 456% Oracle (Sales): 382% JSON (Information Technology): 318% Salesforce CRM (Sales): 292%

Five real ideas you need to get Success from failures

Image
The list looks so small. But these are so powerful. I hate that expression! And everyone seems to use it. Got fired from your job? It is what it is. Lost your savings? It is what it is. Put on 50 pounds? It is what it is. Never use It is what it is Stop saying “it is what it is.” The expression is a mantra for losers.  Be honest with yourself. Halfway through the tryout, you thought it wasn’t going well, so you stopped pushing yourself, didn’t you?  “Tryouts didn’t go well because you didn’t try your hardest. You gave up mentally, so you gave up physically.”  When you fail, figure out why ? It’s my fault. It’s always my fault—thats way I am in control. Adopted from www.success.com

An effective methodology for BI Implementation

Image
Given below is an approach that one could follow to ensure an effective implementation of any BI project. Steps in Business Intelligence Project Requirements elicitation is the most important activity in a BI exercise. We need to very clearly understand the motivation behind the management's need for analytics and their short-term, medium-term and long-term objectives.  You may conduct a workshop with all stakeholders to understand these requirements. Identifying and involving all stakeholders in the requirements discussion is very important to gain buy-in for the BI initiative throughout the enterprise. Anyone would like to see a sample of analytics and play around a little to get a sense of the benefit/impact of analytics. Hence developing a quick prototype and showcasing the same to all stakeholders will help you get the necessary impetus for the initiative.  CAVEAT: Please ensure that the prototype development does not take more than two weeks. References Read mo

6 Top IT Skills that have Huge demand for the next 5 Years

Image
These are top IT skills you need to know. Also, these are highly employable skills. These you can say as digital skills. Digital skills fetch you best salary, according to surveys by top job portals . 6 Top IT SKills SAS and R Programming Full stack development Data Engineering Data Scinece Mobile development - Perl, Ruby and Python Middleware integration software. The Bottom Line The trend is now changed. You can attend off-line and On-line courses and you can practices daily two hours. Within 2 or 3 months you can be perfect. Select any one skill for your employability. You cannot learn all the skills. It is dofficult to tell answers in the interviews.

Ideas: How Bigadata Helps HR Teams

Big Data is the buzzword of the year. Every leader — whether they’re managing a small team or are at the helm of a multinational corporation with thousands of employees — is wondering how they can use Big Data to better get to know their people, to create a setting that better suits their needs and, in turn, drive recruitment and retention. As co-authors of The Decoded Company: Know Your Talent Better Than You Know Your Customers, we’ve spent a lot of time thinking about this exact topic. Here are the top five trends you should be thinking about.

India | USA Jobs - srinimf.jobthread.com

Image
SrinimfJobs is a global leader in connecting people to jobs, wherever they are. For more than 6 years, SrinimfJobs has helped people improve their lives with better jobs, and employers find the best talent.  SrinimfJobs Today, the company offers services in more than 40 countries, providing some of the broadest, most sophisticated job seeking, career management, recruitment and talent management capabilities. SrinimfJobs continues its pioneering work of transforming the recruiting industry with advanced technology using intelligent digital, social and mobile solutions, including our flagship website srinimf.com and a vast array of products and services. SrinimfJobs pioneered the business of digital recruiting in 2014, and today we are the only online recruitment provider able to serve our customers on a truly global basis. In addition to our broad portfolio of global Web sites, Srinimfjobs offers valuable online advertising space on category leading properties.  As we

Data analytics popular free video course on SAS

Image
The Introduction to Analytics course is a set of 12 videos that take you through the basics of data analytics and the language of SAS.You should do this course if you are interested in data analytics and would like to pursue it as a career or if you have heard about the buzz it is creating and just want to know what it is all about. Each video is 5 to 30 minutes in length. If done in one go, it should take you about two hours to cover the course. The course is divided into three sections. The first section 'Introduction to Analytics' is a set of 6 videos. Here is a snapshot of the 6 videos: 1. What is analytics? This module explains the basis of analytics. 2. Why is analytics popular? This module talks about why analytics has become a big buzzword in business circles and the advantages of analytics. 3. Analytics applications? Here you will be introduced to the various analytics applications popularly used today. 4. Analytics technology Link to free course L

How to Prepare Resume Using Online Tool

Image
Here are five ideas to prepare resume using online tools. The resume surely will impress  HR and interviewer. Ideas for Online Resume Here is an open-source tool so that anyone can build a digital resume on their own domain . (It’s free.)  Don’t just showcase your relevant work experience; showcase your personality.  Set up a professional email, preferably at your own domain name.  Empower others to spread the message for you (Social media) Think outside the box to creatively get the attention of decision makers. Related 7 Tips to prepare resume Exclusive ideas to prepare resume for IT jobs

Google Analytics Top Free Courses

With the "Google Analytics Training: Getting Started with Google Analytics" I would like to help you get started with Google Analytic s and be able to get actionable insights from it. You will learn how to start tracking conversion rates and what data you need to analyze in order to improve them. List of Courses Courses on Google Analytics This Google Analytics training course will help you master the basics and see what it takes to turbocharge your website performance. References Free Course Link

7 top initial steps you need before you start HR predictive analytics

Image
Top criteria you need before you start analytics in the Human Resource department. I am sure you need many approvals to start analytics in HR. The risks involved to start analytics in the Human Resource department You must comply with the legal requirements in which you operate as it relates to the use of people data. The reason is the analytical insights should reflect the cultural and social marks of your organization. You need to get involved all stakeholders involved and what the cost of what you're doing is relative to the benefit of doing it. Use analytics through accountable processes, one of which should be acknowledging that using predictive analytics with the workforce has the potential for negative impact, not just positive impact, Walzer said. Engage the legal department to make sure you understand any implications before you've done something, not after the fact. Assess whether the use of analytics involves sensitive areas, which it often will, Walzer sa

Top 20 highest paying working from home jobs

U.S. businesses will spend half a billion dollars hiring remote freelance workers in 2014. "The growth is a clear indicator of a transition of work online," says Fabio Rosati, CEO of Elance-oDesk. The company's platform — which serves as a broker between companies that need skills and freelancers eager to supply them — sees 2.7 millio n freelance jo bs posted a year. According to Elance-oDesk , the total earnings of freelancers have grown 50% compounded annually over the past five years. From Rosati's perspective, so many businesses are hiring these workers because they need work done on demand, typically for a short stint. In those cases... Read more