by Tim Enalls | Aug 25, 2020 | Python, SQL
In this article, we’re going to explore how to connect a dataset from a Python script to a SQL Server database. Then, I’ll explain how to export a dataset from Python to SQL Server. After that, I’ll explain how to use Python to query data from the newly created table...
by Tim Enalls | Aug 17, 2020 | Uncategorized
If you’re in a field related to analytics or data science, you’re always going to be in situations where you need to create new columns in your data so that you can have a greater understanding of it. And most likely, using a software like Excel is way too...
by Tim Enalls | Jul 27, 2020 | Certifications, Project Management
The Project Management Professional (PMP) certification is the most important industry-recognized certification for project managers. In this article, I’ll provide seven tips to pass the PMP exam. In 2017, I obtained “above target” scores in four out of the five...
by Tim Enalls | Jul 24, 2020 | Uncategorized
If you regularly use the Structured Query Language (SQL) to extract data from databases and produce reports, it is essential that you learn to use window functions. In this article, I’ll describe 15 types of window functions as clearly and understandably as possible....
by Tim Enalls | Jul 21, 2020 | Uncategorized
How would you like to validate your knowledge and skills and differentiate yourself in the job market? If you’re in the fields of analytics and data science, becoming a Certified Analytics Professional (CAP) might give you a competitive edge. In this article, I’ll...
