This session will examine ways to write better code by using CTEs to simplify queries, implement error handling to deal with problematic data, and show a few tips and tricks for writing code quicker and generating enough test data to properly evaluate your queries.
We'll examine a few intermediate techniques for efficient queries. We start with tally tables and calendar tables, showing practical uses of each. We will then look at pivoting data to display row data as column data and vice versa.
In this session, we'll examine the windowing functions in SQL Server that allow you to efficiently query data in groups, or partitions, and answer complex questions such as running totals and ranking results into percentiles.
Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More
It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More
To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More