Posts Tagged ‘Xcelsius Gurus’

Apr
16

Saying Goodbye to EverythingXcelsius

Saying Good bye Ryan Goodman

I remember 7 years ago, getting a call from Mico with a vision to create a community around Xcelsius. From that one discussion EverythingXcelsius.com was born and we quickly learned one lesson.

“People make a Community, Not Technology.”

 

A group of passionate and highly intelligent professionals gravitated toward Xcelsius in 2004-2010 and the community that formed was something very special. Needless to say, riding the Xcelsius wave has been amazing. I’ve enjoyed meeting so many of you at various events around the world.

What I’m most excited about now is Mico’s vision for BI Brainz and the soon to be released new ‘Analytics on Fire‘ community.  Having once again and personally discussed with her over the last two years, it’s something that we feel will be very exciting.  As the market continues to rapidly evolve, the timing is perfect to take the existing Xcelsius community who are older, wiser and more diversified in technology knowledge into the next 7 years!

See you on the other side…. but first, since this my last EverythingXcelsius post, I put together my “Ultimate Top 3″ lists. Let’s go down memory lane!

My Top 3 EverythingXcelsius Posts

  1. My Take on Flash vs Few - The controversy around this post was just amazing
  2. Dashboards don’t kill Dashboard Projects, People Do!  - Ouch! Still holds true today.
  3. The Slow Death of a Gauge - This may be getting up there with pie charts.

 

My Top 3 Xcelsius Memories

  1. The look on customer’s faces when I could drag and drop a gauge or chart on a screen, wire it up to a simple slider and stick it in a power point within a couple minutes.
  2. Traveling the world in 2006-2007 evangelizing the possibilities of dashboard with Xcelsius and meeting hundreds of colleagues.
  3. The Xcelsius party that took over GBN conference in 2008 after SAP Acquired BusinessObjects

 

My Top 3 Areas of Focus Moving Forward

  1. Maps for Everyone - Through CMaps Analytics, I am focusing all of my energies to make geo-visualization and analytics available to everyone, everywhere in the enterprise.
  2. Indoor Analytics - With internet of things on the horizon, Indoor tracking is one of the next big data generators, so someone needs to figure out how to funnel this location data into useful information!
  3. Keeping up with the community - Though EverythingXcelsius as we know it is winding down, I am not going anywhere as BI Brainz picks up where EverythingXcelsius left off.

 

My Top 3 Dashboard/Visualization Tools for the Future

  1. Antivia DecisionPoint- I am seeing lots of Xcelsius users gravitate to DecisionPoint for Excel. These guys helped make Xcelsius enterprise ready with XWIS, and from my perspective built the successor to Xcelsius that SAP should have created.
  2. Tableau - In 2013 Tableau’s maturity as a visualization powerhouse took the BI industry by storm. It is not really a dashboard tool, but is best of breed for data exploration and what I use for my data exploration.
  3. D3 - This is more geeky and more about coding visualizations than rapid design, but D3JS.org is a visualization framework is very slick; it is also the foundation for several large software vendor visualization packages (including SAP).

Don’t forget to join us at the new Analytics on Fire community!

Ryan Goodman is the Founder of Centigon Solutions, an SAP® software solution partner that is strategically focused on developing add-on products for use with Xcelsius®. To learn more about him, please visit our new Gurus page.

Jan
2

Happy New Years from the #Xcelsius Gurus!

Hi Guys,

I know we’ve been really quiet the last few months, but it’s not without merit. We have lots planned for the New Year and hope you will continue this journey with us!

From all the Gurus, we wish you a Happy New Year!

Happy New Year from all the Gurus

 

 

 

Aug
26

Join Mico Yuk at the #MasteringSAP Business Analytics conference in Johannesburg, ZA

 

MasteringSAP Johannesburg4

 

Join Mico Yuk at the MasteringSAP Reporting & Analytics conference, September 9-11th, in Johannesburg, South Africa. This unique conference is aimed at business leaders who drive the need for reporting, along with IT executives and their BI teams.

The agenda is perfectly balanced to speak to business users as well as BI teams and is made up of local & international case studies – customers and users sharing stories that will help their peers to fast track initiatives and improve business processes. These are real business examples of people using their data assets to drive good analytics!

Mico MasteringSAP Johannesburg

Mico will share her incredible knowledge through keynote presentations and full-day deep-dive workshops, rated #1 and #2 by attendees:

  • Monday (9th) – Conference Day One
    • (09:00am) Opening Keynote: Top 5 BI Guerrilla Tactics to Overcome User Resistance!
    • (14:15pm) Learn Three Keys to Unlock Your Executive BI Chequebook
  • Wednesday (11th) – Workshops
    • (08:30am) BI Dashboard Formula
  • Registration:MagsteringSAP.co.za/bi

There is only 13 days left to register and places are limited so register online ASAP to reserve your seat, or contact The Eventful Group at +27 21 460 0434 to get registered!

If you can’t attend, Mico will also be tweeting & taking many pics, on twitter and instagram using #MasteringSAP hashtag!

Soo Tang Yuk (@sootangyuk) is the ‘Xcelsius Gurus Network” community manager and evangelist. To find out more, please visit her about me page.

Jan
31

[FREE Webinar]: Learn One Shocking New Way to Increase BI User Adoption

Join Mico Yuk (@micoyuk) again for another ‘eye opening’ webinar, guaranteed to save you time and money on your BI projects.

REALITY… Regardless of how hard you work on your BI project, the success of the project will be determined by one single KPI?

USER ADOPTION…

Studies have shown that BI user adoption rates for 2013 are at an all time low: 15 – 20% for most organizations. This means that 75% or 3 out 4 of your business users will never use your BI solution, regardless of how great it is, unless of course…

You learn to use her one secret technique!

This new, but effective method of launching your BI project will make all the difference in the world to your business users.

In 60 minutes you can expect to experience:

  1. Fun – guaranteed… it’s far from the typical boring IT stuff
  2. Easy – chances are you’ll enjoy it so much it won’t feel like work
  3. Cheap – approximately 3-5% of the average BI project cost
  4. Results? – your business users won’t be able to wait to try your BI product! Your team will leave feeling appreciated and ready to for the next challenge!

She has never shared this before, so you’ll simply have to attend to see what it is and how it’s done.

Register for another Special FREE Webinar today!
Date & Time: Thursday, Feb 7th, 12:00-1:00 pm EST

(Space is limited to first 500 registrants, on average we get about 1K. Recording available for those who register, but can’t attend.)

Don’t miss out! This fun ‘eye opening’ webinar is guaranteed to give you a different perspective on how to successfully approach your BI projects in 2013.

Soo Tang Yuk (@sootangyuk) is the ‘Xcelsius Gurus Network” community manager and evangelist. To find out more, please visit her aboutme page.

P.S. – Registration for the BI Dashboard Formula will shut down in 7 days! Don’t wait… Register Today!

 

Nov
14

Survey Results are in! Final 2012 #AllAccessSAP Xcelsius Webinar is a GO!

We just wanted to say a big ‘THANK YOU’ to everyone who completed the survey! The results are in, with over 2K votes and even more shocking than we expected.

View the complete report now!

Also, by popular demand, the discounted registration pricing for the BI Dashboard Formula 2.0 has been extended to November 23rd! Join us on this journey to getting your BI Dashboards on track for 2013!

Cheers!

Soo Tang Yuk (@sootangyuk) is the ‘Xcelsius Gurus Network” community manager and evangelist. To find out more, please visit her about me page.

Aug
20

Webinar in 24 hrs: Xcelsius Dashboard Scoping

Join Mico tomorrow for yet another FREE webinar that relates to her new BI Dashboard Formula training series.

Due to a number of requests to have “a little more time to gain approval”, we have re-opened the registration page until Friday, August 31st, 2012.  As the class is scheduled to start on September 6th, this will be your absolute LAST OPPORTUNITY to REGISTER for the BI Dashboard Formula.

While presented at a few conferences, Mico has never focused on this topic  in such detail before as it’s an excerpt from the BIDF teachings.  Expect to leave this webinar seeing BI Dashboard Scoping in a new light.  In order to successfully complete your dashboard scoping you must…

Gather three types of requirements:

1. DATA requirements – Capture all the details about the KPI’s and metrics such as the definition, how to calculate, the data sourc(s), any business rules and much more
2. FUNCTIONAL requirements – Learn how your business user expects to ‘use’ the dashboard
3. DESIGN requirements – Define the look and feel of the dashboard

Here are the details to register:

  1. WHERE – Click here to Register (or copy and paste into browser: http://bit.ly/Olqki0)
  2. WHEN – Tomorrow (08/21/2012) at 1pm EST / 10am PST sharp
  3. NOTE – If you cannot attend the live webinar be sure to register to receive the link to the webinar recording
  4. WHAT - Mico will cover about 40% of  Module 3 of the BI Dashboard Formula Training Series, the most popular teaching of the series and will describe how to use the BI Dashboard Formula Blueprint (template)

Hope you can join us!

Soo Tang Yuk (@sootangyuk) is the ‘Xcelsius Gurus Network” community manager and evangelist. To find out more, please visit her about me page.

Jul
26

Dynamic status update of Check Box components in Xcelsius: Part 2/4

Select All or Select None

The ability to update the status of multiple logically related Check Box components with one click is a common request when using SAP BusinessObjects Dashboards (Xcelsius).

Another frequently requested feature is the “Invert Selection” functionality, when on “one click” a user can deselect (uncheck) all of the currently selected items and select (check) those, which were not in the original selection.

The benefits of having these features might not be obvious while dealing with just 3-4 check boxes. However, when we have more of them and try to check only the few that we are interested in, such functionality becomes highly desirable.

The challenge here is making the Check Box component be checked or unchecked dynamically. In Part 1 of this series I demonstrated how to accomplish a dynamic status update (e.g. Reset) of a single Check Box component. This post is about applying that approach to multiple Check Box components.

Let’s build a model with multiple check boxes that represent geographical regions.

We want to support a selective update of individual check boxes and also a simultaneous update of all of them or just those that belong to a predefined group.

1. Set up a spreadsheet as shown in the figure below. For this example, the region “East” is associated with the group 2 and the other ones with the group 1 (see column H). These group names have no special meaning and could be replaced with other identifiers, if it’s also reflected in the dependent formulae.

2. Add to a canvas four sets of components, each of which represents the region to be selected at run time and consists of two check boxes (checked and unchecked), a label and a push button, as shown in a figure above.

3. Link Label components to the cells with the region names in the range I2:I5.

4. Bind the push buttons’ Source Data properties to the cells in column A and the Destination properties to the cells in the column G in the same row.

5. Make the push buttons transparent as explained in my Custom Push Buttons post.

6. Set the Item property of one of the check boxes in each set as a Checked and the other one as Unchecked. The Item property is located on the Common tab of the Behavior section.

7. Configure Dynamic Visibility for each check box in a set by linking their Status properties to the cells in the Status range G2:G5 (shaded in yellow). Set the Key property for the checked check boxes to 1 and to 0 for the unchecked ones.

8. Stack check boxes in each set and place the corresponding transparent push buttons on top.

9. Resize and align Label components with the check boxes.

10. Add to the model five new push buttons and label them as All, None, Invert, Group1 and Group2.

11. All push buttons will use the cells in the Status range (G2:G5) as a Destination property.

The Push Button component fires only on a click and stays neutral upon dashboard load. It allows us to use multiple push buttons pointing to the same destination. The ordinal positions of the components in the Object Browser do not impact the result.

12. Button All uses as a Data Source the range B2:B5 with values 1 in all cells.

Data Source property of the button None is bound to the range C2:C5 with values 0 in all cells.

Invert button points Data Source property to the range A2: A5 with the formula =1-G2 in the cell A2 copied down in other cells in the range.

Buttons Group1 and Group2 illustrate the selection that is based on a custom logic. They use as the Data Sources the ranges D2:D5 and E2:E5 correspondingly. The formula in D2 is =SIGN(H2=1) and the formula in E2 is =SIGN(H2=2). They are copied down the ranges and flagging regions in the Group1 and Group2.

13. For the visualization of underlying run time changes, add a Spreadsheet Table component and bind its Display Data property to the spreadsheet range shown in the figure above.

14. Open a Preview. As depicted in the following figures, we can flip the values in the cells in the Status range by selectively checking/unchecking check boxes and also can simultaneously check/uncheck check boxes in the various logical groups using the push buttons.

One of the practical applications of this functionality is a toggling of the display of a chart series based on the statuses of the corresponding check boxes. I will show how it can be implemented in one of the next posts.

Leonid Koyfman is a BI professional with over 10 years of experience in a database design and development and in delivering reporting solutions using enterprise reporting technologies. He is a big Xcelsius enthusiast passionate about dashboard design and other kinds of data visualization. In his leisure time Leonid enjoys solving mental puzzles and hiking in the Bay Area with his family.

Jan
10

Intro to Guest Blogger, Leonid Koyfman & what he has planned for Us!

Welcome to my first post on Everything Xcelsius. I’m Leonid Koyfman, a Database Architect at AKQA in San Francisco. Although my primary responsibilities are in a database domain, data visualization and dashboard design in particular have always been in the area of my interests. In my career I completed many reporting projects using Crystal Reports, Actuate and various Microsoft products.

Creating reports and dashboards in Excel prepared me well for transition to Xcelsius. Its mashup of art and technology impressed me from the moment I opened a trial version and I enthusiastically promoted Xcelsius in the company I worked for then.

Starting with Xcelsius 4.0 we developed a line of web analytics dashboards for financial institutions. Our clients loved them. Instead of hundreds static slides in PowerPoint decks, they received interactive dashboards with intuitive navigation and the level of detail not supported in the legacy reports.  While the data preparation on the database side and in Excel was the bulk of the work, using Xcelsius for the presentation delivered the knockout punch. The resounding success of the project made me even stronger proponent of Xcelsius. It also inspired me to be creative and look for workarounds when Xcelsius doesn’t support needed functionality out of the box.

While getting better with every new release, Xcelsius still needs more popularization. Everything Xcelsius is one of the major players in that field. I’ve been a big fan of the website for many years, regularly visiting the site, learning new techniques and developing new skills. I’m glad to have a chance to share some of my ideas, tips and tricks here.

In the next several posts I’m going to examine various applications of customized Push Button controls in Xcelsius. Stay tuned!!

Leonid Koyfman is a BI professional with over 10 years of experience in a database design and development and in delivering reporting solutions using enterprise reporting technologies. He is a big Xcelsius enthusiast passionate about dashboard design and other kinds of data visualization. In his leisure time Leonid enjoys solving mental puzzles and hiking in the Bay Area with his family.

Dec
6

Advanced Printing for Xcelsius is Here… Finally!

A few months ago, I received an email with a subject, “check out this print component” from Gabriel Braun at DataSavvy Tools. When I fired it up, I had a smile ear-to-ear because I was sitting in front of exactly what every customer has been asking me for the last 5 years… A robust print button capable of letting me choose what I want to print, control layout, and print to landscape or portrait. So I am happy to say that thanks to the Data Savvy Tools ingenuity, the community now has a fantastic option for printing: Dash Printer

While we try to keep promotions to a minimum on EverythingXcelsius.com, we could not resist posting about this new component because it is so heavily requested among customers. While some would argue that a basic function like printing should be taken care of by SAP, history has told us that they prefer to use the ecosystem to fill in certain gaps. Frankly, I don’t think that it could have been done any better than this.

After clicking on the print icon, you can click and drag to draw the area for which you will print. This way if you only want a portion of your dashboard printed, you can do so.


While still inside of your dashboard, you can instantly toggle the scale, margins, layout, and alignment of your image to print exactly what you want. This way every user is presented with the same visual print setup regardless of operating system.

So if you need an advanced print button for Xcelsius, you can now look to DataSavy Tools for a sound solution moving forward. Get the Dash Printer NOW!

Ryan Goodman is the Founder of Centigon Solutions, an SAP® software solution partner, that is strategically focused on developing add-on products for use with Xcelsius®. To learn more about him, please visit our Gurus page.

May
12

Mico’s #SAPPHIRENOW / #ASUG2011 Schedule

Hi Everyone,

With less than 3 days left for the SAPPHIRENOW / ASUG2011 Conference in Orlando, FL,  I just wanted to do a quick check-in. Before I get to my schedule, I wanted to share my interview from 2 weeks ago with Liz Brenner: “Follow the Leader: Living Her Dream- the Brave Mico Yuk“, for those of who that want to find out more about me. I also want to thank Liz for such an awesome job!

Now to the matter at hand! Below is a list of events where you can find me, along with my role in CAPS (this reflects about 1/4 of my schedule, so I really hope to meet with as many of you as I can).

Monday, May 16th

  • SPEAKER: SAP BusinessObjects Dashboards (formerly Xcelsius) Gurus- FAQ session | Time: 3:00 to 4:00 pm | Location: Broadcast Center 2 (ASUG booth on the show floor)
    • How to leverage SAP BusinesObjects dashboards in your organization
    • Why SAP BusinessObjects dashboard is the best tool for your organization
    • How and when to integrate it with the other tools in the SAP BusinessObjects Suite of software
    • How and when to use the most popular connectivity options
  • JUDGE/JUROR: SAP HANA InnoJam Final | Time: 6:00 to 11:00pm |  Location:  Hilton Hotel (next to convention center)

Tuesday, May 17th

  • MODERATOR: ASUG’s 1st Women’s Leadership Breakfast Panel | Time: 7:00 to 9:00 am | Location: Dux Room at the Peabody Hotel
  • SPEAKER: Xcelsius Gurus Dashboard Methodology 101- 7 Proven Steps to successfully developing your SAP BusinessObjects Dashboard (Xcelsius) with Ryan Goodman | Time: 3:00 to 4:00 pm | Location: S322- Benchmarking Sessions
    • Step 1: Scoping- Gathering Requirements
    • Step 2: Mock up Design (Excel Data Policy)
    • Step 3: Universe Creation (Data Validation)
    • Step 4: Data Connectivity (Ex: QaaWS, Live Office, Cross Domain Policy)
    • Step 5: User Acceptance Testing (UAT)
    • Step 6: Production (Dashboard Launch)
    • Step 7: Change Management (Training & Knowledge Transfer)

Wednesday, May18th

  • INTERVIEWER: Live Interview with Bridgette Chambers (CEO, America’s SAP User’ Group) | Time: 4:30 to 5:00 pm | Location: ASUG Studio

I also want to thank all the folks at SAP and ASUG that have been working with me over the last couple of weeks to make this all possible! Look forward to seeing everyone there!

Mico Yuk is a 2010 SAP Mentor and the founder of the Xcelsius Guru Network, the Everything Xcelsius blog, and co-founder of Benchmarkers Business Intelligence. To learn more about her, please visit our About Us page.