Sunday, April 26, 2019 – 8:30 am-4:30 pm
Hampton Inn – Ogden, UT
There are two optional full-day Sunday training session choices available at the 2020 HEDW Conference. The course registration fee is $500 (in addition to your HEDW conference registration fee). Your enrollment fee includes breakfast, lunch, breaks, beverages and course materials. The number of seats available for each course is limited.
Dimensional Modeling: Kimball Fundamentals
Margy Ross
Excellence in dimensional modeling is critical to a well-designed data warehouse/business intelligence system. In this course, you will learn the most common dimensional modeling techniques, patterns, and best practices. Concepts are illustrated through real-world industry scenarios, conveyed through a combination of lectures, class exercises, small group workshops, and individual problem solving.
Topics:
- Transaction, periodic and accumulating snapshot grains
- Enterprise bus matrix and conformed dimensions
- Slowly changing dimensions types 0 through 7
- Degenerate, role-playing and junk dimensions
- Centipede and factless fact tables
Trainer Bio:
Margy is President of DecisionWorks Consulting. For over 35 years, she has focused exclusively on helping organizations leverage information to make better business decisions. Since specializing in DW/BI program/project strategy, business requirements analysis, and dimensional modeling, she remains convinced that business acceptance is the true measure of DW/BI success.
In addition to her consulting activities, Margy has taught dimensional modeling and DW/BI methodology to over 10,000 students. She co-authored six best-selling books with Ralph Kimball, including The Data Warehouse Toolkit (3rd Ed.), The Data Warehouse Lifecycle Toolkit (2nd Ed.), and The Kimball Group Reader (2nd Ed.).
Building World-class Business Dashboards
Steve Wexler
Learn the art and science of building world-class dashboards from the best-selling author of The Big Book of Dashboards, Steve Wexler.
A well-designed dashboard can point out risks, opportunities, and more; but common challenges and misconceptions can make your dashboard useless at best, and misleading at worst. This workshop will discuss the tools, guidance, and models you need to produce great dashboards that inform, enlighten, and engage. This workshop is for anyone tasked with building or overseeing the development of business dashboards, and is applicable to anyone who needs to help others better understand data to make informed decisions. The workshop will appeal to all levels in the organization, from data analysts to C-Suite executives
Topics
- Introduction and fundamentals of data visualization
- Data representation and visualization types
- Breakout session: how to visualize these data sets
- Visualizing Time
- Breakout session: what’s wrong with this chart?
- Engagement through personalization
- Data visualization best practices and dashboard design
- Breakout session: chart creation and dashboard layout
- The case for dashboards and interactivity
- Thinking critically about data
- Art vs. infographic vs. business dashboard
- Dealing with the real world
Trainer Bio
Steve Wexler is the founder of Data Revelations and co-author of The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios.
Steve has worked with ADP, Gallup, Johnson & Johnson, Deloitte, ExxonMobil, Convergys, Consumer Reports, The Economist, ConEd, D&B, Marist, Cornell University, Stanford University, Tradeweb, Tiffany, McKinsey & Company, and many other organizations to help them understand and visualize their data. Steve is a five-time Tableau Zen Master, Iron Viz Champion, and on the advisory board to the Data Visualization Society.
His presentations and training classes combine an extraordinary level of product mastery with the real-world experience gained through developing thousands of visualizations for dozens of clients.
Steve has taught thousands of people in both large and small organizations and is known for conducting his seminars with clarity, patience, and humor.