skip to main content
Power BI
    • What is Power BI
    • Why Power BI
    • Customer stories
    • Data visuals
    • Security
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile
    • Power BI Embedded
    • Power BI Report Server
  • Pricing
    • Azure + Power BI
    • Microsoft 365 + Power BI
    • Dynamics 365 + Power BI
      • Energy
      • Healthcare
      • Manufacturing
      • Media
      • Retail
    • For analysts
    • For IT
      • Overview
      • Embedded analytics
      • Power BI visuals
      • Automation
      • Documentation
      • Community
    • Partners Overview
    • Solutions Partners
    • BI Specialized Partners
    • Power BI CSOs
    • Fabric Partner Community
    • Training
    • Getting started
      • Overview
      • Self-guided learning
      • Webinars
      • Documentation
      • Roadmap
      • Overview
      • Issues
      • Give feedback
    • Blog
    • Business intelligence topics
    • Overview
    • Forums
    • Galleries
    • Submit ideas
    • Events
    • User groups
    • Community blog
    • Register
    • ·
    • Sign in
    • ·
    • Help
    Go To
    • Power BI forums
    • Updates
    • News & Announcements
    • Get Help with Power BI
    • Desktop
    • Service
    • Report Server
    • Power Query
    • Mobile Apps
    • Developer
    • DAX Commands and Tips
    • Custom Visuals Development Discussion
    • Health and Life Sciences
    • Power BI Spanish forums
    • Translated Spanish Desktop
    • Power Platform Integration - Better Together!
    • Power Platform Integrations
    • Power Platform and Dynamics 365 Integrations
    • Training and Consulting
    • Instructor Led Training
    • Galleries
    • Community Connections & How-To Videos
    • COVID-19 Data Stories Gallery
    • Themes Gallery
    • Data Stories Gallery
    • R Script Showcase
    • Webinars and Video Gallery
    • Quick Measures Gallery
    • 2021 MSBizAppsSummit Gallery
    • 2020 MSBizAppsSummit Gallery
    • 2019 MSBizAppsSummit Gallery
    • Events
    • Ideas
    • Custom Visuals Ideas
    • Issues
    • Issues
    • Events
    • Upcoming Events
    • Community Engagement
    • T-Shirt Design Challenge 2023
    • Community Blog
    • Power BI Community Blog
    • Custom Visuals Community Blog
    • Community Support
    • Community Accounts & Registration
    • Using the Community
    • Community Feedback
    cancel
    Turn on suggestions
    Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
    Showing results for 
    Search instead for 
    Did you mean: 

    Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

    • Power BI forums
    • Galleries
    • Data Stories Gallery
    • Re: The analysis of data on chocolate bars

    Re: The analysis of data on chocolate bars

    02-12-2023 10:23 AM

    Super User technolog
    Super User
    615 Views
    LinkedIn LinkedIn Facebook Facebook Twitter Twitter
    technolog
    Super User technolog
    Super User
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    The analysis of data on chocolate bars

    ‎06-27-2022 07:34 AM

    You are given 5 screens on the questions of cocoa beans in chocolate bars, and you can answer the questions: which cocoa beans are used in chocolate, which is the most popular variety of cocoa beans in the world, which countries are the origin of cocoa beans, what percentage of cocoa content in chocolate bars.

    2022-06-27_17-32-50.png

    2022-06-27_17-32-33.png

    2022-06-27_17-32-17.png

    2022-06-27_17-31-50.png

    2022-06-27_17-31-30.png

         

    This dashboard is based on real data and made as part of the curriculum.

    Made by a student at St. Petersburg State Technological University, Faculty of Economics and Management, direction "Business Informatics" Alexander Yolohov.

    During the analysis, we came to different results on the design:

    1. Chocolate is created from cocoa beans, which is its main component. Consider seven varieties of cocoa beans
    2. The largest cocoa bean plantations are in South America and Africa. But different varieties grow in different regions. Consider a different variety of beans in different countries.
    3. Information on the percentage of cocoa beans in bars is also provided.
    4. Rating of chocolate bars depending on different varieties of cocoa beans.

    During the study, the following conclusions were made:

    The most popular variety of cocoa beans, which was found in 46.6 percent of chocolate bars, is: Trinitario

    Most cocoa beans of the same variety come from a particular country.

    It is quite rare to observe a situation in which the same variety is produced by many different countries and supplied in the same volume.

    On average, each bar from our study contained 72% cocoa beans.

    Curiously, the Criollo (Ocumare) variety not only brought victory to its bar in the taste rating, but also its content in chocolate is a record 80%.

    eyJrIjoiY2YwMGMyYWQtMDM3Yi00OGI4LWJlMTEtMThiM2FjNzI4N2Y3IiwidCI6IjZiZTgxZjIwLWFlY2MtNGQyZC1hMTM0LWJmZWJlOTAxODE4NCIsImMiOjl9



    ____________
    Please join the Power BI UX/UI User Group if you need help with dashboard design and usability

    Join to Data Governance User Group

    Join to DENEB and Power BI Enthusiasts User Group

    Join to Data Fabric Best Practices User Group

    Subscribe to my medium blog
    Chocolate bars.pbix
    Labels:
    • Labels:
    • Lifestyle
    • Other
    Message 1 of 18
    1,858 Views
    17
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    AJAgyeman
    AJAgyeman
    Regular Visitor
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-10-2023 04:21 PM

    Hello there Alex, great job with your visuals and storytelling. I have learned a lot from your project.

    You however mixed up some of the information from the data. The country column you used for the "countries of origin of cocoa beans" is rather the list of countries who use the beans to make chocolate bars i.e. countries in chocolate bar production. The correct country column (i.e. predominantly South American and African Countries who produce the beans) is supposed to have countries like Venezuela, Ghana, Peru, Ecuador, Togo, etc which you named "The country of origin of the bean" in your table.

    Kudos to you!

    Message 17 of 18
    649 Views
    0
    Reply
    technolog
    Super User technolog
    Super User
    In response to AJAgyeman
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎02-12-2023 10:23 AM

    @AJAgyeman Thanks for the comments! I think it will be possible to make changes in the next version for this dashboard.



    ____________
    Please join the Power BI UX/UI User Group if you need help with dashboard design and usability

    Join to Data Governance User Group

    Join to DENEB and Power BI Enthusiasts User Group

    Join to Data Fabric Best Practices User Group

    Subscribe to my medium blog
    Message 18 of 18
    615 Views
    0
    Reply
    Lyubov6932
    Lyubov6932 Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-09-2022 12:49 AM

    The page backgrounds and colors are great and look very appetizing.

    Message 16 of 18
    1,501 Views
    0
    Reply
    Kluev
    Kluev Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-08-2022 10:17 AM

    Perfectly matched background for each picture! In addition, the colors of the graphs that match the background are well chosen

    Message 15 of 18
    1,518 Views
    0
    Reply
    bochkovass
    bochkovass Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-08-2022 06:47 AM

    I learned a little more about my favorite chocolate, very interesting information and beautiful design. Alexander, you have a talent

    Message 14 of 18
    1,528 Views
    0
    Reply
    Snezhana1903200
    Snezhana1903200 Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-05-2022 11:22 AM

    The information was well presented and the color scheme is well chosen

    Message 13 of 18
    1,625 Views
    0
    Reply
    lara_prokhorova
    lara_prokhorova Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-05-2022 09:42 AM

    A very interesting dashboard, not to mention the fact that I love chocolate

    Message 12 of 18
    1,628 Views
    0
    Reply
    collipium
    collipium Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-05-2022 07:04 AM

    Interesting choice of theme! but sometimes the data is difficult to read because of the dark colors

    Message 11 of 18
    1,643 Views
    0
    Reply
    Roman_Mikhailov
    Roman_Mikhailov Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-05-2022 06:32 AM

    A very appetizing dashboard.

    Message 10 of 18
    1,646 Views
    0
    Reply
    thebestcassie
    thebestcassie Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-05-2022 02:58 AM

    Great job, but in some places the information is hard to see due to the dark colors of the dashboard.

    Message 9 of 18
    1,660 Views
    0
    Reply
    LidiaNechaeva26
    LidiaNechaeva26 Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 03:22 PM

    I really liked the design, a lot of informative information

    Message 8 of 18
    1,677 Views
    0
    Reply
    Darya_M
    Darya_M Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 01:45 PM

    A good choice of chart types. Great design!

    Message 7 of 18
    1,698 Views
    0
    Reply
    aanikeychik
    aanikeychik Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 10:11 AM

    Love the variety of pictures on the background!

    Message 6 of 18
    1,704 Views
    0
    Reply
    Marina_K
    Marina_K Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 08:32 AM

    Beautiful color palette!

    Message 5 of 18
    1,708 Views
    0
    Reply
    thebestcassie
    thebestcassie Advocate II
    Advocate II
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 07:49 AM

    Why didn't you use a tree matrix when visualizing countries?

    Message 3 of 18
    1,712 Views
    0
    Reply
    technolog
    Super User technolog
    Super User
    In response to thebestcassie
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-09-2022 05:48 AM

    Will think about it😉



    ____________
    Please join the Power BI UX/UI User Group if you need help with dashboard design and usability

    Join to Data Governance User Group

    Join to DENEB and Power BI Enthusiasts User Group

    Join to Data Fabric Best Practices User Group

    Subscribe to my medium blog
    Message 4 of 18
    1,494 Views
    0
    Reply
    Bulko_Artem
    Bulko_Artem Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-04-2022 05:37 AM

    Good design!

    Message 2 of 18
    1,721 Views
    0
    Reply

    Power Platform

    • Overview
    • Power BI
    • Power Apps
    • Power Pages
    • Power Automate
    • Power Virtual Agents

    • Sign in
    • Sign up

    Browse

    • Solutions
    • Partners
    • Consulting Services

    Downloads

    • Power BI Desktop
    • Power BI Mobile
    • Power BI Report Server
    • See all downloads

    Learn

    • Guided learning
    • Documentation
    • Support
    • Community
    • Give feedback
    • Webinars
    • Developers
    • Blog
    • Newsletter

    © 2023 Microsoft

    Follow Power BI

    • Privacy & cookies
    • Manage cookies
    • Terms of use
    • Trademarks
    Consumer Privacy Act (CCPA) Opt-Out Icon Your Privacy Choices