Creating powerful “what-if” scenario analyses and visualizations using Power BI modeling parameters.
Power Query examples to access Excel data in the current workbook, local file, or SharePoint path. Data structured as a worksheet, table, or named range.
How to manually create a WordPress database, establish a WordPress user access account, and import data from the MySQL / MariaDB command line.
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.
How to query a REST API using Power Query and process the paginated results when the number of pages is either known or unknown.
How to render map visualizations with complex and duplicated city names in Power BI using geographical hierarchies.
How to render both basic map and filled map visualizations in Power BI using continent and country names.
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.