Data Modelling with Qlik Sense - Master Advanced Techniques
Master the intricacies of Data Modeling with Qlik Sense by enrolling in our targeted training program. Gain critical skills in resolving modeling issues, transforming data effectively, managing circular references, generating dynamic datasets, scripting optimization, creating comprehensive calendars, and safeguarding data confidentiality.
Public Pricing
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Subsidies
What you'll learn
- Learn basic data transformation techniques including load statement syntax and field renaming
- Generate dynamic datasets using calculated fields and resident loads
- Implement best practices for maintaining data confidentiality
- Grasp advanced scripting considerations for efficient model performance
- Identify and resolve circular references in data models
- Understand and resolve synthetic key issues in Qlik Sense
- Create a master calendar for effective date-time management in Qlik Sense
Why should you attend?
Data Modeling with Qlik Sense is a specialized course designed to tackle common data modeling challenges and techniques for effective data representation and analysis. The course begins by addressing synthetic keys, explaining their nature and implications, and providing strategies to resolve related issues. Students will learn the importance of avoiding synthetic keys to maintain streamlined data models. The curriculum then progresses into basic data transformation concepts, covering load statement syntax, field renaming, record counting methods, and understanding key fields. This foundational knowledge is crucial for handling data efficiently in Qlik Sense. Circular references are demystified next, with an exploration of loosely coupled tables to prevent model ambiguity. Following this, students are taught how to generate data through calculated fields, use of the 'Where' clause, and resident loads for creating robust datasets. Scripting considerations are discussed with a focus on synthetic and composite keys to optimize script performance. The creation of a master calendar is also covered, highlighting the manipulation of date and time functions within Qlik Sense. Lastly, the course delves into ensuring data confidentiality through security practices.
Course Syllabus
Day 1
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Ratings and Reviews
Instructor
Tarun Sukhani is a distinguished IT and Finance Executive with over 25 years of comprehensive experience in leading enterprise software solutions, business intelligence, and digital transformation initiatives. As a seasoned professional with a multi-cultural background and international work experience spanning the United States, Malaysia, and beyond, he brings exceptional expertise in designing and delivering highly scalable, concurrent, and performant enterprise systems with budgets reaching $100 million.
With an impressive academic foundation that includes a Doctor of Business Administration (in progress), dual Master's degrees in Information Systems Management and Business Administration from Loyola University Chicago, and multiple Bachelor's degrees from prestigious institutions including the University of Chicago and University of Illinois, Tarun combines theoretical knowledge with practical application. His specialization in Business Intelligence, Data Warehousing, Data Mining, and emerging technologies such as Deep Learning, IoT, and Blockchain positions him at the forefront of technological innovation.
As a polyglot developer with programming experience in over 20 languages and technologies, Tarun demonstrates remarkable versatility across the full software development lifecycle. His technical competencies span from traditional enterprise technologies (.NET, Java, C++) to modern frameworks (Python, Ruby, JavaScript/TypeScript) and cutting-edge platforms including Big Data ecosystems (Hadoop, Spark), Machine Learning frameworks (TensorFlow, DeepLearning4J), and Blockchain technologies (Ethereum, Hyperledger). His expertise extends to cloud architectures, DevOps practices, mobile development, and enterprise application integration.
Currently serving as Project Manager and Scrum Master at TopTal, one of the world's most selective consultancies accepting only 3% of applicants, Tarun provides project oversight and hands-on development for Fortune 500 and FAANG companies. His entrepreneurial spirit is evident through his role as Founder and CTO of Abundent, where he leads digital transformation initiatives and develops innovative solutions in facial recognition, fraud detection, and fintech.
Tarun's extensive training and consulting portfolio includes partnerships with premier training providers across Malaysia, Singapore, Europe, and the United States. He holds numerous industry certifications including Certified Scrum Master, Certified Scrum Professional, ITIL, TOGAF, and specialized certifications in Deep Learning and Information Security. His pedagogical expertise, combined with his technical depth, makes him an exceptional educator capable of translating complex technical concepts into actionable knowledge for diverse audiences across government, academic, and corporate sectors.
Instructor Reviews
Tarun Sukhani
IT Executive & Data Science Leader"I attended one of Tarun's Data Science course in Jakarta (CDSS). He was a professional trainer & very knowledgeable in Data Science. In his course, Tarun gave many practical examples & valuable information regarding how to conduct Data Science & it's related components (e.g. Software & Deployment Architecture). In addition to those lessons, he also gave very useful insights on building a career as a Data Scientist."
"He shared his professional insights on data science with a sense of humor that cleared up so many of my questions about the content and real-world applications. Information, tools, and resources given are very useful"
"Tarun is very passionate on the domains and gave numerous insights to support critical business decisions and develop data products to transform daily encounters and processes. He was a professional trainer & very knowledgeable in Data Science. His material is presented through a sequence of brief lectures, interactive demonstrations, great hands-on exercises, and discussions."
"Tarun is the best Data Science lecturer you can find. He is experienced, knowledgeable and humorous, someone who is willing to share generously his working experience and knowledge in the field with the students. "
"Training with Tarun has been awesome. He’s super knowledgable, funny, empathetic and a great educator in general. As someone who didn’t come from a computer science background, his teachings didn’t make me feel stupid or impossible to eventually arrive at being a competent developer. I could understand him as he communicates well & has helped me see the big picture of the computer science field beyond the scope of syntaxes. If you similarly did not come from a CS background and hope to transition into the world of programming but struggle to learn on your own, understand all the foreign & abstract concepts and connect the dots, I think the right person to guide you on your journey would make a big difference. Having someone who’s deep in the field with many years of experience narrow and communicate the relevant areas to focus would also close a big gap from having to struggle and figure out a lot of things on your own. Being able to maintain your interest during your learning journey is important too, thus finding that someone is important. All in all, I would wholeheartedly recommend Tarun and the backend course I took."
"Tarun is a results-driven & inspirational technology leader with a clear vision, direction, and broad-based technology expertise. He is passionate, intuitive, engaged, pragmatic, systematic, agile. His experiences span from small start-ups to complex, global companies, from being technical lead to technical strategist to being the leader of larger group of architecture and engineering teams. Much of his experiences are in the area of Java, Scala, Machine Learning, Neural Networks, Cloud Computing, Data Science and what not. I am truly amazed to experience his breadth & depth of technological expertise and pleasure to be part of his team."
"He was indeed very skilled, knowledgeable and passionate in the data science realm. I was impressed with his business know-how (how the world economy works and how all things can be explain with data, with/without bias) and technical skills in converting data into insights. I will not hesitate to recommend Tarun for any data science related training as I would like to attend more classes myself to learn from the best of the best."
"We’ve been collaborated many times in doing courses for the accountants. He spoke to quiet number of event in our company with various topic regards to accountants need. The collaboration was very smooth and his session definitely made a huge impact on our success. Mr Tarun is a great Professional!"
"Mr. Tarun is a driven, hardworking, and knowledgeable entrepreneur in his field." A broad-minded trainer who embraces change and inspires people to do better every day. Mr. Tarun sets a good example by being enthusiastic and dedicated, and he inspires and motivates others. I am delighted to be working for such personnel"
"Attended "Blockchain Training: An Overview for Business Professionals" conducted by Dr. Tarun. The reference materials are very comprehensive and an excellent means of conveying information. I was very impressed with how this technology works and adapted into business"
FAQ
Frequently Asked Questions About This Course
Courses you may like
Why should you attend?
Data Modeling with Qlik Sense is a specialized course designed to tackle common data modeling challenges and techniques for effective data representation and analysis. The course begins by addressing synthetic keys, explaining their nature and implications, and providing strategies to resolve related issues. Students will learn the importance of avoiding synthetic keys to maintain streamlined data models. The curriculum then progresses into basic data transformation concepts, covering load statement syntax, field renaming, record counting methods, and understanding key fields. This foundational knowledge is crucial for handling data efficiently in Qlik Sense. Circular references are demystified next, with an exploration of loosely coupled tables to prevent model ambiguity. Following this, students are taught how to generate data through calculated fields, use of the 'Where' clause, and resident loads for creating robust datasets. Scripting considerations are discussed with a focus on synthetic and composite keys to optimize script performance. The creation of a master calendar is also covered, highlighting the manipulation of date and time functions within Qlik Sense. Lastly, the course delves into ensuring data confidentiality through security practices.
What you'll learn
- Learn basic data transformation techniques including load statement syntax and field renaming
- Generate dynamic datasets using calculated fields and resident loads
- Implement best practices for maintaining data confidentiality
- Grasp advanced scripting considerations for efficient model performance
- Identify and resolve circular references in data models
- Understand and resolve synthetic key issues in Qlik Sense
- Create a master calendar for effective date-time management in Qlik Sense
Course Syllabus
Day 1
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Instructor Reviews
Tarun Sukhani
IT Executive & Data Science Leader"I attended one of Tarun's Data Science course in Jakarta (CDSS). He was a professional trainer & very knowledgeable in Data Science. In his course, Tarun gave many practical examples & valuable information regarding how to conduct Data Science & it's related components (e.g. Software & Deployment Architecture). In addition to those lessons, he also gave very useful insights on building a career as a Data Scientist."
"He shared his professional insights on data science with a sense of humor that cleared up so many of my questions about the content and real-world applications. Information, tools, and resources given are very useful"
"Tarun is very passionate on the domains and gave numerous insights to support critical business decisions and develop data products to transform daily encounters and processes. He was a professional trainer & very knowledgeable in Data Science. His material is presented through a sequence of brief lectures, interactive demonstrations, great hands-on exercises, and discussions."
"Tarun is the best Data Science lecturer you can find. He is experienced, knowledgeable and humorous, someone who is willing to share generously his working experience and knowledge in the field with the students. "
"Training with Tarun has been awesome. He’s super knowledgable, funny, empathetic and a great educator in general. As someone who didn’t come from a computer science background, his teachings didn’t make me feel stupid or impossible to eventually arrive at being a competent developer. I could understand him as he communicates well & has helped me see the big picture of the computer science field beyond the scope of syntaxes. If you similarly did not come from a CS background and hope to transition into the world of programming but struggle to learn on your own, understand all the foreign & abstract concepts and connect the dots, I think the right person to guide you on your journey would make a big difference. Having someone who’s deep in the field with many years of experience narrow and communicate the relevant areas to focus would also close a big gap from having to struggle and figure out a lot of things on your own. Being able to maintain your interest during your learning journey is important too, thus finding that someone is important. All in all, I would wholeheartedly recommend Tarun and the backend course I took."
"Tarun is a results-driven & inspirational technology leader with a clear vision, direction, and broad-based technology expertise. He is passionate, intuitive, engaged, pragmatic, systematic, agile. His experiences span from small start-ups to complex, global companies, from being technical lead to technical strategist to being the leader of larger group of architecture and engineering teams. Much of his experiences are in the area of Java, Scala, Machine Learning, Neural Networks, Cloud Computing, Data Science and what not. I am truly amazed to experience his breadth & depth of technological expertise and pleasure to be part of his team."
"He was indeed very skilled, knowledgeable and passionate in the data science realm. I was impressed with his business know-how (how the world economy works and how all things can be explain with data, with/without bias) and technical skills in converting data into insights. I will not hesitate to recommend Tarun for any data science related training as I would like to attend more classes myself to learn from the best of the best."
"We’ve been collaborated many times in doing courses for the accountants. He spoke to quiet number of event in our company with various topic regards to accountants need. The collaboration was very smooth and his session definitely made a huge impact on our success. Mr Tarun is a great Professional!"
"Mr. Tarun is a driven, hardworking, and knowledgeable entrepreneur in his field." A broad-minded trainer who embraces change and inspires people to do better every day. Mr. Tarun sets a good example by being enthusiastic and dedicated, and he inspires and motivates others. I am delighted to be working for such personnel"
"Attended "Blockchain Training: An Overview for Business Professionals" conducted by Dr. Tarun. The reference materials are very comprehensive and an excellent means of conveying information. I was very impressed with how this technology works and adapted into business"
Public Pricing
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Subsidies
Ratings and Reviews
Instructor
Tarun Sukhani is a distinguished IT and Finance Executive with over 25 years of comprehensive experience in leading enterprise software solutions, business intelligence, and digital transformation initiatives. As a seasoned professional with a multi-cultural background and international work experience spanning the United States, Malaysia, and beyond, he brings exceptional expertise in designing and delivering highly scalable, concurrent, and performant enterprise systems with budgets reaching $100 million.
With an impressive academic foundation that includes a Doctor of Business Administration (in progress), dual Master's degrees in Information Systems Management and Business Administration from Loyola University Chicago, and multiple Bachelor's degrees from prestigious institutions including the University of Chicago and University of Illinois, Tarun combines theoretical knowledge with practical application. His specialization in Business Intelligence, Data Warehousing, Data Mining, and emerging technologies such as Deep Learning, IoT, and Blockchain positions him at the forefront of technological innovation.
As a polyglot developer with programming experience in over 20 languages and technologies, Tarun demonstrates remarkable versatility across the full software development lifecycle. His technical competencies span from traditional enterprise technologies (.NET, Java, C++) to modern frameworks (Python, Ruby, JavaScript/TypeScript) and cutting-edge platforms including Big Data ecosystems (Hadoop, Spark), Machine Learning frameworks (TensorFlow, DeepLearning4J), and Blockchain technologies (Ethereum, Hyperledger). His expertise extends to cloud architectures, DevOps practices, mobile development, and enterprise application integration.
Currently serving as Project Manager and Scrum Master at TopTal, one of the world's most selective consultancies accepting only 3% of applicants, Tarun provides project oversight and hands-on development for Fortune 500 and FAANG companies. His entrepreneurial spirit is evident through his role as Founder and CTO of Abundent, where he leads digital transformation initiatives and develops innovative solutions in facial recognition, fraud detection, and fintech.
Tarun's extensive training and consulting portfolio includes partnerships with premier training providers across Malaysia, Singapore, Europe, and the United States. He holds numerous industry certifications including Certified Scrum Master, Certified Scrum Professional, ITIL, TOGAF, and specialized certifications in Deep Learning and Information Security. His pedagogical expertise, combined with his technical depth, makes him an exceptional educator capable of translating complex technical concepts into actionable knowledge for diverse audiences across government, academic, and corporate sectors.
Courses you may like
FAQ
Frequently Asked Questions About This Course
Our Offers
Academy for Trainers Academy for Trainers
Teach what you love. Abundent Academy gives you the tools you need to run your own trainings! We provide you with the platform, the students, the materials, and the support you need to succeed!
- Higher trainer payouts
- Ready-made course materials
- Student management system
- AI digital marketing assistant
Academy for Corporates Academy for Corporates
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to learning paths and roles! Perfect for companies looking to upskill their workforce and stay ahead in the tech industry.
- Carefully curated courses
- Role-based learning paths
- Team progress tracking
- Gap Identification and Analysis
Academy for Partners Academy for Partners
White-label IT training delivery for training providers. We become your behind-the-scenes delivery arm so you can say yes to more clients without hiring more trainers.
- Expand your training catalog
- 40+ expert trainers ready
- White-label delivery
- You keep client relationships
Top companies choose Abundent Academy
