Business Analyst to Data Analyst
- 38 Courses | 47h 40m 21s
- 4 Labs | 32h
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
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.
EARN A DIGITAL BADGE WHEN YOU COMPLETE THESE TRACKS
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.