Using QGIS to build a layer for Power BI map visuals
Using QGIS to build a layer for Power BI map visuals In this session, using QGIS to build a (background) layer for Power BI map visuals, probably a Thiessen Voronoi polygon and an isochrone (distance rings). Azerbaijan data set will be used to make it more familiar for the viewers. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Paul Lucassen: Experienced Supply Chain professional with strong analytical, strategic and social skills. Experience as Project Director and General Manager Wide-ranging knowledge and experience in European Distribution, Service Logistics, Service Logistics and Supply Chain Solutions. Experienced in developing (in-night) Distribution Networks in Europe Consultancy activities focus on: Supply chain modelling applying GIS software. Greenfield analysis and Cluster analysis (www.lucassen-consulting.nl) Network analysis and restructuring Training in GIS application and Excel modelling/dashboards This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat. Contact with Paul Lucassen: LinkedIn: https://www.linkedin.com/in/paullucassen/ Members participating in Meetup Live events must be respectful in interactions with people and in content posted on the platform.Power Query in the Trenches: 3 Solutions to a Data Problem
Power Query in the Trenches: 3 Solutions to a Data Problem Data often needs to be reshaped before it can be used for analysis. And just like there are usually three or more ways to do things in Excel, there are often multiple routes to convert ugly data into the required tabular format. It’s fascinating how many different approaches you can take! In this session, Melissa de Korte will explore three different solutions that can be used to unwind a messy data set using practical problem solving with Power Query/M. Agenda: Introductions (5 mins) Presentation (55 mins) Q&A session (15 mins) About Melissa de Korte: Melissa de Korte is an all-round Power Platform enthusiast and Enterprise DNA Expert. On a mission to share what she's learned, in particular her passion for solving practical problems with Power Query/M. This event is online. You may need to install Zoom: https://zoom.us/download Space is limited so reserve your seat.Allocation and Visualization of Budgets with Seasonality | Power Query and DAX
In this session, we will look at a common budget allocation problem that involves seasonality. Seasonality has a major influence on many businesses. The ability to factor in seasonality in budgets and forecasts could help to create clear and meaningful comparisons with actuals. Allocating a high-level budget to lower levels of granularity, on the other hand, can be difficult. I'll demonstrate how to split seasonal budgets utilizing Power Query. This will allow us to compare the budget on a quarterly, monthly, and even daily basis. At the end, I'll demonstrate how to use dynamic DAX calculations for effective budget-to-actual comparisons.Dashboard in A Day with Tun'Up
Discover the world of data analysis and visualization with Microsoft Power BI as part of "Dashboard In A Day" program! This hands-on workshop by Tun'Up Munich e.V. is perfect for ages 16-25, whether you're new to data or have some experience. Workshop Highlights: - Learn Power BI fundamentals. - Master data importing, cleaning, and visualization. - Harness the power of DAX for data insights. - Explore advanced Power BI features. Plus, you'll work on a real-world project, gaining practical skills. Don't miss this opportunity! As space is limited, your confirmation of attendance will be greatly appreciated. So please kindly complete the following online registration form : https://forms.gle/rof32HoZCatkE1x26 and monitor the event’s website at https://meet-and-code.org/de/de/event-show/10177 This event is brought to you by Tun'Up Munich e.V., a non-profit organization dedicated to education in Tunisia. For more details, visit our website www.tunup.org or contact us at [email protected]. Follow us on social media: - Facebook: https://www.facebook.com/tunup.munich - Instagram: https://www.instagram.com/tunup_munich/ - LinkedIn: https://www.linkedin.com/company/tun-up/ See you there! #PowerBI #DataAnalysis #Workshop #TunUpMunich SAP, Haus des Stiftens gGmbH and the respective country partners of the TechSoup Europe network support local nonprofits across Europe to provide access to coding and digital skills for the next generation. Taking place October 6-21, the Meet and Code initiative gives children, teenagers, and young adults the chance to meet and program together, as well as to discover the thrill of coding and of the digital world as a whole. See lessPower Platform Bootcamp Argentina
Durante dos intensos días (21 y 22 de febrero, de 9 AM a 13 PM, hora Argentina) nos sumergiremos en el universo de las tecnologías de Microsoft y mucho más. Este bootcamp está diseñado para profesionales y entusiastas que desean ampliar sus conocimientos y habilidades en el ecosistema de Power Platform y otras herramientas complementarias. ¿Qué aprenderás? Microsoft Fabric y Power BI: Descubre cómo transformar datos en información valiosa para la toma de decisiones. Power Apps y Power Automate: Crea aplicaciones personalizadas y automatiza procesos para mejorar la eficiencia operativa. Power Virtual Agents y AI Builder: Implementa soluciones de inteligencia artificial y chatbots sin necesidad de programación avanzada. Dataverse y Power Platform Connectors: Integra y gestiona datos de manera centralizada para optimizar flujos de trabajo. DAX, SQL y Python: Potencia tus análisis y desarrolla soluciones robustas con estos lenguajes y herramientas clave. Azure Logic Apps, Azure Functions y Microsoft Flow: Aprende a diseñar e implementar procesos automatizados y funciones serverless. Microsoft Dynamics 365 y Power Pages: Explora cómo estas soluciones pueden transformar la gestión de relaciones con clientes y la presencia digital.
Detect if a customer is present last week
Hello, I am working on a Power BI project to identify customers who fix their leaks. I receive a weekly file that I upload to SharePoint. I then use Power Query to compile the data and create a table listing customers with leaks for each week. I am trying to create a calculated column or DAX formula (or a column) to check, for each customer and week, whether they had a leak in the previous week (S-1) and the current week (S) in a visualization table. It's important to note that only customers with leaks are present in the file each week. I've been trying to solve this problem, but I'm struggling to find a solution. If anyone has encountered a similar issue, I'm open to suggestions. client id start & end date of the week leak column i've also uploaded a calendar table ! 😞
AddIn Link to Excel Workbook from D365 F&O
Hello, I hope someone can help. The link in the Excel Workbook keeps breaking (asking to be re-entered)? It seems to me that when it is opened directly to desktop app, it is fine (so i revert to the last version) but when it is opened in excel online the Addin for D365 needs to be re-entered and then the functionality for the refresh/publish etc goes: Sometimes this message comes up: or this:
Server refresh gives Table not found error but fine in desktop
I'm trying to set up my scheduled refresh for my PowerBI report - the connection is an ODBC on import, I have the required drivers and get a green check when I test the connection, however when I refresh I get the following error: SessionID: b5ba2f83-45cb-4fab-8a0e-8a79b6cdbf0c [0] -1055784932: DataSource.Error: ODBC: ERROR [42S02] [Cache ODBC][State : S0002][Native Code 30] [D:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\MDataEngine\Mi] [SQLCODE: <-30>:<Table or view not found>] [Location: <Prepare>] [%msg: < Table 'DBO.DSKILLSETSTAT' not found>]. DataSourceKind = Odbc. DataSourcePath = dsn=MYDSNLOCATION. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). . The exception was raised by the IDbCommand interface. [1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [2] -1055129594: The current operation was cancelled because another operation in the transaction failed. [3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. [4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface. My refresh works just fine in PowerBI desktop, no issues with queries on any tables, it's clearly connecting to the source ok, I'm not sure what I'm missing. I can refresh and save the updated file in desktop and the report data refreshes on server. I'm not sure how or why it can't find the table any more. Here's a snip of the connection structure if I'm creating a new source - the table being queried is called dSkillsetStat in the dbo folder
