Car rental company uses Bi tools to design data warehouse
Location: USA
Industry: Automobile
Problems
The company wanted to improve the speed and quality of decision making and for that, it planned to organize and make sense of the relevant information it already collected from business units and trading partners.
Solutions
Allied consultants convened a project group, including people from IT, Finance, and Planning management. The team had to deal with data quality and to identify a Business Intelligence system (BI) for the company.
The software was installed quickly, and included database elements and a data warehouse building tool (specific to the Fox Rent a Car’s preferred database). The initial deployment of the BI system depended heavily on the spread of skills and interests in the company’s project team.
Solutions
Allied consultants helped the company design data warehouse which included:
- Loading data from different databases
- Created SSRS reports / Dashboards for different departments (sales, operations, Finance)
- Plan resources for upcoming years
- Helped design Forecast reports
Our dashboards also provide operational staff with real-time information. Allied Consultants covered the following areas:
- Contract
- Payment
- Reservation
- Fleet management
Tech Stack
- SSAS (SQL Analysis services) – For cubes
- SSRS –(SQL reporting services) – For reporting
- SSIS – (SQL server integration services) – For ETL
- SharePoint -- For the end user, we have published reports on SharePoint
Get In Touch With Us
we believe in cutting edge solutions and are committed to your success