Dynamic dashboard using power pivot and power query

-

 


Comments

Post a Comment

Popular posts from this blog

Global Freight Forwarders Incremental Ingestion of Logistics Data (Microsoft Fabric)

-
Image
  Company Background Global logistics provider handling high-volume shipments Requires timely data for tracking and SLAs Modernizing ingestion using Microsoft Fabric Current Situation Manual daily logistics file uploads Full data reprocessing every ingestion run Inconsistent data availability for dashboards Challenges Identified Manual uploads with no automation Full-file ingestion causing processing delays No watermark to track processed data Unreliable data freshness for operations Variable source schemas across systems Limited monitoring for failures Call to Action Design automated incremental ingestionB ingestion in Fabric Replace manual processes with reliable pipelines Objective Process only new or updated events Track progress using watermark table Load delta records into Bronze layer Update watermark after successful runs Run pipeline on fixed schedule Architecture Overview Fabric pipeline with lookup a...
Read more

Urban Apparel - Automated Ingestion for the “Summer Splash” Campaign (Microsoft Fabric)

-
Image
  Problem Manual daily CSV downloads caused analytics delays Human errors led to missing campaign insights Goal Automate daily campaign data ingestion Ensure timely, reliable analytics availability Implementation Built centralized Lakehouse in Microsoft Fabric Created pipeline using Copy Data activity Scheduled automated daily execution at 8 AM Validated schema, counts, and sample values Added retry logic and basic error handling Outcome Achieved 100% automated daily data ingestion Reduced reporting delays by one business day Improved data accuracy and consistency Enabled faster marketing decision-making
Read more