Prescriptive analytics enables you to tell a business exactly what to DO, like how to maximize profits given constraints or limited resources.
I created a two-part video series walking through a simple linear programming model in #Excel.
Start learning here: youtu.be/9yaO87KfG1Y
#dataanalytics
This is a thank you post to everyone who has subscribed to my channel over the many years.
To everyone who’s watched, liked, shared, or even just paused to learn something new; thank you! You are the reason my YouTube channel thrives and evolves!
#Tableau #data #dataanalytics #dataanalyst #SQL
If you are a data, SQL and NBA nerd then this is the preview video for you. I recently analyzed the 2018 NBA Draft by vibe-coding with Windsurf and testing the agentic IDE's SQL capabilities.
Full video can be seen here: www.youtube.com/watch?v=bQob...
#SQL #dataanalytics #dataanalyst #WindsurfAI
I had fun editing these snippets from the second entry in my Advanced Tableau Dashboard Build series.
In the full length sequel (for members of my channel), I tackle the meticulous container approach it takes to complete the dashboard build we started in part 1.
#data #dataviz #Tableau #datafam
I didn't know #Syracuse alumns in Atlanta were rolling this deep. Glad I came out to make a few new connections!
This is a PREVIEW of the long awaited SEQUEL of “Create a Stunning Advanced Dashboard in Tableau”.
In this video I introduce you to the detailed process of sizing and arranging multiple Tableau chart components that we learned how to build in part one.
youtu.be/yKMXwZkIwRs
I'm not the only one.
When to use Excel:
✅ Quick Ad-Hoc Analysis
✅ Interactive What-If Analysis
✅ Flexibility for Non-Technical Users
I've worked in organizations that have needed more SQL processes than Excel spreadsheets.
But I've never worked at an organization where they've needed more Excel spreadsheets than SQL processes.
When to use SQL:
✔ Handling Large Datasets
✔ Automating Processes
✔ Ensuring Data Security
I’m happy to share with my network that I’ve been accepted into The Fuqua School of Business at Duke University to pursue a Master's degree in Quantitative Management - Business Analytics.
I enjoy data analytics and there is always something new to learn.
I added a couple titles to the #data library. Looking forward to getting into these.
I attended SQL Saturday Atlanta and got to observe my talented Protiviti teammates Jeff Levy and Vernon Gomes in action. They gave an informative presentation on the pros and cons of using a #Microsoft Fabric Lakehouse vs. using a Fabric Warehouse.
#SQLSaturday
This one is for the channel members.
ROLLUP and CUBE in #SQL are useful in ad hoc reporting as they allow you to efficiently gauge your metrics by multiple grouping levels.
Join the channel to get access to members only vids!
www.youtube.com/watch?v=NlOw...
#SQLServer #data #dataanalyst
This is your year! Share your wins in the workplace and get the recognition you deserve!
#careeradvice #dataanalyst
One of my all time favorite trip hop songs is "Know You" on "The North Borders" album.
This #Excel dynamic dropdown technique requires minimal preparation and only uses 3 functions.
In this tutorial, I'll use 1 dropdown list to select a position and the other dropdown list will dynamically populate with members of the NBA 75th Anniversary Team who were selected at that position.
Godspeed President Carter.
He was easily the most moral, selfless and decent president in history.
I was extremely fortunate to meet him when I was a graduate student at Georgia Tech years ago.
Yet another new pair of JMM Enzos. This is the Sabre colorway, number 340 of 500.
These black and reds will look good at #ClarkAtlantaUniversity homecoming!
#sunglasses #jacquemariemage
For me, writing the SQL is enjoyable and is about 10% of total effort. It's all of the other factors in play to understand and access the right data that complicate the coding.
Writing SQL is rarely just about writing the syntax.
Anyone can write a query that returns data.
But writing effective SQL that returns the correct data?
That can be a real challenge.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #data #sql
A snap from Delta Airlines company winter Xmas party 2024. Happy holidays all!
While visualization SHOWS, storytelling EXPLAINS. Data storytelling is more than just highlighting with a bold color and an annotation.
www.linkedin.com/posts/brentd...
Learn to automate and visualize your data.
Once you learn these two crucial #data skills, keep on learning.
#dataanalysis #dataanalytics #datascience #dataanalyst
#businessintelligence #sql #datavisualiation
Conventional data punditry suggests that #SQL isn’t difficult to learn. Of course it’s easy to write SQL that returns data; however, it can be very difficult to write SQL that returns the CORRECT #data.
#dataanalyst #dataanalytics
This is the way.
With that said there have been plenty of times where I put together exploratory analytics to determine if there was anything worth knowing about the data. However, the analytics where someone can look at my results and immediately make decisions to help the business are the most rewarding to me.
Great question. One recent example was a dashboard where I put together a proof of concept sourced from ERP extracts. It enabled the CFO to know exactly which employees were frequently the bottleneck in the invoice payment process so he could address them directly and pay outstanding invoices.
In your analytics work, focus on clarity, simplicity, and actionable insights.
#data #dataanalysis #dataanalytics #datascience #dataanalyst #businessintelligence
Giants organization punching air right now.
As I was shutting down my virtual desktop, I was presented with the following error, "Cannot quit Microsoft Office Excel". Yeah you and me both.
