Tableau Centralised Row Level Security

Поділитися
Вставка
  • Опубліковано 6 вер 2024
  • How to implement tableau row level security using Virtual connections.
    --------------------------------------------
    📚 Recommended Books
    --------------------------------------------
    📚 DATA VISUALISATION & STORYTELLING
    Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw
    Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na
    The Big Book of Dashboards amzn.to/3q4i3eG
    Data Visualization: A Practical Introduction amzn.to/44KYrel
    Storytelling with Data : Lets Practice amzn.to/44O7WcL
    Tableau Desktop Specialist Certification: amzn.to/44Ocy2P
    Tableau Desktop Certified Associate: amzn.to/3Kk2YfV
    📚 SQL
    SQL for Data Analytics: amzn.to/3rROkGj
    SQL 3 books in 1 : amzn.to/3KklUuY
    Learning SQL: Generate, Manipulate and Retrieve Data : amzn.to/3Kn34mN
    SQL Quick Start Guide: amzn.to/3KInOpx
    📚 DATA ENGINEERING
    Data Engineering with Python : amzn.to/3YelH1Y
    Data Engineering with AWS: amzn.to/3YgXoAL
    Fundamentals of Data Engineering: amzn.to/3OAUVxy
    Software Architecture: amzn.to/3KmNffX
    System Design Interview: amzn.to/3Yhfy5q
    Ace Data Science Interview: amzn.to/3rOxcBl
    System Design Interview: amzn.to/3OAw8d7
    Designing Machine Learning Systems: amzn.to/3YbGxiB
    📚 SOFTWARE ENGINEERING
    Clean Code amzn.to/47aBnr4
    Clean Architecture amzn.to/3OA8VaP
    The Programmatic Programmer: amzn.to/4793k2C
    -----------------------------------------
    👇 CHECK THIS OUT! 👇
    -----------------------------------------
    🏪 AMAZON STOREFRONT
    www.amazon.com...
    All my recommendations for books, gadgets and gear are also available at my
    Amazon storefront. Check it out!
    👕 LIKE THE "DATA RELATED GIFTS" WITH CREATIVE, FUNNY & HUMOROUS QUOTES FOR ANYONE WHO LIKE TO LAUGH ?
    You can purchase one here: www.datavizcan...
    --------------------------------------------------------------------------------
    😍 📧 REACH OUT TO ME ON SOCIAL MEDIA 😍
    --------------------------------------------------------------------------------
    Instagram: / datavizcanvas
    Twitter: / datavizcanvas
    Facebook www.facebook.c...
    Linkedin: / gurpreetsingh515
    Tableau public public.tableau...
    Website : www.datavizcan...
    -------------------
    GEAR I USE
    -------------------
    📷 Video
    Canon EOS RP amzn.to/3QkOpfU
    Canon RF 35mm amzn.to/3rNIh5E
    Canon RF 14-35mm amzn.to/44JQw0Y
    🎙️ Audio
    Rode NT-USB Versatile Studio amzn.to/3DCbxyY
    Rode PSA1 Professional Studio Arm amzn.to/3ObseWN
    ⏱ TIMESTAMPS
    ‼️ DISCLAIMERS
    Links included in this description may be affiliate links. When you buy a product or service with these links, I may receive a small commission. However, there is no additional cost to you :) I genuinely appreciate you supporting my channel so I can continue to provide you with awesome content for free!
    Thanks for being a part of this channel and all your support! 💪 🙏

КОМЕНТАРІ • 2

  • @chandanasrinivas5772
    @chandanasrinivas5772 15 днів тому

    Hi Gurpreet, thanks for sharing this. It was really helpful.
    I have a follow up question: Let' say I have a
    1. Actual sales data (how much sales did a seller achieve)
    2. Sales Target data (how much sales was the seller targeting to achieve)
    3. Seller attributes (seller name, region etc.).
    With these data sets I need to combine seller name, seller target sales and seller actual sales and ensure that seller can only see their own data. How can I do achieve this tableau virtual connection on Tableau Server Version: 2024.2.0?
    I'm basically trying to understand how can I join two tables (Actual sales data, Sales Target data) and apply rls (using Seller attributes data) simultaneously.
    Thanks again!

    • @DataVizCanvas
      @DataVizCanvas  13 днів тому

      Thats a great question. Once you have applied row level security on the primary fact table and then join it with secondary table, it will only retrieve related rows from secondary table.
      Example: Table one is sales with row level security applied on Region (Central)
      Table two is returned orders and is joined with Table one on Order ID field..
      Once the join is created in the workbook then it will only show all the sales made in Central region and corresponding returned items.
      Hope that helps..
      Please feel free to reach out if you need more info.