Amy O’Neel

Amy O’Neel

Senior Consultant, InfoSol Inc.

Amy is certified as a BusinessObjects Certified Professional.  In her 20 years with Infosol, Amy can often be found providing client installations and migrations, as well as universe, report and dashboard design. In addition to BusinessObjects products, she is well-versed in Version Manager, 360View/Plus/Eyes, Infoburst and other 3rd-party tools. Recently, Amy performed site use and performance audits at City of Calgary, WebCor, Loyolla Marymount University and Comdata, developed well-used dashboards for BP Alaska and McHenry College and trained users and administrators at Intel and BP Alaska. Amy admits her greatest passion is for process improvement in whatever form it may take and she loves to throw in extra value to every project.

Virtual: SQL for Data Analysts – Advanced (Day 2)

Day 2 Agenda: Complex functions Using the WITH statement Window functions Ranking data Point in time functions Using the APPLY function Deploying SQL queries in your tool Web Intelligence Crystal Reports InfoBurst Tableau Power BI Other database systems Compare/contrast RDBMS’s Syntactical differences   View Full Agenda: Day 1 Day 2

Post-Conference Boot Camp
READ MORE

Virtual: SQL for Data Analysts – Advanced (Day 1)

Course Description This hands-on course will help data analysts and report/dashboard developers to understand complex SQL concepts. Attendees will learn how to use complex calculations and functions, and how to use subqueries. Intended Audience: Data analysts and report/dashboard developers who want to expand their SQL skills. Prerequisites: At least one year of experience with SQL […]

Post-Conference Boot Camp
READ MORE

Virtual: Webi Dashboard Boot Camp (Day 3)

Module 7 – Creating Webi Dashboards: Strategic Dashboard – Using Space Wisely The third dashboard type is Strategic dashboards.  These dashboards are typically tracking KPIs and are often for management use.  We want to convey a lot of information quickly using images and color instead of text where it makes sense.   We will begin […]

READ MORE

Virtual: Webi Dashboard Boot Camp (Day 2)

Module 4 – Creating Webi Dashboards: Analytical Dashboard – What If? With the second type of dashboards – Analytical dashboards, we will dive right in with What-If Analysis including modifying range inputs and adding multi-select filters and single select filtering.  We will also cover passing a value when refreshing data to influence the resulting format […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Virtual: Webi Dashboard Boot Camp (Day 1)

Module 1 – Alerting Dashboard Using Heat Maps and Scorecards This module will cover the first of three types of dashboards, Alerting dashboards. Our first session will cover charts that alert including heat maps, and scorecards with trending icons. Intended Audience:  Prior experience with Web Intelligence is recommended. Major Topics Include: Bringing in Data Displaying […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

SQL for Data Analysts – Beginner/Intermediate

Course Description: This hands-on course will introduce SQL and how it can be used to drive reports and dashboards. Attendees will learn how to write SQL queries, filter data, join tables, and perform various calculations. Intended Audience: Data analysts and report/dashboard developers who want to learn about the SQL language and how to write SQL […]

Pre-Conference Boot Camp
READ MORE

SQL for Data Analysts – Advanced (Day 2)

Day 2 Agenda: Complex functions Using the WITH statement Window functions Ranking data Point in time functions Using the APPLY function Deploying SQL queries in your tool Web Intelligence Crystal Reports InfoBurst Tableau Power BI Other database systems Compare/contrast RDBMS’s Syntactical differences VIEW DAY 1 AGENDA

Post-Conference Boot Camp
READ MORE

SQL for Data Analysts – Advanced (Day 1)

Course Description This hands-on course will help data analysts and report/dashboard developers to understand complex SQL concepts. Attendees will learn how to use complex calculations and functions, and how to use subqueries. Intended Audience: Data analysts and report/dashboard developers who want to expand their SQL skills. Prerequisites: At least one year of experience with SQL […]

Post-Conference Boot Camp
READ MORE

Webi Dashboard Boot Camp: Module 7 – Strategic Dashboard – Using Space Wisely

The third dashboard type is Strategic dashboards.  These dashboards are typically tracking KPIs and are often for management use.  We want to convey a lot of information quickly using images and color instead of text where it makes sense.   We will begin with covering smart use of space issues.  We will overlay transparent images […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Write-back options through Web Intelligence

BusinessObjects is thought of as a reporting solution but why leave the reporting platform to enter data? So many options are available for engaging users for input! In this presentation we will demonstrate a variety of ways to get user’s input through the Web Intelligence interface. From prompts to comments to dashboards, we will look […]

BusinessObjects Reporting
READ MORE

Webi Dashboard Boot Camp: Module 8 – Interactive Charts and Blocks

This module will cover Strategic Dashboards using interactive charts and blocks including Key Data Points, element linking and special input controls as well as using show/hide options on blocks to display based upon formula. Intended Audience:  Prior experience with Web Intelligence is recommended. Major Topics Include: Key Data points Element Linking Hide Cell or Block […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

More Lessons from the Trenches – Security, Security, and more Security!

Every year there are some interesting and generally applicable things we learn that we think are important enough to share but aren’t big enough for their own presentation. This year’s hodge-podge includes a lot about security such as delegated promotion security, upgrading tomcat versions, special considerations for CMS universe querying, security access combinations, and more […]

BusinessObjects Universes + Administration
READ MORE

Webi Dashboard Boot Camp: Module 9 – Key Performance Indicators

We will take this opportunity to discuss Key Performance Indicators both in display and concept.  We will include using comments on dashboards and using reference cells as input for tiles to make important results stand out above the noise.  Additionally we will be discussing designing for mobile and important considerations when the intended output will […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Webi Dashboard Boot Camp: Module 4 – Analytical Dashboard – What If?

With the second type of dashboards – Analytical dashboards, we will dive right in with What-If Analysis including modifying range inputs and adding multi-select filters and single select filtering.  We will also cover passing a value when refreshing data to influence the resulting format and switching dimension and measure selections on the fly.  We will […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Webi Dashboard Boot Camp: Module 5 – Webi Dashboards Boot Camp: Geomapping, Vector Graphics & Custom Elements

This module will cover bringing in some more customization with additional charts, graphics and geomapping opportunities.  For geomapping we will cover linking to google maps and functionality of existing mapping in Webi, we will also cover custom mapping with SVGs and even animated logos!  For custom elements, there are a variety of add-ons available in […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Webi Dashboard Boot Camp: Module 6 – Analytical Dashboard – Functions for Statistical Charting

This module will cover statistical charting options including the reusability of complicated formulas with Shared Elements as well as some functions and formulas that we have available to us to calculate. Intended Audience:  Prior experience with Web Intelligence is recommended. Major Topics Include: Statistical Functions Percentile Context Operators Polynomial Functions Shared Elements View the Full […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Let’s RUN with Sprints for BusinessObjects Project Management

Agile development and setting up sprints have taken over the IT arena. What special considerations might be involved in using this method with BusinessObjects management? Multiple recent projects involving this management style have led to some interesting conversations and discoveries specific to a reporting environment with multiple pieces working together towards maximum usage and adoption. […]

Limitless BI Case Studies and Future Trends
READ MORE

Webi Dashboard Boot Camp: Module 1 – Alerting Dashboard Using Heat Maps and Scorecards

This module will cover the first of three types of dashboards, Alerting dashboards. Our first session will cover charts that alert including heat maps, and scorecards with trending icons. Intended Audience:  Prior experience with Web Intelligence is recommended. Major Topics Include: Bringing in Data Displaying data in Heat Maps Displaying data in Scorecards Using Specialty […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

Webi Dashboard Boot Camp: Module 2 – Alerting Dashboard – Adding Tableau or PowerBi to a Webi report

We will take our Alerting dashboard further to make it work for our attention!  This module will include using a script for refreshing on a timer, creating eye-catching marquees as well as adding a Tableau or PowerBI visualization into Web Intelligence using iFrame.  We will also demo adding options in scheduling that can trigger alerts […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE

More Lessons from the Trenches – Security, Security, and more Security!

Every year there are some interesting and generally applicable things we learn that we think are important enough to share but aren’t big enough for their own presentation.  This year’s hodge-podge includes a lot about security such as delegated promotion security, upgrading tomcat versions, special considerations for CMS universe querying, security access combinations, and more […]

BusinessObjects Universes + Administration
READ MORE

Webi Dashboard Boot Camp: Module 3 – Alerting Dashboard – Linking to Detail

Once alerted to anomalies in our Alerting dashboard, we may need to drill in further to get details to determine the cause of the alert.  In this module we will cover ways to display our dashboard either in the HTML5 interface and in BI Workspaces.  We will also look at various linking options between documents […]

Main Conference Boot Camps Webi Dashboards Boot Camp
READ MORE