AI Engineering at Experian | Tableau Ambassador | Author & Creator of SQL Short Reads | Lecturer at the University of Texas at Dallas | YouTube @ChrisMPerry
Joined March 2019
- Tweets 2,560
- Following 302
- Followers 233
- Likes 5,192
435 Photos and videos
Pinned Tweet
20 Feb 2024
Over the past two years or so, I have been quietly working on sqlshortreads.com. I have finally published the blog and SQL learning portal this evening.
I look forward to further developing SQL Short Reads and hearing from its readers.
#SQL #SQLSHORTREADS
4
1,383
Inactive users are easy to overlook.
Python Tableau Server Client can turn cleanup into a repeatable workflow:
Identify inactive users
Export an audit file
Unlicense programmatically
Readable automation beats manual cleanup.
#tableau #python #automation
1
1
17
TSC and Tableau’s REST API, in general, are great for automating away hours of manual work and thousands of clicks. Check out the full script and 20 other scripts within my repo:
github.com/CodingOnWindowsOS…
13
Jun 14
Tableau schedules handle recurring refreshes.
But when refresh timing depends on a pipeline, event, or external process, Python TSC lets you trigger refreshes programmatically.
A simple pattern with a lot of flexibility.
#tableau #python #dataengineering
1
20
Jun 14
TSC and Tableau’s REST API, in general, are great for automating away hours of manual work and thousands of clicks. Check out the full script and 20 other scripts within my repo:
github.com/CodingOnWindowsOS…
17
Chris Perry retweeted
Jun 4
The future of analytics may not be better dashboards.
It may be conversations.
Anthropic automated ~95% of analytics questions by treating analytics as a knowledge problem, not a SQL problem.
#dataanalytics #genai #ai
1
1
44
Jun 2
The AI race isn’t about learning every tool.
It’s about learning the concepts that outlive them.
Tools change. Durable knowledge compounds.
#ai #machinelearning #careergrowth
20
May 31
Fortnite is perhaps the most enjoyable esport to watch when lans are like this one.
May 31
2nd fncs summit düsseldorf ($150,000)
Everyone from now on calls pollo the best player in the world we almost brought it back :(
@Pollofn6 @RazZzero0oFN @FalconsEsport
173
May 31
ETL vs. ELT isn’t about right vs. wrong.
It’s about tradeoffs.
Different path. Same goal: trusted data and better decisions.
#DataEngineering #Analytics #BusinessIntelligence
17
May 30
Most analytics failures start before the analysis.
SOAR keeps teams focused on what matters:
Question → Data → Insight → Action
That’s where business value is created.
#datascience #businessanalytics #dataanalytics
1
1
46
May 28
Most Python classes are just data containers.
So why write __init__(), __repr__(), and comparison methods yourself?
Dataclasses do it for you.
Less boilerplate. More clarity. Better code.
#Python #Coding #SoftwareEngineering
24
May 27
Most people manually count with dictionaries.
Python already solved this:
from collections import Counter
Cleaner code. Fewer bugs. Better intent.
One of the most underrated Python classes.
#python #datascience #dataanalytics
1
25
Chris Perry retweeted
May 27
LISTAGG is one of the most practical Oracle SQL functions for reporting.
Turn repeated rows into clean, ordered summaries directly in SQL.
Great for exports, dashboards, and audit reports.
#OracleSQL #SQL #DataEngineering
1
1
31
May 22
Oracle Database 26ai quietly added aggregation filters.
Conditional aggregation just became dramatically cleaner:
SUM(amount) FILTER (WHERE in_stock = 'Y')
No more CASE clutter everywhere.
#SQL #OracleDatabase
16
May 21
Preparing for AI conferences with other senior leaders / co workers be like …
#ai #humor #leadership
1
1
25
May 21
Don’t ink that multi-million dollar contact after a 6 minute demo 🤣
13
May 20
Foreign keys protect meaning.
Referential integrity keeps child records tied to real parent records, preventing orphan data and cleaner joins.
Bad rules create bad reports.
Good constraints create trust.
#database #sql #dataengineer #analyticsengineer
29