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

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

These Lovely Skills You Need to Enter as Data Architect

We can analyze data quickly now. The data can be any size. The basic skills you need are R language skills and Machine learning for analyzing the data. MapReduce Techniques The MapReduce techniques and parallel processing in Hadoop allow us to cheaply and efficiently implement MapReduce on Internet scale problems. We use SQL like tools Pig and Hive. NoSQL We analyze so-called NoSQL storage solutions exemplified by HBase for their critical features: speed of reads and writes, data consistency, and ability to scale to extreme volumes. Data Architect Requirements Data architects develop, analyze and administer data for businesses, schools and other organizations. They need sophisticated design and development skills to collect data and translate it for use in computer applications and systems. Most data architects have a bachelor's degree in information technology (IT), as well as years of experience in the IT field. Experience with programs such as Microsoft Excel, Ac

Top Companies Who Need Data Analysts

Image
The following list of companies hiring analytics candidates. Companies Recruting Analytics Firms Amazon.com Bill and Melinda Gates Foundation INVISTA Nordstrom PopCap Games Salesforce.com Starbucks T-Mobile Tacoma Housing Authority Target