Box office accepts all major credit cards
Will Call is open during regular Box Office Hours and 2 hours prior to curtain.
(480) 965-3434 - Gammage information and Charge By Phone (480) 965-6678 - Gammage Group Services
Box Office is open 10am-6pm Monday - Friday and event days. The Box Office will be closed on Fridays, during the summer months.
Venue is accessible to all patrons. Seats in accessible section are limited to one companion seat. THERE IS NO ACCESSIBLE SEATING AVAILABLE IN BALCONY OR TIER SECTIONS. PATRON MUST USE STAIRS TO GAIN ACCESS TO BALCONY OR TIER SEATING.
Visa, MC, AMEX and Discover.
All tickets are digital- Mobile only.
Vivint Arena (801) 325-2000 Utah Jazz (801) 325-2500
The box office opens at 1:00pm on the day of any scheduled event. Located on the Northeast side of Arena (plaza level). All tickets are now digital. Download the Utah Jazz + Vivint Arena app to easily view, purchase, transfer and sell tickets. Doors open for most events 1 1/2 hours prior.
EXCEL DATA VISUALISATION AND DASHBOARDS
COURSE SUMMARY
Dashboards will summarize and present the key indications of large data in an attractive visual display, hightlighting the most important trends so the most imporatnf aspects of data could could be seen in a snap second by glancing at attractive, colourful charts. PowerPivot helps analyze the data and brings new capabilities to business users to analyse, explore and gain new insight into business and marketing data. Power Pivot help analyze and understand the growing quantities of data that are created on a daily basis. Who should attend?
Business users who analyse data with Excel or create management reports
Excel users who want to analyze large data sets and also create relationships between tables
Excel users who know how to Pivot Tables and Pivot Charts
Excel users who wish to create interactive dashboards
COURSE OUTLINE
Introduction Activating Power Pivot in Excel Browse, Filter and Sort PowerPivot Data PowerPivot Menu Options The AutoSum Function in Power Pivot Creating Pivot Tables with PowerPivot Data Creating PivotTables Changing the Method of Calculation Pivot Table Calculations Filtering with Slicers PivotTable Filters and Slicers Filtering PivotTables and PivotCharts Creating Hierarchies Excel techniques that are essential for DashboardsOffset Lookup formulae (Vlookup, Hlookup, Match, Index) Conditional formulae (If, Countifs, And, Or, etc.) Aggregate formulae Advanced filters to organise columns and filter rows Visuals Sparklines Charting: Pie, Line, Area, Column, Scatter, Bar charts, Charting: Axes, 2D, 3D chart elements, Sizing of charts Charting: Formatting of charts Create dashboard heat maps and other shapes Conditional Formatting Highlight top and bottom products/ people etc Excel Dashboard Tips and Tricks including Adding inter-activity Forms and controls (for drop down lists to choose what you are comparing) Linking cells to a text box Linking cells to chart labels Linking dynamically to changing ranges and values Create Relationships with PowerPivot Data Create Relationships to Master Data Create PivotTables with Table Relationships Refreshing Dashboards inline with changing data
WHAT IS INCLUDED:
Laptops and data for the course. Let us know beforehand if you would like to bring your own
Excel Course Certificate on completion (assessment based)
Excel Course notes
Practical Class exercises, Excel Course Homework
Tea, coffees, but no lunch
To assist after the course, 1 free session for questions online via Skype or Teamviewer.
Max group size is 4.
American Express, Discover, MasterCard, and Visa are accepted. Honda Center is a cashless venue.
A photo ID matching the name the tickets are placed under is required. VIP, Artist, Promoter, or other special will call requirements and locations are subject to change. Will call windows are located at the Box Office. Will call is generally available beginning 1-1/2 hours prior to the event, and closes after the start of the event (after the first intermission for Anaheim Ducks games). Late pick up will be available at the East Entrance after the box office closes.
Box office phones are answered during regular box office hours. Please note, the box office does not sell tickets by phone. Call (714) 704-2500 for general information
Monday through Friday 10am to 3pm. The box office will remain open through the beginning of weeknight events. On event Saturdays and event Sundays, the box office will open three (3) hours prior to the event and remain open through the beginning of the event. The box office is located on the east side of the building, near the East Entrance, facing the Santa Ana riverbed.
Wheelchair accessible seating is available in most areas of Honda Center including Plaza, Club, and Terrace levels. Availability of locations is dependent upon event seating configuration. For availability and exact locations based on a particular event, please toggle the Accessibility icon in the seat map filters on the Ticketmaster.com event page. The box office will have the same availability as Ticketmaster. Please note, semi-ambulatory or limited mobility seating is also available and requires the guest to navigate some steps. Wheelchair accessible seats have no steps. Hearing Impaired Guests: Assistive listening devices are available, with a picture ID as a deposit, at the Guest Services Desk located at Section 214. Requests for sign language interpreters must be received at least 14 business days prior to the event you are attending. To arrange for courtesy sign language interpreters, please either email accessibilityservices@hondacenter.com or call 714-704-2400. For a full list of ADA policies, please visit https://www.hondacenter.com/arena-info/ada-accessibility/
Cash, AmEx, Visa, MC
Pick up tickets one hour prior to the show. Customers must present the actual credit card used to place the order and a photo ID.
(212) 221-1211
Monday - Saturday 10am - 8pm Sunday 12pm - 6pm
Course Overview
This course provides the concrete know-how about the practices that are required to be an effective Scrum Master. It presents in detail the agile processes and team dynamics, with a strong emphasis on the role of Scrum Master. This course covers the benefits of an Agile approach working with Scrum, highlighting the differences between Scrum and the traditional development methodologies. Moreover, the power of visual management, pursuing and resolving impediments are made clear to trainees by means of practical exercises. The training closes with PSM 1 exam, provided by scrum.org. This body of certification was created in 2009 by Ken Schwaber, one of the founders of Scrum.
Course Objectives
The course is based on an interactive approach in which trainees will learn how to guide a team, a project, or an organization into a process of rapid delivery of valuable results. Exercises, case studies, and examples are used to assist the participants to develop the knowledge, skills, capabilities and insights needed to make the shift from the traditional management practices to Scrum framework.
At the end of the course, trainees have a clear understanding about:
Why adopting Agile approach and Scrum?
What are the principles, the different roles and responsibilities in Scrum?
How to implement agile practices for estimation, planning, project execution and monitoring?
How to facilitate Scrum ceremonies and foster product quality?
Targeted Audience
This course is intended for project managers, team leads, designers, developers, testers, software architects and anyone who is expected to lead Scrum projects & teams.
Trainers
Training will be conducted by an experienced trainer and Agile coach from why innovation!.
Course Content
Agile Overview
Agile Definition
Agile Principles: The Agile Manifesto
Benefits of Agile
Understand Agile for Software Development
Overview of Agile Methods
Scrum, Kanban, XP (eXtreme Programming), DevOps, Lean Startup, Design Thinking and Kanban
Adopting Agile Methods
Scrum: Agile Project Management
Architecture of Scrum and focus on product development
Roles and Responsibilities in Scrum
Scrum: The rhythm of Sprints
Importance of continuous improvement
Scrum applied: key success factors and pitfalls
Team Dynamics
The stakeholders
Team work, team spirit, self-organization
The leadership
Effective communication and solving conflict
Managing Requirements
The product manager and the Product Backlog
The delivery plan
Characteristics, performance and quality requirements
Product completion level and tests
Detailed specifications
Requirements traceability
Scrum Process and Meetings
Sprint, Sprint activities, time boxing, Sprint Planning,
Product Backlog, estimations and poker game
Good practices for Sprint Backlog
The Daily Scrum
The burndown chart
The Sprint Review
The Sprint Retrospective
Implementing Scrum difficulties and resistance
Change Management
Good practices and frequent mistakes (Dos and Don’ts)
Course Information
Each session will be limited to a maximum of 12 participants.
Duration: 3 days
Location: Singapore, Hong Kong
Training Fee: SGD 2,310 / HKD 14,000
Certification Fee: SGD 210 / HKD 1,200 from Scrum.org
Funding from IMDA (Available for Singapore citizens and Permanent Resident):
• up to 70% of the exam fees, capped at SGD 500 (exam only) per trainee.
Funding support is available for Singapore citizens and Permanent Residents**. Valid for courses and examinations commencing on or before 31 March 2020. Terms and conditions apply. Please visit http://www.imda.gov.sg/citrep for full details.
Related Courses
Agile Essentials
Scrum Developer with PSD Certification
Scrum Product Owner with PSPO I Certification
Kanban & Lean Foundations
Leading SAFe® 4.0 with SA Certification
SAFe® 4.0 Advanced Scrum Master with SASM Certification
Visa, Mastercard, Maestro
Tickets must be collected hy the card holder who must present the card used to book and the Ticketmaster reference number on the day of the event.
Ticketmaster UK: 0870 154 40 40 International: 00 44 161 385 3500.
Ticketmaster credit card line open 24hrs. A Box Office will be open during the event. It will not be open in advance.
See individual events for specifications.