Gestión Logística: Control de Pedidos en Data Studio + IA

This video is designed to show you a practical and simple way to create a dashboard in Data Studio (Looker Studio). This dashboard will allow you to efficiently manage the flow of products to customers, and with the help of Gemini, we'll learn to use special functions such as CASE. What will you learn to measure?: Average Orders Average Delivery Time Rejection Rate Number of Products Ordered Products Received Products Returned Products Pending Dashboard Features: Interactive filters by Supplier, Quarter (Semester), and Order Status Dynamic bar and line charts to identify trends and compare variations. Color Chart for the Top 6 Products and for Supplier Performance. A creative, fully interactive, and easy-to-use Power BI dashboard. 🎞️Chapters 00:00 Introduction 01:52 Databases 02:37 Making a Copy of the File (THE MOST IMPORTANT PART) 03:13 Connecting to the Data Source 03:33 Creating the Dashboard Background and Inserting the General Title 06:14 Metrics 1 - Average Orders, Rejection Rate, and 15:12 Metrics 2 - Ordered, Received, Pending, and Returned Products 19:52 Doughnut Chart - % of Order Status 21:23 Line Chart - Purchase Trend 24:07 Bar Chart - Spending by Supplier 26:46 Table 1 - Top 6 Most Ordered Products 29:27 Table 2 - Supplier Performance 31:11 Slicers 📌VERY IMPORTANT - to have the file you have to make a Copy of the same file. 📥 Download the free worksheet here: https://docs.google.com/spreadsheets/... 🔔 Don't forget to subscribe for more data analysis tools. Song: Sail On Stranger Author: Dan Lebowitz, Tone Seeker