Skip to content

Implementing Data Warehouse Patterns with the Microsoft BI Tools – October 14, 2013

September 27, 2013

You must register at https://www.eventbrite.com/event/8537892065 in order to be admitted to the building and attend.

Implementing Data Warehouse Patterns with the Microsoft BI Tools

You’ve read some of the content of well-known Data Warehousing books – now what?  How do you take the structures and disciplines inside such books as the Ralph Kimball series and implement them?  This session will take several of the key concepts in Data Warehousing and demonstrate some implementations using SQL Server Integration Services and Analysis Services.  We’ll look at items such as Type 2 Changing Dimensions, Confirmed Dimensions, Dimension Outriggers, Role-Playing Relationships, Many-to-Many Bridge table relationships, Factless Fact tables, Handling of NULL foreign key values, and more.

Presenter: Kevin S. Goff (http://www.kevinsgoff.net):

–  Microsoft SQL Server MVP

– Database architect/developer/speaker/author

– Regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics

– Frequent speaker at community events in the Mid-Atlantic region.

Date/Time:

10-14-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Microsoft Power BI: Redmond’s BI Stack Goes Mobile and Cloud – September 9, 2013

September 2, 2013

You must register at:  https://www.eventbrite.com/event/8127203685 in order to be admitted to the building and attend.

Microsoft Power BI: Redmond’s BI Stack Goes Mobile and Cloud

Microsoft’s Power BI is a new Office 365 cloud-hosted offering that stacks together Power Pivot, Power View, Power Query (formerly “Data Explorer”) and Power Map (formerly “GeoFlow”) along with SharePoint Online.  Data visualizations are authored in Excel 2013 and can be viewed in a browser, or via tablet apps for Windows 8, Windows RT and even the iPad.

Speaker Andrew Brust, who covers Big Data and analytics for ZDNet and GigaOM Pro, recently published a Pluralsight course, “Excel: An Analytics Superhub,” which covers in-depth the various components that make up Power BI, so his interest in the product was strong even before it was revealed.  To top it off, Andrew was among the first to be invited to preview Power BI and in this session he’ll show you all he’s learned.

Presenter: Andrew J. Brust, Blue Badge Insights

Andrew J. Brust is Founder and CEO of Blue Badge Insights and writes a blog for ZDNet called “Big on Data”. (http://www.zdnet.com/blog/big-data). Blue Badge Insights provides strategy and advisory services to Microsoft customers and partners. The company derives from Andrew’s background in application software development dating back to 1985, and his industry expertise in Microsoft technologies like .NET, SQL Server and Analysis Services. Andrew is co-author of “Programming Microsoft SQL Server 2012” (Microsoft Press); an advisor to NYTECH, the New York Technology Council; serves as Microsoft Regional Director and MVP; is conference co-chair of Visual Studio Live!; and writes Visual Studio Magazine’s “Redmond Review” column.

Date/Time:

9-9-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

SQL 2012 – Building Better BI w. DQS (or Fighting GIGO with Knowledge) – July 8, 2013

June 24, 2013

You must register at: http://www.eventbrite.com/event/7210722465 in order to be admitted to the building and attend.

SQL 2012 – Building Better BI w. DQS (or Fighting GIGO with Knowledge) 

Data Quality challenges were discovered when the first Data Warehouse went into production back in the 1970s. Now, almost 40 years later most DW & BI projects are still plagued by it. GIGO (garbage in – garbage out) is one of the biggest concerns for customers and without a framework for sifting out bad & unreliable data, their confidence in BI systems can be very low.

Data Quality Services (DQS) is a knowledge-driven solution, focusing on creation and maintenance of a Data Quality Knowledge Base (DQKB) that is reused for performing various data quality operations, such as data cleansing and matching. The main concept behind DQS is a rapid, easy-to-deploy, and easy-to-use data quality system that can be set up and used practically in minutes.

In this session we’ll review the fundamentals of DQS and build our own Knowledge Base from scratch. We’ll train this knowledgebase (i.e. use Machine Learning) to discover data in our source systems and create rules and domains to define what the outcome data should look like. We’ll also hook into the cloud to leverage Melissa Address Verification Reference Service. In addition, we’ll see how this knowledgebase can be reused over time with SQL Server Integration Services (SSIS) and expanded by data stewards as new data standards and domains are introduced into the DW.

Presenter: Stanislav Novoseletskiy, Microsoft

Stan is a Principal Platform Specialist for Microsoft’s State & Local Government customers. He specializes in SQL & BI Solutions and it’s his job to ensure customer planning and deploying SQL 2012 see the highest ROI by taking advantage of platform capabilities to address business and technical problems. During his career he’s done everything from computer helpdesk back in 1997 to networking and MS Access development in 1999 to .NET & SQL programming 2000’s. After joining Microsoft in 2006 he’s focused on architecting, deploying and supporting enterprise database solutions as well as delivering data warehousing and BI projects.

Date/Time:

7-8-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Bridging the Chasm: BI Theory vs. Practice – June 10, 2013

May 15, 2013

You must register at: http://www.eventbrite.com/event/6712815211 in order to be admitted to the building and attend.

Bridging the Chasm:  BI Theory vs. Practice

A Dynamic Dialog session: According to research compiled by Gartner from discussions with many BI clients, a substantial disparity exists, in the implementation of BI, between theory (standard approaches, promises, claims and expectations) and practice (shortfalls, compromises and other realities). In this session, Business Intelligence Architect and Microsoft MVP Bill Pearson leads a dialog within which we gain an understanding of the general types of discrepancies between the “ideal” approach to BI and the compromised reality that a large number of organizations experience. We’ll then share and class experiences as a group, and discuss ways to avoid these discrepancies in future projects.

Presenter: William E. Pearson III

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.  Bill is a member of the Boulder BI Brain Trust.

Date/Time:

6-10-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Scalable Analytics Without Intermediation (Can it exist? When?) – May 13, 2013

April 23, 2013

You must register at: http://www.eventbrite.com/event/6401086823  in order to be admitted to the building and attend.

Scalable Analytics Without Intermediation (Can it exist? When?)

The cost of an insight is a function of the data volume, schema complexity and development cycles. The promise of the NoSQL movement was to reduce the barriers to the end users so that the analysis could occur in their hands across all the data. We will ask can a fast, robust and iterative analysis of Big Data exist? Can we generate and test insights? How much of BigData data discovery has been solved and how much more remains?

A veteran of analytics, Goodarzi has lead several teams in designing, building and delivering predictive analytics and business analytical products to a diverse set of industries. Prior to joining 1010data, Goodarzi was the Managing Director of Mortgage at Equifax, responsible for the creation of new data products and supporting analytics to the financial industry. Previously, he lead the development of various classes of predictive models aimed at the mortgage industry during his tenure at Loan Performance (Core Logic). Earlier on he had worked at BlackRock, the research center for NYNEX (present day Verizon) and Norkom Technologies. Goodarzi’s publications span the fields of data mining , data visualization, optimization , and artificial intelligence.

Date/Time:

5-13-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Business Intelligence in SharePoint 2013: Empowering users to change their world – April 8, 2013

March 25, 2013

You must register at: http://www.eventbrite.com/event/5997816631  in order to be admitted to the building and attend. 

Business Intelligence in SharePoint 2013: Empowering users to change their world

Starting in May 2010, with SQL Server 2008 R2, Microsoft began talking more and more about “Personal BI”.  The focus of this discussion was a paradigm shift moving business intelligence from being something a few BI professionals do with a data warehouse to a practice done by Information Workers every day in familiar tools like Microsoft Excel and SharePoint.   Over the course of this session we will show you the improvements that Microsoft has made in the 2013 stack to take this new focus from being a “nice idea” to a truly powerful reality.  We will explore the improvements made to Excel, PowerPivot & Power View, & Reporting Services.  We will explain the underlying technology that makes the new features possible and walk through demos of some of the shinier toys.  At the end of the session you will walk away with a better understanding of what is new in 2013 for business intelligence and an extreme desire to build reusable data model that will undoubtedly bring real value to your business.

Presenter: Jason Himmelstein

Jason Himmelstein, MCTS, MCITP, is the SharePoint Practice Director for Sentri, Inc. and has been working with Microsoft Server technologies since 1998 when he was supporting Motorola in Austin, TX.​ He went to work for the University of Texas for 5 years where he developed expertise in Active Directory and Exchange. He left UT to go on the road doing work for Dell in a partnership with Microsoft doing architecture, design and implementation of Active Directory and Exchange. He started working with SharePoint in 2007 as an Enterprise Architect for Raytheon Company. Today he leads a team of dynamic SharePoint Consultants for Sentri, a four-time Microsoft Partner of the Year.

Jason is the co-author of the upcoming O’Reilly book “Developing Business Intelligence Apps for SharePoint“.

Outside of this crazy working world he is a happily married father of 2 boys and a die-hard Texas Longhorns and San Antonio Spurs fan.

Date/Time:

4-8-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Differences between the SSAS Multidimensional (OLAP) model and the SSAS 2012 Tabular Model – March 11, 2013

February 20, 2013

You must register at: http://www.eventbrite.com/event/5590282686 in order to be admitted to the building and attend. 

Differences between the SSAS Multidimensional (OLAP) model and the SSAS 2012 Tabular Model:

In SQL Server 2012, Microsoft introduced a new Tabular Model in SSAS for creating analytic databases. The question is – how does this model differ from the traditional MOLAP model, and is it better than MOLAP?

In this presentation, I’ll cover the new tabular model with some examples, where the model differs from traditional MOLAP, and I’ll also show instances where one model might be preferable over the other for specific applications.

Presenter: Kevin S. Goff

Kevin S. Goff (http://www.kevinsgoff.net) is a Microsoft SQL Server MVP, SQL Server/Business Intelligence Practice Manager for SetFocus LLC, author of 2 books, regular columnist for CoDe Magazine on .NET, SQL Server, and Business Intelligence topics, and a frequent speaker at community events in the Mid-Atlantic region.

Contact URLhttp://www.KevinSGoff.net

Date/Time:

3-11-2013 6:00 P.M. – 8:30 P.M.

Location:  

Microsoft NYC offices, 1290 Avenue of the Americas, 6th Floor, New York, NY, 10104

Follow

Get every new post delivered to your Inbox.