All my content organized by topic…

My Dog Rigby

Introduction

Hi, I’m Eric! I love creating coding tutorials, blogging about professional development, and inspiring others to check out data science. I typically write four articles a month, so follow me to stay up to date with my content! Below are all my articles categorized by Primary Topic.

LinkedIn Twitter Instagram erickleppen.com

Topics

Plotly & Dash
SQL & Databases
Natural Language Processing
Finance & Trading
Professional Development
Data Science & Programming
Personal Essays

Plotly Dash (Dashboards) (Programming) (Business Intelligence) (Web Development)

I am a huge Dash advocate and run pythondashboards.com. If you’re New to the Dash framework by Plotly, start here! My latest Dash project is commanderdeals.com. …


An Introduction to using and applying OPENJSON in SQL

Photo by Christina @ wocintechchat.com on Unsplash

JSON is Everywhere!

Understanding how to work with JSON is an important skill to have. JSON, short for JavaScript Object Notation, is one of the most popular data interchange formats. Because of JavaScript’s dominance as today’s most widely used language, questions relating to JSON have overtaken XML, and other popular formats, on Stack Overflow. As long as JavaScript continues to be widely used, this trend will likely continue.


How to use Python and Ally API to Trade Stocks

Photo by Windows on Unsplash

Is It Time to Automate?

The stock market is still hot, even after the slight correction in March. According to research done by SentimenTrader.com, retail trader activity has slowed from the peak in January. However, small trader (trades for 10 contracts or fewer) behavior is still more aggressive than it has been in the past 20 years.


How the Internet is Fighting with Wall Street

Photo by Clay Banks on Unsplash

2021 Is Getting Wild

The financial soap opera that revolves around GameStop stock has taken the world by storm, even causing some agreement amongst political foes like Donald Trump Jr., Alexandria Ocasio-Cortez, and Ted Cruz.


An Introduction to Options and 3 ways to Profit using Them

Photo by Thought Catalog on Unsplash

Build Your Wealth

Building wealth takes consistency. Sure, you can fast-track your way to riches with some luck, skills, and/or knowledge, but for a lot of us it takes patience, discipline and time. It is often a marathon that takes years to decades to accomplish. In a previous article I share how I began to find consistency trading stocks and options. Although I am certainly not the most brilliant trader, I’ve been chugging along for years, absorbing as much as I can from people and applying the strategies that work for my risk tolerance. …


A step by step guide to enhancing your online business website

Photo by Joshua Rawson-Harris on Unsplash

Building Your Online Empire

The road to riches is paved with multiple income streams, and these days it has never been simpler to start an online business with little to no start-up capital. In my previous guide, How to Start a Business in an Afternoon using Python and Dash, I explain how to sign up for an Amazon Affiliate account and create a home page for an affiliate website from scratch using Python and the Dash framework. If you have not read the previous guide, do not worry! This article contains the complete advanced template code for the website and these new features!

If…


My 10 Favorite Activities I use to Improve My Mental Health

Photo by Anthony Tran on Unsplash

Life is not Always Easy

Like many others, at some point in my life I’ve struggled with serious depression and social anxiety. As a teenager I talked to a therapist about my life issues, and in college I tried medication(Paxil) to help overcome my inability to participate in classroom discussions. Mental health issues, combined with an apathetic attitude, left me feeling like I was left out and never good enough most of my young life.

Instead of giving up or becoming negative and hating the world, I studied self-help and how to change. I spent most of my late teens and early 20’s learning how…


Create User Accounts and Protect Access to Dashboards

Photo by Lukas Blazek on Unsplash

Secure Your Data

Not long ago, it was declared that Data is the new oil in the digital economy[1]. Since that declaration, understanding cyber security and how to protect data has become of utmost importance for businesses around the globe. As someone who works with sensitive education data every day, I understand first hand the seriousness of keeping records protected.

Working in analytics, one of my go-to dashboard tools is Dash by Plotly. Dash is a framework for Python written on top of Flask, Plotly.js, and React.js. It abstracts away the complexities of each of those technologies into easy to apply components. …


Get that Corner Office with a View Using These 7 Tips

Photo: Anya Osintsova/Unsplash

Why so much hate for the 9–5?

Honestly, I love my job. Not every day, and not all the time, but being able to work at the forefront of transforming K-12 education in the U.S. feels incredibly rewarding. I understand not everyone has a rewarding job, and not everyone wants to grind for the corner office, but there are a lot of really good opportunities out there in “9–5 land” for people willing to learn skills and put in some effort.

Instead of telling you how to quit, I am telling you how to get ahead.

On Hustling & Side-gigs

Before getting into the…

Software Product Analyst in Data Science. pythondashboards.com Top writer in Business www.linkedin.com/in/erickleppen01/

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