Posts

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