Data-Literate - VideoAndMovie

Data literacy tips: Excel, SQL, BI and more.

Stop Static SQL! Pass cell values as SQL parameters!

15:33

Stop Static SQL! Pass cell values as SQL parameters!

Bitcoin Stocks

10:08

Bitcoin Stocks

Build out Excel Dashboard from Scratch!

11:59

Build out Excel Dashboard from Scratch!

Excel SUMIFS() Formula

5:45

Excel SUMIFS() Formula

Analyze Data in Excel #Dataliterate #excel

3:22

Analyze Data in Excel #Dataliterate #excel

Automate Business Tasks #dataliterate

2:30

Automate Business Tasks #dataliterate

Power Query / Remove Duplicates

3:58

Power Query / Remove Duplicates

SUMIFS vs COUNTIFS

1:45

SUMIFS vs COUNTIFS

Excel / Lock & Unlock Protect Cell's w VBA

2:22

Excel / Lock & Unlock Protect Cell's w VBA

Power BI - What if Parameter

2:39

Power BI - What if Parameter

SQL DATEDIFF( ) Function #dataliterate

3:09

SQL DATEDIFF( ) Function #dataliterate

PowerQuery - Merge Table's #dataliterate

3:46

PowerQuery - Merge Table's #dataliterate

Excel - VBA Refresh All

4:16

Excel - VBA Refresh All

Slicers for multiple tables

1:52

Slicers for multiple tables

Excel - Slicers and Timeline

1:49

Excel - Slicers and Timeline

SQL CTE Example

2:19

SQL CTE Example

Excel - Data Analysis Business Example

7:15

Excel - Data Analysis Business Example

Excel =INDEX( ) with Example

5:09

Excel =INDEX( ) with Example

SQL - Import Flat File

5:49

SQL - Import Flat File

SQL - Query Multiple Databases

3:16

SQL - Query Multiple Databases

SQL Case Statement

5:41

SQL Case Statement

SQL View

2:11

SQL View

SQL 6 Key Building Blocks

5:58

SQL 6 Key Building Blocks

PowerQuery Quick Tips

1:53

PowerQuery Quick Tips

Power Query Transform Data

4:19

Power Query Transform Data

SQL IIF Function

4:09

SQL IIF Function

Data Analysis Example

2:55

Data Analysis Example

Excel Fill Down Blank Cells #shorts

1:14

Excel Fill Down Blank Cells #shorts

Excel / Working w Effective Date Table

5:07

Excel / Working w Effective Date Table

What is BI? (Business Intelligence)

3:45

What is BI? (Business Intelligence)