Posts

Showing posts from January, 2015

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

Tableau, JMP, Advizor, and Spot-fire - Visualization Tools

Image
We are in a Bigdata world. Data presentation is very critical now a days. Data is generating from multiple sources. What is data visualization? Visualization tools have evolved so far that many people don’t realize the capabilities that exist. Tools like Tableau, JMP, Advizor, and Spot-fire help analytic professionals and business users move beyond graphics that simply illustrate a story that has already been developed. Visualization tools Visualization tools enable the analytic professional or business user to develop a new story in an interactive, visual paradigm. Today’s visualization tools allow multiple tabs of graphs and charts to be linked to the underlying data. Even more important, the tabs, graphs, and charts can be linked to each other. If a user clicks on the bar for the Northeast region, all the other graphs will instantaneously adjust and show only Northeast data as well. Also Read | The all about Tibco Spotfire reporting These new tools might be thought of

6 Top SAP HANA Blogs Useful for Interviews

The following are the best SAP HANA interview questions: SAP Hana interview questions SAP HANA replication techniques 20 SAP HANA interview questions Advanced SAP HANA Interview Questions 100 SAPA HANA interview questions Interview Questions

Major Trends in IT in 2015

As per research paper submitted by Gartner, the following trends will dominate in IT industry. Advanced, Pervasive and Invisible Analytics: Analytics will take center stage as the volume of data generated by embedded systems increases and vast pools of structured and unstructured data inside and outside the enterprise are analyzed. "Every app now needs to be an analytic app," said Mr. Cearley. "Organizations need to manage how best to filter the huge amounts of data coming from the IoT, social media and wearable devices, and then deliver exactly the right information to the right person, at the right time. Analytics will become deeply, but invisibly embedded everywhere ." Big data remains an important enabler for this trend but the focus needs to shift to thinking about big questions and big answers first and big data second — the value is in the answers, not the data. Cloud/Client Computing: The convergence of cloud and mobile computing will continue

Accenture Sees Demand in Big Data Analytics

Accenture Plc., which has 40% of its global big data analytics team based in India, plans to tap the country’s high-end analytics market in anticipation of an increase in demand driven by the government’s Digital India programme.  The National Democratic Alliance (NDA) government’s Digital India initiative is aimed at delivering government services electronically in urban and rural areas, cutting out human intervention and closing the gap between digital haves and have-nots.  It will act as an umbrella plan to integrate and synchronize all digital initiatives including the national broadband plan and the domestic manufacturing policy. “Big data analytics will play a major role in the whole digital disruption that is happening in India today,” said Arnab Chakraborty, managing director for advanced analytics at Accenture Digital.  “Mobility has leapfrogged in India and the whole ‘Make in India initiative’ has caught up strongly in the last six to eight months with the new leadership co

Switching Career Top Skills for Mainframe Programmers

Read my part-1 post. Secondly, the programmers who are working on the mainframe have very good business knowledge.  People who have the following skills are a valuable asset to any organization. Mainframe programmers if they learn other skills and try for new jobs they can earn more money. Programmer Roles. A programmer who can do analysis, create database structures, write clean code, create testing structures, and clearly communicate all that has been done is a very valuable asset. Background of Mainframe. The mainframe was leading in the market since 1950. All the big companies in the world are running their business in mainframes.  Yes, many American universities now teaching mainframe technology in their education curriculum, since in the future possibility is there for mainframe skill shortage. Skills You Need to Switch Career. It may become more important for IT professionals to gain experience working with analytics technology , as research firm Gartner predicted a surge in d

Maximizing Your SAP HANA Skills: Top 5 Course Contents to Consider

You can find SAP HANA course contents for your quick reference. You can download as a pdf. Before you take a course these are the contents you need to learn. Module#1. SAP HANA Introduction and Architecture SAP HANA Overview  SAP In-Memory Computing Overview  SAP HANA Features  Look and feel of SAP HANA  SAP HANA Architecture  SAP HANA Landscape  Structure of SAP in-memory Computing studio  Row store and column store Architecture  Multi Version Currency Control(MVCC)  Persistence Layer in In-memory Computing Engine  Back up &Recovery  High-Availability  Distributed System  Data Provisioning options in SAP HANA  Reporting options on SAP HANA  Security options in HANA  SAP HANA Appliance Model  How SAP HANA Appliance is delivered  Sizing Considerations  SAP HANA –Licensing Options  SAP HANA Project Implementation  Overview: Key Activities  Key Roles  Key Points to keep in mind  Administration Module#2. Basic Modeling Modeling Overview Terminology SAP HANA Studio Features Information

SAS- Get the Right Training, Go get the Job

Image
sas career options Many people think analytics is about gathering data using software tools and creating dashboards and reports. However, analytics is much more. Analytics goes beyond data; its primary goal is to enable business decisions based on that data. This involves working with stakeholders to understand the gaps in the business and using this knowledge as a guide to manipulate data, derive useful insights, and make recommendations – all key actions to increase revenue and lower costs. Wherever you sit in your organization, what’s most important is the bottom line. And so whether you lead business or IT units or are in the trenches, the analytics profession has likely crossed your mind. What does it entail? Who are true analysts? How does one become an analyst? Those of you specifically in a data management, data warehousing or business intelligence role may wonder how to further develop your analytics career. On the surface, an “analytics career” can be quite broadly d

IBM - Open Cloud Architecture

Cloud computing is changing the way we think about technology, and it’s no passing fad. Consumers are using the cloud to store music. Startups are turning to cloud to get up and running without huge investments. Big businesses and governments are relying on clouds to make more data more accessible.  Cloud computing. is changing how business and society run, and it's opening up huge avenues of innovation. We are looking at how developers are now combining systems of record with systems of engagement, and we see a new style of cloud-based application emerging. These are systems of interaction . For these applications to be sustainable, cloud computing needs to be built on open source and standards. Wide adoption of open source software and open standards should be everyone's goal. It means customers won’t have to

SAP HANA top Career Options to Find in Job Market

SAP HANA converges database and application platform capabilities in-memory to transform transactions, analytics, text analysis, predictive and spatial processing so businesses can operate in real-time. I have listed the areas on available careers for SAP HANA. SAP HANA  It has completely transformed the database industry by combining database, data processing, and application platform capabilities in a single in-memory platform. The platform also provides libraries for predictive, planning, text processing, spatial, and business analytics -- all on the same architecture. This makes it possible for applications and analytics to be rethought without information processing latency, and sense-and-response solutions can work on massive quantities of real-time data for immediate answers without building pre-aggregates. Simply put -- this makes SAP HANA the platform for building and deploying next-generation, real-time applications and analytics Operational Analytics With tr

4 Top Applications That Running From Cloud

Data Storage and Backup Box.com, Mozy, Joukuu are the applications offering data storage and backup services in cloud. Box.com offers drag and drop service for files. It just required to drop the files into Box and access from anywhere.  Mozy offers online backup service for files during a data loss. 1. Business Applications MailChimp - It offers an e-mail publishing platform. It is widely employed by the businesses to design and send their e-mail campaigns.  Chatter - Chatter app helps the employee to share important information about organization in real time. One can get the instant feed regarding any issue.  Google Apps - for Business Google offers creating text documents, spreadsheets, presentations, etc., on Google Docswhich allows the business users to share them in collaborating manner.  Quickbooks - It offers online accounting solutions for a business. It helps in monitoring cash flow, creating VAT returns and creating business reports. 2. Management A

Aws course contents ideas to learn

Image
What you are going to learn in AWS course is matter. So before you take the course just look at the course contents on aws.  AWS Course Contents for beginners What you will get after taking Aws course Recognize terminology and concepts as they relate to the AWS platform Navigate the AWS Management Console Understand the security measures AWS provides Differentiate AWS Storage options and create an Amazon Simple Storage Service (S3) bucket Recognize AWS Compute and Networking options and use Amazon Elastic Compute Cloud (EC2) and Amazon Elastic Block Storage (EBS) Describe Managed Services and Database options Use Amazon Relational Database Service (RDS) to launch an application Identify Deployment and Management options Intended Audience Individuals responsible for articulating the business benefits of AWS services Any individual who is new to AWS SysOps Administrators and Developers who are interested in using AWS services This course includes activities that will

Major Players in Cloud Computing

As of now the following are major players in cloud computing. Amazon.com is a web retailer and has the world's largest public cloud. Google operates a computing cloud built upon open source software which is optimized for Internet search.  Hewlett-Packard provides business printers with the capability to scan and store information within pods in cloud computing systems that combine servers, data storage, and management software in a single integrated package. IBM employs a hybrid commercial and open source cloud strategy developed from prototype projects with client companies and government agencies. Microsoft has a commercial software centric infrastructure for delivering cloud computing services. Oracle markets an engineered systems approach combining hardware and software it promotes as providing superior performance and security. NetSuite provides financial and resource planning functions. Salesforce.com sells cloud-based e-mail, computer storage, and customer managem

Cloud Computing - Career Options

Image
There is an explosion in both the use of cloud computing and the demand for people to assist in the mass migration to cloud. Indeed, there are about 50 to 70 jobs chasing truly qualified candidates at this point in time, according to technical recruiters. Photo Credit: Srini Roles in cloud computing IT pros with specific cloud skills IT pros with admin skills Cloud solution architect Skill set Expertise in Amazon web services Development skills in Google App engine Leading skill set AWS-amazon web services Microsoft Cloud Rackspace cloud Typical Cloud Computing certification programs IBM Certified Solution Advisor -- Cloud Computing Architecture IBM Certified Solution Architect -- Cloud Computing Infrastructure Microsoft Learning Google Apps Certified Deployment Specialist VMware Certified Professional (VCP) Certified Cloud Professional (CCP)

Analyst and Data Scientist Career Options

Image
 The following Skillset needed to succeed as Analyst or Data Scientist career. DTD Frame work: Understanding and hands on experience of Data to decisions frame work. SQL Skills: Experience to pull data from multiple sources. Hands on experience of Teradata, Oracle and Hadoop skills also useful Basic Statistics Techniques: Hands-on experience with basic statistical techniques: Profiling, Correlation analysis, Trend analysis, Sizing/Estimation, Segmentation Business Side Experience: Working with all business stake holders. Communication and influencing others. Advanced statistics: Hands-on comfort with advance techniques: Time Series, Predictive Analytics – Regression and Decision Tree, Segmentation (K-means clustering) and Text Analytics (optional) Read more