Programming | Interviewing | Office Hours

Update: Many of you contacted me asking for valuable resources to nail Python coding interviews. Below I share 4 courses/platforms that I strongly recommend to keep exercising after practicing the algorithms in this post:

• LeetCode In Python: 50 Algorithms Coding Interview Questions → Best For Coding Rounds Involving Algorithms!
• Python advanced Coding Problems (StrataScratch)→ Best platform I found to prepare Python & SQL coding interviews so far! Better and cheaper than LeetCode.
• Practicing Coding Interview Questions In Python (60+Problems) → Lists, arrays, sets, dicts, map(), filter(), reduce(), iterable objects → 33% DISCOUNT on annual subscriptions!
• Python Data Engineering Nanodegree→ High…

FORECASTING | PYTHON | OFFICE HOURS

Update: Many of you contacted me asking for valuable resources to learn more about time series forecasting with Python. Below I share 2 courses that I personally took and that would strongly recommend to expand your knowledge on the topic:

• Python For Time Series Analysis (using ARIMA, SARIMAX, VARMA, PROPHET) 15+ hours of content
• Predictive Analytics For Business (ETS, ARIMA) →Very high quality course!

Hope you’ll find them useful too! Now enjoy the article :D

Introduction

In the first part of this tutorial (Forecasting Business KPIs With Python Using Prophet-Part I), we built a simple predictive model using Facebook’s Prophet library…

Forecasting | Python | Office Hours

Update: Many of you contacted me asking for valuable resources to learn more about time series forecasting with Python. Below I share 2 courses that I personally took and that would strongly recommend to expand your knowledge on the topic:

• Python For Time Series Analysis (using ARIMA, SARIMAX, VARMA, PROPHET) 15+ hours of content
• Predictive Analytics For Business (ETS, ARIMA) →Very high quality course!

**USE CODE JULY75 FOR A 75% DISCOUNT ON UDACITY COURSES**

Hope you’ll find them useful too! Now enjoy the article :D

Introduction

Picture this: you are a data analyst or business intelligence analyst with experience building KPIs…

Do you wish to become a Data Engineer and advance your career in 2021? Have a look at Udacity’s on-demand Data Engineering Nanodegree and take advantage of the following special discount code for August 2021:

*USE CODE UPSKILL21 FOR A 50% DISCOUNT ON UDACITY COURSES**

Introduction

Python offers at least two straightforward ways to interact with a PostgreSQL database:

• creating a connection using pycopg2 package
• generating and engine through the sqlalchemy package.

As long as you have valid credentials, you can establish a connection with few lines of code. …

Introduction

Preparing for a professional certification can be stressful. Because of your full time job and your other commitments, you probably have little time left to focus and need to decide what’s the material that is worth studying.

The Databricks Associate Apache Spark Developer Certification is no exception, as if you are planning to seat the exam, you probably noticed that on their website Databricks:

• recommends at least 2 official books;
• offers a number of (expensive) on-demand remote or F2F courses;
• avoids to share mock MCQs test to assess the difficulty of the exam.

So you may be wondering:

“What should…

The Problem: Generating Streaming Datasets

If you are familiar with PySpark and with its Structured Streaming API you know how easy it is to express your streaming job as standard batch job, with the difference that a data stream can be treated as a table that is being continuously appended.

Despite writing a stream processing model in straightforward, finding streaming data sources, could be a challenging task, particularly while testing your application before deploying it or setting your very first streaming job while learning PySpark.

To make your life at work easier and your learning process quicker, in this tutorial I will show you how…

*USE CODE UPSKILL21 FOR A 50% DISCOUNT ON UDACITY COURSES**

A Modern Approach To Data Engineering

A stream of data can be defined as an uninterrupted flow of data generated by multiple type of sources. As modern companies increasingly rely on applications that produce and process data in real-time, data streaming is an increasingly in-demand skill for data engineers.

By using a stream processing framework ( like Kafka Streaming, Apache Streaming, Apache Faust, AWS Kinesis), stream of events can be processed, stored, and analyzed as they are generated in real-time.

A natural question that arises is:

“Have you and your Data Engineering team already shifted toward…

A note for my readers: This post includes affiliate links for which I may earn a small commission at no extra cost to you, should you make a purchase.

A Lack Of Resources To Practice?

If you are in the process of studying for the Databricks Associate Developer for Apache Spark 3.0 certification you are probably facing the same problem I faced a few weeks ago: a lack of mock tests to assess your readiness.

By now, you should know that the exam consists of 60 MCQs and that you will be given 120 mins to answer correctly to at least 42 of them (70%).

Another…