Jacksonville SQL Server User Group (JSSUG)

***** Register here: https://sqlsatjax.eventbrite.com/?aff=Meetup *****

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

Special Notes

You will also be required to buy a pay-by-plate daily parking permit ($5) on the day of the event. You may do this online or at one of the kiosks located in the garage. Kiosk map and pay by plate instructions: https://bit.ly/3IASwg6 - for a map: https://bit.ly/3qsPMLE

***** Register here: https://sqlsatjax.eventbrite.com/?aff=Meetup *****

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!

****** REGISTER HERE https://sqlsaturday.com/jax REGISTER HERE ********

Jacksonville's 17th Annual SQL Saturday event includes two paid pre-con tracks and one FREE day of training sessions for Microsoft Data Platform professionals and those wanting to grow their skill set in Business Intelligence, Analytics, and SQL Server. 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 will be held on May 3, 2025. Admittance to this event is free, and 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 nonprofit organization.

Why Attend? This 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.

Pre-Cons will be held on Friday, May 2nd.

PreCon: DAX and Calculations in Power BI from Rookie to Rock Star - Reza Rad
Click Here To Register - https://sqlsatjax.eventbrite.com

PreCon: Mastering Query Tuning - Brent Ozar
Register Here - https://sqlsatjax.eventbrite.com