March 2017: The Four Levels of Thinking as a Geek Leader

Meeting Date:  Tuesday, March 7, 2017

Topic: The Four Levels of Thinking as a Geek Leader - What HR Doesn’t Tell You About Success

Session Description: As a highly technical expert, you have been successful because of your expert skills. People hire and promote you because of your talent and ability to solve hard problems. This is true. It's also not enough. What no one tells you is that you're only looking at one of the three factors that lead to career success. In this session, you will:

  • Learn the other two factors (and what you should do about them)
  • Learn the four levels of thinking needed to be an expert who leads
  • Assess where you are in each of the areas
  • Identify at least 2 practical things that you can do to improve your influence, get more support for your ideas and projects and gain more respect as a professional

Speaker Bio: Tom started his career as a computer science geek who spent a couple of decades in software and IT initiatives in companies from startups to Fortune 500 companies, leading up to being the VP of Products for a SaaS Big Data software company in the Telecom market. Today Tom is a speaker, trainer and coach helping clients communicate clearly, delegate effectively and manage conflict well. As the father of 7 kids, Tom has had lots of opportunity to fail at leadership, and today he will share about how he had to adjust his thinking as he became a leader of technology experts.

Session Materials: https://brighthillgroup.com/wp-content/uploads/2017/03/FourLevelsofThinkingasaGeekLeader-CBIG2017.pdf


Feb 2017: Use Biml to Automate SSIS Design Patterns

Meeting Date: Feb 7, 2017

Topic: Use Biml to Automate SSIS Design Patterns

Session Description: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

Speaker Bio: Andy Leonard is a Data Philosopher at Enterprise Data & Analytics, an SSIS Trainer, Consultant, developer of the Data Integration Lifecycle Management (DILM) Suite, a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and the Stairway to Integration Services.


Jan 2017: Annual Social Event (aka "Beers and BI")

Join us to celebrate the 4th anniversary of the CBIG group which launched in Jan. 2013.  At this event we'll have casual and fun conversations about BI, data, analytics and get to know each other a little better. 

Location: Taco Mac, 4625 Piedmont Row Drive, Charlotte, NC 28210 (next to Southpark Mall)


December 2016: Effectively Deploying Power BI

Topic: Effectively Deploying Power BI

Abstract: It is generally a mistake to think that simply buying a license and handing it off to users will be enough to enable Self Service BI. Companies are discovering that planning Power BI rollouts are important to realize the expected value. This session will provide an overview of the different roles Power BI can play at an organization, how should teams use it and how to foster and measure adoption.

Presenter: Javier Guillen is a Principal for BlueGranite.  As an active blogger, speaker, and Microsoft community contributor, Javier is particularly interested in SQL Server Analysis Services technology, including Multidimensional and Tabular models, as well as the practical application of MDX and DAX patterns.


November 2016: SQL Server 2016 and PolyBase

Topic:   SQL Server 2016 and PolyBase

Abstract: This session will focus on the brand new SQL Server 2016 feature called PolyBase. PolyBase is a technology that accesses and combines both non-relational and relational data, all from within SQL Server. It allows you to run queries on external data in Hadoop or Azure blob storage. The queries are optimized to push computation to Hadoop. In this session, you will learn how to install and set up PolyBase, and how to use it once you've got it configured.

Presenter: Sean Werick is a principal consultant for Pragmatic Works.  He has been in the data industry for 15 years, focusing on the Microsoft data platform, both on-premises and in the cloud. He has architected, developed and integrated end to end solutions for customers in various sectors including finance, government, health care, and retail. He is extremely passionate about data, data science, and business intelligence. He believes in impacting businesses in a meaningful way through data.


October 2016: Practical PowerShell for SQL & BI Developers

Topic:   Practical PowerShell for SQL & BI Developers

Abstract:  PowerShell is always something you heard about and wanted to use but never did! Starting with the resources available for a PowerShell newbie, we will advance to what pro's use to automate their database activities and beyond, for both DBA's and developers. The goal of this session is to get you immersed in PowerShell. Ask questions and learn how PowerShell can enable you and more importantly do your job for you (the way, future is heading). We will also look at free libraries and tools to help you advance your automation abilities. Common automation scenarios is the theme! Anything done with clicks can be automated.

PresenterJana Sattainathan works as a Senior Oracle and SQL Server DBA at SCOR, a leading Reinsurance company in the world. He has spent most of his professional life around databases. At work, he has automated most aspects of his job using PowerShell. Most recently, he created PowerPump, a “PowerShell Database Copy Server” for his company to copy 50 billion rows (>20 TB,) from 4000+ of Oracle/SQL Server tables on a recurring basis to SQL Server targets for migration/testing.


September 2016: SSAS Aggregation Overview

Topic:   SSAS Aggregation Overview

Abstract:  The presentation will start with overview of the SSAS object hierarchy: DB,Cube, Measure Groups, Dimensions, Partitions.  Aggregations will be introduced next with an overview, their design, impact on query performance and processing times.  Relationship to Measure Groups and Dimensions will be covered next followed by aggregation invalidation and processing options.   The presentation will finish with the topic of detecting both missing and unused aggregation as well as some advanced concepts around the use of "Process Default" options with partially invalidated aggregations. Q&A will be handled throughout the session. 

Presenter: Constantin Ivanov graduated with triple Major in Accounting, Finance, and Computer Science.  He achieved his MSCD and MSCE certifications back in 1995; later on, he added MCDBA, and MCT.  For 15 years, he worked for Microsoft as a Software Architect.  During that time, he participated in over 400 MS SQL Performance Tuning Labs and assisted the MS SQL Product group with enhancing the products. He also delivered BI training as well as assisted ISV's with designing and implementing their products.  After Microsoft, Constantin worked for three years as a Principal BI Architect for  JDA. During that time he designed large scale SSAS cube implementation.   He is also the co-founder of the Charlotte-local BI company: Enterprise Software Solutions.  He also has a very strong expertise in .Net/C# and HTML5/JScript. 


August 2016: Panel Discussion

Topic:   Panel discussion: Time to re-assess your BI & Analytics investment?

Abstract:  Business intelligence & Analytics (BI&A) programs includes people, skills, processes, metrics, technologies and other components. With all these moving parts and an ever-changing technology landscape, the architecture, along with the processes and skills needed to support it, would need to evolve.

But are they evolving? How can we assess the performance of our investment in BI&A? How can we identify gaps and addressed them?

Join us in this panel discussion with leading professionals from well-known companies across the region to address these and other related topics you may have. 


July 2016: How to Define a Big Data Project

Topic:   How to define a Big Data project – A practical use case

Abstract: If you have been around technology for more than a few years, you would probably have seeing the term Big Data spreading like a forest fire to pretty much everything. By know, you already understand the basic concepts, but is it really all Big Data when you define a project or a technology need? 
On this presentation you are going to see a practical use case, the way it was thought out and designed and its implementation. It will also be time for an open discussion on the subject.   

Presenter: Hugo Carreras is the principal and founder of HCT International www.hctint.com. He has over thirty years of information technology and management experience specialized on Data Management, Data Warehouse, BI, Analytics and Big Data. Hugo served Fortune 500 organizations in several industries, including finance, transportation, telecommunications, public sector, and manufacturing. Hugo obtained a Master degree in Computer Science from the University of Miami, Florida and a MS and BS degree in Information Systems at University of Belgrano, Buenos Aires. He graduated at Harvard Management School Executive Program. He is also is a certified project management professional, PMP. 


June 2016: Building Blocks of Cortana Intelligence Suite in Azure

Topic:   Building Blocks of Cortana Intelligence Suite in Azure

Abstract: Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. Expertise required for implementation of each component will be covered as well. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

Presenter:  Melissa Coates is a business intelligence developer based in Charlotte, NC. As a solution architect with BlueGranite, she specializes in delivering BI and data warehousing solutions using corporate and self-service BI tools. Formerly a CPA, Melissa is ridiculously proud to be an IT geek and downright giddy to be a SQL Server MVP. When Melissa steps away from the laptop, you can probably find her hanging out with her border collie on a paddle board. Melissa blogs at sqlchick.com.

Session materials: http://www.sqlchick.com/presentations/


May 2016: SQL Server 2016 Business Intelligence

Topic:   SQL Server 2016 Business Intelligence:  What's New?

Abstract: With SQL Server 2016, you are going to fall in love with SQL Server Reporting Services (SSRS) all over again. If you never liked SSRS, now is the time to give it a second chance! Enhancements include support for modern browsers, mobile reports, KPIs, new SSRS web portal plus a LOT more.   Along with SSRS, other BI products in SQL Server 2016 have evolved significantly.  SQL Server 2016 truly offers a comprehensive, on-premises, enterprise-ready BI platform that will help you to transform complex data into actionable insights.

In this session, we will explore the enhancements that make SQL Server Reporting Services great again. We will also explore key enhancements on SQL Server Analysis Services (SSAS) Tabular model.  Additionally, we will take a look at the improved toolset for BI solution development and administration.   For a complete list of all the new features in SQL Server 2016, refer - https://msdn.microsoft.com/en-us/library/bb500435.aspx

Presenter:  Sajas Salahuddeen works for Microsoft Corporation. In his role as a Premier Field Engineer, he provides proactive and reactive support to Microsoft Premier customers on SQL Server products.  He loves working on all the products in the SQL Server product stack and is equally comfortable troubleshooting SQL performance issues, implementing High Availability & Disaster Recovery using SQL Server Always On or building compelling data models & insights using the BI products.


April 2016: The BI Platform Tree of Life
 

Topic:   The BI Platform Tree of Life: How a greater understanding of your IT landscape can sweeten the fruits of your labor.

Abstract: As a BI Professional, are you aware of the segments of your infrastructure that underpin your development/analysis? Have you ever wondered if there are improvements that can be made in order to ensure that the results of your efforts are reflective of the true body of work capable of environment in which you work? These issues exist within not only internal IT departments but for those working on independent projects that want to ensure top performance for their clients.

In this session we will discuss how each of the components of IT infrastructure ultimate impacts how the tools within the BI platform can perform. We will also discuss how your awareness of these components and the various configurations available can empower you to contribute more to the efforts of the respective IT team. Doing so will ensure peak performance of the end product and present a tangible value add from a personal development perspective, whether you are responsible for ETL, BI Semantic Model development, or Reporting.

Presenter:  Bryan Maynard is a Microsoft SQL Server Database Administrator and Business Intelligence Developer. He started working with the SQL Server product in 2003 as a data analyst when his company at the time was just upgrading from SQL 7 to SQL Server 2000 and has not let it go since.  He currently holds an active MCSA certification, with the ambition of completing my MCSE in both BI and the Data Platform in 2016.


February 2016: Top 5 Tricks to Optimize Excel Query in SSAS

Topic: Top 5 Tricks to Optimize Excel Query in SSAS

Abstract:   After developing a cube, a BI developer may assume users will do their best to query it efficiently.   In reality, users may end up creating highly inefficient pivot tables, triggering complaints the technology did not deliver in its promise of speedy reporting.

This session will provide an overview of useful techniques designed to optimize Excel pivot table performance against Tabular models.  These techniques can enhance the user experience and provide a way to better align with user expectations.

Presenter: Javier Guillen architects, develops and delivers Business Analytics solutions with a strong adherence to best practice patterns. His main focus is dimensional modeling, SQL Server Analysis Services, MDX & DAX, PowerPivot, Tableau, Data Science, R and Hadoop. Javier is the co-founder and co-organizer of the Charlotte Business Intelligence user Group (CBIG), as well as BI blogger, speaker and forum contributor.

Presentation Materials


January 2016:  3rd Annual Anniversary Celebration

Location:  Olde Mecklenburg Brewery

Theme:  Beers & BI!  Join us to celebrate CBIG's THREE year anniversary!  To celebrate, join your fellow BI peers for some casual conversation about BI, data, analytics and whatever else is on your mind!  We call this "Beers and BI" but you don't have to drink beer!  CBIG will provide some light appetizers and 2 drink tickets for each person.


December 2015

Topic:  SQL Server 2016 On-Premises Business Intelligence Tool New Features

Speaker:   Jessica Moss

Business intelligence developers and users everywhere are happily anticipating new updates to the on-premises business intelligence tools for SQL Server.  With the full release of SQL Server 2016 around the corner, Microsoft has released several preview versions of the on-premises tools.  Based on these previews, we can expect to see updates in Reporting Services, such as customizable parameters, mobile reports, and new chart types.  Integration Services also boasts new changes, such as incremental package deployment, better error handling, and new logging levels.  Finally, Analysis Services has additional features, including new DAX functions and extended event viewing.  This session will cover these new items and more in an interactive and demo-heavy presentation.

Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server business intelligence.  Jessica's expertise includes data warehouse modeling, Integration Services ETLs, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their business intelligence solutions.  Jessica enjoys sharing her knowledge across the world, speaks regularly at user groups, code camps, and conferences, and has co-authored numerous technical books.  You can read more on her website:  www.jessicammoss.com.


November 2015

Presentation Topic:  The need of Emotional Intelligence (EI) in Business Intelligence (BI)
Speaker:  Javier Guillen  

Abstract: As new technology cycles emerge, we find ourselves immersed in a growing diversity of tools and infrastructures.  However, success in Business Intelligence sometimes depends less on engineering sophistication and more in our capacity to increase adoption. Realizing the two are not always correlated is key.  Too often we see adoption issues that account for partial or complete failure on expensive BI programs. In this presentation, attendees will learn about a perspective that can help increase chances of BI success by increasing trust and collaboration among I.T. and the business.

Javier Guilllen architects, develops and delivers Business Analytics solutions with a strong adherence to best practice patterns. His main focus is dimensional modeling, SQL Server Analysis Services, MDX & DAX, PowerPivot, Tableau, Data Science, R and Hadoop. Javier is the co-founder and co-organizer of the Charlotte Business Intelligence user Group (CBIG), as well as BI blogger, speaker and forum contributor.

 

August 2015

Presentation Topic:   Exploring Power BI and Cortana Analytics Suite
Speaker:  Jen Underwood

In this session, we will dive deeper into the recent Power BI and Cortana Analytics Suite announcements. We will introduce Cortana Analytics Suite and then dig into the Power BI cloud, Power BI Desktop, Developer APIs, D3.js custom data visualizations and many other areas.  The latest Power BI enhancements were influenced by over 500,000 unique users from 45,000 companies across 185 countries that participated in the global preview. These technologies are gaining market momentum. Please join me in this not-to-miss session to enjoy an open conversation on where Power BI is heading and see a few “bleeding edge” demos.

Jen Underwood is a a Microsoft Sr Program Manager of Business Intelligence & Analytics.   She works with external groups, customers, channel partners, MVP's, BI professionals and application developers to better connect the outside world to engineering.  She also held roles as an Enterprise Data Platform Specialist and a Business Intelligence Consultant for Big 4 system integration firms.  Throughout most of her 20 year career, she has been researching, designing and implementing data warehousing, business intelligence and predictive analytics solutions.  


July 2015

Presentation Topic:  SSIS Data Flow Performance Patterns
Speaker:   Andy Leonard

Use these patterns to improve SSIS 2014 Data Flow performance in your data integration enterprise: Incremental Loads, Blob Pyramid, and Type 2 New + Updated Rows.

Andy Leonard is Chief Servant Officer of Linchpin People, an SSIS Trainer and Consultant, SQL Server database and Integration Services developer, SQL Server data warehouse developer, community mentor, blogger, and engineer. He is a co-author of SSIS Design Patterns and Managing Geeks. His background includes VB and web application architecture and development; and SQL Server 2000-2014.


June 2015

Spotlight Sponsor:  SQLSentry

Presentation Topic:    Why Choose Hadoop?
Speaker:  Kevin Goode

Presentation Slides/Materials

This session will present Inmar's implementation of the Lambda architecture and how Hadoop and NoSQL are core components to providing real-time analytics to a data driven enterprise.  Inmar processes 2.3 billion coupons, 700 million pharmacy claims and 525 million returned goods annually for over 100,000 retail locations and 9000 manufacturers. In 2012, we made the strategic decision to hire a leading data scientist and use our transactional data across all lines of business to perform analytics and generate new data products in order to become strategic partners with our clients. This session covers the technologies and vendors we evaluated, our current architecture and why we selected each component. The presentation will also cover Inmar's implementation of the Lambda architecture, what worked and didn't work for us and where we are going next.

Kevin Goode is the Director of Platform Engineering at Inmar. He has 19 years of IT experience; 17 years of which has been focused on relational databases and the past 3 years have been focused on Big Data, Hadoop and NoSQL. He has worked in many industries including manufacturing, distribution and logistics, financial services, IT outsourcing and has worked for several fortune 500 companies.


May 2015

Spotlight Sponsor:  Intellinet

Presentation Topic:  Continuous Delivery for Data Warehouses & Marts
Speaker:  John Welch

Presentation Slides/Materials

Most data warehouses are in a constant state of flux. There are new requirements coming in from the business, updates and improvements to be made to existing data and structures, and new initiatives that drive new data requirements. How do you manage the complexity of keeping up with the changes and delivering new features to your business users in a timely manner, while maintaining high quality? Continuous delivery is an approach for managing this. It focuses on automation of many steps in the process, so that time is spent on adding new functionality, rather than repetitive steps. Attend this session and learn how Continuous Delivery can be applied to your data projects.

John Welch works at Pragmatic Works, where he manages the development of a suite of BI products that make developing, managing, and documenting BI solutions easier. John has been working with business intelligence and data warehousing technologies since 2001, with a focus on Microsoft products in heterogeneous environments. He is a Microsoft Most Valued Professional (MVP), author, and a frequent presenter on SQL Server BI topics. He also contributes to several open source projects, including SsisUnit, a unit testing tool for SSIS.


April 2015

Date:   Tuesday, April 7, 2015

Time:  5:30 pm to 7:30 pm

Spotlight Sponsor:  BlueGranite

Presentation Topic:  Securing the ETL Pipeline
Speaker:  Brian Kelly

We're going to look at typical ETL (Extract, Transform, Load) pipelines and consider the weak points an attacker might go after. Our goal in this isn't to cause FUD (Fear, Uncertainty, and Doubt), but to discuss risks at each point, options for protecting the vulnerability, and what we've seen typically done (if anything). While this talk primarily focuses on Microsoft SQL Server, especially the database engine and SSIS, many of the points covered will be applicable to any solution set.

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as a database administrator/ architect but has also worked as a infrastructure and security architect and incident response team lead.


March 2015

Date:   Tuesday, March 3, 2015

Time:  5:30 pm to 7:30 pm

Presentation Topic:  PowerBI as a Self-Service Platform

Power BI as a Self-Service BI Platform: Architecture, Use Cases, Strengths, and Shortcomings

Power BI is Microsoft’s newest solution to facilitate self-service business intelligence. In this session we will discuss which components of Power BI are associated with the cloud, Office 365, SharePoint on-premises, Excel, and the newly released Power BI Designer. Along with several demonstrations, we will discuss various ways Power BI can fit into an organization’s data delivery platform.

Melissa Coates is a Business Intelligence developer based in Charlotte, NC.  As a Solution Architect with BlueGranite, she specializes in delivering BI and Data Warehousing solutions using Corporate and Self-Service BI tools.  Formerly a CPA, Melissa is ridiculously proud to be an IT geek and downright giddy to be a SQL Server MVP.  When Melissa steps away from the laptop, you can probably find her hanging out with her border collie.  Melissa blogs at sqlchick.com.


February 2015:  Power Query: End Users and ETL Developers' Hug Day

Presentation Topic: Power Query:  End Users and ETL Developers' Hug Day

Speaker:  Rafael Salas  

Due to its complexity and rigid development cycles, traditional ETL processes are a costly element of information centric solutions. In many cases, end users grow in frustration as they are forced to wait for IT teams they know are "too slow", and processes that "miss the mark." Meanwhile, IT is battling what they perceive as an "unreasonable" number of requests coming from business users. IT and business don't look each other in the eye anymore.

This session will help address those concerns. You will learn how Power Query can be easily used to empower business users when discovering, combining, refining and publishing data while allowing IT to leverage self-service tools that fit in their overall architecture portfolio. We will use Power Query to show how business users can solve complex data  integration challenges that traditionally rely on IT driven technologies in a way that is intuitive and effective. As a bonus, you may get a free hug from a developer or an end user


January 2015:  Annual Anniversary Celebration

Location:  Dilworth Neighborhood Grille

Date:   Tuesday, January 20th

Theme:  Beers & BI!  Join us to celebrate CBIG's two year anniversary!  To celebrate, join your fellow BI peers for some casual conversation about BI, data, analytics and whatever else is on your mind!  We call this "Beers and BI" but you don't have to drink beer!  CBIG will provide some light appetizers and 2 drink tickets for each person.


December 2014

Speaker:  Justin Randall.  Justin is the Director of Professional Services at SQL Sentry, located in Charlotte, NC. With the perspective of nearly 30 years of data management experience, Justin leads a team that provides customers with mentoring, consulting and training services focused on SQL Server performance troubleshooting and optimization using SQL Sentry software. 

Presentation Topic:  Building Your Yellow Brick Road: Directing Your Path to a Successful Career.  

Presentation Description:  Most of us began our technology career through a combination of education, experience, and opportunity. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.


November 2014

Speaker:  Joe Dib is passionate about data! He spent his career, so far, manipulating data, working with databases, leading projects and managing (really mentoring) people. Joe has worked on all phases of Business Intelligence (BI) and Data Warehousing (DW) life cycle. He enjoys speaking (and teaching) on DW/BI strategic level topics as well as covering deep technical solutions. He has used various database platforms, many design methodologies, and different business intelligence tools.

Presentation Topic:  The Data Management Discipline (with a Focus on Data Warehousing).  We begin this session with a very brief yet important framework for data management. Then we explore the different aspects of the enterprise data management discipline. Finally, we delve into the different methodologies to design a data warehouse. We will talk about the Kimball, Inmon, & Data Vault methodologies. This is a high level conceptual talk (no coding) designed to help both developers and non-technical individuals to understand data management, data warehousing, and Business Intelligence disciplines. 

October 2014

No meeting in October due to SQL Saturday in Charlotte, sponsored by CBIG.


September 2014

Derrick Exum.jpg

Speaker:  Derrick Exum is a SQL Server and .NET enthusiast who enjoys learning from colleagues and industry leaders. Derrick is a Senior BI/ETL Developer at Sonic Automotive in Charlotte, a position he has held since 2011. He works on DW/BI projects and, since early 2013, has been working extensively with MDS and MDM. When not learning about Microsoft technologies, Derrick spends his time attending Butler HS football games and learning the piano.

Presentation Topic:  From MDM to MDS.  Have you ever wondered what MDM stands for and why you would use MDS?  Master Data Services is Microsoft's solution for a Master Data Management platform. This presentation will highlight a journey to MDM through MDS. It will touch upon:

  • Brief overview of Master Data Management (MDM)
  • What is Master Data Services (MDS)
  • Installation and Configuration of MDS
  • Gotchas to be aware of during installation
  • Useful system views created by MDS
  • Staging data best practices in MDS
  • Usage patterns for MDS

August 2014

Speaker #1:  Bill Carroll is a Sr. Escalation Engineer for Microsoft. He has worked for Microsoft for 15 years in Charlotte in the commercial support area. His primary expertise is Microsoft SQL Server, but has recently moved to supporting Microsoft’s Azure HDInsight (Hadoop) and Azure Machine learning. In his free time he enjoys the beach and watching moves with his wife and two daughters. 

Presentation Topic #1:  Introduction to Microsoft Azure Machine Learning.  This session will be an overview of Microsoft Azure Machine Learning also referred to as Azure ML (http://azure.microsoft.com/en-us/services/machine-learning/). Azure ML is currently in preview mode and provides data scientists with powerful cloud-based predictive analytics. In the session we will define some basic machine learning terms and attempt to predict survey results using Azure ML. We will show how to access training and test data and build experiments in Azure ML studio from a web browser. We will discuss the training, scoring, and evaluation of the model. We will then publish the model as a web service and attempt get a prediction from the web service from a C# application.

Speaker #2:  Leveat Ruse.  I currently develop effective recruitment strategies at MDI Group to attract top talent at all levels of an organization. I am an IBM certified trainer and began my career performance general Human Resources duties. I quickly worked my way up through the ranks to Business Development. My desire is to interact with others and help people achieve their goals and find the right career path.

Presentation Topic #2:  Building a Compelling IT Resume. In this session we will discuss tips and best practices to get activity from your resume.


July 2014

PatrickKeisler_80x83.png

Speaker:  Patrick Keisler.  I'm a husband, a father, an Atlanta Braves fan, and oh yeah...I'm also a Microsoft SQL Server database administrator for a major investment bank, Wells Fargo Securities.  I have over 10 years of DBA experience and have gained considerable knowledge in SQL Server by supporting hundreds of applications ranging from high-volume trading applications to large data warehouses.

Presentation Topic:  Columnstore Indexes.  Have you heard about columnstore indexes? Maybe you've read about it, but not yet tested it? If you're developing or managing data warehouses, then the columnstore index is the biggest turbo button you'll ever get for your current hardware. Learn how SQL Server stores the data differently and how it uses new access patterns to retrieve data at blazing speeds. You'll see the difference between clustered and non-clustered columnstore indexes as well as the advantages and disadvantages of both.


June 2014

Speaker:  Shannon Lowder is a database architect and consultant with 14 years of experience in Microsoft SQL Server administration, performance tuning, and development. He specializes in designing highly available platforms and scalable data warehousing solutions including cloud-based solutions such as Microsoft Azure. In addition, he is well-versed in mentoring both DBAs and developers with respect to Microsoft technologies with regards to the day-to-day operational demands of small and mid-market companies and ensuring they are developing and instituting sound disaster recovery practices.

Presentation Topic:  Manage Your SSIS Packages with PowerShell.  We’ve all built ETL frameworks, and we’ve all learned things along the way that make them better.  So we have to go back and open all of those packages and update them so we keep them all following our standard.  That takes time, time we don’t have to spend.  Recently I’ve discovered SQLPSX, a set of modules for PowerShell that make it much easier to manage your frameworks.  From auditing your packages to get a list of all the variables used in all of your packages, to adding connection strings and executables, all this and more is now possible via PowerShell.  I’ll introduce you to the modules, as well as some of the problems I’ve hit along the way.  I even have something for those of you looking for a unit testing framework for SSIS.

Slides:  Manage Your ETL Framework with PowerShell


May 2014

Speaker:  Rafael Salas is a recognized speaker and published author with more than 15 years of experience in Business Intelligence and Information Architecture. He is the recipient of multiple industry recognitions, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

Presentation Topic:   ETL: Avoiding Costly Mistakes. In this session we will review a list of common costly mistakes we make when designing and building ETL and data integration processes. We will also look at actionable recommendations to avoid these mistakes. 

You will get a checklist that you can use in your projects to ensure that the ETL processes include the capabilities that a solid data integration subsystem should have. After this session, you will be better prepared to assess the reliability of ETL solutions.


April 2014

Speaker:  Javier Guillen is a Solutions Architect for BlueGranite.  As an active blogger, speaker, and Microsoft community contributor, Javier is particularly interested in SQL Server Analysis Services technology, including Multidimensional and Tabular models, as well as the practical application of MDX and DAX patterns.

Presentation Topic:  Business Insight Through Cloud-Based Data Models. It is common for power users and data scientists to start mocking up their analysis in Excel.  As their reporting grows in sophistication, however, it is important to understand the options available to enable increasingly robust analytical capabilities without incurring high infrastructure costs during experimentation phases.

This session will explore promotion paths for Power Pivot models that mature to demand robust data transformations, as well as cleansing and master data procedures.  You will learn the pros and cons of using cloud-based Power Pivot environments, as well as the recommended architectures for model growth.

Slides: Business Insight Through Cloud-Based Data Models


March 2014

BradLlewellyn_100x100.jpg

Speaker:  Brad Llewellyn is a Statistician, Data Miner, and Visualizations Expert for Mariner in Charlotte, NC. Brad enjoys his role as a consultant and loves the challenges it brings each day. He hopes to help bring Mariner and all of its clients fully into the world of Predictive Analytics.

Presentation Topic:  Data Mining with Excel and SQL Server Analysis Services.  Brad will discuss how to use Excel and SQL Server Analysis Services to uncover hidden information within your data.  Want to know which customers are going to buy your new product?  How about forecasting next year’s revenue?  You could even improve market share by improving upselling and cross-selling opportunities.  It’s all here, and much more.


February 2014

LetronBrantley.jpg

Speaker:  Letron Brantley.   SQL Server/OLAP Developer for Bank of America.  Letron is passionate about everything BI, has 15 years of IT experience, and holds an MCITP certification.  Letron is an active musician playing Sax and Bass, and is married with three wonderful kids.

Presentation Topic:  SQL Server 2012: Multidimensional vs. Tabular Model. Microsoft has given us two distinct models to choose from when creating solutions in SSAS.  There is the familiar Multidimensional model and the new Tabular model which was introduced in SQL Server 2012.  How do you know which one to choose?  Is one better than the other?  In this session we will attempt to answer these questions and discuss what we know about the future of Analysis Services.

Slides:  Multidimensional vs Tabular


January 2014

Social event at Duckworth's Grill and Tavern to celebrate CBIG's one year anniversary.


December 2013

BradLlewellyn_100x100.jpg

SQLShot Speaker:  Brad Llewellyn is a Statistician, Data Miner, and Visualizations Expert for Mariner in Charlotte, NC. Brad enjoys his role as a consultant and loves the challenges it brings each day. He hopes to help bring Mariner and all of its clients fully into the world of Predictive Analytics.

Short "SQL Shot" Presentation:  Gaining More Insight out of Your Dashboards through Best Practices.  Brad will talk about a few simple ways to ramp up your analyses by applying best practices to your dashboards. 

DanniOrtman_83x100.png

Speaker:  Danni Ortman began her technical career as a trainer in Dayton, Ohio in 1992 then transitioned to a SQL Server consultant working on SQL 4.21, 6.0, and 6.5.  Danni started at Microsoft a few months before the SQL Server 7.0 release as a pre-sales technical resource specializing in BI and Data Warehousing covering the states of MI, OH, and KY. Since that time, Danni moved to many roles within Microsoft including account manager, account technology strategist, and productivity specialist for the retail/hospitality industry.  Danni relocated from Microsoft Cincinnati to Microsoft Charlotte in April of 2013 to undertake the challenging pre-sales technical role for the Carolina’s specializing in BI and Data Warehousing.  

Main Presentation Topic:  Power BI for Office 365.  Don’t just review the marketing slides on the internet, come see the products live.  With the newly released ‘Power BI’ for Office 365, Microsoft is providing everyone with powerful new ways to work with data in Excel and Office 365. Easily search, discover, and access data within and outside your organization and, with just a few clicks, shape and transform data. Analyze and create stunning interactive visualizations that uncover hidden insights to share and collaborate from anywhere, on any device.  During this session we will review the products that comprise the Power BI stack with demos and details on use cases for each product.

Slides:  Power BI for Office 365


November 2013

AndyIsley_90x105.png

Speaker:  Andy Isley, BI Practice Manager for Scalability Experts.  Andy has 18 years of experience designing, managing and implementing data warehouses.  He has implemented data warehouses from small 5 GB to 100's TB.  His primary focus is business requirements, dimensional modeling, technical architecture designs, ETL design and implementation, reporting and analytics, and production support. Andy is a certified PDW instructor.  Andy has helped the MS COE develop best practices for implementing PDW.

Presentation Topic:  Is PDW Right for Your Organization? Microsoft has just released its latest version of PDW (Parallel Data Warehouse).  Many people have heard of it but few understand what it s or how they can benefit from it.  In this session we will discuss:

  • What is PDW?
  • How do you know if you need it? 
  • What benefits will it provide to a BI solution? 

This session will provide real world examples free of marketing hype.


October 2013

 

PASS Summit Preview Night

 

OrganizerPic_Jason.jpg

Jason Thomas:   Visualizing John Snow's Cholera Map Using Microsoft BI   Back in 1854, London was developing into one of the world's first modern cities, although without the essential sanitary infrastructures. This along with the increase in population made it the perfect breeding ground for many diseases, such as cholera. Around the same time, physician John Snow explored the correlation between diseases and contaminated water supplies and came up with one of the most famous maps in history. Relive the adventure of John Snow as we follow his journey in this session using Microsoft BI tools. As we recreate his map, we’ll also talk about the steps and best practices for exploring geospatial data.  

CoatesMelissa_2013_headshot.png

Melissa Coates:  So You Want to Be a Rockstar Report Developer? 

Don't settle for being an average report developer. We'll walk through the process end-to-end while discussing tips and best practices for SQL Server Reporting Services requirements gathering, development, deployment, testing, standardization, and documentation.  We will review techniques to increase report maintainability as well as save you time.

Audience participation and sharing of experiences is encouraged as we cover choices you have for data sets, sorting, grouping, filtering, calculations, parameters, deployment, and delivery. This session will focus primarily on SSRS 2012, although some concepts may apply to other BI tools as well. Join us for this session and take your reporting skills to the next level.

OrganizerPic_Rafael.png

Rafael Salas:  Self-Service ETL and Power Query: Are We There Yet?

Have you determined the role that a self-service ETL tool could play in your organization? Self-service business intelligence technologies have gotten a lot of attention in the last few years, and capabilities have grown from data visualization to data discovery and enrichment. Power Query for Excel is Microsoft’s latest move in the self-service data-integration area. A free add-in for Excel 2010 and 2013, Power Query is receiving glowing reviews from BI pros and power users because of its friendly interface and rich capabilities.  

In this session, you’ll learn how Power Query for Excel can be used to discover, combine, and refine data. We’ll also look at some advanced functionality and the language used under the covers – M. After attending this presentation, you’ll be better prepared to support business users, understand how Power Query may fit into your organization’s BI landscape, and address potential risks of misguided implementations.

 


September 2013

DanniOrtman.png

Speaker:  Danni Ortman began her technical career as a trainer in Dayton, Ohio in 1992 then transitioned to a SQL Server consultant working on SQL 4.21, 6.0, and 6.5.  Danni started at Microsoft a few months before the SQL Server 7.0 release as a pre-sales technical resource specializing in BI and Data Warehousing covering the states of MI, OH, and KY. Since that time, Danni moved to many roles within Microsoft including account manager, account technology strategist, and productivity specialist for the retail/hospitality industry.  Danni relocated from Microsoft Cincinnati to Microsoft Charlotte in April of 2013 to undertake the challenging pre-sales technical role for the Carolina’s specializing in BI and Data Warehousing.  

Short Presentation Topic:  Power BI for Office 365

Short Presentation Description:  In July of 2013 Microsoft Announced Power BI for Office 365 which provides everyone with powerful new ways to work with data in Excel and Office 365. In this quick overview we will review the list of Power BI products with an explanation of uses as well as resources to find additional information.

Presentation Materials:  Power BI for Office 365

BenDeBow.jpg

Speaker:  Ben DeBow is a consultant who works with customers of all sizes on their mission critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also an MCDBA, MCSE, and MCITP. He is also the co-founder of SQLHA with Allan Hirt, and can be reached at http://www.sqlha.com.

Main Presentation Topic:  Developing Your Indexing Strategy

Main Presentation Description:  With rare exceptions, all databases have data that is accessed by users. The old adage “time is money” applies here – the sooner the user gets his or her results, the better. A key aspect of improving the performance of a query is ensuring that you have the right indexes on each table. Do you need a clustered index? Where will a covering index be appropriate? Do you even need an index at all for a small table? Could a columnstore index benefit my workload? Every indexing strategy is not only based on the right balance of indexes, but also knowing the code/schema and how people use the application to ensure that it is adjusted as things change over time. This session will cover the fundamentals of how to build an indexing strategy for your tables that will work today, tomorrow, and long into the future.

Presentation Materials:  Developing Your Indexing Strategy


August 2013

SteveWake.jpg

Speaker:  Steve Wake is a Sr. BI Consultant at Pragmatic Works with more than 20 years of experience in various IT organizations. Steve is a Microsoft Certified Professional with an MCSE in SQL Server 2012 Business Intelligence and MCITP in SQL Server 2008 Business Intelligence. Steve has experience in Manufacturing, Retail, Charities, Telecommunications and Financial Services organizations & switched to consulting to share/expand/teach on his experiences with Microsoft Business Intelligence. Steve is also very involved in the local community, speaking at events across the country and is currently President of the Denver SQL Server User Group. Steve blogs regularly at http://blog.wakebi.com  and is on Twitter @stevewake, LinkedIn and Google+.

Presentation Topic:  Capture Change and Apply it with Change Data Capture & SSIS

Presentation Description:  Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database, Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server & SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.

Presentation Materials:  Steve's Blog

 


July 2013

KatherineFraser.jpg

Speaker:  Katherine Fraser has been working in the IT field since 1995, focusing on database modeling and development in multiple domains such as financial services, manufacturing, and logistics. In her current position as a BI technical fellow, she helps different product groups in her company design and build data stores and reports, analyze information and visualize data. Katherine has a Masters degree in Information Systems and has a weird passion for data storage and retrieval.  She is also co-leader for the Triad PASS BI chapter.

Presentation Topic:  Are Pie Charts Always Evil?  Information Design for Excel.

Presentation Description:  You just imported 5 million rows into PowerPivot. Now how do you make it look great in Excel 2013?  We'll look at the different chart types and visualization options, including Power View, and talk about how to use them effectively.  Following the recommendations of Edward Tufte, we'll build sample data views that achieve "graphic excellence" and avoid "chartjunk."  Learn how to choose the best chart type for your data, create hierarchies to enable aggregation, utilize cards and tiles and integrate images.  This session is all about using Excel to clearly display complex, multivariate data.

Slides:   Data Visualizations In Excel

Infographic Examples:  AAA Travel Forecast

                                     Easel.ly template

                                     Healthcare Literacy

                                     Weather Forecast 


June 2013

JulieSmithAndRobVolk.png

Speakers Julie Smith and Rob Volk.  Julie Smith has spent the last 12 years bending data using varied tools such as MS Access, MySQL, and SQL Server 2000-2012. She is a Business Intelligence Consultant at Innovative Architects.  She is an active speaker, blogger and writer in the Microsoft SQL Server Community.   She is one of the co-founders of The Cloverleaf School of Atlanta, which educates elementary aged children with ADHD, High Functioning Autism and other learning differences.  In spite of being a SQL Server MVP, she remains “very simple woman with warm fuzzy secret heart.”   Rob Volk is a database administrator from the Atlanta, Georgia area, having worked in the wireless telecom, utility billing, and credit card processing industries for the past 10 years.  He started using SQL Server with version 6.5 and is very glad to have upgraded since then. He has presented at several SQL Saturdays and user groups. In his spare time he accomplishes more than he does on the job, just don't tell his boss. 

Presentation Topic:  Using Data Explorer + Other Tools for Data Assembly, Cleansing, Organization & Decision-Making

Presentation Description:  In this session we will cover the basics of using Data Explorer + other BI and event management tools using data from the SQL Saturday website.  We will look at lesser-known features like XML feeds, harvesting data from other websites, and social media sources.  We will use Business Intelligence tools such as the new Data Explorer to analyze this data and help guide decisions about speaker & session selection, sponsors, and pre-conference sessions.  Finally, we will look at other free tools like Yammer, Trello, and EventBrite and how they can help organize the details of an event.  If you've ever been frustrated managing an event or project via Excel and e-mail, you'll be pleasantly surprised! 

Slides:  Data Explorer

Excel Spreadsheet:  Data Explorer


May 2013

JoeDib.png

Speaker:  Joe Dib manages the Data Solutions Practice for Cardinal Solutions in Charlotte, NC. He spent his career, so far, manipulating data and working with databases.  Joe has worked on all phases of the Business Intelligence (BI) and Data Warehousing (DW) lifecycle. He enjoys speaking on DW/BI strategic level as well as covering deep technical solutions. Joe is a SQL Server convert. He worked on SQL Server early on in the career, moved on to other database and BI vendor platforms, then rediscovered SQL Server 2008 (and was sold on it!). 

Presentation Topic:  Overview of BI in SQL Server 2012

Presentation Description: A tour of SQL Server 2012 looking at different areas pertinent to Business Intelligence. This is a high level overview with some demonstrations. This session is perfect for managers and/or developers. We will also discuss how Microsoft tools of Excel, SharePoint, and SQL Server form the complete BI offering for self-service BI solutions and/or enterprise-wide BI platform.

Slides:  Overview of BI in SQL Server 2012


April 2013

LetronBrantley.jpg

"SQLShot" from Letron Brantley:  What is Big Data?  The Problem and Opportunity.  What is Hadoop?  How can Hadoop be used in conjunction with SSAS and other BI tools?  Presented by CBIG Member Letron Brantley, SQL Server/OLAP Developer for Bank of America.  Letron is passionate about everything BI, has 15 years of IT experience, and holds an MCITP certification.  Letron is an active musician playing Sax and Bass, and is married to Pamela with two wonderful kids (Jazzmin and Nathan) and one mystery child on the way.  (SQLShot is a 5-15 minute presentation.  Open to any CBIG member who wishes to "take a shot" at speaking.)

Slides:  Big Data / Hadoop / OLAP

 

MelissaAndJavier.png

 Roundtable Discussion Topic:  Corporate BI + Self Service BI: Friends or Foes?

Facilitated By:  Melissa Coates (BI Architect, Intellinet) & Javier Guillén (Senior Consultant, Mariner)

Description: This evening we plan to “step away from the keyboard” and consider a topic which is very relevant to today’s BI initiatives:  the relationship between Corporate BI and Self Service BI.  As companies attempt to find a proper balance between Corporate and Self Service BI, it is important to consider the obstacles, benefits, and solutions to achieve an optimal balance. 

We will review Microsoft's vision for an overall Business Intelligence framework which addresses analytical requests from both ends of the BI spectrum.  We will also discuss concepts in the context of the organization's need for data governance, change management, standardization, training, support, access of unregulated data sources, personal data exploration, among other challenges.

Slides:  Corporate BI + Self Service BI: Friends or Foes? 


March 2013

JorgeSegerra.jpg

Speaker:  Jorge Segarra (aka SQLChicken) is an author, blogger, speaker, SQL Server MVP and community volunteer currently working as a DBA/BI Consultant for Pragmatic Works. Jorge has co-authored on several books including "SQL Server 2012 Bible" and “SQL 2008 Pro Policy-Based Management“. He was also a Redgate Exceptional DBA of the Year 2010 Finalist.

Topic:  What is a BI DBA?  (Business Intelligence Database Administrator)

Description: Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!

Slides:  What is a BI DBA? 


February 2013

BillPearson.png

Speaker:  Bill Pearson, MVP.  Bill created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since.  Bill's background as a CPA, Internal Auditor, Management Accountant and SQL Server MVP (BI) enable him to provide value to clients as a liaison between Accounting / Finance and Information Services.  Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies, and focuses his practice upon the integrated Microsoft business intelligence solution.

Topic:   An Overview of PowerPivot for Excel

Session Description:  In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson explores "Self-Service BI" as a concept.  He then provides a walkthrough of the primary features of PowerPivot, focusing on how we can exploit its capabilities to offer the benefits of BI to decision makes and analysts throughout our organizations.  "There is no service like self-service...."  This session applies equally to SQL Server an Analysis Services 2008, 2008R2, and 2012 Data Sources.  Objectives:  (1) Impact an understanding of Self-Service BI, including the advantages and challenges that accompany its introduction to the enterprise.  (2) Overview of the architecture and uses of PowerPivot for Excel 2010 within the organization to support Self-Service BI.  (3) Explore and demonstrate the assembly of data from diverse sources into models that deliver business intelligence upon demand, including exposure to accessing and relating data, and employing the Data Analysis Expressions (DAX) language, to construct PowerPivot applications that support analysis and reporting throughout the enterprise.

 


January 2013

WayneSnyder.png

Speaker:   Wayne Snyder - Wayne specializes in Business Intelligence Solutions, and is an international speaker, author, and PASS volunteer. He is a SQL Server MVP, co-author of Knight's 24 Hour SQL 2012 SSIS Trainer, and author of the popular Learnkey SQL Server Training series. He is a Distinguished Architect for Mariner (http://www.mariner-usa.com/), who, on the weekend, sings and plays keyboards for the regional band soundbarrier (http://www.soundbarrierband.com/).

Topic:   Information Visualization - What no one ever taught you about charts, graphs, and tables!

Session Description:  This session will provide you with some surprising and interesting insights into how dashboards should be designed. Called Information Visualization, there is a whole line of thinking which maps how the brain interprets what the eyes see. We will translate this into best (and worst) practices related to visualization in dashboard, scorecard, table, and report design. Both funny and informative, you will probably learn, as I did, that you have been designing your dashboards, scorecards and reports badly. We are going to take a visualization test, and learn how to convey information in a clearer, better way. You will be surprised.  Join me - this session is going to be hoot!

Slides:  Information Visualization