In the Sales, Profit Margin tie, line with the subtitle, notice that the data was Refreshed: NOW.
Notice also that there's now a for 2020 Jun. If you don't see the June 2020 data, you might need to press.
In the Sales, Profit Margin tie, line with the subtitle, notice that the data was Refreshed: NOW.
Notice also that there's now a for 2020 Jun. If you don't see the June 2020 data, you might need to press.
Pin to dashboard
Open My Workspace and open the Sales Monitoring dashboard.
Notice that the dashboard has a single tile
The DimSales Territory table contains one row. In the Queries pane, select the FactResellerSales query.
FactResellerSales table contains one row per sales order line a saies order contains one or more line items.
17. Review the column quality for the TotalProductCost column, and notice that 8% the rows are empty.
7. Repeat the steps to create a query based on the
• ColorFormats CSV file contains one row per product colar. Each row records the HEX codes to format background and font colors.
You should now have two new queries, ResellerSalesTargets and ColorFormats.