Chatgpt & Qlik Sense: Application Development Master Class

Skill up with Prompt Engineering and Workflow integration then apply these skills to your Qlik Sense app development

What you'll learn

Construct ChatGPT prompts using formal patterns e.g. Few shot, Meta Language, Template, Game Play, Flipped Interaction

Introduce AI (ChatGPT) into your workflow to increase your productivity exponentially

Create a customised GPT that will be your Business Intelligence and Retail Banking Mentor during this project

Upload sample data to your GPT for analysis and design considerations

Use your GPT to model & structure the Qlik Sense data model that is used within the app

Write-Test-Run SQL created by your GPT

Develop Qlik Sense load scripts via your GPT

Set Expressions that your GPT creates for you to use in visualisations

Updating your GPT with project documentation that it generated during your data modelling chats

Your GPT assists with complex development e.g. Master Calendar and Bridge Table creation

Requirements

A Windows PC (or virtual Win PC) to run Qlik Sense (Software is included in the course)

A basic understanding of Excel as some of the functions we use are similar e.g. sum()

A basic understanding of relational databases e.g Tables contain data rows

A browser with an internet connection (of course)

A ChatGPT account (if you have access to GPT4, Team or later that's better)

Be prepared to work hard at this course as there is a lot to learn, which pays off in the end

Description

There's a popular quote doing the rounds …  "AI will not take your job, but someone with AI likely will ! " 21st Century progressive corporate leaders are insisting on their teams acquiring AI literacy skills to make them more productive or risk being let go in favour of more AI skilled personnel.No doubt you may have watched loads of videos online about AI ! But none are really teaching you how to use it as part of your day to day project work , be it software, business intelligence, process development etc. Using AI's (LLM's) like ChatGPT requires a mindset that shapes your productive interaction (Dialog & Conversation) with the Large Language Model (LLM) .Without this mindset your conversations can be unproductive, long winded and useless thus getting you nowhere fastIn this course I will teach you the key skills and a mindset that you can use immediately at work for developing Qlik Sense business Intelligence apps. Key  Points…This is a serious hands on development course with plenty of practical mini projects for you to do as well as dozens of quizzes to test your knowledgePrompt Engineering patterns , patterns enable effective LLM communicationAI as a development methodologyApplying diverse prompt patterns during your development of Qlik Sense data analytics applicationsOur hands on project work will extract real data from a PostgreSQL db into our Qlik Sense Retail Banking App, ChatGPT via a personalised GPT will assist you with the majority of  the developmentAll data and apps are included in the course for you to practice withTake a look at the course curriculum and you'll see how comprehensive your learning will be.Don't forget AI is here to stay, so rather than hide from it we can embrace it and use it to our advantage to make us better developers.As such ChatGPT can be our go to expert to enhance the work we do and increase our productivity when developing Business Intelligence solutions for our clients and users alike. Don't get left behind!

Overview

Section 1: ChatGPT : A Primer for Prompt Engineering and Language Models

Lecture 1 Course Overview

Lecture 2 ChatGPT - That expert you always wanted by your side at work

Lecture 3 Is Prompt Engineering Important or Not ?

Lecture 4 The Chat User Interface and Settings (Part 1)

Lecture 5 The Chat User Interface and Settings (Part 2)

Lecture 6 How do LLM's work ?

Lecture 7 The Unpredictability Of Output

Section 2: Harnessing Prompts, Strategies, Patterns, and Advanced Techniques for Navigating

Lecture 8 What is a Prompt ?

Lecture 9 Prompt Influence

Lecture 10 With Prompts Everyone is a Programmer !

Lecture 11 Patterns for LLM's and the Persona Pattern

Lecture 12 Adding more information to the LLM

Lecture 13 Prompt Size Limitations

Lecture 14 Thinking of Prompts as Conversations

Lecture 15 Root Prompts

Section 3: Evolving Conversations with Patterns

Lecture 16 Question Refinement Pattern

Lecture 17 Cognitive Verifier Pattern

Lecture 18 Audience Persona Pattern

Lecture 19 Flipped Interaction Pattern

Section 4: Mastering the Few-Shot Prompt

Lecture 20 The Few-Shot Prompt

Lecture 21 Leveraging Few-Shot Learning for Actionable Intelligence

Lecture 22 Advanced Problem Solving with Few-Shot Prompts

Lecture 23 Refining Few-Shot Prompt Writing

Lecture 24 The Zero-Shot Prompt

Section 5: Large Language Model Proficiency : Reasoning, Coding and Self-Evaluation

Lecture 25 Chain of Thought Prompting

Lecture 26 AI-Driven Programming

Lecture 27 Using the LLM to Grade Itself

Section 6: Harnessing LLM Flexibility : Innovative Strategies for Enhanced Conversations

Lecture 28 The Template Pattern to Format Output

Lecture 29 Meta Language Pattern

Lecture 30 The Recipe Pattern

Lecture 31 Game Play Pattern

Lecture 32 Alternative Approaches Pattern

Section 7: Perfecting LLM Interactions for Optimal Results

Lecture 33 Ask for Input Pattern

Lecture 34 Combining Patterns in Prompts

Lecture 35 Tail Generation Pattern

Lecture 36 Outline Expansion Pattern

Lecture 37 Menu Actions Pattern

Lecture 38 Fact Check List Pattern

Lecture 39 Semantic Filter Pattern

Section 8: AI as a Development Methodology

Lecture 40 Mindset Management

Lecture 41 Bootstrapping the AI Conversation

Section 9: Your Banking Analytics Development Project Starts Here !

Lecture 42 You Just Got Hired to Build a Qlik Application , Now What ?

Lecture 43 The GPT is Your Customized Mentor (Part 1)

Lecture 44 The GPT is Your Customized Mentor (Part 2)

Lecture 45 The GPT Can be Tweaked !

Lecture 46 Generating Questions & Ideas for Stakeholder Meetings

Lecture 47 Identification of Primary Data Sources (Part 1)

Lecture 48 Identification of Primary Data Sources (Part 2)

Lecture 49 Exercise 9.1

Lecture 50 Exercise 9.1 - Demo

Lecture 51 Download and Install PostgreSQL (with pgAdmin)

Lecture 52 Restore the PostgreSQL Project Database

Lecture 53 Using the GPT for Planning and Execution (Part 1)

Lecture 54 Using the GPT for Planning and Execution (Part 2)

Lecture 55 Exercise 9.2

Lecture 56 Exercise 9.2 - Demo

Lecture 57 AI Generated SQL to Extract Data Samples

Lecture 58 Exercise 9.3

Lecture 59 Exercise 9.3 - Demo

Section 10: Creating the Database Model with Generative AI

Lecture 60 Section Work Flow

Lecture 61 Using AI to Analyze a Data Extract

Lecture 62 Documenting Your Project

Lecture 63 Exercise 10.1

Lecture 64 Exercise 10.1 - Demo

Lecture 65 Database modeling 101

Lecture 66 AI Works Out the Relationships Between Tables - The Prompt

Lecture 67 AI Works Out the Relationships Between Tables - Analysis

Lecture 68 AI Works Out the Relationships Between Tables - Testing

Lecture 69 Exercise 10.2

Lecture 70 Exercise 10.2 - Demo (Part 1)

Lecture 71 Exercise 10.2 - Demo (Part 2)

Lecture 72 AI Works Out the Relationships for Bulk Tables - The Prompt

Lecture 73 AI Works Out the Relationships for Bulk Tables - Analysis

Lecture 74 AI Works Out the Relationships for Bulk Tables - Testing (Part 1)

Lecture 75 AI Works Out the Relationships for Bulk Tables - Testing (Part 2)

Lecture 76 AI Fixes the Orphaned Table Relationship

Lecture 77 Exercise 10.3

Lecture 78 Exercise 10.3 - Demo

Lecture 79 The Final ERD - How We Got Here (Part 1)

Lecture 80 The Final ERD - How We Got Here (Part 2)

Lecture 81 The Final ERD - The Generator Prompt

Section 11: Project Milestone

Lecture 82 Recap of Your Progress and What's Next

Lecture 83 The GPT Suggests KPI's & Metrics (Part 1)

Lecture 84 The GPT Suggests KPI's & Metrics (Part 2)

Lecture 85 Reporting and Visualization Requirements

Section 12: AI Assists With the Associative Data Modelling and Initial Data Loads

Lecture 86 Download and Install/Unlock Qlik Sense Desktop

Lecture 87 What is the Qlik Sense Hub & How to Create an App ? GPT explains !

Lecture 88 Start Building the Qlik Sense App With the GPT's Advice

Lecture 89 A Human Discusses Associative Data Modelling Concepts

Lecture 90 The GPT Outlines the Steps to Connect to PostgreSQL from Qlik Sense

Lecture 91 GPT, Is There a Data Preview Wizard ?

Lecture 92 GPT, Please Explain this Load Script !

Lecture 93 Adding Database and ERD Subject Knowledge to the GPT

Lecture 94 GPT, Please Help Me Write Load Scripts !

Lecture 95 Testing the GPT Load Script for Two Tables

Lecture 96 Exercise 12.1

Lecture 97 Exercise 12.1 - Demo

Lecture 98 GPT Generates Scripts to Load the Remaining Dimension Tables

Lecture 99 GPT Assists With the Fact Table Load

Lecture 100 GPT, How Can I Smooth the Date Gaps in My Data (The Script) ?

Lecture 101 GPT, How Can I Smooth the Date Gaps in My Data ? Converse with the GPT (Part 1)

Lecture 102 GPT, How Can I Smooth the Date Gaps in My Data ? Converse with the GPT (Part 2)

Lecture 103 GPT, How Can I Smooth the Date Gaps in My Data ? Converse with the GPT (Part 3)

Lecture 104 GPT, How Can I Smooth the Date Gaps in My Data ? Converse with the GPT (Part 4)

Lecture 105 Implementing the GPT Generated Script in Qlik Sense

Lecture 106 Help me GPT, I Need to Debug My Script ! (Part 1)

Lecture 107 Help me GPT, I Need to Debug My Script ! (Part 2)

Section 13: Using Your GPT to Learn About Qlik Sense Basic Aggregation Functions

Lecture 108 Update the GPT With Additional Knowledge

Lecture 109 Ask Your GPT How Basic Aggregations Work - Sum()

Lecture 110 GPT Has Generated the Steps to Code a Bar Chart Using Sum()

Lecture 111 There is Something Strange About the Bars on Your Bar Chart !

Lecture 112 Converse With Your GPT to Find a Solution to the Bar Chart Issue

Lecture 113 Ask Your GPT How Basic Aggregations Work - Avg()

Lecture 114 Ask Your GPT How Basic Aggregations Work - Count()

Lecture 115 Pie Chart Looks Odd, GPT Will Diagnose It From An Image !

Lecture 116 Exercise 13.1

Lecture 117 Exercise 13.1 - Demo

Lecture 118 Ask Your GPT How Basic Aggregations Work - (Part 1) FirstSortedValue()

Lecture 119 Ask Your GPT How Basic Aggregations Work - (Part 2) FirstSortedValue()

Lecture 120 Ask Your GPT How Basic Aggregations Work - (Part 1) RangeSum()

Lecture 121 Ask Your GPT How Basic Aggregations Work - (Part 2) RangeSum()

Lecture 122 Use Your GPT To Conduct a Research Assignment

Lecture 123 Ask Your GPT How Basic Aggregations Work - (Part 1) Aggr()

Lecture 124 Ask Your GPT How Basic Aggregations Work - (Part 2) Aggr()

Lecture 125 GPT, Why Do I See Green, Grey, White When Selecting Data ?

Section 14: Can the Large Language Model Assist With Qlik Sense Expression Logic ?

Lecture 126 Update the GPT With Sample Data

Lecture 127 Tailoring a Aggregation Function For Specific Results - GPT Explains !

Lecture 128 Tailoring a Aggregation Function For Specific Results - GPT suggests using If()

Lecture 129 Exercise 14.1

Lecture 130 Exercise 14.1 - Demo

Lecture 131 GPT, Can You Teach Me Set Analysis ? Part 1 - Basics

Lecture 132 GPT, Can You Teach Me Set Analysis ? Part 2 - Coding GPT Samples

Lecture 133 GPT, Can You Teach Me Set Analysis ? Part 3 - Deeper Exploration

Lecture 134 GPT, Can You Teach Me Set Analysis ? Part 4 - Identifiers {$} & {1}

Lecture 135 GPT, Can You Teach Me Set Analysis ? Part 5 - Identifiers {$_1} & {BM ID}

Lecture 136 Exercise 14.2

Lecture 137 Exercise 14.2 - Demo

Lecture 138 GPT, Can You Teach Me Set Analysis ? Part 6 - Set Operator (* Intersection)

Lecture 139 GPT, Can You Teach Me Set Analysis ? Part 7 - Set Operator (+ Union)

Section 15: [D] Dashboard Sheet Visuals Using the GPT (Part 1)

Lecture 140 Your Journey So Far and the Exciting Road Ahead!

Lecture 141 Users Love Maps ! GPT How Do I Add a Map to My Dashboard ? - (Part 1)

Lecture 142 Users Love Maps ! GPT How Do I Add a Map to My Dashboard ? - (Part 2)

Lecture 143 Adding a Master Calendar Drill Down Filter

Lecture 144 Transaction Insights Using KPIs the GPT has Suggested

Lecture 145 Consult the GPT , Are We Seeing a Run On the Bank Based On KPI's ?

Lecture 146 The KPI Money Format is Unacceptable, Can the GPT Can Fix This ?

Lecture 147 Exercise 15.1

Lecture 148 Exercise 15.1 - Demo - (Part 1)

Lecture 149 Exercise 15.1 - Demo - (Part 2)

Lecture 150 GPT Helps With Associating the Master Calendar With Multiple Tables - (Part 1)

Lecture 151 GPT Helps With Associating the Master Calendar With Multiple Tables - (Part 2)

Lecture 152 GPT Helps With Associating the Master Calendar With Multiple Tables - (Part 3)

Lecture 153 GPT Helps With Associating the Master Calendar With Multiple Tables - (Part 4)

Lecture 154 GPT Helps With Associating the Master Calendar With Multiple Tables - (Part 5)

Lecture 155 GPT Helps With Associating the Master Calendar With Multiple Tables - (Part 6)

Section 16: [D] Dashboard Sheet Visuals Using the GPT (Part 2)

Lecture 156 GPT Helps Create a Transaction Volume Visualisation Object

Lecture 157 GPT Suggests Adding a Rolling Average Value To The Transaction Volume Chart

Lecture 158 Exercise 16.1

Lecture 159 Exercise 16.1 - Demo

Lecture 160 GPT Modifies My Script Code to Add Rolling Balances For Accounts - (Part 1)

Lecture 161 GPT Modifies My Script Code to Add Rolling Balances For Accounts - (Part 2)

Lecture 162 GPT Explains the Chart for End Of Day Customer Balance Insight

Section 17: [A] Analysis Sheet Visuals Using the GPT for Inspiration and Guidance

Lecture 163 Purpose of "Analysis" in the DAR Paradigm

Lecture 164 Ask the GPT About Data Elements & Offer Chart Suggestions - (Part 1)

Lecture 165 Ask the GPT About Data Elements & Offer Chart Suggestions - (Part 2)

Lecture 166 Using the GPT for Visualisation Inspiration - (Part 1)

Lecture 167 Using the GPT for Visualisation Inspiration - (Part 2)

Lecture 168 Exercise 17.1

Lecture 169 Exercise 17.1 - Demo - (Part 1)

Lecture 170 Exercise 17.1 - Demo - (Part 2)

Lecture 171 Converse With the GPT for Customer Spend Value - (Part 1)

Lecture 172 Converse With the GPT for Customer Spend Value - (Part 2)

Section 18: [R] Reporting is About the Detail that Leads to Discovery & Insight

Lecture 173 What Does Qlik Sense Reporting Really Mean ?

Lecture 174 GPT How Can I Use the Qlik Sense Pivot Table for Insight ?

Lecture 175 GPT Directs LDR Reporting For TY/LY - (Part 1)

Lecture 176 GPT Directs LDR Reporting For TY/LY - (Part 2)

Lecture 177 Are Charts Possible in Straight Tables ? The GPT Explains ! - (Part 1)

Lecture 178 Are Charts Possible in Straight Tables ? The GPT Explains ! - (Part 2)

Lecture 179 Exercise 18.1

Lecture 180 Exercise 18.1 - Demo

Section 19: Wrap Up

Lecture 181 A Message About AI and Your Work

Lecture 182 How to Retrieve Your Results Based Training Certificate

Anyone that wants to incorporate AI in their workflow and increase their worth and productivity