Search this site
Embedded Files
Adam Bouzgan
  • Home
  • Reflection
  • SQL
  • Python
  • PowerBI
  • Tableau
  • Excel
  • Contact Page
Adam Bouzgan
  • 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.


Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse