|
Business Intelligence and Data Warehousing solution for a Real Estate leader in US.
The client is a large multi billion-dollar real estate marketing & advertising provider in the United States.
Challenge
The real estate services provider needed to better understand its marketplace and the behavior of its customers to
remain ahead of its competition.
Solution
- Initial analysis indicated that the large size data warehouse would be designed to gain insights into the company's
operational data, finances, and profits.
- iGlades designed a data warehousing solution based on decision support system - DSS technology, to deliver
unprecedented analytical power to managers over a web interface.
- iGlades succeeded in providing access to its branch and field personnel across the Business Market units
interactive, Web-based, historical views on data.
Benefits
- Data Access - Data Warehouse facilitated reporting at senior management levels on details of composite
financial information to better analyze company's contributions and profit margins.
- Information Analytics - Managers could access the system for reports on its customers, such as Top 100 gainers
or decliners by product or geography, divided by domestic vs. international mix.
- Anomalies - Managers can also track and analyze "gaps," which are period-to-period changes in operational
trends.
- Management Decisions -
"How has the total utilization or the total sales or mix of a business changed over this period of time?"
"Who are the customers who have the greatest gaps?
- Decisions Support Systems - By leveraging this DSS system, managers can detect subtle problems earlier, or
detect a material change in the behavior of a customer or an event in the marketplace. These abilities enabled the
company to make timely business decisions that have resulted in significant financial impact.
- Business Drivers - Analyzing the data revealed the actual drivers behind events and helped discover situations
that previously may have been overlooked, and acquiring a finer, more subtle understanding of customer utilization of
the company's products.
Technologies used:
- Data Warehouse - Google Cloud
- Data Integration (ETL): Talend 3.x
- Business Intelligence - Apache Spark 3.x, Hadoop 3.x
|
