Course Description

Welcome to the Certificate course for the...

Practical QlikSense Business Analyst

This training course will provide the following skills that will empower you to become a Qlik Sense Business Analyst ...

  1. Fundamentals for developing production-quality applications in Qlik Sense
  2. Practical knowledge and understanding of creating dimensions, measures and objects
  3. Practical knowledge and experience in UI design and development
  4. Hands on script and expression coding (including Set Analysis)

Downloadable resources included are

  1. All sample data allowing the student to follow along by creating their own apps
  2. All apps created by the instructor for you to modify/verify your code work etc

Certificate awards

  1. Quizzes testing your practical knowledge and progress throughout the course
  2. Achievement based certificates up to the level of Distinction (add value to your CV and LinkedIn profile)

Lifetime Access

  1. The course never expires, students have permanent access 24/7 x 365 days per year
  2. Course content updates as QlikSense versions are released to market

Online Discussions

  1. Students can create and contribute to course lecture discussions with the instructor and the student cohort
  2. Make suggestions for course improvement and inclusion of new material

Video Quality

  1. All lectures are presented in 1080p HD quality and will scale to any device e.g. Tablets, PC desktops etc

Guarantee 

If within 48 hours of purchase you decide this course is not for you after all (see simple terms) then a full refund is made, no questions asked.

What is there to lose ? Nothing at all !

If you want a practical hands on approach to learning QlikSense and earn an Achievement Certificate that showcases your Qlik Sense skills then this is the only course to take and it will not drain you of many thousands of dollars to develop your knowledge .

QlikSense 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

The skills that you learn in this course are 100% transferable to QlikSense Enterprise and QlikSense Cloud.

Best

Paul

Data Analyst , Qlik Dev, SQL Dev

Awari School of Analytics : Paul Scotchford

Hello and Welcome,My name is Paul Scotchford and I am thrilled that you are reading this.As well as my normal consulting work in Australian business and govt teach I here at the Awari School of Analytics. There are 3 very distinct technology specialisations I work with and these are the QlikView, QlikSense and SQL Server for delivering Data Analytics and Visualisations.QlikView and QlikSenseProfessionally I have been delivering QlikView  solutions to business and government users for the past 5 years and QlikSense since it first released in 2014. Qlik delivers these products to the market and is an industry leader in the BI and Analytics world.SQL ServerI have been delivering data analytics with the SQL Server (Tech Stack) for more than 14 years as this technology (in my humble opinion) is the best Relational Database and Data Warehouse (Mart) product on the market and will continue to be well into the future.SummaryBecause of my passion and experience working with these technologies in the real-world you can be assured that you will be getting first class training from my courses here on Awari School of Analytics.I am super stoked and looking forward to sharing my ongoing experience and passion for data analytics with you. Looking forward to seeing you in one of my courses soon.KindlyPaul

Course curriculum

  • 1

    Course overview

    • Course introduction

  • 2

    Course introduction

    • Welcome, please take a few minutes to read this important note.

    • Study Tips

    • Business Planning 101 For Our Startup

    • Exam INT 1: Basic Business Planning

    • Lets Get Started

    • Download and Install QlikSense Desktop software

  • 3

    The language of metrics and kpi's

    • Understanding metrics and KPI's

    • Exam LAN 1: Metrics and KPI's
  • 4

    Develop an app for Budget analytics

    • Sample Budget Project Data and App

    • Where to find everything for this course

    • Navigating the QlikSense HUB

    • Exam BUD 1 : Budgeting analytics

    • Dimensions and measures

    • Exam BUD 2 : Dimensions and Measures

    • Create your first app

    • Import budget data and more

    • EXAM BUD 3 : Data import

    • Review the data using a pivot table

    • EXAM BUD 4 : Data review

    • Charting budget trends over time

    • Create a budget target KPI

    • How to filter data

    • Review what we have learned in this chapter

    • EXAM BUD 5 : End of chapter

  • 5

    Develop an app for Sales analytics

    • Sample Sales project data and App

    • What will you learn in this chapter ?

    • Review the data using a pivot table

    • Categorized product sales analysis

    • EXAM SAN 1: Sales analysis

    • Gross profit analysis - Part 1 (Using the IF function for filtering)

    • Gross profit analysis - Part 2 (Using the IF function for advanced filtering)

    • EXAM SAN 2 : GP Analysis (Expression logic)

    • Gross profit analysis - Part 3 (Using charting to provide actionable insights)

    • Gross profit analysis - Part 4 (Advanced formatting of the data visualization)

    • EXAM SAN 3 : Data viz and debugging

    • Retail store performance analysis - Part 1 (Prepare for Geo demographics)

    • Retail store performance analysis - Part 2 (Using Geo demographics)

    • EXAM SAN 4 : Basic mapping
  • 6

    Develop an app for Logistics Analytics

    • Sample Inventory project data and App

    • What will you learn in this chapter ?

    • Introduction to Synthetic keys and circular references

    • Loading data and how to fix circular references

    • EXAM LOG 1 : Data integrity

    • Creating a straight table and hierarchical drill down dimensions

    • Creating KPI objects and coding measures

    • Creating combo charts and a conversation about coding Set Analysis

    • EXAM LOG 2 : Calculated dimension

    • A conversation about Set Analysis

    • More about our Set Analysis conversation

    • Coding Set Analysis for measures (Part 1)

    • Coding Set Analysis for measures (Final)

    • EXAM LOG 3 : Set analysis basics
  • 7

    Develop an app for Online Customer Analytics

    • Sample Online Sales project data and App

    • What will you learn in this chapter ?

    • EXAM OCA 1 : Primer

    • Design a new data model and merge like file structures

    • How to discretize data for analysis (e.g. Market Segmentation)

    • EXAM OCA 2 : Banding

    • Understanding resident data loads

    • Using the Lookup() function to query the data model

    • EXAM OCA 3 : Data

    • Transform banded (discretized) data to a visualisation

    • Advanced counting with Sum() , Aggr() and TOTAL

    • Visualising and testing advanced counting

    • EXAM OCA 4 : Counting recap

    • Consolidating objects into a visualisation

    • Geo Mapping (Maps on visualisations)
  • 8

    Develop an app for Payroll Analytics

    • Sample Payroll project data and App

    • What will you learn in this chapter ?

    • The associative data model explained

    • EXAM PAY 1 : Data modelling 101

    • Examine the payroll data set (Part 1)

    • Examine the payroll data set (Final)

    • Introducing new functions RowNo(), Above(), RangeSum()

    • 80/20 Analysis - Part 1 (Combining RowNo(),Above(),RangeSum() functions)

    • 80/20 Analysis - Part 2 (Evolve the basic visualization)

    • 80/20 Analysis - Final (explore a better visualization method)

    • Consolidate everything into a dashboard

    • EXAM PAY 2 : Counting and the Pareto
  • 9

    Develop an App for Profit/Loss Analytics

    • Sample P/L project data and App

    • What's new ? Another take on the compound key and the magic of variables

    • EXAM PLA 1 : Snap Quiz

    • Using variables in QlikSense (Part 1)

    • Using variables in QlikSense (Final)

    • EXAM PLA 2 : Variables

    • Use variables in date calculations

    • Use variables in Set Analysis

    • Coding expression variables

    • Exploiting variables for display formatting

    • The variable with an apostrophe conundrum

    • EXAM PLA 3 : Final on variables
  • 10

    Advanced developer material, enhancing your knowledge and skills

    • Sample Tips/Tricks project data and Apps

    • Create bookmarks and a mention about data story telling

    • Create a data story

    • Share your data story with others

    • Export data (including to QVD files)

    • How to connect to a SQLServer database

    • Scrape web page data sources

    • EXAM BON 1 : Generalist

    • Using Peek() to look into the data model

    • Limiting data quantity at load time

    • EXAM BON 2 : Maintenance

    • Integrate d3 extension library from Qlik Branch

    • Integrating other extensions to enhance the visualization

    • Hyper links and other things

    • EXAM BON 3 : Extending visualisations

    • A conversation about Data Governance for QlikSense

    • Applying Data Governance to your app

    • Exam BON 4 : Governance basics

    • Inventory error solution

    • EXAM BON 5 : Inventory anomoly

    • How to create web mashups

    • EXAM BON 6: Mashups
  • 11

    Course survey

    • Your opinion really does matter (just a quick survey thank you, don't forget if you have done the quizzes a forma certificate will be sent)

Reviews

5 star rating

TUMISO SEKHWELA (9405286188083)

Read Less

Why not enrol in the QlikView Boot Camp to enhance your Qlik skills and while you are at it grab the FREE SQL query code development course.

  • Free

    FreeThe Hitch Hikers Guide to Writing SQL Queries

    Enroll Free

  • $9.99

    $9.99The Complete QlikView Boot Camp

    Buy Now