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

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