Ray Givler’s Post

💡 **Pro Tip for Tableau Users: Level of Detail (LOD) Expressions** 💡 If you’re working with complex data in Tableau Desktop, you’ve likely encountered situations where basic calculations just don’t cut it. That’s where **Level of Detail (LOD) expressions** come in handy! Here’s why I find LOD expressions so powerful: 1️⃣ **Flexible Aggregation**: LODs allow us to calculate values at different data levels—like showing monthly and yearly sales on the same view without changing the granularity. 2️⃣ **Control Over Context**: By using FIXED, INCLUDE, or EXCLUDE expressions, you can control which dimensions affect your calculation, giving you more precise insights. 3️⃣ **Efficient Data Prep**: Instead of multiple data sources or complex joins, LOD expressions often let you get the results you need with less prep work. 💬 Curious to hear from other Tableau users—what’s your favorite use case for LOD expressions? Or, if you haven’t tried them yet, drop a comment with any questions. Let’s exchange tips and make our Tableau skills even stronger! #Tableau #TableauDesktop #DataVisualization #LODs #BusinessIntelligence #SeniorBIDeveloper #DataTips

𝗡𝗼 𝗗𝗔𝗫 𝗡𝗲𝗲𝗱𝗲𝗱: 𝗘𝘅𝗽𝗹𝗼𝗿𝗲 𝗧𝗮𝗯𝗹𝗲𝗮𝘂’𝘀 𝗖𝗮𝗹𝗰𝘂𝗹𝗮𝘁𝗲𝗱 𝗙𝗶𝗲𝗹𝗱𝘀 𝗮𝗻𝗱 𝗩𝗶𝘀𝘂𝗮𝗹𝗶𝘇𝗮𝘁𝗶𝗼𝗻 𝗧𝗼𝗼𝗹𝘀 🚀 Day 7 of My Tableau Journey In my last post, we discussed Joins and Calculated Fields in Tableau. Today, let’s explore the basic parts of Tableau’s interface: Worksheets, Dashboards, and Stories. We’ll also cover important elements like Rows, Columns, Marks, Filters, and Pages all necessary for building great visualizations. In Power BI, DAX Measures are essential, but there’s no DAX in Tableau. 😄 Instead, Tableau uses Calculated Fields to create new data or perform calculations based on existing data, similar to Calculated Columns in Power BI. A special feature of Tableau’s Calculated Fields is LOD (Level of Detail) Expressions, which let you do calculations at different levels of detail than what’s shown in your chart. While they’re not exactly like DAX Measures, LOD Expressions help control how detailed your data is within Tableau. Check out the PDF below for a detailed explanation. ↓️ Stay tuned for more insights, and thanks for following along on this journey! Follow Sourav for more content like this! 🌟 #Data #DataAnalytics #Tableau #CareerGrowth #TableauTips

🔎 With the help of some others, I may have finally cracked the algorithm for where and how Tableau stores worksheet cards on a dashboard.   🙏 First, thanks to Sam Batchelor for the baseline trashcan approach which got me well on my way.   🔬 So, this is a multi-staged algorithm, based on externally observable behaviors.   ✔️ Tableau adds cards (filters, legends) associated with a sheet when you drag it onto the dashboard. I used Tableau for years before I realized this. If you hide all cards before you drag, you can then place the cards manually via the dropdown menu on the frame of each worksheet.   But… *where* does tableau place them (or any automatically placed cards when they are left open in the sheet before dragging)?   ✔️ Tableau will use the front-most, *empty* layered container if no other container houses *cards*. Do not label this container with a textbox that says, "Trash" or some other title. It will then *not* receive the cards. ✔️ Otherwise, if another container already has cards, Tableau will place new cards in the front-most container that has at least 1 card. ✔️ It doesn’t matter if the container is on- or off-dashboard; Tableau will add to it. Off-dashboard helps for new dashboards because… ✔️If there are no containers matching the above criteria, Tableau will create a Tiled container and put your cards in it; this container will be placed in the back-most layer and will end up completely hidden if you follow the common approach of starting your dashboard with a baseline vertical container that encompasses its entire size.   I hope that helps!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

💡Tableau tip: Did you know that in Tableau, you can utilize any chart as a powerful filter for other visuals? This simple yet incredibly effective feature allows to do deep-dives easily and get a better understanding of the variations in trends and drivers for the same.📊 For example, one could select a particular region on a map chart and a view of ordered city-wise sales for that region is available immediately in an adjoining bar chart. Such cross-filtering behavior is not ON by default in Tableau (although it is default ON in power BI and Looker Studio). But turning it ON is simple. Simply select the chart that should be used as a filter and enable "use as filter" option. Are you aware of any other cool features in Tableau that enhance data analysis? Share in the comments below, and let's learn from each other! For more such informational items related to data analytics, follow me on LinkedIn Harish Mahale #tableautips #tableau #tableaucharts #tableaucrossfiltering #dataanalytics #topnanalytics

https://lnkd.in/gfeFFjvc Complete Tableau SOP Guide Now Available! 🌟 I'm excited to share that I’ve created a comprehensive Standard Operating Procedure (SOP) for Tableau! This guide covers everything you need to get started with Tableau and dive deep into data visualization. Whether you're a beginner or looking to refine your skills, this SOP includes detailed explanations on: Data Connections and Preparations Calculations and Formulas Building Dashboards and Reports Advanced Visualizations Publishing and Sharing Insights 👉 Check out the post here https://lnkd.in/gfeFFjvc This SOP is designed to be a complete resource for anyone interested in mastering Tableau. If you find it helpful, feel free to save or share it with others who may benefit. #Tableau #DataVisualization #SOP #DataAnalytics #BusinessIntelligence --- This message highlights the contents and purpose of your SOP, encourages engagement, and uses relevant hashtags. Feel free to adjust it as you like!

🤔 Do you keep notes about your dashboards…   😲 in your dashboards?   📝 You can include an entire dashboard of text for development notes and hide them off-screen with a show/hide button that does not display on Tableau Server.   To get that button to set outside the defined borders of the dashboard, either go to the Layout tab and set its X value to some value greater than the width. Alternatively, you can drag the right border beyond the edge and then drag the left border.   Previously, I had been doing the well-known hack of putting a text box out there, but if your dashboard is fairly wide, that leaves very little room for text. I finally figured, "Why not use a button and take up the whole space?!"   🔎 Check the image or download the version from Tableau Public to see some ideas of what kind of content to include.   Some people like to put worksheet-level notes in the often-unused Captions text fields.   🚧 One drawback to that is that if your users download to .pdf or .pptx, there is no way to turn off the display of those Captions. Go ahead and try it on Tableau Public on my Viz. Choose the "Selected Sheets" option and pick the first one.   Anyhow, I just thought of this button approach, so I need to put it into practice!   🏗→🧠 Build to Learn!   💭🚶♀️🚶♂️ Follow for more.   #tableau #data #analytics #VizoftheRay

"🔍 A Comparative Look at Tableau & Power BI! Order of Filters 📊 In Tableau, it's common to utilize the order of operations. How does Power BI mirror this fundamental concept? 🎨 A visual breakdown showcasing the similarities and differences between the order of filters in Tableau and Power BI! 💡 Whether you're transitioning from one tool to another or simply looking to expand your data visualization knowledge, this comparison will serve as a valuable resource. 🚀 More content available in my Power BI vs. Tableau free Comparison Store here ☝https://lnkd.in/gSXxFdmZ 📊Interactive Comparison using Tableau (extended form of the below image) https://lnkd.in/grxMSq6X 💥My Tableau Channel    ► https://lnkd.in/gpakmErB 💥My Power BI Channel    ► https://lnkd.in/dKyDhFy7 💪 #DataVisualization #Tableau #PowerBI #Analytics #DataScience #DataViz

TABLEAU TIP #6 – GET THE ORIGINAL DATA FILE FROM A TABLEAU .TWBX FILE Let’s say someone sent you a Tableau .twbx file, and you want to get the original data file from it. To do this, you first need to unpack the file. Check out my latest blog post to see how to do this. Let's build a community of Tableau enthusiasts together. If you have a Tableau tip or trick that has helped you, I would love to hear about it. Your contribution could be featured in a future blog post, with full credit to you. https://wp.me/p34UfX-4N9 #Key2Market #Tableau #Datafam #TableauTipsandTricks #DataVizBlog #Unpackage

🎉 Tableau : Simplifying the Reset Filters Button! 🎉 While exploring Tableau today, I found an effortless and effective way to create a reset filters button. I just had to share this with the community! Here’s a quick rundown of how I did it: Creating Random Worksheets: I quickly put together a few worksheets to demonstrate the reset filter button. They may not be perfect, but they served their purpose! Building the Dashboard: I added the worksheets to a dashboard and enabled all the filters by showing them on the dashboard. The Magic of Extensions: Here’s where it gets interesting! From the dashboard objects, I selected the “Extensions” and searched for the “Filter Bookmarks” extension. This powerful feature allowed me to create the reset filter functionality in the easiest and most straightforward way. ✨ Watch my quick demo video where I practically implemented the reset filter button. It’s simple yet super effective! #Tableau #PowerBI #DataAnalyst #DataScience #Businessdeveloper #bi #businessanalyst #dilytics #follow #connections #linkedin #followers #slash #Tableau #DataAnalytics #ProblemSolving #CommunityEngagement #like

🔍 Transforming Data into Insights with SQL & Power BI/Tableau 📊 I recently came across an interesting analogy: A cracked wall representing raw data in SQL. Alone, it's scattered and complex, much like data waiting to be organized. But when we place the right frame – whether it's Power BI or Tableau – it transforms into a meaningful picture of data analysis. 🎯 Both Power BI and Tableau offer powerful features: 📊 Interactive visualizations for real-time insights ⏳ Time-saving automation for reporting and dashboard updates 📈 Data integration from multiple sources to create a holistic view 🚀 Actionable insights to fuel better decision-making and business strategy These tools turn raw data into strategic powerhouses, driving success in today’s data-driven world! 💡 #DataAnalysis #PowerBI #Tableau #SQL #BusinessIntelligence #DataVisualization #Analytics #DecisionMaking