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

Talent Analytics on employees to measure real worth

Image
Human resource managers are currently embracing talent analytics like never before. Companies are evaluating and analysing raw data to derive valuable insights which are helping them to hire the right talent, retain them as well as help them learn and grow internally. Data to do analytics Talent analytics companies take into account all the data, rather than limited samples, so a full-fledged picture emerges.  It looks for patterns in the data and discovers critical connections that might otherwise go unnoticed. Such data can be related to employees' pre-employment assessments to background checks to social media profiles. How data will gather They also gather data on the characteristics of their most successful employees. When big data is tapped this way, HR managers no longer need to depend on intuitions of interviewers and hiring managers or rely on obsolete hiring tools of yesteryears.  Organisations are also leveraging big data to hire and promote t

Internet-of-Things jobs Booming in Technology area

Image
The Internet of Things helps enable proactive data access from any connected device.The Internet of Things represents an evolution in which objects are capable of interacting with other objects. Hospitals can monitor and regulate pacemakers long distance, factories can automatically address production line issues and hotels can adjust temperature and lighting according to a guest's preferences, to name just a few examples.  Stocksnaps.io Furthermore, as the number of devices connected to the Internet continues to grow exponentially, your organization's ability to send, receive, gather, analyze and respond to events from any connected device increases as well. IBM solutions can help put the Internet of Things to work for you by giving you the ability to:  connect millions of objects and millions of events. unlock information in systems of record.  support new systems of interaction with people, mobile devices, sensors, machines and applications.  optimize business r

New Wave in Data Analytics in 2014

Image
 SrnimfJobs N ow that we’re in the swing of a new year, we’ve taken stock of the data analytics trends that are brewing and developed a list of the Top 5 trends we believe are going to dominate the industry this year. Even if some of them don’t realize their full potential in 2014, it promises to be an important year in which consumer trends and technology innovation will further shape a future in which companies make data-driven decisions. 1. Data Visualization Goes Mainstream In the mid-90s, e-mail introduced the Internet to consumers, made it more accessible, and catalyzed user adoption. Similarly, data visualization will make data analytics more accessible in 2014. Visual analytics allows business users to ask interactive questions of their prepared data sets and get immediate visual responses, which makes the whole process engaging. This trend will democratize access to data and foster a strong data analysis culture where business users will look for data and perform

12 Top Teradata Blogs

Image
Teradata is popular among data warehouse projects. I have collected good blogs for developers. Here you will get complete list. The following are 12 top Teradata blogs. Teradata with learn quest Teradata Tutorials Teradata first blog Teradata developer blog Teradata developers recommendations Teradata tuning Teradata fog blog Teradata Bigdata Blog Teradata blog big solutions Teradata Applications Blog Teradata Utilities Teradata Technology Blog Conclusion Not only reading getting knowledge from these blogs, if you feel these are good you can share to your friends.

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