Master your data operation skills every day

Check out how the BigQuery Datetime and Timestamp functions work for multiple use cases such as extract date, convert date values, etc.

Read about how you can switch from Etsy to Shopify and what pitfalls, as well as advantages, are expected from this migration.

Find out how to use the Excel SUMIF function with text criteria. This tutorial covers various formulas, from basic to advanced examples.

A step-by-step tutorial on how to connect Power BI to BigQuery for loading data using the native connector or an ODBC driver.

Master the BigQUery Regexp functions to easily: extract, validate, split, and otherwise manipulate your data.

Learn how the combination of Excel VLOOKUP & SUM functions can be useful to sum values across multiple columns.

It’s easy to move data from Shopify to Google Data Studio. Learn how to do it and gain insights into building your first Data Studio dashboard.

You can export data from QuickBooks manually or do it automatically with dedicated tools. We discuss available options and answer common questions.

Integrating BigQuery and Data Studio is very simple and will help you build rich dashboards for your business. Learn how to set them up from our guide.

There’s plenty of Shopify reports available right in your dashboard. We discuss each report in detail and share plenty of practical tips.