Chatgpt & Qlik Sense Application Development Master Class

Free Download Chatgpt & Qlik Sense Application Development Master Class
Published 4/2024
MP4 | Video: h264, 1920×1080 | 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

Homepage

www.udemy.com/course/chatgpt-qlik-sense-application-development-master-class/