MAIN MENU

Main Menu

Institute / Trainer Account

Social Links

img

Power BI Training
By
HN Global Solutions

Course Info

Course Description:

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

Topics covered:

Power BI, Qlik Sense, QLIKVIEW

Institute Info

Faculty : ------
Duration : 45 Days
Course Fee : 12,000
Training Type : Online
Batch Type : Regular

Related Courses

Register Now

SEND COURSE ENQUIRY