Current Articles | Categories | Search | Syndication

Human Resource Demand for BI - Article Rating

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




Traditional BI builds reports off of Relational Databases; Next-Generation BI builds predictions off of many data sources


In this session, we will discuss using relational and non-relational data sources, modeling the data as its read (not as it’s stored), using Advanced Analytics (Machine Learning) to deliver Predictive as well as Descriptive Analytics, and an overview of the BI UG charity project:  using Machine Learning to match mentors and students for a local school.

Speaker: Scott Shaw, Horton Works and Phil Milner, BI UG Chair


Traditional versus new Analysis Services:  Multi-dimensional mode Tabular mode


The mulit-dimensional mode is the traditional Analysis Services.  It provides data cubes for fast, ad hoc data exploration.  Tabular mode is an in-memory database/analytics for reporting apps such as Excel and Microsoft Power View.  The future is not only big data but fast data via in-memory analytics!

Speaker: Maria Stanley, Oakwood Technology


Introduction to Machine Learning and how it relates to the BI UG charity project

Machine Learning is applying statistics to data to discover patterns.

It is one of the primary tools to enable advanced analytics and work with big data.

Microsoft now offers Machine Learning on its Azure data platform.

Speaker: Jeff Heaton, Reinsurance Group of America and Heaton Research

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