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.
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.
👍13❤3👌1
How to Prepare for a Business Analyst Interview
Whether you are a new graduate or already having working experience, we are ready with the best solutions for your interview. From having memorized all basic business analyst interview questions to figuring out how to interview an economist, for example, you can be sure that this article will cover them all in one go.
In order to be well-prepared for an interview, it is mandatory to first be well-acquainted with the role of the business analyst. Business analysts close the gulf between IT and company by using data analytics to appraise processes, determine necessities, and make suggestions based on data. They take on the main part of advising institutions to take informed decisions and improve their own operations.
The main duties of a business analyst are:
Recognizing and evaluating the business problems
Collecting and recording the requirements
Producing a detailed business analysis
Communicating the results to the stakeholders
Implementing and testing the solutions
Read more: https://datasimplifier.com/how-to-prepare-for-a-business-analyst-interview/
Whether you are a new graduate or already having working experience, we are ready with the best solutions for your interview. From having memorized all basic business analyst interview questions to figuring out how to interview an economist, for example, you can be sure that this article will cover them all in one go.
In order to be well-prepared for an interview, it is mandatory to first be well-acquainted with the role of the business analyst. Business analysts close the gulf between IT and company by using data analytics to appraise processes, determine necessities, and make suggestions based on data. They take on the main part of advising institutions to take informed decisions and improve their own operations.
The main duties of a business analyst are:
Recognizing and evaluating the business problems
Collecting and recording the requirements
Producing a detailed business analysis
Communicating the results to the stakeholders
Implementing and testing the solutions
Read more: https://datasimplifier.com/how-to-prepare-for-a-business-analyst-interview/
👍8❤1👏1🤔1
If you’re trying to get a job in data analytics, simplify your roadmap through SPN(skills, portfolio, network) Method:
1. Learn the Skills :-
What to Learn: Focus on mastering SQL, Excel, and a data visualization tool like Tableau or Power BI.
How to Learn: Utilize online resources, tutorials, and practice exercises to hone your skills.
2. Build Your Portfolio :-
Why it's Important: A portfolio showcases your abilities to potential employers.
How to Build: Create a free website using platforms like Wix or Wordpress.
What to Include: Write-ups of your projects, detailing the business problems you've tackled and the methods you've used. Provide links to your code and dashboards.
3. Expand Your Network :-
Why Network: Building connections increases your chances of landing a job.
Where to Network: Connect with professionals on LinkedIn, attend local data meetups, and engage in industry-related events.
How to Network: Interact genuinely with others, avoiding spammy or impersonal outreach tactics.
4. Stay Positive and Persistent:-
Why it Matters: Job hunting can be challenging, but maintaining a positive attitude and persevering is key.
How to Stay Motivated: Believe in your abilities and keep pushing forward despite obstacles.
Conclusion: Keep Going!
Final Encouragement: You've got what it takes. Keep learning, networking, and persevering. You'll reach your goals!
If it's useful give us 👍
1. Learn the Skills :-
What to Learn: Focus on mastering SQL, Excel, and a data visualization tool like Tableau or Power BI.
How to Learn: Utilize online resources, tutorials, and practice exercises to hone your skills.
2. Build Your Portfolio :-
Why it's Important: A portfolio showcases your abilities to potential employers.
How to Build: Create a free website using platforms like Wix or Wordpress.
What to Include: Write-ups of your projects, detailing the business problems you've tackled and the methods you've used. Provide links to your code and dashboards.
3. Expand Your Network :-
Why Network: Building connections increases your chances of landing a job.
Where to Network: Connect with professionals on LinkedIn, attend local data meetups, and engage in industry-related events.
How to Network: Interact genuinely with others, avoiding spammy or impersonal outreach tactics.
4. Stay Positive and Persistent:-
Why it Matters: Job hunting can be challenging, but maintaining a positive attitude and persevering is key.
How to Stay Motivated: Believe in your abilities and keep pushing forward despite obstacles.
Conclusion: Keep Going!
Final Encouragement: You've got what it takes. Keep learning, networking, and persevering. You'll reach your goals!
If it's useful give us 👍
👍20❤1
✅YouCine - v1.13.1 [New version AD-FREE]⭐
⬇️ Mobile Download Link👇👇👇
https://app.youcine.vip/app/signyoucinemobile_Analyst-group.apk
✅ No ads / Ads-Free
✅ Unlimited free content
✅ Secure and virus-free
✅ Exclusive live streaming content
✅ Download Resources Offline
⬇️TV Download Link👇👇👇
https://app.youcine.vip/app/cinetv_Analyst-group.apk
📺Including STAR+, PRIME VIDEO, NETFLIX, HBO MAX, DISNEY+...
🚩 No paid subscription is required to access the channel's live content. Series and movies, sports, hot content 😍and much more... it's all there.🔥
⬇️ Mobile Download Link👇👇👇
https://app.youcine.vip/app/signyoucinemobile_Analyst-group.apk
✅ No ads / Ads-Free
✅ Unlimited free content
✅ Secure and virus-free
✅ Exclusive live streaming content
✅ Download Resources Offline
⬇️TV Download Link👇👇👇
https://app.youcine.vip/app/cinetv_Analyst-group.apk
📺Including STAR+, PRIME VIDEO, NETFLIX, HBO MAX, DISNEY+...
❤3👍3
Avoid directly copying YouTube projects onto your resume because if everyone looks the same, recruiters might discard resumes.
Instead, for eg, let's say you are working on a SQL case study, download a dataset from Kaggle (usually a CSV file), set up a Postgre/MySQL database, connect it with the data, and prompt ChatGPT with questions ranging from basic to advanced SQL.
Solve the questions step by step. When using PowerBI, connect to the database and create a compelling dashboard. Don't just upload the dataset; employ DAX queries, statistical functions, and avoid relying solely on drag-and-drop features. Use Formatting section to do creative stuff and add your unique element in the project.
ENJOY LEARNING 👍👍
Instead, for eg, let's say you are working on a SQL case study, download a dataset from Kaggle (usually a CSV file), set up a Postgre/MySQL database, connect it with the data, and prompt ChatGPT with questions ranging from basic to advanced SQL.
Solve the questions step by step. When using PowerBI, connect to the database and create a compelling dashboard. Don't just upload the dataset; employ DAX queries, statistical functions, and avoid relying solely on drag-and-drop features. Use Formatting section to do creative stuff and add your unique element in the project.
ENJOY LEARNING 👍👍
👍33❤11
Forwarded from Data Analytics
Do you want complete checklist to learn Excel, SQL, Tableau, Python & Power BI for FREE?
Anonymous Poll
97%
Yes
3%
No
❤1
One of the most common interview question in #sql round. What is the order of execution of the below #query:
""""Query""""""
Select product_id,
product_rank
(
SELECT product_id,
rank() over(order by total_sales_amount desc) as product_rank
FROM sales_info
)
WHERE product_rank <= 5
order by product rank desc;
""""Query""""""
Select product_id,
product_rank
(
SELECT product_id,
rank() over(order by total_sales_amount desc) as product_rank
FROM sales_info
)
WHERE product_rank <= 5
order by product rank desc;
👍9❤3
🥳🚀When delving into data analytics and initiating your SQL journey, prioritize mastering the fundamental concepts that address the majority of problems before delving into other topics.
👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX
👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)
👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions
👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS
Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences
👉🏻CTE
👉🏻Views & Triggers (optional)
Amazing resources to learn & practice SQL: https://t.me/sqlanalyst/195
Hope it helps in your SQL learning 📚
👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX
👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)
👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions
👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS
Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences
👉🏻CTE
👉🏻Views & Triggers (optional)
Amazing resources to learn & practice SQL: https://t.me/sqlanalyst/195
Hope it helps in your SQL learning 📚
👍12👏2
Forwarded from Data Analytics
Thank you so much everyone for the awesome response. I have created an entire checklist to learn SQL, Power BI, Excel, Python & Tableau.
You can access Free Checklist here.
Like this post if it helps 👍❤️
I'll try bringing more resources like these in the future to help you as much as I can.
Share with credits: https://t.me/sqlspecialist
You can access Free Checklist here.
Like this post if it helps 👍❤️
I'll try bringing more resources like these in the future to help you as much as I can.
Share with credits: https://t.me/sqlspecialist
👍24👌5❤3🎉1