Walter Hartman - People Leader’s Post

Good Morning Data and LinkedIn Fam, I quickly want to drop this here knowing that my day will be packed and I might not have time for study or to make a post later in the day and yes, my brain is very active right now, so why not 😊 So, this morning I worked on the ORDER BY clause, ORDER BY is basically used for sorting out your data by columns, so I will just say it basically 'Sort Out'. The ORDER BY is accompanied by ASC and DESC (Ascending and Descending). This is basically it guys, any correction or input is welcome. Have a most Beautiful Friday 😇 #dataanalytics #sql #dataanalysts #learning

Once you've learned/mastered the fundamentals of SQL, try learning these: - 𝐉𝐎𝐈𝐍𝐬: LEFT, RIGHT, INNER, OUTER joins. - 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐞 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬: Utilize SUM, COUNT, AVG, and others for efficient data summarization. - 𝐂𝐀𝐒𝐄 𝐖𝐇𝐄𝐍 𝐒𝐭𝐚𝐭𝐞𝐦𝐞𝐧𝐭𝐬: Use conditional logic to tailor query results. - 𝐃𝐚𝐭𝐞 𝐓𝐢𝐦𝐞 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬: Master manipulating dates and times for precise analysis. Next, explore advanced methods to structure and reuse SQL code effectively: - 𝐂𝐨𝐦𝐦𝐨𝐧 𝐓𝐚𝐛𝐥𝐞 𝐄𝐱𝐩𝐫𝐞𝐬𝐬𝐢𝐨𝐧𝐬 (𝐂𝐓𝐄𝐬): Simplify complex queries into manageable parts to increase the readability. - 𝐒𝐮𝐛𝐪𝐮𝐞𝐫𝐢𝐞𝐬: Nest queries for more granular data retrieval. - 𝐓𝐞𝐦𝐩𝐨𝐫𝐚𝐫𝐲 𝐓𝐚𝐛𝐥𝐞𝐬: Create and manipulate temporary data sets for specific tasks. Then, move on to advanced ones: - 𝐖𝐢𝐧𝐝𝐨𝐰 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧𝐬: Perform advanced calculations over sets of rows with ease. - 𝐒𝐭𝐨𝐫𝐞𝐝 𝐏𝐫𝐨𝐜𝐞𝐝𝐮𝐫𝐞𝐬: Create reusable SQL routines for streamlined operations. - 𝐓𝐫𝐢𝐠𝐠𝐞𝐫𝐬: Automate database actions based on specific events. - 𝐑𝐞𝐜𝐮𝐫𝐬𝐢𝐯𝐞 𝐂𝐓𝐄𝐬: Solve complex problems using recursive queries. - 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐨𝐟 𝐐𝐮𝐞𝐫𝐢𝐞𝐬: Techniques to enhance performance and efficiency. What other essential SQL skills would you add to this learning journey? 𝐎𝐧𝐜𝐞 𝐲𝐨𝐮 𝐥𝐞𝐚𝐫𝐧 𝐨𝐫 𝐚𝐬 𝐲𝐨𝐮 𝐥𝐞𝐚𝐫𝐧, 𝐩𝐫𝐚𝐜𝐭𝐢𝐜𝐞 𝐒𝐐𝐋 𝐡𝐞𝐫𝐞: 1. Dataford - https://lnkd.in/dau5UwmN 2. InterviewQuery - https://lnkd.in/dzJET9aC 3. LeetCode - https://lnkd.in/gkCpv7NA 4. HackerRank - https://lnkd.in/exe3kXzD hashtag #sql hashtag #dataanalytics hashtag #interviewprep

For anyone who’s starting their data career journey, I’d give them this exact advice: Don’t try to be good at everything. Lemme explain that. When you are starting out, you’ll probably want to create a million dashboards, query some data, make some presentations, etc. But if you try and be good at everything, you’ll never excel at anything. I’d rather someone focus on a couple or few things, with business knowledge being the top one. I’d rather be the go-to person for a specific topic or be the Excel person than just be another person who is ok with a bunch of stuff. If you truly want to make an impact and grow, focus on being a subject matter expert and thinking of how you can learn the business inside and out. PS I’m doing a free live intro to SQL class in a couple of weeks! Check it out in the comments.

Day 9 of my path to becoming a data analyst. Today, I learned about Power Pivot which provides one the opportunity to model and analyse a complex and large data in excel. I also learned some DAX functions like CALCULATE and CROSSFILTER. I applied my newly acquired knowledge to analyze a data set to determine the highest paying data jobs, the data roles that require more skills and the top skills possessed by data nerds in the United States and other countries.

The biggest mental problem when switching from web-dev to data scientist. 1. You've been creating webs to save your clients from using Excel. 2. As data scientist, you need to learn Excel. 3. Then you realize how many of your webs could have been done FASTER with Excel.

You're losing money every month as a data analyst. But there is a solution: Invest in your skills. It's simple. You will save time. ↓ You will get better faster. ↓ You will be more efficient. ↓ You will be better at your job. ↓ You will make more money. What are you doing to invest in your skills? Investing doesn't have to be financial. __________ Hi, I'm Andy Kriebel Click my name + follow + 🔔 I help people build their Tableau skills and make more money. If that sounds good to you, book an appointment and let's see how I can help. Like this post? Like 👍 | Comment ✍ | Repost ♻️

"𝗠𝘆 𝗳𝗶𝗿𝘀𝘁 𝗾𝘂𝗲𝗿𝘆 𝘄𝗮𝘀 𝗮 𝗱𝗶𝘀𝗮𝘀𝘁𝗲𝗿." I ran a "𝙎𝙀𝙇𝙀𝘾𝙏 *" command, thinking more was better. What I got was an unreadable wall of rows. Worse, it took forever to load. I knew I had to change my approach. So I went back to basics. - Focused on just the necessary columns. - Added 𝙒𝙃𝙀𝙍𝙀 conditions to filter the mess. - Sorted the output with 𝙊𝙍𝘿𝙀𝙍 𝘽𝙔. It was still 𝙎𝙀𝙇𝙀𝘾𝙏—just smarter. The result? From chaos to clarity in seconds. If SELECT is your tool, use it to shape your data. What’s your most frustrating SELECT experience? #sql #dataanalytics

Just returned from vacation and jumped straight into a bug investigation - numbers not adding up, you know the drill. Caught myself upon a curious thing. Writing #SQL is all good and nice, but if we're talking about granular data (like individual rows) and I really can't find the problem, when I need to iterate very very fast, change aggregations on the fly, play with filters, etc - I resort to its highness the Pivot Table in #Excel. TL;dr I resort to Excel when I'm desperate. It's what I would use if I'd get a call on a Friday 15 minutes before leaving to quickly check why something is off. That, of course, provided we're talking about the right scale of data. So I guess, use whatever works best for the job and for you specifically. Excel is still a data analysis powerhouse. But the auto-formatting/conversion/whatever it tries to do to help me has the opposite effect and is just a big pain (although I read that you can turn it off). Just so don't end the post on a sad note, pictured below, in the distance, Balos area on Crete.

"Inviting my LinkedIn family to join me on this exciting journey of growth and learning! 🌟 Let's dive into the world of data analytics together, mastering SQL Server and tackling tasks with enthusiasm and determination. Together, we'll conquer new challenges and unlock endless possibilities! 💼💡 #LinkedInCommunity #DataAnalytics #LearningTogether"

what's going on everybody! Indeed I'm gonna make a dive into data analytics. As I found a lot of new stuff to absorb interms of employment possiblities and inorder to choose it as an intermediate step for datascience furtherly! #dataanalytics #alextheanalyst #mysqlchasing #excelchasing #day1