Blogs

0

643

The Concat Function

QlikView has many useful and sometimes underused functions that can make your life as a developer a lot easier. One of these is CONCAT(). This should not be confused with the CONCATENATE script keyword.In its simplest form, CONCAT() is used to string together values/words/selections in to one string. However, it can be utilized in a number of ways to help you solve different problems.All of the examples in this post are based on the data in the t... Show More

QlikView has many useful and sometimes underused functions that can make your life as a developer a lot easier. One of these is CONCAT(). This should not be confused with the CONCATENATE script keyword.

In its simplest form, CONCAT() is used to string together values/words/selections in to one string. However, it can be utilized in a number of ways to help you solve different problems.

All of the examples in this post are based on the data in the table below.....

concat data table.png

I have shown a few simple but useful examples below to hopefully help you in your everyday QlikView development!

Simple String Concatenation

As mentioned earlier, the function lets you string together a list of values. These values can be hard coded or driven my selections/data.

=CONCAT(MyColumn,',')

=CONCAT(DISTINCT MyColumn,',')

This simple concat statement would string together all of the possible values from the column MyColumn. You may wish to add the DISTINCT keyword. This would ensure that each value is only displayed once in the string.

ABC,DEF,GHI,JKL,MNO,PQR,STU,VWX

When using a simple concat, you have the option to add a sort weight to the function to order the string values by a column of your choice. In the example below, I have added the date column to sort the values…..

=CONCAT(MyColumn, ',', Date)

Result: JKL,VWX,GHI,ABC,STU,PQR,MNO,DEF

Concat() within an expression/set statement

There are occasions when you want to pass a selection of values to a set statement. To do this I would need to add some single quotes to the string so that the CONCAT() function returns e.g. 'JKL','VWX'. But you cannot have the single quotes as they are, since they then would be interpreted when the Concat is evaluated instead of when the set expression is evaluated. Instead I use the Chr() function:

=CONCAT(Chr(39)&MyColumn&Chr(39),',')

I can then pass this concat statement to the inside of an expression…

=Sum({<MyColumn={$(=CONCAT(Chr(39)&MyColumn&Chr(39),','))}>} Value)

In most instances, this technique would be used where data islands are present. It lets me pass values to an expression that will not affect any part of the data model as the data island table is not joined to it.

Concat() in the Script

Concat can also be utilised in the script to let you convert multiple rows in to one single column value, just as any other aggregation.

Remembering the source data we have earlier in the blog. The result of script side CONCAT can be seen below...

concatscript result.png

Using Rank() to influence the Concat()

When you start to utilise other function in conjunction with concat() you can start to achieve to clever results. In this example, I have used Rank() to grab the top 3 performers (based on Value) and string them together.

=CONCAT(IF(aggr(Rank(sum(Value)),MyColumn)<=3,MyColumn),',')

Result: ABC,MNO,STU

So as you can see, there are a number of uses for CONCAT(). Let's if you can find more!

For more information, please refer to the Technical Brief here.

ABY.

11

46099

With Advanced Analytics, It's People (Not Data) That Stand In The Way Of Change

Now more than ever we are seeing the importance of learning what Data Analytics is and why its a crucial part of everyday business. Today students graduating with a background in analytics are much more likely to be hired due to the lack of employees with analytical skills.To further explain this idea, Forbes released an article recently highlighting the growing skills gap between analytics and employees. To read the full article visit https://... Show More

Now more than ever we are seeing the importance of learning what Data Analytics is and why its a crucial part of everyday business. Today students graduating with a background in analytics are much more likely to be hired due to the lack of employees with analytical skills.

To further explain this idea, Forbes released an article recently highlighting the growing skills gap between analytics and employees.

To read the full article visit https://www.forbes.com/sites/baininsights/2017/10/16/with-advanced-analytics-its-people-not-data-that-stand-in-the-way-of-change/#49fb5a5a3d1c

To help solve this gap, the Academic Program has been teaching analytics to professor and students for a number of years! We encourage you to share all that Academic Program has to offer to professor and students so they too can learn the important skills needed to take advantage of this growing market!

0

158

QlikView November 2017 Technical Preview Release

Qlik customers & partners are invited to join the QlikView November 2017 Technical Preview. This Preview includes new features and improvements like:Analytic connections - With analytic connections, you can integrate external analysis with your business discovery. By configuring an analytic connection (through server-side extensions), you can extend the built-in expression library with support for calling third-party calculation engines, both for... Show More

Qlik customers & partners are invited to join the QlikView November 2017 Technical Preview. This Preview includes new features and improvements like:

Analytic connections - With analytic connections, you can integrate external analysis with your business discovery. By configuring an analytic connection (through server-side extensions), you can extend the built-in expression library with support for calling third-party calculation engines, both for load script and for chart expressions.
WebClient improvements like switch language, Detach, Set reference, Copy single column selection, Copy cell
Shared files management improvements - improved stability, shared file cleaning, PGO buffering
Export in XLSX format - XLSX is now the default exporting format for Excel files, replacing XLS.
BNF script reload mode - A new script reload mode, BNF, has been introduced. It uses the same syntax checks as those in the Script editor.
KML support - QlikView now can read KML files for use in a map visualizations. The KML file can represent either area data, such as countries or regions, or point data such as cities or places.
LEF Control on Maintenance date - When upgrading the QlikView Server or QlikView Desktop, LEF files must be up to date.

Try out these new capabilities and improvements and use the community to give your feedback on this new release of QlikView.

If you have any question or have issues accessing the community please send an email to insight@qlik.com.

4

3289

Qlik Qualification for Students

Last week we announced our brand new Qlik Qualifications, now allowing students to use their QCC knowledge and in classroom BI experience to become an academically qualified student as either a Business Analyst or a Data Architect.But what is the difference between each pathway? Business Analyst This qualification exam tests your basic skills and applied knowledge of the Qlik Sense product. Tested skills include building Qlik Sense visualisa... Show More

Last week we announced our brand new Qlik Qualifications, now allowing students to use their QCC knowledge and in classroom BI experience to become an academically qualified student as either a Business Analyst or a Data Architect.

But what is the difference between each pathway?

Business Analyst

BA Qualification icon.

This qualification exam tests your basic skills and applied knowledge of the Qlik Sense product.

Tested skills include building Qlik Sense visualisations for data analysis, creating master items for business user consumption, incorporating new data from text/Excel files, and understanding how to use and build bookmarks, snapshots and stories for collaboration.

Data Architect

DA Qualification icon.

This qualification exam tests your basic skills and applied knowledge of the Qlik Sense product.

Tested skills include understanding data modelling concepts, generating, debugging and troubleshooting the load script, incorporating new data using external files and data sources, and creating master items for business user consumption.

We're very excited to be able to offer this option for students and assist towards their careers in analytics or where ever that might be. The qualifications can be viewed on the QCC platform through the Academic Program tab.

0

637

Getting More Connected in the Cloud

We are excited to be closing in on the first year of Qlik Sense Cloud Business!One of the main areas of focus this year for our customers and cloud development team has been the addition of a broader range of data connectivity options within Qlik Sense Cloud Business. Recently, you may have noticed the addition of direct data connectivity to the following applications:Bit.lyFacebook InsightsFacebook Pages (expanded tables, including LikesforItem,... Show More

We are excited to be closing in on the first year of Qlik Sense Cloud Business!

One of the main areas of focus this year for our customers and cloud development team has been the addition of a broader range of data connectivity options within Qlik Sense Cloud Business. Recently, you may have noticed the addition of direct data connectivity to the following applications:

Bit.ly
Facebook Insights
Facebook Pages (expanded tables, including LikesforItem, CommentsforItem, and CommentsandReplies)
Google Analytics (expanded tables, including MetaDataColumns, CustomMetrics, CustomDimensions, and Goals)
MailChimp
Microsoft Dynamics
Slack
SugarCRM
SurveyMonkey

Using the New Connectors

Configuration and authentication for these newest connectors is similar to the processes for existing web connectors – after entering your basic account information for the various cloud applications, you can access an authentication code to establish the connection. Look for the new connectors in the data load editor, under Qlik Web Connectors:

cloud blog 1.png

Connectors in Qlik Sense Cloud Business

These new additions help bring more of the core Qlik Sense experience to Qlik Sense Cloud Business. Qlik’s Associative Difference empowers users to easily connect to business-critical data and immediately benefit from the ease of exploring multiple data sources together, at once. That’s why we’ve ramped up connectivity to both cloud and on-premises sources, as well as more flexible options like REST, web files, and Dropbox (coming soon!). The full list of connectivity included in a Qlik Sense Cloud Business subscription now looks like this:

cloud blog 2.png

This recent release of connectors means that Qlik Sense Cloud Business now includes direct connectivity to the three of the market-leading CRM applications, so you can easily dive deeper into customer, sales and marketing data. Interested in creating a CRM dashboard or app? Head over to our demo site and explore the CRM demo app, as well as some other tips and tricks for getting the most out of your CRM data.

More Qlik Sense Cloud Business highlights:

30 Day Trial - The free trial period for Qlik Sense Cloud Business is now 30 days. If you have been interested in learning more about Qlik Sense or experimenting with cloud analytics, take advantage of the extended free trial period to create and share apps. Go to qlik.com/cloud to create a Cloud Basic subscription, then upgrade in-product.
Customer Story - Curious about how other organizations use Qlik Sense Cloud? Hear from Wayne Printy, CFO, LincolnHealth - a Qlik Sense Cloud Know It All!
Learn More - Our Cloud Success Team is always ready to help you get the most of your Qlik Sense Cloud Business subscription. Sign up to attend a live, interactive webinar with the team to get your questions answered and learn more.

2

1639

Limited Load and the First Prefix

Have you ever had an application that takes a long time to reload and you dread making changes to the script because that would require you to wait until the reload is complete to make sure your changes are working correctly? Well QlikView and Qlik Sense both provide options that allow you to test your script without waiting for the entire reload to complete – Limited Load and the First prefix.QlikView and Qlik Sense have Debug capabilities that... Show More

Have you ever had an application that takes a long time to reload and you dread making changes to the script because that would require you to wait until the reload is complete to make sure your changes are working correctly? Well QlikView and Qlik Sense both provide options that allow you to test your script without waiting for the entire reload to complete – Limited Load and the First prefix.

QlikView and Qlik Sense have Debug capabilities that allow you to do a Limited Load. With each product, you can enter the maximum number of records that each Load and Select statement can load. This reduces the execution time of the reload but still lets you to test that the script runs properly. Limited load can be very useful when the data sources are large or when you are testing with live data and want to keep the execution time low.

In QlikView and Qlik Sense, you can access the Debug window from the script editor. In QlikView, you can find it in the File menu or on the toolbar.

QV toolbar.png

The Debug window looks like the image below. You can check the Limited Load checkbox and enter the maximum number of records you want loaded with each Load and Select statement.

QV debug windoe.png

In Qlik Sense, you can also access the Debug panel from the Data Load Editor.

QS toolbar.png

Clicking on the Debug icon opens the Debug panel at the bottom of the page. You can check the Limited Load checkbox and then enter the maximum number of records you want loaded with each Load and Select statement.

QS debug window.png

Another option that can be used to reduce the number of records loaded is the First prefix. This can also be used with a Load or Select statement to set the maximum number of records that are loaded. The difference between the Limited Load and the First prefix is that the Limited Load will apply to all Load and Select statements in the script whereas the First prefix is manually added to each Load or Select statement that it should apply to. For example, I could run the script below to load only 10 customers from the Customers QVD.

The First prefix can be written as it is above or with parenthesis like this: First (10) LOAD. If there are many Load and Select statements in the script, a Limited Load may be easier to use but if there are only a few Load/Select statements or if there is one data source in particular that has a lot of records, then the FIRST prefix may work best.

Keep in mind when using Limited Load or the First prefix that all the data may not be loaded and you may find that visualizations are not showing data or that selections are not providing the expected result. This is really noticeable if you do a Limited Load with only a few records like 5 or 10. When using Limited Load or First, the data that is loaded may not be associated so you may end up with tables in the data model with disconnected data. That is ok, once you do a full reload, everything will look as you expect.

Limited Load and the First prefix both can reduce the execution time of the reload script which can be helpful when you want to just test a script or when you are testing with a live data source. There are times when you need to load all the data in order to ensure that the script logic is working – it all depends on the specific application - but it is good to know when working with large data sources that there are options that can reduce the reload time.

Thanks,

Jennell

10

14100

Are you in need of Data?

Searching for clean data can be difficult but the Academic Program is here to steer you in the right direction! Kaggle provides a wide range of data sets for any classroom or project. If you need data we recommend visiting Datasets | Kaggle.

0

190

Amazing New Qlik Academic Resources FOR YOU!

We are excited to announce the Qlik Academic Program is expanding, and we have BIG news to share! Members currently receive free Qlik software, free training through the Qlik Continuous Classroom (QCC), and a free Data Analytics Curriculum to help professors introduce data literacy concepts to their students.In addition, members will now receive the following:· Qlik Sense Qualification: After learning skills in the QCC, and applying your skills ... Show More

We are excited to announce the Qlik Academic Program is expanding, and we have BIG news to share! Members currently receive free Qlik software, free training through the Qlik Continuous Classroom (QCC), and a free Data Analytics Curriculum to help professors introduce data literacy concepts to their students.

In addition, members will now receive the following:

· Qlik Sense Qualification: After learning skills in the QCC, and applying your skills using Qlik products, you can test your knowledge to earn a Qlik Sense Qualification! Two qualifications are currently available: Business Analyst Qualification and Data Architect Qualification. After passing a two-part exam, you will receive a printable certificate and a digital badge to share on your resume, LinkedIn, and other social sites.

· Data Analytics Curriculum: We have updated and expanded the curriculum!

o Students can now access on-demand videos to learn data literacy concepts at their own pace.

o UPDATED Data Visualization Course: We have added complementary videos with new activities and a real-world, interactive business use case.

o NEW Introduction to Data Analytics Course: We have created a new course which provides lecture materials for professors, handouts, activities and a real-world, interactive business use case.

· The QCC Platform: We have migrated all our resources to the QCC! Now you can access the free training, the curriculum, and the qualification exams all in one place. Simply log into the QCC using your Qlik Account username and select “Academic Program” on the menu at the top of the QCC homepage.

If you are currently an active member of the Academic Program, you will automatically receive access to these amazing new resources. If it's been more than a year since you last applied, we recommend you check us out by visiting http://www.qlik.com/us/company/academic-program. There you can apply as a professor or students and receive access to all these wonderful resources!

0

160

Qlik Learning

A Culture of Data Literacy

When we think of the word “culture”, or phrase “corporate culture”, many thoughts can come to our mind, some positive and some negative. In my first blog post, The Rise of Data Literacy, we spoke of the data revolution and of data literacy itself. But for organizations to succeed with data literacy, the right frame of mind and data literacy culture must exist. What does the phrase “data literacy culture” mean? How can an organization implemen... Show More

When we think of the word “culture”, or phrase “corporate culture”, many thoughts can come to our mind, some positive and some negative. In my first blog post, The Rise of Data Literacy, we spoke of the data revolution and of data literacy itself. But for organizations to succeed with data literacy, the right frame of mind and data literacy culture must exist. What does the phrase “data literacy culture” mean? How can an organization implement and put in place the proper culture to ensure it starts to grow within data literacy and progresses with the data revolution?

To read the full article visit A Culture of Data Literacy | Qlik

1

1062

Qlik Sense September 2017 is now available

Qlik Sense September 2017 is now available from our Customer Download Site. You can also try out many of the new capabilities in Qlik Sense Cloud‌ where you can use Qlik Sense Cloud Basic for free or try Qlik Sense Cloud Business with a free 30 day trial. You will find many new features and capabilities in this release including:For Business UsersWaterfall Chart - You can now illustrate how an initial value is affected by intermediate positive... Show More

Qlik Sense September 2017 is now available from our Customer Download Site. You can also try out many of the new capabilities in Qlik Sense Cloud‌ where you can use Qlik Sense Cloud Basic for free or try Qlik Sense Cloud Business with a free 30 day trial.

You will find many new features and capabilities in this release including:

For Business Users
- Waterfall Chart - You can now illustrate how an initial value is affected by intermediate positive and negative values with the new waterfall chart. For example, you can show the positive and negative contributions of different accounts in an income statement.
- Recent Colors- The color picker in Qlik Sense now displays the five most recent colors selected in Qlik Sense
- Expression Driven Labels – Provides the ability to use expressions in labels for dimensions and measures in property pane. E.g. This allows you to add dynamically calculated values into the labels on your charts.
- Box Plot Chart Improvements – Addition of lasso and range selection, reference lines, and vertical orientation in the box plot chart that was introduced in June.
- Pivot Table Improvements – Ability to expand and collapse all items within a pivot table.
- Data Manager Sequential Operations - Improvements to Data manager enable you to perform sequential transformations on your tables and fields. Where previously you were limited in what transformations you could perform together, such as being able to apply a single data profiling card transformation on a single field, you can now use the data profiling cards, concatenation, calculated fields, and unpivoting data together.
For Administrators
- Centralized Logging - With the introduction of shared persistence, all nodes now have direct access to a common database and file system. The new Qlik Logging Service allows administrators to configure logs to be centralized by collecting all the messages and inserting them into a PostgreSQL database to help find issues and analyze usage.
- Qlik Sense Mobile - This option is only available for customers who have an MDM app store hosted in-house and who have deployed Qlik Sense Enterprise. The Qlik Sense Mobile app can be downloaded fromhttps://vpp.itunes.apple.com

For Developers
- Hierarchical Data API - A new hierarchical data API enables a definition that more closely reflects the visual representation of data. Benefits of the new API: Ensures little to no manipulation or transformation of data structure in the front end. / Simplifies the creation of charts./ Enables more powerful and dynamic charts.
- Visualization API Update – Addition of new waterfall chart.
- Extension Certification Pilot - Initial implementation of a new process for certifying extensions for Qlik Sense.. This is a limited implementation but ultimately we will offer partners the opportunity to apply for certification and to make certified extensions for sale via Qlik Market.

Attached you will find a document which outlines these features as well as an overall view of the improvements that have been released over the past 12 months.

------------

Join us in a city near you!

From October 3rd to November 16th we will be visiting cities around the world for the Visualize Your World‌ tour. Learn how Qlik’s cloud-ready analytics platform delivers value and how Qlik is building on its unique Associative Difference to drive a new wave of analytics across all your data, people, and ideas.

7

6139

FileSize Function

In the past, I have blogged about the FileName function and how I used it to generate data for my Qlik Sense app. Today, I thought I would blog about another file function, the FileSize function. The FileSize function is a script function that can be used to return the size of a file or table. The FileSize function returns an integer for the size, in bytes, of the file specified or a table. The file can be a QVD, a text file, an Excel file or... Show More

In the past, I have blogged about the FileName function and how I used it to generate data for my Qlik Sense app. Today, I thought I would blog about another file function, the FileSize function. The FileSize function is a script function that can be used to return the size of a file or table. The FileSize function returns an integer for the size, in bytes, of the file specified or a table. The file can be a QVD, a text file, an Excel file or a table. The syntax is quite simple:

Syntax:

FileSize([filename])

I have used the FileSize function to determine if a QVD exists before I load it. In the example script below, I set the size of the CustomerMaster QVD to the vSize variable. Then I check the variable to see if a size was returned. If a size was returned meaning a QVD is there, I load the QVD. If the QVD does not exist then the FileSize function will return null.

The FileSize function can also be used to return the table size of the table file being read. To do this, the FileSize function is used in the Load statement as seen in the example script below. When the filename parameter is excluded, then the FileSize function will return the size of the table currently being read. The TableSize field will store the size of the CustomerMaster table after it has been loaded.

The FileSize function is another easy-to-use script file function that can be used in Qlik Sense or QlikView to provide the size of a file or a table. Use the FileSize function as a checkpoint in your script to ensure the file is available before loading, as I did in the example above, or use it ensure size requirements for files being loaded are being met in your app. Good luck scripting!

Thanks,

Jennell

10

8208

Tips to improve your data literacy using Qlik Sense

Hello Qlik Community! Qlik's Bruno Calver is back sharing his in-the-field experiences, building upon his User Experience white paper made available last year. This time he has authored a white paper on Data Literacy. Bruno has worked with many large global enterprises, helping them discover the value in their data and how to best represent it in order to drive results. During this time he has come across many different ways of working with data... Show More

Hello Qlik Community! Qlik's Bruno Calver is back sharing his in-the-field experiences, building upon his User Experience white paper made available last year. This time he has authored a white paper on Data Literacy. Bruno has worked with many large global enterprises, helping them discover the value in their data and how to best represent it in order to drive results. During this time he has come across many different ways of working with data. This article tries to consolidate the key take-aways within the context of data literacy. Be sure to download the attached PDF at the bottom of this post to learn more.

Introduction

Literacy skills have always been top of the bill in the education system -- and for good reason. Equally, data literacy skills are climbing the agenda in today’s competitive business environment.

Organizations will soon rely less and less on pre-processed information and their gut instincts as a decision making paradigm. It is increasingly important for everyone to apply critical thinking skills to every problem and data set in order to achieve a competitive advantage and create truly innovative solutions.

However, for many of us it is not clear what data literacy means, let alone the skills and techniques that might help drive our own data literacy level. The attached article explores these concepts and provides 5 key areas to think about when analyzing your data - including practical examples:

Trends & Context
Internal & External Data
Cohorts & Cell based analysis
Averages, Aggregation & Distribution
Bias & Non-Causal Correlations

Increasing data literacy skills can have a profound impact on organizations in the following ways:

Increasing user adoption and awareness of analytical tools and capabilities
Creating data driven cultures to enhance performance
Unlocking more value from your data investment

If this sounds interesting, then please read the article and see what new things you can discover about the language of data…!

Bruno is a Principal Solution Architect working in the UK with some of Qlik’s enterprise customers. His passion is working with business people to turn disparate and otherwise mundane data sets into insights and stories that can engage their audience, drive change and inspire new ways of thinking.

10

8156

QlikView and Qlik Sense

As most of you have noticed – I hope – we have now released a new product.Qlik Sense.Qlik Sense is not just a new release of QlikView. Instead it is something different. But there are still so many similarities between the two products, so I thought it would be appropriate to dedicate a blog post to differences and similarities between the two.Basically, the two products are two different user interfaces to the same analysis engine. This means th... Show More

As most of you have noticed – I hope – we have now released a new product.

Qlik Sense.

Qlik Sense is not just a new release of QlikView. Instead it is something different. But there are still so many similarities between the two products, so I thought it would be appropriate to dedicate a blog post to differences and similarities between the two.

Basically, the two products are two different user interfaces to the same analysis engine. This means that old scripts and old formulae will (almost) always work exactly the same way as before. (There are some smaller differences in that Qlik Sense uses libraries, and cannot always use relative paths for files.)

Hence, the two products both have the same Green-White-Gray logic; both use the same calculation engine; both have roughly the same response times; and you should use the same considerations for both when it comes to data modelling. This also means that many of the previous posts here on the Design Blog are just as relevant for Qlik Sense as for QlikView.

But the two products are still very different. And just as a parent cannot say that one child is better than the other, I cannot say that one product is better than the other. They are good at different things:

QlikView is a tool for situations where you want prepared business applications, i.e. applications created by developers who put a lot of thought into the data model, the layout, the charts and the formulae; and deliver the applications to end-users who consume the applications. We call this Guided Analytics. The end-user has total freedom to explore data, select, drill down and navigate in the information, and can this way discover both questions and answers in the data. The end-user is however limited when it comes to creating new visualizations. This type of situation will without doubt be common for many, many years to come.
Qlik Sense is a tool for situations where you don’t want to pre-can so much. Instead you want the user to have the freedom to create a layout of his own and in it, new visualizations; charts that the developer couldn’t imagine that the user wants to see. You want Self-service data discovery, which means a much more active, modern, engaged user. In addition, Qlik Sense is much easier to use when you have a touch screen, and is adaptive to different screen sizes and form factors. On the whole, Qlik Sense is a much more modern tool.

Finally, it is important to acknowledge that a piece of software is never ready. It evolves constantly:

Qlik Sense today is only the first version of something that will evolve further and get more features and functions as time goes on. Some of the features and functions of QlikView have not yet been implemented in Qlik Sense – there just hasn’t been time enough – but many of them will be implemented in coming versions.

Also QlikView is not yet a "final product". The product will be developed further, and most likely we will see some of the new functionality from Qlik Sense also in coming versions of QlikView. The goal is to use the same platform for both user interfaces.

With these two tools, we believe that we are well prepared for the future.

HIC

112

129760

Launch of Centre of Excellence in Analytics-powered by Qlik!

Qlik in association with Vidya Jyothi Institute of Technology ( VJIT) launched its first ‘Centre of Excellence- powered by Qlik’ in IT city, also called India’s Genome Valley, Hyderabad on 11 September 2017. This Centre was jointly inaugurated by the Chairman of VJIT and Anurag Institutions, Dr. P Rajeshwar Reddy and Qlik’s Academic Program Manager APAC, Pankaj Muthe. Dr. Reddy is also the Member of Legislative Council ( MLC) in the State of... Show More

Qlik in association with Vidya Jyothi Institute of Technology ( VJIT) launched its first ‘Centre of Excellence- powered by Qlik’ in IT city, also called India’s Genome Valley, Hyderabad on 11 September 2017.

This Centre was jointly inaugurated by the Chairman of VJIT and Anurag Institutions, Dr. P Rajeshwar Reddy and Qlik’s Academic Program Manager APAC, Pankaj Muthe. Dr. Reddy is also the Member of Legislative Council ( MLC) in the State of Telangana and its party Chief Whip.

This event was attended by Professors, Head of Departments of VJIT including its Director Dr. P Venugopal Reddy, Principal Dr. M. Padmaja and Dr. Siddhartha Ghosh-Professor and Training and Placement Head. Representatives from Qlik including Jaydeep Deshpande, Marketing Manager- India and SAARC and Fahad Khan, Solution Architect were also present. Support from team India and especially the Marketing, PR ( APAC) and Pre Sales team has been forthcoming for the successful launch of this Centre. Inputs at various stages were offered by these teams.

The key goal of the Centre of Excellence is to support data literacy and enable Professors and students in analytics through the resources offered under the Qlik Academic Program such as Qlik Continuous Classroom( QCC), analytics curriculum, community support etc.

This Centre would serve as a dedicated point of contact for students and also to Professors at VJIT who wish to collaborate on data analytics in areas of research and industry-academia partnerships in analytics. Professor Dr. Siddhartha Ghosh is facilitating these initiatives on behalf of VJIT.

The Centre would also serve as a point of confluence for ideas, trends and concepts in data analytics to be exchanged not just in VJIT but also for professionals, bodies and experts in analytics in the city of Hyderabad and States of Telangana and Andhra Pradesh.

A computer lab equipped with 70 hi-end computers, UPS, dedicated Server, LCD and a leased line internet connection is available to students as a part of this Centre.

More than 60 students from VJIT are already enrolled into the academic program and have begun training and accessing resources offered by the program. Many of the students dedicate a fixed time every week to train themselves using QCC. The target is to enable 180 students in analytics through the Centre every year.

Prior to the launch, 24 students participated in a hackathon conducted by VJIT and final five were selected to present their findings and demonstrate their apps built using Qlik Sense. Presentations on their apps were made on topics such as ‘The world happiness report’, ‘Analysis of students performance in pre-placement test’, ‘Hidden stories using Qlik Sense’ etc.

In addition, 20 poster presentations on various aspects of Qlik and its technologies were prepared and displayed by students at VJIT.

The Academic Program is growing at healthy pace in India and by collaborating on this initiative, engagement with Universities has moved further and the scope to work together in different activities has opened up. Also with the rapid change and introduction to newer technologies and in the world of analytics, the Centre of Excellence in Analytics is well positioned to facilitate this transition and support students and professors well.

Qlik and VJIT team at the Centre of Excellence in Analytics-powered by Qlik!

VJIT students attending the launch!

One of the students presenting her app on " The world happiness report"

poster presentn.JPG

Poster presentation on Qlik by students!

JD talk.JPG

Marketing Manager-India and SAARC Jaydeep Deshpande addressing the audience

Solution arch fahad demo.JPG

Solution Architect and Regional Champion of the Academic Program, Fahad Khan doing a demo on Qlik Sense

Academic Program Manager APAC, Pankaj Muthe speaking during the inauguration

Video Link : 5514

One of the student shares her experience about the Academic Program and how she's benefitted using the resources available under the program.

0

1000

Qlik Learning

It's Not What You Know, It's What You Can Do

A new blog post is available! In this blog we discuss the need for organizations to innovate and evolve their approach to learning and enablement. Rather than just checking a box once learning has been completed, organizations must ensure their employees can apply the competencies and skills they learned. And at Qlik, we emphasize not just seat-time but mastery of skills. To read the full post visit It's Not What You Know, It's What You Can D... Show More

A new blog post is available! In this blog we discuss the need for organizations to innovate and evolve their approach to learning and enablement. Rather than just checking a box once learning has been completed, organizations must ensure their employees can apply the competencies and skills they learned. And at Qlik, we emphasize not just seat-time but mastery of skills.

To read the full post visit It's Not What You Know, It's What You Can Do | Qlik

0

887

Qlik Sense September 2017 - Coming Soon!

As we shared earlier this year, we will be releasing a new version of Qlik Sense approximately every 10 weeks. Our next release is scheduled for September 2017, just a few short weeks away!Leading up to each release, we are committed to providing a release preview to ensure that you have an opportunity to check out the latest features before they go live. The technical preview for the September releases of both Qlik Sense and Qlik NPrinting can... Show More

As we shared earlier this year, we will be releasing a new version of Qlik Sense approximately every 10 weeks. Our next release is scheduled for September 2017, just a few short weeks away!

Leading up to each release, we are committed to providing a release preview to ensure that you have an opportunity to check out the latest features before they go live. The technical preview for the September releases of both Qlik Sense and Qlik NPrinting can be found on the Qlik Product Insight area of community.

Below you will find a tentative list of What's New in this upcoming release.

Qlik Sense September 2017

For Business Users
- Data Manager Sequential Operations - Improvements to Data manager enable you to perform sequential transformations on your tables and fields. Where previously you were limited in what transformations you could perform together, such as being able to apply a single data profiling card transformation on a single field, you can now use the data profiling cards, concatenation, calculated fields, and unpivoting data together.
- Waterfall Chart - You can now illustrate how an initial value is affected by intermediate positive and negative values with the new waterfall chart. For example, you can show the positive and negative contributions of different accounts in an income statement.
- Recent Colors - The color picker in Qlik Sense now displays the five most recent colors selected in Qlik Sense
For Administrators
- Centralized Logging - With the introduction of shared persistence, all nodes now have direct access to a common database and file system. The new Qlik Logging Service allows administrators to configure logs to be centralized by collecting all the messages and inserting them into a PostgreSQL database to help find issues and analyze usage.
For Developers
- Hierarchical Data API - A new hierarchical data API enables a definition that more closely reflects the visual representation of data. Benefits of the new API: Ensures little to no manipulation or transformation of data structure in the front end. / Simplifies the creation of charts./ Enables more powerful and dynamic charts.
- Visualization API Update – Addition of new waterfall chart.
- Extension Certification Pilot - Initial implementation of a new process for certifying extensions for Qlik Sense.. This is a limited pilot but ultimately we will offer partners the opportunity to apply for certification and to make certified extensions for sale via Qlik Market as appropriate. More about this later.

Qlik NPrinting September 2017
- Report Cycles - Generate a separate report file for each combination of one or more dimension values. Each report will be filtered according with the combination of values that generates it.
- Report Export/Import - It is possible to export a report into a compressed file and import it into a different installation of Qlik NPrinting.
- Object filters for Qlik Sense Charts - Allows you to apply a filter to a single object like a chart without applying that filter to it objects in the report. It can also be used to block filtering of an object so that even though the rest of the report has filters applied, that object doesn't.

6

6822

Cryptocurrency Historical Prices | Kaggle

New Semester, New Data!

As a new semester approaches (in Europe at least, our friends in the US are already hard at work) I have been approached by several Professors about the possibility of new data sets for their students to use in their projects for the coming year.Despite the wealth of data sources out there, it is difficult to know what data you should start with when considering a project or problem to solve. Do you begin with the outline of your project? definin... Show More

As a new semester approaches (in Europe at least, our friends in the US are already hard at work) I have been approached by several Professors about the possibility of new data sets for their students to use in their projects for the coming year.

Despite the wealth of data sources out there, it is difficult to know what data you should start with when considering a project or problem to solve. Do you begin with the outline of your project? defining the issues to solve, only to find the data you require doesn't exist or only available on a paid database, or do you find the data you would like to use and begin to ask questions of it

Either way, I have put together 5 interesting data sets and their websites for possible data analysis;

1. Ecological - Mapping magpies and Blackbird numbers throughout Europe.

Data set - http://mei.org.uk/data-sets

2. Currency - Cryptocurrency Historical Prices.

3. Retail - Walmart Stores Sales

Walmart Recruiting - Store Sales Forecasting | Kaggle

4. Academic - Yelp University data sets

Yelp Dataset

5. All Purpose data sets

https://www.dataquest.io/blog/free-datasets-for-projects/

Datasets

Try putting these into Qlik Sense and seeing what outputs you find.

Happy analysing!!

0

685