Qlik Sense for Data Science and BI

Explore Qlik Sense basics, navigate the interface, and build your first visualization with tweaks. Tackle a real challenge using Qlik Sense and gain hands-on confidence.

Explore the business challenge of identifying top regional salespeople using Qlik Sense, connect to data via files and data mart, and set up a new app with csv data.

Navigate the Click Sense interface, save your model frequently, and use the top hub, data manager, and assets panel to work with fields, master items, and charts.

Learn how to use chart expressions to compute total sales value by multiplying units by unit price, choosing the correct aggregation, and configuring chart visuals for executives.

Use alternate measures in Qlik Sense to toggle units sold, adjust sorting and colors, and export visuals as images, PDFs, or Excel with data view and snapshot options.

Review installation, data connections, interface navigation, and the use of dimensions, measures, and chart expressions in Qlik Sense; explore insights advisor, data connectors, data mart, and exporting charts (not snapshots).

Learn to build a fully functional interactive dashboard in qlik sense by linking multiple data files, establishing one-to-many relationships, applying map hierarchies, filters, and scatterplots to analyze profit and discounts.

Connect data from an excel file in Qlik Sense and visually associate order and order line with order ID key, explore data modeling and geographic roles for dashboards and maps.

Use a container to toggle between profit and profit margin maps while using sum(profit) divided by sum(sales) as the margin.

Learn to build scatter plot in Qlik Sense by plotting sales and profit, with a third measure for bubble size and color by profit margin to reveal relationships and outliers.

Learn to build KPI big-number dashboards using sales, profit, and profit margin, format metrics, and visualize regional profit with donut and bar charts, handling negatives and filters.

Add a filter pane to your Qlik Sense dashboard with dropdowns for date dimensions such as year, month, and quarter. Save as master item to update across sheets.

Learn to work with images in Qlik Sense using the media library, customize app and sheet thumbnails, and add your own images with PNG/JPG/GIF support and a five megabyte limit.

Change the default working directory for Qlik Sense click apps by editing the settings.ini to set the document directory path, back up the file, and restart click to apply.

Recap covers working with images in Qlik Sense, importing images for thumbnails, sheets, apps, and stories, and adjusting themes and sheet styling for brand compliance plus changing the working directory.

Explore the app's functionality, learn how to export and share dashboards with users, and create compelling stories that guide viewers to key insights from scratch.

Explore and export dashboards in Qlik Sense, using snapshots, self-service exploration, lasso and circle selections, and export options to PDF, image, or Excel.

Finish a data storytelling story in Qlik Sense by adding slides, maps, and annotated visuals to compare profit and gross profit margin across countries, then export and drill into sources.

Explore data preparation techniques to tackle dirty data, including unpivoting, splitting fields, and handling null or inconsistent values, plus manual data associations across Excel and CSV files and set analysis.

Connect to data in Qlik Sense, fix headers, filter inactive students, clean and split fields, set geo data roles, replace values, and load and join students with results for analysis.

learn to unpivot and associate multiple data sources in Qlik Sense by selecting fields, linking on student ID and course ID, and renaming columns for clean visualizations.

Explore set analysis in Qlik Sense, using set expressions to compare overall values with selections, and apply KPI examples like average grade and distinct student counts.

Learn to add a bullet chart in Qlik Sense to show the average grade by category with an overall grade line, using a site analysis to ignore selections.

Prepare dirty data for dashboards by filtering inactive records, correcting data types, and splitting fields. Build accurate associations, use unpivot, and explore word cloud, bullet chart, and set analysis basics.

Celebrate completing the course and persevering through challenges, then look forward to an advanced course with more detail and practice, and consider leaving a review.