Certificate in Qlik Sense Analytics Development
What you’ll learn
Business Intelligence & Analytics development
Skills needed to become a data analytics & visualisation engineer
Identify KPI’s,metrics and dimensions from your business requirements
Design and build data visualisations using key Qlik Sense features
Understand the associative data model and how to load data to it
Resolve data integrity and modelling issues like synth keys and circular references
Code expressions for metrics and dimensions, we learn set analysis coding too
Explore downloadable source code & data during your development work here
Requirements
A windows PC (or a Mac with Docker or VM installed) as Qlik Sense is a windows product
Keen to learn new concepts and develop your skills further
Basic understanding of data concepts
Keen to escape excel confusion
Don’t have a Win PC (or Mac), no problem, develop in the cloud using Qlik business trial
Description
This course is also available on Udemy Business Certificate in Qlik Sense Analytics Development (Fully updated October 2021)Data Scientists, Data Analysts are big career topics today, but we still need an efficient and timely method to visualise what we have discovered in the morass of data within our enterprise. Thankfully we have the Qlik suite of products to help us with this and my all time favourite is Qlik Sense, I liked it so much, I took a leave of absence for 3 months to develop this course (and it is continually updated to stay current). If you want a hands on approach to learning Qlik Sense and a certificate that showcases your technical skill then this is the best course for you. Qlik Sense is the next generation of QlikView.Qlik Sense is overtaking so many of it’s peers because of it’s underlying ‘associative data model’ technology and absolute ease of discovery for insightful decision making and story telling.I am sure that once you have completed this course you will not want to revert to the old clunky ways of surfacing your analytics like you did with those products from the older monolithic vendors that will always impose their ways to suppress your work flow and creativity.This course of study is designed to transition your skills into a deep understanding of Qlik Sense application development.The skills that you learn in this course is 100% transferable to Qlik Sense Enterprise and Qlik Sense Cloud (SaaS).Looking forward to seeing you in the course.PaulData Analyst and Visualisation Engineer
Overview
Section 1: Course Objectives *
Lecture 1 Introduction and welcome
Lecture 2 Our start-up needs a business plan, but what is it meant to do ?
Lecture 3 Tune your browser to get 1080p HD all of the time
Lecture 4 Download , Install & Register Qlik Sense
Section 2: The Language *
Lecture 5 Metrics and KPI’s what are they ?
Section 3: Budgeting and KPI (goal) setting *
Lecture 6 Where to find everything
Lecture 7 Introduction to navigating the Qlik Sense hub
Lecture 8 Dimensions and Measures, what are they?
Lecture 9 Create your first application (App)
Lecture 10 The first data load
Lecture 11 Create a Pivot table
Lecture 12 Creating charts and expression sorts
Lecture 13 How to create and use a KPI object
Lecture 14 Introducing the filter pane
Lecture 15 Recap of our app and the Selection Model
Section 4: Data Science for Sales Performance *
Lecture 16 Loading new sales data to the model
Lecture 17 Review and check the sales data
Lecture 18 Learn about Master Items and start using count()
Lecture 19 Changing the scope using conditional expressions
Lecture 20 More advanced expressions to calculate a variance
Lecture 21 How to Visualise Correlation (Scatter Plot)
Lecture 22 Adding more features to the scatter plot
Lecture 23 Geo Analysis (Part 1)
Lecture 24 Geo Analysis (Part 2)
Section 5: Inventory Analytics *
Lecture 25 A conversation about the data we shall use for this section
Lecture 26 Loading data and how to fix circular references
Lecture 27 Loading data and how to fix synthetic keys and circular references
Lecture 28 Using straight tables for data validation (Inc Spark Lines)
Lecture 29 Creating KPI objects and coding metrics
Lecture 30 Creating KPI objects and coding metrics in Set Analysis (Expressions)
Lecture 31 A conversation about coding Set Analysis – Part 1
Lecture 32 A conversation about coding Set Analysis – Part 2
Lecture 33 A continuation of our coding Set Analysis conversation
Lecture 34 Coding Set Analysis for other measures
Lecture 35 How to avoid misleading the user in an expression
Lecture 36 Coding Set Analysis for mapping (GeoAnalytics)
Lecture 37 Coding Set Analysis for tabular display
Section 6: Online Customer Sales Analytics *
Lecture 38 Overview the tons of new stuff in this section
Lecture 39 Make a new model and merge like file structures
Lecture 40 How to discretize data for analysis (Market Segmentation)
Lecture 41 Understand what resident loads are
Lecture 42 What is the Lookup() function ?
Lecture 43 Start creating our visualizations with discretized data (Market Segmentation)
Lecture 44 Using Rank(), Sum(), Aggr() for advanced counting
Lecture 45 Using element function e() for advanced counting
Lecture 46 Using element function p() for advanced counting
Lecture 47 Bringing it all together on a dashboard sheet
Section 7: Payroll Analytics and Pareto analysis *
Lecture 48 Introducing Payroll with some cool new functions
Lecture 49 Data modelling 101 in Qlik Sense
Lecture 50 Create a data review sheet with a special type Pivot Table
Lecture 51 Combining functions the RowNo(), Above() and RangeSum() for 80/20 analysis
Lecture 52 How to do 80/20 analysis (Pt 1)
Lecture 53 How to do 80/20 analysis (Pt 2)
Lecture 54 InLine load and Salary Distribution
Lecture 55 Bringing it all together – Part 1
Lecture 56 Bringing it all together – Part 2
Section 8: Profit performance including the magic of variables *
Lecture 57 Section 8 Overview
Lecture 58 Lets explore another example of a compound key
Lecture 59 What is a variable and how do we use them in Qlik Sense ?
Lecture 60 Defining variables and revealing them in the debug window
Lecture 61 Build a bar chart using the canonical calendar & variables (Part 1)
Lecture 62 Build a bar chart using the canonical calendar & variables (Part 2)
Lecture 63 Replacing chart expressions with expression variables
Lecture 64 Setting variables with date functions in Set Expressions – Part 1
Lecture 65 Setting variables with date functions in Set Expressions – Part 2
Lecture 66 Write YTD/MTD dates in a variable
Lecture 67 Visualise cumulative values from variables – Part 1
Lecture 68 Visualise cumulative values from variables – Part 2
Section 9: Tips and Tricks (Common developer requirements) *
Lecture 69 Section 9 Overview
Lecture 70 How to create a bookmark and set default page
Lecture 71 How to create your story – Part 1
Lecture 72 How to create your story – Part 2
Lecture 73 Store data from Qlik Sense into a QVD
Lecture 74 Using web page data for charts
Lecture 75 The Master Calendar – Part 1
Lecture 76 The Master Calendar – Part 2
Lecture 77 How to use extensions from Qlik Garden
Lecture 78 Linking to sheets and external URL’s
Lecture 79 Data Governance & the Metadata Dictionary – Part 1
Lecture 80 Data Governance & the Metadata Dictionary – Part 2
Lecture 81 Data Governance & the Metadata Dictionary – Part 3
Lecture 82 How to create mashups in Qlik Sense – Part 1
Lecture 83 How to create mashups in Qlik Sense – Part 2
Section 10: Retrieving your Achievement Certificate
Lecture 84 Instructions to retrieve your graded certificate
Anyone that wants to learn QlikSense from scratch and get productive at work quickly,Supplement your learning towards certification,Analytics Prоfеѕѕiоnаlѕ,Developers looking to supplement what they already know about Qlik Sense,BI/ETL/DW Professionals,Prоjесt Managers,Job seekers looking to answer tough interview questions (tons of quizzes to help you with this),Buѕinеѕѕ аnd Rероrting рrоfеѕѕiоnаlѕ,Grаduаtеѕ building a career in data Visualisation & Anаlуѕiѕ,QlikView Developers and Users looking to update to Qlik Sense,Data Scientists looking for alternate visualisations besides ‘R’, Python, SAS etc
Course Information:
Udemy | English | 13h 52m | 5.74 GB
Created by: Paul Scotchford
You Can See More Courses in the Business >> Greetings from CourseDown.com