Posts

Showing posts from November, 2016

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

How to Execute Commands in R Language

Image
The next step after installing R is how to run commands. You can run directly by entering commands. The other way is you need to write an R script, that contains all the series of commands. The benefit of the script is you can save your commands, it saves your time. Second, as a script, you can run it whenever you need. #How to Run-commands in R: Executing Commands in R Commands can be entered directly into the R console (the window that opens when you start R), following the red > prompt, and sent to the computer by pressing enter. For example, typing 1 + 2 and pressing enter will output the result 3: > 1+2 [1] 3 Your entered code always follows the > prompt, and output always follows a number in square brackets. Each command should take its own line of code, or else a line of code should be continued with { }  It is possible to press enter before the line of code is completed, and often R will recognize this. For example, if you were to type 1 + but then pr

PostgreSQL is beyond NoSQL database

Image
The PostegreSQL is a popular database for web applications. You can manage user data in this database conveniently. #postgreSQL What is PostgreSQL Web applications started using NoSQL databases. PostgreSQL is updating their database to meet the requirements of web applications. So PostgreSQL is almost equal to NoSQL database. Java Script PostgreSQL supports  JSON (JavaScript Simple Object Notation) . JSON is portable data format to share data. The MongoDB follows JSON. PostgreSQL's structured format for saving JSON, called JSONB, eliminates the need for restructuring a document before it is committed to the database. Benefits  PostgreSQL is similar to MongoDB to ingest documents  PostgreSQL follows ACID compatibility  PostgreSQL have all the features and options to edit JSON data.

5 Tableau Features Useful for Data Analytics

Image
Below are the top Tableau features for data analytics. Tableau 9 for Data Science engineers. CONNECTING TO LOCAL FILE  Tableau can connect to any local file or database such as Excel  Text File Access  Statistical File, or  Another Database file CONNECTING TO SERVER Tableau can connect to your data server too. It can connect to almost any type of data server. Below are some of the most popular databases that Tableau can connect: Tableau Server Google Analytics Google BigQuery Hortonworks Hadoop Hive MapR Hadoop Hive IBM DB2 IBM BigInsights IBM Netezza Microsoft SQL Server Microsoft Analysis Services Oracle Oracle Essbase MySQL PostgreSQL SAP While working on Tableau, data can have Live Connection where any change in the source data will be automatically updated in Tableau. On the other hand, data can be Extracted to the Tableau repository so that any change made here will not affect the original source data. CONNECTING TO EXCEL FILE To connect

My 4 Top Books Success, Life, Money, Mind Power

Image
Four ultimate books I have collected after asking many seniors and experienced people. Based on their valuable suggestions I have added these books to my reading table. Simply nice collection. Even now I read these books regularly. Get these and you too can benefit. A book that has valuable information can be read by readers on a daily basis. As said, sometimes difficult to get all the information at one time. So many professionals read daily. Just grab the below collection to your next goal. Photo credit: Srini 👍 1. Greatness Guide 2 - Robin Sharma The Greatness Guide is a strikingly powerful and enormously practical handbook that will inspire you to get to world-class in both your personal and professional life. Written by Robin Sharma, one of the planet's top success coaches and a man whose ideas have been embraced by celebrity CEOs, leading entrepreneurs, rock stars and royalty, as well as by many Fortune 500 companies, the Greatness Guide contains a proven formula

7 Features of Tableau Self-service Engine

Image
Tableau introduced the Self-Service tool. This Tool helps user queries while importing data from multiple sources. This project is called Project Maestro . This is an additional feature for the data analysis engine. Self-Service Engine in Tableau The visual ways of inspecting, joining and editing data. Results could then be piped into Tableau for analysis. Speedier data import and analysis. Tableau's new data engine works based on Hyper technology. You can see now faster to import and analyze large data sets with Tableau. Hundreds of thousands of records being imported per second, as well as being visualized in real-time as the import process continued. This engine developed based on feedback from the user community. It supports natural language queries. Tableau is aiming for true natural speech, not merely being able to type in questions that require using exact field names and functions. The example is you can ask questions like Tell me the cheapest houses in near Calif

Data analyst in FMCG sector the real opportunities

Image
[Demand for data analytics in FMCG] Data analyst is a great demanding career in FMCG sector. The below are the key areas where data analytics can be applied in FMCG sector. There are many areas in FMCG sector one can get great insights. I have given some most useful thought that are being used in FMCG industry. The data engineer /Scientist must have great business knowledge to get true insights. However, as a software developer, this is just a working on analytics software as per guidelines prescribed by data scientists. Consumers  Business questions: Where are your consumers? Can you identify the characteristics that bond your consumers to the brands they buy? Can you segment your consumers using those characteristics and create a consumer purchase decision tree? Can you access and translate the sentiment that your customers are saying about your company, your products and your customer service? Can you share data with your retail and convenience store customers on a regul

How to Run First Program in Python

When you are a first-time learner of Python, the below commands you can try on windows Python-interpreter. Python is a powerful and multipurpose language. At the highest level, Python is an interpreted language. And you don't need declarations for: Variables Methods Parameters Functions You don't need a compiler. During the run-time, the Python interpreter validates the code and shows-up errors. How to Run First Program in Python. $ python ## Run the Python interpreter Python 2.7.9 (default, Dec 30 2014, 03:41:42) [GCC 4.1.2 20080704 (Red Hat 4.1.2-55)] on linux2Type "help", "copyright", "credits" or "license" for more information. >>> a = 6 ## set a variable in this interpreter session >>> a ## entering an expression prints its value 6 >>> a + 2 8 >>> a = 'hi' ## 'a' can hold a string just as well >>> a'hi' >>> len(a) ## call th