Data Analytics

Important Topics which you should know to learn SQL 👇👇 https://t.me/free4unow_backup/455

Tricky question, lets see how many of you are able to answer it correctly 😁

Data Analyst Interview Questions [Python, SQL, PowerBI] 👇👇 https://t.me/datasciencefun/800

Good to see 500+ subscribers interested in learning SQL and Python. These are very useful skills if you are aiming for data analytics domain 😄👍

Here are the different ways to create views in Tableau 👇👇 Drag fields from the Data pane and drop them onto the cards and shelves that are part of every Tableau worksheet. Double-click one or more fields in the Data pane. Select one or more fields in the Data pane and then choose a chart type from Show Me, which identifies the chart types that are appropriate for the fields you selected. Drop a field on the Drop field here grid, to start creating a view from a tabular perspective.

Important topics which you should know to learn Tableau 👇👇 https://t.me/free4unow_backup/453

Q. Explain the data preprocessing steps in data analysis. Ans. Data preprocessing transforms the data into a format that is more easily and effectively processed in data mining, machine learning and other data science tasks. 1. Data profiling. 2. Data cleansing. 3. Data reduction. 4. Data transformation. 5. Data enrichment. 6. Data validation. Q. What Are the Three Stages of Building a Model in Machine Learning? Ans. The three stages of building a machine learning model are: Model Building: Choosing a suitable algorithm for the model and train it according to the requirement Model Testing: Checking the accuracy of the model through the test data Applying the Model: Making the required changes after testing and use the final model for real-time projects Q. What are the subsets of SQL? Ans. The following are the four significant subsets of the SQL: Data definition language (DDL): It defines the data structure that consists of commands like CREATE, ALTER, DROP, etc. Data manipulation language (DML): It is used to manipulate existing data in the database. The commands in this category are SELECT, UPDATE, INSERT, etc. Data control language (DCL): It controls access to the data stored in the database. The commands in this category include GRANT and REVOKE. Transaction Control Language (TCL): It is used to deal with the transaction operations in the database. The commands in this category are COMMIT, ROLLBACK, SET TRANSACTION, SAVEPOINT, etc. Q. What is a Parameter in Tableau? Give an Example. Ans. A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines. For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter.