-
Power BI and R: A Visual Power Punch
By:
Helen Wall
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2021 - July/August
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
By:
Kevin Goff
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - September/October
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2020 - July/August
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2019 - November/December
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
By:
Sahil Malik
Last updated: Wednesday, March 17, 2021
Published in: CODE Magazine: 2019 - September/October
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
By:
Brian Noyes
Last updated: Thursday, April 1, 2021
Published in: CODE Magazine: 2019 - May/June
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
By:
Wei-Meng Lee
Last updated: Wednesday, April 7, 2021
Published in: CODE Magazine: 2019 - January/February
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
By:
Last updated: Tuesday, April 13, 2021
Published in: CODE Magazine: 2018 - November/December
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
By:
Last updated: Friday, April 16, 2021
Published in: CODE Magazine: 2018 - September/October
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.
-
Refactoring a Reporting Services Report with Some SQL Magic
By:
Last updated: Monday, April 26, 2021
Published in: CODE Magazine: 2018 - May/June
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
By:
Last updated: Friday, April 30, 2021
Published in: CODE Magazine: 2018 - March/April
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
By:
Last updated: Thursday, May 6, 2021
Published in: CODE Magazine: 2018 - January/February
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
By:
Last updated: Tuesday, May 11, 2021
Published in: CODE Magazine: 2017 - November/December
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
By:
Last updated: Thursday, May 13, 2021
Published in: CODE Magazine: 2017 - September/October
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)
By:
Last updated: Wednesday, May 12, 2021
Published in: CODE Magazine: 2017 - September/October
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
By:
Last updated: Wednesday, May 19, 2021
Published in: CODE Magazine: 2017 - May/June
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
By:
Rachel Reese
Last updated: Thursday, May 27, 2021
Published in: CODE Magazine: 2017 - January/February
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
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2016 - November/December
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
By:
Last updated: Monday, June 7, 2021
Published in: CODE Magazine: 2016 - September/October
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
By:
Last updated: Wednesday, June 23, 2021
Published in: CODE Magazine: 2016 - May/June
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
By:
Gary Short
Last updated: Wednesday, July 7, 2021
Published in: CODE Magazine: 2015 - September/October
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
By:
Last updated: Thursday, July 15, 2021
Published in: CODE Magazine: 2015 - May/June
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
Last updated: Wednesday, September 1, 2021
Published in: CODE Magazine: 2014 - November/December
Dino explains the business layer so that even a seven-year-old can understand.
-
Baker's Dozen--Business Intelligence Developers
By:
Last updated: Monday, December 27, 2021
Published in: CODE Magazine: 2014 - March/April
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
By:
Last updated: Wednesday, June 8, 2022
Published in: CODE Magazine: 2013 - March/April
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)
By:
Last updated: Wednesday, August 31, 2022
Published in: CODE Magazine: 2012 - May/June
The new release of SQL Server's Integration Services has many exciting new features
-
Adaptive Leadership Chapter 3: Deliver a Continuous Flow of Value
Last updated: Tuesday, February 19, 2019
Published in: Book Excerpts, Newsletters
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.
- Home
Articles filed in category 'Business Intelligence'