Category Archives: General

Qonnections 2018 Reflections

I just wrapped up the week at Qonnections 2018.  I found it to be an inspiring conference and the most positive I’ve attended in years.

What was inspiring?  The cognitive insights demo was fantastic.  This is the future of BI.  We have well understood principles and algorithms recently formalized in the discipline of machine learning. Let’s incorporate them in the tool.   If the goal of data visualization is to amplify cognition of data, then I would say cognitive insights is to visualization as visualization is to data.

On the technical front, the previews and demos of elastic cloud and Qlik Core provided me the “aha” moment to understand how the Qlik Big Data Index will be possible.  I can see how many distributed indexing and aggregation engines can provide massively scalable access to a data lake.

The most exciting announcement to me wasn’t technical, but on the commercial side.  For a “small uptick in maintenance”,  QlikView  users will be entitled to use the same license for Qlik Sense.  To me this signals a new strategy for dealing with the two products going forward.  There was also a roundtable discussion on feature gap between the two products and the announcement that some level of pixel-perfect control will be available in Qlik Sense.

Taken together with main stage comments from CEO Mike Capone and CTO Mike Potter,  I’m seeing a needed correction to the “two product strategy” which so heavily favored Qlik Sense.  No one expects QlikView to live forever,  but loyal QlikView customers want to adopt a new product only when they see that it clearly benefits them.   Ideally we will see a converging product that blends the best features and lessons learned from both products.

-Rob

Share

Qonnections 2018

Are you going to Qonnections in Orlando April 23?   I’ll be there and presenting three breakout sessions.  In addition to checking in with colleagues and hearing about what’s new, here are some things I’m looking forward to:

  • Hearing from the new Leadership team
  • Qlik Core!
  • Learning more about subscription pricing
  • Freakonomics!

I’ll be presenting three technical breakout sessions.

148255 – Options and Levels for Qlik Sense Mashup Integration: Tuesday 10:30am  –  This session aims to introduce you to the possibilities for re-using Qlik Sense content and data in other applications such as web pages.  We’ll cover the very simple “codeless”  embedding using URLs all the way through data fetching and custom visualization using enigma.js.   This session is suitable for technical and management staff who want to understand the potential in mashups and get a measure of the effort involved.  My colleague Nick Webster will be joining me in this presentation.

148870 – Automated Testing of Qlik Applications:  Tuesday 3:00pm – A favorite of mine, I’ll be discussing and demonstrating the free regression testing tools from Qlik that allow you to completely automate the QA testing of your Qlik — both Qlik Sense and QlikView — applications.  I’ll also touch on some current trends in unit testing and operational monitoring.

148256 – QlikView Document Performance Tuning Using Document Analyzer:  Thursday 9:30am – Document Analyzer (DA) is a popular free tool that can be used to examine and improve the performance of a QlikView document.  In this session I’ll be showing the tool and my typical approach to improving the response time of a specific document.  Admittedly,  Document Analyzer has little documentation so consider this your DA training session. If you’ve never seen DA,  Dalton Ruer, aka @QlikDork recently produced a  DA intro video.

Other sessions I hope I can make it to:  Nick Webster’s “Putting Qlik in a Mirror” – just for the wow factor;  Göran Sander’s sessions on Butler SOS and SenseOps;  Sessions on Qlik Core and View/Sense coexistence.  Sadly  I’m going to miss Speros Kokenes’ sessions because he’s scheduled at the same time as me.

I’ll also be hanging around in the Discovery Expo — look for the hat at the Masters Summit booth or elsewhere.

Hope to see you there!

-Rob

Share

Spring Holiday Recommendations

Summary: This post has nothing to do with Qlik. It’s a reach out to the community I have built over the years soliciting holiday recommendations.

I have a two week holiday break between the Masters Summit for Qlik in Prague 3 April and Qonnections 23 April.

My wife Linda favors warm so we are heading south.

Through my experience with this site and the greater Qlik Community,  I’ve been  blessed to travel and make  friends all over the world.  So now I’m reaching out to that larger community with a question that has nothing to do to with Qlik or BI.

Should we spend two weeks in Southern Spain or one week in Spain and another in Morocco?

I’m expecting to hear from my Portuguese, Greek and other friends as well 😉

Where would you go with those two weeks in April?

-Rob

 

Share

QViewer Acquisition

I’m pleased to announce that I’ve acquired the excellent QViewer tool from Dmitry Gudkov effective January 1.  I’ll be marketing, developing and supporting QViewer going forward.

QViewer has a stellar reputation as a must have tool for Qlik Developers.  I’m pleased to be taking over such a fine product.

This acquisition is one step in my plan to focus more on software development during 2018.  Stay tuned for other announcements during the year.

Existing licensed QViewer customers should email future support requests to support@panalyticsinc.com.

Happy New Year!

-Rob

Share

Is Data Beautiful? The Art of Adrien Segel

This past spring I enjoyed a glorious week of whitewater kayaking with Noah Weinstein at the incredible Otterbar Lodge on Northern California’s Salmon river.

Noah runs the Artists In Residence program at Autodesk’s Pier 9 Workshop in San Francisco.  Autodesk is a long time big QlikView customer and the Pier 9 Workshop is a working lab that demonstrates and tests practical applications of Autodesk products.

During downtime at Otterbar Lodge, Noah introduced me to the work of sculptor Adrien Segel.  Adrien sources data sets of observations from the natural world and transforms those data into beautiful, fascinating and challenging sculptures.

Adrien’s “Wind at Ravenswood Slough” project visualizes wind speed and direction over a 48 hour period at a single location. The Y-axis (vertical) represents time, the X-axis (length of the bars) represent speed — and here’s the advantage of a physical 3-D rendition — the Z-axis indicates wind direction.

Mount wind-at-ravenswood-pic1the finished sculpture  at the site where the data was collected and you have a deep understanding and delightfully personal relationship with data.  Brilliant!

 

 

 

 

Check out some of Adrien’s other projects like the  Snow Water Equivalent Cabinet  I found this dataset personally  interesting because of my love of rivers and river seasons.  Adrien takes a direct approach in mapping the data and the  result is a functional, fascinating  and intimate piece of furniture.

Can data be beautiful?  I think so.

-Rob

 

 

 

 

Share

Qlik Dev Group SF June 28

Join us at the free QDG event in SF on June 28 from 5:30pm to 8:30pm.  The easy to access location is 44 Montgomery, same building as Montgomery BART.

We’ve got a great lineup in store with David Freriks of Qlik talking about the latest big data strategies, Patrick Vinton  of QlikMaps showing off some innovative GeoSpatial analytics, as well as community presenters Gerry Castellino and Rob Wunderlich covering data heirarchies and automated testing. The full program can be viewed here.

Have you been to a Qlik Dev Group meetup yet?   The meetings are free, volunteer run and take place all over the world.  At QDG diverse speakers from Qlik and the greater community give technical presentations on topics of interest to Qlik Developers.

It’s a place to share technology, practices and tips in a non-competitive, no-selling environment.

If you can join us in SF on June 28, please pre-register here. If you are not in the SF Bay Area, check the QDG site  to find a group in your region.

Hope to see you on June 28!

-Rob

Share

Yoke Dashboard

I was chatting with a colleague recently about trends in BI and I brought up what I call the “commoditization of metrics” .  Google Analytics is an early example of this — your data crunched and delivered at the KPI level.

I recently ran across a great example of the commodity metrics idea:  Yoke.io.

Yoke let’s you build your own dashboard using metrics gleaned from cloud services such as Gmail, Twitter and Github. Here’s a portion of my Yoke dashboard. It’s all built with a few clicks and no coding.

Yoke Image

Give Yoke.io a try, it’s free!

-Rob

Join me at the upcoming “Masters Summit for Qlik” in Milan on 5-7 April. In addition to learning about all things Qlik, we’ll be talking about trends in Dashboarding and BI. 

Share

Preparing for QlikView Version 12

There are a number of reasons you may want to upgrade to QV12, I’ll be posting about them in the next few weeks. Today’s post is specifically about what you must address to upgrade to QV12.

There are two items I’m aware of that you must be aware of and consider before upgrading.

  1. QlikView version 12 Server changes the default permission for the  EXECUTE script statement More details in this post.
  2. In QlikView 12, QVD functions now respect the DIRECTORY statement. This is a breaking change that may cause some of your QV11 script to return incorrect results or take incorrect conditional actions. More information in a post here.

So again, I’ll be blogging about new features you may want to take advantage of,  but above are the only two items I know of that you must consider before upgrading.

How do you know if you are using the impacted EXECUTE statement or QVD* functions? Perhaps you already have a tool in place to answer that question. But if you don’t, my colleagues at the Masters Summit for Qlik are making the Script Repository Tool (“ScriptRepo”) available for public download.

If you have attended a Masters Summit, then you already have a copy of ScriptRepo  in your takeaways.  if not, we would love to have you attend a Summit. But the Masters Summit Team understands the universal need for a tool like ScriptRepo whether you can attend the Summit or not.

The “ScriptRepo” tool extracts script from a directory of QVWs and then allows you to do a global search for script of interest such as “Execute”. Plug in the directory path that contains qvw files,  and a temporary work directory to extract the script into:

384

Press the “Extract & Reload” button and each QVW file in the input directory will be opened and the script extracted. The open is done with “nodata”, so the extraction runs relatively fast — about one qvw per second.

After extraction, you can use your favorite search tool to scan the output directory, or use the builtin QlikView search & display from the “Script Search” sheet.

After searching for “customer” and selecting a candidate qvw:

276

 

I hope to see you at the Milan Summit in April 2016 or a USA location in Fall 2016.  If you have questions about the Summit or using the ScriptRepo tool, let us know through the QlikView Cookbook Contact form or the Masters Summit Contact page.

-Rob

Share

Masters Summit 2016 — Milan

The Masters Summit for Qlik begins it’s fourth year with a date in Milan, Italy on 5-7 April. The Masters Summit is three days of advanced training designed to take your Qlik skills to the next level.

Designed for Qlik Developers who have basic skills and experience,  the Summit presents three days of intense hands-on sessions in topics such as Advanced Scripting and Data Modeling, Advanced Aggregation and Set Analysis, and Visualization Techniques.

We’ve updated our name to “Masters Summit for Qlik” to reflect that the conference now provides training and content for both QlikView and Qlik Sense.

You have some experience with Qlik, have taken the beginning courses. How do you ramp up to create more success with Qlik? Learn from seasoned experts and world class presenters Rob Wunderlich, Barry Harmsen, Oleg Troyansky and Bill Lay.

In addition to the hands-on exercises, you’ll come away with many valuable sample files and documents. You’ll also get a chance to meet and network with Qlik Developers from around the world.

In three years over 500 Qlik Developers have attended eight Summits in Europe and the US. Their feedback is overwhelming positive. Read about their experience here.

The US Summit date is in the planning stages. We anticipate the date will be sometime in September 2016.  Also stay tuned for an announcement of a brand new continent for the Summit in fall of 2016.

An early bird discount is available for Milan so register now.

Share

Masters Summit Guest Speakers

Qlik won’t be holding a user conference in 2015. Why not spend your training time with us at the Masters Summit for QlikView in New York or Copenhagen this fall? In three days of intense hands on training you’ll take your skills to the next level and come home with the knowledge and tools to advance your company’s QlikView program and resolve those knotty problems.

In addition to advanced training from QV experts on scripting, set analysis & aggregation, data modeling, visualization and performance, we are pleased to announce some excellent guest presentations.

Christof Schwarz, Senior Solution Architect at Qlik Austria, will join us in Copenhagen with his bag of tricks for both QlikView and Qlik Sense. Christof’s presentation at the 2014 Amsterdam Summit impressed everyone with his elegant solutions to difficult visualization challenges.

Shima Auzins, former head of the Visualizations and Demo team at Qlik, now with Infozone, will share her rich knowledge in New York City by presenting  some Dashboard Visualization and Design tips that promise to be enlightening.

I hope you can join us at one of the Summits. We get incredibly positive feedback from attendees and continue to collaborate afterwards in a private LinkedIn group.  Register by July 30 to receive a $300 discount!

-Rob

Share