Qlikview training

Page 1

NameTraining QlikviewCourse Online

TekSlate.com


Course Name About QlikView QlikView is a comprehensive business intelligence platform providing powerful business analytics to a broad range of users throughout the organisation. The QlikView suite is designed for application development and data extractions, efficient information distribution and powerful analysis for either the power user or end-user. QlikView can be deployed both offline and online leveraging a range of industry leading technologies. QlikView Client is a stand-alone Windows client provides the full developer’s ETL and end-user application to develop, deploy and analyse QlikView applications. QlikView Publisher ensures that the right information reaches the right user at the right time. Developed for larger user environments, QlikView Publisher gives further centralised administration and management. QlikView Publisher allows for complete control of the distribution of a company’s QlikView applications through QlikView AccessPoint also automating the data refresh process.

TekSlate.com


Qlikview Course Content Introduction What You Will Learn in this Course, Course Logistics, Notes, QlikView Environment, QlikView Desktop

QlikView Deployment Methodology Import/Export Sheet and Document Layouts as XML, Qlik Wholesale Trade (QWT) Project Plan, Project Plan Review, SAFE Methodology

Deployment QlikView Standalone, QlikView Server, QlikView Publisher Introduction to Data and Scripting

Relational Databases, Other Data Structures, Comparing Database Structures to QlikView Data Structures, Data Structures in QlikView, Data Source Files, The QWT Primary Data Source, The QWT Secondary Data Files, Script Syntax

TekSlate.com


NameContent QlikviewCourse Course Loading Data from the Database Script Generation, Comments in the Script, Script Debugging, Creating Tabs in the Script Basic Data Model and Table Viewer The Table Viewer, The System Table, Document Properties: Tables page Basic Data Transformation Load Statement, Renaming a Field, Script Expressions, Loading an XML File, Renaming Fields Using the Qualify Statement, Key Fields, Example Predicament, How Does this Affect You?, Loading a Field into a Table Multiple Times, Using a Record Counter on Key Fields Generating Data using QlikView Script Resident Load, Using Orders to determine Sales Person., Include, Time Functions: Creating a Calendar, Getting the Highest and Lowest Date from the Orders Table, Autogenerate tables, Creating Variables in the Script, The Master Calendar

TekSlate.com


NameContent QlikviewCourse Course Scripting Considerations Synthetic Key Tables, Circular References, Causes of Circular References, Check the Numbers QlikView Data (QVD) Files QVD File Format, Use of QVD Files, Creating QVD Files, Manual Creation of a QVD File in the Script, Automatic Creation of a QVD File in the Script, QVD File Script Functions, REPORTING BUGS IN QLIKVIEW QlikView Layout User Friendly Design, Natural Human Behavior, Chart and Object Choices in QlikView, Import/Export Sheet and Document Layouts, APPENDIX: The Completed Script QlikView Developer Introduction Installing the Course Materials, Program versions, Text formats, Developer Tools, Troubleshooting, The Debugger

TekSlate.com


NameContent QlikviewCourse Course Mapping Tables and Loading Budget Data Mapping Quarters to the Orders table, MonthYear, Cleaning up the table structure, Reading Cross Tables

Advanced Scripting Condition on a field in a table, Aggregating Data, Joining tables, Concatenation, Preceding Load on Preceding Load Advanced Calculations in Sheet Objects Set Analysis, Dollar-Sign Expansion, AGGR Function Scripting and Data Modelling Challenges Link Tables and Concatenated Tables, Calculating net change within a field, Functions InDate, Data & DateIslands, Aggr(), Class(), Dynamic Aggregation, IntervalMatch Data Model Optimization Performance Tuning, Best Practices for QlikView File Optimization, Creating Incremental Loads, Performance Tuning, Best Practices for QlikView File Optimization, Creating Incremental Loads

TekSlate.com


NameContent QlikviewCourse Course QlikView Security Access control, Access levels, Access control database, Inherited access restrictions, Hidden script, Adding Section Access, Access control for certain commands, Further access control, Unattended Command Line Reload Considerations, Access restrictions on selected field values, Field value limitation in Section Access Advanced Database Connectivity Custom Data, SAP Connector Business Case Workshop Scenario, Data Structure QlikView Deployment Configurations Company Requirements, User Requirements, What configuration to choose?, QlikView Standalone, QlikView Server, QlikView Server & Publisher

TekSlate.com


Course Name

Our Qlikview Online Training batches starts every day. You can attend Free Demo

TekSlate.com


We Provide Online Training On TIBCO BW Tableau QlikView TIBCO Spotfire SAS BI SAP Hybris Selenium Oracle DBA Oracle SOA Oracle Financials IOS Development Android Data Modeling- Erwin Performance Testing SFDC SAP UI5 SAP Hana

TekSlate.com


We offer You 1. Interactive Learning at Learners convenience 2. Industry Savvy Trainers 3.“Real Time" Practical scenarios 4. Learn Right from Your Place 5. Customized Course Curriculum 6. 24/7 Server Access 7. Support after Training and Certification Guidance 8. Resume Preparation and Interview assistance 9. Recorded version of sessions

TekSlate.com


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.