Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

Data and Analytics

Using Cards To Filter In Power BI

How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.

Categories Data and Analytics Tags Excel, Power BI, Power Query Leave a comment

WordPress Database Cleanup Without Plugins (SQL Only)

Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.

Categories Data and Analytics Tags MySQL, phpMyAdmin, WordPress 1 Comment

Handling Paginated REST API Results with Power Query

How to query a REST API using Power Query and process the paginated results when the number of pages is either known or unknown.

Categories Data and Analytics Tags JSON, Power BI, Power Query, REST API 17 Comments

Mapping Cities in Power BI

How to render map visualizations with complex and duplicated city names in Power BI using geographical hierarchies.

Categories Data and Analytics Tags Power BI Leave a comment

Mapping Continents and Countries in Power BI

How to render both basic map and filled map visualizations in Power BI using continent and country names.

Categories Data and Analytics Tags Power BI Leave a comment

Excel Lookup Using Date Ranges and Multiple Criteria in Power Query

How to use Power Query to retrieve a value when the date from the first table exists between an effective date range in a second table.

Categories Data and Analytics Tags Excel, Power Query 2 Comments

Display Excel File Modified Date in Power BI

How to display the last modified date of the underlying source Excel data file used in a Power BI report.

Categories Data and Analytics Tags Excel, Power BI, Power Query, VBA Leave a comment

Custom Power BI Date Tables Using Power Query

How to create a custom date table and year, quarter, month hierarchy in Power BI using Power Query.

Categories Data and Analytics Tags Power BI, Power Query 1 Comment

Display Total Inside Power BI Donut Chart

How to display a total and percent of total at the center of a Power BI donut chart.

Categories Data and Analytics Tags Excel, Power BI Leave a comment
Older posts
Page1 Page2 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Display Total Inside Power BI Donut Chart
  • How to Use Unicode Characters in Power BI
  • Create Self-Signed S/MIME Certificates
  • Automate E-mail Information Extraction from Outlook into Excel Using VBA

Latest Posts

  • Upgrade PHP and PHP-FPM from the Command Line on a Debian LAMP Stack
  • Install a LAMP Stack Manually on a Debian OS Only Amazon Lightsail Instance
  • Automatically Back Up a Linux Server to Google Drive
  • Linting WordPress Code Using Composer and PHP_CodeSniffer
  • Using Cards To Filter In Power BI

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.