Event Location:
University Hall - 3rd Floor, University of Denver
2197 S. University Blvd
Denver, Colorado
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,
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,
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,
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,
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,
Abstract:
Lunch on your own in the DU area.
Speaker(s): Steve Jones,
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,
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,
Abstract:
This session covers the Power BI REST API, Power BI Embedded, Custom Visuals, and Stream Analytics.
Speaker(s): Peter Myers,
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/cherfox
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.
LinkedIn: http://www.linkedin.com/in/b5lurker
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.
LinkedIn: http://www.linkedin.com/in/melissacoatesprofile
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.
LinkedIn: http://www.linkedin.com/in/way0utwest
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.
LinkedIn: http://www.linkedin/in/carlosbossy
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.
LinkedIn: https://www.linkedin.com/in/sqllocks/
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
LinkedIn: http://linkedin.com/in/peterjsmyers
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.
LinkedIn: http://www.linkedin.com/in/way0utwest
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.
LinkedIn: http://linkedin.com/in/peterjsmyers
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.
LinkedIn: http://www.linkedin/in/carlosbossy
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.