https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2619436#M7679 <P>A little dull palette of colors, but fits the theme. Interesting choice of visualization of the second slide</P> Tue, 05 Jul 2022 09:41:12 GMT thebestcassie 2022-07-05T09:41:12Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2617427#M7570 <P><SPAN>A dataset was chosen as a case study for this work, which includes information about the sales of KEE'S CHOCOLATES. The final work includes two dashboards: a sales report in the company, which is needed to visualize the main indicators of this process, and a "What if?" model, which is necessary in order to track the impact of various dynamics on the main indicators.</SPAN></P> <P><SPAN>A thematic data set was found and processed. After connecting it to power bi, two dashboards were built.</SPAN></P> <P><SPAN>The first dashboard is a simple collection of graphs forming a sales report for 2020. The composition of the screen includes:</SPAN></P> <UL> <LI style="font-weight: 400;" aria-level="1"><SPAN>Pie chart with the distribution of profits by country</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>4 Cards showing profit, costs, revenue and number of customers</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>A graph showing the dynamics of revenue by category</SPAN></LI> </UL> <P><SPAN>The second dashboard was created using the "What if?" function and it consists of:</SPAN></P> <UL> <LI style="font-weight: 400;" aria-level="1"><SPAN>Actual cost, revenue and profit cards</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>Cards of projected costs, revenue and profit</SPAN></LI> <LI style="font-weight: 400;" aria-level="1"><SPAN>Cost, revenue and profit cross-sections that reflect the planned change in indicators as a percentage</SPAN></LI> </UL> <P><SPAN>The created dashboard is designed for financial forecasting. It is able to help in building a plan, assessing the profitability of changes in indicators with an increase in cost prices.</SPAN></P> <P><img /></P> <P> </P> <P><img /></P> <P> </P> <P><SPAN class="reportid hidden">eyJrIjoiOWMxNzBkYzYtM2YyYS00YTJmLTlhYzAtYjJiOTJjY2I4MWY2IiwidCI6IjZiZTgxZjIwLWFlY2MtNGQyZC1hMTM0LWJmZWJlOTAxODE4NCIsImMiOjl9</SPAN></P> Mon, 04 Jul 2022 12:16:09 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2617427#M7570 technolog 2022-07-04T12:16:09Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2618267#M7641 <P>An excellent idea of sales modeling, as well as a well-chosen color palette!</P> Mon, 04 Jul 2022 21:15:13 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2618267#M7641 Darya_M 2022-07-04T21:15:13Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2619436#M7679 <P>A little dull palette of colors, but fits the theme. Interesting choice of visualization of the second slide</P> Tue, 05 Jul 2022 09:41:12 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2619436#M7679 thebestcassie 2022-07-05T09:41:12Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2626110#M7831 <P>The filters on the second page look interesting, good job!</P> Thu, 07 Jul 2022 19:36:40 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2626110#M7831 LidiaNechaeva26 2022-07-07T19:36:40Z https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2627828#M7846 <P>I love these color combinations, so this dashboard was very attractive. The filters are unusual and surprisingly comfortable. Thank you for your work</P> Fri, 08 Jul 2022 14:04:01 GMT https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/Sales-modelling/m-p/2627828#M7846 bochkovass 2022-07-08T14:04:01Z