Articles filed in category 'Business Intelligence'

Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.

It’s when you’re working with lots of data that you start looking around for an easier way to keep track of it all. Machine learning and artificial intelligence seem like the obvious answers, and Sahil shows you why.

If you want to be a great SQL Server developer, you’ll want to pay attention to these 13 key points. Kevin Goff covers both best practices and common pitfalls of Business Intelligence.

Helen shows you the ins and outs of creating really useful charts and graphs with Tableau. You’ll never make a boring old pie chart again.

Brian shows you that Power BI Embedded makes it possible to have great visuals as part of your app. He also helps you figure out which of the many flavors is the right one for you.

Got a sinking feeling that you’re missing something in Artificial Intelligence? This article is only the tip of the iceberg, but Wei-Meng offers you a helping hand into the lifeboat called Microsoft Azure Machine Learning Studio.

Instead of implementing machine learning algorithms manually, Wei-Meng found that someone else had already done the hard part. Come along as he explores a Python tool, called Scikit-learn, and builds a couple of models.

Using Firebase Cloud Messaging, Wei-Meng shows you how to enable PWA push notifications as if they were native code, and how to host your REST API as a serverless app.

If you’re curious about Data Science or Python—and if you’re interested in the Internet of Things, you should be—you’ll find this introduction both important and exciting. Wei-Meng makes it all clear for us by explaining the basics.

Learning R sets you up for creating machine learning projects. Wei-Meng takes a close look at the language, which can implement a wide variety of statistical techniques, tests, analysis, classification, clustering, and can help you produce publication-quality graphs.

In this next installment of his exploration into artificial intelligence, Sahil show you how to get LUIS to understand even if you misspell or mispronounce something.

The point of showing data in graphical form is to make things clear, right? Keven shows you how the best of intentions can go wrong and how to repair the damage.

Kevin looks at his favorite reporting tool (SSRS) and shows you how to maximize your users’ experience.

You already know that SQL Server’s Reporting Services tools are useful. Kevin shows you some nifty work-arounds and extra-credit tricks that will make your reports sing.

Kevin leaves his SQL Server-focused Baker’s Dozen behind and launches into a new series looking at the various stages of data warehousing. His first installment includes a look at reporting and storage layers, handy tips, and dealing with the business side of development.

The new release of SQL Server's Integration Services has many exciting new features

Kevin takes a look at SQL Server “then and now,” and shows us just how important it is to understand the various tools involved in BI.

All eyes were on Microsoft when the latest version of SQL Server came out a couple of months ago. If you want to know what’s so great about it, you need to read Kevin’s handy summary.

Imagine you’re working for a company that has accumulated a tremendous amount of transaction data. The business users want to perform all sorts of analysis, monitoring and analytics on the data. Some OLTP developers might reply with, “Just create views or stored procedures to query all the data the way the users want.” Many companies initially take that approach - however, just like certain technologies and system hardware configurations don’t scale well, certain methodo...logies don’t scale well either. Fortunately, this is where data warehousing and dimensional modeling can help. In this article, I’ll provide some basic information for developers on the basics of data warehousing and dimensional modeling - information that might help you if you want to provide even more value for your company.See More

In this first installment of his ETL articles, Kevin shows you what to do—and even what not to do—when designing your Data Warehouse.

Dino explains the business layer so that even a seven-year-old can understand.

If you’ve ever wondered what the difference is between MapReduce and Hadoop, Gary will tell you, putting it all in context of Hadoop and .NET.

You know that F# is the Next Big Thing, but did you know that it uses type providers? Rachel shows you how to use them to access data in no time.