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: Sales figures – US MARKET

    Re: Sales figures – US MARKET

    07-09-2022 18:28 PM

    ChekanovVV6931
    Advocate I
    907 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

    Sales figures – US MARKET

    ‎07-01-2022 02:46 AM

    An analysis was made of car sales data in the United States of America. This dashboard is based on real data and made as part of the curriculum.

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

    During the analysis, we came to different results:

    1. In the tree diagram, we can see the best-selling car brand in the United States of America. The following brands fall into the top: Ford, Toyota, Nissan.
    2. By car brands, we compared sales from 2005 to 2022, also determined the maximum and minimum market shares, and derived market change indicators.
    3. Sales of Audi cars have been growing rapidly since 2005. By 2020, the decline begins. And in 2022, there is still not enough data, so many charts have minimum values. They also indicated the dynamics of market share and market changes.
    • Maximum value of market share: 1.32
    • Minimum market share value: 0.48
    •  Maximum market change value: 16.30
    • Minimum market change value: -3.80
    1. BMW car sales go up and down.
    • Maximum market share value: 2.25
    • Minimum market share value: 1.57
    • Maximum market change value: 15.29
    • Minimum market change value: -11.00
    1. According to the histogram of Ford sales, you can see a decrease by 2009 and an increase by 2015, by 2020 there is a decrease in sales to 1.9 million.
    • Maximum market share value: 16.00
    • Minimum Market Share: 12.07
    • Maximum market change value: 8.65
    • Minimum market change value: -12.90
    1. Sales of Huyndai cars are declining sharply in 2006 and there is an increase and since 2017 a slight decline.
    • Maximum value of market share: 5.81
    • Minimum Market Share: 2.71
    • Maximum market change value: 26.97
    • Minimum market change value: -13.61
    1. Sales of KIA gradually grew.
    • Maximum market share value: 5.32
    • Minimum market share value: 1.63
    • Maximum market change value: 28.11
    • Minimum market change value: -13.44
    1. Sales of Mazda cars are not stable, then there is a decline, then an increase. According to the histogram of the market change, we notice that from 2009 to 2019 there are negative indicators.
    • Maximum value of market share: 44.56
    • Minimum Market Share: 19.36
    • Maximum market change value: 13.83
    • Minimum market change value: -7.95
    1. Sales of Mitsubishi cars fell by 2009 and gradually grew until 2019.
    • Maximum value of market share: 0.81
    • Minimum market share value: 0.34
    • Maximum market change value: 22.27
    • Minimum market change value: -53.64
    1. Nissan cars fell in sales by 2009 and gradually increased in 2018, with a decline until 2020.
    • Maximum market share value: 8.37
    • Minimum market share value: 4.03
    • Maximum market change value: 7.82
    • Minimum market change value: -26.55
    1. Sales of Toyota by 2010 began to fall, then there is a gradual increase, by 2020 sales are falling again.
    • Maximum value of market share: 15.84
    • Minimum Market Share: 10.66
    • Maximum market change value: 14.41
    • Minimum market change value: -17.77

    Based on the statistics obtained, the following conclusions can be drawn:

    Most car sales fell by 2009 and by 2020. In the United States of America, residents opt for Ford cars.

    eyJrIjoiZDcxNTI2ZDEtYjIyOS00YTNjLThhODQtMDY0NDBkMTFmZWYyIiwidCI6IjZiZTgxZjIwLWFlY2MtNGQyZC1hMTM0LWJmZWJlOTAxODE4NCIsImMiOjl9



    ____________
    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
    SALES FIGURES – US MARKET.pbix
    Labels:
    • Labels:
    • Business
    Message 1 of 10
    1,132 Views
    11
    Reply
    • All forum topics
    • Previous Topic
    • Next Topic
    ChekanovVV6931
    ChekanovVV6931 Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-09-2022 06:28 PM

    I think the aim to get the users complete information achieved with excellence!

    Message 10 of 10
    907 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-07-2022 12:51 PM

    I'm not a fan of using basic colors on the second page, but the report is good and easy to watch, thank you!

    Message 9 of 10
    939 Views
    0
    Reply
    KulAn
    KulAn Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-06-2022 05:20 PM
    A very beautiful dashboard!Everything is very detailed

     

    Message 8 of 10
    946 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:23 AM

    Good information on the automotive market

    Message 7 of 10
    992 Views
    0
    Reply
    Catherina_M
    Catherina_M Advocate I
    Advocate I
    • Mark as New
    • Bookmark
    • Subscribe
    • Mute
    • Subscribe to RSS Feed
    • Permalink
    • Print
    • Report Inappropriate Content

    ‎07-05-2022 08:15 AM

    A good dashboard, but the graph on slide 2 is hard to read because of the small scale. It would be more interesting if you used more colors in the detailed analysis

    Message 6 of 10
    1,001 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:01 AM

    An interesting and detailed dashboard. Good job

    Message 5 of 10
    1,006 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:44 AM

    Interesting block visualization. Laconic design.

    Message 4 of 10
    1,007 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-05-2022 04:50 AM

    Good detailed dashboard with beautiful design.

    Message 3 of 10
    1,034 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:38 AM

    Cool dashboard! but I'd like a bit brighter colors on sales chart for each brand of car (for example, like on the second slide) 😃

    Message 2 of 10
    1,041 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