Data Visualization Mastery (Office Elearning Menu)

Introductie

Data Visualization Mastery E-Learning Training 

Data Visualization spelen een sleutelrol bij het helpen van bedrijven bij het nemen van datagestuurde beslissingen. Deze reis van Skillsoft Aspire helpt je het belang te begrijpen van het creëren van gebruikersgerichte visuals, best practices om te volgen, samen met verschillende soorten grafieken, plots, grafieken en diagrammen om gegevens visueel weer te geven. Naast opvallende visualisaties met Excel uit verschillende geïmporteerde gegevensformaten, leer je ook verschillende soorten visualisaties te maken met behulp van BI-tools zoals QlikView. Vervolgens onderzoekt u het maken van interactieve dashboards en infographics voor uw visualisatieprojecten. Je zult ook verschillende technieken verkennen voor het maken van visualisaties met behulp van verschillende Python-bibliotheken zoals Matplotlib,

Learning Kits zijn gestructureerde leertrajecten, voornamelijk binnen het gebied Emerging Tech.Met een Learning Kit werkt de student naar een overkoepelend doel toe, wat hem helpt zijn carrièreaspiraties te verwezenlijken.Elk onderdeel leidt de student stap voor stap door een uiteenlopende reeks van onderwerpsgebieden.Learning Kits bestaan uit verplichte tracks, die alle beschikbare leermiddelen bevatten zoals Assessments (eindexamens), Mentor, Practice Labs en natuurlijk E-learning. En alle middelen met een 365 dagen toegang vanaf de eerste activering.

Omschrijving

This learning path, with more than 43 hours of online content, is divided into the following four tracks:

Track 1: Data Visualization with ExcelTrack 2: Data Visualization with Bi ToolsTrack 3: Creating Infographics for Data VisualizationsTrack 4: Data Visualization with Python

Track 1: Data Visualization with Excel

In this track, the focus will be on data visualization best practices and data visualization using Microsoft Excel.

Cursusinhoud

Data Visualization: Best Practices for Creating Visuals

Course: 1 Hour, 4 Minutes

• Course Overview
• Importance of Data Visualization
• Best Practices for Data Visualization
• Chart and Presentation Types for Visualizing Data
• Use Cases: Tables and Bar Charts
• Use Cases and Best Practices: Line and Pie Charts
• Use Cases: Histograms and Box Plots
• Use Cases: Scatter Charts and Bubble Charts
• Use Cases: Gantt Charts and Waterfall Charts
• Heatmaps, Funnel, Sunburst, and Sankey Charts
• Course Summary

Excel Visualization: Getting Started with Excel for Data Visualization

Course: 1 Hour, 12 Minutes

• Course Overview
• Performing Basic Data Load Operations in Excel
• Using Excel Power Query to Work with Imported Data
• Importing Various Data Types to Excel
• Getting Started with Data Visualization in Excel
• Customizing and Formatting a Column Chart in Excel
• Creating Basic Line Charts in Excel
• Formatting Line and Column Charts in Excel
• Course Summary

Excel Visualization: Building Column Charts, Bar Charts, & Histograms

Course: 1 Hour, 18 Minutes

• Course Overview
• Creating Excel Clustered and Stacked Column Charts
• Visualizing Data Using 3D Column Charts in Excel
• Creating Excel 3D Column Charts & Identifying Issues
• Creating and Working with Various Excel Bar Charts
• Formatting Bar Charts in Excel
• Distinguishing the Use of Various Excel Bar Charts
• Visualizing Binned Data Using Excel Histograms
• Customizing Histograms Using Various Excel Features
• Course Summary

Excel Visualization: Visualizing Data Using Line Charts & Area Charts

Course: 1 Hour, 39 Minutes

• Course Overview
• Visualizing Data Using Excel Line Charts
• Using Gradient Fill on Excel Line Charts
• Customizing and Formatting Excel Line Charts
• Using Linear Regression Trendlines on Line Charts
• Using Advanced Trendline Features on Line Charts
• Distinguishing Different Types of Excel Line Charts
• Creating Basic Area Charts in Excel
• Creating Stacked Area Charts in Excel
• Using 100% Stacked Area Charts in Excel
• Using 3D Area Charts in Excel
• Formatting the Walls in a 3D Area Chart
• Course Summary

Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts

Course: 1 Hour, 19 Minutes

• Course Overview
• Using High-Low-Close Charts for Financial Data
• Creating Candlestick Charts in Excel
• Visualizing Data Using Radar Charts in Excel
• Formatting and Customizing Radar Charts in Excel
• Visualizing Hierarchical Data Using Excel Treemaps
• Visualizing Proportions Using Pie Charts in Excel
• Using the Pie-of-pie and Bar-of-pie Charts in Excel
• Visualizing Proportions Using Doughnut Charts in Excel
• Course Summary

Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More

Course: 1 Hour, 40 Minutes

• Course Overview
• Displaying Statistics Using Box Plots in Excel
• Creating Multi-category Box-and-whisker Plots
• Creating Colored Box-and-whisker Plots in Excel
• Visualizing Hierarchical Data Using Sunburst Charts
• Visualizing Cumulative Data Using Waterfall Charts
• Visualizing Related Tasks Using Gantt Charts
• Creating Basic Band Charts in Excel
• Finding Relationships in Data Using Scatter Charts
• Measuring KPI Progress Using a Waffle Chart
• Course Summary

Online MentorYou can reach your Mentor by entering chats or submitting an email.Final Exam assessmentEstimated duration: 90 minutes

Track 2: Data Visualization with BI Tools

In this track, the focus will be on data visualization using QlikView.

Content:

E-learning courses

QlikView: Getting Started with QlikView for Data Visualization

Course: 1 Hour, 52 Minutes

• Course Overview
• Installing QlikView on Microsoft Windows
• Illustrating How QlikView's Associative Model Works
• Importing Data into QlikView
• Working with Table Box Sheet Objects in QlikView
• Creating Bar Charts and Tables in QlikView
• Running QlikView Bar Chart Sort & Filter Operations
• Using Horizontal Bar Charts in QlikView
• Importing CSV Data into QlikView
• Creating Table Boxes and Multi Boxes in QlikView
• Using QlikView Pie Charts to Visualize Compositions
• Visualizing Data Using Grid Charts in QlikView
• Visualizing Data Using Trellis Charts in QlikView
• Course Summary

QlikView: Creating Line Charts, Combo Charts, Pivot Tables, & Block Charts

Course: 1 Hour, 45 Minutes

• Course Overview
• Creating and Formatting Line Charts in QlikView
• Applying Regression Using QlikView Trendlines
• Customizing Line Charts & Using QlikView Area Charts
• Creating Standard Combo Charts in QlikView
• Customizing Combo Charts in QlikView
• Create Stacked Bar Charts in QlikView
• Visualizing Hierarchical Data Using Pivot Tables
• Using Selected Data & QlikView Straight/Pivot Tables
• Visualizing Hierarchies Using QlikView Block Charts
• Creating Buttons in QlikView
• Course Summary

QlikView: Creating Mekko Charts, Radar Charts, Gauge Charts, & Scatter Charts

Course: 1 Hour, 38 Minutes

• Course Overview
• Using Mekko Charts in QlikView to Visualize Data
• Creating Line/Arrow Sheet Objects in QlikView
• Creating and Using Funnel Charts in QlikView
• Visualizing Data Using Gauge Charts in QlikView
• Customizing Gauge Charts in QlikView
• Working with Different Gauge Charts in QlikView
• Visualizing Data Using Radar Charts in QlikView
• Creating Scatter Charts in QlikView
• Customizing Scatter Charts in QlikView
• Using QlikView Animations, Search Bars, and Sliders
• Course Summary

Online MentorYou can reach your Mentor by entering chats or submitting an email.Final Exam assessmentEstimated duration: 90 minutes

Practice Labs: Data Visualization with Excel and BI Tools (estimated duration: 8 hours)Perform data visualization tasks with Excel such as creating and customizing line, bar, area and band charts. Then use QlikView to create tables and bar, combo, line and funnel charts. This lab provides access to tools typically used for data visualization, including:

• Microsoft Excel 2019
• QlikView 12

Track 3: Creating Infographics for Data Visualizations

In this track, the focus will be on creating infographics with Infogram and Visme.

Content:

E-learning collections

Infogram: Getting Started

Course: 1 Hour, 51 Minutes

• Course Overview
• Setting Up and Exploring Infogram
• Creating an Infogram Project
• Configuring Visual Elements in an Infogram Project
• Preparing Data for Infogram Charts
• Plotting a Line Chart in Infogram
• Configuring a Line Chart in Infogram
• Using Line Charts with Error Margins in Infogram
• Using Column Charts and Histograms in Infogram
• Using Stacked Bar Charts in Infogram
• 100% Stacked Bar Charts in Infogram
• Stacked Area Charts in Infogram
• Course Summary

Infogram: Advanced Features

Course: 1 Hour, 39 Minutes

• Course Overview
• Creating Animated Bar Races in Infogram
• Creating Candlestick Charts in Infogram
• Creating Waterfall Charts in Infogram
• Creating a Dashboard in Infogram
• Defining Interactions in Infogram Dashboards
• Creating an Infographic in Infogram
• Customizing Infographic Project Types in Infogram
• Adding Pie Charts and GIFs to Infogram Infographics
• Course Summary

Visme: Introduction

Course: 1 Hour, 17 Minutes

• Course Overview
• Getting Started with Visme
• Exploring Visme Templates for Social Media Posts
• Building an Infographic in Visme
• Configuring Shapes and Text in Visme Presentations
• Adding a Background Image to a Visme Infographic
• Adding a Video to a Visme Project
• Animating Visme Elements
• Course Summary

Visme: Exploring Charts

Course: 1 Hour, 7 Minutes

• Course Overview
• Adding a Bar Chart to a Visme Report
• Configuring a Visme Bar Chart
• Visualizing Data Using Visme's Horizontal Bar Charts
• Configuring Stacked Bar Charts in Visme
• Working with Pie and Donut Charts in Visme
• Visualizing Data Using Visme's Line and Area Charts
• Course Summary

Visme: Designing a Presentation

Course: 49 Minutes

• Course Overview
• Using Visme Templates to Create a Presentation
• Formatting Icons and Text in Visme
• Using Visme's Map Chart
• Sharing a Visme Project
• Course Summary

Online MentorYou can reach your Mentor by entering chats or submitting an email.Final Exam assessmentEstimated duration: 90 minutes

Track 4: Data Visualization with Python

In this track, the focus will be on data visualization with Python using Matplotlib, Bokey, and Plotly.

Content:

E-learning collections

Python & Matplotlib: Getting Started with Matplotlib for Data Visualization

Course: 1 Hour, 44 Minutes

• Course Overview
• Installing Matplotlib
• Visualizing Random Data Using Line Charts
• Visualizing Time Series Data Using Line Charts
• Customizing Line Chart Elements
• Exploring the Use of Figure and Axes Objects
• Creating Line Charts Using the Twinx() Function
• Visualizing Data Using Histograms
• Customizing Histograms
• Comparing Categorical and Continuous Data
• Creating Lollipop Charts
• Creating Charts That Visualize Multiple Variables
• Course Summary

Python & Matplotlib: Creating Box Plots, Scatter Plots, Heatmaps, & Pie Charts

Course: 1 Hour, 29 Minutes

• Course Overview
• Visualizing Statistics Using Box-and-whisker Plots
• Customizing Box-and-whisker Plots in Matplotlib
• Visualizing Relationships Using Scatter Plots
• Visualizing Correlations Using Matplotlib Heatmaps
• Creating Labeled Heatmaps in Matplotlib
• Visualizing Composition Using Matplotlib Pie Charts
• Creating Matplotlib Exploded Pie Charts and Treemaps
• Predicting with Auto-correlation & Cross-correlation
• Visualizing Data Using Stacked Plots and Stem Plots
• Course Summary

Data Visualization: Building Interactive Visualizations with Bokeh

Course: 1 Hour, 6 Minutes

• Course Overview
• Installing Bokeh
• Saving Bokeh Charts as PNG and HTML Files
• Displaying Bokeh Charts Inline in Jupyter Notebooks
• Creating Bar Charts in Bokeh
• Creating Stacked Bar Charts in Bokeh
• Implementing Bokeh Clustered Bar Charts
• Visualizing Data in Bokeh Using Pie Charts
• Creating Donut Charts in Bokeh
• Course Summary

Data Visualization: More Specialized Visualizations in Bokeh

Course: 1 Hour, 8 Minutes

• Course Overview
• Creating Scatter Plots Using Bokeh
• Visualizing Relationships with Bokeh Scatter Plots
• Customizing Scatter Plots in Bokeh
• Visualizing Data Using Bokeh Heatmaps
• Creating Line Charts in Bokeh
• Customizing Line Charts with Area Charts in Bokeh
• Visualizing Data Using Bokeh Network Charts
• Course Summary

Data Visualization: Getting Started with Plotly

Course: 1 Hour, 9 Minutes

• Course Overview
• Installing Plotly
• Components of Plotly Graphs
• Creating Box Plots in Plotly
• Plotting Categorical Data with Box and Strip Plots
• Customizing Plotly Box Plots
• Visualizing Financial Data Using Candlestick Charts
• Visualizing Data Using Plotly Funnel Charts
• Course Summary

Data Visualization: Visualizing Data Using Advanced Charts in Plotly

Course: 1 Hour, 10 Minutes

• Course Overview
• Creating Radar Charts in Plotly
• Components of Plotly Radar Charts
• Visualizing Hierarchical Data Using Sunburst Charts
• Visualizing Schedules in Plotly Using Gantt Charts
• Creating Sankey Diagrams in Plotly
• Visualizing Data Using Plotly Sankey Diagrams
• Visualizing Geographical Data Using Plotly Maps
• Course Summary

You can reach your Mentor by entering chats or submitting an email.

Final Exam assessmentEstimated duration: 90 minutes

Practice Labs: Creating Infographics and Data Visualization with Python (estimated duration: 8 hours)

Perform data visualization tasks such as creating an Infogram project, building an infographic and creating box-and-wisker plots, line charts and histograms. Then visualize relationships using a scatter plot, create a bar chart using Bokeh, and create a box chart using Plotly. This lab provides access to tools typically used for data visualization, including:

• Jupyter Notebook
• matplotlib
• numpy
• pandas
• Plotly
• Bokehh