Archive for the ‘Xcelsius Training’ Category

Jun
25

Learn ‘Big Data Visualization Storyboarding and Wireframing Techniques’ like never before!

As you all know, we live in an era where ‘Big Data’ has indeed become an important core component in every industry. When data is used to its full potential, companies can maximize their marketability, generate more revenue, and even create disruptive innovation. However, to be effective, it is critical that the data be presented in a manner that users can easily analyze and interpret. Data visualization storyboarding and wireframing techniques are just some of the key strategies needed to start building effective visuals for your organization.

Join me this Thursday, June 26th at 12 pm EST, for BI Dashboard Mastery 2.0 and learn how to jumpstart that process, as I will teach the following key techniques:

  • The 2 most important steps you need to take to start your visual storytelling journey today. I’ll share two things that you can start doing immediately to jumpstart your data viz journey! It’s easier than you think :-)
  • The 4 most critical sections that all successful BI Storyboards must have, but 80% of users don’t even know exist! Yes that is correct! You will learn about the 4 key areas that we include on all 400+ dashboards that we have built, and how to start using them!
  • Which free tool you should be using to build your dashboard wireframe to make the process painless! There are over 40 in the market… we will show you our top 3. Remove the guesswork!
  • How to easily create dashboard wireframes that will WOW your users and gain sign off 80% faster. No more struggling through design discussions. No need for a designer. This one tip alone we’re told is worth the entire course!

PLUS!

You get the chance to instantly download some BIDF wireframe templates to use immediately!

Webinar information:

  • When: Thursday, June 26, 2014
  • Time: 9am PST / 12pm EST / 5pm CET
  • Register now: http://bit.ly/QbQh3R

Our last two BI Dashboard Mastery workshops had well over 1200 registrants, so don’t wait last minute to claim your spot!

BIDF Webinar #2 Click here now

Mico Yuk, Founder, BIDashboardFormula.com | Author, Data Visualization for Dummies (Wiley, 2013) | BI Coach | Global Keynote Speaker| Top Analytics Blogger (2012) | Co-Founder, ‘Xcelsius Gurus’ Network & EverythingXcelsius.com. To find out more about Mico, visit http://micoyuk.com

Jun
4

Webinar Rewind: Free Dashboard Design & Requirements Gathering workshop w/ Mico Yuk

About a month ago, Mico hosted her highly rated KPI gathering and scoping techniques webinar, where she demoed the BIDF Blueprint and shared never seen before techniques.

After the webinar, positive feedback just kept pouring in… seriously, we were pleasantly overwhelmed! In all that feedback, we also received emails from folks who just couldn’t make the webinar for various reasons…

Feeling bad that so many folks missed out on the ‘time saving’, ‘wow your users’ type techniques, we decided to do it once again!

Yes! You read correctly, Mico will be hosting the webinar again! This time however, it will only last for an hour, but Mico will cover 3 key points that you will not want to miss!

BIDF Blueprint

What will be covered during the webinar:

  • The 3 most important tweaks you should be making to your BI Dashboards in 2014.
  • Why gathering these three types of requirements in the order we teach you can reduce scope by over 50%, while still increasing user adoption rates
  • How to easily create a dashboard wireframe that will WOW users and gain sign off 80% faster. We’ll show you the free tools to use to make this process painless.

Webinar Information:

  • When: Wednesday, June 11, 2014
  • Time: 9am PDT / 12pm EDT / 5pm CET
  • Registration: http://bit.ly/QbQh3R

BI Dashboard Mastery 1.0

 

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

May
22

Join Mico Yuk at #IBIS2014 in Carlsbad, CA on June 15 – 18!

Join Mico Yuk at IBIS 2014: Limitless BI 2.0 in Carlsbad, California, June 15-18, 2014. This premier SAP BusinessObjects conference offers 3 days of hands-on boot camps, seminars, workshops, and case studies on BusinessObjects Web Intelligence, Xcelsius/Dashboards 4.x, Data Services, Crystal Reports, Migration, and much more.

IBIS2014

This year Mico is heading a half-day, interactive hands-on workshop, described as ‘eye-opening’, at the pre-seminar on Sunday afternoon focused on ‘intelligent’ BI dashboard design. This non-technical, three hour hands-on workshop will provide attendees with the foundation needed to make their analytics more impactful! Whether you are a beginner or a dashboard veteran, this fun filled workshop will take you through the fundamentals of dashboard design and then all the way into real world applications.

The following topics will be discussed:

  • Fundamentals of Dashboard Design – Review of basic and advanced design principles
  • Data Viz Do’s and Don’ts – A clear look at the do’s and don’ts of dashboard design
  • Real World Applications – How to apply the principles of design to real world dashboards
  • Add Intelligence to your Dashboards – Tips and tricks to make your data visualizations more intelligence and impactful
  • Team Exercise: Do you see it? – Each team will be assigned a set of dashboards and asked to identify areas where improvements can be made to make it more intelligent and impactful.
  • Team Exercise: Can you apply it? – Each team is asked to then take their recommendations and apply it to one of the dashboards presented.
  • Open Q&A

Who should attend:

Attendees should have been exposed to, hosted, or participated in at least one full BI project before attending course. Newbies are welcome, but are warned to keep their seat belts on.

Important Information:

With less than 3 weeks left and limited space, don’t wait to register for this compelling learning experience in designing effective BI dashboards and data visualizations.

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

Apr
16

[Free Workshop] How many of these 5 common mistakes are you making with your Dashboards?

Here’s the reality guys, 8 years, 500+ dashboards and 5K+ students later, I’ve finally been able to put my fingers on which mistakes 98% of people make when working with users to create their dashboards. About 3 weeks ago, I taught my highly rated session: Mastering the Art of Dashboard Requirements Gathering and Prototyping, at BI2014. As usual, the time allotted for the session wasn’t enough and I had to skip revealing these 5 common mistakes. However, on April 30th, during a Free 2-hour live online event: BI Dashboard Mastery 1.0 I will complete my BI2014 session by revealing this 5 common mistakes.

 

BI Dashboard Mastery Webinar

 

What will be covered during the workshop:

1) The 3 most important tweaks you should be making to your BI Dashboards in 2014.
2) Why focusing only on these four key aspects of your KPI’s will determine whether or not your project is successful.
3) The 7 most important questions to ask your users to derive ‘intelligent’ Key Performance Indicators (KPIs)
4) Why gathering these three types of requirements in the order we teach how you can reduce your scope by over 50% while still increasing our user adoption rates
5) How to easily create a dashboard wireframe that will WOW your users and gain sign off 80% faster. We’ll show you the free tools to use to make this process painless.

Reserve your spot here: http://bit.ly/QbQh3R. (Recording available for those who register)

I will also be demoing one of my ‘Cheat Sheets’ and making a long awaited announcement! See you there!

Mico Yuk, Founder, BIDashboardFormula.com | Author, Data Visualization for Dummies (Wiley, 2013) | BI Coach | Global Keynote Speaker| Top Analytics Blogger (2012) | Co-Founder, ‘Xcelsius Gurus’ Network & EverythingXcelsius.com. To find out more about Mico, visit http://micoyuk.com.

Sep
5

Live Dashboard Training with Mico Yuk in Zurich at BOAK 2012

I’m sure many of you have heard about Mico’s online training series, the BI Dashboard Formula, that starts on the 6th of September. Well Mico is now taking this training on the road to Zurich, Switzerland, for our ONLY live event on September 19th, as part of the BOAK 2012 Conference.

Mico will be teaching the entire 7-steps of the BI Dashboard Formula live for the first time! See below for details:

  • Step 1. Planning – The Most Important but Overlooked Step
  • Step 2. Scoping – The Art of Gathering Requirements
  • Step 3. Prototyping – Developing the ‘Perfect’ Dashboard
  • Step 4. Validating the Data – Before making False Promises
  • Step 5. Connecting the Data – The Moment of Truth!
  • Step 6. UAT (aka User Attack Testing) – How to get Thru Quickly
  • Step 7. Go Live – Living Through Dashboard Armageddon
  • Step 8. Knowledge Transfer – The key to Job Security
  • Click here to read the full details of each training module on the BIDF homepage!

Registration closes on September 17th, and we have 6 spots left as of this blog post!

  • Where: Zurich, Switzerland
  • When: September 19th, 2012
  • What time: 9am – 4:30pm CEST
  • How to Register: http://bit.ly/PWhvx4
  • What to expect: We’ve been told that being stuck with Mico in a room all day discussing BI is career changing literally. Lots of fun and lots of learning!

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

Jul
18

New Video: Mico’s Dashboard Planning Webcast Recording

Last week Tuesday, Mico and our friends at BusinessObjects Expert co-hosted a webinar on Planning and why it’s the most overlooked step in dashboard development. This webinar served as a preview to Module 1 of Mico’s live online training series, BI Dashboard Formula.

To gain access to the webinar recording follow these 2 simple steps:

  1. Download the Free Planning Guide to follow along
  2. Click here to see why 500+ people registered (hear the LIVE  FAQ’s and download the slides)
  3. Reminder: We ONLY have 9 playbooks left and the $500 discounted registration ends July 31st. Click here to register now.

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

Jul
6

7/10 Webinar: Learn Key Tips and Tricks on HOW to PLAN your dashboards!!

On July 10th at 10am PST / 1pm EST, Mico Yuk will be joining forces with the BusinessObjects Experts site to give you a sneak peek into Module 1 of her almost sold out BI Dashboard Formula - a simple and proven 7-step process used to implement 100′s of dashboards successfully worldwide by the Gurus (discounted registration ends July 30th if space is available).

During this 60-minute webinar you will learn to:

  1. Identify the key steps to starting a successful dashboard project using her Planning Guide (FREE Gift to you)
  2. Learn important tips on how to handle key players in the early stage and extract the most important KPI”s, all during the planning process
  3. Understand what exact resources are needed and how to plan up front before starting the dashboard scoping process

Please bring your questions for Mico, as there will be a 15 minute Q&A after the presentation.

Don’t wait… here is how you can sign up:

(space is limited as we are not hosting it ourselves, and the recording will be available ONLY to those who register for the webinar)

  • Where: Click here to Register Now (or cut and past this link into your browser - http://bit.ly/LtwwQP)
  • When: July 10, 2012 at 10am PST / 1pm EST
  • To Preprare: Visit the BI Dashboard Formula website to sign up for your Mico’s FREE planning guide (the one that she will be using during the webinar)

See you there!

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

Apr
21

Xcelsius and Business Intelligence Web Services (BIWS)

With the limited availability of scalable data connectivity options for Xcelsius, are you constantly seeking  to improve your dashboard performance?  If your answer is ‘YES’, then this post is for you.

Easily connecting to an ‘Enterprise database’ is a well known problem when using SAP BusinessObjects Dashboards (formerly known as Xcelsius). Let’s refer to it as ‘SCDD’ from here on. Traditionally you have two main data connectivity options, namely Live Office and Query as a Web Service, that is until the release of Business Objects 3.1 SP2 which included a 3rd option named BI Web Services.

With BI Web Services (referred to as BIWS going forward), you leverage the web service engine available in Web Intelligence and connect it directly to your dashboard utilizing the QaaWS connector in SCDD.

5 Reasons why you should consider using BIWS:

  1. You can gain simple access via the QaaWS data connection interface
  2. Your data can easily be filtered using the filter properties in the report
  3. You can connect to cached reports to facilitate faster response times and dashboard overall performance
  4. You can filter, drill and prompt from your dashboard without the need to go back to the universe
  5. It will also be available in BI 4.0 (which is what I used for these examples)

To provide insight into the process, I broke it down into a 2 part step-by-step process that includes screenshots.  Keep in mind this was done in a BI 4.0 environment but should work the same in BOE XI 3.1 which is where I originally tested it.

PART 1: SETTING UP YOUR WEBI REPORT AND WEB SERVICE

1.  Launch the Web Intelligence Rich Client. Create your query and basic report. NOTE: Don’t be too concerned with formatting the report at this stage, just make it viewable so that you can review the output.

2.  Save and export the report to the CMS.

3.  In the Webi Rich Client, Highlight a report block and right-click then choose Publish as Web Service. (Note: Report web services are mapped to a report block just like Live Office objects are.)

4.  The Publish Content wizard is then displayed.  Click Next.

5.  Enter the Name of your web service to and click Next.

6.  Define the name of the content block, Set your Filters then Click Next.

7.  Click Publish, and voila! Your web service is created.

8.  Copy the WSDL url and place in a Notepad.  You will need to paste this into the QaaWS data connection in SAP BusinessObjects Dashboards.

The next step is to access the web service from your dashboard.

The BI web service is exposed as the same SOAP interface used by QaaWS. To use the service in your dashboard, you will add a QaaWS connection, Import the wsdl, choose a method and then define the input and output parameters.

PART 2: HOW TO CONNECT TO THE WEB SERVICE FROM YOUR DASHBOARD

1.  Launch SAP BusinessObjects Dashboards.

2.  Open the Data Connection Menu and add a QaaWS connection.  Paste URL into the wsdl URL box and then click Import.

3.  For this example, choose the GetReportBlock_State_Sales_Service from the Method dropdown list.

4.  In the Output Values, bind the table cell to the same number of columns as your web service report block. (Note: Choose as many rows as you think you may need)

5.  Bind the Header cell value to a single row of cells to hold your report block header.

6.  Change the usage to refresh when loaded.

7.  Preview your dashboard.

CONCLUSION: In reviewing the Connection options, you see that using the BIWS is more powerful than using the basic Qaaws connection. You have two methods to use, one for retrieving the full report block the other is for drilling. We will cover drilling in a future post.

TIP: If you want to search for a specific row value, you can set the value to be read from your spreadsheet and bind the operator to the word ‘equals’. There are other options for operator such as ‘greater than’ and ‘less than’.

With BI Web Services and SAP BusinessObjects Dashboards you have a lot of flexibility to provide fast and robust data access to your dashboards, hence improving the performance which is your main goal.

Scott Strool is a Senior BI Consultant for Benchmarkers Business Intelligence, where he helps customers obtain their BI visions. He presented at the 2010 SAP BusinessObjects User Conference in Orlando, FL, and has led many dashboard initiatives. You may follow him on twitter at @scott_strool.

Mar
15

Free Webinar Alert: How to Effectively Price a Dashboard (Xcelsius) Project

Join Mike Alexander (Author, Crystal Xcelsius for Dummies & Microsoft Excel MVP) and Mico Yuk (SAP Mentor & Co-Founder, Benchmarkers Business Intelligence) on Thursday, March 17, 2011, at 1pm EST, for a one hour webinar, titled: “How to Effectively Price a Dashboard Project“.

Anyone in the business of dashboard consulting knows the complexities of pricing out a dashboard project. Between growing scope, increasing complexity, and interactive development, a dashboard project can quickly become a black hole that sucks up your time and resources.

Mike and Mico will show you how to put your arms around the actual scope of the project, breaking up the project into separate fundamental sub-tasks. Then the duo will dive into the most effective ways to layer in pricing. At the end of this webinar, you’ll move away from that generic hourly rate, moving toward a more surgical strike method for building a quote for your potential dashboard clients.

Webinar details:

Also, don’t forget to register for the upcoming Xcelsius Advanced Developer Workshop in Miami, FL on April 19-20, 2011. Register before 04/01 and save $100 during the early bird special. Seats are filling up fast and last year we had a waiting list, so please don’t delay!

Soo Tang Yuk is the ‘Xcelsius Gurus Network” community manager and evangelist. To find out more about her, please visit the About Us page.

Feb
15

Will you be at our Xcelsius Training? (April 19-20, 2011)

Hey Folks,

We’re doing it again in April!  I’d like to formally announce open registration for our highly successful Xcelsius Advanced Developer Workshop (aka Training) that will take place in Miami, FL on April 19-20, 2011. Conducted by Mike Alexander (author, Crystal Xcelsius for Dummies) and myself, this 2-day event is jammed packed with content and always sold out within a few weeks of announcing.

Last year (see pics below) the training sold out (we even had a waiting list, see how packed it was by viewing our album here!), so we encourage everyone to Register before March 31st , to secure your seat and receive the early bird special SAVINGS OF $200.

On the 1st day, the training will cover Basic Data Connectivity Techniques, including, Advanced Dashboarding Techniques. On the 2nd day, we will cover Advanced Data Connectivity Techniques and much more! We will be also be covering SAP Crystal Dashboard Design. To view the entire agenda go to http://xcelsiustraining.com.

Follow us on Twitter or FaceBook for special announcements, as we will be giving away a free seat again this year. Don’t forget the early bird special ends on March 31st, so register today and save $200.

We look forward to seeing everyone there!!  Email us at gurus at everythingxcelsius.com with any questions.

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.