Jacksonville SQL Saturday #1103 - May 3rd, 2025

In your journey to learning Power BI, DAX and calculations are must-learn techniques. However, understanding DAX can be complicated as it uses concepts that can be hard to absorb.
If you want to perform a year-over-year calculation, a month-to-date, or percentage of the total, dynamic row-level security patterns, or even conditional formatting, DAX is the answer to them all. You can write formulas and expressions in DAX which answers all of those queries.
Reza Rad is the best-selling author of the Power BI DAX Simplified book and dozens of other Power BI books. In this one-day workshop, he gets you from the very beginner level of learning DAX into advanced techniques and examples. At the end of this training, you will be able to write DAX calculations for your own models and understand how the calculation and formula language works.
You don't need any prerequisites for this workshop. This workshop is designed for beginner and experienced users of Power BI.
The day includes modules below:
-Fundamentals
-Aggregation and Iterators
-Filter
-Relationship functions
-Logical functions
-Time Intelligence
-Table manipulation functions
-Parameter table

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker, and Consultant. He has a BSc in Computer engineering; he has more than 20 years of experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for 14 continuous years (from 2011 till now) for his dedication to Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of the Difinity conference in New Zealand, the Power BI & Fabric Summit (the biggest Power BI & Fabric conference), and Data Insight Summit (Chicago, USA)
CEO at RADACAD
Director at Power BI & Fabric Summit
Director at Difinity conference (Since 2017)
Microsoft Regional Director (Since 2018)
Microsoft Data Platform MVP (Since 2011)
Leader of Data, Insights, and Power BI user group in Auckland, New Zealand (Since 2013)
Microsoft Fast Track Recognized Solution Architect – Power Platform
Power BI All-Star award winner
Dynamic Communities Emerald award winner
Best-selling author of more than 13 books on BI, analytics, and Power BI
Speaker at many conferences such as Ignite, Microsoft Business Applications Summit, PASS, etc.
Blogger, and content creator
Consultant, and trainer
Microsoft Certified trainer
Microsoft Certified professional
His articles on different aspects of technologies, especially on BI, can be found on his blog: https://radacad.com/blog.
He wrote some books on Microsoft BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and user groups. And He is a Microsoft Certified Trainer.

You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans.
In this 1-day session, Brent Ozar will use the same practical before-and-after techniques that he uses in his Query Challenges blog series in order to demonstrate what parts of your skills need to change as you modernize your databases.
You should be comfortable using SSMS to write multi-page queries, functions, and stored procedures. You should be comfortable identifying common query plan operators like index seeks & scans, key lookups, sorts, and parallelism, and comparing plans.
In this session, you’ll:
* Learn the difference between early and late estimation errors
* Learn how to choose between temp tables, CTEs, and table variables
* Learn the best query hints to apply quickly
* And more!

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. Las Vegas, US.

We will have a room set up for you to ask our SQL Experts for assistance with any current challenges you might be having. Look for this image posted at the door

If you are interested in speaking at SQL Saturday Jacksonville, please go here to submit your sessions: https://sessionize.com/sqlsatjax

By registering for this event, you agree to the following.

SQLSaturday events seek to create a respectful, friendly, patient, considerate, and inclusive event experience and an environment where all participants feel welcome.

We therefore ask all participants to honor this Code of Conduct. Any disruptive, intolerant, or inappropriate behavior will not be tolerated, and we reserve the right to remove participants who violate our Code of Conduct from the event.

We do not tolerate any harassment or discrimination. Although this list cannot be exhaustive, we explicitly honor diversity in age, gender, gender identity or expression, culture, ethnicity, language, national origin, profession, race, religion, sexual orientation, socioeconomic status, physical and psychological ability, and technical ability.

The organizer of this event will prioritize marginalized people’s safety over privileged people’s comfort. Please report any concerns, harassing behavior, or suspicious or disruptive activity to the event organizer or staff.

Jacksonville's 17th Annual SQL Saturday event includes paid pre-con tracks and one FREE day of training sessions for Microsoft Data Platform professionals and those wanting to grow their Business Intelligence, Analytics, and SQL Server skills. This event is hosted by Jacksonville SQL Server Users Group, a 501c3 non-profit organization.

SQL Saturday is a training event for SQL Server and data professionals who want to learn how to elevate their careers to the next level. This is the 17th year of SQL Saturday in Jacksonville, and it will be held on May 3, 2025. Admittance to this event is free; donations and sponsorship cover all costs. Please register soon, as seating is limited, and let friends and colleagues know about the event. SQL Saturday Jacksonville is hosted by Jacksonville SQL Server Users Group, a 501c3 non-profit organization.

Why: It is a great opportunity to learn from SQL Server Experts, Microsoft MVPs, SQL Server Authors, and Professionals who have been through and can relate to the obstacles you have day to day. This one-day training event is unlike any other, providing free food, training, and networking.

You may place discounted reservations between 4/30/25 and 5/5/25 - All reservations must be booked before 4/15/25 for the discount.

Host or Publisher Jeff Taylor Events