<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Lauren Rosenthal on Medium]]></title>
        <description><![CDATA[Stories by Lauren Rosenthal on Medium]]></description>
        <link>https://medium.com/@lauren-maven?source=rss-9626d419793e------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*47ep2PujIpG8V3HM</url>
            <title>Stories by Lauren Rosenthal on Medium</title>
            <link>https://medium.com/@lauren-maven?source=rss-9626d419793e------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 18:11:01 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lauren-maven/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[7 courses I would take to get started on my data journey today]]></title>
            <link>https://medium.com/learning-data/7-courses-i-would-take-to-get-started-on-my-data-journey-today-5019109b04ed?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/5019109b04ed</guid>
            <category><![CDATA[education]]></category>
            <category><![CDATA[analytics]]></category>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Fri, 22 Nov 2024 18:43:02 GMT</pubDate>
            <atom:updated>2024-12-20T23:14:51.448Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*QRH-3ozWu_aOqdew" /><figcaption>Photo by <a href="https://unsplash.com/@thoughtcatalog?utm_source=medium&amp;utm_medium=referral">Thought Catalog</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Let’s play out a scenario.</p><p>You’re dissatisfied in your current career and looking desperately for something that will fulfill you… <em>and</em> pay a living wage.</p><p>In your search, you come across a video.</p><p>It’s a young woman, talking about her career as a data analyst: what she does, how much she makes, and the skills she uses.</p><p>You think to yourself, “That sounds like fun. I wonder if I could do that…”. And so you dig deeper. You find that data analysts do really freaking cool stuff. They make a good living. There are opportunities for growth.</p><p>So of course you start looking into what technical skills you need. <em>This</em> is where things start to go awry…</p><ul><li>AI</li><li>SQL</li><li>Excel</li><li>Python</li><li>Tableau</li><li>Power BI</li><li>R programming</li><li>Cloud computing</li><li>Machine learning</li><li>Data engineering</li><li>Data warehousing</li></ul><p>Do you need all of them? None of them? Yikes.</p><p>And even more than that, you find that there are hundreds upon hundreds of courses that make outrageous claims like, “We’ll take you from beginner to job-ready in just 10 hours!”</p><p>Where do you start?</p><p>Before getting (too) overwhelmed, here’s the thing: <strong>to get into data analytics, you need a solid foundation in key skills and concepts.</strong> That means having a deep understanding of basic tools, like Excel, SQL, and a data visualization tool.</p><p>I’ll let you in on a secret: this “scenario” is exactly where I found myself when I was just starting out. I had no clue how to get started, what courses to take, or what skills to focus on. Luckily, my circuitous route got me to the right spot…eventually.</p><p>But instead of repeating my mistakes, here are 7 courses that I recommend you take if you’re just starting out today.</p><h3><a href="https://mavenanalytics.io/course/data-literacy-foundations">Data Literacy Foundations</a></h3><p>These days, <em>everyone</em> works with data.</p><p>This <a href="https://mavenanalytics.io/course/data-literacy-foundations">2.5-hour FREE course</a> is one that I recommend to literally anyone, regardless of if you want to become a data analyst or not!</p><p>This course gives you a <strong>comprehensive introduction to data literacy</strong>, covering core skills like interpreting, managing, analyzing, and communicating with data. You’ll learn how to work with datasets, apply QA techniques, and explore frameworks for problem-solving like a data professional.</p><p>You’ll also be introduced to the principles of effective data visualization and storytelling, including how to avoid common mistakes and craft clear, data-driven narratives. This course is a fantastic introduction to data analytics and will help you develop the data skills needed to make smarter, more impactful decisions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*dH2-xfMnAhXIxuWE_P53Lg.png" /></figure><h3><a href="https://mavenanalytics.io/course/thinking-like-an-analyst">Thinking Like An Analyst</a></h3><p><a href="https://mavenanalytics.io/course/thinking-like-an-analyst">Thinking Like An Analyst</a> is where I got my own start. It’s a 5-hour course that provides the <strong>foundational skills needed for a successful career in data</strong>.</p><p>With interactive case studies and applicable frameworks, you’ll learn how to navigate the entire data analysis workflow, from measurement planning and defining success to tracking and optimizing KPIs.</p><p>The course covers data prep techniques, including cleaning, transforming, and profiling raw data, and teaches you how to write actionable, data-driven insights. You’ll also dive into data visualization, mastering effective visual communication, dashboard design, and best practices. The course also explores the analytics tool landscape, common “stacks” for different roles, and valuable resources for continued learning.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ynjzaY3JBQPzl2p9jTfQjA.png" /></figure><h3><a href="https://mavenanalytics.io/course/excel-formulas">Excel Formulas &amp; Functions</a></h3><p>After a solid foundation in how to <em>think</em> like an analyst, it’s time to dig into the meat and potatoes, starting with <a href="https://mavenanalytics.io/course/excel-formulas">Excel Formulas &amp; Functions</a>. This course focuses on using formulas and functions to create dynamic analytics tools. Instead of just memorizing the syntax, you’ll <strong>learn how to think like Excel</strong>, while practicing over 75 core functions through hands-on demos.</p><p>You’ll cover a range of techniques, from automating tasks to exploring raw data with text functions, logical operators, time intelligence, and dynamic arrays. By the end, you’ll understand how to create interactive models and dashboards, and streamline complex tasks — key skills for anyone looking to become a data analyst.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZNGfpdntl-L55yZV4X8gnA.png" /></figure><h3><a href="https://mavenanalytics.io/course/excel-pivot-tables">Excel Pivot Tables and Charts</a></h3><p>Learning how to use Pivot Tables opens up a whole new world so I definitely recommend understanding how and when to use them.</p><p>In this course, you’ll start by understanding the basic functionality of PivotTables, including how to structure source data, navigate the field list, and refresh your data. The course will walk you through PivotTable formatting options, like number formatting, custom headers, and conditional formatting, to help you present your data clearly and effectively.</p><p>Advanced techniques will cover sorting, filtering, and grouping data, as well as working with slicers, timelines, and report filter pages. You’ll also learn how to apply summarization options, including calculating percentages, running totals, and ranks. <a href="https://mavenanalytics.io/course/excel-pivot-tables">Excel Pivot Tables &amp; Charts</a> provides <strong>hands-on experience with real-world case studies</strong> that will help you work more efficiently with data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*W5x2hcK9mt0x7ntHkascxQ.png" /></figure><h3><a href="https://mavenanalytics.io/course/mysql-data-analysis">MySQL Data Analysis</a></h3><p>Moving on from Excel, SQL is where I would turn next.</p><p><a href="https://mavenanalytics.io/course/mysql-data-analysis">MySQL Data Analysis</a> is a practical, hands-on course that will teach you <strong>how to analyze relational databases</strong>. It’s also a course that is near and dear to my heart, since SQL is the language I chose to focus on, largely due to this course.</p><p>You’ll start with an introduction to the SQL language, covering key database fundamentals, and learn how to use MySQL to select, filter, sort, and group data from individual tables. After nailing down the “Big 6” (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY), you’ll get into more complex concepts, combining data from multiple tables, aggregating data, and using more advanced functions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*F39P3iNOQkLkdAYasb9Rfw.png" /></figure><h3><a href="https://mavenanalytics.io/course/sql-advanced-queries">Advanced SQL Querying</a></h3><p>This is a <a href="https://mavenanalytics.io/course/sql-advanced-queries">brand new course</a> from Maven Analytics and one of my <em>top</em> recommendations. While the MySQL Data Analysis course is a great introduction, this course truly lets you <strong>understand SQL’s full capabilities</strong>.</p><p>After learning the basics in SQL, I often hear the question, “what next?” This course is the answer to that. You’ll learn advanced querying techniques like subqueries, CTEs, and window functions, along with advanced functions used for manipulating various data types. You’ll also get to practice with real-world business problems to apply the skills you’ve learned.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*olC0aI_25l2Iint1gXzLbQ.png" /></figure><h3><a href="https://mavenanalytics.io/course/microsoft-power-bi-desktop">Microsoft Power BI</a> or <a href="https://mavenanalytics.io/course/intro-tableau-desktop">Intro to Tableau Desktop</a></h3><p><strong>Data visualization is a topic that an aspiring data analyst can’t afford to skip</strong>. This recommendation is a little different because there are two ways you can go: either Microsoft Power BI Desktop or Intro to Tableau Desktop. Both are incredibly powerful, useful tools and a lot of it comes down to personal choice (and operating system).</p><p><a href="https://mavenanalytics.io/course/microsoft-power-bi-desktop">Microsoft Power BI Desktop</a> will go through the entire business intelligence workflow, broken down into four stages:</p><ol><li>Connect and transform the raw source data</li><li>Design and build a relational model</li><li>Analyze the data with calculated columns &amp; DAX measures</li><li>Design custom, interactive reports and dashboards</li></ol><p>You’ll get to know Power BI’s basic functionality, understand common Power Query tools and use cases, identify data modeling best practices, and get a strong introduction to DAX, in addition to designing interactive dashboards.</p><p>On the other hand, <a href="https://mavenanalytics.io/course/intro-tableau-desktop">Intro to Tableau Desktop</a> will teach you how to connect, analyze, and visualize data with practical case studies. You’ll dig into connecting and transforming data, filtering, sorting, and grouping tools, building visualizations, and defining custom calculations and parameters.</p><p>Both courses offer a strong foundation in data visualization skills, real-world case studies, and the opportunity to build interactive, dynamic data dashboards and reports.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*UzKC0Upy7PI-ekK_Y8yZ0Q.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*qNTsthmUnP7c-XxOX55Efw.png" /></figure><h3>BONUS: <a href="https://mavenanalytics.io/path/data-career-roadmap">Data Career Roadmap</a></h3><p>This quick <a href="https://mavenanalytics.io/path/data-career-roadmap">learning path</a> is just the icing on the cake. With a series of short, 1-hour(ish) courses, you’ll learn more about common data analytics roles, as well as how to create a great resume, polish your LinkedIn profile, and build a strong project portfolio. You’ll also get tactics to ace tough analytics interviews, review common interview questions, and advice on technical assessments and live case studies. When you’re ready to look for your next role, this is the ultimate job hunt prep guide.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mGwc6rZiMjPfQmowJFIYkQ.png" /></figure><h3>Wrapping Up</h3><p>A career in data analytics can be exciting but the road to get there can feel overwhelming and a little uncertain. With a strong foundation in the right skills, you’ll find that it’s not quite as complicated as it seems. By focusing on key technical skills like Excel, SQl, and data visualization, you’ll be ready to take on real-world data challenges.</p><p>If you’re thinking about getting into data analytics, now is the perfect time. <a href="https://mavenanalytics.io/black-friday?utm_source=medium&amp;utm_medium=medium&amp;utm_campaign=blackfriday2024">Maven Analytics’ Black Friday sale</a> is our biggest of the year and it’s almost over! Take advantage and see if a career in data is the right thing for you.</p><p><em>If you liked this, we’d love for you to subscribe to our publication, and please drop us a comment letting us know what you’d like to see next!</em></p><p><em>You can also</em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e?sk=020dfac485597d602e218968d9ffb395"><em> submit your own writing</em></a><em> for us to promote, so don’t be shy if you would like to become a contributor.</em></p><p><em>Find even more from us at </em><a href="http://mavenanalytics.io/"><em>Maven Analytics</em></a><em>.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5019109b04ed" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/7-courses-i-would-take-to-get-started-on-my-data-journey-today-5019109b04ed">7 courses I would take to get started on my data journey today</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[3 Common Misconceptions About Data Literacy (and why they’re wrong!)]]></title>
            <link>https://medium.com/learning-data/3-common-misconceptions-about-data-literacy-and-why-theyre-wrong-1e3029656954?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/1e3029656954</guid>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[data-literacy]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Thu, 04 Apr 2024 18:59:14 GMT</pubDate>
            <atom:updated>2024-04-04T18:59:14.784Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*y6msIAw4GMGsNdD6" /><figcaption>Photo by <a href="https://unsplash.com/@johnishappysometimes?utm_source=medium&amp;utm_medium=referral">John Schnobrich</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>What do you know about <strong>data literacy</strong>?</p><p>If someone asked you, “are you data literate?” how would you respond? If your answer is 🤷🏼‍♀️, you’re not alone — but this one’s for you!</p><p>Data literacy is a buzzword that has become increasingly more common in today’s world, and for good reason! The amount of data in the world is expected to reach over 180 zettabytes by 2025, which means it’s growing… and <em>fast</em>.</p><p><strong>Data is everywhere.</strong> It’s how Netflix knows what TV shows to recommend, how Amazon knows what products to show you, and how TikTok cultivates your FYP. (Yes, this means you’re to blame for what you see on your FYP!)</p><p>Having a solid grasp on what data is, how it’s used, and why it’s important is essential. And guess what! That’s essentially what data literacy IS.</p><p>Our definition of data literacy is this:</p><blockquote><em>The ability to interpret, manage, analyze, and communicate with data</em></blockquote><p>If you’re thinking you can just leave the data literacy to the data scientists and analysts, though, think again. Luckily, this brings us to our first common misconception…</p><h3>Data literacy is just for data professionals.</h3><p>Data literacy is all about making data-driven decisions, regardless of your job title or industry.</p><p>Maybe you’re thinking, “I don’t work with data; why do I need data literacy skills?”</p><p>Here’s the thing: <strong>no matter where you work or what industry or department you work in, your organization uses data, too.</strong></p><p>Human resources professionals use data to identify training needs or analyze workforce demographics. They can use data to make decisions about which employees should receive a promotion and to help understand employee attrition rates.</p><p>Healthcare professionals use data from electronic health records, like patient demographics and diagnoses. They use data for claims and insurance purposes, as well as for operational purposes. Speaking from experience, healthcare professionals also use data to guide treatment planning and goal setting.</p><p>Sales professionals use data to analyze customer demographics and forecast sales trends. They can use data to improve productivity and efficiency or to understand the patterns in their sales processes.</p><p>The common theme here? None of these people have the title of data analyst or data scientist. They’re everyday people who work with data and thus, need data literacy skills.</p><p>But the question becomes: what level of data literacy is right for you?</p><p>That brings us to our second common misconception, which is…</p><h3>Data literacy is one-size-fits-all.</h3><p>The great thing about data literacy is this: your level of literacy should be based on the skills <em>you</em> need in <em>your</em> job function.</p><p>We think about three different levels of data literacy:</p><ul><li>Someone who is <strong>conversational </strong>with data can understand basic data concepts and interpret straightforward analytics outputs. They don’t have the ability to manipulate data or perform an analysis themselves. These people are who we call the <strong>data interpreters</strong>. They’re non-analysts who are consuming and potentially making decisions based on analytical outputs.</li><li>The person who is <strong>data literate</strong> is someone who can interpret, manage, and analyze data for a basic descriptive or diagnostic analysis. They might have limited to no experience conducting advanced analyses or presenting to stakeholders. These people are <strong>citizen analysts</strong>. They aren’t necessarily analytics specialists but they do leverage data in their role.</li><li>Last is the person who is <strong>data fluent</strong>. This is someone who has the skills to think strategically, design and conduct complex analyses, and clearly share insights to technical and non-technical audiences. These are the <strong>data specialists</strong>. They’re professionals in specialized data roles like BI Analysts, data scientists, or data engineers.</li></ul><p>Data literacy isn’t about getting to a fluent level. It’s about having the skills you need to succeed in your specific role.</p><p>If you noticed in the descriptions above, data literacy involves abilities like interpreting basic charts and graphs and communicating insights with stakeholders. One thing that these skills share? They don’t involve advanced technical skills, which brings us to our third and final common misconception…</p><h3>Data literacy is just about the numbers and requires advanced technical skills.</h3><p>Let’s revisit Maven Analytics’ definition of data literacy:</p><blockquote><em>The ability to interpret, manage, analyze, and communicate with data</em></blockquote><p>Our definition of data literacy certainly doesn’t involve “<em>the ability to calculate R-squared</em>” or “<em>the ability to write a Python script</em>”! While numbers are obviously part of data, data literacy is about more than that. It’s about understanding the story and context behind the data, what the data means.</p><p>In fact, data literacy often comes down to soft skills, rather than technical ones.</p><ul><li>Can you use critical thinking skills to interpret the meaning of the chart in front of you?</li><li>How would you solve data quality problems like outliers or incorrect data types?</li><li>Have you evaluated the information available to you objectively and without bias?</li><li>What graph would be best to clearly communicate your insights?</li></ul><p>Sure, numbers and advanced technical skills <em>can be</em> a part of data literacy but they’re not the entire story.</p><h3>So now what?</h3><p>It’s becoming more and more obvious that data literacy skills are for everyone, no matter your job function, industry, or department. They allow you to make better, more data-driven decisions that have solid evidence behind them. And, with data growing exponentially (see 180 zettabytes above), now is the time to…</p><h4>Assess your own data literacy skills</h4><ol><li>Do you feel comfortable looking at a chart and understanding what it means?</li><li>Can you figure out what type of data you’re looking at and where it comes from?</li><li>Are you able to analyze data to find patterns, trends, and insights?</li><li>Would you know which chart or graph to use to communicate your findings?</li></ol><h4>Determine what data skills you need in your job function</h4><ol><li>Are you expected to interpret charts and tables?</li><li>Does your job involve finding and gathering data?</li><li>Do you analyze data to provide insights to others?</li><li>Are you asked to communicate your findings?</li></ol><h4>Take steps to bridge the gap between where you are and where you want to be</h4><p>Whether you decide to take a course, read a book, or join groups dedicated to data literacy, what matters is that you’re making moves toward becoming more data-literate. I’m confident that you’ll quickly see how valuable of a skill it is and will continue to be.</p><p>I hope these steps will help you figure out exactly how to begin your own data literacy journey!</p><p><em>Ready to start your journey toward data literacy? Check out our brand new course: </em><a href="https://mavenanalytics.io/course/data-literacy-foundations"><strong><em>Data Literacy Foundations</em></strong><em>!</em></a><em> It’s 2.5 hours long and is built for everyone. Plus, it’s FREE!</em></p><figure><img alt="" src="https://cdn-images-1.medium.com/max/800/0*sEoxLK5oaUuAvSZV" /></figure><p><em>If you liked this, we’d love for you to subscribe to our publication, and please drop us a comment letting us know what you’d like to see next!</em></p><p><em>You can also</em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e?source=friends_link&amp;sk=020dfac485597d602e218968d9ffb395"><em> submit your own writing</em></a><em> for us to promote, so don’t be shy if you would like to become a contributor.</em></p><p><em>Find even more from us at </em><a href="http://mavenanalytics.io/"><em>Maven Analytics</em></a><em>.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=1e3029656954" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/3-common-misconceptions-about-data-literacy-and-why-theyre-wrong-1e3029656954">3 Common Misconceptions About Data Literacy (and why they’re wrong!)</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Fangirling My Way to Success: My Journey in Data Analytics]]></title>
            <link>https://medium.com/learning-data/fangirling-my-way-to-success-my-journey-in-data-analytics-0e48dcabd5f3?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/0e48dcabd5f3</guid>
            <category><![CDATA[job-hunting]]></category>
            <category><![CDATA[job-interview]]></category>
            <category><![CDATA[career-change]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Mon, 04 Dec 2023 22:07:25 GMT</pubDate>
            <atom:updated>2023-12-04T22:07:25.363Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*1RxUncRt-tzPwIBP" /><figcaption>Photo by <a href="https://unsplash.com/@edulauton?utm_source=medium&amp;utm_medium=referral">Edu Lauton</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I never anticipated that my seemingly inconsequential comment on LinkedIn would change the trajectory of my career.</p><p>I had just accepted an offer for my first job as a business intelligence analyst at a health insurance company when I came across this LinkedIn post:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/707/0*kHybXw4HaOPVZXaC" /></figure><p>I remember thinking to myself, “It would be so cool to work for the company that I learned most of my own data skills from!” But I didn’t actually think about it seriously. I was too fresh, too inexperienced, and too early on in my brand-new career to start helping other people learn data skills…<em>right?</em></p><p>Regardless of my certainty that I wouldn’t even be considered (imposter syndrome, man!) I decided it couldn’t hurt to shoot my shot. What’s the worst that could happen, after all?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/707/0*iau4aRUiZsV8gW-U" /></figure><p>And that’s it. That simple interaction is what got me on my current path.</p><p>But that’s not the whole story.</p><p>As you may have guessed, I filled out the application and took the SQL assessment…</p><p><em>…And then I put it aside.</em></p><p>I was getting into the swing of things with my new job and figured, maybe I’d hear back and maybe I wouldn’t.</p><p>And lo and behold, I did! I quickly received a response with a request to set up some time to meet and talk through the position.</p><h3>Making a good impression</h3><p>I was nervous. This was a company that I never dreamed I would work for and I wanted to make a good impression. So, of course, I researched. I found plenty of articles, how-tos, and listicles online about how to prepare for an interview.</p><p>They all contain similar tips and tricks:</p><ul><li>Practice your interview answers; don’t forget the STAR method.</li><li>Prepare questions to ask your interviewers.</li><li>Be ready to show examples of your work.</li><li>Research the company.</li><li>Dress professionally.</li><li>Arrive on time.</li></ul><p>…the list goes on.</p><p>And believe me, I did all of that! I was thrilled to even get the opportunity to interview for this job and I prepared accordingly.</p><p>But that wasn’t all.</p><h3>My secret weapons</h3><p>I knew I had to go beyond the typical interview preparation checklist if I really wanted to make an impression. While the basics like STAR method responses and punctuality are undoubtedly crucial, I needed to stand out from the crowd.</p><p>Here’s how I did it…</p><h4>Name recognition</h4><p>My first secret weapon wasn’t even one I was aware of. I had begun writing about my own journey to data analytics on LinkedIn about five months prior to this and had built a community of people online.</p><p>Why did that matter?</p><p>One of the first topics of conversation in my interview was this: when my application came in, <em>the team already recognized my name</em> from my contributions to the data community. Mind. Blown. 🤯</p><p>I didn’t get on LinkedIn with the intention of building that name recognition but, accidental or not, it gave me a boost of confidence.</p><h4>Enthusiasm and passion</h4><p>This is the big one!</p><p>I’m not kidding when I say I fangirled my way into a job.</p><p>The position was originally meant to be a part-time job — answering student questions about the Maven SQL courses. Even before the interview, though, I was told that my application responses and engagement in the data community made the team think there might be a bigger role for me.</p><p>I was SO excited. This was the platform on which I learned the majority of my own data skills, and now I had the opportunity to get more involved?!</p><p>Throughout the process, I repeatedly reinforced how thrilled I was to even be interviewing for the position. Positive energy and genuine interest were two of my greatest strengths.</p><h3>The moral of the story</h3><p>Looking back, that “throwaway” LinkedIn comment became the catalyst for an entirely new and unexpected chapter in my career. And now, almost a year into that role, I couldn’t be happier. My enthusiasm and passion for Maven and our mission turned out to be my secret weapons.</p><p>So my advice is simple: embrace your journey, celebrate your unique qualities, prepare for your interviews, take chances, and, most importantly, don’t underestimate the impact of genuine enthusiasm.</p><p>Who knows; your next career-defining moment might be a LinkedIn comment away, just waiting for you to seize it!</p><p><em>If you liked this, we’d love for you to subscribe to our publication, and please drop us a comment letting us know what you’d like to see next!</em></p><p><em>You can also</em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e?source=friends_link&amp;sk=020dfac485597d602e218968d9ffb395"><em> submit your own writing</em></a><em> for us to promote, so don’t be shy if you would like to become a contributor.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=0e48dcabd5f3" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/fangirling-my-way-to-success-my-journey-in-data-analytics-0e48dcabd5f3">Fangirling My Way to Success: My Journey in Data Analytics</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[5 Ways I Have Used ChatGPT in My Day-to-Day Work]]></title>
            <link>https://medium.com/learning-data/5-ways-i-have-used-chatgpt-in-my-day-to-day-work-e8e27542cdd9?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/e8e27542cdd9</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[prompt-engineering]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[chatgpt]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Tue, 12 Sep 2023 21:43:46 GMT</pubDate>
            <atom:updated>2023-09-12T21:43:46.643Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*TR7uf5UTrdIKiP-e" /><figcaption>Photo by <a href="https://unsplash.com/@growtika?utm_source=medium&amp;utm_medium=referral">Growtika</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>It’s not an understatement to say that ChatGPT turned the world on its head when it was released back in November of 2022. It’s changed the way many people work and I’m not afraid to say that I’m one of them!</p><p>At first, it was simple curiosity that had me making an account.</p><p>“What’s all the fuss about this new-fangled tool?” I thought to myself. <em>(Note: this probably isn’t exactly how it went down. I don’t tend to use words like new-fangled in my thoughts.)</em></p><p>But then I realized, “hey, this could be a game changer!” Back in November, I had a solid grasp on SQL but I still found myself stumped at times. Questions like, “How would I write a (complex) query that does xyz?” or <br>“What’s the difference between these two concepts and when would I use one over the other?” puzzled me and there wasn’t anywhere I could go to ask that exact question to find my answer. Sure, Google could give me resources like Stack Overflow, but that involved digging through <strong><em>a lot</em></strong> of questions and not always finding the answer I needed.</p><p>ChatGPT changed that.</p><p>Here are 5 ways that I’ve used ChatGPT in my data analysis work:</p><ol><li>Helping write a query using unfamiliar operators</li><li>Giving assistance with Google Sheets/Excel formulas</li><li>Explaining how certain functions or operators work</li><li>Commenting my code</li><li>Breaking down a query that used advanced concepts</li></ol><h3>1. Helping write a query using unfamiliar operators</h3><h4>The situation</h4><p>I had data that I needed to group into broader categories but didn’t have a clear way to do that. I knew what I wanted to use (REGEXP) but wasn’t sure how to actually write the query.</p><h4>The request</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*a872trc7Qx4_EbsuLajzmA.png" /></figure><h4>The response</h4><p>ChatGPT gave me a query that used REGEXP in a CASE statement to create buckets for each cancelation reason.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*U_J5RBeTFlM_3b_Om03m7g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*itDB1m25TDFKq6eJWG-kqQ.png" /></figure><h3>2. Giving assistance with Google Sheets/Excel formulas</h3><h4>The situation</h4><p>I’ll be the first to say, Google Sheets and Excel aren’t my strong suit. I can and do use them regularly but remembering how to write formulas and when to use them is a challenge. In this scenario, I needed a function to return everything after the comma in each cell within a column.</p><h4>The request</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*j8i9U02TqyqCpazhIy5ncg.png" /></figure><h4>The response</h4><p>ChatGPT returned a formula that included the RIGHT function in conjunction with the FIND function to return everything after the comma in a cell.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*IrnuWKE2U0AB4NgdJdkFow.png" /></figure><h3>3. Explaining how certain functions or operators work</h3><h4>The situation</h4><p>For whatever reason, window functions were beyond my understanding for a long time but I knew that, if I could figure them out, they could be incredibly useful to my work. So of course, I went to ChatGPT to try to grasp the concept of window functions.</p><h4>The request</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*V4MMyasD5I4mojfZCCdqCQ.png" /></figure><h4>The response</h4><p>ChatGPT gave me the basic syntax and provided examples of different window functions and when they might be used.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*fICkO_qPN4i1pCXLHaCQ5g.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*iAoIG0m9Q6uNX4_SSiH1gg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*rHV66JpolbjA-n20EzrYdw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*PA9j02DFO_hY9irXMVKKvQ.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*4dXR4ST07e4UEq5oLDp9sg.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*cSk9x41pBwzeevAtkcHeNg.png" /></figure><h3>4. Commenting my code</h3><h4>The situation</h4><p>I had a long query with multiple CTEs and I really wanted to comment purposefully so I (or someone else) could go back and see what the query was meant to do.</p><h4>The request</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*YUXCgXeidfcg7cGTliyzEA.gif" /></figure><h4>The response</h4><p>ChatGPT went through my query and added comments to each CTE to explain the purpose of them.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ZCMZGgynL7dOk-i1t8VC9Q.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*4RRLTBOe0JBJrfa9sLW4Ew.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*3CpwkYvln0NuRGjcH0y1yw.png" /></figure><h3>5. Breaking down a query that used advanced concepts</h3><h4>The situation</h4><p>I wanted to understand the purpose of GROUPING and how it works in a query with ROLLUP but after looking at the query further, I needed more information.</p><h4>The request</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*4SNXf0QxC_hBhVhvoej2qQ.png" /></figure><h4>The response</h4><p>ChatGPT broke down each step of the query and explained exactly the purpose of those steps.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*oR0Cb0dDzFYpZE4eoXK6LA.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*SQRp5hX0VPga6GducsLmhw.png" /></figure><p>…however, I was <em>still</em> confused by GROUPING!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*UKYnmFU0uWoKRoLniQ10Qw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*00HmoXA4A0McY47hQ2Xpzw.png" /></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1018/1*4ELcp7fFIHuX4kEbfWAYmA.png" /></figure><h3>My advice is this…</h3><p>Learn how to use ChatGPT to your advantage. That means:</p><ol><li>understanding exactly what you’re looking for</li><li>being able to clearly explain your need in writing</li><li>checking that the answer you’re receiving is accurate</li><li>not solely relying on ChatGPT to do your work!</li></ol><h4>And a quick caution…</h4><p>ChatGPT isn’t always right. I asked for it to explain the difference between ELSE 0 vs. ELSE NULL in the COUNT(CASE) pivot method and this was the first example it gave me:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*L5K2vZ7NCbmuJlfsZUcgOA.png" /></figure><p>In the explanation, ChatGPT tells me that the COUNT(CASE) will count how many times each customer placed an order containing product 123.</p><p>…but that’s not right. Since COUNT() simply counts the number of rows that have a non-NULL value, it would include rows where the output was 0, therefore inflating the number of times a customer placed an order containing product 123. When I responded with a clarification, ChatGPT returned:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*wNtDGqIqiiSWgdVxjCKKPg.png" /></figure><p>The point here is that you can’t entirely rely on ChatGPT without having a solid grasp on the tool or domain you need help with.</p><h3>So what does it all mean?</h3><p>The bottom line is: use ChatGPT to your advantage but be skeptical. It’s a great tool to supplement your work but it shouldn’t replace critical thinking and your own expertise. Use ChatGPT to further your own understanding, increase your independence, and enhance your productivity but remember that ChatGPT is simply a (powerful) tool, not a substitute for your skill and knowledge.</p><p>P.S. If you’re interested in learning more about how you can use ChatGPT in your own work, Maven offers a free <a href="https://mavenanalytics.io/course/chatgpt-for-data-analytics">ChatGPT for Data Analytics</a> course!</p><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor. Check out submission instructions </em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e"><em>here</em></a><em>.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=e8e27542cdd9" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/5-ways-i-have-used-chatgpt-in-my-day-to-day-work-e8e27542cdd9">5 Ways I Have Used ChatGPT in My Day-to-Day Work</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Portfolio Projects: Beautify Your SQL Queries]]></title>
            <link>https://medium.com/learning-data/portfolio-projects-beautify-your-sql-queries-9bcf15686472?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/9bcf15686472</guid>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-visualization]]></category>
            <category><![CDATA[projects]]></category>
            <category><![CDATA[sql-queries]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Mon, 07 Aug 2023 20:53:01 GMT</pubDate>
            <atom:updated>2023-08-07T21:03:59.503Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1004/1*Ko2p6uRztvGgG3Kyf_eEkQ.png" /></figure><p>We’ve all heard it before: creating projects is essential on your journey to becoming a data analyst.</p><p>As a quick review, here are a few reasons why projects should be part of your repertoire:</p><ol><li>They demonstrate practical skills.</li><li>They show your problem solving ability.</li><li>They give you hands-on experience.</li><li>They showcase your communication skills, both written and visual.</li><li>They set you apart from others in a competitive job market.</li><li>They give you confidence that you have the necessary skills.</li></ol><p>And best of all, projects can be fun!</p><h3>What does a project consist of?</h3><h4>Project overview</h4><p>You can start with a brief description of the project. Explain the objectives, context, and the problem or questions you aim to solve/answer through your analysis.</p><h4>Data information</h4><p>Include info like where you got your dataset and the type of data you’re using. Give an overview of what’s contained in the data: number and name of tables, types of columns, what information is found in them, etc.</p><h4>Data cleaning</h4><p>Talk about the steps you took to clean and process the data. Were there missing values, outliers, mismatched data types, or anything else that impacted your ability to complete your analysis? Discuss what you did and why.</p><h4>Data exploration</h4><p>A great way to get to know your data is through exploratory data analysis (EDA). Use simple queries and visualizations to find basic information about the data. How many records does your dataset contain? If there are date values, what timeframe does it cover? This could also be a great time to build an EER diagram to showcase the relationships between the tables in your data.</p><h4>Data analysis</h4><p>Showcase the SQL queries or Excel formulas you used to extract relevant data for analysis. Include a variety of queries that show your skills including filtering, grouping, joining, and aggregating data. Aim to answer the questions you laid out in your project overview.</p><h4>Data insights and interpretation</h4><p>Summarize what you found in your data analysis. Answer the questions that originally guided your project. Give recommendations and meaningful conclusions.</p><h4>Data visualization</h4><p>Create a dashboard or visualization with Power BI, Tableau, Excel, or another data visualization platform. Make sure to include only relevant information and keep your objectives in mind.</p><h4>What next?</h4><p>Wrap up your project by considering:</p><ul><li>Did I answer the questions laid out in my project overview?</li><li>Did I provide solutions for problems?</li><li>Are there steps I would take next to advance the analysis?</li></ul><p>Provide a conclusion, a link to the data you used, and any references to external sources.</p><h3>You’ve put together a fantastic project!</h3><p>By the end of the process, you’ll have a polished dashboard or visual that clearly demonstrates your ability to gain insights from data and communicate them in a meaningful way…</p><p>But here’s one thing we often run into: sure, your portfolio project demonstrates your ability to put together a great Power BI, Tableau, or Excel dashboard, but it doesn’t exactly show the complexity of the SQL queries you wrote or how you found the information you’re displaying.</p><h3>So what can you do?</h3><p>Depending on where you’re hosting your project portfolio, you have a couple of options. If you’re hosting it on GitHub, you can add your SQL files to a repository. You can also simply add the SQL queries as markdown within a file. If you use WordPress, SquareSpace, or Wix, you can take screenshots of your queries and add them to your site or use code blocks in the pages.</p><p>What if you want to really focus on your SQL queries, though? If you’re using JOINs, CTEs, subqueries, and/or window functions (just to name a few), you may want to display that level of skill and expertise! You put a lot of hard work into them and to simply have them as an afterthought may not be the route you want to take. Maybe you really want to draw attention to the particularly complex queries you wrote as evidence that you have the skills needed to be a data analyst.</p><h3>Here’s a few options…</h3><p>There are multiple websites that allow you to create images of your source code so find the one that fits you and your needs best!</p><p>You can think about:</p><ul><li>Do I want something basic or an editor that allows me more flexibility and customization?</li><li>Do I want titles on my queries to explain what their purpose is?</li><li>Do I want a description section or will I stick with commenting my code throughout the query itself?</li></ul><p>All of these questions will help guide you to the best fit.</p><h4><a href="http://carbon.now.sh/">Carbon</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*djJNJFMDNi0eziJJffa4Bw.png" /></figure><p>Carbon is easy to use and the interface is straightforward. It gives you some customization options, including theme, background color, and coding language. You can also create your own custom theme to choose the color of different keywords, numbers, and more. Carbon doesn’t give you the option of gradient backgrounds but does allow you to use an image. Interestingly, Carbon doesn’t give you an obvious option to provide a title for your image like some of the other editors you’ll see. You’ll definitely want to include some comments within your code to explain the purpose. Carbon is middle-of-the-road when it comes to customization options but it’s a great place to get started.</p><h4><a href="https://snappify.com/">Snappify</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*5knXax628tNYNoGhrpH6lw.png" /></figure><p>Snappify has some of the most unique customization options that I’ve found and if you upgrade to a paid version, you get access to even more. In the free version, there are 6 preset themes to choose from. However, you can customize those even further and create entirely new ones in the Background section of the editor. You can choose to add a title or other elements including images, a profile picture, or other form elements. This editor has plenty of options but might feel a little overwhelming at first.</p><h4><a href="https://ray.so/">Ray.so</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QK-USMSJaqdLLnHd2RbDBw.png" /></figure><p>Ray.so allows you to change your theme and coding language. It also lets you give your query a title. While Ray.so gives you some amount of control over your customization, there aren’t as many options as with some of the other code editors; but, it still produces a visually aesthetic image! This might be a little less overwhelming for some beginners.</p><h4><a href="https://codekeep.io/screenshot">CodeKeep</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*WN6YCCQ-kQ7_U6NGGLpB4w.png" /><figcaption>I like that I have the option to include a description with my CodeKeep image.</figcaption></figure><p>CodeKeep’s interface is definitely more complex than some of the other options here and there are some pros and cons. It allows you to choose from preset templates, but those templates aren’t the typical color or gradient options. For instance, I chose the “Paper” template. It gives you a ton of customization options, including language, showing/hiding a title and description, adding social icons or other images, and much more. This one might be a little overwhelming but there are some cool options to explore!</p><h4><a href="http://codetoimg.com/">CodeToImg</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ApAfPKMwYtk1x7tBHobnlA.png" /></figure><p>CodeToImg allows you to choose a background (color, gradient, or picture from Unsplash), coding language, image format, and more. It also allows you to provide a title to the image to give more context. In terms of customization, CodeToImg gives you a lot of freedom, from font size to amount of padding to scale and more.</p><h4><a href="https://chalk.ist/">Chalk.ist</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*oUBEcPRS1ikaWjcC1cECVQ.png" /></figure><p>Yet another option, Chalk.ist lets you choose from eight predefined themes, customize amount of padding on the X and Y axes, and choose from a set of coding language (SQL is, interestingly, not one of the choices). I like the look of the source code but there are definitely fewer customization options with Chalk.ist.</p><h4><a href="https://codeimg.io/">CodeImg</a></h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/900/1*p3VMX2g0wbuZ-WWJ3PmDSg.png" /></figure><p>CodeImg asks you to start by choosing a Social Network Template and gives you insight into which ones are used most often. This allows you to ensure that the image fits the dimensions of different platforms, like Facebook and Twitter. Once you’ve done that, you’re directed a page that is similar to the other interfaces we’ve seen. CodeImg gives you a lot of control over canvas width and height, as well as editor theme. It doesn’t allow you as much customization in terms of background but is generally easy to use.</p><h3>Still not sure how to put this into practice?</h3><p><a href="https://mavenanalytics.io/project/38">Here’s</a> an example of a project I completed early in my data analyst journey. Scroll to the bottom to see how I added additional images to my project that display my SQL queries with Snappify!</p><p>Portfolio projects are a great tool for any data analyst who is looking for a job. They can clearly demonstrate the ability to think critically, problem solve, determine and communicate important insights, and more. Adding images of SQL queries can be an additional tool in your toolbox to show exactly how you did your analysis, the complexity of your queries, among many other benefits.</p><p>What do you think? Will you start adding images of your SQL queries to your projects?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*52AeVPBEEOmY6dnL" /><figcaption>Photo by <a href="https://unsplash.com/@lukechesser?utm_source=medium&amp;utm_medium=referral">Luke Chesser</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor. Check out submission instructions </em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e"><em>here</em></a><em>.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=9bcf15686472" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/portfolio-projects-beautify-your-sql-queries-9bcf15686472">Portfolio Projects: Beautify Your SQL Queries</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Cannonball Into SQL Success: A Roadmap]]></title>
            <link>https://medium.com/learning-data/cannonball-into-sql-success-a-roadmap-110600ab9643?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/110600ab9643</guid>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[data-analyst]]></category>
            <category><![CDATA[mysql]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Mon, 10 Jul 2023 20:53:30 GMT</pubDate>
            <atom:updated>2023-07-10T22:17:11.327Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*U6bCcFTwWLi5Xnhx" /><figcaption>Photo by <a href="https://unsplash.com/@drewfarwell?utm_source=medium&amp;utm_medium=referral">Drew Farwell</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>One of the reasons that SQL is such a popular language for entry-level data analysts to learn is because, from the outside, it looks pretty basic.</p><p><strong>SELECT <em>column_name</em></strong></p><p><strong>FROM <em>table_name</em></strong></p><p><strong>WHERE <em>condition</em>;</strong></p><p>Presto! Your work is complete, right?</p><p>Not quite, as it turns out.</p><p>Once you look under the surface, you can do some really cool, complex things with SQL. But often, there’s no clear roadmap for when or how to learn the more advanced concepts in SQL.</p><p>Here’s a quick breakdown of one way you could map out your own learning plan.</p><h3>Quick overview</h3><ol><li><a href="#47dd">Setting expectations</a><br> — Introducing the tables</li><li><a href="#d853">Dipping your toe in</a><br>— Create, alter, delete, insert into<br>— Basic statements (SELECT, FROM)<br>— Filter and sort (WHERE, ORDER BY)<br>— Single table data retrieval and manipulation (MIN, MAX, AVG, LIKE, CONCAT)</li><li><a href="#d870">Wading in the water</a><br>— Aggregating and grouping (GROUP BY, HAVING)<br>— Conditional logic (CASE statements)<br>— Join tables (LEFT, INNER, UNION)<br>— Combine logic and aggregations (COUNT CASE, SUM CASE)<br>— Subqueries, CTEs, temporary tables</li><li><a href="#e70c">Diving into the deep end</a><br>— Stored procedures<br>— Window functions<br> — Optimization</li></ol><h3>Setting expectations</h3><p>I’m going to be using MySQL syntax in my roadmap. I’ll also be using 2 basic tables to demonstrate each of the concepts I’m focusing on.</p><p>Those tables are the <em>products</em> table and the <em>product_category</em> table.</p><figure><img alt="A data table with columns (product id, name, description, brand, category id, unit price, and quantity in stock) and 32 rows" src="https://cdn-images-1.medium.com/max/1024/1*CIeYU1jlB7sMTCcm_qmbzg.png" /><figcaption>The products table has: product_id (primary key), product name, description, brand, category_id (foreign key), unit price, and quantity in stock.</figcaption></figure><figure><img alt="A data table with two columns, category id and category name, and 12 rows." src="https://cdn-images-1.medium.com/max/492/1*POuJA0DfKMZVVgO4-Vg50g.png" /><figcaption>The category table has: category_id (primary key) and category name.</figcaption></figure><h3>First, dip your toe in</h3><h4>Create, alter, delete, insert</h4><p><strong>It’s always good to have an understanding of how to create, alter, update, and delete, even if you don’t plan on becoming a database administrator.</strong> This means learning statements like CREATE, ALTER, DELETE, and INSERT INTO.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/824/1*4OjTwWi4LCuvcPnpg7H3Ug.png" /><figcaption>CREATE TABLE statement for the product_category table.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*QSIQ1sUXZsE_GjfVbrxoog.png" /><figcaption>INSERT INTO statement for new category and product.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*0fdir73xiHYhlPLp49cwZg.png" /><figcaption>There was a duplicate product, orange juice, with product ID 31. We used an UPDATE statement to remove the duplicate and add peanut butter into our <em>products</em> table. Because who doesn’t love peanut butter?</figcaption></figure><h4>Basic statements</h4><p><strong>Learn how to write basic statements in whichever “flavor” of SQL you choose.</strong> Don’t worry too much about which one you focus on first; there are way more similarities than differences when it comes to SQL variants.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/708/1*akvHaKAvElrOkCr8U_kWgg.png" /><figcaption>A basic query to start understanding what the database contains.</figcaption></figure><h4>Filter and sort</h4><p><strong>Work on filtering and sorting data.</strong> You can use the WHERE clause, logical operators, and ORDER BY to better understand what’s going on within your data.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/824/1*nbayCajvauZ3cox9yL2Yqg.png" /><figcaption>Returning results where there are 30 or less of the product in stock, ordering by unit price (highest to lowest).</figcaption></figure><h4>Single table data retrieval and manipulation</h4><p><strong>Use single tables to explore simple data retrieval and manipulation. </strong>This might look like using aggregate functions, like COUNT, SUM, AVG, MIN, and MAX, using basic math and date/time functions, or understanding string functions like LIKE, CONCAT, LENGTH, and SUBSTRING.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/982/1*lARpmDrh010s5oRxDmARvA.png" /><figcaption>Using MIN, MAX, and AVG to explore quantity in stock.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*n1PPOp0ta3_pS-Dxtdn6cg.png" /><figcaption>Using LIKE to find all products with “fresh” in the description.</figcaption></figure><h3>Next, wade in the water</h3><h4>Aggregate and group</h4><p><strong>Dig into aggregating and grouping data more deeply.</strong> You can use GROUP BY and HAVING to really find insights in your data. The GROUP BY clause is used to group rows and perform aggregations at the group level. The HAVING clause is then used to filter the groups <em>created by your GROUP BY</em> based on certain conditions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/954/1*PGaMD0FHomUxMHjzh2ew1A.png" /><figcaption>Using GROUP BY to count the number of products in each category and HAVING to return only the categories with 2 or more products in them.</figcaption></figure><h4>Conditional logic</h4><p><strong>Deepen your understanding of conditional logic with case statements.</strong> Using CASE statements increases your flexibility. It lets you manipulate and transform data within your query, customize query results, create new columns, derive calculated values, and categorize data based on specific conditions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*U2KQFk71tTvxn36RZI7uFQ.png" /><figcaption>Using a CASE statement in both the SELECT clause and the ORDER BY clause to categorize products by price.</figcaption></figure><h4>Join tables</h4><p><strong>Understand different types of joins and when to use them.</strong> This is a big step; it involves not only understanding joins like INNER, LEFT, and RIGHT JOINs, but also combining multiple tables. This also means understanding primary and foreign key relationships and how to join tables based on common columns. You might also start to look at UNIONs during this time.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*yAamcGM_0s9CsSFbbtQ23Q.png" /><figcaption>LEFT JOIN to find the category name of each product, using the shared column, “category_id”.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/968/1*O7gtM0eTP3Zlriuhh8EFmQ.png" /><figcaption>Increasing complexity of query and using an INNER JOIN.</figcaption></figure><h4>Combine logic and aggregations</h4><p><strong>Combine CASE statements with COUNT, SUM, MAX, MIN, AVG. </strong>Take CASE statements to the next level by using them in conjunction with aggregations. This lets you perform those aggregations based on specified conditions.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*RX0ZMOBnJT1ysZnq-6d2zQ.png" /><figcaption>Using COUNT CASE and SUM CASE to find the number of different items within each category, along with the total number in stock of each category, with a UNION ALL to combine the queries.</figcaption></figure><h4>Use subqueries, CTEs, and temp tables</h4><p><strong>Discover subqueries, CTEs, and temporary tables</strong>. While similar, subqueries, CTEs, and temporary tables all have their uses. Many times you can use whichever you’re most comfortable with and come up with the same results.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/882/1*Dkqe0Hx04xrKrflWJd08XQ.png" /><figcaption>Using a CTE (common table expression) to find total quantity of items in each category.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/938/1*Jmvs3NGN9AfrdAeDahNUxQ.png" /><figcaption>Using a subquery to find total quantity of items in each category.</figcaption></figure><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*_8tkDjCbQguNYYhz0al8Xw.png" /><figcaption>Using a temporary table to find total quantity of items in each category.</figcaption></figure><h3>Finally, dive into the deep end</h3><h4>Stored procedures</h4><p><strong>Understand the purpose of stored procedures.</strong> A stored procedure is a routine or program that can be executed multiple times. Stored procedures help to streamline database operations, increase efficiency in writing queries, and improve performance.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*HzLTNaNsnJ_1SXg1eyCe9Q.png" /><figcaption>Stored procedure will return the products in the category_id in CALL statement, along with the total quantity in stock, which is stored in the variable @total_quantity</figcaption></figure><h4>Window functions</h4><p><strong>Learn about window functions</strong>. Window functions allow you to perform calculations and analysis on a subset of rows within a window, without altering the overall result set. They can aggregate data at a granular level. With window functions, you can compute moving averages, running totals, rank data based on specific criteria, and calculate other metrics.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*ir_y8ygQ38ZsvtUCaYyShQ.png" /><figcaption>Using this window function will return the information about each product as well as the total quantity per category. Notice the final column remains the same over each category.</figcaption></figure><h4>Optimization</h4><p><strong>Optimize, optimize, optimize.</strong> Once you have a good understanding of SQL and the various concepts, it’s time to optimize your queries. You can do this by learning about indexes, understanding the <a href="https://medium.com/learning-data/cracking-the-code-understanding-the-order-of-execution-in-sql-queries-fc9d078e0068">SQL order of execution</a>, and simplifying where you can.</p><h3>Wrapping Up</h3><p>I’ll be the first to say that I haven’t mastered all of these concepts! That’s one part of SQL that I love; I’m learning more every day.</p><p>One other note here. Just because I’ve laid out this roadmap <strong>doesn’t mean that…</strong></p><ol><li>…it’s the be all, end all. This is simply a rough idea of when and how I approached my own learning.</li><li>…you have to master all of these things before applying to jobs! I certainly didn’t know how to do window functions or stored procedures before getting my first job. Focus on becoming great at the basics and the rest will follow.</li><li>…once you’ve learned all of these concepts, you’re done learning. SQL is ever-changing and growing so don’t expect to ever be “done” with learning.</li></ol><p>SQL can be incredibly powerful once you start to understand its full capabilities. It’s one of the tools that I tell aspiring data analysts that I would <em>definitely</em> recommend learning.</p><p>So there you have it! A roadmap to learning SQL. I’d love to hear what you think. What concepts did you learn first? Does your path align with my own?</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*AIprL7DjxWaCNsXa" /><figcaption>Photo by <a href="https://unsplash.com/@subtlecinematics?utm_source=medium&amp;utm_medium=referral">Subtle Cinematics</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor. Check out submission instructions </em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e"><em>here</em></a><em>.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=110600ab9643" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/cannonball-into-sql-success-a-roadmap-110600ab9643">Cannonball Into SQL Success: A Roadmap</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Things I Did on My Path to Data Analytics and What I Learned Along the Way]]></title>
            <link>https://medium.com/learning-data/things-i-did-on-my-path-to-data-analytics-and-what-i-learned-along-the-way-3a550f54432a?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/3a550f54432a</guid>
            <category><![CDATA[healthcare-industry]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[career-paths]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[life-lessons]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Thu, 15 Jun 2023 16:12:29 GMT</pubDate>
            <atom:updated>2023-06-15T16:12:29.884Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Gy9TfpOEVNpkFu3b" /><figcaption>Photo by <a href="https://unsplash.com/@anniespratt?utm_source=medium&amp;utm_medium=referral">Annie Spratt</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I started my path to data analytics without a clear goal in mind. I learned about SQL in a TikTok video (not joking) and thought it sounded interesting so I went to Udemy and bought a course. I took it, enjoyed the content, and wanted to keep learning more.</p><p>In the following weeks, I went back to Udemy and bought another course, and another, and another… I bought courses in Excel and Tableau and SQL and R and Python.</p><p>You get the idea.</p><p>I had no real direction or plan in mind; I was buying courses that sounded interesting to me and that was basically my only criteria.</p><p>As I moved through my journey, I got more thoughtful and deliberate in my plan but there was definitely a huge learning curve at the outset.</p><p><strong>But here’s the good part: I did it so you don’t have to!</strong></p><p>Welcome to: Things I Did on My Path to Data Analytics and What I Learned Along the Way… Part 1</p><h3>What I did: Bought 19 courses on Udemy and finished 2 of them</h3><p><strong><em>Rating: </em></strong><em>2/10. Wouldn’t recommend.</em></p><h4><strong>What I learned:</strong> Just because I was taking courses didn’t mean I was making progress.</h4><p>It’s easy to assume that as the course progress indicator increases, so does your breadth of knowledge. Unfortunately, that’s not how it works.</p><p>If you’re just following along with the courses and not independently practicing the skills you’re learning, chances are you’re just spinning your wheels.</p><h4><strong>What I should have done: bought courses on an “as-needed” basis.</strong></h4><p>It can be tempting to buy courses on Udemy because they’re on sale or they look interesting but taking 1 or 2 courses in each tool I wanted to learn (Excel, SQL, and Tableau for me!) and then putting those skills into practice would have been a better choice.</p><p>Completing projects, putting skills to the test, and learning where the gaps in my knowledge were would have allowed me to be more strategic in what courses I bought.</p><h4>My advice:</h4><p>Don’t buy more than one course (or subscription) at a time and don’t start your next course until you’re done with the one you’re currently working on. The courses I took were valuable but the money I wasted on the other 17, not so much.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*8UrwBpACWZKD3Vcv" /><figcaption>Photo by <a href="https://unsplash.com/@lunarts?utm_source=medium&amp;utm_medium=referral">Volodymyr Hryshchenko</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>What I did: Flitted from one topic to the next without a plan</h3><p><strong><em>Rating: </em></strong><em>1/10. Wouldn’t recommend.</em></p><h4><strong>What I learned: </strong>Creating a <a href="https://mavenanalytics.io/online-data-analysis-learning-paths">learning plan</a> should be the first step.</h4><p>This relates to my first point but I generally took courses when and how I felt like it. That meant I might be working on Excel one day and SQL the next. Not great for moving the information into my long-term memory.</p><p>By randomly selecting courses based on my immediate interests or whims (hey, some of those courses had enticing cover photos and titles!) and jumping from one course to another without a logical progression, I undermined the effectiveness of my own learning process.</p><h4><strong>What I should have done: </strong>Built a comprehensive plan that focused on learning one skill at a time and building on those skills progressively.</h4><p>A carefully designed plan would have allowed me to set clear goals, prioritize the tools in a logical order, and create a structured and systematic approach to learning.</p><h4>My advice:</h4><p>There’s no better way to get frustrated and feel like you’re not remembering anything than by having an unclear plan of action.</p><p>Figuring out exactly what tools you need to learn to get the job is a great way to focus your attention and determine exactly what course(s) you want to take and in what order. Researching what skills and tools build on others is also useful so you have an understanding of if there are any prerequisites to learning any of the tools you’re interested in.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*t8EIRddTylr7btoT" /><figcaption>Photo by <a href="https://unsplash.com/@benjaminelliott?utm_source=medium&amp;utm_medium=referral">Benjamin Elliott</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>What I did: Submitted a cover letter when applying to jobs</h3><p><strong><em>Rating: </em></strong><em>8/10. Would recommend.</em></p><h4><strong>What I learned: </strong>Even if you don’t want to hear it, coming from a non-traditional background, a cover letter <em>might be</em> key to getting your foot in the door.</h4><p>One thing I didn’t do was write the typical cover letter, one that goes something like this:</p><p><em>Dear Human In Charge of Hiring,</em></p><p><em>I came across your job posting on LinkedIn and am very interested in the job opportunity at Your Very Cool Company. After reviewing the job description and requirements, I feel I am strongly suited for this role…</em></p><p>You get the idea. Instead, I decided to do it in a more unique way. I personalized my cover letter based on what I found on the company website. For example, at the company with whom I ended up accepting my first job, I went to their website and found a uniquely formatted list of company values. It gave me the idea to format my cover letter in the same style:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*OHoNIyScHfT70kSjLWSsVA.jpeg" /><figcaption>My cover letter for one of the applications I submitted</figcaption></figure><p>Do I know if that’s what helped me get my interview? No. But did it hurt my chances? Also no. And to be honest, it was way more fun to write.</p><h4><strong>What I should have done:</strong> I wish I had done this with more of my applications.</h4><p>A sample size of one is pretty small so I can’t say for sure what impact the cover letter had.</p><h4>My advice:</h4><p>As someone coming from an entirely unrelated career, I wanted to be able to draw parallels between where I was coming from and where I wanted to go. The cover letter is one of the few places I felt like I could show my real personality and the benefits of hiring me.</p><p>Boring cover letters are…boring. Let your personality shine through and show that you put in the time and effort to learn about the company.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*YIiXSj9d04GaW7n1" /><figcaption>Photo by <a href="https://unsplash.com/@markuswinkler?utm_source=medium&amp;utm_medium=referral">Markus Winkler</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>What I did: Researched and practiced interview questions</h3><p><strong><em>Rating: </em></strong><em>10/10. Would recommend.</em></p><h4><strong>What I learned:</strong> Use resources to your advantage! Behavioral interview questions are timeless and pretty standard, all in all.</h4><p>There are only so many interview questions in the world and there are countless websites that give you suggestions, strategies, and even templates for how to answer them.</p><p>Thinking about potential interview questions and how I would answer them helped me prepare so I didn’t get stuck having to think of an answer on the spot. Here are a few of the questions I thought about prior to my interviews:</p><ul><li>Tell me about yourself. (Spoiler alert: they don’t want your entire life story; focus on things that are relevant to the role you’re interviewing for!)</li><li>How do you deal with pressure or stressful situations?</li><li>Tell me about a challenge or conflict you’ve faced at work, and how you dealt with it.</li><li>What’s a time you disagreed with a decision that was made at work?</li><li>Can you explain why you changed career paths?</li></ul><h4><strong>What I should have done:</strong> Prepared even more!</h4><p>No one wants to hear an obviously scripted response but practice a STAR answer: Situation, Task, Action, Result.</p><p>Here’s an example of a STAR response to “tell me about a challenging situation you’ve faced at work.”</p><p><em>At my previous job, I evaluated students using formal, standardized assessments to see if they qualified for occupational therapy services. Recently, one of the students I evaluated didn’t qualify based on the data </em>(As an aside: see how I threw in that the results were data-driven?)<em>. I had to explain to the parent why her child didn’t qualify for my services and she didn’t agree with my findings. I walked her through the assessment, how her child scored compared to peers, and the results I would expect to see at that age/grade level. After speaking to the parent and explaining the process in an easy-to-understand way, she agreed with my findings and accepted the results.</em></p><h4>My advice:</h4><p>Prepare, prepare, prepare. Give yourself a leg-up and soothe your interview nerves by researching often-asked questions and planning how you might answer them.</p><p>Think about framing your answers in a way that can relate back to the job you’re applying for. If it’s a job where you need to be collaborative, talk about that time you worked through a conflict with a coworker. If it’s a job with a “busy season,” mention the time you had 6 projects on your plate and were asked to take the lead on the 7th.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*bM4naHPo2WewzDGE" /><figcaption>Photo by <a href="https://unsplash.com/@wocintechchat?utm_source=medium&amp;utm_medium=referral">Christina @ wocintechchat.com</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>What I did: Leveraged my soft skills</h3><p><strong><em>Rating: </em></strong><em>1,000,000/10. Would recommend.</em></p><h4><strong>What I learned:</strong> Even though I didn’t have the technical background, I sure as heck had the soft skills needed to be successful as a data analyst.</h4><p>As a quick rundown, here are some frequently listed soft skills data analysts might need:</p><ul><li>Communication</li><li>Collaboration</li><li>Problem solving</li><li>Critical thinking</li><li>Organization</li><li>Time management</li><li>Attention to detail</li></ul><p>These soft skills, or some combination of them, are utilized in almost every profession. Being able to explain how <em>your </em>soft skills apply to the job is what’s most important. And what’s more, sometimes soft skills are harder to develop than technical skills.</p><p>Are you particularly resourceful? Talk about how you used that to gather hard-to-find data. Are you great at being adaptable? Relate that to how you would easily handle a scope- or direction-change in a project. Is communication one of your greatest assets? Mention it in regards to how you can easily explain your insights and recommendations to stakeholders.</p><p>Make sure that you don’t just focus on the technical aspects of a job description. Pay attention to the soft skills mentioned and make sure you are able to effectively demonstrate how you possess those skills.</p><h4><strong>What I should have done:</strong> Nothing, really.</h4><p>I’m not perfect by any means but I realized early on that my soft skills were what was going to differentiate me from other candidates. I knew I needed to leverage them and did so effectively.</p><h4>My advice:</h4><p>This is your chance to gas yourself up! Don’t be afraid to put your soft skills on display and figure out exactly how you would use them in different settings.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*mSBvYCIg9l4ThqwX" /><figcaption>Photo by <a href="https://unsplash.com/@srz?utm_source=medium&amp;utm_medium=referral">sydney Rae</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><h3>At the end of the day, your learning path is yours alone.</h3><p>Find what works for you and stick with it, whether that means taking my advice or disregarding it entirely! These are just a few of the things that I found on my own journey.</p><p>Stay tuned for Part 2 of Things I Did on My Path to Data Analytics and What I Learned Along the Way because, believe me, there’s loads more.</p><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor. Check out submission instructions </em><a href="https://medium.com/learning-data/how-to-get-your-work-published-by-learning-data-with-maven-analytics-7df21e466a3e?source=collection_home---------0----------------------------"><em>here</em></a><em>.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=3a550f54432a" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/things-i-did-on-my-path-to-data-analytics-and-what-i-learned-along-the-way-3a550f54432a">Things I Did on My Path to Data Analytics and What I Learned Along the Way</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How I Moved From Healthcare to Data Analytics and Why You Should Too]]></title>
            <link>https://medium.com/learning-data/how-i-moved-from-healthcare-to-data-analytics-and-why-you-should-too-607503982cc1?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/607503982cc1</guid>
            <category><![CDATA[healthcare-industry]]></category>
            <category><![CDATA[career-paths]]></category>
            <category><![CDATA[data-analytics]]></category>
            <category><![CDATA[life-lessons]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Tue, 30 May 2023 18:08:18 GMT</pubDate>
            <atom:updated>2023-05-30T18:08:18.555Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*jLIY3XD69WatzYU5" /><figcaption>Photo by <a href="https://unsplash.com/pt-br/@vladbagacian?utm_source=medium&amp;utm_medium=referral">Vlad Bagacian</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>I knew early on in my occupational therapy career that it was not going to be my “forever” career.</p><p>A nonexistent work-life balance, the expectation to either work off the clock or somehow meet the elusive 90%+ productivity demand, feeling disrespected and like the lowest person on the totem pole, piles of paperwork and documentation, little upward growth… it all added up very quickly. Add to that, the lack of mentorship and supervision, and I had myself a <strong>perfect storm of dissatisfaction and burn out.</strong></p><p>You might ask, <em>“So if it was that unfulfilling, you left the field immediately then, right?”</em></p><p>Nope.</p><p><em>“You left after a couple of years and multiple settings, right?”</em></p><p>Not quite.</p><p><em>“You left the field after working for five years and with three different populations…right?”</em></p><p>Don’t I wish.</p><p>What really happened: After eight years in the field, four populations, and five different positions, I <em>finally</em> left occupational therapy.</p><p>Backing up a little bit: I got serious about my search for my next career about six years ago. I knew two things early on: first, that I was interested in getting into tech, and second, that I wanted something entirely different. I wasn’t sure how my skills as an occupational therapist would ever apply outside of the healthcare world.</p><p>After all, what other jobs would require me to know how to transfer patients, use a sock aid, form the letters of the alphabet correctly, and recognize the difference between sensory seeking and sensory sensitivity?</p><p>Not many, as it turns out.</p><h3>Leveraging my transferable skills</h3><p><strong>I had to start thinking strategically.</strong> I wouldn’t be able to find a new career that allowed me to use the concrete knowledge I had gained but what about the underlying skills?</p><p>I realized that I had this valuable toolbox of soft and transferable skills that could be applied to SO many different jobs! I sat down and made a list of general skills I used as an occupational therapist. It looked a little like this:</p><ul><li>Communication</li><li>Empathy</li><li>Flexibility</li><li>Collaboration</li><li>Critical thinking</li><li>Organization</li><li>Attention to detail</li><li>Problem solving</li><li>Creativity</li></ul><p>When that finally clicked for me, I saw that I did have an invaluable set of skills, I just needed to <strong>reframe the way I was thinking about them.</strong></p><h3>Finding a job with growing demand</h3><p>The next roadblock was that I wanted a career in a field that wasn’t likely to go away. What I mean by that is: I saw the way the occupational therapy profession was moving, with insurance companies cutting therapy minutes in order to cut costs, other disciplines encroaching on what we saw as “our domain”, and the constant devaluation of occupational therapists as, “oh they’re just like physical therapists but they work on the upper body!”</p><p><strong>I wanted a job in a field that’s here to stay.</strong></p><p>But in addition to that, I didn’t want to try to get into a field that was overly saturated. I considered UX design for a long time but wasn’t prepared to really try to make it in what I saw as an increasingly competitive career. That’s not to say that UX design isn’t a fantastic possibility for healthcare professionals looking to make a change, just that it wasn’t for me.</p><p><strong>Enter: data analytics.</strong></p><p>About 15 months ago, I started on my journey to data analytics. With data becoming increasingly available at expeditious rates, I felt confident that data analytics would continue to be necessary (as an aside, I continue to feel this way, despite recent advancements in AI). When I looked at job prospects, I found that there were tons of entry-level data analyst opportunities.</p><p><strong>I was sold.</strong></p><h3>Keeping what satisfied me</h3><p>Despite how it may appear, there were parts of my job that I genuinely enjoyed. There was, after all, a reason that I got into occupational therapy in the first place. I wanted to make sure I didn’t lose sight of those things in my desire to shift careers.</p><p>Staying true to form, I made a list of the things I did enjoy:</p><ul><li>Helping people</li><li>Creatively thinking about problems</li><li>Solving puzzles</li><li>Learning everything I could about specific topics</li></ul><p>I used that list as a measure against potential new careers.</p><p>And it helped! When I discovered data analytics and started considering it as a possible career, I went back to my list…</p><p><em>Do data analysts help people?</em> Definitely. We provide answers to stakeholders and help drive business decisions.</p><p><em>Can data analysts think creatively about problems?</em> Most assuredly; datasets can be messy, requests can be unclear, and visualizations don’t always work the way you need them to.</p><p><em>What about solving puzzles?</em> Certainly! Data analysis is entirely about solving puzzles, coming up with meaningful insights, and helping clear the way for better business decisions.</p><p><em>Can data analysts learn a lot about a specific topic?</em> It’s almost required — data analysts need to be experts in certain tools and skills but they also can become experts in their domain, the industry they work in, or entire parts of the data lifecycle.</p><p>It seemed like a match made in heaven.</p><h3>Searching for balance</h3><p>On top of everything else, I decided I wasn’t going to leave OT unless I could find a career that offered me a better work-life balance. I was determined that <strong>there was no way I would leave one job with little flexibility just to find myself in the same situation.</strong></p><p>The devil you know and all that jazz.</p><p>In addition to location flexibility, I also wanted a job that allowed for <strong>better balance throughout the workday.</strong> Occupational therapists are often required to meet absurd productivity demands or only get paid for the amount of time they’re face-to-face with a patient.</p><p>Imagine being told you only have 6 minutes per hour to do literally everything else your job requires except for face-to-face interactions with clients or stakeholders, or that if a client cancels, it comes out of your paycheck. It’s exhausting and sets you up for failure.</p><p>Luckily, data analytics fit the bill here, too. I looked at tons of job postings and many of them were offering hybrid or remote work. Plenty of data analysts whom I was following on LinkedIn mentioned their schedule flexibility so I felt confident that I could find the same.</p><h3>Discovering countless opportunities for growth</h3><p>The more I researched data analytics (read: watched TikTok videos, read multiple “A Day in the Life of…”, <a href="https://medium.com/learning-data/strength-in-numbers-building-an-advisory-board-for-your-data-career-a79dcc772440">followed data analysts</a> on LinkedIn), the more I was certain that <strong>this was it</strong>.</p><p>But before I really went whole-hog, I wanted to make sure that data analytics had something that occupational therapy did not: <strong>room for growth.</strong></p><p>One of my biggest complaints about occupational therapy was (and is) that there just wasn’t space to grow. Unless you wanted to become a Director of Rehab or open your own practice, you were either an OT or a senior OT. That was basically it.</p><p>Luckily for me, there are tons of opportunities for growth in the data field! I could become a data analyst or a business intelligence analyst. I could advance my skills and become a data scientist or engineer. I could become an expert in database architecture. I could move into management and lead a team of analysts. Heck, I could shoot for the stars and become a Chief Data Officer!</p><p>The room for growth is seemingly endless.</p><h3>Meeting my match</h3><p>And so here I am, nine years later, a little older and much more self-reflective.</p><p>I’m in a job I love, with great work-life balance and flexibility in my work day. I solve puzzles and answer questions all day long. I get to be creative, empathetic, and collaborative. I can firmly say that I made the right choice.</p><p>But why am I telling this story? Because there’s seemingly a mass exodus of healthcare professionals in the United States and <strong>my story isn’t unique.</strong></p><p>Doctors, nurses, PTs, OTs, SLPs, and more are getting burnt out by high demands and low flexibility. They’re experiencing not just a <em>bad</em> work-life balance, but <strong>no</strong> work-life balance. Regulations continue to get more stringent and the red tape keeps piling up.</p><p>This is all to say: if you’re one of those people who are burnt out, feeling unfulfilled, and ready to leave, don’t be me. Don’t wait for 8 years, continuously thinking, “well maybe this population is a better fit,” or, “this setting could be the one!”</p><p><strong>Start making your own plan. </strong>Think about your own soft skills, the things you do like about your job, what your requirements are for your future career, and discover what else is out there.</p><p><strong>Who knows, maybe data analytics is right for you, too.</strong></p><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=607503982cc1" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/how-i-moved-from-healthcare-to-data-analytics-and-why-you-should-too-607503982cc1">How I Moved From Healthcare to Data Analytics and Why You Should Too</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Cracking the Code: Understanding the Order of Execution in SQL Queries]]></title>
            <link>https://medium.com/learning-data/cracking-the-code-understanding-the-order-of-execution-in-sql-queries-fc9d078e0068?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/fc9d078e0068</guid>
            <category><![CDATA[learn-to-code]]></category>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[sql]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data-science]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Thu, 18 May 2023 15:18:07 GMT</pubDate>
            <atom:updated>2023-05-18T15:18:07.768Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*4w3N3zLeYkdIWfgG" /><figcaption>Photo by <a href="https://unsplash.com/@olav_ahrens?utm_source=medium&amp;utm_medium=referral">Olav Ahrens Røtne</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>When you first start learning SQL, you most often begin with learning the statements and clauses in this order:</p><h4><strong>- SELECT</strong></h4><h4><strong>- FROM</strong></h4><h4><strong>- WHERE</strong></h4><h4><strong>- GROUP BY</strong></h4><h4><strong>- HAVING</strong></h4><h4><strong>- ORDER BY</strong></h4><p>That’s the way they’re written in our queries, so it makes sense to learn them that way. But, is that the same order in which the query is executed?</p><p>Let’s find out!</p><h3>Diving in</h3><p>Let’s say we have two tables, <em>employees</em> and <em>department</em>.</p><h4>Employees table:</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Mwu0cRjBFwadL4yne7-wXA.png" /><figcaption>The <strong><em>employees</em></strong> table contains 1000 rows with the following columns: employee_id, first_name, last_name, email, age, salary, department_id, and bonus.</figcaption></figure><h4>Department table:</h4><figure><img alt="" src="https://cdn-images-1.medium.com/max/668/1*_nc7jI75w8J3px4T6QW9zQ.png" /><figcaption>The <strong>department</strong> table contains the following columns: department_id and department.</figcaption></figure><h4>The question:</h4><p>Using the employees and department tables, <em>we want to find the average salary by department.</em></p><p>We can do this with the following query:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/826/1*6pFbVWwBT9Z-A6mhcZNB6Q.png" /></figure><h4>The result:</h4><p>The above query returns this result:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/668/1*MQ9LGU9KQZs3-gp2c_gaKA.png" /></figure><p>But what’s going on behind the scenes? How is this query actually executed? Here’s a sneak peak:</p><h3>The order of execution</h3><h4><strong>1. FROM and JOINs</strong></h4><p>The FROM clause and any JOINs are executed in order to determine the tables involved in the query and form the source for retrieving the data.</p><p>In the example query above, this means it’s taking the entire <em>employees</em> table and joining the <em>department</em> table if there is a corresponding department_id.</p><h4><strong>2. WHERE</strong></h4><p>The WHERE clause filters the rows based on the specified constraints. Rows that don’t meet the constraints are removed from the set of data.</p><p>In the example query, we filter out any row from the <em>employees</em> table that contains a person with an <em>age</em> greater than 30.</p><h4><strong>3. GROUP BY</strong></h4><p>The GROUP BY clause is executed on the rows that remain after the WHERE clause has filtered our original result set.</p><p>In the example query, our results get grouped by <em>department</em>. That means there are only as many rows as there are unique department values.</p><h4><strong>4. HAVING</strong></h4><p>The HAVING clause filters out the grouped rows that don’t meet the criteria.</p><p>In the example query, the HAVING clause filters out any groups of records that contain fewer than 5 employees.</p><h4><strong>5. SELECT</strong></h4><p>The SELECT clause is executed to determine the columns to be selected and retrieved from the tables.</p><p>In the example query, the <em>department</em> column and the <em>salary</em> column are selected, with the salary aggregated to return the rounded average salary per department.</p><h4><strong>6. ORDER BY</strong></h4><p>The ORDER BY clause is executed to sort the results in a specified order.</p><p>In the example query, the results are returned from highest average salary to lowest average salary.</p><h4><strong>7. LIMIT</strong></h4><p>If present, the LIMIT clause would specify the number of rows returned and discard the rest.</p><h3>Why does it matter?</h3><p>You may be thinking at this point, “okay, great, but why does the order of execution matter?” There are a few reasons:</p><ol><li><strong>Query optimization:</strong> by understanding the order in which your query executes, you can optimize your queries for better performance.</li><li><strong>Expected results:</strong> understanding the order of execution can help you to get the desired results by applying appropriate filters, aggregations, and conditions in the correct order.</li><li><strong>Troubleshooting:</strong> understanding the order of execution helps in identifying where data is not being filtered correctly, grouped appropriately, or sorted as expected.</li><li><strong>Developing complex queries:</strong> understanding the order of execution helps you organize and structure your queries correctly, ensuring the logic flows smoothly and producing the desired output.</li></ol><h4>An example:</h4><p>If we wanted to return the name and total compensation of any employee who made over $100k/year, we might write a query like this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/812/1*O_25N2w5Fbx0OR_-O6w6lg.png" /></figure><p>In MySQL, we get the following error message: <em>Error Code: 1054. Unknown column ‘total_comp’ in ‘where clause’.</em> Can you figure out why?</p><p>Based on the order of execution, the WHERE clause is executed before the SELECT statement, so the query doesn’t recognize the alias ‘total_comp’. Instead, we could do this:</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/812/1*KjGj4iJ1iqGxGXqR74a0nQ.png" /></figure><p>And as we would expect, we return all of the employees who meet our criteria.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/726/1*RGg8S5n2DFrzUP1QNuzJAQ.png" /></figure><p>Success!</p><h3>Conclusion</h3><p>As you progress in your journey of learning and using SQL, being able to optimize, debug, and troubleshoot your queries will be of the utmost importance. Understanding how the order of execution occurs will help you do just that!</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*Bt5pak1bsRnBKUHw" /><figcaption>Photo by <a href="https://unsplash.com/@dynamo10?utm_source=medium&amp;utm_medium=referral">Rahul Dey</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fc9d078e0068" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/cracking-the-code-understanding-the-order-of-execution-in-sql-queries-fc9d078e0068">Cracking the Code: Understanding the Order of Execution in SQL Queries</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Data Analytics: Unlocking Insights from Data]]></title>
            <link>https://medium.com/learning-data/data-analytics-unlocking-insights-from-data-cda2ab7ad509?source=rss-9626d419793e------2</link>
            <guid isPermaLink="false">https://medium.com/p/cda2ab7ad509</guid>
            <category><![CDATA[learning]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[data]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <category><![CDATA[analytics]]></category>
            <dc:creator><![CDATA[Lauren Rosenthal]]></dc:creator>
            <pubDate>Mon, 08 May 2023 15:31:11 GMT</pubDate>
            <atom:updated>2023-05-08T16:50:52.539Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/0*X_haCIHSNGuJLtx6" /><figcaption>Photo by <a href="https://unsplash.com/@kmuza?utm_source=medium&amp;utm_medium=referral">Carlos Muza</a> on <a href="https://unsplash.com/?utm_source=medium&amp;utm_medium=referral">Unsplash</a></figcaption></figure><p>Data is all around us. It comes in various forms, ranging from structured to unstructured data. From the health data of individuals to the financial data of businesses to the marketing data of consumers, data is an invaluable resource, one that can provide insights that can be leveraged to make informed decisions. However, collecting, organizing, and interpreting data can be a challenging task. That’s where data analytics comes in!</p><h3><strong>What is data?</strong></h3><p>There are plenty of definitions of data. In its most basic form, data is facts, figures, and statistics that are used to convey information. It can be structured, like an Excel table, or unstructured, like a collection of social media posts. When you think of data, you might primarily think of structured data, but that’s only one small subset of the data that is available to us. Data can come in many forms, like:</p><ul><li>Text data</li><li>Numerical data</li><li>Geospatial data</li><li>Audio data</li><li>Visual data</li><li>Transactional data</li><li>Web data</li></ul><h3><strong>What is data analytics?</strong></h3><p>Data analytics is the process of examining and interpreting data to uncover patterns, relationships, and trends. It involves collecting, cleaning, analyzing, and interpreting data to gain insights and make informed decisions. Data analytics is an interdisciplinary field that incorporates aspects of statistics, computer science, and domain expertise. But data analytics is a career that is open to more than just scientists and statisticians. In fact, due to the nature of data analytics, oftentimes people who possess strategic thinking skills, technical proficiency, and communication skills are very successful in the field. We like to call this the Analyst Trifecta.</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*cYRdBgoGKRu20NubgdJ4pw.jpeg" /><figcaption>The Analyst Trifecta</figcaption></figure><h3><strong>How is data analytics used?</strong></h3><p>Data analytics is used in a wide range of industries, from healthcare to finance to retail to manufacturing and beyond. It’s used to find trends or patterns in a particular dataset that can give relevant and insightful information about a particular area of business. For example, data analytics is used in healthcare to analyze patient data to identify risk factors, in marketing to understand customer behavior, and in finance to detect fraud. Generally, data analytics can be used to predict future trends or outcomes, identify areas for cost savings or process improvements, optimize marketing campaigns, detect fraud or security breaches, improve product design and user experience, and more. At its core, data analytics is used to optimize business processes, improve customer experiences, and inform strategic decisions.</p><h3><strong>Types of data analysis</strong></h3><p>There are four main types of data analysis: descriptive, diagnostic, predictive, and prescriptive.</p><p><strong><em>Descriptive analytics</em></strong> often happens at the outset of an analysis. It involves analyzing data to understand <strong>what</strong> <strong>happened</strong> in the past. Descriptive analytics explores and summarizes large sets of data to begin to identify patterns, relationships, and trends. It answers questions like, “What is the revenue for the past year?” and “How many website visitors did we have last month?”</p><p><strong><em>Diagnostic analytics</em></strong> takes the analysis to the next level. It involves analyzing data to understand <strong>why</strong> <strong>something happened</strong> in the past. By using techniques like drill-down analysis, root cause analysis, regression analysis, and data mining, it aims to answer questions like, “Why did our sales decrease last month?” and “What caused the increase in website traffic?”</p><p><strong><em>Predictive analytics</em></strong> involves analyzing data to predict what <strong>will happen</strong> in the future. It uses tools and techniques like statistical algorithms, machine learning, and data mining to make predictions, such as in sales forecasting, inventory management, fraud detection, and risk assessment. It answers questions like, “What will be our sales figures next quarter?” and “How many website visitors can we expect next month?”</p><p><strong><em>Prescriptive analytics</em></strong> involves analyzing data to determine the <strong>best course of action</strong> to take. With techniques like optimization, simulation, and machine learning algorithms, prescriptive analytics analyzes large datasets to identify the best solution or action in a given situation. It takes the insights obtained from descriptive, diagnostic, and predictive analytics and uses them to answer questions like, “What should we do to increase our sales figures?” and “What changes should we make to our website to improve customer satisfaction?”</p><h3><strong>What does a data analyst do?</strong></h3><p>A data analyst is responsible for collecting, cleaning, analyzing, and interpreting data to provide insights and recommendations. They work with various stakeholders to understand their data needs and help them make data-driven decisions. A data analyst should have strong analytical skills, attention to detail, and the ability to communicate complex information in a simple and understandable way.</p><h3><strong><em>Data analysis workflow</em></strong></h3><p>One approach to the <a href="https://mavenanalytics.io/course/thinking-like-an-analyst"><strong>data analysis workflow</strong></a> involves several steps:</p><ol><li>Understanding the business case: Data analysts work with stakeholders to understand the business problem they are trying to solve. They need to have a clear understanding of the goals and objectives of the project to be able to identify the most relevant data sources.</li><li>Building a measurement plan: Once the business problem has been identified, data analysts need to define the metrics that will be used to measure the success of the project. This involves identifying the key performance indicators (KPIs) that are relevant to the project.</li><li>Collecting and preparing data: Data analysts need to collect and organize data from various sources, such as databases, spreadsheets, and APIs. They also need to clean and transform the data to ensure accuracy and consistency.</li><li>Understanding data: Data analysts need to have a deep understanding of the data they are working with. They need to identify any outliers, missing values, or inconsistencies in the data and make decisions on how to handle them.</li><li>Analyzing and visualizing data: Once the data has been cleaned and prepared, data analysts use various techniques to identify trends and patterns in the data. They also use data visualization tools such as charts and graphs to create visual representations of the data that can be easily understood by stakeholders.</li><li>Developing data-driven insights: Data analysts use their analysis and visualizations to develop insights and recommendations based on the data. They need to be able to translate the data into actionable insights that can help stakeholders make informed decisions.</li><li>Measuring, testing, and optimizing the process: Data analysts need to continuously measure and test the data analysis process to ensure that it is accurate and reliable. They also need to be able to optimize the process to improve efficiency and effectiveness.</li></ol><h3><strong>Skills required for data analytics</strong></h3><p>To become a data analyst, you need a mix of technical and soft skills. Technical skills include proficiency in tools like Excel, SQL, and data visualization. You also need to have a solid understanding of statistics and data analysis techniques. In addition, soft skills are also crucial for data analysts to be effective in their roles.</p><p><strong><em>Tools used by data analysts</em></strong></p><p>Data analysts use various tools to collect, clean, analyze, and present data. Some of the commonly used tools are:</p><ol><li><strong>Excel/Google Sheets:</strong> These spreadsheet software programs are used for data entry, cleaning, organization, and basic analysis.</li><li><strong>SQL </strong>(Structured Query Language): This is one of the primary coding languages used to extract and manipulate data from relational databases.</li><li><strong>Data visualization tools:</strong> Data visualization tools like Power BI and Tableau are used to create visualizations that make it easy to understand and interpret data.</li><li><strong>Python/R:</strong> Python and R are programming languages that are commonly used for statistical analysis and machine learning.</li></ol><p><strong><em>Soft skills needed by data analysts</em></strong></p><p><strong>Communication</strong>: Data analysts need to be able to effectively communicate complex information to both technical and non-technical stakeholders. They should be able to explain their analysis and insights in a way that is easy to understand and relevant to the audience.</p><p><strong>Problem-solving</strong>: Data analysts should be able to identify problems and find solutions. They should be able to break down complex problems into smaller, more manageable components and come up with effective solutions.</p><p><strong>Attention to detail</strong>: Data analysis requires a high level of attention to detail to ensure accuracy and avoid errors. Data analysts should be meticulous in their work and have a strong eye for detail.</p><p><strong>Time management</strong>: Data analysts need to be able to manage their time effectively to meet deadlines and prioritize tasks. They should be able to balance competing demands and complete projects within a given timeframe.</p><p><strong>Curiosity</strong>: Data analysts should be curious and have a desire to learn. They should be willing to explore data and be open to new ideas and perspectives.</p><p><strong>Collaboration</strong>: Data analysis often involves working with a team of stakeholders from different departments. Data analysts should be able to collaborate effectively with others, share ideas, and work towards a common goal.</p><p><strong>Business acumen</strong>: Data analysts should have an understanding of the business context and the industry they are working in. They should be able to connect the data insights to the business goals and make recommendations that align with the company’s overall strategy.</p><h3><strong>Key takeaways</strong></h3><p>Data analytics is a rapidly growing field that is transforming the way organizations make decisions. By collecting, organizing, and analyzing data, data analysts can unlock insights that can help organizations make informed decisions. Understanding the different types of data analysis, the workflow, the tools used, and the required skills can help you get started on your journey toward becoming a data analyst.</p><p><em>If you liked this, we’d love for you to subscribe to our publication.</em></p><p><em>And drop us a comment letting us know what you’d like to see next. You can also submit your own writing for us to promote, so don’t be shy if you would like to become a contributor.</em></p><p><em>Happy learning!</em></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=cda2ab7ad509" width="1" height="1" alt=""><hr><p><a href="https://medium.com/learning-data/data-analytics-unlocking-insights-from-data-cda2ab7ad509">Data Analytics: Unlocking Insights from Data</a> was originally published in <a href="https://medium.com/learning-data">Learning Data</a> on Medium, where people are continuing the conversation by highlighting and responding to this story.</p>]]></content:encoded>
        </item>
    </channel>
</rss>