Tags
Language
Tags
June 2025
Su Mo Tu We Th Fr Sa
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 1 2 3 4 5
    Attention❗ To save your time, in order to download anything on this site, you must be registered 👉 HERE. If you do not have a registration yet, it is better to do it right away. ✌

    ( • )( • ) ( ͡⚆ ͜ʖ ͡⚆ ) (‿ˠ‿)
    SpicyMags.xyz

    Chatgpt & Qlik Sense: Application Development Master Class

    Posted By: ELK1nG
    Chatgpt & Qlik Sense: Application Development Master Class

    Chatgpt & Qlik Sense: Application Development Master Class
    Published 4/2024
    MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
    Language: English | Size: 16.65 GB | Duration: 22h 32m

    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