Qlik Sense Certification - The Complete Practical Course
What you'll learn
- Begin with the Data Manager to load & shape data in our first app
- Understand associative model concepts
- Create sheets with charts, tables and KPIs
- Understand the 4 application tier types
- Alternate states for comparative analysis
- Star and Snowflake schema types
- How to build data models based on user requirements
- Load data from different data source types
- Understand Joins, IntervalMatch, Crosstable , FirstSortedOrder ,Rank
- Incremental loads with sub routines for flow control
- Slowly Changing Dimensions
- Validate the data using different techniques
- Create technical requirements and design sheet layout
- Using element (E) & (P) functions inside a set expression
- The power of canonical calendars and their use
- Geo Analytics with switchable metrics
- Master Items e.g. Measures, Dimensions & Visualisations
- Security e.g. Data Reduction
- Mashups and data story telling
- Migrate QlikView documents to Qlik Sense
- Code Set Expressions - Simple to complex including date range expressions
- Development using the D A R concept , common in enterprise solutions
- Explore the Qlik Sense visualisation bundle features
- Understand the theory behind the scenes to fully appreciate Qlik Sense , explained in vivid detail
- Code pre-aggregations and flags in your load script
- Write efficient data load scripts
- So much more is covered in this course beyond what is included in this list
- Practice with assignment exercises to refine your skills
- Answer the quizzes to be sure of your knowledge
- All recorded in HD 1080p with code zooming so you don't miss a thing
Requirements
- QlikSense is a Windows based architecture hence a Windows PC is required (or use a VM/Docker running windows on a Mac)
- All software and data downloads are provided for this course
- Basic understanding of Excel and formula creation such as functions like Sum()
- Basic understanding of SQL concepts (Although you are guided through this in the data load scripts we code)
- Basic understanding of data (e.g. Data Types, Files, Database concepts)
Description
1st Dec 2021 - A Message from a student via LinkedIn "After several years developing Qlik apps, I recently earned the Qlik Sense Business Analyst certification! Many thanks to Paul Scotchford for the amazing Udemy prep course which turned out to be an invaluable resource."
Yes this course delivers what it is designed to deliver ...
I will guide and instruct you in real world Qlik Sense data analytics project development that will boost your skills and confidence to go for that job or promotion you really want or take on the certification exams. Either way you are guaranteed to learn more in this course than any other Qlik Sense course that is currently available anywhere.
This is the only course you need to become expert in developing Qlik Sense apps that will prepare you to take the Qlik Sense Data Architect (QSDA) and Business Analyst (QSBA) certifications !
"More than 50k organisations in more than 100 countries around the world depend on Qlik to help them drive smarter, faster decisions every day."
With Qlik Sense being so popular (used by > 50,000 companies) in the data analytics and data science world the time is right for you to get on board and become highly proficient and employable in this rapidly expanding world of business intelligence , data analytics and data science.
It's not just medium to large corporations deploying web and mobile apps for data analysis and data science outcomes; but also large government organisations & educational institutions world wide.
You can view the Qlik customer listing on their site and it's impressive! Can you picture yourself working for one of those companies ?
FAQ …
What if I don't want to do a certification right now?
No problem, this course is highly detailed so you will still become very competent in the development of Qlik Sense apps.
Can I learn at my own pace as my time is limited ?
You sure can as you have life time access 24/7 ! Just study to your schedule.
I've never used Qlik Sense will this course be too hard for me ?
If you like a challenge and follow the lectures carefully , code along then you will get to know Qlik Sense quickly and at your pace of learning.
What if the course is not for me ?
No problem ! You can get your money back with the Udemy 30 day refund offer - it's a win win proposition.
So what are your waiting for ?
Take action , sign up and invest in your self and your future !
Who this course is for:
- If you want to learn Qlik Sense completely from scratch then you should take this course
- If you have some rudimentary Qlik Sense skills and want to develop them further then you should take this course
- Even if you are good with Qlik Sense and want to advance much further then you definitely should take this course
- If you are planning on sitting the QSDA/QSBA certification exams you should take this course to fill in the your knowledge gaps to pass the exams
Instructor
G'Day and Welcome,
When I get reviews like this one "oh my goodness. I cracked an Interview using this course" then I know my Qlik course material is hitting the spot and delivering career solutions for my students ...
--------------------------------------------------------------------------------------------
October 2021 News: Just released - Full content update for the "Certificate in Qlik Sense Analytics Development" , complete make over , new and revised content along with refined quizzes and code challenges.
--------------------------------------------------------------------------------------------
As well as my normal consulting work in business and government I teach here on Udemy, there are 3 very distinct technology specialisations I work within and these are QlikView, Qlik Sense and SQL Server for delivering Data Analytics and Visualisations. In my downtime I go out and fly as a private pilot (that's my passion too) .
In addition 2 of my Qlik courses are offered on Udemy For Business (UFB) .
QlikView and QlikSense
Professionally I have been delivering QlikView solutions to business and government users for the past 9 years and Qlik Sense since it first released in 2014. Qlik delivers these products to the market and is an industry leader in the BI and Analytics world with more than 50,000 organisations using Qlik products.
SQL Server
I have been delivering data analytics with the SQL Server (Tech Stack) for more than 18 years as this technology (in my humble opinion) is the best Relational Database and Data Warehouse (Mart) product on the market and will continue to be well into the future.
Summary
Because of my passion and experience working with these technologies in the real-world you can be assured that you will be getting first class training from my courses here on Udemy.
I am looking forward to sharing my ongoing experience and passion for data analytics with you.
Looking forward to seeing you in one of my courses soon.
Stay safe and well , looking forward to you joining in the courses.
Kind Regards
Paul