- You are here:
- Home »
- Author's Archive:
All posts by James
Why 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 readingUsing Statistics to Simulate Sales Data
Remember that statistics class that you thought was useless back in college? Bet you didn’t think you’d ever use it once you finished, right? You had to take it as part of the curriculum, but once it was done, you were done with statistics forever, right? It turns out, some of the techniques they taught […]
Continue readingHow to Import the Price of a Stock in Excel
I work with Microsoft Excel quite often as do many others. I use Excel to track my stock portfolios. Often, this entails getting prices for the stock online and updating Excel (manually). There is no function (that I am aware of) that does this natively in Excel. This article will describe how to import the […]
Continue readingHow to Get Started with Power BI
Power BI is an analysis tool created by Microsoft. It is part of a class of software tools known as self-service business intelligence tools, which means that it is supposed to be easier than most analytics-based tools. However, it still has a learning curve that users need to master. This tutorial will help you get […]
Continue readingHow to Generate Mock Sales Data
Search for mock data or mockup data, and you’ll have plenty of options for items like customers or regions. Mockaroo is one popular choice among many for generating such data and will generate up to 1000 records for free. When you try try to find sales data that is worth using, that is another story […]
Continue readingFind Your Use Cases
If I see another tutorial using the Iris dataset, I’m going to jump off a bridge. Not literally, of course. But I am not interested in learning about the properties of flowers. Some people are, and that’s great! Who knows? Maybe someday, I’ll be put in a situation where that I need to learn about […]
Continue readingLoading R Scripts Into Power BI
R is a popular language for data science, although recently Python is winning the language wars. Still, R has its proponents (yours truly) and will continue in its use throughout the data science community. Did you know that it can be used with Power BI, too? This quick tutorial gives instructions on loading R scripts […]
Continue reading