Generated by All in One SEO Pro v5.0.0.1, this is an llms.txt file, used by LLMs to index the site.

# The Data Crew

Data‑Driven. Decision‑Ready.

## Sitemaps

- [XML Sitemap](https://thedatacrew.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Articles](https://thedatacrew.com/articles/)
- [Azure & Office 365 IP Address Ranges Reference](https://thedatacrew.com/azure-office-365-ip-address-ranges-reference/) - Quick Reference to where the latest various Azure IP ranges are located across the Microsoft documentation Resources. I'll keep this post updated as they change. Azure IP Ranges and Service Tags – Public Cloud General https://www.microsoft.com/en-us/download/details.aspx?id=56519 US Gov http://www.microsoft.com/en-us/download/details.aspx?id=57063 Germany http://www.microsoft.com/en-us/download/details.aspx?id=57064 China http://www.microsoft.com/en-us/download/details.aspx?id=5706 POP IP list for Azure Content Delivery Network https://learn.microsoft.com/en-gb/azure/cdn/cdn-pop-list-api Limits and configuration
- [SQL Server CLR Function on Azure SQL Server Managed Instance](https://thedatacrew.com/sql-server-clr-function-on-azure-sql-server-managed-instance/) - When you need to deploy an assembly (.net DLL) SQL Server CLR Function on Azure SQL Server Managed Instance, you have to do it slightly differently. I'll show you how to do this with the least amount of effort! On a locally hosted or native installation of SQL Server, you would reference the assembly locally.
- [SQL Server Managed Instance IO Performance](https://thedatacrew.com/sql-server-managed-instance-io-performance/) - SQL Server Managed Instance IO Performance is dependant on a few settings. Service Tier vCore Count File Sizes !! Yes, File Sizes. A quick explanation, if you have a small database < 128GB your not going to get much data throughput. Only around the 500 IOPS or 100 MB/s. It's all explained here. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits You
- [SSIS Dependency Diagram with DiagrammeR and Sprockit](https://thedatacrew.com/ssis-dependency-diagram-with-diagrammer-and-sprockit/) - We can use DiagrammeR & Sprockit to discover Server Integration Services (SSIS) Dependencies. SSIS is a mature data integration tool bundled with SQL Server. SSIS like many other tools can lead to 'dependency hell'. This is where packages or stored procedures are developed that carry out many tasks. With many of these packages it can
- [Making a Classification Prediction with Neural Networks](https://thedatacrew.com/making-a-classification-prediction-with-neural-networks/) - In this post I give an example of making a prediction with R stats for a type of business problem that requires a classification prediction. The business question being answered is to evaluate the safety standard of cars based on certain parameters and classify them to predict Car Acceptability. This data is obtained from UCI Machine
- [Using an R Dataframe as a Power BI source](https://thedatacrew.com/using-an-r-dataframe-as-a-power-bi-source/) - Power BI can use a wide variety of data sources. This is one of the things that makes it very powerful. In this post I show how you can use an R script as a data source. If you have folks in your team that can program R you can take advantage of the power
- [Python Script to get Data for Power BI](https://thedatacrew.com/python-script-to-get-data-for-power-bi/) - For a recent meetup I wanted to query the website predithq. They have a dataset of events and I wanted to use this data in a meetup. Unfortunately Power BI isn't compatible with the API this provider uses. They use a 308 Permanent redirect as the initial response, requiring an additional request. After a bit
- [Upload Multiple Files to Azure Storage with PowerShell](https://thedatacrew.com/upload-multiple-files-to-azure-storage-with-powershell/) - A simple code example that takes a pipeline input of file names, appends an optional date stamp and uploads the file(s) to Azure Storage. It needs the new Azure Az Module. You can install that here. Install-Module Az -AllowClobber -Scope CurrentUser Install-Module Az -AllowClobber -Scope CurrentUser Here is the PowerShell Script. Copy-ItemToAzStorage.ps1 param ( [Parameter(Mandatory
- [Microsoft Dynamics Nav SQL Queries](https://thedatacrew.com/microsoft-dynamics-nav-sql-queries/) - As part of our ERP query series we bring you Navision / Microsoft Dynamics Nav / Dynamics 365 Business Central the new name for the latter. The schemas are all pretty close and there are many tables and but there are a few core ones that are always used in ETL / BI Analytics projects.
- [Cleaning Football Data with R Tidyverse](https://thedatacrew.com/cleaning-football-data-with-r-tidyverse/) - Cleaning data is a big part of Data Science. Being able to script data cleaning makes it repeatable and transparent. The best tools to do this with in my opinion are R/Python/Power Query/SQL. In this post I take some scrapped Football data and clean it up with Tidyverse packages in the R stats eco-system. I've

## Pages

- [The Data Crew - Data & Analytics Consultancy, Manchester](https://thedatacrew.com/) - Modern data consultancy delivering analytics solutions with Azure, Databricks, Synapse, Power BI & ML. Built for insight, scale, and performance.
- [Trusted Azure Data Specialists Achieving Outstanding Outcomes](https://thedatacrew.com/about-us/) - Where Modern Meets Proven. We’re a modern data consultancy built on timeless principles — blending Kimball, Inmon, and Data Vault with cutting-edge Azure, Fabric & Databricks to deliver results that last. Book a free initial consultation Your Trusted Partner in Data & Analytics At The Data Crew, we specialize in designing, building, and delivering modern
- [Support](https://thedatacrew.com/support/) - Tech Trouble? Let’s Fix It—Fast. From glitches to roadblocks, our expert support team is ready to jump in and get you back on track—your way, right away. Book a support call Service Hub Login to your Service Hub to create tickets and manage your support requests online. Login Now Email Support Send an email to
- [Warehouse Wisdom. Lakehouse Speed.](https://thedatacrew.com/data-warehouse/) - Warehouse Wisdom. Lakehouse Speed. We fuse classic modelling with cloud-native muscle, so your data moves at lakehouse speed. Book a free initial consultation Proven Modelling Patterns—Re-imagined for Today Choosing a “one-size-fits-all” model is outdated. We blend these patterns to match your data sources, governance needs, and growth plans. Approach Core Idea When It Shines Now
- [Databricks](https://thedatacrew.com/databricks/) - Ready, Set, Lakehouse. Accelerate with DATABRICKSXCELERATOR® — Databricks Lakehouse Blueprints as Code. Book your 30‑minute Databricks Workshop Spin up a secure, well‑architected Azure Cloud foundation in days. Built on Microsoft’s Cloud Adoption Framework and delivered through proven Bicep & Terraform templates, DATABRICKSXCELERATOR® delivers governance, networking, security, Databricks, and data pipelines—so you can focus on insights, not infrastructure. Data’s
- [Data Xcelerator](https://thedatacrew.com/data-xcelerator/) - ETL/ELT. At Warp Speed. Automate 80% of your data integration with metadata-driven ETL for Azure Data Factory, Fabric, Databricks & the Lakehouse with PortalXcelerator® Book a free initial consultation Content Coming Soon
- [Portal Xcelerator](https://thedatacrew.com/portal-xcelerator/) - Your Insights. Their Access. Instantly. Transform internal analytics into a secure, self-service data portal. Publish dashboards from Power BI, Databricks, Tableau, and more—beautifully embedded in the PortalXcelerator® CMS. Book a free initial consultation Content Coming Soon
- [Consulting & Support](https://thedatacrew.com/consulting-support/) - Fix. Improve. Accelerate. Whether it’s Azure, Databricks, Synapse, SQL, Fabric or Power BI, we solve performance problems and unblock development — so your data team stays on track. Book a free initial consultation Architecture & StrategyWe design cloud-native data architectures using Microsoft Fabric, Azure Databricks, and the wider Azure ecosystem. From high-level roadmaps to detailed
- [Contact](https://thedatacrew.com/contact/) - Let’s Talk Data. Ready to transform your data strategy or just have a quick question? Reach out — we’re here to help. Explore our services Please call us direct, or fill in the form below and we'll get back to you. We can't wait to hear from you. Please enable JavaScript in your browser to
- [Data Governance](https://thedatacrew.com/data-governance/) - Secure Every Byte. Pass Every Audit. Map your entire data estate in real time—automated discovery, sensitive-data classification, and end-to-end lineage that slam-dunks GDPR, HIPAA & SOX compliance. Book your 30‑minute Power BI Workshop Why Data Governance Matters Data volumes are exploding. Regulations are tightening. Without governance, insight becomes guesswork. Governance by Design, Not Afterthought. We
- [Power BI](https://thedatacrew.com/power-bi/) - Insight Starts Here. Unleash the power of your business data with modern BI—Power BI. Book your 30‑minute Power BI Workshop Fast. Actionable. Scalable. Built for modern teams, Power BI empowers everyone—from data analysts to execs—to act faster with real-time, interactive insights. Unify Your Data. Sharpen Your Decisions. Most businesses juggle data from multiple systems—legacy platforms,
- [Microsoft Fabric](https://thedatacrew.com/microsoft-fabric/) - All Your Data. One Fabric. Unify data engineering, real‑time analytics, and BI on Microsoft Fabric—AI‑ready, lake‑centric, and governed end‑to‑end. Book your 30‑minute Fabric Workshop Spin up a secure, unified Microsoft Fabric Lakehouse in days. Built on Microsoft’s Cloud Adoption Framework and delivered through proven Bicep & Terraform templates, FABRICXCELERATOR® streamlines governance, networking, security, OneLake, DirectLake, and data pipelines—so you can focus
- [Azure Data Platform](https://thedatacrew.com/azure-data-platform/) - Raw to Ready. Insights On Tap. Enterprise‑grade analytics, deployed in days. Book your 30‑minute Data Landing Zone Workshop Spin up end‑to‑end analytics foundation in days, not months. Our Azure Data Platform blueprints weave security, governance, cost control & DevOps into every layer—so your teams can focus on turning data into outcomes, not wrestling with infrastructure.
- [Data Analytics & BI](https://thedatacrew.com/data-analytics-as-a-service/) - Data Driven. Delivered. We run your Azure analytics stack—so you can focus on insights, not infrastructure. Book a 30 minute discovery call 360° view of your business Get deeper insights from your data Drive tangible business outcomes Eliminate repetitive reporting Empower your team Track live performance Data Analytics as a Service with Microsoft Azure We’ll
- [Azure Data Landing Zone](https://thedatacrew.com/azure-data-landing-zone/) - Ready, Set, Landing Zone. Accelerate with CLOUDXCELERATOR® — Enterprise Landing Zone Blueprints as Code Book your 30‑minute CloudXcelerator Workshop Spin up a secure, well‑architected Azure Cloud foundation in days. Built on Microsoft’s Cloud Adoption Framework and delivered through proven Bicep & Terraform templates, CLOUDXCELERATOR® delivers governance, networking, security, Databricks, Fabric and data pipelines—so you can focus
- [Azure DataXcelerator](https://thedatacrew.com/azure-dataxcelerator/) - Accelerate Azure Data Workloads by 90 % Stop hand‑coding pipelines and start shipping insights the same week. See ROI Calculator
- [Umbraco Power BI Customer Portal](https://thedatacrew.com/power-bi-customer-portal/) - Omnis nemo Umbraco Power BI Customer Portal Saepe do lobortis mattis irure tristique officia wisi sapiente, sunt. Aspernatur rutrum. Aut, iusto eos laboriosam a tenetur, tempus nobis cupiditate, aliquam Omnis nemo Illum congue laborum euismod quisquam montes deserunt ducimus voluptatum curabitur suspendisse suspendisse delectus voluptates labore? Facilisis, vero id, rhoncus ligula? Blandit torquent dis lectus,
- [Remote Consulting](https://thedatacrew.com/remote-consulting/) - Consulting Remote Consulting Advised on data strategy, defined the Data Architecture, built the Azure Infrastructure, Data Integration (ETL), Data Warehouse & developed the Power BI Data Model. Viverra voluptatum illo voluptate metus lacinia quidem, taciti praesent praesent, minima nam hic vel, ipsam aliquam natoque, soluta! Ullamcorper quidem curae eget litora fugiat. Libero pharetra doloremque accumsan
- [Privacy Policy](https://thedatacrew.com/privacy-policy/) - Privacy Policy This privacy policy applies between you, the User of this Website and The Data Crew (AME Futures Ltd), the owner and provider of this Website. The Data Crew (AME Futures Ltd) takes the privacy of your information very seriously. This privacy policy applies to our use of any and all Data collected by
- [Azure ADF ETL Accelerator](https://thedatacrew.com/azure-adf-etl-accelerator/) - Omnis nemo Azure ADF ETL Accelerator Saepe do lobortis mattis irure tristique officia wisi sapiente, sunt. Aspernatur rutrum. Aut, iusto eos laboriosam a tenetur, tempus nobis cupiditate, aliquam Omnis nemo Illum congue laborum euismod quisquam montes deserunt ducimus voluptatum curabitur suspendisse suspendisse delectus voluptates labore? Facilisis, vero id, rhoncus ligula? Blandit torquent dis lectus, parturient
- [Consulting](https://thedatacrew.com/consulting/) - Consulting Services Advised on data strategy, defined the Data Architecture, built the Azure Infrastructure, Data Integration (ETL), Data Warehouse & developed the Power BI Data Model. Remote Consulting Excepteur libero porta amet? Debitis potenti luctus optio in cum iusto, eleifend, ut debitis cillum ratione erat cras egestas sed? Condimentum sint! Architecto hymenaeos tenetur elementum nunc
- [Data Engineering](https://thedatacrew.com/data-engineering/) - Extract, Transform & Load Integrations Services, Azure Data Factory, ETL Automation & BIML Experts Reduce complexity, standardise & automate, Find how we shave 80% off your ETL / ELT workload Data Engineering & Integration With every data analytics & reporting project, there is always the requirement to load data from external applications and systems into

## Case Studies

- [Individual Restaurants Group](https://thedatacrew.com/case-studies/individual-restaurants-group/) - We delivered a modern Azure data platform for Individual Restaurants Group — redesigning their architecture, integrating data sources, and enabling real-time Power BI insights across operations, finance, and marketing.
- [White Oak UK](https://thedatacrew.com/case-studies/white-oak-uk/) - White Oak UK are specialists in SME business finance, offering a range of funding solutions from business loans for VAT or tax to invoice finance to unlock funds.
- [Two Circles](https://thedatacrew.com/case-studies/two-circles/) - Their clients are the biggest names in sports clubs and venues, from jockey clubs to football stadiums..
- [Seddons Plant & Engineering](https://thedatacrew.com/case-studies/seddons/) - Seddon Plant & Engineers Ltd are suppliers of Construction, Groundcare & Environmental products
- [Home Instead](https://thedatacrew.com/case-studies/home-instead/) - Home Instead is one of the UK’s leading Care Providers. They have over 230 franchises that use their world-class branding and infrastructure.
- [Age UK](https://thedatacrew.com/case-studies/age-uk/) - Age UK provide services and support at a national and local level to inspire, enable and support older people
- [EFT](https://thedatacrew.com/case-studies/eft/) - EFT helps build, protect and maintain their client’s property, life safety and security assets.
- [Hoyle Law](https://thedatacrew.com/case-studies/hoyle-law/) - Hoyle Law provides high-quality, specialist legal services.
- [Belting Manufacturer](https://thedatacrew.com/case-studies/belting-manufacturer/) - A leading Belting Manufacturer were paying a lot of money for a third-party company to manage their data, and it wasn’t working.

## Categories

- [Microsoft Business Intelligence](https://thedatacrew.com/category/microsoft-business-intelligence/)
- [Data Science](https://thedatacrew.com/category/data-science/)
- [ETL](https://thedatacrew.com/category/etl/)
- [SSIS](https://thedatacrew.com/category/ssis/)
- [Analytics](https://thedatacrew.com/category/analytics/)
- [Data Warehousing](https://thedatacrew.com/category/data-warehousing/)
- [Azure](https://thedatacrew.com/category/azure/)
- [PowerShell](https://thedatacrew.com/category/powershell/)
- [Database Performance](https://thedatacrew.com/category/database-performance/)
- [SQL Server](https://thedatacrew.com/category/sql-server/)

## Tags

- [Power BI](https://thedatacrew.com/tag/power-bi/)
- [Python](https://thedatacrew.com/tag/python/)
- [Classification Prediction](https://thedatacrew.com/tag/classification-prediction/)
- [Neural Networks](https://thedatacrew.com/tag/neural-networks/)
- [R](https://thedatacrew.com/tag/r/)
- [Data Cleansing](https://thedatacrew.com/tag/data-cleansing/)
- [Tidyverse](https://thedatacrew.com/tag/tidyverse/)
- [DiagrammeR](https://thedatacrew.com/tag/diagrammer/)
- [Sprockit](https://thedatacrew.com/tag/sprockit/)
- [SSIS](https://thedatacrew.com/tag/ssis/)
- [Dynamics 365 Business Central](https://thedatacrew.com/tag/dynamics-365-business-central/)
- [ERP Queries](https://thedatacrew.com/tag/erp-queries/)
- [Microsoft Dynamics Nav](https://thedatacrew.com/tag/microsoft-dynamics-nav/)
- [Nav Customers](https://thedatacrew.com/tag/nav-customers/)
- [Nav Inventory](https://thedatacrew.com/tag/nav-inventory/)
- [Nav Products](https://thedatacrew.com/tag/nav-products/)
- [Nav Queries](https://thedatacrew.com/tag/nav-queries/)
- [Nav Sales](https://thedatacrew.com/tag/nav-sales/)
- [Nav Sales Ledger](https://thedatacrew.com/tag/nav-sales-ledger/)
- [Nav Sales Queries](https://thedatacrew.com/tag/nav-sales-queries/)
- [SQL Queries](https://thedatacrew.com/tag/sql-queries/)
- [Azure](https://thedatacrew.com/tag/azure/)
- [PowerShell](https://thedatacrew.com/tag/powershell/)
- [Storage](https://thedatacrew.com/tag/storage/)
- [IP Range](https://thedatacrew.com/tag/ip-range/)
- [IOPS](https://thedatacrew.com/tag/iops/)
- [Performance](https://thedatacrew.com/tag/performance/)
- [SQL Server Managed Instance](https://thedatacrew.com/tag/sql-server-managed-instance/)
- [Azure SQL Server Managed Instance](https://thedatacrew.com/tag/azure-sql-server-managed-instance/)
- [CLR Functions](https://thedatacrew.com/tag/clr-functions/)

## Industry

- [Marketing & Media](https://thedatacrew.com/industry/media/)
- [Retail](https://thedatacrew.com/industry/retail/)
- [Financial Services](https://thedatacrew.com/industry/financial-services/)
- [Leisure & Entertainment](https://thedatacrew.com/industry/leisure-entertainment/)
- [Manufacturing](https://thedatacrew.com/industry/manufacturing/)
- [Legal](https://thedatacrew.com/industry/legal/)
- [Non Profit](https://thedatacrew.com/industry/non-profit/)
- [Engineering](https://thedatacrew.com/industry/engineering/)
- [Care & Social Services](https://thedatacrew.com/industry/care/)