CODE Magazine / Articles
Business Intelligence
Articles filed under Business Intelligence
Articles
Showing 1–27 of 27
-
Power BI and R: A Visual Power Punch
Updated
Data Visualization can be the best way to get your message across. Helen shows you how, using Power BI and R.
-
Stages of Data: A Playbook for Analytic Reporting Using COVID-19 Data, Part 2
Developers should know their data before they spend a lot of effort analyzing it. For example, at face value, you should know if your data is in the millions or billions, and know "that's what the data said" is not the right answer if the data is bizarre. This article in Kevin Goff's Stages of Data series using PowerBI introduces a new state profile page with ranking formulas, new trend-based measures, defining custom filter groups, and more.
-
Power Query: Excel’s Hidden Weapon
Updated
Helen talks about how to use Power Query, a tool that's part of Excel and Power BI that enables you to automate the ETL process of bringing data into Excel. Learn to create an elegant ETL process in Power Query to first bring in the data, then later refresh it with a single button
-
Best Practices for Data Visualizations: A Recipe for Success
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.
-
Azure Machine Learning Workspace and MLOps
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.
-
Creating Embedded Reports in Your Web Apps with Power BI Embedded
Updated
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.
-
Implementing Push Notifications in Progressive Web Apps (PWAs) Using Firebase
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.
-
Stages of Data #1: A New Beginning
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.
-
Natural Language Understanding with LUIS
Sahil Malik’s article explains how Natural Language Understanding with Microsoft LUIS lets developers convert free-form user input into actionable intents and entities, using domain-focused models that can be trained, tested, and refined through iterative utterances and patterns. He illustrates both browser-based and programmatic workflows—creating, training, and publishing LUIS apps via REST APIs, integrating with applications, and securing calls. Through step-by-step examples (creating apps, adding intents/entities, supplying utterances, and consuming results), Malik demonstrates how to automate and scale natural-language capabilities in software, highlighting cognitive services’ power and practical integration considerations.
-
Refactoring a Reporting Services Report with Some SQL Magic
Updated
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.
-
Introduction to the R Programming Language
Updated
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.
-
A SQL Programming Puzzle: You Never Stop Learning
Kevin learns the hard way how to estimate a process’ duration and he uses a clever bit of code to figure it out.
-
Implementing Machine Learning Using Python and Scikit-learn
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.
-
Getting Started with Machine Learning Using Microsoft Azure ML Studio
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.
-
The Baker’s Dozen: 13 Tips for Better Extract/Transform/Load (ETL) Practices in Data Warehousing (Part 1 of 2)
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.
-
SQL Server Reporting Services: Seven Power Tips
Updated
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.
-
Using F# Type Providers for Data Science
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.
-
Introduction to Data Science using Python
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.
-
The Baker’s Dozen: 13 Great Things to Know About SQL Server 2016
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.
-
SQL Server Reporting Services: Eight Power Tips
Updated
SQL Server’s Reporting Services is still the best workhorse for getting data to your users. Kevin tells you how to take advantage of some of its more subtle points.
-
Using Apache Hadoop on the Windows Platform
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.
-
The Baker’s Dozen State of the Union: 13 Points on SQL Server Data Warehousing and Business Intelligence
Updated
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.
-
The Mythical Business Layer
Dino explains the business layer so that even a seven-year-old can understand.
-
Baker's Dozen--Business Intelligence Developers
Updated
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.
-
The Baker’s Dozen: 13 Tips for Basics of Data Warehousing and Dimensional Modeling
Updated
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 methodologies 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.
-
The Baker’s Dozen Doubleheader: 26 new Features in SQL Server Integration Services 2012 (Part 2 of 2)
Updated
The new release of SQL Server's Integration Services has many exciting new features
-
Adaptive Leadership Chapter 3: Deliver a Continuous Flow of Value
The agile software movement has now been around for a full decade. As coauthor of the original Agile Manifesto, Jim Highsmith has been at its heart since the beginning. He's spent the past decade helping hundreds of organizations transition to agile/lean. When it comes to agile, he's seen it all–in a variety of industries, worldwide. Now, in Adaptive Leadership, he has compiled, updated, and extended his best writings about agile and lean methods for a management audience. Highsmith doesn't just reveal what’s working and what isn't; he offers a powerful new vision for extending agility across the enterprise. Drawing on what's been learned in application development, this guide shows how to use adaptive leadership techniques to transform the way you deliver complete solutions, whatever form they take. You'll learn how enterprise agility can enable the ambitious organizational missions that matter most; how leaders can deliver a continuous stream of value; how to think disruptively about opportunities, and how to respond quickly by creating more adaptive, innovative organizations.