I imported the two Olist Kaggle datasets into an SQLite database. I modified the original table names to make them shorter and easier to understand. Here's the Entity-Relationship Diagram of the resulting SQLite database:

https://www.googleapis.com/download/storage/v1/b/kaggle-user-content/o/inbox%2F2473556%2F23a7d4d8cd99e36e32e57303eb804fff%2Fdb-schema.png?generation=1714391550829633&alt=media" alt="Database Schema">

Data sources:

https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce

https://www.kaggle.com/datasets/olistbr/marketing-funnel-olist

I used this database as a data source for my notebook:

SQL Challenge: E-commerce data analysis

This statistic presents a ranking of the most popular online stores in Germany in the electronics and media segment in 2021, sorted by annual net e-commerce sales. For more information please visit ecommerceDB.com.In 2021, market leader amazon.de generated 10.1 billion U.S. dollars via the sale of physical goods in the category electronics and media in Germany. The online store mediamarkt.de was ranked second with a revenue of 1.4 billion U.S. dollars.

This statistic presents a ranking of the most popular online stores in the United Kingdom in the food and personal care segment in 2021, sorted by annual net e-commerce sales. For more information please visit ecommerceDB.com.In 2021, market leader tesco.com generated 6.1 billion U.S. dollars via the sale of products from the foor and personal care segment in the United Kingdom. The online store sainsbury.co.uk was ranked second with a revenue of 4 billion U.S. dollars.

The eCommerce market in Greater China is predicted to reach US$2,131,037.2m revenue by 2025. The top online retailers in the market are jd.com, suning.com and vip.com.

Amazon.co.uk is leading the Toys & Baby e-commerce market in the UK, with e-commerce net sales of US$854 million in 2021 generated in the UK, followed by argos.co.uk with US$779 million. Third place is taken by sainsburys.co.uk with a revenue of US$529 million. Very.co.uk is the fourth biggest Toys & Baby online store in the UK with net sales of US$302 million in 2021. For an extended ranking, please visit ecommerceDB.com.

The eCommerce market in Japan is predicted to reach US$115,683m revenue by 2025. The top online retailers in the market are amazon.co.jp, apple.com and shein.com.

• 3M+ Contact Profiles • 5M+ Worldwide eCommerce Brands • Direct Contact Info for Decision Makers • Contact Direct Email and Mobile Number • 15+ eCommerce Platforms • 20+ Data Points • Lifetime Support Until You 100% Satisfied

Buy eCommerce leads from our eCommerce leads database today. Reach out to eCommerce companies to expand your business. Now is the time to buy eCommerce leads and start running a campaign to attract new customers. We provide current and accurate information that will assist you in achieving your goals.

Our database is made up of highly valuable and interested leads who are ready to make online purchases. You can always filter our data and choose the database that best meets your needs if you need eCommerce leads based on industry.

We have millions of eCommerce data ready to go no matter where you are. We’ve acquired hundreds of clients from all over the world over the years and delivered data that they’re happy with.

We were able to do so by obtaining data from various locations around the world. As a result, our database is widely accessible, and anyone can use it from any location on the planet. Please contact us if you want the best eCommerce leads .

We sell eCommerce leads that can be filtered by industry. We know what you’re going through and what you’ll need for your next project. As a result, we’ve compiled a list of eCommerce leads that are exactly what you require. With the most potential data we provide, you can grow your business and achieve your business goals. All of our eCommerce leads are generated professionally, with real people – not bots – entering data.

We’re a leading brand in the industry because we source data from the most well-known platforms, ensuring that the information you receive from us is accurate and reliable. That’s especially true because we verify each and every piece of information in order to provide you with yet another benefit in your life.

The majority of our customers have had success with the information we’ve provided. That is why they keep contacting us for our services. You can count on our business-to-business eCommerce sales leads. Contact us to work with one of the most effective lead generation companies in the industry, which has already helped thousands of potential members achieve success.

Every month, we update our eCommerce store sales leads in order to provide our clients with the most accurate data possible. We have a team of professionals who strive for excellence when it comes to gathering the right leads to ensure you get the number of sales you need. Our experts also double-check that all of the sales data we receive is genuine and accurate.

The accuracy of our eCommerce database is why the majority of our clients choose us. Furthermore, we offer round-the-clock support to provide on-demand solutions. We take care of everything so you can spend less time evaluating our product database and more time becoming one of them.

The eCommerce market in Ireland is predicted to reach US$5,733m revenue by 2023. The top online retailers in the market are amazon.co.uk, tesco.ie and apple.com.

Success.ai’s Ecommerce Merchant Data and B2B Contact Data for Global E-commerce Professionals provides a comprehensive and highly accurate database from over 170 million verified profiles. Specifically tailored for the e-commerce sector, this dataset features work emails, direct phone numbers, and enriched professional profiles to connect businesses with the leaders and decision-makers shaping the global e-commerce landscape. Continuously updated with advanced AI validation, this resource is ideal for enhancing marketing campaigns, sales initiatives, recruitment efforts, and market research.

Key Features of Success.ai's Global E-commerce Professional Contact Data

1. Global Data Coverage Gain access to an extensive database spanning key e-commerce markets worldwide. With verified profiles from 170M+ professionals, Success.ai ensures you can connect with global influencers, decision-makers, and strategists across diverse regions and industries.

2. AI-Driven Accuracy Harness the power of AI validation for 99% accuracy rates across emails and phone numbers. Our continuously updated dataset ensures that you reach the right professionals with reliable and actionable contact data.

3. Tailored for E-commerce Professionals Our data includes profiles of experts in online retail, supply chain logistics, payment systems, digital marketing, and e-commerce technology, making it a perfect fit for targeting niche segments within the e-commerce industry.

4. Customizable Data Delivery Choose from API integrations, custom flat files, or direct database access to seamlessly integrate this dataset into your existing systems, empowering your team with flexibility and efficiency.

5. Compliance-Ready Data Success.ai ensures all data is collected and processed in alignment with GDPR, CCPA, and other international compliance standards, so you can leverage this resource with confidence and ethical assurance.

Why Choose Success.ai for Global E-commerce Contact Data?

• Best Price Guarantee We offer a highly competitive pricing model that ensures the best value for high-quality, actionable data.

• Strategic Applications Success.ai’s B2B Contact Data supports a variety of business functions:

E-commerce Marketing Campaigns: Use verified contact information to launch targeted campaigns that reach decision-makers in the e-commerce sector. Sales and Outreach: Enhance your sales strategy with direct access to key players in global e-commerce. Talent Acquisition: Identify and engage with e-commerce professionals for roles in marketing, logistics, technology, and operations. Market Insights: Leverage enriched demographic and firmographic data to conduct in-depth market research and refine your strategies. Business Networking: Build connections with professionals and companies driving innovation in the global e-commerce ecosystem.

• Technology-Enhanced Solutions Our data delivery is optimized for seamless integration into your systems, including:

Enrichment API: Real-time updates to maintain the accuracy and relevance of your contact database. Lead Generation API: Maximize outreach efforts with access to key contact information, enabling up to 860,000 API calls per day.

• Data Highlights 170M+ Verified Global Profiles 50M Direct Phone Numbers 700M Total Professional Profiles Worldwide 70M Verified Company Profiles

• Use Cases

1. Enhanced Marketing: Empower your e-commerce marketing strategies with precise email and phone contact details.
2. Sales Growth: Equip your sales team to connect with top-level executives and decision-makers.
3. Recruitment Excellence: Source global e-commerce talent efficiently with verified professional profiles.
4. Customer Understanding: Deepen insights into customer demographics for improved personalization.
5. Partnership Building: Identify potential collaborators and strengthen relationships with influential industry players.

Success.ai is the ultimate choice for global e-commerce data solutions, delivering unmatched volume, accuracy, and flexibility:

• AI-Validated Data: Ensures a 99% accuracy rate to drive success in your campaigns. Extensive Reach: Access professionals and companies across key regions in the e-commerce sector.
• Seamless Integration: Choose the data delivery method that works best for your business needs.
• Compliance Assurance: Leverage ethically sourced data in adherence to global privacy regulations.

Transform your e-commerce strategies today with Success.ai. Gain access to reliable, verified contact data for global e-commerce professionals and unlock unparalleled opportunities for growth and innovation.

No one beats us on price. Period.

The eCommerce market in Finland is predicted to reach US$7,092.5m revenue by 2025. The top online retailers in the market are gigantti.fi, verkkokauppa.com and k-ruoka.fi.

amazon.com is one of the largest e-commerce retailers by online revenue in the world. In 2023, the marketplace' net revenue reached nearly ******* million U.S. dollars. The revenue on ecommerceDB does not include income from subscription services and provisions for third party sales and fulfillment.

Amazon.com was the leading online store in the U.S. e-commerce market, with e-commerce net sales of *** billion U.S. dollars in 2024, followed by walmart.com with ** billion U.S. dollars. Ranking third was shein.com with sales reaching over ** billion U.S. dollars. Target.com is the fourth-biggest online store in the U.S. with net sales of **** billion U.S. dollars in 2024.For an extended ranking as well as rankings in specific product categories, please visit ecommerceDB.com.The eCommerceDB provides detailed information for over ****** online stores in more than ** countries, including detailed revenue analytics, competitor analysis, market development, marketing budget, and interesting KPIs, such as traffic, shipping providers, payment options, social media activity and many more.

E-Commerce Transactions: AOV: Business & Consumer Services: Business Services data was reported at 185.809 USD in 18 Nov 2023. This records a decrease from the previous number of 243.765 USD for 16 Nov 2023. E-Commerce Transactions: AOV: Business & Consumer Services: Business Services data is updated daily, averaging 215.000 USD from Jan 2019 (Median) to 18 Nov 2023, with 193 observations. The data reached an all-time high of 4,283.050 USD in 30 Dec 2019 and a record low of 7.660 USD in 03 May 2023. E-Commerce Transactions: AOV: Business & Consumer Services: Business Services data remains active status in CEIC and is reported by Grips Intelligence Inc.. The data is categorized under Global Database’s Singapore – Table SG.GI.EC: E-Commerce Transactions: by Category.

E-Commerce Transactions: AOV: Computers Electronics & Technology: Telecommunications data was reported at 49.226 USD in 09 Mar 2025. This records a decrease from the previous number of 54.883 USD for 06 Mar 2025. E-Commerce Transactions: AOV: Computers Electronics & Technology: Telecommunications data is updated daily, averaging 48.442 USD from Jan 2019 (Median) to 09 Mar 2025, with 326 observations. The data reached an all-time high of 509.711 USD in 31 Oct 2022 and a record low of 5.813 USD in 24 Nov 2022. E-Commerce Transactions: AOV: Computers Electronics & Technology: Telecommunications data remains active status in CEIC and is reported by Grips Intelligence Inc.. The data is categorized under Global Database’s Singapore – Table SG.GI.EC: E-Commerce Transactions: by Category.

E-Commerce Transactions: AOV: Business & Consumer Services data was reported at 577.635 USD in 03 May 2025. This records an increase from the previous number of 553.767 USD for 02 May 2025. E-Commerce Transactions: AOV: Business & Consumer Services data is updated daily, averaging 214.625 USD from Jan 2019 (Median) to 03 May 2025, with 1693 observations. The data reached an all-time high of 3,425.756 USD in 23 Jun 2021 and a record low of 0.224 USD in 02 Jul 2023. E-Commerce Transactions: AOV: Business & Consumer Services data remains active status in CEIC and is reported by Grips Intelligence Inc.. The data is categorized under Global Database’s Singapore – Table SG.GI.EC: E-Commerce Transactions: by Category.

E-Commerce Transactions: AOV: Heavy Industry & Engineering: Heavy Industry & Engineering data was reported at 28.023 USD in 30 Mar 2025. This records an increase from the previous number of 2.633 USD for 23 Mar 2025. E-Commerce Transactions: AOV: Heavy Industry & Engineering: Heavy Industry & Engineering data is updated daily, averaging 136.247 USD from Sep 2019 (Median) to 30 Mar 2025, with 283 observations. The data reached an all-time high of 14,209.838 USD in 19 Oct 2023 and a record low of 2.633 USD in 23 Mar 2025. E-Commerce Transactions: AOV: Heavy Industry & Engineering: Heavy Industry & Engineering data remains active status in CEIC and is reported by Grips Intelligence Inc.. The data is categorized under Global Database’s Singapore – Table SG.GI.EC: E-Commerce Transactions: by Category.

The eCommerce market in Chile is predicted to reach US$10,503.5m revenue by 2025. The top online retailers in the market are falabella.com, paris.cl and lider.cl.

Unlock the door to business expansion by investing in our real-time eCommerce leads list. Gain direct access to store owners and make informed decisions with data fields including Store Name, Website, Contact First Name, Contact Last Name, Email Address, Physical Address, City, State, Country, Zip Code, Phone Number, Revenue Size, Employee Size, and more on demand.

Ensure a lifetime of access for continuous growth and tailor your campaigns with accurate and reliable information, initiating targeted efforts that align with your marketing goals. Whether you're targeting specific industries or global locations, our database provides up-to-date and valuable insights to support your business journey.

• 4M+ eCommerce Companies • 40M+ Worldwide eCommerce Leads • Direct Contact Info for Shop Owners • 47+ eCommerce Platforms • 40+ Data Points • Lifetime Access • 10+ Data Segmentations • Sample Data

target.com, operated by Target Corporation, is an online store with nationally-focused sales. Its eCommerce net sales are generated almost entirely in the United States. With regards to the product range, target.com is an all-round online store, with products on offer that cover different categories, such as “Toys, Hobby & DIY”, “Electronics & Media” as well as “Furniture & Appliances”. The online store was launched in 1999. *Forecast

E-Commerce Transactions: AOV: Pets & Animals: Pet Food & Supplies data was reported at 53.667 USD in 28 Feb 2024. This records an increase from the previous number of 52.546 USD for 25 Feb 2024. E-Commerce Transactions: AOV: Pets & Animals: Pet Food & Supplies data is updated daily, averaging 66.003 USD from Jan 2019 (Median) to 28 Feb 2024, with 359 observations. The data reached an all-time high of 731.430 USD in 10 Dec 2019 and a record low of 1.397 USD in 18 Dec 2021. E-Commerce Transactions: AOV: Pets & Animals: Pet Food & Supplies data remains active status in CEIC and is reported by Grips Intelligence Inc.. The data is categorized under Global Database’s Singapore – Table SG.GI.EC: E-Commerce Transactions: by Category.