• Home
• Training SQL Server 2008
• Meeting Location
• Downloads
• Meetings at a Glance
• Contact Us

May Meeting: Professor Stewart Rogers

We have a very special opportunity for you: this month’s instructor will be Professor Stewart Rogers of the Business Intelligence Graduate Program at SMU – Cox School of Business!

Professor Stewart Rogers is going to give us a rare and valuable insight into what Business Intelligence really means to the corporate world and how we can enable Business Analysts to do their analysis work without overburdening Report Writers.

Some of the topics Professor Rogers will cover will be:

• Tips and tricks for identifying, (via the SSIS DNS Test Connection)
• Which applications are being called and how to optimize this
• Why and when to use Excel as a reporting tool
• The Pro’s and cons of using Excel pivot tables as a reporting and alternatives to pivot tables

(collecting SQL data and creating dynamic Excel reports in the formats that are actually being utilized for large corporations by their Business Analysts (using 7-11 as an example of this methodology)…in other words, pushing into specific Excel fields exactly what the BA’s are having to cut’n’paste and restructure into their spreadsheets to perform their Business Analysis, such as the Pivot Tables in Excel as they almost always need).

• How to take slices from a data warehouse and move into a smaller stand-alone database for portability to locations that have no external connectivity or have limited software approaches (small businesses or remote businesses that must rely on stand-alone solutions such as SQL Express or Access databases), which actually enables DBA’s to branch out to assist in or create solutions for a turn-key data analysis solution for small to medium businesses or even large corporations when their business processes restrict their network connectivity.

7 pm but come early for our meet and greet at 6:30 pm if you can and get to know Professor Rogers

Hope to see you there!

~ Mary Mathias

Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.