Data Visualization Core Concepts: Visme 2021 Beginner

https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581649&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581650&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581651&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581652&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581653&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581655&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581656&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581658&expertiselevel=3581648 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581652&expertiselevel=3581654 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581652&expertiselevel=3581657 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581653&expertiselevel=3581654 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581656&expertiselevel=3581654 https://www.skillsoft.com/channel/data-visualization-core-concepts-ef67beb1-10b8-11e7-be8a-afccb86e7a23?data-visualization=3581658&expertiselevel=3581654
  • 4 Courses | 2h 36m 53s
  • 8 Books | 37h 31m
  • 3 Courses | 3h 11m 53s
  • 1 Course | 1h 3m 52s
  • 2 Books | 10h 27m
  • 3 Courses | 3h 41m 55s
  • Includes Lab
  • 3 Courses | 3h 22m 30s
  • Includes Lab
  • 2 Courses | 3h 28m 32s
  • 2 Courses | 2h 30m 46s
  • 1 Course | 1h 5m
  • 6 Courses | 8h 20m 58s
  • Includes Lab
  • 3 Courses | 4h 30m 2s
  • Includes Lab
  • 4 Courses | 2h 54m 37s
  • 6 Books | 21h 21m
  • 1 Course | 1h 42m 51s
  • Includes Lab
  • 3 Courses | 3h 26m 15s
  • Includes Lab
Likes 152 Likes 152
 
How you look at your data can change the way it's interpreted. Explore data visualization and its various technologies.

GETTING STARTED

Data Visualization Essentials

  • Playable
    1. 
    What is Data Visualization
    3m 46s
    NOW PLAYING
  • Playable
    2. 
    Knowing Your Audience
    3m 50s
    UP NEXT

GETTING STARTED

Visme: Introduction

  • Playable
    1. 
    Course Overview
    2m 11s
    NOW PLAYING
  • Playable
    2. 
    Getting Started with Visme
    11m 12s
    UP NEXT

GETTING STARTED

Data Visualization: Best Practices for Creating Visuals

  • Playable
    1. 
    Course Overview
    2m 31s
    NOW PLAYING
  • Playable
    2. 
    Importance of Data Visualization
    9m 14s
    UP NEXT

GETTING STARTED

Excel Visualization: Getting Started with Excel for Data Visualization

  • Playable
    1. 
    Course Overview
    1m 37s
    NOW PLAYING
  • Playable
    2. 
    Performing Basic Data Load Operations in Excel
    11m 49s
    UP NEXT

GETTING STARTED

Google Chart Tools: Basic Charts

  • Playable
    1. 
    Course Overview
    2m 11s
    NOW PLAYING
  • Playable
    2. 
    Rendering a Pie Chart
    8m 54s
    UP NEXT

GETTING STARTED

Infogram: Getting Started

  • Playable
    1. 
    Course Overview
    1m 58s
    NOW PLAYING
  • Playable
    2. 
    Setting Up and Exploring Infogram
    11m 21s
    UP NEXT

GETTING STARTED

Plotly for Data Visualization: An Introduction to Plotly Chart Studio

  • Playable
    1. 
    Course Overview
    2m 38s
    NOW PLAYING
  • Playable
    2. 
    Setting up Chart Studio
    6m 55s
    UP NEXT

GETTING STARTED

Data Visualization: Building Interactive Visualizations with Bokeh

  • Playable
    1. 
    Course Overview
    1m 54s
    NOW PLAYING
  • Playable
    2. 
    Installing Bokeh
    5m 43s
    UP NEXT

GETTING STARTED

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

  • Playable
    1. 
    Course Overview
    1m 50s
    NOW PLAYING
  • Playable
    2. 
    Creating Excel Clustered and Stacked Column Charts
    7m 52s
    UP NEXT

GETTING STARTED

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

  • Playable
    1. 
    Course Overview
    2m 51s
    NOW PLAYING
  • Playable
    2. 
    Displaying Statistics Using Box Plots in Excel
    10m 54s
    UP NEXT

GETTING STARTED

Advanced Visualizations & Dashboards: Visualization Using Python

  • Playable
    1. 
    Course Overview
    1m 43s
    NOW PLAYING
  • Playable
    2. 
    Relevance of Data Visualization for Business
    3m 42s
    UP NEXT

GETTING STARTED

Plotly for Data Visualization: Advanced Charts & Features in Chart Studio

  • Playable
    1. 
    Course Overview
    2m 22s
    NOW PLAYING
  • Playable
    2. 
    Using Plotly Chart Studio Box Plots
    8m 9s
    UP NEXT

GETTING STARTED

Data Visualization: More Specialized Visualizations in Bokeh

  • Playable
    1. 
    Course Overview
    2m 2s
    NOW PLAYING
  • Playable
    2. 
    Creating Scatter Plots Using Bokeh
    11m 53s
    UP NEXT

COURSES INCLUDED

Data Visualization Essentials
It's becoming more common to present data in a visual way to engage audiences with what the data is saying. Explore the essentials of creating great data visualizations.
17 videos | 1h 2m has Assessment available Badge
Graph & Charts
To ensure the audiences understand what's being presented, effective data visualizations need to be created. Explore different forms of data visualizations.
7 videos | 30m has Assessment available Badge
Delivering Dashboards: Management Patterns
In this 11-video course, explore the concept of dashboards and the best practices that can be adopted to build effective dashboards. The course also covers how to implement dashboards and visualizations by using PowerBI and ELK and the concepts of leaderboards and scorecards. Learners begin with analytical visualization, recognizing the various types of visualizations that can be used to build concise dashboards. Then you will look at different dashboard types and their associated features and benefits. Learners examine different types of data used in analysis and the types of visualizations that can be created from the data. Learn about dashboard components, the essential components involved in building a productive dashboard. Familiarize yourself with best practices for building a productive dashboard. Learn how to create a dashboard using ELK (Elasticsearch, Logstash, and Kibana) and PowerBI (business intelligence platform). Then look at selection criteria for charts, the critical benefits provided by leaderboards and scorecards, and the various scorecard types. The closing exercise involves creating dashboards by using PowerBI and ELK.
12 videos | 33m has Assessment available Badge
Delivering Dashboards: Exploration & Analytics
Explore the role played by dashboards in data exploration and deep analytics in this 11-video course. Dashboards are especially useful in visualizing data for a wide variety of business users, so that they can better understand the data being analyzed. First, learners examine the essential patterns of dashboard design and how to implement appropriate dashboards by using Kibana, Tableau, and Qlikview. You will begin by learning about data exploration capabilities using charts; then take a look at analytical visualization tools, the prominent tools that can be used to implement charts. Learn how to create bar and line charts and dashboards, and then share those dashboards with Kibana. Learners then watch demonstrations of creating charts and dashboards by using both Tableau and Qlikview tools. You will explore the approach to building dashboards with real-time data updates and how to specify essential design patterns that can be adopted when designing dashboards. Finally, learn about creating monitoring dashboards with ELK (Elasticsearch, Logstash, and Kibana). The concluding exercise deals with creating dashboards by using Kibana, Tableau, and Qlikview.
12 videos | 30m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Visme: Introduction
Visme is a visualization tool that facilitates data delivery by transforming content into visually appealing formats like infographics and presentations. In this course, you'll achieve a broad overview of Visme's capabilities and use cases. You'll begin by identifying how to create different types of visuals in Visme using templates for concise infographics, social media posts, as well as detailed reports. Moving on, you'll examine how to work with some of these visuals and start by building an infographic. You'll then recognize how to incorporate design elements such as icons, shapes, images, and text within visuals to enhance their appearance. Finally, you'll investigate how to include a video within a visual and make your project stand out by animating various elements of your visuals.
9 videos | 1h 16m has Assessment available Badge
Visme: Exploring Charts
Charts and graphs help convey information visually, which enables viewers to draw meaningful conclusions from the data. Visme allows users to create and modify different types of charts and use them within other visuals like infographics, reports, presentations, and social media graphics. In this course, you'll explore the use cases and configuration methods of different bar charts. You'll start by recognizing how to build a simple bar chart and alter its appearance. You'll then examine how to visualize diverse forms of data by implementing horizontal bar charts and stacked bar charts. Next, you'll investigate how to convey proportions in data using pie charts and donut charts. You'll also identify how to work with line charts and area charts to analyze changes in values within a dataset over a period of time.
8 videos | 1h 6m has Assessment available Badge
Visme: Designing a Presentation
A presentation often requires powerful graphic elements in order to convey information effectively. Visme's versatile design elements can help you create an engaging and visually impactful presentation. In this course, you'll explore how to work with Visme's design elements and configurations to create a visually striking presentation. You'll begin by recognizing how to create a presentation from an existing template and modify it to suit a specific visual theme. You'll then examine how to configure presentation backgrounds by formatting text and icons, incorporating layers, and using a grid to align different elements. You'll also work with a map chart to highlight specific countries in the world that are relevant to your presentation. Finally, you'll discover how to collaborate with another Visme user by sharing your project.
6 videos | 49m has Assessment available Badge

COURSES INCLUDED

Data Visualization: Best Practices for Creating Visuals
Most organizations depend on data visualization to help drive business decisions. Using the correct charts and graphs helps communicate the right information and identify patterns and trends within your data. You'll begin this course by identifying the importance of data visualization and its application in curating data that is easy to digest, understand, and interpret. Next, you'll discover best practices for visualizing data and the significance of creating user-centered visuals. You'll then explore different presentation types such as comparison, composition, distribution, trends, and relationship, and learn how to map your charts to these categories. Finally, you'll investigate the use cases for popular charts such as line charts, pie charts, histograms, scatter plots, and others. You'll also recognize when to use specialized charts such as Gantt charts, sunburst charts, and Sankey diagrams.
11 videos | 1h 3m has Assessment available Badge

COURSES INCLUDED

Excel Visualization: Getting Started with Excel for Data Visualization
Excel charts can be used for a myriad of data visualizations, including categorical data and continuous data, like time-series data. In this course, you'll learn how to bring data into Excel and build and customize various charts. You'll start by importing data from an existing workbook into a new spreadsheet. You'll then import data from CSV and JSON file formats and Microsoft Access database files. Next, you'll use the Power Query editor to perform various operations. Moving on, you'll create column and clustered column charts and perform various formatting operations on the clustered column chart, such as adding data labels, error bars, axis titles, and trendlines. Lastly, you'll create a simple line chart, formatting various aspects, such as the line, background, title, legend, axes, and position of charts relative to each other.
9 videos | 1h 11m has Assessment available Badge
Complete Guide to Excel 365: Getting Started
Microsoft Excel has many potential applications, offering extensive, customizable features to suit virtually all tasks and workflows. At first, Excel can be intimidating, but the benefits of knowing how to eke out every bit of this tool's productivity far outweigh the slight learning curve. In this course, you'll learn how to set up Excel, identify and choose an Excel template, locate and recognize the purpose of each primary menu item group in the Quick Access Toolbar, and apply customization to this toolbar. Next, you'll execute basic cell operations, such as copy-pasting data and inserting and deleting rows and columns. You'll and apply a range of cell formatting options, such as alignment, font, and currency formats. Finally, you'll import delimited and fixed-width data and work with Excel's Flash Fill functionality.
10 videos | 1h 13m has Assessment available Badge
Complete Guide to Excel 365: Working With Charts & Sparklines
One of the primary purposes of using Excel is to analyze and present data in a focused, accessible, and accurate way. A great way to do this is with charts and sparklines. In this course, you'll create basic chart types, such as line, bar, and pie charts, as well as more advanced charts, like treemaps and sunburst charts. In doing this, you'll work with the different aspects of Excel's chart customization capabilities, from chart element transparency to the orientation and exploding out of slices in a pie chart. Next, you'll advance to use more statistically-oriented chart types, including histograms, scatter plots, and box-and-whisker plots. Finally, you'll learn to create, customize, and work with Excel's sparklines, which are lightweight visualizations usually contained within a single cell.
11 videos | 1h 16m has Assessment available Badge

COURSES INCLUDED

Google Chart Tools: Basic Charts
Google Charts provides a handy tool for developers who need to create standard and powerful charts for their users. In this course, you'll explore Google Charts through a series of labs in which you'll build several data visualization charts. You'll start with the very basics - the HTML and JavaScript components that you need to put together to render Google charts, such as the DataTable and options objects. While doing so, you'll construct some of the fundamental charts available in the Google Charts library, such as pie, bar, and area charts. You'll then use various customization and visualization techniques, such as changing a chart's appearance and the data it shows and using stacked column charts, combo charts, material charts, and charts with dynamic behavior.
14 videos | 1h 36m has Assessment available Badge
Google Chart Tools: Interacting with Charts
When developing charts with Google Charts, you can control not only what data your users see, but also how they interact with it. In this course, you'll explore the different ways in which user interaction with Google Charts can be set up and configured. You'll start by learning how to get data from Google Drive and use it in your Google charts. You'll then learn how to convey the relationship between fields using a scatter chart. Next, you'll learn how to create a chart editor to allow users to choose the right chart for their data. You'll learn how to work with dashboards and controls to enable users to visualize a subset of their data dynamically. Lastly, you'll design a dashboard with multiple charts and controls.
8 videos | 48m has Assessment available Badge
Google Chart Tools: Advanced Visuals with Charts
Once you're familiar with the basics of Google Charts, you can build on this to create more exciting and advanced visualizations. In this course, you'll get hands-on experience with some of the specialized visuals available in Google Charts. You'll learn how to work with geo charts to convey information related to countries and map charts to convey data on satellite, street, and terrain maps. You'll also work with Sankey charts to convey data flow, treemap charts to show hierarchical information, gauge charts for values within a range, and calendar charts for daily date-related data. In addition, you'll recognize what kind of data can be portrayed in these charts and learn how to set up and customize them.
9 videos | 57m has Assessment available Badge

COURSES INCLUDED

Infogram: Getting Started
Infogram, a cloud-based tool for creating easily comprehensible presentations and reports, is a useful tool for roles in all industries. In this course, you'll learn to use this tool from scratch, moving from installation to building a project. You'll start this course by setting up an Infogram account. You'll then spend some time cycling through the different types of projects in Infogram and catch a glimpse into the variety of built-in templates. Next, you'll create a basic Infogram project. After which, you'll examine different element types that can be added to projects, including text, icons, shapes, arrows, and background images. You'll move on to formatting data in an external tool before visualizing it in Infogram charts. Lastly, you'll briefly outline the use of Microsoft Excel and its pivot table feature for data preparation.
13 videos | 1h 50m has Assessment available Badge
Infogram: Advanced Features
Once you've learned how to set up a basic project in Infogram, there are several ways you can ensure the information in your infographic stands out. In this course, you'll work with Infogram's many advanced data visualization features. You'll start by using the bar race plot feature to animate bar charts that change over time. You'll then create candlestick charts to visualize variations in data over set periods and waterfall charts to convey the cumulative effect of positive and negative values. Next, you'll create dashboards to convey information using various visual elements, including a treemap, a series of line charts, a streamgraph, and a forecast line chart. Moving on, you'll use an infographic project type to convey several fun bits of information related to James Bond films. To do this, you'll use a Gantt chart, a line chart, and some animated components.
10 videos | 1h 38m has Assessment available Badge

COURSES INCLUDED

Plotly for Data Visualization: An Introduction to Plotly Chart Studio
This course serves as an introduction to Plotly's Chart Studio - a handy visualization tool that supports various purposes. You'll start by covering the basics, creating or loading a dataset into a grid. You'll then use that data to generate a chart. Following from there, you'll practice loading different data source types into Chart Studio, such as CSV files and SQL query results. You'll then create basic visualizations, including a bar graph and a table, and style them to suit your aesthetic requirements and, more crucially, to accurately convey the underlying information in your dataset. Lastly, you'll delve into how to set up a single plot to include multiple charts, allowing users to analyze data along various dimensions.
10 videos | 1h 15m has Assessment available Badge
Plotly for Data Visualization: Exploring Chart Studio Visualizations
This course's focus is on working with the variety of charts available in Plotly Chart Studio - each of which has its use case in terms of the kind of information it conveys best. Upon completion, you'll recognize which chart to choose to best present information the underlying data. You'll begin by working with pie charts, a great way to project the proportion of values represented by individual categories. You'll then work with scatter plots to visualize relationships between two variables, line charts to analyze sequential data, and histograms to understand a distribution of values. While exploring all of these charts, you'll cover several features that make plots useful and exciting, such as using multiple charts within subplots, adding annotations, and configuring the chart axes.
11 videos | 1h 15m has Assessment available Badge

COURSES INCLUDED

Data Visualization: Building Interactive Visualizations with Bokeh
An interactive visualization library, Bokeh allows users to create diverse graphics and highly interactive dashboards and data applications. In this course, you'll achieve a foundational knowledge of using Bokeh to build simple graphs and visualizations. You'll start by exploring how to install Bokeh on your local machine, display charts inline within your Jupyter notebooks, and create an interactive visualization. You'll then recognize how to save Bokeh charts as HTML and PNG files. Next, you'll investigate how to visualize categorical data using bar charts, stacked bar charts, and clustered bar charts. You'll also identify how to implement pie charts and donut charts to represent compositions in your data. You'll finish the course by examining the ease of interactivity and granular customizations that Bokeh offers.
10 videos | 1h has Assessment available Badge

COURSES INCLUDED

Excel Visualization: Building Column Charts, Bar Charts, & Histograms
Data visualizations in Excel reveal the insights uncovered by your data in easy-to-consume representations. You can identify categorical values, recognize how parts sum up to a whole, see percentages rather than absolute values, discretize continuous variables, and approximate the probability density function of variables. In this course, you'll build charts to uncover all of this information. You'll start by working with column and bar charts. You'll then create and differentiate between clustered and stacked column charts. You'll move on to formatting and customizing bar and column charts before working with 2D and 3D chart types and customizing them in various ways. Lastly, you'll work with histograms, examining how they work, what they're used for, and how to customize them to your needs.
10 videos | 1h 17m has Assessment available Badge
Excel Visualization: Visualizing Data Using Line Charts & Area Charts
Line charts are possibly the most common type of visualization for time-series data, enabling you to see time trends at a glance. These can be augmented with trendlines, used to visualize time trends in data. Stacked area charts are a powerful type of visualization, combining information about trends over time with information about composition and parts of a whole. In this course, you'll learn how to create and customize all of the visualization types above. You'll begin by exploring the purpose of line charts before moving on to formatting and customizing them. You'll then practice using trendlines to evaluate different regression models on data in a line chart. You'll also customize and format these trendlines. Following this, you'll work with area charts and stacked area charts, examining, in detail, the several types of stacked area charts in Excel and customizing their appearance.
13 videos | 1h 38m has Assessment available Badge
Excel Visualization: Plotting Stock Charts, Radar Charts, Treemaps, & Donuts
Data visualization options in Excel are vast. You should choose your visualization type based on the data and what you want to show from it. For example, using High-Low-Close and Open-High-Low-Close charts (also called candlestick charts), you can summarize several stock performance aspects. Excel also lets you build radar charts - great for visualizing multivariate ordinal data, such as ratings or scores, to spot strengths or spikes. In this course, you'll not only learn how to build and customize the charts mentioned, but you'll also create treemaps to visualize hierarchical data and pie charts to display parts of a whole. You'll then generate pie-of-pie and bar-of-pie charts, both of which use a secondary visualization to complement a pie chart. Finally, you'll create donut charts to visualize composition using multiple concentric donut rings to represent points in time.
10 videos | 1h 18m has Assessment available Badge
Complete Guide to Excel 365: Using Formatting, Styles, & Themes
Conditional formatting is a significant and powerful feature in Excel. In this course, you'll begin by using some of the more straightforward types of conditional formattings, such as those based on specific values or ranking. You'll then use the more visually appealing types of conditional formatting, such as data bars, icon sets, and color scales, before advancing to more complex custom formatting rules using worksheet functions and a cell's row and column information. Additionally, you'll distinguish the purpose of notes versus comments and how to work with them both. Finally, you'll learn to use built-in styles and themes, create custom styles and themes and export them for use in other Office 365 products, such as PowerPoint, to apply a uniform look-and-feel to all your spreadsheets and presentations.
11 videos | 1h 17m has Assessment available Badge
Complete Guide to Excel 365: Linking, Printing, & Protecting Workbooks
Some of the core benefits of working with data in Excel include connecting data combined from different workbooks and controlling how it's presented and who has access to it. In this course, you'll begin by linking data in different Excel workbooks, before editing, testing, and cleanly breaking those links. Next, you'll work with an often-ignored but powerful aspect of Excel - precise control over how a workbook is laid out and printed. You'll configure headers, footers, page numbers, background, images, and the views used to print only parts of a workbook. Finally, you'll use Excel's protection features for individual cells and cell ranges, worksheets, and workbooks. This includes setting roles and passwords, working with read-only workbooks, and utilizing editable cell ranges.
11 videos | 1h 20m has Assessment available Badge
Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
Excel is not only used for aggregating and analyzing data, but also for data cleansing. There are several data cleaning, validation, and checking techniques available, some of which are among Excel's most well-known and widely-used functions. In this course, you'll start by using various string and data manipulation functions to clean data and fill in missing values. Next, you'll perform simple data validation based on specific numeric thresholds and text lengths, before moving on to validation using lists. You'll then combine data validation to implement a formidable, dynamic data validation mechanism using named ranges and the INDIRECT formula. Finally, you'll use one-dimensional lookups - the classic HLOOKUP and VLOOKUP worksheet functions - as well as more complex, two-dimensional lookups utilizing a combination of INDEX and MATCH.
13 videos | 1h 29m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
Once you grasp how to work with the scope of standard Excel chart types, you can expand into more complex visualizations. For example, you can use box-and-whisker plots to convey a wealth of information about the statistical distribution of a variable and identify outliers in a data series. You can use sunburst charts to visualize hierarchical data with differing levels of detail, waterfall charts to show the cumulative effect of positive and negative values, and Gantt charts to illustrate progress toward a goal involving multiple parallel tasks. Additionally, you can avail of band charts to quickly eyeball the trend in a line chart, scatter plots to uncover the relationship between two variables, and waffle charts to visualize progress towards KPIs. In this course, you'll create all of these charts either via Excel's built-in tools or by building them manually using nifty workarounds.
11 videos | 1h 39m has Assessment available Badge
Complete Guide to Excel 365: What-If Analysis, Solver, & Analysis ToolPak
Excel's Scenario Manager allows you to create named scenarios with different values for key variables. These scenarios can be quickly examined and summarized using the What-If Analysis tool. In this course, you'll use GoalSeek and Solver, both of which are mathematical tools. Goal Seek comes in handy when solving quadratic, cubic, or other equations. Solver is much more powerful and allows complex constrained optimization problems to be easily defined and addressed. As you'll recognize, Solver's interface, used for specifying objective functions and constraints, is intuitive and easy to use. Next, you'll use several heavy-duty statistical techniques in Analysis ToolPak. These range from the creation of correlation and covariance matrices, hypothesis testing, and F-test and T-test interpretations to ANOVA, random and periodic sampling, and the construction and analysis of linear regression models.
12 videos | 1h 35m has Assessment available Badge
Complete Guide to Excel 365: Pivot, PowerPivot, & Financial Modeling
In this course, you'll recognize how relational data - data with schema and clearly-defined column names - can be imported into Excel as a set of data tables. This data can be sliced-and-diced using classic Excel pivot tables or the more robust PowerPivot add-in. Now a standard part of Excel, this add-in vastly expands the tool's capabilities with some serious entity-relationship modeling and big data analysis. Excel has powerful capabilities to detect relationships across models and infer foreign key relationships between parent and child tables. Creating, visualizing, and modeling such relationships is an important aspect of working with relational databases. As you'll recognize, you can now accomplish much of that from within Excel using PowerPivot. In this course, you'll use some classic yet powerful worksheet functions that have ensured Excel's use in Wall Street for decades. These functions can be used to compute the yield of a bond and the present and future values of a set of cash flows. They can also be used to perform complex operations on settlement dates and compounding rates of financial instruments.
9 videos | 1h 14m has Assessment available Badge

COURSES INCLUDED

Advanced Visualizations & Dashboards: Visualization Using Python
In this course, learners explore approaches to building and implementing visualizations for data science, as well as plotting and graphing using Python libraries such as Matplotlib, ggplot, bokeh, and Pygal. Key concepts covered here include the importance and relevance of data visualization from the business perspective; libraries that can be used in Python to implement data visualization and how to set up a data visualization environment using Python tools and libraries; and prominent data visualization libraries that can be used with Matplotlib. Then see how to create bar charts by using ggplot in Python; how to create charts, using the bokeh and Pygal libraries in Python; and criteria that should be considered when selecting an appropriate data visualization library. Learners observe how to create interactive graphs and image files; how to plot graphs using line and markers; and how to plot multiple lines in a single graph with different line styles and markers. Finally, see how to create a line chart with Pygal, create an HTML directive to render the line chart, and render the line chart.
12 videos | 37m has Assessment available Badge
Advanced Visualizations & Dashboards: Visualization Using R
Discover how to build advanced charts by using Python and Jupyter Notebook for data science in this course, which explores R and ggplot2 visualization capabilities and how to build charts and graphs with these tools. Key concepts in this course include different types of charts that can be implemented and their relevance in data visualization; how to create a stacked bar plot; how to create Matplotlib animations; and how to use NumPy and Plotly to create interactive 3D plots in Jupyter Notebook. Learners are shown the graphical capabilities of R from the perspective of data visualization; how to build heat maps and scatter plots using R; and how to implement correlogram and build area charts using R. Next, you will explore ggplot2 capabilities from the perspective of data visualization; learn how to build and customize graphs by using ggplot2 in R; and how to create heat maps, a representation of data in form of a map or diagram. Finally, learn to create scatter plots and create area charts with R.
11 videos | 34m has Assessment available Badge
Storytelling with Data: Introduction
In this 10-video course, learners can explore the concept of storytelling with data, including processes involved in storytelling and interpreting data contexts. You will explore prominent types of analysis, visualizations, and graphics tools useful for storytelling. Become familiar with various processes: storytelling with analysis, and its types; storytelling with visualization; and storytelling with scatter plots, line charts, heat maps, and bar charts. Popular software programs are also used: d3.js (Data-Drive Document), WebDataRocks, Birt, Google Charts, and Cytoscape. Users of storytelling include three types: strategists, who actually build strategy for story making; developers or designers, who often use videos, images, infographics to create experience architecture; and marketers or salespeople, who uses different modes including visual social networks, calendaring, messaging in visual form, digital signage, UGC or employee advocacy, story selling, live streaming, or data storytelling. A concluding exercise asks learners to recall elements of storytelling context; specify types of analysis used to facilitate storytelling with data; list prominent visualizations used to facilitate storytelling with data; and list prominent graphical tools useful for data exploration.
10 videos | 46m has Assessment available Badge
Storytelling with Data: Tableau & Power BI
To convey the true meaning of data most effectively, data scientists and data management professionals need to be able to harness the capabilities of different approaches of storytelling with data. This 14-video course explores how to select the most effective visuals for a storytelling project, how to eliminate clutter, and how to choose the best practices for story design. In addition, learners will see demonstrations of how to work with Tableau and Power BI bar charts to facilitate storytelling with data. Learn to select appropriate visuals for your data storytelling project; how to use slopegraphs; and learn important steps to take in cluttering and de-cluttering data. Explore the gestalt principle, as well as common problems of visual story design. In the concluding exercise, learners will load data by using Power BI from a CSV file; create a bar chart by using the data; and create a pie chart to show the whole-part relation in the data.
14 videos | 56m has Assessment available Badge
SHOW MORE
FREE ACCESS

COURSES INCLUDED

Plotly for Data Visualization: Advanced Charts & Features in Chart Studio
There are many specialized charts and other advanced features available in Plotly Chart Studio, which can be used to give life to your data. These include Box and Violin plots to analyze the distribution of values, Candlestick charts to analyze tradeable assets' performance, and map charts to visualize geographical data. In this course, you'll learn how to work with these chart types, as well as funnel, treemaps, and sunburst charts. You'll also practice sharing plots and charts with collaborators and viewers. Beyond this, you'll learn how to create a dashboard to group related charts. You'll generate curves, namely a moving average and a fitted curve, to augment some of your charts. You'll then finish my writing some Python code and using it to generate charts from a Python application.
15 videos | 1h 42m has Assessment available Badge

COURSES INCLUDED

Data Visualization: More Specialized Visualizations in Bokeh
Bokeh facilitates the creation of high-performance charts allowing users to build impactful web-based dashboards and applications. In this course, you'll investigate how to visualize your data using complex charts in Bokeh. First, you'll identify how to visualize relationships that exist in your data using scatter plots, discover the function of jitter in viewing individual data points, and configure scatter plots where both axes represent continuous values. Next, you'll outline how to represent relationships between pairs of variables using heatmaps. You'll then recognize the use of line and area charts to visualize time-series data. Finally, you'll explore how to visualize data structures in the form of nodes and edges using network graphs. When you have completed this course, you'll possess the skills and knowledge to build simple as well as complex interactive visualizations using Bokeh.
9 videos | 1h 7m has Assessment available Badge
Data Visualization: Getting Started with Plotly
Plotly is Python's browser-based graphing library, which provides users with online graphing, analytics, and statistics tools. In this course, you'll explore how to use Plotly's declarative APIs to build interactive graphs and visualizations. You'll start this course by getting familiar with the components of the Plotly library. You'll identify the role of the high-level library (plotly.express) in creating visualizations and the low-level library (plotly.graph_objects) in creating granular customizations of your charts. Next, you'll investigate the use of box plots in visualizing the statistical properties of a continuous data series. You'll also discover how to represent additional categorical data by creating separate box plots and customizing their color. Finally, you'll examine how to implement a candlestick chart to reflect the trend of stock price performance over a period of time and visualize sequential data in a linear process using funnel charts.
9 videos | 1h 8m has Assessment available Badge
Data Visualization: Visualizing Data Using Advanced Charts in Plotly
Using data visualizations during exploratory data analysis is an important part of the data science process. The Plotly graphing library helps with this by allowing users to investigate their data through interactive charts. In this course, you will explore the construction and applications of advanced charts in Plotly for varied use cases. You'll begin by identifying how to present multi-dimensional ordinal data along different axes using radar charts. You'll then recognize how to use sunburst charts to visualize multi-level hierarchical data. Next, you'll implement Gantt charts to visualize schedules and timelines in a project and then move on to exploring how to represent the flow of data between entities using Sankey diagrams. You'll finish the course by investigating the use of geo plots and choropleth maps in visualizing geographical data and plot locations.
9 videos | 1h 9m has Assessment available Badge

EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE COURSES

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

BOOKS INCLUDED

Book

#MakeoverMonday: Improving How We Visualize and Analyze Data, One Chart at a Time
Exploring different perspectives and approaches to creating more effective visualizations, this book offers inspiration and a giant dose of perspective for those who communicate data.
book Duration 3h 57m book Authors By Andy Kriebel, Eva Murray

Book

Data Visualization and Statistical Literacy for Open and Big Data
Featuring extensive coverage on emerging relevant topics such as data complexity, statistics education, and curriculum development, this book highlights methodological developments in the way that data analytics is both learned and taught.
book Duration 6h 49m book Authors By Theodosia Prodromou

Book

Data Visualization, Volume II: Uncovering the Hidden Pattern in Data Using Basic and New Quality Tools
Providing a collection of visuals and graphical tools, this book focuses on data visualization and information visualization tools-two major categories of data visualization.
book Duration 1h 47m book Authors By Amar Sahay

Book

Making Sense of Data II: A Practical Guide to Data Visualization, Advanced Data Mining Methods, and Applications
Detailing how to define a problem, perform an analysis, and deploy the results, this indispensible book equips readers with advanced data mining methods that are needed to successfully translate raw data into smart decisions across various fields of research.
book Duration 4h 32m book Authors By Glenn J. Myatt, Wayne P. Johnson

Book

Making Sense of Data III: A Practical Guide to Designing Interactive Data Visualizations
Including step-by-step examples and numerous exercises, this indispensable book describes the best approach for designing and implementing interactive graphics and visualizations that play a central role in data exploration and decision-support systems.
book Duration 4h 57m book Authors By Glenn J. Myatt, Wayne P. Johnson

Book

Data Visualization for Dummies
Part technical manual and part analytical guidebook, this straightforward, full-color resource is the perfect tool for transforming dull tables and charts into high-impact visuals your audience will notice and remember.
book Duration 3h 11m book Authors By Mico Yuk, Stephanie Diamond

Book

The Visual Organization: Data Visualization, Big Data, and the Quest for Better Decisions
Rife with real-world examples and case studies, this full-color guide looks at how an increasing number of organizations are embracing new dataviz tools and, more importantly, a new mind-set based upon data discovery and exploration.
book Duration 3h 33m book Authors By Phil Simon

Book

High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, Second Edition
Covering new features and added support for visualization in Excel 2016, this essential book helps in harnessing the power of Microsoft's flagship, self-service business intelligence suite to deliver compelling and interactive insight with remarkable ease.
book Duration 8h 45m book Authors By Adam Aspin
SHOW MORE
FREE ACCESS

BOOKS INCLUDED

Book

Foundations of Data Visualization
This book focuses entirely on the fundamental questions in visualization.
book Duration 8h 40m book Authors By Gerik Scheuermann, Helwig Hauser, Min Chen

Book

Data Visualization, Volume II: Uncovering the Hidden Pattern in Data Using Basic and New Quality Tools
Providing a collection of visuals and graphical tools, this book focuses on data visualization and information visualization tools-two major categories of data visualization.
book Duration 1h 47m book Authors By Amar Sahay

BOOKS INCLUDED

Book

Storytelling With Data: A Data Visualization Guide For Business Professionals
Teaching you the fundamentals of data visualization and how to communicate effectively with data, this book demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story.
book Duration 2h 55m book Authors By Cole Nussbaumer Knaflic

Book

Practical SQL: A Beginner's Guide to Storytelling with Data
With exercises and real-world examples in each chapter, this approachable and fast-paced guide will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.
book Duration 6h 46m book Authors By Anthony DeBarros

Book

Data Visualisation with R: 100 Examples
Offering a comprehensive introduction to creating presentation graphics with R, this book presents the complete code of 100 examples from various fields and includes step-by-step explanations of the programming of figures, based on real data.
book Duration 4h 12m book Authors By Thomas Rahlf

Book

Pro Data Visualization using R and JavaScript
Combining the power of the R language with the simplicity and familiarity of JavaScript, this book shows you how to use R to interrogate and analyze your data, and then use the D3 JavaScript library to format and display that data in an elegant, informative, and interactive way.
book Duration 2h 27m book Authors By Tom Barker

Book

Jumpstart Tableau: A Step-By-Step Guide to Better Data Visualization
Covering the basic reporting and analysis functions that most BI users perform in their day-to-day work, this practical book simplifies the use of Tableau software functionality for novice users so that they can create powerful data visualizations easily and quickly.
book Duration 1h 4m book Authors By Arshad Khan

Book

#MakeoverMonday: Improving How We Visualize and Analyze Data, One Chart at a Time
Exploring different perspectives and approaches to creating more effective visualizations, this book offers inspiration and a giant dose of perspective for those who communicate data.
book Duration 3h 57m book Authors By Andy Kriebel, Eva Murray
SHOW MORE
FREE ACCESS

SKILL BENCHMARKS INCLUDED

Business Analyst to Data Analyst Competency
The Business Analyst to Data Analyst competency benchmark will measure your ability to recall, recognize, and understand concepts and techniques applied as a business analyst working with Excel, Tableau, and Power BI. You will be evaluated on your ability to recognize business analytics techniques and functions in Tableau, Power BI, and Maria DB; create basic data visualizations using charts; create dashboards; load data from files in Tableau; analyze tables; apply transformations, data validation, and cleaning; and use pivot tables. A learner who scores high on this benchmark demonstrates that they have the required skills in business analytics to build effective dashboards and share reports and insights with business users.
25m    |   25 questions
Business Analyst to Data Analyst Proficiency
The Business Analyst to Data Analyst Proficiency benchmark will measure your ability to recall, recognize, and apply business analytics concepts and features of Tableau, Power BI, Python, and BigML. You will be evaluated on your ability to recognize and use business analytics techniques in Tableau, Power BI, Maria DB, Python, and Big ML for data visualizations using various charts, including Google charts. You will be evaluated on your ability to create dashboards; load data from a variety of files in Tableau; analyze tables; apply transformations, data validation, and cleaning; use pivot tables; use Python pandas for data analysis; and leverage Maria DB and BigML for machine learning models. A learner who scores high on this benchmark demonstrates that they have strong skills in business analytics and data analytics to build effective dashboards and share reports and insights with business users.
20m    |   20 questions
Business Analyst to Data Analyst Literacy
The Business Analyst to Data Analyst Literacy benchmark will measure your ability to recall, recognize, and understand concepts and techniques applied as a business analyst such as basic and advanced Excel for analytics. You will be evaluated on your ability to recognize the basic concepts of business analytics techniques and functions in Excel for data import and export, data visualizations using various charts, statistical analysis, data validation and cleaning, pivot tables, and the basics of Tableau and Power BI. A learner who scores high on this benchmark demonstrates that they have the required foundation of business analytics skills to understand and apply in their projects.
20m    |   20 questions

SKILL BENCHMARKS INCLUDED

Data Visualization Competency
The Data Visualization mastery Competency benchmark will measure your ability to recall, relate, and demonstrate applying the underlying Data Visualization concepts and techniques in Excel, Qlikview and Python. You will be evaluated on your ability to recognize the concepts of data visualization, techniques, and functions in Excel, Qlikview, Infographics, and Python. A learner who scores high on this benchmark demonstrates that they have the required data visualization skills to understand and apply visualization techniques in their projects.
30m    |   20 questions
Data Visualization Mastery
The Data Visualization Mastery benchmark will measure your ability to recall, relate, demonstrate, and apply the data visualization concepts and techniques in Excel, Qlickview, and various Python visualization libraries. You will be evaluated on your ability to recognize and apply the concepts of data visualization techniques, tools, and functions in Excel, QlikView, Infogram, and Python. A learner who scores high on this benchmark demonstrates that they have the required data visualization skills to understand, apply, and work independently on the visualizations in their projects.
30m    |   20 questions
Data Visualization with Excel Proficiency
The Data Visualization with Excel Proficiency benchmark will measure your ability to recall, relate, demonstrate, and apply data visualization concepts and techniques in Excel. You will be evaluated on your ability to draw, customize, and visualize various types of charts and graphs in Excel. A learner who scores high on this benchmark demonstrates that they have the required data visualization skills to understand, apply, and work independently on visualization projects using Excel.
10m    |   10 questions
Data Visualization with Excel Literacy
The Data Visualization with Excel Literacy benchmark will measure your ability to recall and relate data visualization concepts in Excel. You will be evaluated on your ability to recognize the foundational concepts of data visualization, its uses, and best practices, including the basics of visualization in Excel. A learner who scores high on this benchmark demonstrates that they have the basic data visualization skills to understand and grasp visualization techniques and their uses.
13m    |   13 questions
Data Visualization with Excel Competency
The Data Visualization with Excel Competency benchmark will measure your ability to recall, relate, and demonstrate how to apply underlying data visualization concepts and techniques in Excel. You will be evaluated on your ability to recognize the concepts of data visualization and Excel techniques and functions for various types of charts and graphs. A learner who scores high on this benchmark demonstrates that they have the required data visualization skills to understand and apply visualization techniques in projects using Excel.
14m    |   14 questions
SHOW MORE
FREE ACCESS

SKILL BENCHMARKS INCLUDED

Data Visualization Literacy
The Data Visualization Literacy benchmark will measure your ability to recall and relate the underlying data visualization concepts in Excel. You will be evaluated on your ability to recognize the foundational concepts of data visualization, its uses, and best practices like the basics of visualization in Excel, Qlikview, and Python. A learner who scores high on this benchmark demonstrates that they have the basic data visualization skills to understand and grasp the visualization techniques and their uses.
30m    |   20 questions

YOU MIGHT ALSO LIKE

Likes 142 Likes 142  
Likes 244 Likes 244