This course teaches how to use asserts in Python to validate data cleanliness. Learn to compare indexes, Series, and DataFrames, compose quantitative and logical tests, and apply them for data cleaning.

In this workshop you're analyzing and architecting solutions based on a series of sheets in a planning workbook. You're choosing the company to use, so we've given you detail based on industry standards.

Create complex Excel user interfaces with VBA. Learn form validation, complex controls usage, and secure email sending via VBA.

Leverage Excel's VBA tool for operations, macros, and debugging. Learn to format cells, manage sheets, and utilize FormatConditions object.

Master VBA in Excel for pivot tables, charts, and financial data. Learn to automate tasks in MS Access, run SQL queries, and set up event handlers.

Explore large language models (LLMs) and vector databases, including ANN search, similarity methods, and practical skills using BERT and ChromaDB embeddings.

Master integration, correlation identification, and anomaly detection for informed decision-making.

Learn how to create and customize pie charts, bar graphs, and other data visualizations with Microsoft Excel.

Learn to make effective data visualizations in Python with Matplotlib and Seaborn.

By combining the stream processing capabilities of Azure Stream Analytics and the data visualization capabilities of Microsoft Power BI, you can create real-time data dashboards.

Data visualization is an important step for professionals who want to make sense of data for machine learning purposes or even presenting meaningful data to an audience. In this course you will see how to do data visualization using AWS QuickSight.

Data is often available on web pages, requiring extra effort and caution to retrieve it. This course is about the Rcrawler package which is a web crawler and scraper that you can use in your R projects.