Marathon Consulting’s Post

w00t! I cover using the On-premises data gateway in a demo of hybrid data engineering in my Day of Fabric Data Factory training (shameless plug: next delivery is 29 Oct 2024)! :{>

5 Tips to master dataflows in Power Platform If you need to sync external data or migrate data into Dataverse, using a dataflow can help. It can sometimes be overlooked, but my latest blog aims to provide some practical advise in using them in your next project. https://lnkd.in/en4pcFDJ #PowerApps #PowerPlatform #PowerQuery #Dataverse #SharingIsCaring #PowerAddicts #PowerConnects

💡Power Query Mind Map⚡ 𝗪𝗵𝗮𝘁 𝗶𝘀 𝗶𝘁? 🔍 Power Query isn't just a tool, it's your Army for data tasks. ➡️ ETL (Extract, Transform, Load): Extract data from various sources, transform it to meet your needs, and load it into your preferred destination. ➡️ Data Cleaning: Effortlessly clean and prepare your data for analysis or reporting. ➡️ Data Connector: Connect to diverse data sources and integrate them. ➡️ Data Generator: Generate synthetic data for testing or analysis purposes. 💻 𝗨𝘀𝗲𝗿 𝗜𝗻𝘁𝗲𝗿𝗳𝗮𝗰𝗲 Power Query's user interface is designed for efficiency. ➡️ Ribbon: Navigate through tabs like Home, Transform, Add Column, and View for easy access to functionalities. ➡️ Queries Pane: Organize and manage all your queries in one place for streamlined workflow. ➡️ Steps: Track and manage applied actions to your data. ➡️ Publish: Instantly publish your transformed data to Excel or Power BI as polished tables for presentation. 💾 𝗗𝗮𝘁𝗮 𝗦𝗼𝘂𝗿𝗰𝗲𝘀 Power Query empowers you to connect to a wide range of data sources. ➡️ Traditional Files: Excel, CSV, Text, and even PDF files. ➡️ Web Data: Extract data directly from websites for analysis. ➡️ Structured Formats: Handle data in JSON, XML formats with ease. ➡️ Databases: Connect to databases seamlessly for real-time data processing. ➡️ Cloud Sources: Access data from cloud platforms for enhanced scalability. ➡️ Sharepoint: Integrate data from Sharepoint effortlessly into your workflows. 💡 𝗧𝗵𝗶𝗻𝗴𝘀 𝘁𝗼 𝗞𝗻𝗼𝘄 ➡️ It uses M language. ➡️ Dependency: Each step in Power Query builds upon the previous one, ensuring data integrity. ➡️ Case Sensitivity: Pay attention to case sensitivity in Power Query operations for accurate results. 🙌 Inspired from Chandoo.org, heartfelt thank you for the invaluable guidance provided through YT. #powerquery #excel #powerbi #data #dataanalysis #mindmap

Power Query Journey: Step 1️⃣: Get acquainted with Power Query and create your first automation with it. Step 2️⃣: Explore the tools and features available in the user interface and initiate a wave of time-saving solutions at your work. Step 3️⃣: "Oooops! Where's the button for that? How come Power Query does not have it??" - Time to get serious about learning M Language and become the office's Power Query Magic Wizard! Jump into step 3 with the help of Melissa de Korte in this free session about Custom Functions in Power Query. After you get the hang of it, your life will never be the same (hint: it will be so much better. 😁) Register here to attend live or receive the video recording 👇 https://lnkd.in/gKc-MjbP #msexceltoronto #excel #powerquery #powerbi #businessintellignce

The author’s primary objective is to develop a custom function in Power Query. Read more 👉 https://lttr.ai/AP3Xm #ChangingDataTypes #PowerfulData #CustomFunction #PowerQuery #AchievingDesiredResults #ReducingDuplicativeEfforts #AuthorSPrimaryObjective #PowerfulDataTransformation #SingleReusableFunction #CreateCustomFunctions

[40] Google Sheets tops our list of most-used Destinations, followed closely by Postgres and SharePoint (Excel). When we started Nekt, we didn’t expect sheets to grab so much attention, but after speaking with countless companies this year, it makes perfect sense. What’s the use of a data platform if you can’t easily get data into everyone’s hands? Our Google Sheets Destination solves that by taking a dataframe and delivering it straight to a specified sheet based on a trigger—Scheduled, Event-based, or Manual. This allows you to consolidate data and send it to the right team in a familiar format, where they can take immediate action. In today's video, I’ll walk you through setting up a Google Sheets Destination to send data from a consolidated table. The most common workflow looks like this: 1️⃣ Extract data from multiple sources (Sources) 2️⃣ Consolidate it into a new table (SQL or Spark Transformation) 3️⃣ Schedule the Destination to send the data every day at X hour (Destination) That way, everyone pulls from the same source without anyone having to run early-morning queries, export tables, or email spreadsheets around. It’s all automated. If someone at your company is spending most of their time running SQL queries and sending data around, you might be underutilizing their potential. Automate that process with a few clicks, and let your team focus on what really moves the needle. This is post #40 in a series I’m writing while building a startup. Catch up on posts 1-39 by checking the hashtag #nektjourney. On to the #nekt one! 🎯

Hi Power BI Community, Ever faced data mismatch after a scheduled refresh in Power BI Service and wished you had a backup for troubleshooting? Check out my latest blog post on automating Power BI report backups before scheduled refreshes. This solution will help you streamline your workflow and maintain access to pre-refresh versions of your reports, making troubleshooting easier and ensuring data integrity. Read more on Medium: https://lnkd.in/eEWEScFe GainInsights Microsoft Guy in a Cube Maven Analytics Onyx Data RADACAD Enterprise DNA #Microsoft #PowerBI #BusinessIntelligence #DataAnalytics #Azure #PowerShell #Dashboard

Super excited to finally share my first post for the Microsoft Power Platform Community! 🎉 The first topic was related to Power Automate. I decided to showcase how Openiyi Tosin and I solved a problem. This article will show how one can modify the M-code in Power Query to fetch just weekday date and show the previous day data as well. 👨🏽🎓 Big thanks to the Community & Content Manager, Duane Montague 🙏 Read all about it here: https://lnkd.in/dMg2F2CK

The March #PowerBI blog post is out! A lot of new features are introduced. 1. Reporting a. Visual calculations update b. On-Object Interaction Updates c. Mobile layout auto-create d. Expanding Spatial Data Integration: Shapefile Support in Azure Maps Visual e. Data bars in matrix subtotal/total conditional formatting f. Data labels alignment 2. Modeling a. Write DAX queries in DAX query view with Copilot b. Enhanced row-level security editor is Enabled by Default c. Selection expressions for calculation groups d. DAX query view improvements 3. Service a. Edit your data model in the Power BI Service – Updates b. Undo/Redo, Clear all, and New filter cards in Explore c. Deliver report subscriptions to OneDrive SharePoint 4. Mobile a. Custom visual SSO support 5. Developers a. New title flyout for Power BI Desktop developer mode b. Rename to “Semantic Model” in Power BI Project files c. System file updates for Git integration d. Hierarchal Identity filter API 6. Visualizations a. New visuals in AppSource b. Dumbbell Bar Chart by Nova Silva c. Date Picker by Powerviz d. Drill Down Combo PRO e. PDF Uploader/Viewer f. Inforiver Premium Matrix 7. Paginated Reports a. Connect to new data sources from Power BI Report Builder b. Localized parameter prompts in Power BI Report Builder #powerbi #dp600 #fabric #march2024 #bi https://lnkd.in/gz7eD3Td

Power BI is not only for visualization/dashboard!!! Learn more on: 👉Power Query: To clean, transform, wrangle your data etc. 👉Data Source connections: Learn to connect to other sources (SQL, sharepoint, web etc) apart from Excel/csv and also changing/integrating new sources Data modelling practice: Learn Fact & Dimension Table, creating relationship, cardinality to ensure your model is standing on solid foundation. DAX: CT, CC, Measure, RLS to enhance your visual/dashboards Other Elements: Drillthrough, Bookmarks, Slicers etc for interactivity and easy navigation. Let's start with source connection: The Excel file you want to load straight to Power BI, do it like this instead: 1. SQL: 👉Load the Excel file to the SQL flavor on your system. 👉Connect your Power BI to SQL to access the same data. Same Excel, same data, but different connection. Watch this: https://lnkd.in/ekWfYDuC by Olanrewaju Oyinbooke 2. Sharepoint: Through your Microsoft account, you have a sharepoint. 👉Load the Excel file into sharepoint 👉connect your Power BI to sharepoint. Same Excel, same data, different connection With sharepoint you have 2 options: a. Connect to sharepoint directly b. Generate a web link from sharepoint and connect as web(Get data 👉Web 👉paste link and connect) Watch this: https://lnkd.in/eUmDiyhc You don't have to wait until you get a job to improve or upskill on your basic skill. Using these other mtds, you have demonstarted: 1. versatility in Data source integartion and ETL 2. intermediate Power BI source connection skill 3. you understand robust analytics framework Talking about these skills and demonstrating them in interviews can also give you an edge. Cheers 🥂🥂 Happy Reading Please like, comment, share and connect for more data related content