Road Map for being a Data Analyst

Welcome to the new blog :-) In this blog I will tell you what's basic difference between formulas(formulae) and functions while using Excel. For an example,  Formulas are like homemade pizza where we can add things with variety and quantity by our own taste. AND  Functions are like pizza from Domino's or Pizza Hut, where we just tell name, size or extra cheese(all the arguments). Not fully customized. It is fine to make single or double topping pizza at home (formulas using operators only). But as we all know most of the time we have lack of experience, lack of ingredients (options) at home to make pizza (formula writing) Which makes the pizza bit different from Domino's and even less tasty(functional). At this point readymade pizza come more handy so we order it(use functions which are inbuilt) Definitions :- Formula :   A set of instructions used to perform a calculation using the data in a spreadsheet. Example of formula :- = (B3+A2)*5 Function :  A preset command...

                    Welcome to the blog where I will tell you how everything works in analysis using R, It is just an overview but you will come to know relation between R and data analysis. This blog will also make you fearless to start with R. So let's start, R is a programming language we all know this, but you will be glad to know it is language which is specially made to analyze the data. The thing is from where to start right ? First see benefits of using R: 1. It is easy to learn language even if you have no coding or technical background. 2. It is like super-market where you will find every tool for analysis. 3. It is one stop solution where we analyze data, make visualization and create documentation. 4. It is open source or free to use. 5. Strong community make it easy to find solutions if you stuck somewhere. Ok, Ok starting how to start and how everything works, first you will go online online to R studio cloud or y...

Welcome again everyone,  Today we are gonna touch the upper surface of usage of SQL in data analysis.  SQL Stands for Structured Queries Language. It is language which we use to talk with database. Each line of code is called query.  It is like talking to someone in his/her regional language and asking for some work to done.  We request database to do a work for us in database language (SQL) and take the outcome.  Cool so this was the concept of SQL.  Now how we use it.  It has very less syntex and spaces don't matter in SQL Let's see a small query SELECT *  FROM database.dataset.table WHERE  Attribute = "varchar" In this query we are using * for selecting all the columns. In FROM we selected table WHERE give a condition to see table. There are a lot of different functions in SQL, following are few common functions- - SELECT -WHERE -SELECT -ORDER BY -CAST -DISTINCT  -COUNT  -LIMIT There is also concept of subqueries, whi...