TDWI Chapters: Minneapolis

The purpose of the Minneapolis Chapter of the Data Warehouse Institute (TDWI) is to enable local BI/DW professionals to:

  • Meet regularly with each other on a regional basis
  • Share best practices in a small group setting
  • Establish a strong network of peers
  • Gain technical advice and career direction

Everyone is welcome. We encourage you to become a member but you do not need to be a TDWI Member to attend.

You may browse previous events using the page buttons at the bottom of the page.


March 9, 2010: Innovations in Business Intelligence: Operational BI & Columnar DBMS 101


Connect. Share. Learn. Innovate

ATTENTION ALL BI/DW AND MARKETING PROFESSIONALS IN THE MINNEAPOLIS – St. PAUL AREA

Dear Minneapolis and St. Paul Area BI and DW Professionals,

We cordially invite you to attend the upcoming TDWI Minneapolis Chapter meeting on March 9, 2010. The theme of the March meeting is BI Innovations covering Operational BI and Columnar Databases. The meeting features another well-known and influential industry thought leader, William McKnight (See Abstract Below). Learn from William’s insight, meet other local professionals, swap business cards, share ideas, and exchange technical and career advice while listening to a quality presentation in a vendor-neutral setting, which is the hallmark of TDWI education. Our meeting agenda is below.

When:

Tuesday, March 9, 2010, 8:00 a.m. – 12:00 p.m.

Where:

Target Corporation
City Center

33 S. 6th Street
Minneapolis, MN 55402

Directions please click here

We are again pleased that Target Corp will host our March 9 meeting. Please note that this meeting is not in the same room as our September meeting. Please proceed to the City Center location and check in at the Skyway level Security Desk. Preregistration will facilitate your entry to the meeting..

DON'T MISS THIS EVENT! Please RSVP below

Click here to register for the next upcoming event

Agenda:

7:45 - 8:15 a.m.

Networking and Registration

8:15 – 8:30 a.m.

Introduction and Chapter Business

8:30 – 9:30 a.m.

Innovation Part I: Operational BI” by William McKnight

Abstract

Business intelligence (BI), utilizing data warehousing as a primary conduit, must change to adapt to competitive pressures. There are business realities forcing these changes. First, there is an information explosion, which can inundate a data warehouse's intake capabilities and render nonautomated analysis to the most basic of levels. It is a real-time business world where suboptimally timed decisions can mean the difference between success and failure. Intraday or during the immediate occurrence of a trigger event is the necessary timing of much intelligence.

Recent advances in information management technology such as Master Data Management, EII and other forms of operational Business Intelligence have allowed for a more nuanced, yet effective, strategy for information management to complement data warehousing.

Join William in a discussion of the value of aligned and accelerated decisions supported by operational business intelligence and an overview of EII, CEP, and DSP as they relate to empowering an operational environment with intelligence.
.

You Will Learn

  • Operational vs. Strategic Decisions
  • The Value of Aligned and Accelerated Decisions
  • The Data Warehouse Conundrum
  • Enterprise Information Integration
  • Embedded Business Intelligence: Complex Event Processing, Data Stream
  • Processing and Business Activity Monitoring

9:30 – 9:45 a.m.

Break and Networking

9:45 – 10:45 a.m.

Innovation Part II: “Columnar DBMS 101by William McKnight

Abstract

Columnar DBMS 101
A columnar DBMS is an implementation of the relational theory, but with a twist. The data storage layer does not contain records. It contains a grouping of columns.

Due to the variable column lengths within a row, a small column with low cardinality, or variability of values, may reside completely within one block while another column with high cardinality and longer length may take a thousand blocks. In columnar, all the same data – your data – is there. It’s just organized differently (automatically, by the DBMS).

The main reason why you would want to utilize a columnar approach is simply to speed up the native performance of analytic queries. There is no difference in the SQL or data access tool used to interface with the data or the logical data modeling.

The columnar approach to data management is not new. In fact, the mainframe database Model 204, first deployed in 1972, used a similar approach. However, columnar’s time may have finally come as analytic processing becomes a business imperative.

You Will Learn

Learn about the columnar orientation and how it can be effective for your needs. This is the orientation of Vertica, ParAccel, Sybase IQ, InfoBright, Exasol, VectorWise and MonetDB. As well, Microsoft SQL Server, in its 2010 release, will have an optional column-oriented storage layer.

10:45 – 11:45 p.m.

Innovation Roundtable, Q & A and Collaboration

11:45 - 12:00 p.m.

Closing Comments & Wrap-Up

DON'T MISS THIS EVENT! Please RSVP below

Click here to register for the next upcoming event

Space is limited so sign up early! To become a member at a 10% discount, please click here and use priority code

mincpt1. For more information about TDWI Membership, contact chapters@tdwi.org.

To contact a Chapter officer, click on name of the officer located on the top right hand column of this page.

Follow Minneapolis chapter meeting notices on Twitter: @TDWIMpls

William McKnight’s Bio

William is President of McKnight Consulting Group. His practice focuses on delivering business value and solving business problems utilizing proven, streamlined approaches in data warehousing, master data management and business intelligence, all with a focus on data quality and scalable architectures.

William has more than 20 years of information management experience, nearly half of which was gained in IT leadership positions, dealing firsthand with the challenging issues his clients now face. His IT and consulting teams have won best practice competitions for their implementations. In 11 years of consulting, he has been a part of 150 client programs worldwide, has over 300 articles, white papers and tips in publication and is a frequent international speaker. William is the author of 90 Days to Success in Consulting. Contact William at william@williammcknight.com or (214) 514-1444.

0 comments


Please note that TDWI membership, while encouraged, is not required to attend this TDWI Minneapolis meeting. If you value the information and networking opportunities you experience at TDWI Chapter events, you can further empower your career by becoming a TDWI Member. TDWI Membership arms you with a powerful, comprehensive, and constantly growing selection of industry research, news, online content, and peer networking opportunities developed exclusively for Members. TDWI Members also receive discounts on TDWI conferences, seminars, and CBIP exams.
Learn More
Become a Member Today and receive a 10% discount off of the membership cost! Use Priority code mincpt1.

About TDWI Chapters

TDWI sponsors Chapters in regions throughout the world to foster education and networking at the local level among business intelligence and data warehousing professionals. Chapter meetings are open to any BI/DW professional.

Chapter Officers

President
Vice President
Chapter Secretary
Kasi Anderson
Program Coordinator
Laura Madsen
PR Coordinator
Rao Nemani
Sponsor Coordinator

Sponsors

IBI

Lancet

onApproach

Woodburn

IBM

Contact Information

TDWI Membership Department
425.226.3053

About TDWI

The Data Warehousing Institute™ (TDWI), a division of 1105 Media, is the premier provider of in-depth, high-quality education and research in the business intelligence and data warehousing industry. More