Aspire Journeys

Business Analyst to Data Analyst

  • 38 Courses | 52h 15m 22s
  • 4 Labs | 32h
Likes 120 Likes 120
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 | 10h 30m 35s
  • 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 | 10h 52m 19s
  • 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 | 13h 16m 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 | 17h 36m 20s
  • 1 Lab | 8h

COURSES INCLUDED

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 | 30m
has Assessment