Power BI Training
By
HN Global Solutions

Qlikview Course Content

Scripting Contents:

• Creating ODBC connections

• OLEDB vs. ODBC
• Loading data from Excel file
• Loading data from Database tables
• Joins
• Keep
• Concatenate
• QVDs
• SET & LET
• Types of loads:

• Preceding Load
• Resident Load
• Buffer Load
• Generic Load
• CrossTable
• Binary Load
• Partial Load
• Inline Load
• Mapping load  

• Synthetic keys and resolving techniques
• Scripting Functions

• Applymap
• RecNo()
• RowNo()
• Peek
• Previous
• Subfield
• Autonumber  - Link Table
• Autogenerate
• RangeSum
• Dual
• Isnull
• Date()             
• Date#() 
• Interval Match 

• Time Dimension/Master Calendar
• Link Table
• Incremental Load techniques

• Insert Only
• Insert and Update
• Insert, Update, Delete

• Include & Must Include

Reporting Contents:

• 13 Charts + Other Sheet Objects
• Fast Type Change
• Set Reference
• Bar Chart vs. Mekko Chart
• Trellis Chart
• Buttons (Show/Hide)
• Displaying no of bars in Bar chart with Input Box
•  Limiting number of field values in list box
• Custom sorting
• Dynamic coloring
• Visual Cues (Conditional Formatting)
• Alerters
• Indicators
• Cyclic Group and Drill down Group
• UI functions:

• Pick
• Match
• If
• FirstSortedValue
• RangeSum
• SubStringCount  - Discussing in Adhoc Reports
• Concat
• Class
• GetSelectedCount - Discussing in Adhoc Reports
• Dimensionality

• Set Analysis (YTD,MTD,QTD,WTD)
• Waterfall Chart

Security:

• Section Access

• Row Level Security
• Column Level Security
• Sheet Level Security
• Object Level Security
• Document Level Security

Advanced Concepts:

• Adhoc Report

•   Dynamic Visibility
•   Alternate States
•   What if Analysis(Predictive Analysis)
•   Document Chaining

Qlikview Server:

• Screenshots of Server overview

• Real time Scenarios
• Faqs Discussion

Qliksense Course Content

• Introduction to Qliksense
• Difference between Qlikview and Qliksense
• Qliksense overview
• Loading Excel file into Qliksense
• Loading backend database tables into Qliksense
• Creation of QVDs
• Various sections in Sheets (Charts, Extension Objects, Master Items, Fields)
• Creating Extension Objects
• Creating Drill down group and Cyclic group in Qliksense
• Binary Load
• Dashboard Development