Thursday, September 8, 2011

Export & Import XML Document Layout (Video)

Below is a short video I recently completed to show a client how to export the contents of a QVW into a series of XML files for use in a source control program.  I also then show how to create a new QVW from the contents of the XML export.

Sometimes it helps to see it rather than just read about it....

Saturday, July 23, 2011

BI Lifecycle In 2 Hours? Day In The Life of a Solutions Architect

I just came out of a meeting with a prospective customer (not to be named).  Somewhat of a typical meeting with a group of relatively junior IT/BI professionals - all over the place.  The group did the typical beating of the chest about how tools they have today are so good.  Rapid fire questions from all angles quickly sabotage of any kind of flow or sequence that I had in mind for my presentation.  Quick on our feet... In the end it was all good.  They want to see more.

The challenge presented to me for the next meeting is to show them the 'Business Discovery' Development Life Cycle for QlikView.  ETL to Dashboard, Development/Reporting, Publishing of documents, etc.....  Oh, and make the app mobile!  Time allocated for our meeting 2 hours.  Now, some would sweat,  I winder... would the competition can even entertain such a meeting.


If you are familiar with QlikView and understand it is core capabilities well you know from a product perspective it is up to the challenge.  The plan of attack:
  
Keep the data model straightforward but still make it compelling for the customer.  One (no more than two) data sources.  Maybe 3 to 4 tables.  

Step 1: 40 minutes - Back End
  • Build a basic Star Schema
  • Have a Calendar script handy for time savings.
  • Show the evolution of the data model, adding one table at a time.  
    • Populate the main tab with some list boxes from each table - showing the data discovery power of QlikView - before an interface is even built.
  • Show some modest transformations to demonstrate the capabilities of the ETL functions.
  • Show the final Star Schema - speak to the associative model, etc...
 Step 2: 40 minutes - Front End
  • Layout a simple dashboard (2 tabs) - remember - clock is ticking
    • 1st Tab - Dashboard
    • 2nd Tab - Details
    • If you have time for a 3rd insert a tab in between the first 2 with some KPIs around a key dimension such as customer or product
  • Use a basic template - company colors are always a good idea if you can get them before hand (Tip - go to the client website and capture colors from their logo, etc..)
  • Be sure show 3 to 4 different types of visualizations, use of a mini-chart, gauge, bar/combo chart, possibly a scatter if the data accommodates it.
  • If you are doing a mobile demo be cognizant of the resolution you are using.
 Step 3: 30 minutes - Save & Publish
  • Save the document in a place that QlikView Server will see it
  • Setup a distribution (great if you can do a loop/reduce example)
  • Show app in the Access Point and how the end-user would see it.
  • Demo self-service.
  • Pull out your iPad.  Even better - have the customer use theirs! Demo mobile .
Step 4: 10 minute summary and next steps!   or.....Sign here _____________

    Thursday, April 14, 2011

    Mobile BI On IPad .....It Is No Longer Hype

    I have been working with QlikView a long time.  Longer than many in the community.  Those that know me know that I am also an early adopter.  So yes, I had QlikView on my iPhone within an hour of it being available in the App Store.  I quickly followed suit on the iPad, even tested QlikView on the Android while giving the EVO4G a test run from Sprint.

    With all of that testing and playing around (I use those terms purposefully) I was still really waiting for Mobile BI to take hold and start to gain traction in the business.  For a long time is was filled with ideas of what could be but the interface was not quite there yet.  

    It has become clear to me that within the past 6 months (maybe 4 months is more accurate) the hype of Mobile BI could be has passed and reality of what it has become is upon us!  Real mobile BI solutions are being sought out by industry leaders more than ever and now there is a platform for delivery of those solutions.

    Next week QlikView will release the Universal Touch Client as part of the latest service release in version 10 (SR2).  I have been using the beta for about a month and I am so impressed with the stability, usability, and ease of deploying useful Mobile BI apps.  Of course there has to be a down side.... here it is...

    As a QlikView partner my company makes a living on implementation services.  As an evangelist for QlikView I enjoy the countless conversations I have had over the past several weeks with my customers explaining how they leverage their existing investments in QlikView and deploy compelling applications in a truly mobile , touch based interface, quickly, easily, and ....for the most part free.   It is very exciting.  Customers are excited to know they have made an investment in a company that is bringing value to their organization in ways they never event considered when they first purchased QlikView.

    So, will I retire on the revenue from building mobile BI apps in QlikView for existing customer's?  Maybe not, but there a whole lot prospective clients that will find the allure of the QlikView on Mobile solutions we build for Life Sciences and Financial Services that we are happy welcome to the B&D and QlikView community.  This is the hook that will finally land the big fish!

    Check out the latest on QlikView on Mobile!




    Saturday, April 2, 2011

    3rd Party App - Adds Flexibility For QlikView Report Distribution

    Recently I started to review NPrinting 10 for QlikView.  This 3rd party application allows you to distribute not only PDF QlikView Reports but also Excel Reports from your QlikView environment (from server or desktop editions).


    I spent about 30 minutes with the product and I was also able to get a good overview from the creators and I was impressed with its potential.  Especially the ability to dynamically filter data and distribute 'templated' Excel reports from visualizations in QlikView.


    As you may know QlikTech offers a PDF Report Distribution add-on to Publisher Enterprise that simply allows Publisher tasks to distribute QlikView Reports in PDF format.  There is no way to automate (short of macro development) the distribution of reports in Excel.  Also, the cost of this add-on makes it cost prohibitive unless you are distributing to a very large group of people.  NPrinting has the potential to give users a more cost effective entry point into PDF distribution with the added benefit of doing Excel distribution as well.


    See for yourself.... http://www.nprinting.com/

    I will post a more detailed review once I spend a bit more time with the product.

    /emb

    Monday, January 17, 2011

    Meta Tags in QlikVIew 10

    One of the more talked about features missing in prior versions of QlikView is the ability to store Meta Data within a QlikView application.  Short of the 'Help Text' in prior versions there were not a lot of options (you could include a data source with descriptive information on table structures/fields) prior to version 10 but this was more of a work around).


    In QlikView v10 there are more choices for setting up Meta Data tags in the QlikView interface and the script. I will walk through a few different examples of the available features below:


    Expression Comments:
    When using the chart wizard there is a new Expression Comment box within the Expressions tab.  Here you can enter comments or select meta data from a data source to tag some basic commentary about a particular expression.


    Comment Field Highlighted in Yellow
    Consider the image to the right.  Here my expression is expressed in a variable that could have easily introduced into my application from a data source (a repository of expressions).  I am describing the what my variable '$(vGoals)' means using plain text.  I can also read this from the same data source as the expression itself allowing for meta data regarding expressions to be maintained outside of my QlikView application and leveraged across many applications.


    Document Properties/Tables:
    When you view the Document Properties (Tables Tab) in QlikVIew 10 there is a new option ('Edit Tags') when you highlight a field with the field list. 
    Edit Tags within Document Properties/Tables Tab
    Looking at the image to the left, I selected the field 'G' and selected the Edit Tag button in the footer.  A new Edit Tags dialog box appeared where I selected 'Add' to add additional Meta Data to this field.


    There is no limit to the number of tags that can be added here.  You will also noticed that there some existing Meta Data provided by QlikView on the type of field. In this case we can see that the field 'G' is numeric and is of the type integer.


    Table Viewer - Mouse Over Field
    Once I add my own set of tags you can see these tags show in the table viewer when you mouse over the field name.  In my example to the right you can see 'Goals Scored By Player' and 'Puck Goes In The Net' as an example of descriptive tags entered in the interface above.


    Adding Tags in the Script:
    Meta Tags can be added via the script using a Mapping Load and the Tag Function.  Using the same example above I have an external source that has the field names and some meta data descriptions.  Using the script sample below I can load the Meta Data using a Mapping Load in conjunction with the Tag command:
    Use of Mapping Load and the TAG Function

    The Tag function provides a way of assigning tags to a field. Field names not present in the document are ignored. If conflicting occurrences of a field or tag name are found, the last value is used.
    A field tagged with dimension will be displayed at the top of all field selection controls in QlikView except in the Edit Expression dialog.
    A field tagged with measure will be displayed at the top of all field selection controls in the Edit Expression dialog.  Examples of where these tags display are below:



     
    Table Viewer
    Select Fields Dialog
    Chart Wizard
    These new features are welcome additions to QlikView in helping you better track Meta Data in your QlikView applications.  Your users will appreciate the added value of having Meta Data descriptors when trying to enhance their QlikView applications.

    /emb