Current Articles | Categories | Search | Syndication

8/12/2014 Meeting: To the Future and Beyond - Article Rating

Topics:  The Future of BI:  Diverse Data and Advanced Analytics

                Including Microsoft’s Azure Machine Learning


                Additional Presentation from Maria Stanley of Oakwood Systems Group

Read More

Class Discounts - Article Rating

PragmaticWorks Class Discounts 


May 20-21,  2 Day SQL Server Performance Tuning Workshop –  

Discount Code SSPT2014 – Discount Expires 4.20.14 


May 12-16,  5 Day BI QuickStart Bootcamp – 

 Discount Code BIQB2014 – Discount Expires 4.12.14 

2/11/14 Self-Service BI with Power Pivot and Power Query - Article Rating


12:30PM         Registration - Lunch Provided by Covenant Technology Partners

1:00PM           PowerPivot

2:00PM           Self-Service BI with Power Query and Building Models Against the Various Data Sources

3:00PM           The Basics of Analysis Services and Their Role in the BI Stack

4:00PM           Q&A and Wrap up


In this session, learn how anyone with Excel experience can take advantage of PowerPivot, the free add-in for Excel, to quickly and easily turn data from different sources such as traditional databases, Analysis Services, Excel, or the web into a workable dataset.  Use this data for ad hoc analysis or to create visually impressive reports directly in Excel.  Then leverage SharePoint to automatically refresh the data and publish it to share with others in the organization.

Speaker: Melissa Meyer, Covenant Technology Partners

Melissa is a senior consultant with Covenant Technology Partners with a passion for all things data. Melissa has been working in BI for 10 years and specializes in implementing the SharePoint BI stack and BI solutions of all types and sizes. In her free time, she enjoys travel, hunting, cooking and spending time with family

Self-Service BI with Power Query and Building Models Against the Various Data Sources

It’s powerful to put BI into the hands of users with Power View and Power Query.  This makes the business efficient and reduces the workload of IT!

Come see how analysis against databases can be executed quickly by business users with these relatively new Microsoft tools.

Speaker: Clayton Groom, Covenant Technology Partners

Clayton Groom is a founding partner of Covenant Technology Partners.  He has worked at the world’s best IT consulting organizations before helping to create CTP.

Clayton is a frequent speaker at User’s Groups and local conferences as well as leading the Business Intelligence practice at Covenant and taking care of his growing family.

The Basics of Analysis Services and Their Role in the BI Stack

The presentation will cover the basics of Analysis Services or Microsoft’s multi-dimensional (cube) database. Relational tables are great but sometimes fast, efficient analysis requires another tool:  the multi-dimensional database and a complex meta-data engine. You will see how cubes are designed and how they relate to a data warehouse. You will also see fast that makes ad-hoc data analysis.  Finally, you will see how the meta-data engine of Analysis Services is a key to other Microsoft BI Products.

Read More

PASS SUMMIT 2014 Discount - Article Rating


Missed PASS Summit’s early-bird savings last week? 

You can still get the lowest rate on the biggest and best SQL Server technical conference.

Save $150 by using the discount code ALUMNI3D before January 31, 2014.

Register Now



Read More

Last chance for early-bird savings PASS Summit 2014 - Article Rating


Register for Summit 2014 now to save $300

St. Louis SQL Server and BI User Group Meeting January 21, 2014 6PM CDT - Article Rating



Performance tuning SQL Server Integration Services (SSIS)


In this demo-rich presentation, Devin shows you some of the common and not so common ways to tune SQL Server Integration Services (SSIS). Learn how to tune the data flow using some of the advanced SSIS options and how to avoid common SSIS mistakes.


Don’t miss the 2-Day Self-Service BI Workshop that starts in the morning and ends January 22nd.


Speaker: Devin Knight, Training Lead, PragmaticWorks

Devin a Microsoft MVP and the Training Director at Pragmatic Works Consulting.  He is an author of five SQL Server books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQL Saturdays and Code Camps. He is also a contributing member to the PASS Business Intelligence Virtual Chapter.  Making his home in Jacksonville, FL, Devin is the Vice President of the local users’ group (JSSUG).


Lync Meeting Information

Read More