Data Analytics & AI | SQL Interviews | Power BI Resources
25.2K subscribers
304 photos
2 videos
151 files
316 links
๐Ÿ”“Explore the fascinating world of Data Analytics & Artificial Intelligence

๐Ÿ’ป Best AI tools, free resources, and expert advice to land your dream tech job.

Admin: @coderfun
Download Telegram
The GPT-4 model outperformed GPT-3 and GPT-3.5 language models
Oil bosses have big hopes for the AI boom

Data centres are fuelling demand for natural gasโ€”for now
This week 180,000 people descended on Abu Dhabi to attend ADIPEC, the global oil-and-gas industryโ€™s biggest annual gathering. This yearโ€™s focus, perhaps unsurprisingly, was the nexus of artificial intelligence (AI) and energy. On the eve of the jamboree Sultan Al Jaber, chief executive of ADNOC, the Emirati national oil giant, convened a private meeting of big tech and big energy bosses. A survey of some 400 energy, tech and finance bigwigs released in conjunction with the event concluded that AI is set to transform the energy business by boosting efficiency and cutting greenhouse-gas emissions.
๐Ÿ‘2
Decagon and OpenAI deliver high-performance, fully automated customer support at scale

Launched in 2023, Decagonโ (opens in a new window) has quickly become a key player in automating customer support for companies like Curology, BILT, Duolingo, Eventbrite, Notion, and Substack. OpenAIโ€™s models are crucial in their ability to deliver fast, reliable responsesโ€”without human intervention.

From enterprises to tech-forward startups, Decagon helps businesses globally handle millions of support conversations without sacrificing quality or speed. The company uses a combination of OpenAIโ€™s modelsโ€”including GPT-3.5, 4, 4o, 4 Turbo, and OpenAI o1-miniโ€”to deliver agentic bots that go beyond response generation and service the entire customer lifecycle.
โค1๐Ÿ‘1
โœ…๐Ÿ“-๐’๐ญ๐ž๐ฉ ๐‘๐จ๐š๐๐ฆ๐š๐ฉ ๐ญ๐จ ๐’๐ฐ๐ข๐ญ๐œ๐ก ๐ข๐ง๐ญ๐จ ๐ญ๐ก๐ž ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ญ๐ข๐œ๐ฌ ๐…๐ข๐ž๐ฅ๐โœ…

๐Ÿ’โ€โ™€๏ธ๐๐ฎ๐ข๐ฅ๐ ๐Š๐ž๐ฒ ๐’๐ค๐ข๐ฅ๐ฅ๐ฌ: Focus on core skillsโ€”Excel, SQL, Power BI, and Python.

๐Ÿ’โ€โ™€๏ธ๐‡๐š๐ง๐๐ฌ-๐Ž๐ง ๐๐ซ๐จ๐ฃ๐ž๐œ๐ญ๐ฌ: Apply your skills to real-world data sets. Projects like sales analysis or customer segmentation show your practical experience. You can find projects on Youtube.

๐Ÿ’โ€โ™€๏ธ๐…๐ข๐ง๐ ๐š ๐Œ๐ž๐ง๐ญ๐จ๐ซ: Connect with someone experienced in data analytics for guidance(like me ๐Ÿ˜…). They can provide valuable insights, feedback, and keep you on track.

๐Ÿ’โ€โ™€๏ธ๐‚๐ซ๐ž๐š๐ญ๐ž ๐๐จ๐ซ๐ญ๐Ÿ๐จ๐ฅ๐ข๐จ: Compile your projects in a portfolio or on GitHub. A solid portfolio catches a recruiterโ€™s eye.

๐Ÿ’โ€โ™€๏ธ๐๐ซ๐š๐œ๐ญ๐ข๐œ๐ž ๐Ÿ๐จ๐ซ ๐ˆ๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ๐ฌ: Practice SQL queries and Python coding challenges on Hackerrank & LeetCode. Strengthening your problem-solving skills will prepare you for interviews.
๐Ÿ‘4โค1
Coding is just like the language we use to talk to computers. It's not the skill itself, but rather how do I innovate? How do I build something interesting for my end users?

In a recently leaked recording, AWS CEO told employees that most developers could stop coding once AI takes over, predicting this is likely to happen within 24 months.

Instead of AI replacing developers or expecting a decline in this role, I believe he meant that responsibilities of software developers would be changed significantly by AI.

Being a developer in 2025 may be different from what it was in 2020, Garman, the CEO added.

Meanwhile, Amazon's AI assistant has saved the company $260M & 4,500 developer years of work by remarkably cutting down software upgrade times.

Amazon CEO also confirmed that developers shipped 79% of AI-generated code reviews without changes.

I guess with all the uncertainty, one thing is clear: Ability to quickly adjust and collaborate with AI will be important soft skills more than ever in the of AI.
๐Ÿ‘3
10 Tools for SQL Developers ๐Ÿ› ๐Ÿ“Š -

๐Ÿ“„ SQL Server Management Studio (SSMS) - Manage and query SQL Server databases
๐ŸŒ phpMyAdmin - Web-based tool for MySQL database management
๐Ÿ” DBeaver - Universal database management tool
๐Ÿ“Š Tableau - Data visualization and BI tool
โš™๏ธ SQL Workbench/J - Cross-platform SQL query tool
๐Ÿ” pgAdmin - Management tool for PostgreSQL
๐Ÿš€ Azure Data Studio - Lightweight and extensible data tool
๐Ÿ“ฆ Toad for SQL - Database development and administration
๐Ÿ“ˆ Datagrip - JetBrains SQL IDE for various databases
๐Ÿ“‚ HeidiSQL - Lightweight MySQL and MSSQL client

#SQLTools #DataAnalysis
๐Ÿ‘1
Quick comparison
๐Ÿ‘6โค1
Python List Methods
โค5๐Ÿ‘1
๐Ÿง  ChatGPT Learning Cheatsheet
๐Ÿ‘4
Useful Python for data science cheat sheets ๐Ÿ‘‡