Title
Grupo Casas Bahia democratizes data at scale with Databricks
Grupo Casas Bahia democratizes data at scale with Databricks | Databricks Skip to main content Login Why Databricks Discover For App Develop…
Each colour maps a published value to the exact source passage used to support it. Only bounded excerpts are public; administrators can inspect the complete captured source.
Title
Grupo Casas Bahia democratizes data at scale with Databricks
Grupo Casas Bahia democratizes data at scale with Databricks | Databricks Skip to main content Login Why Databricks Discover For App Develop…
Description
Brazilian retailer Grupo Casas Bahia migrated from a legacy SAS warehouse to Databricks, using Databricks Assistant to automate 80-90% of ETL script conversion, AI/BI Genie for nontechnical data access, and Unity Catalog for governance, cutting costs 70% and upskilling 107 nonengineering employees to use SQL and Python.
…utomation allowed business users to adopt Python and SQL. According to Steinz, “Databricks Assistant automated 80–90% of ETL script conversion, enabling our team to upskill quickly. After the migration, we had 107 team members who didn’t previously know how to…
…nhanced data democratization and improved productivity across the organization. The migration itself resulted in a 70% cost reduction compared to the legacy SAS system, driven by Databricks lower operating costs and streamlined processes. “Databricks offers a cost that is five to six times lower than SAS, making it a…
…utomated 80–90% of ETL script conversion, enabling our team to upskill quickly. After the migration, we had 107 team members who didn’t previously know how to code, now actively working with SQL and Python.” Empowering nontechnical users to engage with data independently has removed bo…
Company
Grupo Casas Bahia
…nd 800+ physical stores. Legacy SAS infrastructure impeded data democratization Grupo Casas Bahia, one of Brazil’s leading retail and e-commerce brands, has long relied on data to drive their operations and customer engagement. Over time, however, reliance on a legacy SAS warehouse began to hinder their ab…
Country
Brazil
…nd 800+ physical stores. Legacy SAS infrastructure impeded data democratization Grupo Casas Bahia, one of Brazil’s leading retail and e-commerce brands, has long relied on data to drive their operations and customer engagement. Over time, however, reliance on a legacy SAS warehouse began to hinder their ab…
Industry
Retail
…s been transformative, and we’re just getting started.” Share this post Details Industry : Retail and Consumer Goods Use Case : Data Warehousing , Data Engineering Cloud : Google Cloud Product : D…
Problem
Grupo Casas Bahia's legacy SAS environment disconnected data analysts from the data lake, forcing manual data movement, and over a decade of undocumented scripts — many written by staff no longer at the company — made the system costly to maintain and hard to scale for new use cases like product categorization and fraud detection.
…opment,” shared Cezar Steinz, Data and AI Senior Manager at Grupo Casas Bahia. “With SAS, our data analysts were disconnected from our data lake, forcing us to move information manually — a time-consuming and inefficient process.” Additionally, the system lacked scalability and required costly, complex reeng…
…accumulated scripts, many without proper documentation, compounded the issue. “The people who originally built these scripts are no longer at the company, and without documentation, understanding or modifying the code became a major roadblock,” Steinz noted. In parallel with addressing these operational challenges, Grupo…
Solution
Grupo Casas Bahia migrated from SAS to the Databricks Data + AI Platform, using Databricks Assistant (a GenAI tool) to convert SAS scripts into Python and SQL, identify and fix bugs, and generate documentation; AI/BI Genie to let nontechnical users query the data lake conversationally; and Unity Catalog as a governance layer to manage access and track table usage.
…sion and helped us address challenges with outdated and undocumented SAS code.” Using Databricks Assistant to generate Python and SQL code, identify and resolve bugs, and even create documentation significantly reduced the complexity of the migration. “The Assistant didn’t just help with migration, it also disseminated knowledge,…
…ts,” Steinz added. Another cornerstone of Grupo Casas Bahia’s data evolution is AI/BI Genie, which bridges the gap for nontechnical users by allowing them to explore and interact with data more intuitively. By enabling users to query the data lake directly through conversational AI, Ge…
…e SAS environment,” said Steinz. To ensure secure and scalable data management, Grupo Casas Bahia adopted Unity Catalog as a governance layer. Unity Catalog provides comprehensive visibility into their data ecosystem, allo…
Business value
The migration delivered a 70% cost reduction compared to the legacy SAS system, with Databricks Assistant automating 80–90% of ETL script conversion and reducing migration documentation time from months to minutes in some cases. This enabled 107 nonengineering employees who didn't previously know how to code to actively work with SQL and Python, and over 200 users now access and analyze data directly through AI/BI Genie.
…nhanced data democratization and improved productivity across the organization. The migration itself resulted in a 70% cost reduction compared to the legacy SAS system, driven by Databricks lower operating costs and streamlined processes. “Databricks offers a cost that is five to six times lower than SAS, making it a…
…utomation allowed business users to adopt Python and SQL. According to Steinz, “Databricks Assistant automated 80–90% of ETL script conversion, enabling our team to upskill quickly. After the migration, we had 107 team members who didn’t previously know how to code, now actively working with SQL and Python.” Empowering nontechnical users to engage with data independently has removed bo…
…ith data independently has removed bottlenecks and accelerated decision-making. Thanks to AI/BI Genie, over 200 users now access and analyze data directly. “Genie has allowed users to move beyond simple queries and start building their…
AI capabilities
Generative AI, Code Generation, Intelligent Automation
…le to modernize their data infrastructure and simplify their migration process. Central to this effort was Databricks Assistant, an automated tool powered by GenAI that played a pivotal role in converting Grupo Casas Bahia SAS scripts into Databricks–compatible formats. “Databricks Assistant was the core data intelligence tool for our successful mi…
Technology
Databricks SQL, Unity Catalog, Databricks Assistant, AI/BI Genie
…sumer Goods Use Case : Data Warehousing , Data Engineering Cloud : Google Cloud Product : Databricks SQL , Unity Catalog Ready to get started? Try Databricks for free Learn more about our product Talk…
…le to modernize their data infrastructure and simplify their migration process. Central to this effort was Databricks Assistant, an automated tool powered by GenAI that played a pivotal role in converting Grupo Casas Bahia SAS scripts into Dat…
Deployment model
cloud
…stry : Retail and Consumer Goods Use Case : Data Warehousing , Data Engineering Cloud : Google Cloud Product : Databricks SQL , Unity Catalog Ready to get started? Try Databricks f…
Deployment options
cloud
…stry : Retail and Consumer Goods Use Case : Data Warehousing , Data Engineering Cloud : Google Cloud Product : Databricks SQL , Unity Catalog Ready to get started? Try Databricks f…
Headline outcome
…a CUSTOMER STORY Democratizing retail data to power better customer experiences 70% Cost reduction by migrating from SAS to Databricks 80–90% Automation of ETL scripts with Databricks Assistant 107 Nonengineering e…
Use case type
Workflow automation
…utomation allowed business users to adopt Python and SQL. According to Steinz, “Databricks Assistant automated 80–90% of ETL script conversion, enabling our team to upskill quickly. After the migration, we had 107 team members who didn’t previously know how to…