Blog

Using Microsoft Fabric to serve multi-tenant data & analytics Category: Fabric, Office 365, Power BI

A Shift in Tone: Unpacking Sam Altman’s Bold AGI Claims Category: AI & ML, OpenAI

Canada’s productivity puzzle – tale of a cautious Canadian owner class Category: Economics

First-time journey publishing an app to the Google Play Store Category: Dart, Flutter, Google Play, Mobile App Dev

Google Watch Fitbit data and visualization Category: Javascript, MongoDB, Node.js, Plotly, Python

Radio wave light spheres – radio waves washing over nearby stars Category: Javascript, Science

Visualization of tennis player rank vs match outcome and betting odds Category: EChart.js, Javascript

DeepMind Materials new crystal structure data analysis Category: Python, Science

DeepMind AlphaMissense matched to 23andMe data Category: Python, Science

Apache EChart alternative faux legend solution Category: EChart.js, Javascript

Use ChatGPT to standardize and categorize bank and credit card descriptions Category: ChatGPT

Gestalt communication facilitated by multi-modal generative AI? Category: AI & ML, ChatGPT, LLM

Microsoft Windows Copilot General Availability September 26, 2023 Category: Microsoft Copilot

Voip.ms get call detail records and set call detail record filters using API Category: API, Python

OpenAI ChatGPT 4 Advanced Data Analysis used to do river water flow analysis Category: ChatGPT, Environmental science, Python

Attended London Power BI User Group: Introducing Fabric! – London, UK – May 23, 2023 Category: Fabric

Fabric Dataflow Gen2 Web API connection with dynamic current date parameter Category: Fabric, Power BI, Power Query

Attended Data Science Festival Mayday – London, UK – May 20, 2023 Category: AI & ML

CBC news article comments analysis and visualization Category: BeautifulSoup, NetworkX, NLTK, Python

CBC news comment and replies interaction network visualization Category: BeautifulSoup, NetworkX, NLTK, Python

Canada cell tower distribution QGIS visualization Category: Geocoding, QGIS

CBC news article comments web scraping Category: BeautifulSoup, Javascript, NetworkX, NLTK, Python, Web Development

Xero.com data consolidation and reporting solution selection Category: Business Intelligence, ERP, Xero

Canadian Government First Nations long term water advisory data Category: Business Intelligence, Excel Pivot Chart, Excel Pivot Table, Javascript, Plotly, Power Query, Python, Web Development

COVID-19 Data Analysis and Visualization Summary Category: Amazon Web Services (AWS), D3.js, Geocoding, Javascript, Plotly, Power Query, Python

TendiesTown.com – WallStreetBets gain and loss analysis Category: API, Django, Plotly, Python

Use Excel Power Query to get data from Our World In Data Category: Power Query

Sir Patrick Stewart @SirPatStew #ASonnetADay dashboard Category: API, Javascript, Plotly, Python, Twitter API

The human radio-broadcast bubble Category: Science

Amazon AWS Transcribe used to get 2020 presidential debate #1 speaker segments Category: Amazon Web Services (AWS), Plotly, Python

D3.js SVG animation – COVID-19 rate “race” visualization Category: D3.js, Javascript, Web Development

Amazon AWS Textract – WHO “Draft landscape of COVID-19 candidate vaccines” – convert PDF to csv Category: Amazon Web Services (AWS), Python

Periodic chart elements by origin from SVG using Python Category: Plotly, Python

Retrieve and process Environment Canada hydrometric and climate data using Python Category: Environmental science, Python

Plotly Express Python remove legend title Category: Plotly, Python

Legend and polygon colors for Leaflet choropleth using Chroma.js Category: Javascript, Web Development

Scraping public health web page using Python, BeautifulSoup4, Requests and Pandas Category: Amazon Web Services (AWS), BeautifulSoup, Python

Heat maps of Canadian activity changes due to COVID-19 using Google Community Mobility Reports Category: D3.js, Excel Pivot Chart, Excel Pivot Table, Javascript, Power Query, Web Development

Choropleth map of Canada COVID-19 cases by health region using Leaflet and D3.js Category: D3.js, Geocoding, Javascript, Python

GlobalPrePaidCreditCard.com – Prepaid and gift credit card feature comparison for multiple countries Category: Django, Python, Web Development

Delete Google Calendar events by date using Google Script Category: Google Calendar, Google Script

OneDrive SharePoint Migration Tool (SPMT) Category: Azure, Office 365, OneDrive

AWS S3 csv file as D3 report data source Category: Amazon Web Services (AWS), D3.js, Javascript, Web Development

Introduction to Microsoft Power Query in Excel and Power BI Category: Power BI, Power Query

AWS RDS Postgres database external secure connection Category: Amazon Web Services (AWS)

How to use Hadoop HDFS as a datasource for Power BI Category: Hadoop, Power BI

How to use Python as a datasource for Power BI Category: Power BI, Python

Comparison of my old Palm vs my new Pocket PC (from 2004) Category: Palm Pilot

BC Executive Compensation Tableau Visualization Category: Python, Tableau

Business Intelligence – IT Black Box Challenge Category: Business Intelligence

Twitter Followers and List Membership Tracking Category: Amazon Web Services (AWS), API, Chart.js, Python, Twitter API

Installing Hadoop on Windows 8.1 Category: Hadoop

Vultr and Digital Ocean make it easy to get projects going fast Category: Web Development

Django form geocode submitted address to get lat, lon and postal code Category: Django, Geocoding, Python, Web Development

Leaflet.js choropleth map color by count using geoJSON datasource Category: Django, Geocoding, Javascript, Postgres, Python, Web Development

Canadian Canola seed crushing more efficient at extracting canola oil Category: Tableau

Chart.js tooltip format number with commas Category: Chart.js, Javascript

Python get image color palette Category: Postgres, Python

Excel Power Query tutorial using Canadian potato production statistics Category: Excel Pivot Chart, Excel Pivot Table, Power Query

Django recreate database table Category: Django, Python

Canadian TCS FDI Officers Twitter list member analysis Category: Python, Tableau, Twitter API

Use Excel Power Query to scrape & combine Wikipedia tables Category: Power Query

How to update Office 365 password in Power BI dataset refresh Category: Office 365, Power BI, Sharepoint

How to avoid wide margins on a Power BI dashboard Category: Power BI

How to use Google Adsense API to download Adsense data Category: API, Google Adsense, Python

Create Python 3 Virtualenv on machine with Python 2 & 3 installed Category: Python

Use OneDrive API to upload files to Office 365 Sharepoint Site Category: Azure, Office 365, OneDrive, Python, Sharepoint

Careful! Don’t click “Try Power BI for free” Category: Office 365, Power BI, Sharepoint

How to schedule Power BI dataset refresh Category: Office 365, Power BI, Power Query, Sharepoint

Power BI Online – get data from Office 365 Sharepoint file Category: API, Azure, Office 365, OneDrive, Power BI, Sharepoint

OneDrive API features Category: API, Azure, Office 365, OneDrive, Power BI, Python, Sharepoint

Tracking Cuba Gooding Jr’s Twitter follower count Category: Google Charts, MySQL, Python, Twitter API, Web Development

Dell ecommerce web site scraping analysis Category: BeautifulSoup, Python

Power Query MySQL database connection Category: Power Query

How to serve multiple domain name websites with one CakePHP application Category: CakePHP, MySQL

Always remember to start Python Virtualenv Category: Django, Python

Flask SQLAlchemy relationship associations and backref Category: Flask, Python, SQLAlchemy

Using ATMs as wifi hotspot Category: Web Development

Get list of custom segments from Google Analytics API Category: Google Analytics, Python

Display Django queryset results on Google Map Category: Django, Google Maps API, Javascript

How to setup and and use a Twitter API application Category: Twitter API

How to move Google Chart x-axis to top of chart Category: Google Charts, Javascript

BC Hydro’s amazing #BCStorm social media turnaround Category: Power BI, Power Query, Python, Twitter API

How to create OData data source Gateway for Power BI Report Category: Office 365, Power BI

Introducing Speedvisit – a quick and easy way to record visits from people Category: CakePHP, PHP, SaaS, Web Development

How to filter referral spam from Google Analytics using API and Python Category: API, Google Analytics, Python

Tableau vizualization of Toronto Dine Safe data Category: API, Geocoding, Python, Tableau

Single CakePHP application & MySQL database to serve multiple domains Category: CakePHP, PHP

How a new salmon stream was carved from the land Category: Environmental science

Tableau vizualization of Vancouver Car2Go vehicle locations Category: Tableau

How to vizualize a work schedule using a Qlikview Gantt chart Category: Qlikview

How a UK tent rental company used Google analytics and Tableau to improve sales Category: Google Analytics, Tableau

Time based SLA KPI created using MS Access VBA Category: MS Access, VBA

Visualization of Toronto’s 311 contact centre open data Category: Excel Pivot Chart, Excel Pivot Table, Open Data

Introducing Cardivvy – a website showing Car2Go real time car locations, parking and service areas Category: API, Google Maps API, Javascript, PHP, Web Development

LinkedIn ‘People You May Know’ web scraping and analysis Category: BeautifulSoup, Python

Visualizing human arterial blood flow with a D3.js Sankey chart Category: D3.js