By using website you agree to our use of cookies as described in our cookie policy. Learn More


June 9th, 2016: Tennessee Chapter of the TDWI Meeting - Nashville

Connect. Share. Learn.

Dear Tennessee BI/DW and Analytics Professionals,
We cordially invite you to attend our upcoming TDWI Tennessee Chapter meeting on June 9th, 2016 in Nashville. Come meet other local professionals, swap business cards, share ideas, and exchange career advice while listening to quality presentations in a vendor-neutral setting, which is the hallmark of TDWI education. Our speakers will be DW/BI end-users reporting on their success and lessons learned implementing various BI tools or projects. Please see our detailed meeting agenda below.


Thursday, June 9th, 11:00 a.m. – 3:00 p.m.



Tractor Supply Company
5401 Virginia Way
Brentwood, TN 37027


Aggregate Deceptions: Finding Suitable Aggregation Strategies and Appropriate Functions



11:00 – 11:15 a.m.

Welcome and Opening Remarks

11:15 – 11:30 a.m.

Introductions and Chapter Business

11:30 – 12:00 p.m.

Lunch and Networking

12:00 – 1:00 p.m.

Presentation: Aggregate Deceptions: Finding Suitable Aggregation Strategies and Appropriate Functions by Michael J. Handley, YMCA Association of Middle TN


Whether within a powerful visualization tool, an OLAP database, long aggregations in MongoDB, or simple report queries directly over an on-premises data warehouse, the mathematical algorithms written into the common aggregate functions can at times create deception over data sets, particularly when there is a less-than-perfect distribution of details across the range. Statistical functions can be used in tandem and with other aggregate functions to mitigate some numeric reporting risks.
Moreover, the periodicity choices—the backbone of any typical BI aggregation strategy—can be thought of as an orthogonal (vertical) informational complement to the longitudinal (horizontal) approach for describing an entity and how it changes over time. Think of this as a mindset "pivot" from typical Enterprise BI reporting to analytic methods.  This presentation is loosely based on the presenter's article published in TDWI’s "Business Intelligence Journal", March 11, 2016.

1:00 – 1:30 p.m.

Break and Networking

1:30 – 2:30 p.m.

Presentation: Top 10 Data Warehouse Needs that are easy to Overlook by Chris Bowman, Manager of Business Intelligence at HireRight


Every Data Warehouse deployment encounters similar issues and struggles but they can also deliver similar successes.  These accomplishments don’t come automatically as even the most successful projects can require blood, sweat, and tears.  We would probably all agree on the project’s major phases, processes, techniques, and even platforms.  But there are also smaller tasks that your team can perform that can go a long way towards the success of the data warehouse in your organization.  We will review 10 of these tasks during this discussion.  As you will see, many of these are quite simple to implement and can be done regardless of your organization.  Feel free to listen or share from your experiences as we explore simple steps that can go a long way.

2:30 – 3:00 p.m.

Q&A and Wrap-up


Space is limited so sign up early!
To contact a Chapter officer, click on name of the officer located on the top right hand column of this page.

Bios of Presenters

Michael J. Handley
Mike is currently the Director of Information Strategy at the Y main office on Church Street. He has 30+ years of experience in technologies and 20+ years in corporate IT for Fortune 500 companies within healthcare, marketing, and manufacturing verticals. Mike has been focused on DW/BI for over 15 years. He earned an undergrad in Computer Science from SUNY Polytechnic in Rome, NY and an MBA from TnTech in Cookeville, (among other degrees and certifications), and works to keep current with new methods and technologies.  He can be reached at [email protected] or on our TDWI MeetUp group.


Chris Bowman

Chris is currently the Manager of Business Intelligence Development at HireRight here in Nashville. He has over 15 years’ experience in Business Intelligence working with both traditional Data Warehousing and Operational BI.  His experience includes providing technical support through development and application administration along with managing multiple teams.  His multi-faceted background that includes experience in finance, utilities, marketing, fundraising, healthcare, and retail gives him a unique perspective into the world of BI.  His passion with BI includes the whole lifecycle development process concluding with the deployment of solutions that bring real life value to the business.


Upcoming Meetings


Look for future TDWI Tennessee Chapter meetings in both Memphis and Nashville coming soon.

TDWI Membership

Get immediate access to training discounts, video library, research, and more.

Find the right level of Membership for you.