Vicky Ducasse

BI technologies provide historical, current, and predictive views of business operations created an interactive performance metrics dashboard that can be tailor-made to different industry Descriptive Information on what happen over time. e.g Sales performance over the year Diagnosis Analyse root causes for variation Prescriptive Predictive Planning/Forecast ing based on trend analysis Take actions to reduce variations based on analysis Sales dashboard model In the next page there is a sample of sales report from Power BI, where analytics was carried out for on a sample real estate company. The raw sales data for a financial year has been extracted and analyse as follows: Use interactive charts to measure performance : ➢ Dashboard on sales performance for the year Performance summary ➢ Sales measured against budget target of Mur 35M ➢ Sales by region , cluster and product line Trend analysis of sales level: Trend analysis ➢ Sales trend per month by service ➢ Average sales level by region ➢ Sales by business line per quarter Identification of root causes: Variance analysis ➢ Distribution of variance per quarter by main business line where in the sample is mainly attributed to business segment ➢ Variance analysis by quarter per business line ➢ Further drill down in variance analysis per quarter by product class