Consider following schema for the database. Use report builder please

 

Use the sample database and Run all the 3 files on SQL Server in the following sequence.

1. Drop all objects
2. Create objects
3. Load data

Q3. Generate following reports for the same dataset.

1. Plot a chart of products available for different categories.
2. Plot a chart of products available for different brands.
3. Create a tabular report depicting details of employees working for different managers.
4. Display number of orders in each week/ month/quarter/year.
5. Plot sale data for different categories over time.

this is the link for dataset sample

BikeStores Sample Database - create objects.sql

BikeStores Sample Database - drop all objects.sql

BikeStores Sample Database - load data.sql

Transcribed Image Text:

Sales customers * customer_id first_name last_name phone email street city state zip_code orders * order_id customer_id order_status order_date required_date shipped_date store_id staff_id + staffs staff_id first_name last_name email phone active store_id manager_id phone email street stores store_id store_name city state zip_code order_items order_id *item_id product_id quantity list_price discount to ++ Production et categories *category_id category_name products *product_id product_name brand_id category_id model_year list_price stocks store_id *product_id quantity brands * brand_id brand_name ++ Sales customers * customer_id first_name last_name phone email street city state zip_code orders * order_id customer_id order_status order_date required_date shipped_date store_id staff_id + staffs staff_id first_name last_name email phone active store_id manager_id phone email street stores store_id store_name city state zip_code order_items order_id *item_id product_id quantity list_price discount to ++ Production et categories *category_id category_name products *product_id product_name brand_id category_id model_year list_price stocks store_id *product_id quantity brands * brand_id brand_name ++