Mastering QlikView Set Analysis
What you'll learn
- Master Set Analysis syntax and write Set Analysis expressions with confidence
- Set Modifier Deep Dive
- Learn how to use Set Identifiers, Modifiers and Operators in Set Analysis Expression
- Learn how to use Dollar-sign, Double Dollar-Sign expansion, expressions within Set Modifier
- Learn how to use Alternate States with Set Analysis
- Learn Useful functions with Set Analysis advanced aggregations
Requirements
- QlikView development
Description
Are you afraid of using one of the most power QlikView or Qlik Sense functionalities, Set Analysis, to build powerful QlikView or Qlik Sense applications because its syntax is daunting? You are not alone!
This course will teach you step-by-step to master Set Analysis so that you can start writing advanced aggregation expressions in QlikView and Qlik Sense with ease!
You will learn basics of Set Analysis first and then dive into advanced Set Analysis concepts to leverage this powerful advanced aggregation functionality in your QlikView or Qlik Sense application.
Who this course is for:
- QlikView developers
- Business Analysts
- QlikView designers
Instructors
Note: Any coupon requests, please contact DV or Shilpan directly.
At Vertechs, our mission is to teach, learn and inspire. We teach QlikView and Qlik Sense and contribute to charity that educates underprivileged kids.
Vertechs means convergence of three focus points.
Our instructors have over 10 years of combined QlikView experience so our courses include their practical experience that can help students to learn and master QlikView quickly.
Deepak Vadithala (aka DV):
DV is a highly skilled and talented architect and developer. Over his 12 years’ experience, DV has continually developed his skills in many areas through both theory and practice, including SQL/BI within Business Intelligence, Data Management, ETL and Report Development/Automation. His specialities include Qlikview 11, QlikSense, HTML, CSS, JavaScript, SQL Server, T-SQL, SSIS, SPSS, Dreamweaver, Photoshop, Illustrator, MS Access, Excel VBA and Google Analytics. He has become an ‘aficionado’ of QlikView, a sophisticated and globally recognised Business Intelligence platform application. DV is a certified Qlik 11 Designer, Developer and Administrator. His Honors and Awards also include:
- Qlik Luminary 2014 and 2017
- QlikView application nominated for Gartner BI Awards 2012
- QlikView application presented during business discovery event 2012
- Certified Scrum Master (PSM)
- Ranked within top 40 contributors on QlikView Community
- Microsoft Certified Technology Specialist (MCTS)
- Technical Reviewer for QlikView Scripting Book
- Microsoft Certified Professional
- JavaScript Enthusiast and Community Contributor
Shilpan Patel:
Shilpan is passionate about sharing QlikView knowledge. He has over 15 years of experience in business intelligence under his belt. Shilpan has broader experience in various verticals including finance, manufacturing, insurance and healthcare.
Shilpan is a certified Qlik 11 Developer and Designer.
Greetings!
I am a Certified QlikView Developer and Designer, Certified Qlik Sense Data Architect and Certified QlikView System Administrator and a Qlik Luminary with over 15 years of experience in Business Intelligence, data warehousing, and various relational database management systems.
With incredible data growth -- both structured and unstructured -- businesses struggle to make sense of data. Business discovery tools such as QlikView and Tableau offer new opportunities to those who want to help an enterprise make insight-driven decisions. That's my passion, and that's my life long purpose.
I enjoy sharing my knowledge in the field of Business Discovery and visual data analytics at my blog. I have developed and implemented numerous QlikView and Qlik Sense applications for banking, health care, and manufacturing.
My goal is to take your Qlik skills to the next level!
I am currently working as a Qlik/BI Architect and managing a team of Developers. I am recognised as a Qlik Luminary for the year 2014 and 2017. Co-Founded Qlik Dev Group and author of QlikShare. Previous top 20 Global QlikView Community contributor. And I am certified, Scrum Master (PSM). Currently, pursuing masters in Data Science from the University of London.
I have been building Data platforms and BI applications since 2005. I had worked on many successful QlikView, QlikSense and SQL Server implementations, right from the inception through the implementation and deployment. My experience and skills range from application development and UI design to system administration. I can work autonomously and directly with business stakeholders at all levels to define requirements; then develop, document, test and deliver end to end projects within existing project management/delivery frameworks.
I am certified QlikView Designer, Developer, Administrator and Scrum Master. Expertise in Clustering setup, data modelling, data analysis, ETL and data migration projects. I have experience in dealing with large datasets (billions of rows). Qlik specialist with many years experience on versions 8.5 to 12, and now Qlik Sense including Sense APIs. Created many extensions and published them on Qlik branch. Certified Designer, Developer, System Administrator and Qlik Sense Data Architect and known within Qlik as a subject-matter expert.
Technical Skills:
Data Science: Python, Pandas, Numpy and D3.js
Business Intelligence: QlikView, QlikSense, SSRS, SSIS and PowerBI
Database: SQL Server and Oracle
Big Data: Apache Hive and Apache Pig
Web: HTML 5, CSS, JavaScript, JQuery, AngularJS and QlikSense API
Design: Photoshop, Illustrator and Coreldraw
Other: Advanced Excel, VBA, VB Script and Scrum Master
Experience in:
1. Investment Banking
2. Retail
3. Advertising
4. Media
5. Technology
BI Developer with Qlik knowledge. Experience of SQL, ETL and Qlik. This includes data visualization, data analysis, set analysis and Qlik scripting knowledge. experience of SQL, ETL and Qlik. This includes data visualization, data analysis, set analysis and Qlik scripting knowledge. experience of SQL, ETL and Qlik. This includes data visualization, data analysis, set analysis and Qlik scripting knowledge.