Revolutionising Netsuite Business Intelligence
Enhancing business intelligence from with Netsuite reporting, through a scalable data warehouse and Power BI
REVOLUTION BEAUTY
Improving Data Infrastructure with a data warehouse
Revolution Beauty is a leading cosmetics company that partnered with Select Distinct for data analytics consulting for beauty, addressing complex challenges with its data infrastructure and NetSuite reporting.
The NetSuite SaaS platform directly served the core of the business reporting; however, as a result, it was clunky and slow to update. Specialist skills were needed to service the reporting requirements.
Quite simply, Revolution Beauty had outgrown this approach. The existing data structures did not provide the flexibility needed to drive the business forward. The company was looking for a more targeted approach to gain insights and make data-driven decisions.
Revolution Beauty hired Select Distinct to build out their data warehouse solution.
Data Health Check and Discovery Phase
To start the project, Select Distinct conducted a Management Information Health check.
The existing infrastructure used data from the Oracle NetSuite ERP system, with reports distributed through ad-hoc analysis, often in Microsoft Excel. These were often built with Report builder through saved searches,
The health check reviewed the processes and technology involved, and provided recommendations and a roadmap for moving forward.
The main recommendation of the road map was to build a data warehouse. The data warehouse would hold internal and external data. Users could securely distribute reports and visualizations built from the data to key users.
During the discovery phase, Select Distinct worked with Revolution Beauty to identify the initial key subject areas. And defined the short and long-term requirements.
The team also made decisions regarding the infrastructure. We recommended that the client continue using the Microsoft stack. And host the data warehouse on an Azure SQL Server instance, with visualizations in Power BI.
One of the primary reasons for this choice of platform was the familiarity of the Microsoft environment for the existing team. And some prior knowledge and skills that would add more value
Solution Overview
Data Warehouse and ETL Processes
The main data sources for the data warehouse included internal NetSuite ERP data and external Point of Sale data.
Select Distinct developed ETL processes to extract and regularly update the data. This included writing scripts to clean and transform the data and designing an efficient data loading process.
We optimized the structure of the data in the warehouse to meet the business’s reporting and analytical requirements.
Visualizations in Power BI
A dashboard was built in Power BI for each subject area to meet the business stakeholders’ requirements.
The dashboards allowed users to quickly gain insights and take action. With self service data analysis options for the more capable users
The visualizations were published and automatically refreshed included allowing for analysis.
Further Optimization of the ETL Process
To further optimize the ETL process and improve the performance of the data warehouse.
Select Distinct moved away from replicating the NetSuite saved searches. And moved towards replicating the key back-end tables in the system.
This change eliminated the constraint of NetSuite running the queries and led to improved performance. It also allowed Select Distinct to design the ideal structures and indexes to support the key areas.
Conclusion
This case study demonstrates how Select Distinct helped Revolution Beauty.
They improved Revolution beauty’s data infrastructure and Netsuite Reporting. This was undertaken by building a data warehouse, and visualizations in Power BI.
The data health check and discovery phase provided a roadmap for moving forward. And the data warehouse and ETL processes ensured that the data was organized and regularly updated.
All to meet the business’s reporting and analytical requirements.
The visualizations in Power BI allowed users to quickly gain insights and take action. And the optimization of the ETL process improved the performance of the data warehouse. And at the same time reduced workloads on the transactional systems
Client Feedback
Paul Reed – Director of Enterprise Architecture
REVOLUTION BEAUTY
“Having up to date, readily available data that we can explore in Power BI has enabled us to see and react to business performance much more readily. The flexibility afforded by the data warehouse means that
reporting workload can shift from our ERP system to the right tool for the job”
If you would like to talk to us about how we can help you improve your business intelligence solutions then you can book a FREE introductory call below. No obligation, and we just might give you enough food for thought to help you
Revolutionising NetSuite reporting is just one part of what we do. Discover more of Our Work of industry case studies to see how we help firms optimise their data infrastructure.
Read the full story: Explore our detailed case study on Revolutionising Business Intelligence for a Global Beauty Leader
Frequently Asked Questions
How do you ensure BI tools are adopted by the wider team?
A tool is only effective if it is used. Our "Software Second" philosophy ensures we build dashboards that speak the language of your specific business. By focusing on the problems your team needs to solve daily, we create intuitive BI solutions that provide immediate value, leading to much higher internal adoption rates.
Why should we choose a consultancy over an in-house BI build?
In-house teams are often stretched thin by day-to-day maintenance. We bring an external, senior-level perspective and a proven framework for transformation. We don't just "plug in" software; we overhaul your data infrastructure to ensure it is scalable, secure, and aligned with your long-term commercial goals.
How do you handle sensitive commercial and financial data?
Data security is our priority. We work within your existing secure infrastructure (such as Power BI or NetSuite environments) to ensure that sensitive financial and operational data is handled with strict access controls. Our goal is to make data accessible to the right people at the right time, without compromising security.
What are the common indicators that a business needs to revolutionise its BI?
If your senior management team is spending hours manually reconciling reports from different departments, or if you are consistently looking at data that is already several days old, your BI infrastructure needs an overhaul. We help you move from being "data-heavy" but "insight-poor" to having real-time, trustworthy information at your fingertips.
How do you integrate legacy systems like NetSuite into a modern BI environment?
Many firms struggle with extracting the full value from their ERP data. We specialize in building robust data pipelines from systems like NetSuite into agile BI tools (such as Power BI). This allows us to combine your historical financial data with live operational feeds, providing a complete, "revolutionised" view of your business performance.