الحلقه الثالثه من سلسله ما تستخدمش الاكسل في عمل الداشبورد

الحلقه ال 3 AI visuals Power BI Excel AI visuals Power BI Excel Build visuals with your data Select or drag fields from the Data pane onto the report canvas. Filters Build Suggestions Decomposition tree Key influencers Data Search Assortments Geo In_stock Average Inventory Fiscal Year In-Stock % Item Number Sales ($) Week ID Items Category ID Color Function Filters on this visual Add data fields here Filters on this page Add data fields here Filters on all pages Add data fields here Analyze Sum of Sales ($) Explain by Assortment Desc Color Function +Add data Tooltips +Add data Visual Properties Size and style Analysis Tree Bars Category labels Values Headers Conditional formatting Format Filters Build Suggestions Data Search Assortments Geo In_stock Average Inventory Fiscal Year In-Stock % Item Number Sales ($) Week ID Items Category ID Color Function Analyze Sum of Sales ($) Explain by Assortment Desc Color Function +Add data Tooltips +Add data Key Influences Top segments What influences Sales ($) to increase? When: Function is 0 Assortment Desc is Televisions Color is Blue Function is A Sum of Sales ($) 40,214,744.75 40,214,744.75 10.74K Segment 1 Average of Sales ($) 10.74K Repurchases count 375 Assortment Desc is not Electronics Color is Blue Function is A Overall 4.83K Segment 1 contains 375 data points (10.0% of the data). In other 90.0% Function Assortment Desc Color Function Sales ($) is more likely to increase when Assortment Class in Televisions then otherwise (on average) 100K Average of Sales ($) Hardware Assortment Desc Cell Phones Electronics Only show values that are influencers Key Influences Top segments What influences Sales ($) to increase? When: Function is 0 Assortment Desc is Televisions Color is Black Function is A Average of Sales ($) Increase Decrease Running analysis Sales ($) is more likely to increase when Assortment Class in Televisions then otherwise (on average) 100K Average of Sales ($) Hardware Assortment Desc Cell Phones Electronics Only show values that are influencers Key Influences Top segments What influences Sales ($) to increase? When: Function is 0 Assortment Desc is Televisions Color is Black Function is A Average of Sales ($) Increase Decrease Running analysis Sales ($) is more likely to increase when Assortment Class in Televisions then otherwise (on average) 100K Average of Sales ($) Hardware Assortment Desc Cell Phones Electronics Only show values that are influencers Page 1 Page 1 Page 2 Page 1 Page 2 Page 1 Page 2