SQLSaturday #596 - Denver - BI Edition 2017
Event Date: 02/25/2017 00:00:00
Event Location:
- University Hall - 3rd Floor, University of Denver
- 2197 S. University Blvd
- Denver, Colorado
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: Date Dimension: One Script for All
Abstract: All data warehouses need a date and time dimension to enable proper analysis across time. Most data warehouse designers use one that is provided by tools or create one in Excel. But what if you need to set up custom holidays or want different calendars, such as Fiscal or Julian? You can have any date and time dimension you need by using a single SQL script that can be modified and rerun as necessary. Learn what it takes to design a date and time dimension that does all the calculations and formatting up front so that reports are easier to create. A sample script is provided; it creates the date and time dimensions and can be reused as often as necessary without breaking your data warehouse–and it takes only seconds to run!
Speaker(s):
- Steve Wake
Track and Room: BI Platform Architecture, Development Administration - Small
Title: Practical Data Science using R and SQL
Abstract: The practice of Data Science has arrived and as data professionals we’re on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before. To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session, Jeff Renz will start by providing an introduction to R, the defacto programming language for data scientists. Carlos Bossy will then cover predictive analytics using R, providing a practical understanding of what it takes to develop your own predictive models. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into a BI environment.
Speaker(s):
- Carlos Bossy
Track and Room: Thoughtful Track - Large
Title: Azure Machine Learning: From Design to Integration
Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.
In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.
This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.
Speaker(s):
- Peter Myers
Track and Room: Advanced Analysis Techniques - Large
Title: Business Intelligence Overview - Architecture and Management
Abstract: Business Intelligence is an essential component for any business today and a successful BI implementation has the power to change the way your organization functions. In this non-technical session industry consultants and leaders, including Matt Smith from EMC, Shannon Holck from NCM, Marc Beacom of Datalere, and consultant Carlos Bossy will show you what their current BI projects are all about. This session will cover the purpose of the projects, the tools being used, the makeup of the team, and the architecture being implemented. This session will show you to define the success of a BI implementation, and how to evaluate your BI Analytical Strategy. You should leave this session with better knowledge of how to plan, build and deploy effective Business Intelligence solutions.
Speaker(s):
- Carlos Bossy
Track and Room: Thoughtful Track - Large
Title: Data Visualization: How to truly tell a great story!
Abstract: We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There’s a lot more to creating that story than just getting the correct information. Come learn not just the do’s and don’ts, but the whys…
Speaker(s):
- Jonathan Stewart
Track and Room: BI Information Delivery - Large
Title: Lunch
Abstract: Lunch on your own in the DU area.
Speaker(s):
- Steve Jones
Track and Room: Technical Track - Small
Title: Lunch
Abstract: Lunch on your own in the DU area. Take advantage of the time to network with someone new and spend an hour sharing a meal.
Speaker(s):
- Steve Jones
Track and Room: Thoughtful Track - Large
Title: Test Automation: Agile Enablement for DW and BI Teams
Abstract: Test automation is one of several key technical enablement practices that allows data warehouse and business intelligence teams to be more successful in their agile journeys. While there are lots of test practices and automation tools out there for software development teams to leverage, very few are targeted to data-related development and testing. Agile analytics practitioner Lynn Winterboer and DW/BI architect Cher Fox will share essential agile test foundations and data-focused test automation technologies to help data warehousing and business intelligence teams get a leg up on this important agile practice, including a demo of how this works!
Speaker(s):
- Cher Fox
Track and Room: Other - Small
Title: Power BI for the Developer
Abstract: This session covers the Power BI REST API, Power BI Embedded, Custom Visuals, and Stream Analytics.
Speaker(s):
- Peter Myers
Track and Room: Technical Track - Small
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Cher Fox
Twitter: - TheDatanista
LinkedIn: Cher Fox
Contact: http://foxconsulting.co
Cher Fox has 30 years of programming experience, including 25 years in analytics technical writing, and 15 years specializing in DW BI in multiple industries. She has held the corporate positions of Customer Services Manager for an international SW development group, IT Manager for a national risk management company, is currently the CEO/Principal Consultant of Fox Consulting, a Denver based firm specializing in high level management process re-engineering, DW BI consulting.
Ms. Fox is passionate about reverse engineering BI challenges to improve data quality reliability, improving performance in DW/BI processes as well as automating clients out of spreadsheet madness time consuming manual processes.
Steve Wake
Twitter: - stevewake
LinkedIn: Steve Wake
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
Melissa Coates
Twitter: - https://twitter.com/SQLChick
LinkedIn: Melissa Coates
Contact: https://www.CoatesDataStrategies/blog
Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Jonathan Stewart
Twitter: - sqllocks
LinkedIn: Jonathan Stewart
Contact: https://sqllocks.net/
Jonathan Stewart is a Business Intelligence consultant specializing in data visualization, data warehousing, and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack. Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments.
Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and Business Intelligence at numerous SQLSaturday events, local user groups, and conferences throughout the United States and around the world. He participates in webcasts, podcasts, and on
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Steve Jones
Twitter: - way0utwest
LinkedIn: Steve Jones
Contact: http://www.voiceofthedba.com/
Steve Jones is a Microsoft SQL Server MVP and has been working with SQL Server since version 4.2 on OS/2. After working as a DBA and developer for a variety of companies, Steve co-founded the community website SQLServerCentral.com in 2001. Since 2004, Steve has been the full-time editor of the site, ensuring it continues to be a great resource for SQL Server professionals. Over the last decade, Steve has written hundreds of articles about SQL Server for SQLServerCentral.com, SQL Server Standard magazine, SQL Server Magazine, and Database Journal.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Sponsors
The following is a list of sponsors that helped fund the event: