Andy Kriebel’s Post

Hey #datafam, great advice by Andy Kriebel below. The only way to get better is practice. I have lived this approach and would not be where I am at today without constant practice and honing of my #dataviz skills. There is no substitute for hands-on work. You can get all the advice you want and need but if you do not use it, your skills get stale and you do not grow. Until next time. #data #dataviz #dataanalytics #tableau #practice #hands-on

Should you learn Tableau? Or should you learn Power BI? Truthfully, there is no right or wrong answer and I’ll explain why. You must ask yourself, what’s the purpose of Tableau and Power BI? They’re both BI tools used to create amazing data visualizations, which is an underrated skill to have. However, most people get conflicted opinions on which to learn, or even learn both. In my opinion, you must focus on your data storytelling and visual skills. Whichever tool you choose is just helping you learn those exact skills. People like to base their opinions on their personal experiences. If someone primarily works in Tableau, what do you think they’ll recommend? I’ve worked in both and guess what? I now use Looker at my new job. But at the end of the day, my overall knowledge will help me beyond learning the new interface of Looker. My advice: pick a tool, learn data storytelling and visualization skills, and move on.

𝐅𝐫𝐨𝐦 𝐎𝐯𝐞𝐫𝐰𝐡𝐞𝐥𝐦𝐞𝐝 𝐭𝐨 𝐒𝐭𝐫𝐮𝐜𝐭𝐮𝐫𝐞𝐝: 𝐋𝐞𝐬𝐬𝐨𝐧𝐬 𝐟𝐫𝐨𝐦 𝐌𝐲 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐆𝐫𝐨𝐰𝐭𝐡🏛️📈 When I started in data analytics, I thought the key to success was mastering every tool out there—Excel, Power BI, Tableau, SQL, Python... the list felt endless. I jumped from one tool to the next, thinking I’d improve faster. But instead of progressing, I felt stuck and overwhelmed. 😓 Then I realized something: it’s not about how many tools you know—it’s about how well you use the ones you’ve mastered.✨ 𝐈 𝐝𝐞𝐜𝐢𝐝𝐞𝐝 𝐭𝐨 𝐟𝐨𝐥𝐥𝐨𝐰 𝐚 𝐥𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐬𝐭𝐫𝐮𝐜𝐭𝐮𝐫𝐞: - I started with Excel🧮, mastered its formulas and functions. - Then I moved on to Power BI📊 to build dynamic dashboards. - Now, I’m learning Tableau📈, focusing on storytelling through visuals. I still haven’t dived into SQL yet, and that’s okay. 𝐇𝐞𝐫𝐞’𝐬 𝐰𝐡𝐚𝐭 𝐭𝐡𝐢𝐬 𝐬𝐭𝐫𝐮𝐜𝐭𝐮𝐫𝐞𝐝 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐚𝐮𝐠𝐡𝐭 𝐦𝐞: 💡 Master one tool at a time. Chasing every new tool is counterproductive. Start small, build your confidence, and progress gradually. 🧹 Data cleaning is everything. No matter how skilled you are with tools, messy data leads to flawed insights. Cleaning data often takes more time than the actual analysis—but it’s worth it. ✅ Mistakes happen—double-check everything. Human error and biases can creep in easily. Always review your analysis with fresh eyes. 📋 Keep dashboards simple. Fancy visuals are great, but clarity comes first. A good dashboard balances aesthetics with functionality to communicate insights effectively. 📖 Storytelling makes data meaningful. Without a story, data is just numbers. Explaining the “why” and “how” behind the numbers is what makes your analysis valuable. If I could give one piece of advice to beginners, it would be this: 𝒇𝒐𝒄𝒖𝒔 𝒐𝒏 𝒅𝒐𝒊𝒏𝒈 𝒕𝒉𝒊𝒏𝒈𝒔 𝒘𝒆𝒍𝒍, 𝒏𝒐𝒕 𝒇𝒂𝒔𝒕. Analytics isn’t a race—it’s about providing insights that truly matter. 👉 What’s a lesson you’ve learned while working with data? Let’s share and learn from each other in the comments! #DataAnalytics #Excel #PowerBI #Tableau #DataStorytelling #DataCleaning #DashboardDesign

Learning Excel? The LAMBDA function is a game-changer… In a nutshell, the LAMBDA function lets you create custom formulas that you can use across your workbook (without VBA or macros!!) The syntax is simple: =LAMBA( parameter, [parameter], [...], calculation ) Parameters are inputs (like variables) for your formula The calculation, which must be the last argument, uses those parameters and evaluates them inside a formula that you define. For example: =LAMDA(x,y,x+y) In this case, “x” and “y” are the parameters and “x+y” is the calculation, which adds them together. However, you’ll notice that “x” and “y” don't have any values assigned. There are 2 ways to do this: 1. Explicitly within the formula: =LAMBDA(x,y,x+y)(A1,A2) -- this will sum the values of A1 and A2 2. Using name manager to create a new function Click CTRL+F3 and create a new name, like “XplusY” In the “Refers to” section, paste the function: =LAMDA(x,y,x+y) Press OK and call this function just like any other: =XplusY(A1,A2) -- this will sum the values of A1 and A2 This is an example meant to showcase how LAMBDA works, but the possibilities are endless! Do you have any preferred use cases for LAMBDA? Let us know in the comments! #excel #data #analytics #businessintelligence

I'd always aim for Tableau projects "But can it be done in Power BI?", I was asked the other day. In theory, yes. Some might say: "Whether it's Power BI, Tableau, or even Qlick, it only matters to deliver business solutions." Here's my take on it: While analytics tools offer similar functionality, the devil lies in the details. And as much as I like the idea of "analogous tools", recruiters do tend to favor specific ones, right? So, if you're eyeing a specific company, do your homework. Find out what application they use. And keep learning and expanding your toolbox. There's no one-size-fits-all tool out there.

𝗧𝗵𝗲 𝗕𝗶𝗴𝗴𝗲𝘀𝘁 𝗠𝘆𝘁𝗵𝘀 𝗔𝗯𝗼𝘂𝘁 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗬𝗼𝘂 𝗦𝗵𝗼𝘂𝗹𝗱 𝗦𝘁𝗼𝗽 𝗕𝗲𝗹𝗶𝗲𝘃𝗶𝗻𝗴! When I first started learning Power BI, I heard a lot of myths floating around. One that stuck with me was, "𝘙𝘦𝘱𝘰𝘳𝘵𝘴 𝘪𝘯 𝘗𝘰𝘸𝘦𝘳 𝘉𝘐 𝘢𝘳𝘦 𝘤𝘰𝘮𝘱𝘭𝘪𝘤𝘢𝘵𝘦𝘥 𝘢𝘯𝘥 𝘩𝘢𝘳𝘥 𝘵𝘰 𝘤𝘳𝘦𝘢𝘵𝘦." Let me tell you, That's not true at all! Power BI is about visualizing data to make it easier to understand. If you can use Excel, you can definitely make it work! 📊 Another myth? "𝘗𝘰𝘸𝘦𝘳 𝘉𝘐 𝘪𝘴 𝘰𝘯𝘭𝘺 𝘧𝘰𝘳 𝘥𝘢𝘵𝘢 𝘢𝘯𝘢𝘭𝘺𝘴𝘵𝘴." Wrong again! Any professional—from marketing to finance—can benefit from Power BI. You just need to understand the data to turn it into a story. And here’s the biggest one: "𝘗𝘰𝘸𝘦𝘳 𝘉𝘐 𝘩𝘢𝘴 𝘴𝘶𝘱𝘦𝘳𝘩𝘦𝘳𝘰 𝘴𝘬𝘪𝘭𝘭𝘴 𝘴𝘰 𝘧𝘪𝘯𝘢𝘭 𝘳𝘦𝘱𝘰𝘳𝘵𝘴 𝘢𝘳𝘦 𝘳𝘦𝘢𝘭𝘭𝘺 𝘩𝘢𝘳𝘥 𝘵𝘰 𝘢𝘤𝘩𝘪𝘦𝘷𝘦." In reality, It’s a tool that helps you bring your data to life in a visual, engaging way! ✨ So, Don’t let these myths hold you back. What’s a myth you’ve heard about Power BI? Or what’s the most challenging part of creating reports for you? 😄 🚀 Follow Simala Om Prakash for more content 👍 React 💬 Comment ♻️ Share

I am excited to share that I have recently completed the Microsoft Excel: VLOOKUP and HLOOKUP class by MySkill. In this class, I learned how VLOOKUP and HLOOKUP enhance my ability to search and organize data within tables. VLOOKUP helps me search for values in the leftmost column and return corresponding values from other columns in the same row, while HLOOKUP allows me to search in the top row and return values from other rows in the same column. Additionally, I discovered that INDEX MATCH provides a more flexible and efficient method for data lookup by combining the INDEX function, which returns a value from a specific position in a table, with the MATCH function, which finds the position of a value within the table. With these skills, I am now better equipped to tackle complex data analysis challenges and deliver deeper insights.

🚀 Excel: The Unstoppable Force in Data Analytics! 🚀 In a world dominated by advanced tools like Python, R, and Power BI, Microsoft Excel continues to be a go-to for analysts, managers, and professionals across industries. But why does Excel stand the test of time? 🤔 💡 Here’s why Excel remains a must-have skill for anyone working with data: 🔹 Data at Your Fingertips: Excel allows for quick and easy data organization, cleansing, and transformation. Whether it's using simple formulas or advanced pivot tables, Excel makes it easy to get valuable insights in just a few clicks. 🔹 Powerful Analytical Tools: Need to analyze trends, perform calculations, or create dashboards? Excel’s built-in functions like VLOOKUP, INDEX-MATCH, and SUMIFS, paired with data visualization tools (charts, graphs, conditional formatting), turn raw data into actionable insights. 🔹 Automation Made Simple: Tired of repetitive tasks? Excel’s macros and VBA let you automate workflows, saving time and reducing errors. 🔹 Versatility Meets Integration: Excel integrates seamlessly with tools like Python, Power BI, and SQL, expanding its functionality while keeping the learning curve approachable. 🔹 Universal and Accessible: No matter your industry—finance, marketing, supply chain, or operations—Excel is the common language for data and decision-making. ✨ From creating interactive dashboards to quick data crunching, Excel is a data powerhouse that makes it easier to drive business decisions. It’s more than just a spreadsheet; it’s a skill that opens doors to endless possibilities. 🚪 📈 Still using Excel? Share your favorite feature in the comments! 🔖 Doc Credit: Filtered 🔖 Follow Chetan Kumar for more updates! #Excel #DataAnalytics #MicrosoftExcel #Automation #DataDriven #Productivity #ExcelTips #DataVisualization #ExcelSkills #BusinessIntelligence

🚀 Learning Excel Functions & Visualizing Data! Hi LinkedIn Network! 👋 Today, I explored some essential Excel tools: VLOOKUP, HLOOKUP, XLOOKUP, and Pivot Charts. These functions are incredibly useful for simplifying data lookups and creating visual insights. 💡 Here’s what I achieved: VLOOKUP & HLOOKUP: Learned how to find specific data points in large datasets. XLOOKUP: Discovered how versatile and efficient it is for advanced lookups. Pivot Charts: Created charts directly from data tables to visualize trends and patterns more clearly. ✨ Practicing these skills has been exciting, and I’m starting to see how these tools can be applied to real-world scenarios. It’s a step forward in my journey to becoming a skilled data analyst! 🌟 If you have tips, tricks, or interesting use cases for these Excel functions, feel free to share! #Excel #DataAnalytics #LearningJourney #VLOOKUP #PivotCharts #ExcelSkills

Are you tired of spending countless hours in spreadsheets? Look no further than Tableau. By combining #Excel and #Tableau, you can easily answer your most challenging business questions and uncover new insights hidden within your data. Join us for a webinar and discover how to: - Combine your spreadsheets for deeper analysis - Find new insights faster, saving both time and money - Transform your spreadsheets into interactive dashboards - Share visual insights online to inform business decisions Don't miss out on this opportunity to streamline your workflow and drive your business forward. Register now! #Data #DataVisualization #Metrics #Insights #Outcomes #AI #Tableau #Salesforce