HUG Access SIG Meeting 6:30 pm, July 15, 2015, at JCCC, Regnier Center - 3rd Floor, RC 353

Beginning Presentation: Data Warehousing in Microsoft Access

Presenter:   Jim Watkins
Description: How in the heck do you do Data Warehousing in Access? Why would I want to do data warehousing in Access? OK, let’s say I can do data warehousing in Access but .... Should I do data warehousing in Access? Can a star schema be implemented in Access? What the heck is a star schema? Why can’t I use a relational database for OLAP processing?

Jim Watkins is a senior developer for Heritage Computer Consulting & Services, Inc. HCCS is a 24 year old Computer Consulting firm located in Overland Park, Kansas specializing in providing custom solutions to real world challenges for their clients.


Advanced Presentation:    OLAP databases and Cube Functions

Presenter:   Caren Grandgenett

Description: OLAP databases and Cube Functions: Use Online Analytical Processing (OLAP) databases to perform multidimensional analysis of business data.
Background: OLAP databases can be stored on SQL Server where the relationships and hierarchies are stored in cubes.  Cubes provide a multi-dimensional way to look at data.

Caren Grandgenett is an Adjunct Assistant Professor  - Business Entrepreneurship and Technology at Johnson County Community College.  She develops and maintains databases that allow clients to track their clients and competitors.

Drawing:  {for HUG members}
Microsoft Access 2013 for Dummies by Laurie Ulrich Fuller & Ken Cook.
Drowning in data?  Manage it all and make it useful with the tools in Access 2013.
Sponsored by: Heritage Computer Consulting & Services, Inc

Drawing:  {for HUG members)
Amazon $10 gift certificate.
Sponsored by: Heartland User's Group; Access SIG
This drawing for HUG Members only