Skip to content

Qlik Sense Data Architect MasterClass

Introduction to Qlik Sense, Qlik Sense Load Script, Normalized vs De-normalized data structure in Qlik Sense

Arthur Fong

Summary

Price
£19.99 inc VAT
Study method
Online, On Demand What's this?
Duration
3.6 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
  • Reed Courses Certificate of Completion - Free
1 student purchased this course

Add to basket or enquire

Overview

Introduction to Qlik Sense, Qlik Sense Load Script, Normalized vs De-normalized data structure in Qlik Sense

Certificates

Certificate of completion

Digital certificate - Included

Congratulations on completing the course! All the best to you in your future endeavors!

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

3
sections
36
lectures
3h 34m
total

    • 1: 2_Introduction What is BI 02:45
    • 2: 3_Loading Data in Qlik Sense 06:02
    • 3: 5_Introduction Qlik Sense Workflow 04:43
    • 4: 6_Creating Our First Dashboard 06:57
    • 5: 7_Introduction Adding new Columns 01:15
    • 6: 8_Adding New Columns into Table 07:05
    • 7: 9_Introduction Sorting 01:37
    • 8: 10_Sorting in Table 05:07
    • 9: 11_Introduction Chart Interactions 01:31
    • 10: 12_Chart Interaction in Qlik Sense 06:11
    • 11: 13_Table Linkage 07:13
    • 12: 14_Creating Bookmarks 03:12
    • 13: 15_Introduction Variables 01:25
    • 14: 16_Creating Buttons 05:46

    • 15: 1_Load Script Cross Table 04:38
    • 16: 2_Load Script Group By 06:51
    • 17: 3_Load Script Order By 05:32
    • 18: 4_Load Script YTD Fact table 10:01
    • 19: 5_Load Script Master Calendar 12:27
    • 20: 6_Load Script Fiscal Calendar 04:46
    • 21: 7_Load Script Link Table 08:05
    • 22: 8_Load Script Star Schema 02:58

    • 23: 01_1_What is Qlik Sense-converted 05:45
    • 24: 01_Overview - Data Pipelines (ETL)-converted 04:00
    • 25: 02_Normalized Architecture-converted 06:20
    • 26: 03_Denormalized Architecture-converted 10:27
    • 27: 04_Demo_Normalized Data Structure-converted 03:55
    • 28: 05_De-normalized Architecture_Final-converted 12:49
    • 29: 06_De-normalized Mapping_Final-converted 07:48
    • 30: 07_Extracting Fact Table-converted 03:36
    • 31: 08_ApplyMap-converted 06:20
    • 32: 09_IntervalMatch-converted 06:58
    • 33: 10_Date Formatting-converted 05:32
    • 34: 11_Expression Editor-converted 10:21
    • 35: 12_Master_Expression_Final 12:56
    • 36: Conclusion-converted 00:50

Course media

Description

Today, we are all surrounded with full of data.

Data can be in the form of structured data(eg: Tables, worksheets), or unstructured data (free text fields or comments from social media).

An example of Data Usage is in AI model.

Data are the core of an AI model, which utilizes data input for the model to train, test, and learn from the data.

The usage of Machine Learning has allowed computers to perform predictions and provides suggestions to humans based on the data input that has been fed into the machine.

An example of Machine Learning is the Web Search Engine, which tries to understand what is the content we are searching for based on the data input that has been entered into the Search Engine.

Data is everywhere but if we do not extract the data in a feasible manner, are we able to:

1. Comply with Business Model changes on a fast track?

2. Automate the extraction process even if our Business Model changes rapidly?

3. Split up the work of Extraction to Business User to input the data?

If you do not have the answer, join this class to know more about Qlik Sense MasterScript which can help solve your problems.

Who is this course for?

  • Data Analytics Beginner
  • Fresh Graduate in IT
  • Business Intelligence Beginner
  • Business Intelligence Developer
  • Business Intelligence Consultant

Requirements

Anyone interested in Business Intelligence or Data Analysis

Career path

  • BI Developer
  • BI Analyst
  • Data Analyst

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: Data analysis, Business
Related searches: Business analysis courses, Analytics courses, Online courses