Data Analytics

Storytelling: You Can learn to Tell Stories Effectively 👇👇 https://t.me/udemy_free_courses_with_certi/1515 [Free for limited time only] Good to build your story telling skills which will be useful when added with visualization 😄👍

Data Analyst Interview Questions 1. Is indentation required in python? Indentation is necessary for Python. It specifies a block of code. All code within loops, classes, functions, etc is specified within an indented block. It is usually done using four space characters. If your code is not indented necessarily, it will not execute accurately and will throw errors as well. 2. What are Entities and Relationships? Entity: An entity can be a real-world object that can be easily identifiable. For example, in a college database, students, professors, workers, departments, and projects can be referred to as entities. Relationships: Relations or links between entities that have something to do with each other. For example – The employee’s table in a company’s database can be associated with the salary table in the same database. 3. What is a stored procedure? Stored Procedure is a function consists of many SQL statements to access the database system. Several SQL statements are consolidated into a stored procedure and execute them whenever and wherever required. 4. What is Auto Increment? Auto increment keyword allows the user to create a unique number to be generated when a new record is inserted into the table. AUTO INCREMENT keyword can be used in Oracle and IDENTITY keyword can be used in SQL SERVER. Mostly this keyword can be used whenever PRIMARY KEY is used. 5. Which operator is used in query for pattern matching? LIKE operator is used for pattern matching, and it can be used as -. 1. % – Matches zero or more characters. 2. _(Underscore) – Matching exactly one character.

Data Analyst Interview Questions 1. What are Support Vectors in SVM? A Support Vector Machine (SVM) is an algorithm that tries to fit a line (or plane or hyperplane) between the different classes that maximizes the distance from the line to the points of the classes. In this way, it tries to find a robust separation between the classes. The Support Vectors are the points of the edge of the dividing hyperplane. 2. Explain Correlation and Covariance? Covariance signifies the direction of the linear relationship between two variables, whereas correlation indicates both the direction and strength of the linear relationship between variables. 3.What is the cluster sampling techniques used for sampling? Cluster sampling also involves dividing the population into sub-populations, but each subpopulation should have analogous characteristics to that of the whole sample. Rather than sampling individuals from each subpopulation, you randomly select the entire subpopulation. 4. What is P-value? P-values are used to make a decision about a hypothesis test. P-value is the minimum significant level at which you can reject the null hypothesis. The lower the p-value, the more likely you reject the null hypothesis.

Requirements for data analyst based on some job profiles from @getjobss channel 👉 Strong data handling, data modeling & data flow understanding 👉 Ability to write complex queries on SQL to manipulate, consolidate multiple data sources for the purpose of dashboarding and analysis 👉 Intuition for data and ability to handle big data sources 👉 Strong working knowledge in Excel and visualization tools like PowerBI, Tableau, QlikView 👉 Ability to work on ambiguous tasks, find suitable solutions, and seek help/advice where appropriate.

Some basic concepts regarding data and database Data is representation of the facts, measurements, figures, or concepts in a formalized manner having no specific meaning. Database is an organized collection of the data stored and can be accessed electronically in a computer system. DBMS are software systems that enable users to store, retrieve, define and manage data in a database easily. RDBMS is a type of DBMS that stores data in a row-based table structure which connects related data elements. SQL is a database query language used for storing and managing data in RDBMS.

Google is hiring Data Analyst! 👇👇 https://t.me/getjobss/1043

Ways to improve the performance of Tableau 👉🏻 Use an Extract to make workbooks run faster. 👉🏻 Reduce the number of marks on the view to avoid information overload. 👉🏻 Hide unused fields. 👉🏻 Use Context filters. 👉🏻 Use indexing in tables and use the same fields for filtering. 👉🏻 Remove unnecessary calculations and sheets.