PowerBI: Optimizing SQL Queries Part 2
Table of Contents * Managing Query Steps and Naming Conventions * Splitting and Modularizing Complex Queries * Disabling Loading for Supporting Queries * Managing Date/Time Columns and Auto
Chase Woodard
Latest posts
PowerBI: Optimizing SQL Queries Part 1
Table of Contents * Overview of SQL Query Optimization in Power BI * Why Optimized SQL Queries Matter for Automated Reporting * How SQL Query Optimization Works in
Power BI: Understanding Parameters
Table of Contents * Overview * Parameter Types * Parameter Properties * Creating Parameters in Power BI Desktop * Using Parameters in Reports * Best Practices * Conclusion Parameters in Power BI
Automating API Workflows with Postman, Python Requests, & Jinja2
Table of Contents * Introduction * Tools Overview * Core Concepts & Components * Setting Up Your Environment * Designing and Testing API Workflows in Postman * Exporting Postman Requests to
F5 Logging, Reporting & Monitoring with Prometheus + Grafana
F5 Logging, Reporting, & Monitoring with Prometheus + Grafana Everything You Need to Know Table of Contents * Overview * Core Components * Prerequisites * Configuration * Local Logging * Remote Logging
Pipelines: Azure DevOps (ADO) & Ansible AWX Integration
Pipelines: Azure DevOps (ADO) & Ansible AWX Integration Everything You Need to Know Table of Contents * Overview * Core Components * Prerequisites * Configuration * Validation * Troubleshooting * Conclusion Overview:
Ansible AWX: Deep Dive
Ansible AWX: Deep Dive Everything You Need to Know Table of Contents * Overview * Core Components * Prerequisites * Configuration * Syncing Git Repository * Validation * Troubleshooting * Conclusion Overview: Ansible
Ansible: Roles Using Jinja2 (REST-API) Templating
Ansible: Roles Using Jinja2 (REST-API) Templating Everything You Need to Know Table of Contents * Overview * Core Components * Prerequisites * Configuration * Validation * Troubleshooting * Conclusion Overview: Jinja2
F5 (FIPS) Federal Information Processing Standards
F5 (FIPS) Federal Information Processing Standards Everything You Need to Know Table of Contents * Overview * Core Components * Prerequisites * Configuration * Validation * Troubleshooting * Implementation Risk Overview: What
F5 (C3D) Client Certificate Constrained Delegation
F5 (C3D) Client Certificate Constrained Delegation Everything You Need to Know Table of Contents: * Overview * Core Components * Prerequisites * Configuration * Validation * Troubleshooting * Conclusion This feature allows
Git: Commit Code to Repo
Committing New Code to Existing Repo Everything you need to know Table of Contents: * Why Version Control Matters * The Basic Git Workflow * Common Git Commands
Declarative VS Imperative
Differences Focus: * Declarative programming focuses on describing the desired result or logic, without specifying the control flow or implementation details. * Imperative programming focuses on explicitly