Posts

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

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

The best collected artciles from Srinimf for IT developers

Visit Srinimf | Tech.Jobs.Biz.Success's profile on Pinterest.

A Quote On Analytics

Image
W. Edwards Deming Don’t expect smart people to listen to you without proof. Learn the basics of analytics and people will love you. If you don’t have time to learn, hire someone. The Way Get Started Is To Quit Talking And Begin Doing.” – Walt Disney You Learn More From Failure Than From Success. Don’t Let It Stop You. Failure Builds Character.” – Unknown

Big data real role to help Real estate business

How big data helps real estate is trending today. When people buy real estate and its dependencies you can get from analytics Advantages of Big-data in Real estate Study the data from real estate consume Understand the buyers Loan dependencies and role of consumers Sale activities by agents Sales boost Role of Big Data Real estate agents need to check lot of data sources to identify sales pitch and formula to boost sales. The first point is agents should understand the requirements of consumers or buyers of real estate. References Real estate data analytics read now

New IT Job Roles So Popular to Read

The popular job roles you can read today. These are new in the industry. Knowing is not harmful. You will get ideas on achieving these roles. E-Commerce Business Analyst It involves supporting the development of e-commerce solutions. This person should possess strong analytical, organizational and communication skills and will have demonstrated the ability to collaborate within a team environment. Virtualization Engineer/Architect It refers to the agile provisioning of converged storage, computes and network resources. It requires knowledge of how to take a cluster of physical servers and make them virtual machines, it also extends to network and storage virtualization CRM Expert Customer Relationship Management (CRM) experts need to work on complex CRM applications and their role includes programming, project management, project development, systems configuration, and development. Read more