From Your Data Warehouse to Emails in a Neat Way

Hi everyone.
As data practitioners, we often need to deliver data to whoever needs it.
As time goes by, after hundreds of ad-hoc requests and SQL queries, you soon realize that many of these requests are similar, and can be automated.

At the same time, the traditional way of attaching your data as an excel file is way past us. It’s 2021, time to come up with innovative ways to display your data.

Have you ever wanted to extract some data from your Data Warehouse and send it through email, while having the whole process automated?

I’ve got just the…


Data Engineering is the new Data Science

All of us have heard about the title —
Data Scientist, the sexiest job of the 21st Century.
But is it really?

For many people who are new to the data industry, Data Science will be the first thing they hear about, and the title just sticks. Suddenly, everyone is either already a Data Scientist, or aspiring to be one.

However, that is not the only job title in the industry.


Plan Ahead for a Smooth Transition

If you’re reading this, there’s a chance that you may be leaving or planning to leave your current job. Well, we’ve all been there.

I often hear people complaining about their jobs —

  • How they aren’t getting paid enough
  • How their boss isn’t treating them well enough
  • How their growth in the company is hindered

Everyone has their reasons for a job switch. Whatever it is, there are some matters to be tendered carefully so that we do not ruin our potential opportunity costs in the future.

Remember, you leaving the company causes them trouble, at least for hiring a…


Solving the YouTube climb using Data Science

Greetings data practitioners,
Welcome back to your weekly read of solving real-world problems with data science. Right on queue, one of the highest priority first world problems that Millenials face nowadays is —

Not knowing how to blow up on Youtube.

No worries, data can solve everything,
and we are going to solve the YouTube Problem. Today.

Youtube

The world-famous video-sharing website. It is no secret that YouTubers make big bucks posting videos on YouTube. If you’re living under a rock, big YouTubers literally make millions per year, while only having to post 1 video every week.

This had further caused…


What you should be looking out for in 2021, as a Data Practitioner!

Greetings Data Practitioners,
Welcome to 2021, we made it.

Last year was a tough year, I think we can all agree to that.
However, among the hardship, be thankful that you are in a field that is still highly in demand despite the scary situation we are all in.

Data never sleeps, even if there is a pandemic going on.

Hence, it is extremely important that you are aware of the trends that are leading the direction of the data industry. Things like —

  • What went well last year?
  • What’s going on this year?

Throwback to 2020


Add Bootstrap to your Interactive Dashboards

Greetings data practitioners.

Welcome to 2021, where the new trend is all around Machine Learning.
Most employers, even data scientists themselves, are drowning in the thought of deploying that new Machine Learning model that predicts literally everything for them.

If you have ever been in the field, you would understand that most organizations nowadays don’t have the sufficient fundamentals to even venture into Machine Learning, but they still want to.

They have not even scratched —

  • Proper data warehousing practices
  • Full understanding of data owned
  • Utilization of cloud tools to perform Machine Learning

That being said, data…


Build your first real-time dashboard! No, really!

Greetings data practitioners,
I assume you are aware of the increase in demand for people who know how to communicate data. This is exactly why we should always seek to improve, learn more, and sharpen our skills in the data science industry.

Even with all the hype around Machine Learning, Data Visualizations do not lose their importance. Exploratory Data Analysis is often required before any Machine Learning is even planned out.

Large tech companies often need to communicate the data they own.
We are the ones that execute.

A very good example would be google and their known, google trends.


Build your first web app!

Greetings reader,
if you’re like me, you like data.
Data can tell a lot of stories when it’s properly presented.

We live in an era where people depend on data for business decisions, which is exactly why presenting data professionally will put you ahead of others.

Visualization gives you answers to questions you didn’t know you had.
— Ben Schneiderman

We can achieve this by using amazing visualizations. We’ve already talked about how you should take advantage of powerful libraries we currently have in Python.

In this write-up, we’re taking it to the next level. We’re going to talk about…


Here’s how I got my first ever promotion

Promotions are stressful.

It’s like flirting with a guy/girl, you have to be good at ‘the game’. You have to send out the correct signals, check all the right boxes, dress up perfectly, etc. All of the above applies, but to your boss.

Everyone wants a promotion, but not all of us get it. I would like to believe there is a formula on ‘How To 100% Secure A Promotion’, but unfortunately, there isn’t one. …


5 SQL tricks that will help you tremendously in your Data Science Career

Good Day Reader.

If you’re reading this you are probably a data practitioner, or aspiring to be one. Welcome to the world of data, get comfortable here, you are going to spend quite some time learning new things.

With the increase in job demand for the data science field, people are eager to pick up the skills needed for the profession. Python, Machine Learning, Data Visualization, the list goes on. However, the one skill that often gets ignored is …

SQL

SQL has been the go-to querying language for all databases, and it is not going anywhere soon. All data scientists…

Nicholas Leong

Data Scientist turned Engineer — Crunching data and writing about it so you don’t get headaches.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store