Here are Our Latest Publications

a person pulling on gloves to clean

4 Considerations to Maintain Clean Data Across Multiple Systems

When developing a database for your organization, it's crucial to maintain clean data across multiple systems to ensure readability and understanding for everyone involved in the project. However, "clean data" can mean different things to different people. How can you ensure everyone is on the same ...

Read The Full Post

a computer covered in cobwebs

How Can Government Employees Obtain Clean & Aligned Data?

If you work for a small to mid-sized county government in social services, criminal justice, or any other role that uses data then you already know: getting reliable data is a huge challenge.

Read The Full Post

People in Line with Arms Around Each Other Looking Over a Cliff Edge

How Counties Can Un-Silo Their Data Management with Power BI

So, you work for a small to mid-sized county government and are having difficulty efficiently getting data out of the systems you use. You are not alone. County staff in many areas, including health and human services, law enforcement, and child welfare are limited in their productivity due to poor ...

Read The Full Post

illustration of people on a web conference

Need Fabric or BI Support? Join the Minnesota Fabric Group!

As avid users of both Fabric and Power BI, we love hearing from other Fabric and Power BI users. Each person has unique insights, cool tricks and tips and things to share.

Read The Full Post

Brain Larson, Superior Consulting Services

3 Big Reasons to Work with a Microsoft Fabric Consultant

Fabric is Microsoft’s most powerful data tool to date. But getting up to speed with Fabric can be a huge challenge. For organizations who are looking to implement Fabric in the future or who currently use Fabric, working with a Microsoft Fabric Consultant is the best way to get the most out of ...

Read The Full Post

an illustrated blue technology cloud

Finding a Data Home in the Cloud: Microsoft Fabric vs. Azure

Read The Full Post

illustration of a data warehouse connecting to files and a computer

Data Warehouse vs Data Lake vs Data Lakehouse

The following blog comes from Zach Corley, Data and Analytics Consultant at Superior Consulting Services.

Read The Full Post

cubes on a grid, connected by lines. a geometric representation of databases.

Benefits of Using Tabular Editor 2 for Working with Tabular Data Models

Here’s a “fun” exercise: ask any database developer how they like modeling in Visual Studio. To put it charitably, VS has a lot of limitations. There has to be a better way…and there is.

Read The Full Post

an IT director leaning against a wall while using a surface laptop

Should You Switch to Microsoft Fabric? A Guide for IT Directors

Microsoft Fabric is now live. With the launch of this latest data powerhouse tool many IT directors are asking themselves: does it make sense to stick with what we have, or to use Fabric instead?

Read The Full Post

bronze, silver, and gold medals on a pedestal

High-level Overview of Medallion Architecture

Keeping a high volume of data organized is one of the top priorities for a business analyst. You’ve likely heard of (or may already be using) Medallion architecture to achieve these goals. This structure is also considered best practice while designing and using Microsoft Fabric.

Read The Full Post

abstract depiction of data leaving a database

Using SSIS and PowerShell to Manage Power BI Workspaces

The following blog comes from Addison Sand, Data & Analytics Consultant at Superior Consulting Services.

Read The Full Post

Sticker Collage of Fabric Entities

Fabric Community Conference Recap

Brian Larson attended the Microsoft Fabric Community Conference in March 2024. Michael Bergstrom sat down with Brian to capture a quick recap of the experience.

Read The Full Post

an artistic rendering of an aqua wave

Will Microsoft Fabric Replace Synapse or Azure SQL?

If you saw the announcement for Fabric and are wondering what this means for the future of Synapse and Azure SQL, you’re not alone. With Microsoft’s introduction of Fabric, it’s difficult to know which current data solutions will remain relevant and which will be replaced by Fabric.

Read The Full Post

Modern abstract wavy swirl background with lines in gradient cool peacock blue tones

Is Microsoft Fabric Replacing Power BI?

Microsoft Fabric has launched, and with it comes a big question: Is Power BI going away?

Read The Full Post

abstract room with green and silver tiles

Why You Should Perform an SQL Server Health Check Monthly

Your database isn’t a static asset. As time goes by, more data is processed, database usage changes, and more users are added. This natural evolution can start to cause issues within your database if left unchecked.

Read The Full Post

Webinar: Microsoft Fabric - What, Why and How Much

We recently hosted a webinar all about the new features of Microsoft Fabric. An all-in-one data analytics solution with a myriad of features, Microsoft Fabric covers everything from data movement to data science and real-time analytics.

Read The Full Post

two employees pointing at a screen

Why Do You Need Microsoft Consulting Services?

No matter what tools you use, any business-level Microsoft software or application is a significant investment. And most businesses aren’t seeing a return on that investment.

Read The Full Post

Improve Your Performance and Profitability Today

SCS uses best-in-class tools to deliver database, reporting and data platform and analytics solutions. We partner with your team to develop custom solutions.