Using visual studio SSAS and SQL server. Using SQL code You are responsible for designing a cube that will help provide information to help the company streamline its operations and develop strategies to help improve its many KPIs. Among other things, the company is seeking information on the following:

- Total number of trips made and total charge for these trips. One of the KPI is Average Charge per Trip. - Number of trips and associate charge by year, by month, and by date. - Number of trips and associated charge by Drivers full name. - Number of Trips and associated charge by street by city. The managers may need to query this information for a particular city and for a particular street within that city. - In addition, the company will request development of several KPIs as well as reports at a later stage.

For this assignment , please develop an SSAS project named TaxiServiceBISolution. You will design all dimensions that are required to help explain trip mileage and trip charge based on questions posed above. For each dimension, you will need to determine:

a.The dimensions name, b.List of dimension attributes that should be included in the dimension, c. Determine user hierarchies that may need to be defined to help answer some of the questions posed above. d. For each dimension attribute, you will need determine the four major properties we discussed in class. These are Key Column, Name Column, Name, and visibility of Attribute Hierarchy.

DimCity DimLocation Citykey ? Locationkey CityKey Street CityID CityName State FactTrips TripNumber ?DimDriver ? DateKey DriverKey DriverID DriverName Locationkey TripChange ?DimDates ? DateKey DateName MonthName YearName DimCity DimLocation Citykey ? Locationkey CityKey Street CityID CityName State FactTrips TripNumber ?DimDriver ? DateKey DriverKey DriverID DriverName Locationkey TripChange ?DimDates ? DateKey DateName MonthName YearName