Data Sapien🧐

61 posts

Data Sapien🧐 banner
Data Sapien🧐

Data Sapien🧐

@DataDetective98

Data Analyst

Between SQL & Tableau Katılım Kasım 2021
250 Takip Edilen62 Takipçiler
Amazon Help
Amazon Help@AmazonHelp·
@DataDetective98 We're sorry to know you've received an incorrect item in the package. We'd like to help you with this. Please reach out to us via DM, and we'll do our best to assist. Further, please don't include any personal or account information. -Shabreen x.com/messages/compo…
English
1
0
0
12
Data Sapien🧐
Data Sapien🧐@DataDetective98·
I received wrong item instead of my order which is worth or 7,299 INR (new balance shoes). I raised a return request but the portal isnt reflecting it and not even one call was attempted from your side this is very disgrace and unhappy with your customer service. @amazonIN
English
1
0
0
47
Data Sapien🧐 retweetledi
பாக்டீரியா
பாக்டீரியா@Bacteria_Offl·
Jemimah ~ Firstly i want to thank jesus கிரிக்கெட் சங்கிஸ் :
பாக்டீரியா tweet media
English
53
419
5K
140.2K
Jobfound Remote Jobs 👨‍💻
Role - Data Analyst Est. Salary - $70k - $90k yearly Location - Remote - Analyze user behavior data - Develop and maintain dashboards Let us know if you are Interested 👇
English
63
16
157
16.5K
Jobfound Remote Jobs 👨‍💻
Role - Data Analyst Salary - $105,000 - $120,000 Annually Location - Remote - Excel - Create data visualizations and dashboards Let us know if you are Interested 👇
English
197
57
495
59.4K
Data Sapien🧐 retweetledi
DealzTrendz
DealzTrendz@dealztrendz·
#Giveaway Alert 🚨 We’re giving away the Apple iPhone 16 Pro Max 512 GB Steps to Enter ⬇️ 🔄 RETWEET ✅ FOLLOW 👉🏾 @dealztrendz We’ll pick 🔟 random followers & each will get a Apple iPhone 16 Pro Max 512 GB 만우절 GET SET GO 만우절 #DealzTrendzGiveaway
DealzTrendz tweet media
English
690
2.2K
1.8K
251.7K
Piyush Kumar
Piyush Kumar@Piyushkumar420·
SQL is difficult to learn, but not anymore! Introducing Complete SQL Training Course, All Queries, Tips & Tricks , shortcuts Absolutely Free It helps you to save 80% time and money 🤑 To get it, just: 👉 Like and Repost. 👉Comment "SQL" 👉Follow me (must) to Dm you download link🖇️ #SQL #SQLCourses #courses
Piyush Kumar tweet mediaPiyush Kumar tweet media
English
218
176
616
57.8K
Data Sapien🧐 retweetledi
Deeksha
Deeksha@deekshas24·
#Interviews Two scenario-based SQL Interview questions ! Question 1: Scenario: You have a table called "orders" with columns "order_id", "customer_id", "order_date", and "total_amount". Write a query to find the customers who have placed an order in the last 30 days, but not in the last 14 days. Answer: ``` SELECT customer_id FROM orders WHERE order_date BETWEEN DATEADD(DAY, -30, GETDATE()) AND DATEADD(DAY, -14, GETDATE()) GROUP BY customer_id HAVING COUNT(order_id) > 0; ``` Question 2: Scenario: You have a table called "products" with columns "product_id", "product_name", "price", and "product_category". Write a query to find the products that have a price greater than the average price of all products in their category, but less than the maximum price in their category. Answer: ``` SELECT p1.product_id, p1.product_name, p1.price FROM products p1 JOIN ( SELECT product_category, AVG(price) AS avg_price, MAX(price) AS max_price FROM products GROUP BY product_category ) p2 ON p1.product_category = p2.product_category WHERE p1.price > p2.avg_price AND p1.price < p2.max_price; ```
English
8
88
457
44.2K
Kevin Heintz
Kevin Heintz@AskCoachKev·
LOSE STUBBORN BELLY FAT I wrote a comprehensive guide you can use to shred unwanted fat in 8 weeks. Comment "8" and I'll send you a free copy. (taking this down in 24hrs. must be following me or you wont receive it)
English
806
34
426
221.6K
Atul Kumar
Atul Kumar@atulkumarzz·
If you’re interested in learning all of these 𝗙𝗥𝗘𝗘 ( 100TB Drive ) 📝Product management + MBA 📝Project management + 𝗣𝘆𝘁𝗵𝗼𝗻 📝Business Analytics + 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 📝Data visualization + AWS Certified 📝Microsoft Excel + Ethical Hacking 📝𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀+ Cloud Computing 📝UI/UX+ 𝗘𝗫𝗖𝗘𝗟 + CYBER SECURITY 📝𝗦𝗤𝗟 +Advance Excel + Power Bi 🗃️Steps - (72 Hours 🚨) 1. Follow me for DM @atulkumarzz 2. Like & repost 3. Comment " FREE " #course #free #books #excel #SQL
Atul Kumar tweet media
English
572
292
453
32.4K
Atul Kumar
Atul Kumar@atulkumarzz·
Data Analytics from Zero to Expert Free Course😱🤯 A Udemy Complete Paid Course for Free.👇 Limited Time(24 Hours Only) This Course covers; -Excel -SQL -Tableau -Many more... Simply:- 1. Must follow @atulkumarzz to get Link 2. Like and Repost 3. Type "course" & get Link in DM
Atul Kumar tweet media
English
1.4K
795
1.5K
203.6K
Data Sapien🧐 retweetledi
Shalini Tewari
Shalini Tewari@maybeshalinii·
In which order SQL queries run?🔎👇 In SQL, the order in which queries are processed is typically defined by the logical query processing order. The logical query processing order is different from the order in which the SQL statements are written in the query. Here is the general logical order in which SQL queries are processed: 1. FROM clause: The data sources (tables, views, etc.) specified in the FROM clause are processed first. This involves reading the data from the tables and combining data from multiple sources if there are joins. 2. WHERE clause: The WHERE clause is applied to filter the rows based on the specified conditions. Rows that do not meet the criteria in the WHERE clause are excluded from further processing. 3. GROUP BY clause: If a GROUP BY clause is present, rows are then grouped based on the specified columns. Aggregate functions (like SUM, COUNT, AVG) are then applied to each group. 4. HAVING clause: If a HAVING clause is present, it filters groups based on aggregate conditions. Groups that do not meet the criteria in the HAVING clause are excluded. 5. SELECT clause: The SELECT clause is then applied to the result set. Columns are selected, and expressions are computed. 6. ORDER BY clause: If an ORDER BY clause is present, the result set is then sorted based on the specified columns. 7. LIMIT/OFFSET (if applicable): If there is a LIMIT or OFFSET clause (used in some database systems), the final result set is then limited or offset accordingly.
Shalini Tewari tweet media
English
4
297
1.7K
198.2K
Data Sapien🧐 retweetledi
Dr. Senthazal Ravi
Dr. Senthazal Ravi@senthazalravi·
செயற்கை நுண்ணறிவியல் நுட்பங்களை மாணவர்கள் கற்க விரும்பினால் இலவசமாக மைக்ரோ சாப்ட் வழங்கும் ஏ.ஐ பாடங்களை படிக்கலாம். இதோ சுட்டி microsoft.github.io/AI-For-Beginne…
தமிழ்
4
205
583
78.2K
Data Sapien🧐 retweetledi
Ezekiel
Ezekiel@ezekiel_aleke·
Everyone should learn EXCEL irrespective of your profession. It will put you ahead of the curve. Here are 5 YouTube videos that will help you master Excel:
English
11
662
2.2K
333K
Data Sapien🧐 retweetledi
Sasi 📊📈
Sasi 📊📈@freest_man·
Power BI for Data Science Complete Study Plan 10 hours a week to dedicate to this, here's a 12-week study plan Week 1: Introduction to Power BI Day 1-3: Begin with the official Power BI Guided Learning resources to get familiar with the platform. Link: learn.microsoft.com/en-us/training… Day 4-7: Watch the "Getting Started with Power BI" series Link: youtube.com/watch?v=Vqz2d7… Week 2: Data Loading and Transformation Day 1-4: Explore the Power Query Editor and learn how to load and transform data. youtube.com/watch?v=TF0sGX… Day 5-7: Watch the tutorial on data transformation in Power BI youtube.com/watch?v=PiFAa_… Week 3: Building Visualizations Day 1-4: Dive into creating basic visualizations like tables, charts, and maps using the official documentation. [youtube.com/watch?v=Df81Tj…!) Day 5-7: Watch tutorials on creating all the visuals youtube.com/watch?v=GYpiIs… Week 4: Advanced Visualizations Day 1-4: Explore the advanced Power BI tutorials youtube.com/watch?v=ppD-jK… Day 5-7: Watch tutorials on including custom visuals and slicers. Customer Visuals: youtube.com/watch?v=x_tSlW… Slicers: youtube.com/watch?v=-xl-uh… Week 5: Data Modeling and DAX Day 1-4: Learn about data modeling and the DAX language Dax: youtube.com/watch?v=waG_Jh… Data Modelling: youtube.com/watch?v=1Z_f6j… Day 5-7: Watch DAX tutorials on Power BI's YouTube channel. youtube.com/watch?v=sCAQtq… Week 6: Dashboard Design, Publishing And Project Explore dashboard creation, Design, and publishing options in Power BI. Design: youtube.com/watch?v=Lfzu74… Publish: youtube.com/watch?v=KpZPUd… Project: youtube.com/watch?v=pixlHH… Throughout your study plan, remember to practice what you learn by working on personal projects or datasets related to your data science field. - - - That’s all for now! - Smash the LIKE button and REPOST - BOOKMARK because you’ll definitely want to revisit this again - Follow me for more posts like this
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
YouTube video
YouTube
Sasi 📊📈 tweet media
English
9
241
854
168.9K