Series- Event 2: Data Preparation with Power Query
Objective: Enable participants to clean and transform raw data for reporting. Agenda: Connecting to various data sources. Data cleaning techniques (filtering, replacing values, handling nulls). Combining datasets with merges and appends. Format: Interactive session with exercises. Takeaway: Skills to prepare and transform datasets for analysis.Unleashing the Power of DAX Queries in Power BI | Zoe Douglas
Join us for an insightful session on how to harness the power of Power BI to drive sales success through strategic data analysis. In this interactive webinar, we’ll explore essential techniques for transforming financial data into actionable insights, focusing on Power BI’s capabilities for data import, transformation, and report creation. Zoe Douglas, Principal Program Manager at Microsoft, will share how to “take the gloves off” and access the full analytics power of DAX with DAX queries—demystifying the process and showing just how easy it can be to get started with real-world examples you can apply to your own data. Whether you're new to Power BI or looking to deepen your analytical skills, this session is designed to empower you with practical strategies for turning raw data into compelling stories.Replacing your ADF Pipelines with Notebooks in Fabric by Bob Duffy
We migrated to Fabric and replaced almost all our ADF Pipelines with notebooks and haven’t looked back. Should you do the same? This session is a look at how and why you can move from a Pipeline centric ETL architecture to a notebook centric ETL for data warehousing. We compare performance, extensibility, developer experience and supportability between the two tools to see which comes out on top. TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time): 7:45am Teams Meeting opens 8:00am-8:05 am Welcome 8:05am-9:05am Feature Presentation 9:05am-9:10am Wrap-up REGISTRATION: This meet-up will be hosted on Microsoft Teams and will be recorded for those who cannot attend live. To access the Teams Meeting link, you must RSVP for the event. JOINING THE EVENT: Attendees can join the Teams Meeting starting at 7:45 am PST on the day of the event. The link will be visible only if you RSVP beforehand. The event will begin at 8:00 am PST. Please ensure you are on mute to minimize background noise and distractions. During the presentation, type your questions and comments into the chat area, which will be monitored by the event hosts. There will be a Q&A session at the end, where you can unmute your mic and share your video to ask questions.Day2: Ingest and Transform Data (Arabic)
Continue your Fabric journey with Day 2 of our Fabric Data Engineer Associate (DP-700) study series — hosted by the Sudan Microsoft Fabric Study Group, under Fabric Data Days and supported by the global Microsoft Fabric community. This session dives into one of the most essential DP-700 skills: data ingestion and transformation. Learn how to efficiently design, load, and transform data in Microsoft Fabric using both batch and streaming techniques. Topics: • Ingest and transform batch data • Ingest and transform streaming data • Design and implement loading patterns Date: 16th November 2025 Time: 7:00 PM (Sudan) | 8:00 PM (Saudi Arabia) | 12:00 PM (CST) Speakers: Arwa Aldoud Esraa kamal Abdallah Host: Aala Omer Taha Fabric Data Days | Sudan Microsoft Fabric Study Group Empowering our community to learn, share, and get certified together — as part of the global Microsoft Fabric initiative. Join us: - User Group - LinkedIn - Join us on WhatsApp
Converting Data Per Minute to Hourly in Power BI
I need help with data transformation in Power BI. The data I have is stored in the data source with a minute-level granularity, but I want to display the data in the report on an hourly basis. How can I perform this transformation using Power Query Editor to show the data in hourly intervals with the appropriate aggregation (e.g., average)? Thank you for your assistance!
