Welcome to the SplashBI Community.

[ics_calendar url=”https://tasks.office.com/a01a9fad-47e6-46a8-8654-68e2b39b8a33/Calendar/Plan/oqGi3mrqp0-bkPaHer8v0mUAE3v1?t=0_d0feb124-0208-4057-8ec2-d2d0b9b44749_2019-04-15T15%3a52%3a22.2249830%2b00%3a00″]

Moving from EBS to the Oracle Applications Cloud can be challenging! Join Wade Zimmerman, Life Care Service’s Director of Business Applications as he discusses why they decided to move to the cloud, the benefits they have seen, and their challenges and successes with reporting.

Making a new solution work in the business is never an easy sell – regardless of what problem you are looking to fix. Some people don’t like technology. Period. More often than not people have inertia and are reluctant to change. Having a strategy and starting small is your key to success. Enabling early adopters to be your salesman is key. But a spike in interest early on is just the start. Sustainability should be your main goal. This session will give you ideas on how to maintain your core user base over time and how to organically grow the solution over time. Just make sure you have enough licenses!

Motivation – Introduction of Splash BI, GL Connect and having worked for over a year to finalize the contract, on-site demo completed in Nov. 2018 – WOW!!! The possibilities and ease of use was experienced by upwards of 20 County employees from IT, Office of Controller, Budget Office and iProcurement. The Problem – The key component for partnering with SplashBI was to find a strong viable solution to Oracle’s end of support for Discoverer Reporting. Additionally, the Oracle EBS 12.1.3 version had key Discoverer reports utilized by many Departments and Financial Managers. These needed to be replaced as soon as possible. The search was on, and not wanting to get to technical, the vast arenas explored ranged from the very complex to simplicity, that being what we saw with Splash BI Study Design – To reiterate, multiple companies were approached to research the best solution that they offered, within time, economic and technological constraints. Solutions offered: On-Site to Cloud Solutions – EPRCS – Service OBIEE – BICS – OACS EE – OBIA – FUSION The overall length of time was slightly greater than 2 years. Predictions and results – Splash BI provide the greatest (return on investment) (ROI) by far. The return was factored into many different components consisting of (buy not all inclusive): Replacement for Discoverer Reporting Departmental reporting CAFR report for the Office of Controller (Comprehensive Annual Financial Report) Stream-line the use of FSG Abbreviated to fit form…

I will show you how we use SplashBI to deploy reports quickly, effectively and maintain consistency data across multiple data sources and end user requirements.

Tips and tricks learned from real life dashboard development. Hopefully these will help you with your own custom dashboard development efforts. Some of the items covered will be:

• Deciding on your data layout
• Finding the right chart type – Using chart variables
• The difference in chart variables and dashboard variables
• Using drill charts

Audience: All Microsoft Excel Users

You use Excel 40 hours a week, but do you really know how to unleash the power of Excel? Create slick charts in a single button click. Filter by Selection. Fast Formula copy.

Learn amazing time-saving tricks from MrExcel!

Audience: Advanced Microsoft Excel Users

Learn the ins and outs of Pivot Tables (from the guy who wrote the book on pivot tables!). Create slick charts in a single button click. Add thousands of subtotals in seconds. Don’t be tortured by bad data any longer.

Audience: Advanced Microsoft Excel Users

From VLOOKUP to MAXIFS to Goal Seek, learn many Formula tips and tricks from MrExcel. How to make your VLOOKUP faster. When to switch to Index/Match. Run a Model hundreds of times using Sensitivity Analysis.

Audience: All GLC Users

GL Connect is a solution that makes your month-end close processing a breeze, but did you know it can also be used for day to day analysis? In this session, we will teach you how to create ad hoc analyses, complete with drill-downs that can be customized to fit your needs!

Audience: All GLC Users

Most GLC users know the basics of GL Connect, like how to pull a balance and make a financial statement. But we see more and more questions asking for features that already exist, but were just unknown to the user!
In this session, we teach you some of the lesser known, but very powerful, tips and tricks in GL Connect!

• Static Reports
• Hide and Show Zeros
• Using Periods effectively
• Editing Subledger Drills
• Security Profiles
• Jobs from GLC

Audience: All GLC Users

Within Excel, GL Connect provides you with the tools to create the financial statement of your dreams… but are you dreaming big enough?

In this session we explore all the ways you can improve your financial reporting using Excel as your canvas, and GL Connect, as your palette.

• Examples of other financials, made by actual GLC Users
• Tips for a better layout to provide maximum reusability and flexibility
• Using Excel functionality to enhance your GL Connect statements

Audience: Advanced Users

Cross App Reporting is the latest trend in the ever-growing BI landscape, and SplashBI makes it easier than ever!

Our trainer will show the different ways this can be accomplished:

• Learn how to design custom Domains to house various objects from your Data Sources
• Create table joins to allow additional columns to be added to your reports
• Utilize SplashBI Dashboards to produce visual summarizations of all your data!

Audence: Medium and Advanced Users

Did you know that SplashBI has advanced features that can be added to your reports?

Come learn about them with our SplashBI Report Experts!

Topics covered in this session will include:

• Drill Queries
• Pixel Perfect Reports
• Calculation Columns
• Totals, and more!

Audience: All Users

Excel Connect is the known to some as “the 8th Wonder of the World”.

Have you discovered it yet? In this session, we will introduce new users to this powerful addition to SplashBI.  Run and create reports directly in the Microsoft Excel application.

You will learn how to:

• Set up the add-on -Utilize impactful features, such as Refreshing Reports and retaining any new customizations made in Excel
• Build useful workbooks that can be created once, and refreshed when needed!

Audience: All Experience Levels

One of SplashBI Reporting’s most popular features is its ability to allow users to AD HOC reports to suit their needs. Did we mention it doesn’t require IT assistance?

In this training, we will discuss why ad hoc reporting can be such a powerful tool, and walk you through editing your reports on the fly.

Topics include:

• WHY ad hoc reporting is so powerful
• Adding and removing columns
• Formatting columns, including fonts, colors, dates, and numbers
• Adding parameters
• Modifying and adding pivot tables

Audience: Administrators

Are you maximizing your efficiency in SplashBI?  As an Administrator, it is up to you to ensure that SplashBI operates at its highest level.

In this session, learn about the various Admin reports and maintenance processes that you can enable to keep SplashBI performance optimized!
Our expert will explain the use case for each report, and how to automate those processes to make SplashBI do the work for you!

Audience: Everyone

Learn the art of Visualizing your Data!

Sit with our Dashboards experts to learn the basics of creating and utilizing SplashBI visualizations.
In this session, you will also learn:

• Creating & Customizing Charts
• Assembling vibrant Dashboards from a single or various data sources
• Basic Functionalities of a live Dashboard