Event Location:
Microsoft Campus - Las Colinas
7000 State Hwy 161
Irving, Texas
Abstract:
For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at the risk of failure.In this session I will go over some of the basic concepts that are key in understanding BI and DW. I will also go over the natural roadmap towards BI success, its maturity stages and some of the factors that influence a successful BI project. I will exemplify all these concepts by showcasing a successful real-world BI and DW solution.
Speaker(s): Jose Chinchilla,
Abstract:
During this session you will learn how to leverage the Microsoft platform to deliver information to the corporate and at the personal level. We will review SQL Server Reporting Services 2008 R2, SQL Server Analysis Services 2008 R2, SQL Server 2008 R2, SharePoint 2010 and several services like PerformancePoint Services 2010, Excel 2010, and Excel 2010 PowerPivot Add In. The intended audience is for IT and Information Workers who are looking for new ways to leverage the Microsoft platform to deliver information in a concise and meaningful way.
Speaker(s): Forrest Dermid,
Abstract:
This session will pick up where the 1st one left off and continue discussing the basics of SSIS.
Speaker(s): Sean McCown,
Abstract:
Database Normalization and Dimension Modeling are the same but different. Development in today ‘s larger industries require the design and analysis of Online Transaction Processing (OLTP) to take into account Data Warehousing/OLAP (Online Analytical Processing). My transition from Senior DBA to BI Architect at Amedisys has been a process of sanding the rough edges of my passion from fully normalized databases. The Dimensional Modeling started a re-tooling of my mind to look at end result analytics/statistics from smaller and smaller transactions. From previous experience, I know I am not going to get it right the first time. Lessons learned will mold me into a great BI Guy.
Speaker(s): Thomas LeBlanc,
Abstract:
Participants will be shown concepts depicting expanding contextual help for Report Builder 3.0 and beyond and be asked to provide feedback to help us choose between competing designs. Previous customer comments and 2 benchmark tests of RB 3.0 have provided those areas that we think could benefit from this approach which we think might be an alternative to Office Ribbon contextual help. Participants will help us determine future of delivery of on-line and local help with inputs to MSDN and TECH Net for the Business Intelligence products.
Speaker(s): Microsoft Presenter,
Abstract:
Here we’ll talk about different ways to make your packages more supportable. Be it from choosing the right way to deploy them, to choosing the proper security model, or even moving packages between servers. Let’s stop making this so hard on ourselves.
Speaker(s): Sean McCown,
Abstract:
To ensure consistency across data integrated from multiple systems, the application of standard data cleansing routines is a best practice. Examples of data cleansing include translation of NULL values to defaults, trimming string values, and consistent formatting for textual data such as telephone and social security numbers. While these routines can be implemented using standard SSIS components, the resulting logic must be duplicated for each source and column which creates a development and maintenance burden. This session will walk through the process of creating common data cleansing routines in a custom component to enable code reuse with minimal effort across many packages.
Speaker(s): John Welch,
Abstract:
Concept and story board exploration concentrating on Patching and HADR story for SQL 11. There will be a special emphasis on roles and responsibilities and how those might change/improve. Will be looking to participants to provide input on concept and help us to determine success criteria and fit to user work flow.
Speaker(s): Microsoft Presenter,
Abstract:
Participants will work through use cases and other conceptual material to help us determine terminology and need for Impact and Lineage Analysis as well as critical to success metrics.
Speaker(s): Microsoft Presenter,
Abstract:
In this session, we will explore the two scripting tools in SQL Server Integration Services, the Script Task and Script Component. We'll take a tour through each of these tools, learning how they can add flexibility to your SSIS packages. We'll discuss not only how but when and why to write code in SSIS, and will have a number of demos to illustrate.
Speaker(s): Tim Mitchell,
Abstract:
Almost everyone in the business world has Excel, and it is one of the most popular tools for business analysts to use for analyzing data. Excel PivotTables work very well against an Analysis Services data source, and deliver very powerful analytic capabilities. But, as with any tool, it comes with some tradeoffs as well. During this session, we’ll walk through some of the capabilities of Excel PivotTables with OLAP, review the tradeoffs, and explain how you can optimize your OLAP cubes for Excel clients.
Speaker(s): John Welch,
Abstract:
This session will address the things to consider when architecting a large, high-performance relational data warehouse. We’ll discuss strategies for improving ETL and query performance, which frequently conflict with one another. The discussion will touch on partitioning, indexing strategies and pre-aggregation, among other SQL Server 2008 features.
Speaker(s): Erin Welker,
Abstract:
This session will take beginners who know nothing about SSIS and teach them what they need to know to get up and running writing their own packages from scratch.
Speaker(s): Sean McCown,
Abstract:
Rapid-fire visual analysis. Ad hoc query capability. Easy interactive dashboard building. No, this is not going to be an hour of buzzword bingo. This time we will actually deliver on the promise of self service BI. Using SQL in conjunction with a visual analysis tool like Tableau we can help our users find the questions they didn't know they wanted to answer. This session will be demo heavy and will highlight best practices in data visualization and dashboard design.
Speaker(s): Tim Costello,
Abstract:
Participants will be asked to help us sketch out and better understand the process of what a BI project looks like end to end “in the wild”. Emphasis will be on roles, artifacts, business requirements etc. Special emphasis on work flow of dev, test and production and understanding difference between BI professional grade (BIDS) and Power Pivot oriented BI. Participants’ input affects decisions to be made with regard to how tools and functionality for BIDS and the more Power pivot oriented BI products will be built out.
Speaker(s): Microsoft Presenter,
Abstract:
This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks.Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.
Speaker(s): Drew Minkin,
Abstract:
Never hard-code a connection string or file path again! In this session, we'll look at several ways to introduce dynamic logic into your packages by way of the SSIS expression language, package configurations, and variables. Learn how to reuse tasks, components, and containers by replacing static settings with dynamic and flexible properties.
Speaker(s): Tim Mitchell,
Abstract:
Data is the backbone of every business and providing the decision makers with accurate and up-to-date information can go long ways for every organization. With SQL Server being the backbone of Microsoft driven Business Intelligence (BI) Solution we will look at how you can build a BI solution from ground up mashing data from different sources and creating a data model that will streamline your environment data collection while provide a visual dashboard with KPI’s, Scorecard, Reports and Filters and presenting them in a SharePoint 2010 environment.
Speaker(s): Leonard Mwangi,
Abstract:
Demo and Q and A. Participants will be asked to comment on the design, make suggestions particularly as to how they see this fitting into their workflow and environment and how will it be supported by IT?
Speaker(s): Microsoft Presenter,
Abstract:
In this session, we'll explore some of the useful tasks and data flow components of SSIS. Join in as we review the File System Task and the For Each Loop container, as well as data flow components including the Lookup Transformation, the Conditional Split, and the Derived Column. This session will include various demonstrations using SSIS 2008.
Speaker(s): Tim Mitchell,
Abstract:
Introduction to spatial analysis of data using SQL Server 2008. Aspects from spatial data processing to generating actionable information for businesses. Description of projections, implementation in SQL Server 2008, data mashups using mapping services API, spatial analysis with BI stack.
Speaker(s): Ranjan Muttiah,
Abstract:
Group discussion on how participants see interaction between BI IT pros and IWs changing as a result of moving to the cloud. What might “cloudifying” the existing tools look like for IWs and BI IT pros? Participants’ input will be factored into SQL 11 and next gen planning
Speaker(s): Microsoft Presenter,
Abstract:
Beginning SSRS and beyond
Speaker(s): Jennifer McCown,
Abstract:
SQL Reporting Services has become a powerful and flexible tool for delivery of information. What tools and skills are needed to utilize this sytem? In this session I will walk through creating your first report using Microsoft's free Report Builder. We will walk through many examples moving from a basic report expanding to more complex functionality.
Speaker(s): Mark Verret,
Abstract:
This session will show how to use power pivot functionality in SQL Server 2008 R2 to quickly slice and dice data and create self service cubes and also show you how you can share this information with your team
Speaker(s): Sriram Ganapathy,
Abstract:
SQL Server Integration Services (SSIS) and Reporting Services (SSRS) are two pillars of Microsoft's Business Intelligence stack: SSIS gathering the data and SSRS displaying the data. Do you know that SSRS provides a set of Web Services that SSIS can use to manage and even render SSRS reports? In this session we will develop an SSIS package that exports an SSRS report to pdf format using these Web Services. Then we will use the SSRS Web Services in a Data Flow Script Component to get data from a report.
Speaker(s): Russel Loski,
Abstract:
Microsoft SQL Server Analysis Services is the semantic layer in the Microsoft BI technology platform that allows users to see and interact with their information in a faster and more dynamic way compared to static reports. In this event we will take an in-depth look at Analysis Services which provides business users the ability to perform analysis and mine their Data to understand and uncover business issues/drivers leading to better decisions and new business opportunities.
Speaker(s): Anand Pandya,
Abstract:
SQL Server Reporting Services parameter creation and use will be discussed. Aspects such as multi-value parameters, setting default values, and dealing with nulls will be covered.
Speaker(s): David Stein,
Abstract:
The purpose of this class is to provide you the basics of the MDX language and introduce you to the foundational functions you need to know to build solid MDX queries. Participants should bring their laptops with the Adventure Works DW 2008, Adventure Works DW 2008 R2, or MDX Step-by-Step sample Analysis Services databases installed in order to follow along with the instructor-led demonstrations.
Speaker(s): Bryan Smith,
Abstract:
Are you still on SQL Server 2005 and wonder what you are missing? Did you upgrade to SQL Server 2008 and haven’t had the time to check out the new features? In one hour you will see demos that give an overview of the new features for developers included with SQL Server 2008. This presentation will include Management Studio (SSMS) Enhancements, T-SQL enhancements, Table Value Parameters, Merge and more…
Speaker(s): John Sterrett,
Abstract:
Key design issues in desiging the EDW and how to avoild them. For Example, what are the criteria to combine the dimensions or put them saperate, What is the implecation of using RCD (rapidly changing dimensions) etc and how to drive the business value . All these are explained with real world example
Speaker(s): Dr. Suresh Rajappa,
Abstract:
This session will introduce techniques of integrating algorithm output with production data. Example code and lab will use data sets beyond Adventureworks. Topics include: Applying multiple models Developing a scorecarding system Assessing the most effective model Track population stability and algorithm performance over time.
Speaker(s): Drew Minkin,
Abstract:
SQL Azure is SQL Server's relational database as a service offering. SQL Azure can be used as a backend for a number of BI applications. This session will demonstrate how SQL Server Integration Services, SQL Server Reporting Services can be used to connect to a SQL Azure database to build applications that use a dynamic and agile data store. The session will also talk about Microsoft® Codename "Dallas" which is a new service allowing developers and information workers to easily discover, purchase, and manage premium data subscriptions in the Windows Azure platform
Speaker(s): Sriram Ganapathy,
Abstract:
Will demonstrate how to use PowerPivot to dynamically control several different charts as an interactive dashboard. Presenter will also discuss the pitfalls of allowing users access to this new technology
Speaker(s): David Stein,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: http://www.linkedin.com/in/johncwelch/
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: http://www.linkedin.com/in/johncwelch/
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
LinkedIn: http://www.linkedin.com/in/josechinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Sriram Ganapathy is a Senior Technology Specialist with Microsoft Corporation. Sriram has been with Microsoft for 10+ years working on SQL Server, BI and related technologies.
Contact: http://www.ihydroeng.com
Ranjan Muttiah is the president and owner of iHydro Engineering, a company that specializes in the use of spatial data to generate actional information for clients. In addition to consulting experience, Ranjan has held a variety of academic positions with the TCU, Texas AM, and the University of Texas systems.
TBD
LinkedIn: http://www.linkedin.com/profile/view?id=29648544amp;trk=hb_tab_pro_top
Contact: http://Thomas-LeBlanc.com
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop OLTP systems with normalized databases for high-performing T-SQL and dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and is active in the Baton Rouge Analytics and SQL Server User groups, as well as SQLSaturday in Baton Rouge. You can find his blog at TheSmilingDBA.BlogSpot.com and website at Thomas-LeBlanc.com
Erin Welker, a consulting professional whose passion is SQL Server, has worked with the product since version 1.11. She has served as the data warehouse architect on projects for several globally recognized companies. She has also presented on SQL Server topics at several conferences and is the author of various whitepapers, articles, and book chapters on SQL Server and data warehousing.
Contact: http://dataminkin.blogspot.com
Drew Minkin has been a speaker at the MS Business Intelligence Community, North Texas SQL Server User's Group and SQLSaturday events across the country , for four years, He worked at Microsoft in SQL Support and in Premier Field Engineering for over six years. After leaving Microsoft, Drew has designed and supported cubes for dozens of Fortune 1000 companies. he has designed data mining models on pricing optimization, fraud detection, customer retention and marketing campaigns
LinkedIn: https://www.linkedin.com/in/sureshrajappa
Suresh Rajappa is a Principal @ Intellisee Group focusing on Enterprise Performance Management, Big Data, Business Analytics and In-memory computing. He has 20 years of experience in databases and Business intelligence. He holds a PhD in Data Mining and MBA degree in Strategy and Finance. He had spoken in various SQLSaturday sessions across the country.
Contact: http://www.geekswithblogs.net/leonardm
Leonard Mwangi is a Principal Consultant with e Tek Global Inc. concentrating mostly on Information Worker Solutions and applications Integration. Leonard has over 8 years of experience in IT Industry and has been working with SQL Server since SQL 7.0 and SharePoint since SPS with end-to-end client solutions. Leonard is also a regular contributor for MS forums and a presenter at different conferences and Special Interest Groups regarding SQL Server and SharePoint.
TBD
Forrest has been a Sr. BI Technology Specialist for almost 5 years at Microsoft specializing in reporting, analysis, and performance management. Forrest’s professional career spans almost 22 years with ten years in business intelligence software and professional services sales, fourteen years internal and external analytical and application systems consulting experience in all the major US industries. Forrest began his career as an industry accountant primarily in financial reporting, analysis
Mark Verret is the IT Manager for the LSU Highway Safety Research Group. He has over 20 years experience in the IT field. He has worked with SQL Server for the past 12 years implementing Business Intelligence and data warehousing related projects.
Contact: http://dataminkin.blogspot.com
Drew Minkin has been a speaker at the MS Business Intelligence Community, North Texas SQL Server User's Group and SQLSaturday events across the country , for four years, He worked at Microsoft in SQL Support and in Premier Field Engineering for over six years. After leaving Microsoft, Drew has designed and supported cubes for dozens of Fortune 1000 companies. he has designed data mining models on pricing optimization, fraud detection, customer retention and marketing campaigns
TBD
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
TBD
LinkedIn: https://www.linkedin.com/pub/bryan-smith/17/98b/161
Bryan is a Data Solution Specialist with Microsoft Las Colinas, focused on data-driven solutions in the Azure cloud. He also teaches analytics technologies within the MBA amp; MSBA programs at SMU Cox School of Business.
TBD
LinkedIn: http://www.linkedin.com/in/jennifermccown
Contact: http://www.MidnightDBA.com/Jen
Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.
Sriram Ganapathy is a Senior Technology Specialist with Microsoft Corporation. Sriram has been with Microsoft for 10+ years working on SQL Server, BI and related technologies.
Contact: http://johnsterrett.com
John Sterrett is a database administrator at a international law-firm, and is responsible for over 100 instances of SQL Server. John has been active within the SQL Server community, including hosting the first SQLSaturday in West Virginia. John also presented a lightning talk and chalk-talk at the SQL Server 2010 Member Summit, presented sessions at SQLSaturday’s, and the Pittsburgh SQL Server User Group. John is a syndicated blogger at SQLServerPedia and contributes tips at MSSQLTIPS.
TBD
LinkedIn: http://www.linkedin.com/pub/tim-costello/8/b38/a02/
Contact: http://www.timcost.com
Tim Costello is an MCITP, MCTS specializing in etl and data analytics for Interworks Inc. Tim is an international speaker that is always looking for opportunities to share his passion for SQL Server, Tableau and data visualization. Tim is active in the SQL community and leads a data visualization focused user group in the Dallas area.
Contact: http://gnetgroup.wordpress.com
Mr. Pandya is a BI Services Manager with GNet Group in Dallas, TX. Known for his expertise in Information Management strategy and architecture, Anand has managed high performing consulting teams in the acts of creating, selling and delivering market responsive information management solutions.
LinkedIn: http://www.linkedin.com/pub/david-stein/8/ba8/705
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: http://www.linkedin.com/in/russloski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
LinkedIn: http://www.linkedin.com/pub/david-stein/8/ba8/705
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Contact: http://www.midnightdba.com/dbarant
Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.
The following is a list of sponsors that helped fund the event.