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

Social Analytics - How Marketers Will Use

Image
Of all the windows through which a business can peer into an audience,  social media  seems most enticing. The breadth of subjects, range of observations, and, above all, the ability to connect and draw inferences make  social analytics  hugely exciting for anyone who is interested in understanding and influencing past, present and potential customers, employees, or even investors. As individuals leave traces of their activities - personal, social and professional - on the internet, they allow an unprecedented view into their lives, thoughts, influences and preferences. Social analytics attempts to draw useful understanding and inferences, which could be relevant to marketers, sales persons, HR managers, product designers, investors and so on. Thus, as social tools like Facebook, Twitter, LinkedIn, WhatsApp, and many more, host a plethora of social activities of many people, a humongous amount of data is generated about people's preferences, behaviour and sentiments. Like any da

Teradata: Key Role in Telecommunication Analytics

Teradata, a US analytics solutions and applications provider, has said that there is a growing market for next-generation analytics in India amid intense competition among telcos and growing mobile phone penetration. Insights Carriers with increasing consumer focus require next-generation analytics to unify data from both the traditional and Big Data environments and transform it into meaningful insights - on how subscribers are consuming their services and in turn how they can improve their marketing tactics for upselling, customer retention, and loyalty. And ever since mobile number portability ( MNP) - a facility that allows subscribers to retain their numbers despite switching operators - was introduced late 2010 in India, customer retention has become a key imperative for service operators such as Vodafone India, Idea Cellular, and Bharti Airtel. Telecom Analytics "With rising teledensity, ensuing competition, and falling average revenue-per-user, telcos will have to look b

Trends In Digital Marketing in 2014-2015

Digital marketing uses various tools for digital marketing functions such as sales CRM, marketing automation, e-commerce, e-mail, WCM, web analytics, and social CRM. Related Skills for Digital Marketing You Need All these software tools collectively help an organization to develop and implement effective marketing strategies. Tools for Global Digital Marketing These tools are developed to serve specific functions in the Global Digital Marketing market as explained below: Sales CRM manages customer interaction and aligns an organization's sales process such as order tracking, sales performance, and distribution. Marketing automation enhances the capabilities of the marketing department of any organization to design strategies, automate processes, and improve customer communications, and also operates either as standalone software or as a major component of CRM software. E-commerce software offers advanced capabilities for searching, order management, cart management, and cont

Skills Need Every Employee By 2020

Image
With all the  predictions about the future of work , we are constantly painting a picture of how the future workplace will look. But, what most of us should focus on is what the workforce will  need   to look like – meaning, what skills employees need to have to ensure continued success into the next decade? The  Top 10 Online Colleges website  has the answer. They’ve done the research and compiled a list of skills that all employees will need by 2020 (which is only six years away!) and the drivers of the new skill set. First, we must understand what is driving change and molding the future of work. The six key drivers of change include: Extreme longevity:  People are living longer. The rise of smart machines and systems:  Tech will augment and extend our own capabilities. Computational world:  There will be an increase in sensors and processing that will make the world a programmable system. New media ecology:  There will be new communication tools that will require med

Wipro Expecting More Projects on Analytics and Cloud

Image
#Wipro Expecting More Projects on Analytics and Cloud: Bangalore-based IT firm WiproBSE 1.17 % expects to land bigger deals for solutions based on digital technologies like social, mobility, analytics and cloud, a sign that companies are willing to increase their spend on these discretionary areas.  "While our sweet spot is deals in the $2.5-3.5 million (Rs 15-21 crore) range, we are seeing deals worth $5-10 million (about Rs 30-60 crore) in the pipeline," Jeff Heenan-Jalil, global head of Wipro's advanced technology solutions unit said   in an interview to ET.  Wipro's rivals including TCS, InfosysBSE 1.65 % and Accenture have all created separate units to target the digital business, which is based on the technologies which go by the acronym SMAC. The business has typically involved smaller deals till now and posed a problem for IT companies trying to raise their share of revenue from these services.  Read more at: http://economictimes.indiatimes.com/a

UNIX Shell Scripting and Job Scheduling

Shell scripting and job scheduling are two major tasks for any UNIX developer. I am presenting here essential commands that need for any developer. Shell Scripts commands Shell script basics Variables in shell scripts Kornshell arithmetic  Commands for scripts Flow control, tests, and expressions Making Scripts Friendlier Functions Pipes and Shell Scripts Scripts with awk and/or sed Job Scheduling commands bg and at cron Read here

India's Second Largest Analytics Company

India's Second Largest Analytics Company- http://t.co/03r8P7MQJT — ApplyBigAnalytics (@applyanalytics) August 8, 2014

Infosys Looking for New Opportunities in Cutting Edge Software

Image
Analytical skills "I want us to be there in the great problems that are emerging around artificial intelligence techniques, deep data science and big data techniques, analytics and so on. New Opportunities Finding new energy sources, digital oil fields. This is the big thing in the minds of people in the oil and gas industry," Sikka said. Vishal Sikka also told that Infosys could build a computer like IBM's Watson from scratch. Watson is an artificially intelligent computer system that can answer questions posed in normal language and can be used to help make decisions. Watson Power In January this year, IBM announced that it would create a business unit around Watson. IBM CEO Virginia Rometty has said she wants Watson to be a $10 billion business. Read more here.

VBScript Free Video Tutorials (1 to 9)

Image
VBScript Videos

These 2 top skills you need to become an analyst

Image
Pools of master data present in repositories play a big role in data analytics. For example, data is already re-posited in data warehouses. Example, product data, customer data etc. Big data needs mixed skills. For example - technical skills and some soft skills. 1# Technical Skills One being able to administer software frameworks like: Hadoop,  expertise in databases like noSQL,  Cassandra or HBase  analytics programming languages and facilities like R or Pig. 2# Soft Kills Ability of people to think broadly across the organization, to understand the bottom-line needs of the business, to know which analytics questions to pose to get to those bottom lines, and to measure and communicate results. Additional Technical Skills - SAS, Cognos Re lated Hadoop top 100 complex Interview Questions

Data Science in Retail Marketing and Opportunities

Image
Data Science and Analytics started by all big companies including Shoppers top and Wal-mart. Data Science in Retail Shoppers Stop started big data analytics to study customers behavior. Started with one of the easiest programs. Where they studied customer loyalty program. Some Insights Studied patterns Studied customer buying styles Some people buy shirt-only and some people buy both Shirt and Trouser Studied buying patterns of Women buyers Read more at Live Mint

What is IBM InfoSphere DataStage

It integrates data across multiple systems using a high-performance parallel framework, and it supports extended metadata management and enterprise connectivity. IBM InfoSphere Powerful, scalable ETL platform—supports the collection, integration, and transformation of large volumes of data, with data structures ranging from simple to complex. Support for big data and Hadoop—enables you to directly access big data on a distributed file system, and helps clients more efficiently leverage new data sources by providing JSON support and a new JDBC connector.  Near real-time data integration—as well as connectivity between data sources and applications.  Workload and business rules management—helps you optimize hardware utilization and prioritize mission-critical tasks.  Ease of use—helps improve speed, flexibility, and effectiveness to build, deploy, update and manage your data integration infrastructure.  Rich support for DB2Z and DB2 for z/OS—including data load optimization f

13 Top Data Science Blogs To Read Now

Image
Here is the list of top data science blogs. You can improve your knowledge and the latest happening n this field. 13 Top Data Science Blogs To Read Now Data Quest Analyticsvidhya ApplyBigAnalytics Explorium Coursera-Blogs Netflixtechblog SAS Data Science Blogs DataScienceBlog Edureka Blogs ScienceSoft DataSciencedojo thisismetis CISCODataScience