Goldilocks and the Three SQL Concepts – Window Functions, Case Statements, and CTEs
The Goldilocks Seasonal Soup (GSS) Company is a food truck that serves soups during lunch and dinner. They try to make their soups at just the right temperature, hence the truck’s name. They also try to accommodate the right soups for the right seasons.GSS is a fictitious company. However, the research about the temperature of […]
Continue readingShould You Learn SQL?
Most people think that SQL is an arcane language. If you’re not familiar with SQL, it stands for Structured Query Language. It is the language of databases. Many companies have years of records stored on databases. But with popular languages such as R and Python, it’s easy to believe that SQL is on its way out. […]
Continue readingHow to Bucket Data in SQL
Are your employees wondering if they are being paid fairly in your organization? Suppose your HR department wants you to create a tool that will help employees determine how their salaries measure compared to other employees. This tutorial shows one method to help accomplish this task.Purchases made from the links in this article may result […]
Continue readingResources to Become a Data Scientist
Are you considering a career in data science? It is one of the hottest fields and growing. Even if you aren’t looking for a full-time career in the area, you may find it helps you with gleaning insight from your data and systems. Whatever the reason, finding the right resources is essential. This article will […]
Continue readingIt’s Time for Data Scientists to Get Their Heads INTO the Cloud
Data science is an exciting field but has its share of challenges. One of those challenges is the demand for computing power continues to grow. Data science practitioners and enthusiasts are concerned they will be “powered out” of the field. Are machine learning algorithms and artificial intelligence now only useful to big corporations? There is […]
Continue readingCreate Lookup Tables from Fact Tables in Power BI
At some point, you’ll need to create lookup tables from data sources. Excel users often clump all entities together in each row. This is a natural way for them to view the data and it’s the easiest for them to enter it this way. You’ll likely find customer names and addresses, product names, prices and […]
Continue readingWhy Data Scientists Need to Learn SQL Programming
SQL is short for Structured Query Language. It was developed in the 1980s to help database programmers work with database content. While databases existed before SQL, working with them required database programmers to use disparate, and often proprietary methods. Most data scientists focus on learning Python or R, as these are the two dominant languages in […]
Continue readingCloud Computing and Data Science: A Great Match?
Your boss calls you into her office and describes a business problem for you to solve. After analyzing the problem, you decide that a deep learning algorithm will be the best solution to the problem. Your boss gets excited and tells you to implement that deep learning solution. There’s only one problem: you don’t have […]
Continue readingReview: Power BI – Up & Running with Power BI Desktop
Course: Power BI – Up & Running with Power BI DesktopInstructor: Chris DuttonPlatform: Udemy.comPrice: VariesRating: 5 Stars (out of 5)SummaryIf you are struggling to learn the intricacies of the Microsoft product, Power BI, then you owe it to yourself to take this course on the topic. Chris Dutton does such an amazing job teaching it. […]
Continue readingIntroduction to Power BI – Training that Helps You Learn Quickly
Power BI is an analytics program that helps people gain insights into data. It’s not overly difficult to learn, but it has several powerful features that can make it overwhelming for newcomers. There is great training online for the software, but I happen to find one called Introduction to Power BI. It is training that […]
Continue reading