Revenue by employee: Determine which employees bring the highest revenue to the store to evaluate their work performance by month/quarter/year
Strengths of each employee: Find out the types of customers suitable for each employee, from there you can assign or transfer the right type of customers according to their strengths
Strategic location: observe customer purchasing and spending trends in countries or regions, thereby devising expansion strategies or providing products suitable for each region
Golden hour: observe times that bring in high revenue or sell in large quantities, at those hours or times. From there, promotional campaigns or attractive incentives will be deployed at those time frames, helping to attract many customers
Favorite genres: Track which genre movies are still unrented by quarter and year Which genre movies have the most inventory by quarter and year. Which genre's movies are in stock at least quarterly and annually? We can adjust our marketing and advertising strategies to increase the rental opportunities for these movies
Cost of film rental: Track which genre movies are rented with the highest price by quarter and year. Which genre movies are rented with the lowest price by quarter and year. We can identify the value of each type of movie in total revenue and adjust our pricing or calling strategy accordingly
After build successfully a data warehouse, import data from it to hierarchal database by SSAS service. Then, load data to Power BI and Excel for analyzing
A Example Dashboard
