--- title: Superior Spotlight Blogs (5) description: Superior Consulting Services offers valuable insights in our blog series. Here are our latest publications. Read more. (5) --- [Skip to main content](https://www.teamscs.com/superior-spotlight-blogs/page/5#main-content) - [Power BI Consulting](https://www.teamscs.com/power-bi-enterprise) - [Request a Quote](https://www.teamscs.com/discovery) [![Superior Consulting Services logo](https://www.teamscs.com/hubfs/SCS_2015_LOGO.svg) ![Superior Consulting Services logo](https://www.teamscs.com/hubfs/SCS_2015_LOGO.svg)](https://www.teamscs.com/old-homepage) - Show submenu for Data Services Data Services - [Data Unification](https://www.teamscs.com/data-unification) - [Data Modeling](https://www.teamscs.com/data-modeling) - [Data Visualization](https://www.teamscs.com/reporting-and-analytics) - [Spatial Analytics](https://www.teamscs.com/gis-spatial-analytics) - [Business Automation](https://www.teamscs.com/business-automation) - [AI & Machine Learning](https://www.teamscs.com/ai-machine-learning) - Show submenu for Technologies Technologies - [Power BI & Analytics](https://www.teamscs.com/power-bi-enterprise) - [Microsoft Fabric](https://www.teamscs.com/microsoft-fabric-consulting) - [Microsoft Azure](https://www.teamscs.com/azure-services) - [Power Apps & Power Automate](https://www.teamscs.com/power-apps-power-automate) - Show submenu for Industries Served Industries Served - [Community Corrections](https://www.teamscs.com/community-corrections) - [Financial Institutions](https://www.teamscs.com/financial-institutions) - [Government Contracting](https://www.teamscs.com/government-contracting) - [HHS Departments](https://www.teamscs.com/county-hss-departments) - [Insurance Companies](https://www.teamscs.com/insurance-industry) - [Manufacturing](https://www.teamscs.com/manufacturing) - [Nonprofits](https://www.teamscs.com/nonprofits) - [SaaS Companies](https://www.teamscs.com/software-as-a-service) - [Service Providers](https://www.teamscs.com/service-providers) - Show submenu for About Us About Us - [Meet the Team](https://www.teamscs.com/about) - [The Superior Way](https://www.teamscs.com/superior-way) - [Case Studies](https://www.teamscs.com/superior-spotlight-blogs/tag/case-studies) - [Testimonials](https://www.teamscs.com/insights/testimonials) - Show submenu for Training Training - [Power BI & Fabric Training](https://www.teamscs.com/custom-training) - [Online Courses](https://www.teamscs.com/learn-power-bi) - [User Groups and Events](https://www.teamscs.com/user-groups-and-events) - Show submenu for Resources Resources - [Superior Blog](https://www.teamscs.com/superior-spotlight-blogs) - [Published Books](https://www.teamscs.com/insights/resources) - [Contact](https://www.teamscs.com/contact) Open main navigation Close main navigation - Show submenu for Data Services Data Services - Data Services - [Data Unification](https://www.teamscs.com/data-unification) - [Data Modeling](https://www.teamscs.com/data-modeling) - [Data Visualization](https://www.teamscs.com/reporting-and-analytics) - [Spatial Analytics](https://www.teamscs.com/gis-spatial-analytics) - [Business Automation](https://www.teamscs.com/business-automation) - [AI & Machine Learning](https://www.teamscs.com/ai-machine-learning) - Show submenu for Technologies Technologies - Technologies - [Power BI & Analytics](https://www.teamscs.com/power-bi-enterprise) - [Microsoft Fabric](https://www.teamscs.com/microsoft-fabric-consulting) - [Microsoft Azure](https://www.teamscs.com/azure-services) - [Power Apps & Power Automate](https://www.teamscs.com/power-apps-power-automate) - Show submenu for Industries Served Industries Served - Industries Served - [Community Corrections](https://www.teamscs.com/community-corrections) - [Financial Institutions](https://www.teamscs.com/financial-institutions) - [Government Contracting](https://www.teamscs.com/government-contracting) - [HHS Departments](https://www.teamscs.com/county-hss-departments) - [Insurance Companies](https://www.teamscs.com/insurance-industry) - [Manufacturing](https://www.teamscs.com/manufacturing) - [Nonprofits](https://www.teamscs.com/nonprofits) - [SaaS Companies](https://www.teamscs.com/software-as-a-service) - [Service Providers](https://www.teamscs.com/service-providers) - Show submenu for About Us About Us - About Us - [Meet the Team](https://www.teamscs.com/about) - [The Superior Way](https://www.teamscs.com/superior-way) - [Case Studies](https://www.teamscs.com/superior-spotlight-blogs/tag/case-studies) - [Testimonials](https://www.teamscs.com/insights/testimonials) - Show submenu for Training Training - Training - [Power BI & Fabric Training](https://www.teamscs.com/custom-training) - [Online Courses](https://www.teamscs.com/learn-power-bi) - [User Groups and Events](https://www.teamscs.com/user-groups-and-events) - Show submenu for Resources Resources - Resources - [Superior Blog](https://www.teamscs.com/superior-spotlight-blogs) - [Published Books](https://www.teamscs.com/insights/resources) - [Contact](https://www.teamscs.com/contact) - [Power BI Consulting](https://www.teamscs.com/power-bi-enterprise) - [Request a Quote](https://www.teamscs.com/discovery) Categories - [Data](https://www.teamscs.com/superior-spotlight-blogs/tag/data) - [Case Studies](https://www.teamscs.com/superior-spotlight-blogs/tag/case-studies) - [Data Management](https://www.teamscs.com/superior-spotlight-blogs/tag/data-management) - [Data Accessibility](https://www.teamscs.com/superior-spotlight-blogs/tag/data-accessibility) - [Data Analysis](https://www.teamscs.com/superior-spotlight-blogs/tag/data-analysis) - [Data Analytics](https://www.teamscs.com/superior-spotlight-blogs/tag/data-analytics) - [Fabric](https://www.teamscs.com/superior-spotlight-blogs/tag/fabric) - [Microsoft Fabric](https://www.teamscs.com/superior-spotlight-blogs/tag/microsoft-fabric) - [Microsoft Solutions](https://www.teamscs.com/superior-spotlight-blogs/tag/microsoft-solutions) - [Data integration](https://www.teamscs.com/superior-spotlight-blogs/tag/data-integration) - [Business Intelligence & Reporting](https://www.teamscs.com/superior-spotlight-blogs/tag/business-intelligence-reporting) - [About SCS](https://www.teamscs.com/superior-spotlight-blogs/tag/about-scs) - [BI](https://www.teamscs.com/superior-spotlight-blogs/tag/bi) - [Custom Business and IT Services](https://www.teamscs.com/superior-spotlight-blogs/tag/custom-business-and-it-services) - [Data Visualization](https://www.teamscs.com/superior-spotlight-blogs/tag/data-visualization) - [Data and Analytics](https://www.teamscs.com/superior-spotlight-blogs/tag/data-and-analytics) - [Analysis](https://www.teamscs.com/superior-spotlight-blogs/tag/analysis) - [Data Model](https://www.teamscs.com/superior-spotlight-blogs/tag/data-model) - [Data Storage Solutions](https://www.teamscs.com/superior-spotlight-blogs/tag/data-storage-solutions) - [GIS](https://www.teamscs.com/superior-spotlight-blogs/tag/gis) - [Power BI](https://www.teamscs.com/superior-spotlight-blogs/tag/power-bi) - [Application Development](https://www.teamscs.com/superior-spotlight-blogs/tag/application-development) - [Business Analyst](https://www.teamscs.com/superior-spotlight-blogs/tag/business-analyst) - [IT Leaders](https://www.teamscs.com/superior-spotlight-blogs/tag/it-leaders) - [Infrastructure](https://www.teamscs.com/superior-spotlight-blogs/tag/infrastructure) - [Insurance Companies](https://www.teamscs.com/superior-spotlight-blogs/tag/insurance-companies) - [Manufacturing](https://www.teamscs.com/superior-spotlight-blogs/tag/manufacturing) - [Backups](https://www.teamscs.com/superior-spotlight-blogs/tag/backups) - [Cloud](https://www.teamscs.com/superior-spotlight-blogs/tag/cloud) - [Cloud Storage](https://www.teamscs.com/superior-spotlight-blogs/tag/cloud-storage) - [Data Manipulation](https://www.teamscs.com/superior-spotlight-blogs/tag/data-manipulation) - [Data Protection](https://www.teamscs.com/superior-spotlight-blogs/tag/data-protection) - [Data Security](https://www.teamscs.com/superior-spotlight-blogs/tag/data-security) - [IT Challenges](https://www.teamscs.com/superior-spotlight-blogs/tag/it-challenges) - [IT Leader](https://www.teamscs.com/superior-spotlight-blogs/tag/it-leader) - [ASP.net](https://www.teamscs.com/superior-spotlight-blogs/tag/asp-net) - [Analytics](https://www.teamscs.com/superior-spotlight-blogs/tag/analytics) - [Artificial Intelligence](https://www.teamscs.com/superior-spotlight-blogs/tag/artificial-intelligence) - [Associate Consultant Program](https://www.teamscs.com/superior-spotlight-blogs/tag/associate-consultant-program) - [Big Data](https://www.teamscs.com/superior-spotlight-blogs/tag/big-data) - [Business Processes](https://www.teamscs.com/superior-spotlight-blogs/tag/business-processes) - [CSRF](https://www.teamscs.com/superior-spotlight-blogs/tag/csrf) - [Coding](https://www.teamscs.com/superior-spotlight-blogs/tag/coding) - [DBA](https://www.teamscs.com/superior-spotlight-blogs/tag/dba) - [Data Loss Prevention](https://www.teamscs.com/superior-spotlight-blogs/tag/data-loss-prevention) - [Data Warehouse](https://www.teamscs.com/superior-spotlight-blogs/tag/data-warehouse) - [Denormalization](https://www.teamscs.com/superior-spotlight-blogs/tag/denormalization) - [Differential](https://www.teamscs.com/superior-spotlight-blogs/tag/differential) - [External HDD](https://www.teamscs.com/superior-spotlight-blogs/tag/external-hdd) - [Forgery](https://www.teamscs.com/superior-spotlight-blogs/tag/forgery) - [Full](https://www.teamscs.com/superior-spotlight-blogs/tag/full) - [Government](https://www.teamscs.com/superior-spotlight-blogs/tag/government) - [IT Management](https://www.teamscs.com/superior-spotlight-blogs/tag/it-management) - [Incremental](https://www.teamscs.com/superior-spotlight-blogs/tag/incremental) - [Installation](https://www.teamscs.com/superior-spotlight-blogs/tag/installation) - [Internship](https://www.teamscs.com/superior-spotlight-blogs/tag/internship) - [Nonprofits](https://www.teamscs.com/superior-spotlight-blogs/tag/nonprofits) - [PowerShell](https://www.teamscs.com/superior-spotlight-blogs/tag/powershell) - [SSIS](https://www.teamscs.com/superior-spotlight-blogs/tag/ssis) - [SaaS Companies](https://www.teamscs.com/superior-spotlight-blogs/tag/saas-companies) - [c#](https://www.teamscs.com/superior-spotlight-blogs/tag/c) - [data consulting mn](https://www.teamscs.com/superior-spotlight-blogs/tag/data-consulting-mn) # Here are Our Latest Publications [![literal images of clouds ](https://www.teamscs.com/hubfs/Imported_Blog_Media/311652017-1024x683-1.jpeg)](https://www.teamscs.com/superior-spotlight-blogs/2017/11/move-on-premise-servers-to-the-cloud) ##### [Move On Premise Servers to the Cloud](https://www.teamscs.com/superior-spotlight-blogs/2017/11/move-on-premise-servers-to-the-cloud) Moving on premise servers to the cloud can save you time, money and effort if done correctly. There are many approaches for moving on premise servers and workloads to the cloud, but here we will be focusing on lift and shift today. [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2017/11/move-on-premise-servers-to-the-cloud) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/blog-img-generic-03-4.jpg)](https://www.teamscs.com/superior-spotlight-blogs/2017/05/power-bi-query-editor-value-and-table-columns-or-data-denormalization-made-easy) ##### [Data Denormalization Made Easy](https://www.teamscs.com/superior-spotlight-blogs/2017/05/power-bi-query-editor-value-and-table-columns-or-data-denormalization-made-easy) Power BI Query Editor Value and Table Columns Data stored as part of a transactional data processing system, for example a database to information on package deliveries, is often difficult to work with when it comes time to explore that data or create reports. This is because of a process called ... [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2017/05/power-bi-query-editor-value-and-table-columns-or-data-denormalization-made-easy) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/blog-img-generic-05-Jul-07-2023-03-44-42-6524-PM.jpg)](https://www.teamscs.com/superior-spotlight-blogs/2017/03/power-bi-fit-data-journey) ##### [Where Does Power BI Fit in Our Data Journey?](https://www.teamscs.com/superior-spotlight-blogs/2017/03/power-bi-fit-data-journey) Power BI is the newest business intelligence offering from Microsoft. It’s a product that a lot of people have been talking and thinking about for the past year or two, and it is gaining more and more traction every day. I like to refer to it as “The best tool that people don’t realize they should ... [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2017/03/power-bi-fit-data-journey) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/blog-img-generic-06-4.jpg)](https://www.teamscs.com/superior-spotlight-blogs/2016/08/power-bi-connection-types) ##### [Power BI Connection Types](https://www.teamscs.com/superior-spotlight-blogs/2016/08/power-bi-connection-types) The most common way to use Power BI is to import the data into Power BI and define the structure of the data model there. In many situations, this is the best way to use Power BI. However, it is not the only way to use Power BI. [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2016/08/power-bi-connection-types) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/blog-img-generic-02-3.jpg)](https://www.teamscs.com/superior-spotlight-blogs/2014/03/technology-best-practices-critical) ##### [Why Technology Best Practices are Critical](https://www.teamscs.com/superior-spotlight-blogs/2014/03/technology-best-practices-critical) As with many things in life, technology sometimes allows you to take the “easy way out.” For example, you have been working hard on implementing the new Exchange server and you hit a road block. The install won’t complete. You do some digging and find out what the issue is, then you come to a ... [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2014/03/technology-best-practices-critical) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/LockedLaptop.jpg)](https://www.teamscs.com/superior-spotlight-blogs/2014/02/preventing-cross-site-request-forgery) ##### [Preventing Cross Site Request Forgery](https://www.teamscs.com/superior-spotlight-blogs/2014/02/preventing-cross-site-request-forgery) Cross Site Request Forgery (CSRF) is an attack against web applications that forces users to execute unwanted actions within the web applications that they are currently authenticated. By sending a malicious link via email, social network post or chat, an attacker may trick users of web ... [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2014/02/preventing-cross-site-request-forgery) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/Backup_-Restore_-Repeat_-Your-System-Backup-Survival-Guide1-1.png)](https://www.teamscs.com/superior-spotlight-blogs/2013/08/backup-restore-repeat-system-backup-survival-guide) ##### [Backup. Restore. Repeat. Your System Backup Survival Guide.](https://www.teamscs.com/superior-spotlight-blogs/2013/08/backup-restore-repeat-system-backup-survival-guide) By Tim LaPean, SCS Infrastructure Consultant [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2013/08/backup-restore-repeat-system-backup-survival-guide) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/blog-img-generic-03-4.jpg)](https://www.teamscs.com/superior-spotlight-blogs/2012/07/dynamic-sql-search-performance) ##### [Dynamic SQL Search Performance](https://www.teamscs.com/superior-spotlight-blogs/2012/07/dynamic-sql-search-performance) Recently SCS was approached by a client and presented with an interesting problem: frequently, their data management application – a critical piece of their business model – would grind to a halt. Searches would take many minutes to complete, if they completed at all. Important reports which ... [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2012/07/dynamic-sql-search-performance) --- [![](https://www.teamscs.com/hubfs/Imported_Blog_Media/scs-logo-back.png)](https://www.teamscs.com/superior-spotlight-blogs/2011/01/who-is-scs) ##### [Who is SCS?](https://www.teamscs.com/superior-spotlight-blogs/2011/01/who-is-scs) Superior Consulting Services (SCS) is a Microsoft Gold Certified technology firm providing innovative solutions that enable our clients to solve business problems. We use Microsoft products and tools to provide custom solutions to small- to medium-sized businesses in the Twin Cities, as well as ... [Read The Full Post](https://www.teamscs.com/superior-spotlight-blogs/2011/01/who-is-scs) --- [Prev](https://www.teamscs.com/superior-spotlight-blogs/page/4) [1](https://www.teamscs.com/superior-spotlight-blogs) [2](https://www.teamscs.com/superior-spotlight-blogs/page/2) [3](https://www.teamscs.com/superior-spotlight-blogs/page/3) [4](https://www.teamscs.com/superior-spotlight-blogs/page/4) [5](https://www.teamscs.com/superior-spotlight-blogs/page/5) [All](https://www.teamscs.com/superior-spotlight-blogs/all) [![SCS\_2015\_LOGO](https://www.teamscs.com/hubfs/SCS_2015_LOGO.svg)](https://www.teamscs.com/old-homepage) 350 West Burnsville Parkway, Suite 550 Burnsville, MN 55337 [scs@teamscs.com](mailto:scs@teamscs.com) [952.890.0606](tel:9528900606) - - - - [Careers](https://www.teamscs.com/superior-consulting-careers) - [Power BI Consulting and Support](https://www.teamscs.com/power-bi-enterprise) - [Fabric Consulting](https://www.teamscs.com/microsoft-fabric-consulting) - [Azure Services](https://www.teamscs.com/azure-services) - [Power Apps & Power Automate Services](https://www.teamscs.com/power-apps-power-automate) - [Data Unification & Modernization](https://www.teamscs.com/data-unification) - [Data Modeling](https://www.teamscs.com/data-modeling) - [Reporting & Analytics](https://www.teamscs.com/reporting-and-analytics) - [GIS & Spatial Analytics](https://www.teamscs.com/gis-spatial-analytics) - [Business Automation & Workflow](https://www.teamscs.com/business-automation) - [Government Contracting](https://www.teamscs.com/government-contracting) - [HHS Departments](https://www.teamscs.com/county-hss-departments) - [Community Corrections](https://www.teamscs.com/community-corrections) - [Manufacturing](https://www.teamscs.com/manufacturing) - [Insurance Companies](https://www.teamscs.com/insurance-industry) - [Financial Institutions](https://www.teamscs.com/financial-institutions) - [Nonprofits](https://www.teamscs.com/nonprofits) - [Service Providers](https://www.teamscs.com/service-providers) - [SaaS Companies](https://www.teamscs.com/software-as-a-service) Copyright © 2026 Superior Consulting Services | All Rights Reserved | [Privacy Policy](http://23673295.hs-sites.com/privacy-policy) | [Terms of Use](https://www.teamscs.com/terms-of-use) | Minneapolis Web Design by Bizzyweb