9.2 R is lazy and comes with guardrails.8.10 Disconnect from the database and stop Docker.8.9.4 Monthly Sales by Order Type with corrected dates – relative to a trend line.8.9.2 Define and store a PostgreSQL function to correct the date.8.9.1 Define a date correction function in R.8.9 Correcting the order date for Sales Reps.8.8 Detect and diagnose the day of the month problem.8.7.3 Compare monthly lagged data by Sales Channel.8.7.2 Monthly variation compared to a trend line.8.7.1 Retrieve monthly sales with the onlineorderflag.8.7 Impact of order type on monthly sales.8.6.4 Comparing average order size: Sales Reps to Online orders.8.6.1 Add onlineorderflag to our annual sales query.8.5.2 Comparing dollars and orders to a base year.8.4.1 Annual summary of sales, number of transactions and average sale.8.3 The overall AdventureWorks sales picture.8.1 Setup our standard working environment.8 Asking Business Questions From a Single Table.7.6 Disconnect from the database and stop Docker.7.5.5 The skim function in the skimr package.7.5.4 The glimpse function in the tibble package.7.5.2 Always look at your data with head, View, or kable.
7.3 Translating dplyr code to SQL queries.7.2.4 Retrieving random rows from the DBMS.7.2.3 Controlling the number of rows returned with collect().7.2.2 Create a pointer to a table that can be reused.7.2 Methods for downloading a single table.6.5 Disconnect from the database and stop Docker.6.4 Anatomy of a dplyr connection object.6.3 Set schema search path and list its contents.