| Speaker |
Description |
Angel Abundez
|
Instructor:
Angel Abundez
Date/Time:
6/20/2013 11:00 AM
In today's mobile landscape, many companies such as Spotify, Dropbox, XBox Live, and Netflix are succeeding with subscription-based business models. Measuring and monitoring subscription data can provide a wealth of information, but conventional methods using CRM and ERP systems to track such business simply don’t work. Several key metrics in membership and revenue exist that should be used to monitor the health of this type of business model. In this session we'll show you how to dimensionally model the subscription economy and uncover these key metrics. We'll explore lessons learned, team requirements, and business rules you can take away in modeling the subscription economy. You’ll be faced with hard questions around “freemium” subscriptions, grace periods, and legacy data we’ll cover that, too . Then, we’ll end with some good data visualizations you can use to uncover additional value from these critical measures.
Measuring the Subscription Economy
|
Chris Schmidt
|
Instructor:
Chris Schmidt
Date/Time:
6/25/2013 11:00 AM
In this session, we'll cover some of the more advanced concepts in tabular databases. First we'll take a look at things like partitions and perspectives, and how we can use them to assist in management and maintenance of an Analysis Services database. Then we'll look at implementing dynamic security into our solution, and finally we'll briefly explore the types of query modes available to tabular.When should In-Memory, DirectQuery, or one of the hybrids be used?
Advanced Concepts in Tabular
|
Anthony Sammartino
|
Instructor:
Anthony Sammartino
Date/Time:
6/27/2013 11:00 AM
In this session I will cover how PowerPivot and BISM Tabular complement each other in the domains of self-service and corporate BI. Let's face it, The Finance department does not have the expertise to model a database for reporting, and IT doesn't have the expertise in advanced financial calculations that the executive team is interested in. To bridge the gap from a large requirements process with the risk of functionality lost in translation, I will show you how you can roll out a PowerPivot model for business units in your organization and when it makes sense to centralize it in a BISM Tabular model.
A Balanced BI Approach (Self-Service & Corporate)
|
Brian Knight
|
Instructor:
Brian Knight
Date/Time:
7/2/2013 11:00 AM
The technology field is full of amazing jobs but you need to stand out to get the perfect job and salary. Learn about the jobs and salaries that are available in the market and do a check to see if you’re on track to achieve one of the amazing jobs in business intelligence or software development. Also, learn how to make your resume shine against thousands of people competing for the same jobs.
Doubling Your Salary in 3 Years
|
Jorge Segarra
|
Instructor:
Jorge Segarra
Date/Time:
7/9/2013 11:00 AM
Now that Windows Azure virtual machines are generally available to the public, how does this offering affect you? In this session we'll review this offering, walkthrough creating and deploying a virtual machine with SQL Server on it. We'll also discuss how you can leverage this offering to your existing infrastructure!
Azure Virtual Machines: A Walk in the Cloud
|
Bradley Schacht
|
Instructor:
Bradley Schacht
Date/Time:
7/11/2013 11:00 AM
With more and more companies moving to the cloud it’s important to understand how that affects data analytics. It’s great to store data on Azure but what about your BI applications? How does this affect reporting services, analysis services cubes, PowerPivot and Excel. We will explore how to integrate an Azure database with the rest of the Microsoft BI stack on premises and also walk through Reporting Services on Azure.
Combining Azure and Business Intelligence
|
Jason Strate
|
Instructor:
Jason Strate
Date/Time:
7/16/2013 11:00 AM
Sometimes the hardest performance issues in your environment have simple solutions. One of these simple solutions is through properly indexing the database. In this session, we’ll look at five ways that performance of a database can be improved through indexing. When we finish, you’ll be armed with scripts and methodologies that you can put into place today to improve database performance.
5 Ways to Improve Performance through Indexing
|
John Welch
|
Instructor:
John Welch
Date/Time:
7/18/2013 11:00 AM
There are multiple ways to solve most problems in SSIS, but some approaches are better than others. In this presentation, we’ll show some of the common approaches that can impact the performance, maintainability, and understandability of your packages. We’ll discuss how to tell if a particular scenario is a cause for concern, and how to address the problem, and how to update the package to a better approach if necessary. We’ll also cover using BI xPress’s Best Practices Analyzer to quickly identify trouble spots in your packages.
SSIS Best Practices Checklist
|
Bradley Ball
|
Instructor:
Bradley Ball
Date/Time:
7/23/2013 11:00 AM
VLDB’s are the way of the world. Years ago a large database was anything over 10 GB, then it was 100 GB, and now 1 TB sized databases are common place. Querying large tables takes a lot of time, archiving data takes forever, inserting new rows take hours, and rebuilding indexes take longer and longer. In this session we will talk about how to effectively use Partitions for Fast Loading and Fast Archiving data. We’ll cover sliding windows, using views for partition elimination, Partition Schemas, Functions, and things to keep in mind when querying from partitioned tables.
Partitioning in SQL Server 2012
|
|
Jason Strate
|
Instructor:
Jason Strate
Date/Time:
7/25/2013 11:00 AM
Extended events provide DBAs with a powerful tool that can be used to troubleshoot and investigate SQL Server. Throughout this session, you’ll walk through five great reasons, with demos. By the end of the webcast, you’ll be itching to grab the scripts from the demos to start building your own extended event sessions today.
5 Amazing Reasons DBAs Need to Love Extended Events
|
Julie Koesmarno
|
Instructor:
Julie Koesmarno
Date/Time:
7/30/2013 11:00 AM
SQL Server Analysis Services Tabular Model allows rapid and simplified data modelling of Business Intelligence solutions. An important aspect that is often overlooked when building a tabular model, is meeting real-time requirements. In this session you will learn how to tackle immediate (or close to) real time requirements using the different types of Data Access and Query Modes of Tabular Model and how your choice impacts your reporting options in the Microsoft BI stack...
Understanding Query Modes in Tabular Model
|
Kathi Kellenberger
|
Instructor:
Kathi Kellenberger
Date/Time:
8/1/2013 11:00 AM
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Writing Better Queries with Window Functions
|
James Serra
|
Instructor:
James Serra
Date/Time:
8/6/2013 11:00 AM
If your company is planning to build a data warehouse or BI solution, you need to be aware that BI projects have high failure rates. Gartner says between 70% to 80% of corporate business intelligence projects fail. And with “big data” adding more complexity you can expect even more failures. However, the major causes of these failures are well known and can be avoided by implementing a set of best practices.
I have worked on dozens of end-to-end BI projects and have seen my share of successes and failures. I will talk about the reasons BI projects fail and share best practices and lessons learned so your BI project will fall into the “successful” category.
Best Practices to Deliver BI Solutions
|