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
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
12:30PM Registration - Lunch Provided by Covenant Technology Partners
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
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.
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