Driving Insights: A Comprehensive Analysis of Vehicle Sales in USA

Note: This report is for demonstration/trial purposes only

Key findings:

  1. Average Vehicle Price: $13,700.00

  2. Total Revenue: 7,510,000,000

  3. Number of cars sold in USA: 548,520

Please interact with the visuals to uncover deeper insights, compare metrics, and tailor the data to your unique needs.

Top 4 Selling States

Schema Details

Snowflake Model | Power BI

  • Brand

    Country of Origin

    Founded

    Founder(s)

    Notable Models (split)

    Selling Points (split)

  • Area

    body

    body (groups)

    body (groups) 2

    color

    condition

    Country

    interior

    make

    Make (NEW)

    mmr

    model

    odometer

    odometer (bins)

    Region

    saledate.1

    seller

    sellingprice

    state

    StateName

    transmission

    trim

    vin

    year

    SelectedBrand

    SelectedImageURL

    StateName

    Hierarchy

    StateName

    Country Area

  • Country

    Flag Image URL

  • brandName

    brandSlug

    image.localOptimized

    image.localOriginal

    image.localThumb

    image.optimized

    image.original

    image.source

    image.thumb

  • Country

    Hex Color Code

If you have feedback, questions, or want to connect, please reach out, and I’ll respond as soon as I can!

  • “There were 5 exabytes of information created between the dawn of civilization through 2003, but that much information is now created every two days.”

    Eric Schmidt, Executive Chairman at Google

  • “Without data, you’re just another person with an opinion.”

    W. Edwards Deming

  • "Data is a precious thing and will last longer than the systems themselves."

    Tim Berners-Lee, Inventor of the World Wide Web

  • “The world’s most valuable resource is no longer oil, but data.”

    The Economist

  • “Data will talk to you if you’re willing to listen.”

    Jim Bergeson

  • “With data collection, ‘the sooner, the better’ is always the best answer.”

    Marissa Mayer

Check my work

Next

EPL Insights - 18/19