Humans learn from past experiences, while Machines follow instructions. So, humans train machines to learn from past data and that’s what Machine Learning is all about. Machine learning is a subset of Artificial Intelligence. Machine learning enhance machines with the ability to learn autonomously based on observation and analysis within a given data set without specific …
1. Why do you want to be a Data Analyst? Answer: You should list why you love data, research what the company do with data, explain how you can create insights from data. 2. Where do you see yourself in 5years? Answer: Your answer should be how you can use your acquired experience to influence …
What is a Join in SQL? Inner join returns rows when there is at least one match in both tables while Left Join returns rows from the right and matched rows from the left table. Left join When to use Left Join Instead of Inner Join in SQL To choose which side of the table …
SQL DISTINCT clause is used to remove duplicate records. SELECT DISTINCT returns distinct(different) values. DISTINCT can be used with aggregate functions: COUNT, AVG, MAX, MIN. Syntax: SQL SELECT DISTINCT based on one column You can SELECT DISTINCT values from one column in a table. Below is the syntax. SQL SELECT DISTINCT based on multiple columns …
The SELECT statement in SQL is used to retrieve data from a database. Mostly used to retrieve all data in a table and data from desired table columns (fields). SELECT Syntax In the above syntax, you are selecting data from exact columns or fields indicated as column1, column2, column3 and so on. To select all …
A Database is a collection of unknown figures known as data. Databases are usually organized and un-organized data. Databases also contain rows(record) and columns(field). Company’s both large and small rely heavily on databases to power their applications. Databases store large amounts of data such as: user id’s, usernames, email addresses, healthcare data, product information, sales …
SQL stands for Structured Query Language. SQL is used to store, query, modify, manipulate and retrieve data stored in a relational database. Usually pronounced as “ess-que-ell”. According to ANSI (American National Standards Institute), it is the language for relational database management systems. All relational database systems (RDBMS) accept the use of SQL (MS Access, MySQL, …
In this blog, we will learn most asked interview questions and answers as regards to Microsoft Power BI. What is Power BI Power BI is an analytical tool for visualizing data by creating reports, dashboards, charts, graphs, data modelling and so on to enable user interpretation of data. Data can be imported into and exported …
In a data centered world, we find a lot of job opportunities as a Data Scientist or Data Engineer for most data-driven organizations. Both career paths are data-driven, analytical and problem solvers. Data scientist, data engineer, data analyst and business analysts are part of data analytics team and compliment each other based on their job …
SQL has become a powerful tool for data analysis and manipulation of data. The EOMONTH() function returns the last day of the month of a specified date. EOMONTH() can be used as a worksheet function (WS) in Excel. However, to get the last day of previous month in SQL can be achieved with the following SQL …