Upcoming Events

Power Up Your Data with Power BI

SQL Saturday Slovenia December 12, 2014

Preconference (Register here)

This workshop will show you how to use Excel 2013 BI features to transform raw data into powerful insights. 
Before you can begin exploring the data, you must build a suitable data model. In this session you’ll learn how to import data into a model and how to combine data from multiple sources.
You’ll also learn how best to structure your model to support analysis by adding relationships, hierarchies, and simple calculations. By using DAX formulas, you can enrich your Power Pivot model in multiple ways. 
You’ll learn the principles of DAX through the development of many different types of calculations. You’ll learn how to create calculated columns to compute new values and how to create calculated fields to aggregate data for analysis to measure progress toward goals. 
Although you can explore your model by using pivot tables and pivot charts in Excel, you can use Power View to interactively explore and analyze your data by using a variety of techniques. You’ll learn how to combine multiple data visualizations into a report that you can filter and highlight to understand data patterns. You’ll also learn the necessary optimizations for your data model to ensure a better experience with Power View.Microsoft has added even more functionality to Excel 2013 with Power Query, Power Map, and Power BI Q&A, while at the same time bringing business intelligence to the cloud. 
Last, we’ll review the BI components available in the cloud and contrast functionality with on-premises tools.

Multidimensional vs Tabular: May the Best Model Win

SQL Saturday Slovenia December 13, 2014

Are multidimensional models dead on arrival? Are tabular models the future of analysis? Come to this session to learn the similarities and differences between these two approaches to analytical modeling first introduced in SQL Server 2012 Analysis Services. We’ll explore the pros and cons of each type of model and review how to select the appropriate model to your analytical requirements.

 

SQLSkills Immersion Event – Business Intelligence

Chicago, IL May 4 - May 8, 2015 

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!

 

Building a BI Performance Monitoring Solution

SQL Cruise 2015 Mediterranean, June 14 – June 21, 2015

Users expect business intelligence solutions to quickly deliver answers to their questions. When queries start slowing down, how do you determine the root cause of the problem? Is it the report server, the cube, the query, or server resource contention? Come to this session to learn how to use performance counters, report execution log data, and trace files to troubleshoot performance problems. You’ll also learn how to set up a monitoring solution to capture data for benchmarking purposes before problems arise and for diagnostic purposes when queries start slowing down. You’ll learn how to interpret performance monitoring data so that you can take the necessary steps to resolve performance problems in your BI solution.