Aspire Journeys

Business Analyst to Data Analyst

  • 38 Courses | 47h 40m 21s
  • 4 Labs | 32h
Likes 160 Likes 160
Data Analysts interpret data and turn it into information that drives business decisions. This journey will guide you in the transition from Business Analyst to a Data Analyst by teaching the required skills. In this Skillsoft Aspire journey, a stage is set by covering comprehensive courses on Excel, a powerful, most common, and widely used data analysis tool in the industry. It then teaches you the most popular Data Visualization tools and techniques. You will also learn the about Data Analysis using Python. Here, you will explore data gathering, exploration, cleaning, and transforming using Python. You will also learn BigML which is a popular Machine Learning platform.

Track 1: Business Analyst

In this Business Analyst track of this Skillsoft Aspire journey, the focus is on basic to advanced Excel skills. Excel is the most popular and powerful tool widely used in the industry to instantly analyze the data. It has many potential applications with extensive, customizable features for almost all kinds of workflows. This track provides a comprehensive and advanced training on using many important features and tools in excel.  It covers basic operations like data import and export, customizing tool bars, data visualizations using various bars and charts, various statistical analysis to more advanced features like data validations, data cleaning, data manipulations, pivot tables and modelling relationships among data.

  • 8 Courses | 9h 29m 4s
  • 1 Lab | 8h

Track 2: Decision Analyst

In this Skillsoft Aspire journey Decision Analyst track, the focus is on Tableau and Power BI.

Tableau is widely used in the industry for Business Intelligence, creating dash boards, interactive graphs and charts for data interpretation and gaining business insights. This track will make you proficient in Tableau by introducing basic features of tableau like loading data from a wide variety of files and taking you through many important features for analyzing tables, applying transformations, various chart interactions as well as data cleaning to effectively tell your story with data.

Power BI is another most common, widely used, and powerful tool to analyze data from various sources, visualize and report data. You can create effective dash boards and share reports and insights with business users. You will learn how to combine Power Query and Power BI to perform basic to advanced operations on data.

  • 8 Courses | 9h 50m 49s
  • 1 Lab | 8h

Track 3: Systems Analyst

This Skillsoft Aspire journey track introduces you to the simple, easy to use, and powerful visualization tools like Google Charts and Chart studio. It also focuses on the popular relational database MariaDB.

Google Charts are simple and handy tool for developers who need to create standard, powerful, and interactive charts. They allow us to create graphical charts for visualizations on web from user supplied information. You will learn how to construct fundamental Google charts to visualize data, constructing interactive graphic charts, to apply and configure a wide range of available visualizations from Google Charts library to represent your data.

Chart Studio is the easiest way to graph and share your data. By incorporating Chart Studio in existing workflows, we can create interactive charts using various themes and templates. This track introduces this powerful and handy visualization tool by covering the basics like loading data into Chart Studio from various data sources and teaches how to include multiple charts by setting up a single plot which allows users to analyze the data along various dimensions. You will also learn working with various charts, plots, graphs, and even specialized and advanced charts to visualize complex data.

You will also learn MariaDB, one of the most popular relational databases for SQL programming. You will learn installing MariaDB on windows and SQL programming with MariaDB.

  • 10 Courses | 12h 5m 8s
  • 1 Lab | 8h

Track 4: Data Analyst

This Skillsoft Aspire journey track focuses on Excel’s VBA, a powerful tool for multitude of purposes. It also focuses on BigML, a simple, programmable, and scalable Machine Learning platform. You will also learn data analysis using Python and the most popular Pandas library. 

  • 12 Courses | 16h 15m 20s
  • 1 Lab | 8h


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 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 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 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 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 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 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 has Assessment available Badge
Final Exam: Business Analyst
Final Exam: Business Analyst will test your knowledge and application of the topics presented throughout the Business Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
1 video | 32s has Assessment available Badge
Tableau for Data Visualization: Introduction
Tableau is a data visualization tool suitable for a variety of purposes and situations. Knowing the basics of this tool will help you share necessary data with stakeholders and peers in a meaningful and engaging way. This course will introduce you to Tableau's basic features and cover the fundamental operations performed with this tool. You'll start by loading data into Tableau using a variety of file types. You'll then apply transformations to your data and choose the most appropriate visualization for it. Next, you'll learn how to analyze data in multiple related tables as well as data categories. You'll then practice setting the aesthetics of charts and garnering detailed information through chart interactions. Lastly, you'll get hands-on with the Tableau data interpreter to clean a dataset.
11 videos | 1h has Assessment available Badge
Tableau for Data Visualization: Exploring Visualizations & Data Formats
Tableau not only has a variety of tools to visualize data, but it also allows you to redefine the fields in your data to convey rich meaning. In this course, you'll explore how multiple dimensions of the underlying data can be portrayed using shapes, colors, and labels. You'll learn to build a wide variety of charts, such as pie charts, treemaps, and many more, to convey various information types. You'll also work with different techniques, such as hierarchical, combined, and calculated fields, to arrange the fields in the underlying dataset into hierarchies and groups, portraying relationships and facilitating data drill-downs for your users. Lastly, you'll learn how you can generate sets from combined data, so this data can be analyzed with the context of the set, as well as outside it.
14 videos | 1h has Assessment available Badge
Tableau for Data Visualization: Advanced Features
In addition to everything you'd expect from a data visualization tool, Tableau has extensive support for many advanced visual customization and user interaction features. This course gives you a taster of how these features work. You'll start by using Tableau maps to render country-specific information and then further customize these maps, rendering their appearance and using map layers. You'll then assemble multiple charts together to collectively convey information using dashboards. Next, you'll learn how to change the aesthetic appearance of Tableau dashboards and update them to include charts and other interactive objects and settings, such as navigation buttons, text labels, and download options. Lastly, you'll learn how to share a story publicly in the form of visualizations comprising charts and a dashboard using Tableau's publish feature.
10 videos | 1h has Assessment available Badge
Business Reporting: Getting Started with Power BI Desktop for Data Analysis
Power BI is one of the most commonly-used tools for building data reports from various source data. In this course, you'll start by installing Power BI Desktop and importing data to it from several sources, including the relational databases, MySQL and PostgreSQL, cloud data warehouses, and Excel, CSV, JSON, and XML files. You'll then use Power BI to perform simple operations, such as changing data types, renaming columns, and using uppercase text. You'll also open and run the Power Query app. Moving on, you'll use Power BI to create and format simple data visualizations, such as bar charts, line charts, and stacked bar charts. Finally, you'll practice aggregating numeric data and string (categorical) data in charts, working with the correct aggregation operators for their respective fields.
11 videos | 1h has Assessment available Badge
Business Reporting: Visualizing & Merging Data in Power BI
Power BI and Power Query can be used in combination to facilitate both basic and advanced operations. In this course, you'll learn how to use Power Query to create the two types of calculated columns, custom and conditional. Next, you'll use Power BI to import and clean data and create stacked line charts (area charts) to visualize data. You'll filter the unique categorical values of the visualized series using various filtering techniques. You'll then combine data between tables using a foreign key relationship and create a bar chart with line markers using the analytics card. You'll move on to import a large number of files residing in the same folder. Lastly, you'll use Power BI's UI and Advanced Editor to perform basic data cleaning operations and Power Query to perform various advanced operations.
10 videos | 1h has Assessment available Badge
Business Reporting: Creating & Formatting Matrix Visualizations in Power BI
Some of Power BI's advanced capabilities include mapping relationships among tables and customizing the look and functionality of matrix visualizations. You'll start this course using E-R (entity-relationship) diagrams to create, edit, and delete relationships among columns in different tables. You'll then move on to creating matrix visualizations and setting up a matrix control. You'll use the matrix control to visualize parent and child columns via a drill-down feature. You'll then create a column from a formula (known as a measure in Power BI) and perform various formatting operations to your matrix visualization, such as adding a title and row subtotals, editing text size and alignment, and turning on vertical and horizontal gridlines. Lastly, you'll implement conditional formatting on your matrix visualization.
13 videos | 2h has Assessment available Badge
Business Reporting: Leveraging Treemaps, Matrices, & Slicers in Power BI
Treemaps are an impressive hierarchical data visualization feature of Power BI. Add in tooltips, matrices, slicers, and mobile readiness, and your reports will be highly interactive and engaging. You'll start this course by creating and configuring a treemap in Power BI. You'll then set up a treemap tooltip and configure it to use a chart on another Power BI page. Next, you'll create a Power BI report that automatically links the treemap to a matrix visualization. You'll then optimize this report for mobile device viewing. You'll move on to use slicers and add them to a page in your Power BI report. Lastly, you'll work with different slicer settings for numeric and string (categorical) fields and implement horizontal and vertical slicer layouts.
8 videos | 1h has Assessment available Badge
Final Exam: Decision Analyst
Final Exam: Decision Analyst will test your knowledge and application of the topics presented throughout the Decision Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
1 video | 30m has Assessment available Badge
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 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 | 51m 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 | 1h has Assessment available Badge
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 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 has Assessment available Badge
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 has Assessment available Badge
SQL Programming with MariaDB: Getting Started with MariaDB for Data Analysis
MariaDB is a popular tool for SQL programming. To use it, you must first know how to install it on your machine and set it up for your needs. In this course, you'll learn how to install MariaDB for macOS and MS Windows. You'll then run MariaDB from a command line interface (CLI) and create a new custom user for MariaDB from the CLI -an essential step for running MariaDB from a client such as DBeaver, as connecting as root is not considered a best practice. Next, you'll work with DBeaver and recognize how it is a handy user interface to interact with a MariaDB server. Finally, you'll run a few basic MariaDB commands and queries from DBeaver.
9 videos | 1h has Assessment available Badge
SQL Programming with MariaDB: Analyzing Relational Data
To query data with SQL, you need to know which queries and keywords to use for which operations. In this course, you'll learn to query data using the classic SQL syntax construct, the SELECT-FROM-WHERE query, and how keywords, such as LIKE, can be used to filter data based on a condition and using wildcards. You'll learn how to carry out different aspects of inserting, updating, and deleting data - such operations, along with querying, are collectively known as CRUD operations, an acronym for Create-Read-Update-Delete. Finally, you'll learn how to take advantage of another important aspect of relational database usage - the ability to impose constraints upon data. You'll work with UNIQUE, NOT NULL, and FOREIGN KEY constraints.
10 videos | 1h has Assessment available Badge
SQL Programming with MariaDB: Using Joins, Triggers, & Stored Procedures
Joins, triggers, and stored procedures are useful tools to take advantage of when working with MariaDB. In this course, you'll begin by using several types of joins, such as cross joins, inner joins, and outer joins, to combine data from multiple tables.

Next, you'll use aggregate functions, such as SUM, MIN, MAX, AVERAGE, and COUNT, with the GROUP BY clause to group data in rows based on a specified column. You'll then use the HAVING clause as a way to filter the output of the GROUP BY clause.

You'll move on to use the two types of generated columns - virtual and persistent, computing them on-the-fly from a function expression.

Finally, you'll use triggers to perform operations whenever a condition is satisfied and stored procedures for code re-use and parameterization.
14 videos | 2h has Assessment available Badge
Final Exam: Systems Analyst
Final Exam: Systems Analyst will test your knowledge and application of the topics presented throughout the Systems Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
1 video | 30m has Assessment available Badge
VBA: Getting Started with VBA in Excel
Excel's VBA can be a powerful tool useful for a multitude of purposes if you know how to leverage its capabilities, debug issues, and mitigate for specific limitations. In this introductory course, you'll begin by using subroutines in VBA to perform operations. You'll then define functions and reference and edit cell ranges and Excel sheets with VBA. After that, you'll invoke subroutines with relative cell references, record macros in Excel, and debug macros in VBA. You'll insert columns and sheets from VBA and format cells based on a condition in VBA both manually and using a FormatConditions object. Finally, you'll illustrate how clearing formatting using a FormatConditions object will only clear formatting created using a FormatConditions object, not by using if-else conditionals.
13 videos | 2h has Assessment available Badge
VBA: Building User Interfaces with Forms in VBA & Excel
One of the many capabilities of Excel's VBA is building complex user interfaces within Excel. Part of this is the creation of complex forms for gathering input data. In this course, you'll learn how to create user forms using VBA in Excel and, in doing so, achieve user interfaces with complex controls like combo boxes and spinners. You'll also learn how to send emails from VBA while being mindful of security risks and the configuration required if the email provider is Gmail. You'll learn how to validate form input data, insert it into an Excel spreadsheet, and illustrate how such user input can be accepted using complex controls, such as radio buttons and checkboxes, and buttons that, when clicked, trigger the invocation of VBA subroutines.
10 videos | 1h has Assessment available Badge
VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access
Leveraging VBA with Excel has many useful capabilities, including the creation and management of pivot tables and charts, and the automation of tasks in MS Access, the lightweight relational database. In this course, you'll learn how to create and edit pivot tables and different chart types, such as bar charts and line charts, using VBA in Excel. You'll then save these Excel charts as images, again using VBA. Next, you'll use Excel's stock datatype to access financial data. Moving on, you'll learn how to use VBA to automate tasks in MS Access, accept user input, validate it, and insert it into an MS Access database. You'll also learn how to run simple SQL queries against that database. Finally, you'll set up event handlers in Excel using VBA and illustrate their purpose. 
14 videos | 2h has Assessment available Badge
Using BigML: An Introduction to Machine Learning & BigML
From self-driving cars to predicting stock prices, machine learning has an exciting range of applications. BigML, due to its ease of use, makes these algorithms widely accessible. This course outlines machine learning fundamentals and how these are applied in BigML. You'll start by examining various machine learning algorithm categories and the kinds of problems they're used to solve. You'll then investigate the classification problem and the process involved in training and evaluating such models. Next, you'll examine linear regression and how this can help predict a continuous value. Moving on, you'll explore the concept of unsupervised learning and its application in clustering, Principal Component Analysis (PCA), and generating associations. Finally, you'll recognize how all of this comes together when using BigML to significantly simplify the building and maintenance of your machine learning models.
11 videos | 1h has Assessment available Badge
Using BigML: Getting Hands-on with BigML
BigML not only provides ease-of-use, but it also offers flexibility in how you work with your data. This course serves as a hands-on introduction to BigML and its vast array of features. You'll start by exploring the different ways data can be loaded into the platform and how these can be transformed into datasets to train and test a machine learning model. You'll gain practical experience with some of the tools available to help you better understand your data - from histograms and scatterplots to visualizations of value distribution. Moving on, you'll build a fundamental classification model, a decision tree, which takes employee details and predicts whether they'll stay or leave in the next year. Finally, you'll investigate some possible configurations for this model.
11 videos | 1h has Assessment available Badge
Using BigML: Building Supervised Learning Models
The versatility of BigML allows you to build supervised learning models without much complexity. In this course, you'll practice constructing a selection of supervised learning models using BigML. You'll start by building an ensemble of decision trees to perform binary classification. Next, you'll build a linear regression model to predict the values of homes in a particular region. You'll then train and evaluate a logistic regression model to illustrate how it can be used to solve similar problems to those solved using ensemble methods. Another BigML capability you'll explore is building a time series plot to make various forecasts. In each demonstration, you'll delve into some optional configurations for the model being trained. Lastly, you'll use the OptiML feature to find the optimal model for your data.
14 videos | 1h has Assessment available Badge
Using BigML: Unsupervised Learning
BigML includes various unsupervised learning models used to gain insights into your data. These insights can help make pivotal business decisions or act as a starting point to build supervised learning models. In this course, you'll build several unsupervised learning models and analyze the results they produce. You'll start by creating clusters from a dataset and examining how data points within a cluster share similarities. You'll move on to uncover associations in a dataset about items purchased on an e-commerce platform. Next, you'll apply topic modeling to extract the topics discussed in a collection of texts. Following this, you'll transform a dataset containing multiple fields into a handful of principal components using Principal Component Analysis, or PCA. Finally, you'll explore the detection of anomalies in your dataset.
9 videos | 1h has Assessment available Badge
Analyzing Data Using Python: Data Analytics Using Pandas
Built on the Python programming language, pandas provides a flexible and open source tool for data manipulation. In this course, you'll develop the skills you need to get started with this library. You'll begin by installing pandas from a Jupyter notebook using pip. Next, you'll instantiate a pandas object, including a Series and DataFrame, and practice several ways of instantiating Dataframes - for instance, from lists, dictionaries of lists, and tuples created from lists using the zip method. You round out this course by performing filter operations on DataFrames using the loc and iloc operations - fundamental techniques used to access specific rows and columns. You'll use loc to identify rows based on labels and iloc to access rows based on the index offset position starting from 0.
9 videos | 1h has Assessment available Badge
Analyzing Data Using Python: Importing, Exporting, & Analyzing Data With Pandas
You can analyze a myriad of data formats through pandas - all you need to know is how. In this course, you'll bring various data types into pandas and perform several operations on the data. You'll practice using common file types such as CSV, Excel, JSON, and HTML through pandas. You'll not only learn how to open and read files of different types, but you'll also serialize objects and copy them to the in-memory clipboard. You'll move on to perform various fundamental operations on DataFrame objects. Lastly, you'll learn to compute basic statistics, access metadata, and modify and sort data in rows.
10 videos | 1h has Assessment available Badge
Analyzing Data Using Python: Filtering Data in Pandas
Not all data is useful. Luckily, there are some powerful filtering operations available in pandas. The course begins with a detailed look at how loc and iloc can be used to access specific data from a DataFrame. You'll move on to filter data using the classic pandas lookup syntax and the pandas filter and query methods. You'll illustrate how the filter function accepts wildcards as well as regular expressions and use various methods such as the .isin method to filter data. Furthermore, you'll filter data using either two pairs of square brackets - in which case the resulting subset is itself a DataFrame - or a single pair of square brackets, in which case the returned data takes the form of a Series. You'll drop rows and columns from a pandas DataFrame and see how rows can be filtered out of a DataFrame. Lastly, you'll identify a possible gotcha that arises when you drop rows in-place but neglect to reset the index labels in your object.
10 videos | 1h has Assessment available Badge
Analyzing Data Using Python: Cleaning & Analyzing Data in Pandas
For data analysis to be useful and accurate, the analyzed data needs to be cleaned and curated. There are copious methods to achieve this in pandas. In this course, you'll learn how to identify and eliminate duplicates in pandas. You'll start by using the pandas cut method to discretize data into bins, using bins to plot histograms and identify outliers using box-and-whisker plots. You'll parse and work with datetime objects read in from strings and convert string columns to datetime using the dateutils python library. Moving on, you'll master different pandas methods for aggregating data - including the groupby, pivot, and pivot_table methods. Lastly, you'll perform various joins - inner, left outer, right outer, and full outer - using both the merge and join methods.
13 videos | 1h has Assessment available Badge
Final Exam: Business Analyst to Data Analyst
Final Exam: Data Analyst will test your knowledge and application of the topics presented throughout the Data Analyst track of the Skillsoft Aspire Business Analyst to Data Analyst Journey.
1 video | 30m has Assessment available Badge


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.


Card image
Likes 0 Likes 0  
Card image
Likes 61 Likes 61