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

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

How to Write Python 'Hello World' Program Quickly and Run it

Image
The first Python program looks like the below.  I have explained the steps you need to write your first program in Python. My first program: odbchelper.py You can write your program as nameccheck.py module. if authorsFirstName == 'Irv':       teachingPython = True       print 'Pay attention to his wisdom' How to Run Your Python Program python namecheck.py Sample python program if authorsFirstName == 'Irv':      teachingPython = True    print 'Pay attention to his wisdom' The above if condition checks for first name.  In python '==', means equal to. It makes true to teachingPython .  You can start your python program quickly. Really useful for learning and to use it in projects.

5 Top Code Format Tools

I have given in this post the list of code formatting tools. These are useful to write better code. 5 Top Code Format Tools SQL Formatter - This tool helps you format your SQL Queries instantly. Java Code format Tool - This tool is one of the best tool to format your JAVA code instantly. Python Code Format Tool - This tool is famous Python online code format tool. CSS Code format Tool - The best tool to format your CSS code so nicely JavaScript Code Format Tool - This is one of the best tool to format your JavaScript code

How to use Python Interactive Shell in an easy way

It's like this: Python leads a double life. It's an interpreter for scripts that you can run from the command line or run like applications, by double-clicking the scripts. What is Interactive Shell? But it's also an interactive shell that can evaluate arbitrary statements and expressions. This is extremely useful for debugging, quick hacking, and testing. I even know some people who use the Python interactive shell in lieu of a calculator!  Launch the Python interactive shell in whatever way works on your platform, and let's dive in with the steps shown here: First Steps in the Interactive Shell >>> 1 + 1 ❶ 2 >>> print 'hello world' ❷ hello world >>> x = 1 ❸ >>> y = 2 >>> x + y 3 ❶ The Python interactive shell can evaluate arbitrary Python expressions, including any basic arithmetic  expression. ❷ The interactive shell can execute arbitrary Python statements, including the print s

Python Command Line Options List

The complete list of command line options -b Issue warnings for calling str() with a bytes or bytearray object and no encoding argument, and comparing a bytes or bytearray with a str. Option -bb issues errors instead. -B Do not write .pyc or .pyo byte-code files on imports. -d Turn on parser debugging output (for developers of the Python core). -E Ignore Python environment variables described ahead (such as PYTHONPATH). -h Print help message and exit. -i Enter interactive mode after executing a script. Hint: useful for postmortem debugging; see also pdb.pm(), described in Python’s library manuals. -O Optimize generated byte code (create and use .pyo byte-code files). Currently yields a minor performance improvement. -OO Operates like -O, the previous option, but also removes docstrings from byte code. -q Do not print version and copyright message on interactive startup (as of Python 3.2). -s Do not add the user site directory to the sys.path module search path. -S Do not imply “impor

5 Top Features People Need Today in Modern Devices

Image
S mart devices in the current world play a key role. It is because these have better features to help people. In this post, I shared the top features people expect in smart devices. Now the world is mature enough to design devices and connect them with some intelligence and should give some benefit to users. Intelligence in the Modern Devices. Devices installed with Software, you can call Intelligent things. Modern devices nowadays have intelligence.  People look at Smart things is the problem-solving approach . At the same time, smart things should generate revenue. List of Smart Devices. There are many smart devices already in the market. For example, smartphones, smart appliances, Shoes, watches, and more.  The real requirement is increasing user experience in those devices. Design companies are advising their departments to implement high user experience in their devices.  For example smart cameras, advice on personal and financial matters. Features People Need in Mo

Top Skills You Need to Develop a modern App

Image
The development of mobile applications provides many job opportunities. In today’s mobile world intelligent apps play a crucial role. Modern Intelligent apps. To understand correctly intelligent apps now ruling the world. They started 60 years ago, and they are now in a mature stage.  Due to the increasing usage of mobile phones, the importance of Artificial Intelligence apps came into the limelight again. Intelligent apps usage is quite a lot. The key applications are Voice to text , Text to Voice, and Image recognition. Application of Intelligent Apps. Planning Vision Voice recognition Natural Language Processing Self-driving cars Help to physical Disabled people Role of Robotics. Agriculture needs many robots. They can work even in the rainy season. The construction field needs many robots to work on roof-tops.  Deep-ocean where Robots requires for exploration of oil and pearls.  Top Examples of Intelligent Apps. PowerVocab  UnlockyourBrain  TED  Casual

7 Amazing Ideas to Make Resume for First Job

Image
Resume writing is a skill. Out of a thousand applications, only a few would shortlist for the next process. Here are my ideas to provide in your resume before you send it out. Resume format How to make resume format Give Mobile number and E-mail on the top of your resume. Use MS-word to format it. Organize information using bullets wherever the need. Check Spell and Grammar. Two pages are ideal for any type of job. 7 Amazing ideas Detailed resume ideas Provide genuine-experience. Transferable skills such as Public-speaking, Customer-communication - good to mention. Provide previous experience in reverse order - last-in-first. Keep educational qualification after the experience. No need to mention weaknesses. Add awards you received during your employment. Not required salary details.

Top Tips You Need to Create Mobile Apps

Image
Before you start creating mobile applications, you need to understand two things. There are two mobile application types. Namely Native and Web applications. Mobile applications are two types.Those are Native and Web applications.   Photo Credit: Srini Native applications Each mobile operating system you need to create one version. Native applications are platform dependent. The disadvantage is you need to create multiple versions. Develop apps only on that platform These apps not portable Web applications The web applications are platform independent. They work for all mobile operating systems. These applications are browsable using any popular browsers. These apps are browsable from any popular web browsers 4 Top Mobile Platforms iOS  Android  Windows Phone 7  Blackberry OS  4 Top Tablet Platforms iOS  Android  Blackberry OS  Windows 8 Related Learn Android app quickly and your own time