Posts

Showing posts from April, 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

Data analysis report these are example queries to use on final data

Image
ApplyAnalytics@twitter The role of data analysis will come into picture, once you have cleaned and filter the raw unstructured data. The next stage is called analysis. Your success of data analysis project is based preparing highly informative final report. Tip:  What could you investigate with data To prepare analysis report, you need to ask some intelligent questions. These are example questions you can use. Based on your questions, you  need to prepare SQL queries to get the desired report or dashboard from your final data or cleaned data.  The report or dashboard should be such that it should improve client business. Let us use some case study on world bank data, what are the questions come into mind:  How much (in USD) is spent on healthcare in total in each country?  How much (in USD) is spent per capita in each country?  In which country is the most spent per person?  In which country is the least spent?  What is the average for each

Ruby Top Interview Questions

Ruby is one of the best language being used in Analytics and Big data. Updated presentation with super rich tutorial of Ruby concepts. Ruby programming from Kartik Kalpande Patil Most Popular Content How Linux Became Most Popular Operating System 5 Artificial Intelligence Real-time Applications

A Powerful Video to Import MS Excel into SAS (Part-1)

Image
#A Powerful Video to Import MS Excel into SAS: SAS is a Statistical Analytical Software. The below video shows how MS-EXCEL data import into SAS for analysis.

Real thoughts on IBM power8 servers to use on analytics

Image
IBM Servers International Business Machines Corp, in its latest attempt at reviving demand for its hardware products, is launching high-end system servers that it says are 50 times faster than its closest competitor at analysing data.  The POWER8 servers , the product of a $2.4 billion, three-year investment, are part of the company's decade-long shift to higher-value hardware technology.    IBM  said the machines are 50 times faster than the low-end x86-based servers it sold to Chinese PC maker  Lenovo  Group Ltd in January.  The technology services provider said on Wednesday it hopes the servers, designed for large-scale computing, will appeal to clients looking to manage new types of social and mobile computing and mass amounts of data. Last week, the company reported its lowest quarterly revenue in five years, weighed down by falling demand for its storage and server products. IBM dominates the higher-end server market with 57 percent market share, according to res

Career in analytics these 3 are top tips you need

Image
There is a big question to be successful in analytics career. I am giving most popular ideas to be successful in this analytics career. Gettyimages.in There are absolutely three... The tip number one is you need to be familiar with different types of analytics. Web Analytics Financial Analytics Marketing Analytics Education Analytics Retail Analytics Health Care Analytics The second one is you should have right kind of training at less expensive way. In the booming Analytics Industry, one needs right course of training and experience, and working experience of case studies on selected analytics area, really boost your career. I am sure Udemy is offering lot of courses . The third rule and idea is correct mindset Assertive Communication   BE PROACTIVE - Be Proactive is about taking responsibility for your life. You can't keep blaming everything on your parents or grandparents. Proactive people recognize that they are "response-able." They don'

SAP HANA Top new Applications

Image
The SAP HANA analytics from German software vendor SAP AG is betting heavily on a new generation of analytic computing it calls HANA.  In this post you will know the new features that are added in HANA. To maintain its position as the world's largest business-application vendor. So, learning HANA is really good and make sure these HANA course contents you need to have in your training. SAP HANA Applications HANA, which is already installed at more than 200 customer locations, processes data in real-time by storing it in live memory rather than in a separate data warehouse, enabling customers to make business decisions faster. >> Liquor distributor Charmer Sunbelt Group finished installing a HANA system , and it says it has helped managers react to logistical problems as they occur. Getting shipments out is essential for Charmer because customers can refuse them if they are late. >> According to Chief Information Officer Paul Fipps, HANA h

India Top Analytics Magazine Really Useful For All Developers

Image
AIM is one of the India's best analytics Magazine. The features it covers Articles, Latest trends in analytics, Start-ups in India, various job opportunities. Various government initiation on Big Analytics is plus point in this Magazine. Read AIM here. Analytics Tips for E-retailers:  This is one of the good article from CIO. Click to read Also read Google Analytics for Web Marketers and Tips AWS Basics for Software Engineers

Three top big data trainings useful to get deep insights

Image
I have selected 3 top professional training programs for all working engineers. ISB- Indian School of Business:  started a course in "Certificate Program" in Analytics: The use of Business Analytics is widespread across all industries and functions, including Information Technology, Web/E-commerce, Healthcare, Law Enforcement, Banking and Insurance, Biotechnology, Human Resource Management. WIPRO-Started deepening: its Analytical Business with " OPERA SOLUTIONS":Opera Solutions will allow Wipro engineers to offer solutions for customers based on the predictive analytics company's technology platform, according to a senior executive of the New Jersey based company.  SAAS - Software as a service changed INDIA IT indutsry: Empowering non-tech employees.The SaaS revolution in India is also bringing about another important change in organizations. "The CMO today is even more empowered than before," said Gartner's Padmanabhan. "Previously,

6 Top Ideas Key to Success in Life

Image
  These are the ideas for self growth. Total six steps to focus more to improve your self growth. 1# Education  The first of the nine success factors is education. In our society, the highest paid people are those who know more than the average. They know more of the critical facts, ideas and information than the average person in their field.    As a result, they can make a more valuable contribution to a knowledge-based society and live the best life possible . They are valued more, respected more and ultimately paid more money and promoted more often. The rule is that, “to earn more, you must learn more.” If you want to increase your level of income and achieve the best life for yourself, you must increase your level of intellectual capital and thereby the value of the knowledge component of what you are doing. 2# Skill The second of the nine success factors that you can use to achieve the best life possible is simply skill. Your level of ability in your field will determ

Course Topics You Need to Know Before You Take Course on Excel

Hey, you want to be master in Excel. There are 4 parts in this course. These contents cover all the functionalities you need to work with Excel. Excel is one of the tools to be used in data analytics Why I have given contents means these you must ask your tutor if present in the course or not. This list useful to start a career in analytics. List of Excel Course Topics Part-1 - Importing Data from other sources Import or Export data from multiple data sources Part-2 - Converting data Excel ready Formatting the data understand by EXCEL. Part-3 - Data Mining Formulas you need for Data cleaning. Part-4- Excel Data Analysis Tools Data analysis using statistical methods, Charts and Pivot Tables

Real Opportunities to Get a Job in Data Analytics

Image
In my recent analysis, I have found that a lot of jobs will be created in big data analysis area. I have listed the real opportunities here. I have collected a few of the things, and I am sharing with you. Opportunities ahead to get a job  The huge volume of data created by users from multiple devices in a variety of formats.  Need specialized skills to analyze the data, and to get predictive results. The tools developed by SAP, IBM, and Oracle provide multiple opportunities to start a career in data analytics.   Video on job opportunities

2 Top Skills You Need For E-commerce

Image
The following skills are must for every data analytics engineer to be successful in e-commerce companies. Many software engineers are struggling to get this information. I am giving here both technical and general skills. 1# Technical Skills for Analytics Career What skills they need to be successful in their analytics career. The skills required to get an entry into the Analytics job are here for your reference. I have told in my previous posts that there are many branches in analytics . You need to apply domesticated techniques to extract actionable knowledge. 2# General Skills I have selected the following mindset and skills that you need to get a job in data analytics. These are proven skills. Set a clear goal to acquire these skills. Strong interpersonal, oral and written communication and presentation skills;  Ability to communicate complex findings and ideas in plain language  Being able to work in teams towards a shared goal;  Ability to change direction quickl

5 top data warehousing questions to read before interview

Image
Hey, welcome to data analytics. Here I have given a few questions and answers. The below five questions helps you to understand very basics on data analytics. These are very basic questions. But, for laymen, they can understand easily and also good for interviews. Stocksnap.io Questions on Business Intelligence What is Business Intelligence?  It is a well-established process in the business world whereby decision makers integrate strategic thinking with IT  What is Web Analytics?  It is the collection, analysis, and reporting of Web site usage by visitors and customers of a website in order to better understand the effectiveness of online initiatives and other changes to the website in an objective, the scientific way through experimentation, testing, and measurement.  What is academic analytics?  This is the area analytics applied in academia  What is action analytics?  This is the area of analytics to produce actionable intelligence  What is the process of

Top Valuable Sources to Learn Predictive Analytics After Your Degree

Image
The word predictive analytics is to increase competitive advantage and at the same time to suggest the best value products to end customers. Data analytics Why you need to go for predictive analytics The reasons are Growing data Cheaper computers and servers Easy to use software Tough economic conditions More: Case Study on data analytics The predictive analytics helps in the following areas: Detecting fraud Improve marketing campaigns Reduce risk Improving operations Growing data analytics creating many job opportunities. Where You Need to Learn Do PG or post graduation in data analytics Attend Class Room Coachings