by David Chisholm | Released March 2019 | ISBN: 9781789955002

Work with QlikView, the most intuitive business intelligence tool that enables you to visualize and analyze data effectivelyAbout This VideoGet the best out of your investment in QlikView along with exclusive insider tips, best practices, and success strategiesUnderstand how to build a model from real data and extend it with each new conceptReceive special insights into data visualization based on knowledge and expertise gathered over 10 years of working and training in QlikView developmentIn DetailData visualization has become a key part of monitoring performance in businesses today. It is now easier to understand complex data and insights with the help of data visualization. In this course, you will cover advanced applications of QlikView and understand how you can use it efficiently for your business intelligence (BI) needs. You will start by learning how to create QlikView applications for visualizing your day-to-day business needs. By exploring various real-world scenarios like using a sales report from a sports firm, you will be able to implement advanced data visualizations and dashboards. With this module's practical approach, you'll get to grips with some advanced concepts, as well as best practices that you can use for data visualization in QlikView. By the end of this course, you will have become an expert in creating your own state-of-the-art data visualizations and dashboards for your data analysis requirements. Show and hide more

1. Chapter 1 : How Does a Great Dashboard Work
   • The Course Overview 00:02:33
   • An Overview of QlikView 00:02:35
   • What Visualizations Are Available? 00:04:31
   • Navigation and Selection 00:01:42
   • Green, White, and Grey 00:01:05
   • Demo of the Model 00:06:03
2. Chapter 2 : Loading Data
   • Loading Data Into Our Model 00:07:28
   • Fact and Dimension Tables 00:04:31
   • Joining Tables Together 00:05:33
   • Applymap and its Three Parameters 00:05:23
   • Where and Where Exists 00:02:57
   • Resident Load and Cross Table 00:06:32
3. Chapter 3 : Visualizations on Our Canvas
   • Data Selectors 00:07:00
   • Three Uses of a Text Box 00:06:21
   • Our First Charts 00:09:15
   • Current Selections and Search Functionality 00:03:37
   • Sliders, Bookmarks, and Containers 00:05:28
   • Setting New Sheets Up 00:04:58
4. Chapter 4 : Adding Power to Your Charts
   • Set Analysis 00:05:23
   • Adding Set Analysis to Power Up the Charts 00:06:01
   • Let Us Look at the Gauges 00:04:29
   • Cycles and Drills 00:05:39
   • Conditional Display 00:04:31
   • Let Us Think About the Initial View 00:08:39
   • Ranking and Mini Charts 00:07:03
   • What does AGGR Do? 00:07:50
5. Chapter 5 : Adding Power to Your Scripting
   • What are Variables? 00:06:47
   • Optimize Our Calculations 00:03:34
   • User-Defined Reports 00:08:20
   • Calendar Script 00:05:37
6. Chapter 6 : Security and Reporting
   • The 5 Levels of Security 00:03:03
   • Section Access Explained 00:05:36
   • Row Level Security 00:03:54
   • Column Level Security 00:02:44
   • Object Level Security 00:03:33
   • Build a Report 00:03:11
7. Chapter 7 : Styling and Best Practice in Visualization
   • World Map 00:07:26
   • Google Maps 00:05:32
   • Scripting – Final Tidy Up 00:05:32
   • Look and Feel – Best Practice 00:02:51
   • Make it Look Like a Web Page 00:05:25
   • Final Review 00:03:36
Show and hide more