Sacramento SQL Server User Group

Attending PASS Summit 2019? Use discount code LGDIS6HUR to save $150 and support our group!

 

Next Meeting

Wednesday,

June

05

Intro to DAX in the Tabular Data Model - Christian Chanco

  • Harvard Square (map)
  • 2180 Harvard Street, Suite 280 (Second Floor)
  • Sacramento, CA 95815
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

Intro to DAX in the Tabular Data Model - Christian Chanco

RSVP on Meetup:
https://www.meetup.com/Sacramento-SQL-Server-User-Group/events/261063805/

DAX, measures, and you: How to use DAX to query your tabular data model.

Have you implemented Power BI in your work to build powerful dashboards and want to encapsulate complex business logic? Do you struggle writing MDX queries in the multidimensional model? If your answer is yes, then join me in this DAX presentation to see how to create measures that make use of the DAX language. I will go over the DAX (Data Expression Language), powerful functions such as SUMMARIZECOLUMNS(), HASONFILTER(), CALCULATE(), USERELATIONSHIP(), RELATED(), FILTER(), ALL() and many more. I will go over the use of variables to make your DAX expression self-documenting and create additional columns in the dimension Date table that slicers or parameters can use to detect the years/months with actual data in Fact Tables.

About the Presenter:
Christian Chanco is a Business Intelligence Developer at Dignity Health Medical Foundation (now part of Common Spirit Health) and promotes the use of Microsoft business intelligence products to find robust business solutions. Lately, he replaced manually ETL processes and reports and automated them with Power BI and DAX for Dignity Health Medical groups in the California Market.

Meeting Sponsor:
Zeektek
https://www.zeektek.com/

Sacramento SQL Server User Group:
https://www.meetup.com/Sacramento-SQL-Server-User-Group
https://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448

Upcoming Events:

SQLSaturday Sacramento 2019:
Join us Saturday, August 17, for a full day of free and fun-packed SQL Server training!
https://www.sqlsaturday.com/885/EventHome.aspx

[SQLSatSac PreCon] Brent Ozar: "Performance Tuning in 21 Demos"
A full day of training on Friday, August 16 with Brent for just $199!
https://www.eventbrite.com/e/sql-saturday-sacramento-precon-brent-ozar-tickets-58872776058

[SQLSatSac PreCon] Kalen Delaney: "SQL Server Query Plans: Reuse or Recompile"
A full day of training on Friday, August 16 with Kalen for just $199!
https://www.eventbrite.com/e/sql-saturday-sacramento-precon-kalen-delaney-tickets-59011310418

PASS Summit 2019 Discount Code: LGDIS6HUR
Attending PASS Summit 2019 in Seattle this November? Use discount code LGDIS6HUR to save $150 and support the Sacramento SQL Server User Group when you register for the Full 3-Day PASS Summit!
https://www.pass.org/summit/2019/Home.aspx

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids