Upcoming Events

From Reporting Services Rookie to Rockstar

PASS Summit 2013, Charlotte, NC October 14, 2013

Preconference

Join this introduction to SQL Server Reporting Services, designed specifically for report developers who have no prior experience with the product, and learn how to use the development tools effectively, how to present and enhance data in a report, and how to create dynamic reports. Even if you have some experience with Reporting Services, this session will explore aspects that aren’t intuitive or well-documented, helping you expand your skills and make the most of this powerful reporting tool.In a jam-packed day of discussions and demonstrations focused on SQL Server 2008 Reporting Services and later, you’ll learn:
• How to approach the report development process
• How to manage key components of a report project: data sources, datasets, report items, and data regions
• How to use a tablix effectively to design the layout of data with creative groupings
• How to use expressions to display data or change the appearance and behavior of a report in practical ways
• How to use report parameters with and without query parameters
• How to use data visualization features to enhance the communication of information
• How to add interactivity to reports
• How to work with pagination and rendering features to manage page layout
• And more!

 

Reduce, Reuse, Recycle: Automating Your BI Framework

PASS Summit 2013, Charlotte, NC October 16, 2013

Spotlight Session

Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.

 

Planning Your Report Design

PASS Summit 2013, Charlotte, NC October 17, 2013

Regular Session

SQL Server Reporting Services provides a lot of flexibility in report design, which can be overwhelming at first. You can spend a lot of time trying out different approaches to report design before you discover that a feature that users need most conflicts with the features you’ve been implementing. With some advance planning, you can decide which features are most important for your current project and be more productive throughout the report development process. In this session, you’ll learn how to approach the report design process, including assessing your audience, reviewing your layout options, and implementing standards.
 

A Big Data Primer

SQL Saturday #237, BI Edition Charlotte, NC October 19, 2013

The term “big data” dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
 

A Big Data Primer

SQL Saturday #256 Kalamazoo, MI November 2, 2013

The term “big data” dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
 

Languages of BI

SQL Server Days 2013 Schelle, Belgium November 7, 2013

Preconference Session

To get the most of the presentation layer tools in the Microsoft BI stack when data sources include cubes, PowerPivot workbooks, and data mining models, you can’t rely solely on your T-SQL skills.To produce high-performing reports and analytical tools, you’ll need to use other query languages like MDX, DAX, or DMX.

In this workshop, you’ll learn which languages each presentation layer tool supports and the basic syntax used by each language. You’ll also learn how take advantage of query builder tools to help you produce queries until you’ve developed the proficiency to create more complex queries on your own.

You’ll also learn how to work with expressions to add calculations to cubes and PowerPivot workbook, and how to use expressions to customize the appearance of reports, scorecards, and dashboards.

 

Power BI

SQL Server Days 2013 Schelle, Belgium November 8, 2013

Regular Session

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we’ll review the BI components available in the cloud BI stack. We’ll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you’ll have a better understanding of what’s possible and whether it’s time to launch your BI-in-the-cloud solution.

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we’ll review the BI components available in the cloud BI stack. We’ll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you’ll have a better understanding of what’s possible and whether it’s time to launch your BI-in-the-cloud solution.

 

Power BI

SQL Cruise 2014 Caribbean, January 25 – February 2, 2014

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we’ll review the BI components available in the cloud BI stack. We’ll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you’ll have a better understanding of what’s possible and whether it’s time to launch your BI-in-the-cloud solution.

Microsoft has brought business intelligence to the cloud. What does this mean and how does this work? In this session, we’ll review the BI components available in the cloud BI stack. We’ll also compare and contrast functionality of the cloud BI tools with on-premises tools. After attending this session, you’ll have a better understanding of what’s possible and whether it’s time to launch your BI-in-the-cloud solution.

 

SQLSkills Immersion Event – Business Intelligence

Tampa, FL February 10 – 14, 2014 

Chicago, IL April 28 – May 2, 2014 

Even with little to no knowledge of BI, this course will provide you with immediately-usable, production-level knowledge of BI. The course has been designed to take you from installation to configuration to application and integration – for all facets of the BI stack (SSIS, SSAS, SSRS, PowerPivot, and SharePoint) – it is meant for anyone who wants to get involved in BI. Are you a DBA who wants to better understand how to support BI projects on your servers? Or do you need to jumpstart your skills so you can start building solid, scalable BI solutions? This class might be the perfect way to advance your career and dig deeper into topics that don’t typically get covered in most BI classes.

Maybe you accomplish quite a bit with Excel – but how do you get the data there? Quite a few folks use cut-and-paste, or import from a CSV – but of course there’s a much better, and much more scalable and robust way using SSIS! Relational data warehousing – with lots of aggregate tables – helps you keep your data organized for Excel or any other type of reporting or analysis tool that you might want to use, but some types of business questions are answered more easily when you move your data from the data warehouse into SSAS cubes. Whether you store data in tables or cubes, you have a variety of options in the BI stack to access and analyze the data, but which is best? Learn how to choose the right tool for the task and how to manage a secure and scalable environment for reporting and analysis.

The course starts out in the 100-200 range on Day 1 but moves into the 200-300 range for the remainder of the week. For each technology in the BI stack, you’ll learn basic usage and design principles, followed by more coverage of configuration, performance tuning, and other management tasks than you’ll find in most BI end-to-end classes. The course will not only bridge the gap in your BI knowledge, but will continue on to take you a lot further. If you’ve always wanted to immerse yourself into BI, figure out the end-to-end story, and go behind-the-scenes to learn how to install, configure, and deploy BI solutions, this is the place to be!