Data Visualization Core Concepts: Excel 365 beginner
Data Visualization:
Expertise:
- 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
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
-
1.What is Data Visualization3m 46sNOW PLAYING
-
2.Knowing Your Audience3m 50sUP NEXT
GETTING STARTED
Visme: Introduction
-
1.Course Overview2m 11sNOW PLAYING
-
2.Getting Started with Visme11m 12sUP NEXT
GETTING STARTED
Data Visualization: Best Practices for Creating Visuals
-
1.Course Overview2m 31sNOW PLAYING
-
2.Importance of Data Visualization9m 14sUP NEXT
GETTING STARTED
Excel Visualization: Getting Started with Excel for Data Visualization
-
1.Course Overview1m 37sNOW PLAYING
-
2.Performing Basic Data Load Operations in Excel11m 49sUP NEXT
GETTING STARTED
Google Chart Tools: Basic Charts
-
1.Course Overview2m 11sNOW PLAYING
-
2.Rendering a Pie Chart8m 54sUP NEXT
GETTING STARTED
Infogram: Getting Started
-
1.Course Overview1m 58sNOW PLAYING
-
2.Setting Up and Exploring Infogram11m 21sUP NEXT
GETTING STARTED
Plotly for Data Visualization: An Introduction to Plotly Chart Studio
-
1.Course Overview2m 38sNOW PLAYING
-
2.Setting up Chart Studio6m 55sUP NEXT
GETTING STARTED
Data Visualization: Building Interactive Visualizations with Bokeh
-
1.Course Overview1m 54sNOW PLAYING
-
2.Installing Bokeh5m 43sUP NEXT
GETTING STARTED
Excel Visualization: Building Column Charts, Bar Charts, & Histograms
-
1.Course Overview1m 50sNOW PLAYING
-
2.Creating Excel Clustered and Stacked Column Charts7m 52sUP NEXT
GETTING STARTED
Excel Visualization: Building Box Plots, Sunburst Plots, Gantt Charts, & More
-
1.Course Overview2m 51sNOW PLAYING
-
2.Displaying Statistics Using Box Plots in Excel10m 54sUP NEXT
GETTING STARTED
Advanced Visualizations & Dashboards: Visualization Using Python
-
1.Course Overview1m 43sNOW PLAYING
-
2.Relevance of Data Visualization for Business3m 42sUP NEXT
GETTING STARTED
Plotly for Data Visualization: Advanced Charts & Features in Chart Studio
-
1.Course Overview2m 22sNOW PLAYING
-
2.Using Plotly Chart Studio Box Plots8m 9sUP NEXT
GETTING STARTED
Data Visualization: More Specialized Visualizations in Bokeh
-
1.Course Overview2m 2sNOW PLAYING
-
2.Creating Scatter Plots Using Bokeh11m 53sUP 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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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
Assessment
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 TimeExploring different perspectives and approaches to creating more effective visualizations, this book offers inspiration and a giant dose of perspective for those who communicate data.
3h 57m
By Andy Kriebel, Eva Murray
Book
Data Visualization and Statistical Literacy for Open and Big DataFeaturing 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.
6h 49m
By Theodosia Prodromou
Book
Data Visualization, Volume II: Uncovering the Hidden Pattern in Data Using Basic and New Quality ToolsProviding a collection of visuals and graphical tools, this book focuses on data visualization and information visualization tools-two major categories of data visualization.
1h 47m
By Amar Sahay
Book
Making Sense of Data II: A Practical Guide to Data Visualization, Advanced Data Mining Methods, and ApplicationsDetailing 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.
4h 32m
By Glenn J. Myatt, Wayne P. Johnson
Book
Making Sense of Data III: A Practical Guide to Designing Interactive Data VisualizationsIncluding 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.
4h 57m
By Glenn J. Myatt, Wayne P. Johnson
Book
Data Visualization for DummiesPart 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.
3h 11m
By Mico Yuk, Stephanie Diamond
Book
The Visual Organization: Data Visualization, Big Data, and the Quest for Better DecisionsRife 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.
3h 33m
By Phil Simon
Book
High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI, Second EditionCovering 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.
8h 45m
By Adam Aspin
SHOW MORE
FREE ACCESS
BOOKS INCLUDED
Book
Foundations of Data VisualizationThis book focuses entirely on the fundamental questions in visualization.
8h 40m
By Gerik Scheuermann, Helwig Hauser, Min Chen
Book
Data Visualization, Volume II: Uncovering the Hidden Pattern in Data Using Basic and New Quality ToolsProviding a collection of visuals and graphical tools, this book focuses on data visualization and information visualization tools-two major categories of data visualization.
1h 47m
By Amar Sahay
BOOKS INCLUDED
Book
Storytelling With Data: A Data Visualization Guide For Business ProfessionalsTeaching 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.
2h 55m
By Cole Nussbaumer Knaflic
Book
Practical SQL: A Beginner's Guide to Storytelling with DataWith 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.
6h 46m
By Anthony DeBarros
Book
Data Visualisation with R: 100 ExamplesOffering 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.
4h 12m
By Thomas Rahlf
Book
Pro Data Visualization using R and JavaScriptCombining 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.
2h 27m
By Tom Barker
Book
Jumpstart Tableau: A Step-By-Step Guide to Better Data VisualizationCovering 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.
1h 4m
By Arshad Khan
Book
#MakeoverMonday: Improving How We Visualize and Analyze Data, One Chart at a TimeExploring different perspectives and approaches to creating more effective visualizations, this book offers inspiration and a giant dose of perspective for those who communicate data.
3h 57m
By Andy Kriebel, Eva Murray
SHOW MORE
FREE ACCESS
SKILL BENCHMARKS INCLUDED
Business Analyst to Data Analyst Competency (Intermediate Level)
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 (Advanced Level)
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 (Beginner Level)
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 (Intermediate Level)
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 (Expert Level)
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 (Advanced Level)
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 (Beginner Level)
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 (Advanced Level)
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 (Beginner Level)
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
