Data Analytics and Business Intelligence Training

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.

Power BI: Dashboard in a Day

A one-day, hands-on workshop for business analysts that covers the full capabilities of Power BI

At the end of the day, attendees will better understand how to:

• Connect to, import, and transform data from a variety of sources.
• Define business rules and KPIs.
• Explore data with powerful visualization tools.
• Build stunning reports.
• Share dashboards with their team and business partners, and publish them to the web.

Microsoft Power BI: Data Analysis Practitioner

In this course, you will analyze data with Microsoft Power BI. You will:

• Analyze data with self-service BI.
• Connect to data sources.
• Perform data cleaning, profiling, and shaping.
• Visualize data with Power BI.
• Enhance data analysis by adding and customizing visual elements.
• Model data with calculations.
• Create interactive visualizations.

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

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