Andrew Bancroft is an experienced iOS developer and educator with over 15 years of experience. He shares tutorials, courses, and insights on Swift, SwiftUI, Core Data, and app development best practices.
203 articles from this blog
Learn how to load Excel files using Python and Pandas with examples for local files and URLs.
Learn how to load a CSV file using Python and Pandas, including from local directories and URLs.
A cheat sheet listing Jupyter Notebook keyboard shortcuts for Command and Edit modes.
Guide to creating a SQL Server credential for accessing Azure Blob Storage using PowerShell.
A mnemonic for remembering Type I and Type II errors in hypothesis testing using a courtroom analogy.
Overview of iOS data persistence options including UserDefaults, Core Data, SQLite, and remote storage solutions.
Explains the meaning and use of the tilde (~) symbol in R for statistical modeling and formulas.
Troubleshooting guide for resolving 'No events found' error when sampling data with Azure Stream Analytics, focusing on JSON formatting issues.
Guide to deciphering error messages in Azure Data Lake Analytics U-SQL jobs, covering script, data, and extractor issues.
A guide to fixing common U-SQL syntax errors for T-SQL newcomers, focusing on capitalization and semicolons.
Learn to use Apple's CloudKit framework for remote data storage, syncing, and sharing in iOS apps with this foundational course.
Explores whether Core Data entities need explicit primary key properties, using SQLite debug insights.
Explores the use cases for Apple's CloudKit as a backend service for mobile apps, comparing it to Firebase and custom backends.
Guide to programmatically creating an HDInsight cluster in Azure using PowerShell, including login, resource group, and storage setup.
A Swift cheat sheet for implementing iPhone location services, covering permissions, CLLocationManager, and delegate methods.
Swift cheat sheet for iPhone camera access, covering permission requests, camera usage, and handling captured images.
Explains why dimensional modeling remains relevant in big data, offering 5 reasons for IT and business success.
Explains the difference between predictive analytics and machine learning, clarifying their relationship and distinct roles.
Troubleshooting SSIS flat file destination error 'Cannot open the datafile' with common causes and fixes.
Explores the difference between data analysis and data analytics by examining the suffixes -sis, -tic, and -ics.
