Data Analysis and Visualization with Microsoft Excel

In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

• Perform data analysis fundamentals.
• Visualize data with Excel.
• Analyze data with formulas and functions.
• Analyze data with PivotTables.
• Present visual insights with dashboards in Excel.
• Create geospatial visualization with Excel.
• Perform statistical analysis.
• Get and transform data.
• Model and analyze data with Power Pivot.
• Present insights with reports.

Click here for course dates

Programming and Data Wrangling with VBA and Excel®

In this course, you will develop and deploy VBA modules to solve business problems. You will:

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
• Write VBA code to create a custom worksheet function.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
• Control how and when macros run.
• Develop UserForm objects to create custom dialog boxes and windows.
• Use VBA to read and write data from local files and cloud services.
• Use VBA to clean and transform data.
• Run programs and commands outside of Excel and share VBA projects with other users

Excel – Automating Excel with Macros and Analysis Tools

This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data.

Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data.

Google Analytics – Foundation

Upon successful completion of this course, you will be able to implement Google Analytics and perform analysis using standard reports.

You will:

• Implement Google Analytics
• Configure Google Analytics
• Configure goals, funnels, and filters
• Configure monitoring and alerting
• Analyze website traffic
• Analyze behavior and conversion

DP-100 Designing and Implementing a Data Science Solution on Azure

Gain the necessary knowledge about how to use Azure services to develop, train, and deploy, machine learning solutions. The course starts with an overview of Azure services that support data science. From there, it focuses on using Azure’s premier data science service, Azure Machine Learning service, to automate the data science pipeline. This course is focused on Azure and does not teach the student how to do data science. It is assumed students already know that.

This role is responsible for solving the business problem that initiated the project. While the Data Engineer will prepare the data to be used for the models, the Data Scientist determines what data is needed for model training, creates model features from the data, determines what machine learning model to use, trains and evaluates the model, and often has involvement in model deployment. Often the data scientist needs to evaluate multiple models to determine which performs the best.

Using Data Science Tools in Python®

In this course, you will use various Python tools to load, analyze, manipulate, and visualize business data.

You will:

• Set up a Python data science environment.
• Manage and analyze data with NumPy arrays.
• Manipulate and modify data with NumPy arrays.
• Manage and analyze data with pandas DataFrames.
• Manipulate, modify, and visualize data with pandas DataFrames.
• Visualize data with Matplotlib and Seaborn