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 Tips and tricks Flattening data/rows to columns Lead and lag functions Data validation Deploying SQL queries in your tool Web Intelligence Crystal Reports InfoBurst Tableau Power BI Other database systems Compare/contrast RDBMS’s Syntactical differences […]

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

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

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

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

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