Neal Waterstreet

  • Home
  • About
  • Book Reviews
    • 2018 Reading List
    • 2017 Reading List
    • 2016 Reading List
    • 2015 Reading List
    • 2014 Reading List
    • 2013 Reading List
  • Projects
    • OBi200
    • DS716+ memory upgrade
    • Cord cutting
  • Presentations
  • Contact

Atlanta Modern Excel – May Meeting

May 9, 2018 by neal Leave a Comment

Topic: Time Intelligence and Date Tables in Power BI & Excel

Speaker: Marco Russo (MVP, Author, DAX Guru)

Summary: Every Power BI model has dates and the need of calculation over dates to aggregate and compare data, like Year-To-Date, Same-Period-Last-Year, Moving Average, and so on. Quick measures and DAX functions can help, but how do you manage holidays, working days, weeks based fiscal calendars and any non-standard calculation.

This session provides you the best practices to correctly shape a data model and to implement time intelligence calculations using both built-in DAX functions and custom DAX calculation for more complex and non-standard requirements.

RSVP at https://www.meetup.com/Atlanta-Modern-Excel-User-Group/events/250622970/

When: Wednesday, May 16, 2018

Where: Microsoft Technology Center, 8000 Avalon Boulevard, Suite 900, Alpharetta, GA 30009 (https://binged.it/2KQLAPw)

Filed Under: Atlanta Modern Excel Group Tagged With: Data Modeling, Excel, Power BI

Atlanta Modern Excel – May Meeting

May 11, 2017 by neal Leave a Comment

Topic: Data Modeling for Atlanta Excellers

Speaker: Patrick LeBlanc  (https://twitter.com/patrickdba)

Summary: In this session, I will show you what, why, and how to do data modeling. In this session, we will take a flat data file and show you what you need to consider, how you can model this data in Excel as individual tabular structure and how you can connect these tables. You will walk away with the basic data modeling concepts and techniques that will be very useful in the real work when you do data analysis using Excel and PowerBI.

RSVP at https://www.meetup.com/Atlanta-Modern-Excel-User-Group/events/239729655/

When: Wednesday, May 17, 2017

Where: Microsoft Alpharetta Office, 1125 Sanctuary Pkwy #300, Alpharetta, GA 30009 (https://binged.it/2nYkfyz)

Filed Under: Atlanta Modern Excel Group Tagged With: Data Modeling, Excel, Power BI

May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Mar    

Blogroll

  • Atlanta MDF
  • Atlanta Microsoft Business Intelligence Group
  • Atlanta Modern Excel User Group
  • Chris Webb's BI Blog
  • codegumbo
  • Lance England
  • PowerPivotPro
  • Prologika
  • SQLBI

Tags

#SQLSatATLBI Aereo at Atlanta Microsoft BI Azure Azure DataFest Backups Batch Certification changeset Chicago Conference CrashPlan Data Modeling Data Quality DAX Deployment DVR Entity-based staging Error Messages Excel Filter Goals Headphones Healthcare Leaf Tables MDM MDS MDS Add-in for Excel Oops! Something went wrong PASS Healthcare VC Power BI Power Pivot review Roku SQLSaturday SQL Saturday 800 SQLSaturday Atlanta BI SSIS Streaming Subscription View Time Training Validation Version Flag

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Copyright © 2025 · Minimum Pro Theme on Genesis Framework · WordPress · Log in