The Information Lab
The Information Lab
  • 578
  • 3 002 340
How To Make Small Multiple Charts In Power BI (In Under 5 Minutes)
*Don't forget to click Subscribe if you want more weekly data-related updates!*
Need to Compare Complex Data Clearly? Or struggling to compare multiple datasets effectively? Small multiples charts, also knows as trellis or grid charts, offer a visually appealing solution!
This video, led by Holly Jones, walks you through creating small multiples charts in Power BI. Whether you're a data visualisation beginner or a seasoned expert, this tutorial will equip you with the skills to create impactful small multiple charts in Power BI.
*Note audio becomes faint after 02:41 minutes (so turn your volume up).
📌Timestamp
00:00 Intro
00:38 Build a clustered column chart
02:19 Change single clustered column chart into a small multiple
02:41 Format your small multiple chart
03:21 Customise colour based on values
🔗Links
- Prefer to read this as a blog? www.thedataschool.co.uk/holly-jones/creating-small-multiples-in-power-bi/
- Download a copy of the Tableau Superstore data: data.world/missdataviz/superstore-2021
- Connect with Holly on LinkedIn: www.linkedin.com/in/hollyjones87/
- Find out more about Holly on The Data School site: www.thedataschool.co.uk/blog/holly-jones/
🎧Want more 5 minute tutorials? Check out our other 'How to' in 5 minutes playlists
▶️How to in Power BI ua-cam.com/play/PL_t5OlLHbVGyRK9dKLKxJ_Kqhk5-LRSBp.html
▶️How to Add Formatting in Tableau ua-cam.com/play/PL_t5OlLHbVGzU5eEQcLT-TTcsXdT4i5f7.html
▶️How to with Calculations in Tableau ua-cam.com/play/PL_t5OlLHbVGwALU9783GhnvW2DwJYCwSx.html
▶️How to Build Chart Types in Tableau ua-cam.com/play/PL_t5OlLHbVGxFSiWXUsEQrDPvFd1Nhxiu.html
▶️How to Data Questions in Tableau ua-cam.com/play/PL_t5OlLHbVGwhMGvehkV7EvFV1bvQPAXQ.html
▶️How to Join and Manipulate Data in Tableau ua-cam.com/play/PL_t5OlLHbVGxsVCKWA3Jf9WG-us5qlm5z.html
▶️How to in Tableau Prep ua-cam.com/play/PL_t5OlLHbVGzjl3ygGsOnXbr9sxPOrogY.html
▶️How to in Alteryx ua-cam.com/play/PL_t5OlLHbVGy5cEs8HSp7UvBS7fWS_u_Z.html
Переглядів: 255

Відео

4 Essential Ways To Visualise Time In Power BI
Переглядів 159Місяць тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* As analysts we always need to visualise time series data (think sales trends, website traffic, stock prices) - but that doesn't mean that there's only one way to do it. In this video Hewan Zewdu dives into 4 powerful ways to visualize changes over time in Power BI, perfect for both beginners and data whizzes. 📌Times...
How To Encourage More Women To Join Your Team And Start Their Careers In Data
Переглядів 45Місяць тому
Interested in a career in Data? Interested in a career in Data, but worried that you don't have the relevant experience? To celebrate International Women's Day join us for a special talk highlighting ways to encourage more women into careers in data. We are very proud to have expert recruiter Stephanie Hampel share how she has help develop the Information Lab's Data School application process t...
Date Tables 101 in Power BI
Переглядів 1002 місяці тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* New to Power BI and struggling with wrangling dates and time series analysis? There's a better way for accurate calculations! In This video Hewan Zewdu unlocks the power of date tables - your key to unlocking deeper data insights. She shows you how to build one in under 1 minute, and how to use it to build a line ch...
Switch Between Multiple Charts Using Buttons With Dynamic Zone Visibility
Переглядів 1,3 тис.4 місяці тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* If you have a lot of charts that you want to show on one dashboard , but don't want to make it feel crowded, then this video is for you. Follow along ass Data Schooler Liz shows you how to switch between multiple charts in your Tableau dashboard using buttons with Dynamic Zone Visibility. 📌Timestamp 00:00 Intro 00:3...
Make A Personalised Data-Themed Christmas Cards Generator
Переглядів 1734 місяці тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Will Sutton is behind on his Holiday tasks and needs to make some last-minute data-themed Christmas cards. He enlists his AI co-pilot build to help generate personalised Christmas cards for all his friends on his Xmas card list. Follow as Will uses ChatGPT and Dalle-3 to generate personalised cards. Also, don't forg...
How To Add Labels To The Top of Stacked Bar Charts
Переглядів 4914 місяці тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Make your stacked bar charts easier for users to understand by adding grand total labels on the top of your stacked bar charts. Follow Data Schooler Tyler Ha as he shows you how to to do this in Tableau. 📌Timestamp 00:00 Intro 00:40 Build a stacked bar chart 02:20 Create a dual axis chart 03:25 Format the charts 🔗Li...
Build A 3-Layer Map Drill-Down In Tableau
Переглядів 1 тис.5 місяців тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Add more layers of analysis to your map analysis with Dynamic Zone Visibility. In this overview tutorial Data Schooler Marc-Anthony T. shows you how to use Dynamic Zone Visibility to build a 3-level map drill-down so your users can seamlessly go from State to County to Zip Code. 📌Timestamp 00:00 Intro 00:26 Make a S...
Build Your Own Tableau Certified Analyst Exam GPT
Переглядів 4045 місяців тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Will Sutton and his AI co-pilot build a OpenAI custom GPT to can pass the Tableau Certified Tableau Analyst Exam. See how Will uses publicly available data to train a GPT and test it against GPT-4 and GPT-3.5 (free version). The outcome? It initially underperforms compared GPT-4. After some work Will was able to cus...
How To Dynamically Change the Colour of the Selected Line In Tableau
Переглядів 6755 місяців тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* This short tutorial is for you if you need to highlight trends, and help users engage with your line chart. Follow Data Schooler Randee Johnson as she shows you how to change the colour of the lines you want to focus on in a line chart with a click of your mouse. 📌Timestamp 00:00 Intro 00:27 Get the data 00:48 Open ...
How To Add Icon Indicators On Bar Charts
Переглядів 5225 місяців тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Follow Data Schooler Randee Johnson as she shows you how clean up government data in Tableau, and then inject some extra visual appeal into your progress bar charts with custom icons. 📌Timestamp 0:00 Intro 00:32 Get the data 01:00 Open the data in Tableau 01:19 Clean and filter the data in Tableau 02:57 Build the ba...
Use AI To Build Venn Diagrams For Tableau
Переглядів 8015 місяців тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Will Sutton wants his AI co-pilot to help him build a Venn Diagram in Tableau (hint: it's much more complicated than he originally thought it would be!). See how Will uses different AI tools to successfully build this non-native Tableau chart type. 📌Timestamp 00:00 Intro 00:40 Using perplexity 01:07 Using R Euler pa...
Wireframe Your Dashboard With Excalidraw
Переглядів 9865 місяців тому
*Don't forget to click Subscribe if you want more weekly data-related updates!* Save time creating a well organised dashboard by mapping out all the elements *before* your begin building in Tableau. Follow Data Schooler Leigh Davis as she shows you how to wireframe your dashboard in Excalidraw. 📌Timestamp 0:00 Intro 00:25 What is wireframing 00:42 Dashboard Containers for wireframing 01:11 Wire...
Using ChatGPT To Create Fake Datasets
Переглядів 1,5 тис.6 місяців тому
Using ChatGPT To Create Fake Datasets
Is ChatGPT Good At Data Prep?
Переглядів 3986 місяців тому
Is ChatGPT Good At Data Prep?
Top Tip: How To Maintain Table Calcs While Filtering
Переглядів 2446 місяців тому
Top Tip: How To Maintain Table Calcs While Filtering
Tableau Beginners | Understand Tableau's Data Model
Переглядів 1 тис.6 місяців тому
Tableau Beginners | Understand Tableau's Data Model
Tableau Beginners | Get To Grips With Calculations
Переглядів 1,2 тис.6 місяців тому
Tableau Beginners | Get To Grips With Calculations
Tableau Beginners | Dive Into Dashboards
Переглядів 7806 місяців тому
Tableau Beginners | Dive Into Dashboards
Tableau Beginners | Working With Publicly Available Data In Tableau
Переглядів 5586 місяців тому
Tableau Beginners | Working With Publicly Available Data In Tableau
Tableau Beginners | Start Here: From Zero To Dashboard
Переглядів 3 тис.6 місяців тому
Tableau Beginners | Start Here: From Zero To Dashboard
How To Make An Attention-Grabbing Viz Using Shapes
Переглядів 3976 місяців тому
How To Make An Attention-Grabbing Viz Using Shapes
How To Use AI To Help You Viz Something As Big As A Conference
Переглядів 3576 місяців тому
How To Use AI To Help You Viz Something As Big As A Conference
Marks Card Fundamentals: How to change colour, size and shape
Переглядів 2516 місяців тому
Marks Card Fundamentals: How to change colour, size and shape
Marks Card Fundamentals: How to use it with Bar Charts and Line Charts
Переглядів 2586 місяців тому
Marks Card Fundamentals: How to use it with Bar Charts and Line Charts
Can ChatGPT help you Build a Viz in Tableau? (Spoiler: it can!)
Переглядів 2,3 тис.7 місяців тому
Can ChatGPT help you Build a Viz in Tableau? (Spoiler: it can!)
How to disable Chart Highlighting (and create a Dummy Highlight) in Tableau | UX Tip
Переглядів 3967 місяців тому
How to disable Chart Highlighting (and create a Dummy Highlight) in Tableau | UX Tip
How to create a Drilldown Chart with Parameter Actions in Tableau in 5 Minutes
Переглядів 1,8 тис.7 місяців тому
How to create a Drilldown Chart with Parameter Actions in Tableau in 5 Minutes
Make a Hexbin Map in Tableau in 4 minutes
Переглядів 6187 місяців тому
Make a Hexbin Map in Tableau in 4 minutes
How to use Dynamic Zoning for Sheet Swapping in Tableau | 5 Minute Guide
Переглядів 6897 місяців тому
How to use Dynamic Zoning for Sheet Swapping in Tableau | 5 Minute Guide

КОМЕНТАРІ

  • @nashkmr
    @nashkmr 14 годин тому

    Thanks for the great video. My sort order changes after the Multi-Row Formula. Any idea why?

  • @vsagar4b38
    @vsagar4b38 День тому

    Thanks for the Video we need to split the actions to show in the Title

  • @nataliarobinson5671
    @nataliarobinson5671 4 дні тому

    Very well explained. Thank you!

  • @sulashidayat
    @sulashidayat 6 днів тому

    how to do it if we have two or more FACTs data. e.g. our big projects is fertilizer industry, we have 3 FACT data: import-export commodity trade, Fertilizer production each company in each country, crop yield of agriculture product in Indonesia. How to deal with that? e.g 2: we want to build complete executive dashboard, covering sales performance, HR dashboard, supply chain dashboard, and plant operation dashboard. all that dashboard require differents facts. how to do that

  • @madtoonimation6117
    @madtoonimation6117 11 днів тому

    Can we send a sheet as pdf to the mail? Can we send mail to multiple people at the same time? Please let me know.

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

    How would one write this same iterative macro to call down data from a live database in chunks to then run through your workflow and then write data in chunks? Is there a tutorial on that use case?

  • @neelufarbanu7139
    @neelufarbanu7139 23 дні тому

    Hi Jonathan , Thank you for this amazing video .. Just had a question how do i monitor backup since i am not able check the same in datadog

  • @HongFu-pw1qr
    @HongFu-pw1qr 23 дні тому

    good explanation Ali. You solved my issues with colour palette. thanks

  • @user-bd3pc2vk5p
    @user-bd3pc2vk5p 27 днів тому

    Please invest is some good mic first.

  • @maheshg82
    @maheshg82 29 днів тому

    Great presentation

  • @praveennamani2384
    @praveennamani2384 Місяць тому

    Hi, How can we resolve the Java Heap Space error in Tableau Prep?

  • @mikehawk5247
    @mikehawk5247 Місяць тому

    Very helpful!

  • @priyankadahiphale5231
    @priyankadahiphale5231 Місяць тому

    How to return single string value in calculated field using Tableau data from python and present it on new sheet of Tableau as Text value. For example, Data contains lists of cities and population of city. These are represented in graph in Tableau. We would like to find city having maximum population. Python code is written using max function. The python code is returning correct value to tableau, however there are multiple rows returned to tableau while I need only single value. Incase we are using label for returning maximum population in Tableau, it doesn’t return any value if we are not passing parameters in row and column field which are used in python code. Below python code is used to find maximum population in city: SCRIPT_STR(" city_list = _arg2 population_list = _arg1 highest_population = max(population_list) ind = population_list.index(highest_population) city_name = city_list [ind] output_str = ' '+str(city_name)+' with highest population: '+str(highest_population) return output_str ", ATTR([City]),SUM([Population]))

  • @raviranjansingh5527
    @raviranjansingh5527 Місяць тому

    thanks making good content

  • @tableaujedi
    @tableaujedi Місяць тому

    Great Video!

  • @mariiatverdokhlib2057
    @mariiatverdokhlib2057 Місяць тому

    Hi, I've found no option. Did they change the UI? I'm crazy about that, could you please give me a tip?

  • @PedroMendes-ed2dl
    @PedroMendes-ed2dl Місяць тому

    Thank you so much for the video! I was strugling! You saved my life :D

  • @xiearsene4507
    @xiearsene4507 Місяць тому

    Thank you. Are the number of rows and columns fixed for Small multiples? Or can it be dynamically controlled through parameters? 🤔

    • @theinformationlab
      @theinformationlab Місяць тому

      Hi - I asked Holly Jones about this and she said "as far as I'm aware they are fixed up to 6x6 layout. I don't think they can be changed by parameters." You can also find out more information on Microsoft's PowerBI help page learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples

  • @tee3553
    @tee3553 Місяць тому

    Thank you 😊

  • @domnitaflorea6707
    @domnitaflorea6707 Місяць тому

    Hi! I am having trouble opening the workbook on Tableau Public.

  • @trev1463
    @trev1463 Місяць тому

    Great video with clear instructions - thanks for making this Jana!

  • @Orholam5
    @Orholam5 Місяць тому

    one piece of advice, I would start with the WHY. show the final product and show why we are doing what we are doing first.

  • @mahendranmech9780
    @mahendranmech9780 Місяць тому

    It shows dotted line only when you hover over there in a particular place..how did you create this?

  • @saisantosh253
    @saisantosh253 Місяць тому

    Thank you :)

  • @sandarshm8288
    @sandarshm8288 Місяць тому

    I guess this chart is static or can we make the numbers dynamic based on other filters?? If so how?

  • @jilhamluthfi3398
    @jilhamluthfi3398 2 місяці тому

    Hi, I wonder if the username we input is the email address of our admin account or what?

  • @maryam4071
    @maryam4071 2 місяці тому

    hi, can u tell please if u login with root user or with iam user?

  • @wisdomwave9605
    @wisdomwave9605 2 місяці тому

    in this case, the point of the Dynamic rename is to identify automatically the columns that contain Zip as part of the name. It does not make sense to first select only the two columns manually, I believe in this case one should select all columns and use the formula writed to automatically identify 'zip' in their name

  • @GabrielPretorius-kn3lc
    @GabrielPretorius-kn3lc 2 місяці тому

    I just want to know. I tried the link, and it doesn't work. I was wondering if I could find this file somewhere?

  • @timdurgan
    @timdurgan 2 місяці тому

    So, if I had two tables with ID numbers as the joining column but every ID was consistent across both (e.g. marketing data and ad data, with 30 IDs each and all IDs are the same), it wouldn't matter which join I did, would it? As there are no IDs in the marketing data that don't also exist in the ad data). Is that correct?

  • @MrDarkplace22
    @MrDarkplace22 2 місяці тому

    thanks for the video, i really helped me understand how to work json and snowflake for work

  • @raviranjansingh5527
    @raviranjansingh5527 2 місяці тому

    GOOD INFO,PLEASE MAKE MORE VIEO

  • @danielq1985
    @danielq1985 2 місяці тому

    Brilliant. Thank you, sir!

  • @Seraphic75
    @Seraphic75 2 місяці тому

    Just what I needed. Clear and concise. Thank you :-)

  • @charlene6306
    @charlene6306 2 місяці тому

    Thank you for sharing, really helpful. Can i as, why Tableau and not Power BI

  • @instantkevlar4763
    @instantkevlar4763 2 місяці тому

    how would a published workflow be useful if your data sources are offline excel files? Is it still possible to make it work?

  • @ishikaJain987
    @ishikaJain987 2 місяці тому

    I think Mokkup is a better tool for wireframing dashboards. This tool is particularly dedicated to creating dashboard prototypes, allowing you to easily add different elements without worrying about adjusting them horizontally and vertically.

  • @stacia6678
    @stacia6678 3 місяці тому

    Could you not just copy-paste the table into Excel or Sheets?

  • @DataAnaylst
    @DataAnaylst 3 місяці тому

    Right to the point. Thank you kindly, sir. 👍

  • @GapingxDutch
    @GapingxDutch 3 місяці тому

    Thank you Jana! This video helped me out a lot!

  • @lmr8277
    @lmr8277 3 місяці тому

    Can this be done with a date instead of "Round"? Struggling to get this to work on a different dataset

  • @amity5020
    @amity5020 3 місяці тому

    can i use tab py connection as input dataset in flow?

  • @zonk9659
    @zonk9659 3 місяці тому

    Thanks for the video. Wondering if you have created, or can create, an XmR control chart (with the average line) and have the chart show new average and limit lines after recalculating them based on change signal in the data, while still showing the average and limits prior to the change signal?

  • @hcdatatranslator
    @hcdatatranslator 3 місяці тому

    This information is life changing for my career!

  • @user-ww8yx2ou1h
    @user-ww8yx2ou1h 3 місяці тому

    Thank you, very helpful !

  • @ecooled93
    @ecooled93 3 місяці тому

    Thanks for the video, but you didn't actually show how to create a KPI card. Thumbs down and will avoid your video as they don't contain what title promies.

  • @reubenovbiebo9866
    @reubenovbiebo9866 3 місяці тому

    Hi there, thank you for this video. Is there a way to drill back up. Also, how do you had filter or a parameter that helps user to go to a specific level

  • @SSi-nq3rt
    @SSi-nq3rt 4 місяці тому

    thank you very much. Finally somebody who explained how to pivot without any calculation on the field. You saved my day.

  • @user-bs8co5du9h
    @user-bs8co5du9h 4 місяці тому

    Dear theinformationlab, your video about making a resume with Tableau was very useful for me. Thanks Mahdi

  • @Inesamdamd
    @Inesamdamd 4 місяці тому

    great video, thank you !!