Blog on SQL Server, Business Intelligence, Azure, Power BI and more!

Deleting Is Scary

Power BI, Free Training, BI, Power BI Desktop, Power BI Report Services, Azure Data Architecture Guide, On-Demand Learning
By Matt Peterson
Dec 21, 2020

Loading Folders as Data Sources in POWER BI

Power BI, Free Training, Power BI Report Services, Azure Data Architecture Guide, On-Demand Learning
By Matt Peterson
Dec 14, 2020

The POWER of Support

Staffing, Global Leader in IT Services, On-Demand Learning
By Matt Peterson
Dec 07, 2020

November's Power BI Updates

Power BI, Free Training, Power BI Report Services, On-Demand Learning
By Matt Peterson
Dec 02, 2020

It’s been another month and thank goodness we are getting closer to the end of 2020! If you like to read about the updates...

Unique Ask For Drill Through

Power BI, Free Training, Power BI Report Services, On-Demand Learning
By Matt Peterson
Nov 23, 2020

Power BI Makes APPs, too? A Quick Guide to Understanding that an APP is like a CONTAINER

Power BI, Free Training, Power BI Report Services, On-Demand Learning
By Matt Peterson
Nov 16, 2020

Pizza and DAX are my Love Languages

Power BI, Free Training, DAX, Power BI Report Services, On-Demand Learning
By Matt Peterson
Nov 09, 2020

Calculated Measures on a Halloween Full Moon

Power BI, Free Training, Power BI Report Services, On-Demand Learning
By Matt Peterson
Nov 02, 2020

October's POWER BI's Updates with Matt Peterson

Power BI, Free Training, Power BI Report Services, On-Demand Learning
By Matt Peterson
Oct 26, 2020

DEMO: How to Set Up Parameters for POWER BI Reports

Power BI, Free Training, Power BI Report Services, On-Demand Learning
By Matt Peterson
Oct 19, 2020

Building an App Session 7 | Editing Records- Demo

Power BI, Free Training, Azure Power Apps, On-Demand Learning
By Matt Peterson
Oct 13, 2020

Avoiding Unwanted Outcomes using Date Columns

Power BI, Free Training, DAX, On-Demand Learning
By Matt Peterson
Oct 06, 2020

September's Power BI Update | 2020

Power BI, Free Training, On-Demand Learning
By Matt Peterson
Sep 29, 2020

Power App Session 6 | Adding Records to our Data Sources

Power BI, Free Training, Azure Power Apps, On-Demand Learning
By Matt Peterson
Sep 22, 2020

Power App Session 5 | I am not afraid to edit!

Power BI, Free Training, Azure Power Apps, On-Demand Learning
By Matt Peterson
Sep 15, 2020

Pragmatic Works is now part of the Microsoft Global Training Partner Program

Microsoft, On-Demand Learning
By Pragmatic Works
Sep 14, 2020

An Update on My Journey | September 2020

Power BI, Free Training, Azure Power Apps, On-Demand Learning
By Matt Peterson
Sep 11, 2020

Let's Build a Power App Session 4

Free Training, Azure PowerApps, On-Demand Learning, App in a Day
By Matt Peterson
Sep 08, 2020

It’s time for another session of building our check-in Power App for my former school. This is now session 4 of our series....

Let's Make a Power App (Round 3)

Free Training, Azure Power Apps, On-Demand Learning, App in a Day
By Matt Peterson
Aug 10, 2020

It’s time for another session of building our check-in Power App for my former school. This is now session 3 of our...

Using Web-Sourced NFL Stats in Data Analysis

Power BI, Dashboard in a Day, Power Query, Data Analytics, On-Demand Learning
By Matt Peterson
Aug 07, 2020

Have you ever connected to a web source to do some data analysis? I am sure it's what everyone does in his or her spare...

Join Our Blog

Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.

Posts by Topic

Azure (365)
Power BI (364)
Azure Every Day (346)
Free Training (154)
Power BI Custom Visuals (122)
Company Info (75)
On-Demand Training (68)
Azure Data Factory (65)
On-Demand Learning (65)
Microsoft (53)
SQL Server (48)
Azure Power Apps (43)
SSIS (42)
Azure Databricks (33)
Power BI Monthly Digest (31)
PowerApps (29)
Azure SQL Database (28)
Consulting (28)
Task Factory (26)
DAX (23)
Expert Shared Development (22)
Microsoft Power Platform (22)
Analytics (19)
Azure SQL Data Warehouse (19)
Training (19)
Dashboard in a Day (18)
Data Warehouse (18)
App in a Day (17)
This Week In Data (17)
Azure Active Directory (16)
Cloud (16)
Data Analytics (16)
Excel (15)
Remote Services (15)
SSAS (15)
Microsoft Flow (14)
AI (13)
Big Data (13)
Business Intelligence (13)
Cloud solutions (13)
Data Security (13)
LegiTest (13)
Power BI Managed Services (13)
Power BI Report Services (13)
SSRS (13)
Who Is (13)
Azure Data Lake (12)
Azure Data Week (12)
Azure Analysis Services (11)
Azure DevOps (11)
Azure SQL DB (11)
Disaster Recovery (11)
HDInsight (11)
Machine Learning (11)
Azure Blob Storage (10)
Azure Machine Learning (10)
Cosmos DB (10)
ETL (10)
Power BI Service (10)
SQLSaturday (10)
Azure Data Factory V2 (9)
Azure Data Warehouse (9)
Microsoft PowerApps (9)
Power BI Dataflow (9)
Staffing (9)
PaaS (8)
Power BI Updates (8)
PowerShell (8)
SharePoint (8)
Azure Cognitive Services (7)
Azure Monitor (7)
Common Data Services (7)
Data Governance (7)
Data Migration (7)
Data Modeling (7)
Data Testing (7)
Excel at Excel (7)
Office 365 (7)
Power BI Desktop (7)
Power BI Embedded (7)
Power BI Training (7)
Azure Managed Instance (6)
Azure Storage (6)
Azure VMs (6)
DBA Managed Services (6)
Data Science (6)
IoT (6)
Products (6)
Professional Development (6)
REST Source (6)
Azure Data Lake Store Gen 2 (5)
Azure Portal (5)
Azure SQL Data Warehouse Gen 2 (5)
BI (5)
GDPR (5)
Hadoop (5)
High Availability (5)
Logic Apps (5)
MySQL (5)
Power Automate (5)
Power BI Boot Camp (5)
Power Query Editor (5)
Python (5)
Row Level Security (5)
SQL Server Management Studio (5)
T-SQL (5)
Advanced Threat Protection (4)
Apache Spark (4)
Azure Cost Management (4)
Azure Data Box (4)
Azure Data Catalog (4)
Azure Data Factory Data Flow (4)
Azure Database (4)
Azure Database for MySQL (4)
Azure IoT Hub (4)
Azure Key Vault (4)
Azure Logic Apps (4)
Azure PowerApps (4)
Azure Security (4)
Azure Stream Analytics (4)
BI xPress (4)
Cloud Migration (4)
DBA (4)
Data Driven (4)
Data Storytelling (4)
Direct Query (4)
Learning Paths (4)
NoSQL (4)
Power BI Tips (4)
Pragmatic Workbench (4)
R Language (4)
Sales (4)
Virtual Boot Camp (4)
Visual Studio (4)
e-learning (4)
performance tuning (4)
Azure Advisor (3)
Azure Data Architecture Guide (3)
Azure Data Studio (3)
Azure Database for MariaDB (3)
Azure Integration Services (3)
Azure Machine Learning Studio (3)
Azure Managed Instances (3)
Azure PostgreSQL (3)
BI Quick Start Boot Camp (3)
Bad Data (3)
Cloud Computing (3)
Cloud Security (3)
Data Dictionary (3)
Data Quality (3)
Databricks Delta (3)
Dataflows (3)
Digital Transformation (3)
Dynamics 365 (3)
Free Trial (3)
Hybrid Cloud (3)
IaaS (3)
Learning Coaches (3)
MDX (3)
Metadata (3)
PASS Summit (3)
PASS Summit 2019 (3)
Power Apps Functions (3)
Power BI Mapping (3)
Power BI Premium (3)
Power BI Quick Tips (3)
Power BI Report Server (3)
Power BI Security (3)
Power Query (3)
Power Virtual Agents (3)
Real-World Data Testing (3)
SAP ERP (3)
Salesforce (3)
Slowly Changing Dimensions (3)
Stored Procedure (3)
Tableau (3)
Virtual Machines (3)
Advanced Analytics (2)
Analysis Services (2)
Azure Automation (2)
Azure Bot Service (2)
Azure Computer Vision API (2)
Azure Data Architecture (2)
Azure Data Box Disk (2)
Azure Data Box Edge (2)
Azure Data Box Gateway (2)
Azure Data Platform (2)
Azure Event Grid (2)
Azure Event Hub (2)
Azure Functions (2)
Azure Log Analytics (2)
Azure Management Studio (2)
Azure Marketplace (2)
Azure Network Watcher (2)
Azure Pricing Calculator (2)
Azure Resource Manager (2)
Azure SQL Managed Instance (2)
Azure Secure Score (2)
Azure Security Center (2)
Azure Services (2)
Azure Storage Explorer (2)
Azure Synapse Analytics (2)
Bing Maps (2)
COVID-19 (2)
Chatbots (2)
Cloud Accelerators (2)
DOC xPress (2)
Data Flows (2)
Data Help Desk (2)
Data Privacy (2)
Data Protection (2)
Databricks cluster (2)
Date Tables (2)
Dynamic Reporting (2)
ELT Workloads (2)
Elastic Query (2)
Global Leader in IT Services (2)
Identity Management (2)
Informatica (2)
JSON (2)
M Query Language (2)
Master Data Management (2)
Microsoft Certifications (2)
OneDrive (2)
PASS Summit 2017 (2)
Power Apps Design Tips (2)
Power Apps Portals (2)
Power BI Interview Questions (2)
Power Platform Quick Tips (2)
Power Query Builder (2)
Power Virtual Agents in a Day (2)
Project Management (2)
R (2)
Report Server Administration (2)
SQL (2)
SQL Database (2)
SQL Karaoke (2)
SQL Server Analysis Service (2)
SQL Server Integration Services (2)
Security (2)
Security and Management (2)
Software Releases (2)
Spark (2)
Tabular Models (2)
Virtual Conference (2)
Virtual Workshop (2)
ADFv2 (1)
AI Builder (1)
APS (1)
AZ 900 Exam (1)
Address Verification (1)
Administering Business Intelligence (1)
Advanced Data Technologies (1)
AlwaysOn (1)
Amazon (1)
Application Insights (1)
Augmented Analytics (1)
AutoML (1)
Automated Task (1)
Azure Blockchain (1)
Azure Bot Framework (1)
Azure Command Line (1)
Azure Common Data Services (1)
Azure Consumption Insight (1)
Azure Customer Advisory Team (1)
Azure Data Box Heavy (1)
Azure Data Explorer (1)
Azure Data Lake Gen 2 (1)
Azure Data Lake Storage Gen2 (1)
Azure DevOps Git (1)
Azure Exams (1)
Azure File Sync (1)
Azure Firewall (1)
Azure Hybrid Benefit (1)
Azure IP Advantage (1)
Azure IaaS SQL Server Agent Extension (1)
Azure Maps (1)
Azure Networking (1)
Azure Open Source (1)
Azure Portal Mobile App (1)
Azure Queues (1)
Azure Relational Database Services (1)
Azure Reserve VM Instances (1)
Azure Resource Groups (1)
Azure SQL (1)
Azure SQL Database Hyperscale Tier (1)
Azure SQL Database Reserved Capacity (1)
Azure SQL Studio (1)
Azure Sentinel (1)
Azure Virtual Network (1)
Azure Virtual WAN (1)
Azure performance (1)
BI Testing (1)
Backing Up (1)
Backups and Recovery (1)
Biometrics (1)
BlackRock (1)
Boot Camps (1)
Budget Alerts (1)
Calculated Measures (1)
Canvas Apps (1)
Career Development (1)
Cloud Shell (1)
Cloud-based BI (1)
Clutch (1)
Comm Data Model (1)
Consolidate Data (1)
Coronavirus (1)
DIAD (1)
DOC xPress Server (1)
DTU Pricing Model (1)
Data Bricks (1)
Data Centers (1)
Data Compliance (1)
Data Discovery and Classification (1)
Data Estate (1)
Data Masking (1)
Data Migration Assistant (1)
Data Modeling Workshop (1)
Data Replication (1)
Data Source (1)
Data Validation (1)
Data Warehouse Table (1)
Data Warehouse Testing (1)
Database Migration Assistant (1)
Database Security (1)
Databricks Community Edition (1)
Databricks Secret Scope (1)
Datazen (1)
Datometry (1)
Donald Farmer (1)
ESRI Map (1)
Elastic Database Jobs (1)
Elastic Databases (1)
Elastic Pool (1)
Elite Partner Program (1)
Energy Sustainability (1)
Enterprise Security Package (1)
Enterprise Training (1)
Entity Lists (1)
Event Triggers (1)
Express Route (1)
FTP (1)
Gartner Magic Quadrant (1)
Geo-backup Policy (1)
GitHub (1)
Giving Back (1)
Government Shutdown 2019 (1)
HBase (1)
HD Insight (1)
HDInsight IO Cache (1)
HDInsight Kafka (1)
HDInsight Storm (1)
HDSpark (1)
HR (1)
Hackathon (1)
Hierarchy Chart (1)
Hive (1)
Holidays (1)
Home Office Skills (1)
Hyperscale (1)
IAM (1)
IT (1)
Identity and Access Management (1)
Import Mode (1)
Incompatibility (1)
Incremental Refresh Policies (1)
Informatica Enterprise Data Catalog (1)
Integration Runtimes (1)
Intellectual Property (1)
IntelliJ IDEA (1)
Intelligence Features (1)
Interactive Query (1)
IoT Security (1)
IsMatch Function (1)
JSON Files (1)
Key Vault (1)
Kubernetes (1)
LUIS.ai (1)
Launch Command (1)
Lift and Shift (1)
Linked Services (1)
Linux (1)
Lookup (1)
M Query (1)
Machine Learning Services (1)
Managed Disc Migration (1)
Measures (1)
Merging Queries (1)
Microsoft 365 (1)
Microsoft Azure Sphere (1)
Microsoft Cognitive Services (1)
Microsoft Graph (1)
Microsoft Ignite 2018 (1)
Microsoft Information Protection Service (1)
Microsoft Learn (1)
Microsoft Power BI DA-100 (1)
Microsoft Power BI Quick Start Guide (1)
Microsoft Stream (1)
Microsoft Sustainability Calculator (1)
Microsoft Threat Protection Suite (1)
Microsoft Translation Services (1)
Model-driven Apps (1)
Multi-cloud (1)
Multi-factor Authentication (1)
NASDAQ (1)
Natural Language Processing (1)
New Software Release (1)
Object Detection (1)
Office 365 A1 Offer (1)
On-Demand Learning Mobile App (1)
On-Demand Training Elite Package (1)
On-Demand Training Sale (1)
Operations Management Suite (OMS) (1)
Oracle (1)
PII (1)
Paginated Reports (1)
Parallel Processing (1)
Parameter Passing (1)
Performance Analyzer (1)
Pipeline Templates (1)
PolyBase (1)
PostgreSQL (1)
Power Apps (1)
Power Apps Environments (1)
Power Apps Licensing (1)
Power Apps Search Function (1)
Power Apps Styling Tips (1)
Power BI 70-788 Exam (1)
Power BI Activity Log (1)
Power BI Administration (1)
Power BI Bookmarks (1)
Power BI Case Study (1)
Power BI Datasets (1)
Power BI Deployment Pipelines (1)
Power BI Embedded Playground (1)
Power BI Functions (1)
Power BI Licensing (1)
Power BI Report Service Adminstration (1)
Power BI Slicers (1)
Power BI Timeline (1)
Power BI User Groups (1)
Power Platform Pro Series (1)
PowerApps Collections (1)
PowerApps Portals (1)
PowerShell Training (1)
Pragmatic Works Sales Team (1)
Predictive Models (1)
Project Natick (1)
QnAMaker (1)
R Server (1)
REST API (1)
REST API Authentication (1)
Real-time Reports (1)
Report Backlog (1)
Retirement Planning (1)
SIEM (1)
SQL Agent Jobs (1)
SQL Database Query Editor (1)
SQL Profiler Trace (1)
SQL Server 2008 (1)
SQL Server 2019 (1)
SQL Server Machine Learning Services (1)
SQL Server on VMs (1)
SaaS (1)
Scala (1)
Security Information and Event Management (1)
Server Monitoring Tools (1)
Shared Access Signatures (1)
Source Code Repository (1)
Star Schema (1)
Structured Streaming (1)
Text Search Slicer (1)
Twitter (1)
TxtSync (1)
Underwater Cloud (1)
VPN (1)
Visual Studio 2019 (1)
WORM Storage (1)
Walmart (1)
Web Scraping (1)
Windows Virtual Desktop (1)
Yelp (1)
azure synapse (1)
eCommerce (1)
vCore Pricing Model (1)

see all

Stay Up-to-Date on All Things SQL Server, Business Intelligence and Cloud