KPMG Data Intelligence Solutions

📢 Exciting News! We are proud to announce that the KPMG Data Intelligence Solutions is part of the INDICATE EU project which aims to create the secure environment supporting 𝐝𝐚𝐭𝐚 𝐞𝐱𝐜𝐡𝐚𝐧𝐠𝐞 𝐚𝐧𝐝 𝐚𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐚𝐜𝐫𝐨𝐬𝐬 𝐄𝐔 𝐡𝐞𝐚𝐥𝐭𝐡𝐜𝐚𝐫𝐞 𝐢𝐧𝐬𝐭𝐢𝐭𝐮𝐭𝐢𝐨𝐧𝐬. Together, we can achieve a higher level of health protection by combining the knowledge and experience of medical, legal, and IT professionals 𝐚𝐜𝐫𝐨𝐬𝐬 𝐄𝐔 𝐜𝐨𝐮𝐧𝐭𝐫𝐢𝐞𝐬. Motivated by the project's goals, we are developing a cutting-edge architecture that enables 𝐅𝐞𝐝𝐞𝐫𝐚𝐭𝐞𝐝 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐬𝐢𝐬 and 𝐅𝐞𝐝𝐞𝐫𝐚𝐭𝐞𝐝 𝐌𝐚𝐜𝐡𝐢𝐧𝐞 𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 to advance patient-centered care and implementation of trustworthy AI models.   📨 If you would like to start or enhance your data analytics journey, please do not hesitate to contact our experts! Michał Walanus Urszula Glesner   #FederatedDataAnalysis #FederatedMachineLearning #DataPrivacy #Security #Databricks #Microsoft

Microsoft #PowerBI has become a top platform for visualizing and analyzing data. The recent addition of Copilot, an AI-powered feature, has greatly advanced its data analysis capabilities. It acts as an intelligent assistant, using natural language processing and machine learning to help users create reports, generate insights, and explore their data. 📊   What are the key functionalities Copilot offers within Power BI? 🔹 𝐑𝐞𝐩𝐨𝐫𝐭 𝐩𝐚𝐠𝐞 𝐬𝐮𝐦𝐦𝐚𝐫𝐲 - automatically generates insights from data, identifying key trends and anomalies, and suggesting potential areas of interest for further exploration. 🔹 𝐒𝐦𝐚𝐫𝐭 𝐍𝐚𝐫𝐫𝐚𝐭𝐢𝐯𝐞 𝐕𝐢𝐬𝐮𝐚𝐥𝐢𝐳𝐚𝐭𝐢𝐨𝐧 - enhances data storytelling by translating complex data points and visual trends into easy-to-understand language. 🔹 𝐂𝐫𝐞𝐚𝐭𝐢𝐧𝐠 𝐚 𝐫𝐞𝐩𝐨𝐫𝐭 𝐩𝐚𝐠𝐞 – suggests visualizations and provide recommendations for optimizing report layouts and interactivity. This functionality makes it easier for users to create insightful, dynamic reports quickly, ensuring data is presented clearly and effectively (pages cannot be edited afterwards). 🔹 𝐃𝐀𝐗 𝐐𝐮𝐢𝐜𝐤 𝐌𝐞𝐚𝐬𝐮𝐫𝐞𝐬 - simplifies the creation of common calculations without requiring extensive knowledge of Data Analysis Expressions (#DAX). These pre-defined measures allow users to quickly generate calculations like averages, percentage changes by selecting from a list of standard options (it can mostly create very simple measures that will be used without additional context). 🔹 𝐀𝐮𝐭𝐨𝐦𝐚𝐭𝐢𝐜𝐚𝐥𝐥𝐲 𝐠𝐞𝐧𝐞𝐫𝐚𝐭𝐞𝐝 𝐦𝐞𝐚𝐬𝐮𝐫𝐞 𝐝𝐞𝐬𝐜𝐫𝐢𝐩𝐭𝐢𝐨𝐧𝐬 - provides clear explanations of each measure's calculations, detailing the purpose and logic used. This improves understanding and collaboration by making it easier for users to interpret and use the measures in reports and dashboards 🔹 𝐃𝐀𝐗 𝐪𝐮𝐞𝐫𝐲 - analyzes your uploaded dataset to recommend suitable function. Additionally, if you're unsure about a function's purpose, you can paste it into Copilot for a detailed explanation.   💡 𝐂𝐨𝐩𝐢𝐥𝐨𝐭 𝐟𝐨𝐫 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐢𝐬 𝐮𝐧𝐝𝐨𝐮𝐛𝐭𝐞𝐝𝐥𝐲 𝐚 𝐠𝐚𝐦𝐞-𝐜𝐡𝐚𝐧𝐠𝐢𝐧𝐠 𝐚𝐝𝐝𝐢𝐭𝐢𝐨𝐧 𝐭𝐡𝐚𝐭 𝐢𝐦𝐩𝐫𝐨𝐯𝐞𝐬 𝐭𝐡𝐞 𝐮𝐬𝐞𝐫 𝐞𝐱𝐩𝐞𝐫𝐢𝐞𝐧𝐜𝐞 𝐚𝐧𝐝 𝐭𝐫𝐚𝐧𝐬𝐟𝐨𝐫𝐦𝐬 𝐡𝐨𝐰 𝐮𝐬𝐞𝐫𝐬 𝐞𝐧𝐠𝐚𝐠𝐞 𝐰𝐢𝐭𝐡 𝐝𝐚𝐭𝐚. Copilot speeds up report creation, encourages exploration, and supports data-driven decision-making with its natural language interface, contextual suggestions, and AI assistance.   At this stage, the functionalities described above still have bugs that may lead to some doubts about whether to fully trust Copilot’s suggestions, but Microsoft is constantly developing its #AI tools, so we are sure #Copilot will reach its full potential soon. 📨 If you have any questions or would like to know more details on how to take advantage of Copilot in Power BI, contact our experts! Radoslaw Kowalski Michał Walanus

The procurement process plays a critical role for many of our clients whose businesses are based on #manufacturing. They need to ensure the seamless acquisition of necessary components and services to produce the final products they distribute in the market.   We support them by delivering advanced #BI analytics that help to resolve process bottlenecks and overcome operational challenges. Comprehensive reports assist them in establishing a smooth, predictable flow and discovering cost efficiencies.   Below, we unveil the top 3 challenges our clients face: 🔹 𝐌𝐚𝐯𝐞𝐫𝐢𝐜𝐤 𝐬𝐩𝐞𝐧𝐝𝐢𝐧𝐠 – These are the expenses that deviate from established procedures, often resulting from time-consuming, inefficient processes and poorly designed acceptance workflows. Detailed spending analysis is pivotal to determine the main drivers of maverick spending. 🔹 𝐈𝐧𝐚𝐝𝐞𝐪𝐮𝐚𝐭𝐞 𝐯𝐞𝐧𝐝𝐨𝐫 𝐦𝐚𝐧𝐚𝐠𝐞𝐦𝐞𝐧𝐭 – The lack of regular vendor performance evaluation results in hurdles when trying to optimize and consolidate vendors. Identifying high-performers could potentially unlock opportunities for discounts. 🔹 𝐏𝐫𝐢𝐜𝐞 𝐢𝐧𝐬𝐭𝐚𝐛𝐢𝐥𝐢𝐭𝐲 – Uncertainty regarding price fluctuations can significantly impact a company’s budgeting and overall financial performance. This instability may result in squeezed profit margins and difficulties in maintaining competitive pricing for end products. It's critical to monitor price changes and notify procurement managers when price variations exceed certain thresholds.   𝐀𝐧 𝐞𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭 𝐩𝐫𝐨𝐜𝐮𝐫𝐞𝐦𝐞𝐧𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐢𝐬𝐧'𝐭 𝐣𝐮𝐬𝐭 𝐚𝐛𝐨𝐮𝐭 𝐬𝐚𝐯𝐢𝐧𝐠 𝐦𝐨𝐧𝐞𝐲; 𝐢𝐭'𝐬 𝐚𝐛𝐨𝐮𝐭 𝐦𝐚𝐤𝐢𝐧𝐠 𝐬𝐦𝐚𝐫𝐭𝐞𝐫, 𝐝𝐚𝐭𝐚-𝐝𝐫𝐢𝐯𝐞𝐧 𝐜𝐡𝐨𝐢𝐜𝐞𝐬 𝐭𝐡𝐚𝐭 𝐫𝐞𝐬𝐮𝐥𝐭 𝐢𝐧 𝐩𝐨𝐬𝐢𝐭𝐢𝐯𝐞 𝐨𝐮𝐭𝐜𝐨𝐦𝐞𝐬 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐨𝐫𝐠𝐚𝐧𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐚𝐬 𝐚 𝐰𝐡𝐨𝐥𝐞. Don't worry if you encounter hurdles in the procurement process – even the most well-oiled machines can face obstacles. 😊 We're here to help. Don’t hesitate to contact us - let's work together to streamline the process and enhance your productivity! 📩   #Procurement #BusinessOptimization #SupplyChainManagament

🔉 We are thrilled to share that our team had the privilege to participate in the 9th edition of the Analytics Forum organized by Żabka Polska and deliver a lecture on the latest updates in Power BI!   Our session titled “What's new in Power BI – a guide to key updates for analysts” covered: 🔹 𝐕𝐢𝐬𝐮𝐚𝐥 𝐂𝐚𝐥𝐜𝐮𝐥𝐚𝐭𝐢𝐨𝐧𝐬: the tool enabling dynamic calculations directly in visualizations, 🔹 𝐃𝐀𝐗 𝐐𝐮𝐞𝐫𝐲 𝐕𝐢𝐞𝐰: enhancements in DAX query interface, 🔹 𝐍𝐞𝐰 𝐯𝐢𝐬𝐮𝐚𝐥 𝐟𝐞𝐚𝐭𝐮𝐫𝐞𝐬: including new chart types, slicers and advanced customization options for line and bar charts.   A big thank you to the organizers for the invitation Karim Sylla Daniel Korzeniowski, to our experts Michał Walanus and Mateusz Lamch for leading the session and to everyone who attended! 🤝   #ForumAnalityków #PowerBI #DataAnalytics #BI

Incorporating UX/UI (User Experience/User Interface) best practices when creating reporting solutions is crucial in delivering valuable insights in a user-friendly manner. By understanding audience, prioritizing information hierarchy, maintaining simplicity and consistency, implementing intuitive navigation, visualizing data effectively and conducting user testing, you can prepare reports and dashboards that not only show the data but also provide a positive and engaging user experience. 📊   There are multiple options that could enhance user experience, but our main focus should be on implementing the following rules:   🔹 𝐀𝐝𝐣𝐮𝐬𝐭 𝐭𝐡𝐞 𝐫𝐞𝐩𝐨𝐫𝐭 𝐭𝐨 𝐭𝐡𝐞 𝐭𝐚𝐫𝐠𝐞𝐭 𝐚𝐮𝐝𝐢𝐞𝐧𝐜𝐞 𝐚𝐧𝐝 𝐦𝐚𝐤𝐞 𝐢𝐭 𝐢𝐧𝐭𝐮𝐢𝐭𝐢𝐯𝐞 Consider your audience's perspective when designing your layout. Place vital information in the upper left corner for easy access, such as high-level data and key performance indicators (KPIs). Progress horizontally and vertically to unveil more detailed insights gradually. Tailor the level of detail to suit different user types; keep summaries concise for those needing a general overview, while offering expansive options for analytical teams to delve into data at various depths.   🔹 𝐌𝐚𝐤𝐞 𝐢𝐭 𝐬𝐢𝐦𝐩𝐥𝐞 𝐚𝐧𝐝 𝐜𝐨𝐧𝐬𝐢𝐬𝐭𝐞𝐧𝐭 Simplicity is key in UX/UI design. Avoid unnecessary elements that may distract or overwhelm users. Maintain a consistent design while using fonts, colors, icons, navigation, filtering and other elements throughout the report. It would ensure readability of the report and is very useful while creating several pages in one report, or a series of reports that could be consumed in similar way.   🔹 𝐔𝐬𝐞 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐯𝐢𝐬𝐮𝐚𝐥𝐬 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐝𝐚𝐭𝐚 𝐬𝐭𝐨𝐫𝐲𝐭𝐞𝐥𝐥𝐢𝐧𝐠 Ensure visualizations serve a purpose and match the data type. They should clearly convey the story, using appropriate charts, graphs, and infographics. Pay attention to details like titles, labels, legends, and customization for added clarity and information.   🔹 𝐔𝐬𝐞 𝐚𝐩𝐩𝐫𝐨𝐩𝐫𝐢𝐚𝐭𝐞 𝐜𝐨𝐥𝐨𝐫𝐬 Color choice is crucial in report design, impacting aesthetics, brand identity, and data clarity. Use colors judiciously to highlight key information and avoid distractions. Align color themes with the company's brand book or website when collaborating with clients, enhancing cohesion and visual consistency.   🔹 𝐔𝐬𝐞 𝐚𝐧 𝐞𝐱𝐭𝐞𝐫𝐧𝐚𝐥 𝐚𝐩𝐩 𝐭𝐨 𝐜𝐫𝐞𝐚𝐭𝐞 𝐥𝐚𝐲𝐨𝐮𝐭 Using external layout applications offers flexibility by creating backgrounds, allowing incorporation of multiple elements without rendering them directly on report page. Tools like Adobe XD or Figma provide enhanced layout capabilities beyond Power BI visuals, facilitating outstanding design preparation.   🔎 Do you always follow these fundamental rules when creating reports, or do have another approach to enhance the user experience of solutions?   #BusinessIntelligence #PowerBI #Datavisualization

Ready to embark on the journey of creating a powerful #PowerBI report? 📊 Let's unravel some crucial stages that define our commitment in delivering seamless and impactful reporting experiences:   📝 𝐑𝐞𝐪𝐮𝐢𝐫𝐞𝐦𝐞𝐧𝐭𝐬 𝐠𝐚𝐭𝐡𝐞𝐫𝐢𝐧𝐠: Before diving into data visualization, we carefully understand your business needs. Our team engage with stakeholders, conducts in-depth requirements gathering, and defines the goals of your Power BI report. This stage lays the foundation for a report that aligns perfectly with your organization's goals.   🎨 𝐃𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐦𝐨𝐜𝐤𝐮𝐩𝐬: Visualize the future! Our business analysts and UI/UX experts bring requirements to life through detailed mockups. They create mockups that bring the requirements to life. By designing the layout, choosing the right visuals, and ensuring a user-friendly interface, mockups serve as a visual blueprint. Early stakeholder feedback ensures perfect alignment with expectations, setting the stage for excellence.   🛠️ 𝐑𝐞𝐚𝐥𝐢𝐳𝐢𝐧𝐠 𝐫𝐞𝐩𝐨𝐫𝐭𝐬: At the heart of the process is the use the Power BI desktop to turn your mockups into a working report. Using technical expertise and creativity, we connect to data sources, transform raw data into actionable insights and design compelling visuals. The result is a report that tells a compelling data story.   🌐 𝐏𝐮𝐛𝐥𝐢𝐬𝐡𝐢𝐧𝐠 𝐟𝐨𝐫 𝐓𝐞𝐬𝐭𝐢𝐧𝐠: It's time to share! We publish the report to the Power BI service so stakeholders can interact with the report in a live environment. This collaborative testing phase facilitates valuable feedback and enables the necessary adjustments to meet the expectations of both creators and end-users.   🚀 𝐄𝐧𝐭𝐞𝐫𝐢𝐧𝐠 𝐭𝐡𝐞 𝐏𝐫𝐨𝐝𝐮𝐜𝐭𝐢𝐨𝐧 𝐏𝐡𝐚𝐬𝐞: The grand finale! As your report moves from testing to production, eligible team publish it for wider distribution, ensuring it is accessible to all intended users. By implementing scheduled refreshes to keep the data up-to-date, establishing role-based access and monitoring performance, the production phase marks the culmination of effort – turning data into actionable insights for your entire organization.   𝐈𝐧 𝐭𝐡𝐞 𝐝𝐲𝐧𝐚𝐦𝐢𝐜 𝐥𝐚𝐧𝐝𝐬𝐜𝐚𝐩𝐞 𝐨𝐟 #dataanalytics, 𝐦𝐚𝐬𝐭𝐞𝐫𝐢𝐧𝐠 𝐞𝐚𝐜𝐡 𝐬𝐭𝐚𝐠𝐞 𝐨𝐟 𝐭𝐡𝐞 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐫𝐞𝐩𝐨𝐫𝐭 𝐣𝐨𝐮𝐫𝐧𝐞𝐲 𝐢𝐬 𝐜𝐫𝐢𝐭𝐢𝐜𝐚𝐥 𝐟𝐨𝐫 𝐝𝐞𝐥𝐢𝐯𝐞𝐫𝐢𝐧𝐠 𝐢𝐦𝐩𝐚𝐜𝐭𝐟𝐮𝐥 𝐢𝐧𝐬𝐢𝐠𝐡𝐭𝐬. Join us as we embrace collaboration, iterate with feedback, and watch your data-driven narrative unfold!   #BusinessIntelligence #DataVisualization

In the ever-changing world of #dataanalysis, the ability to dive deep into the nuances of information is crucial. #PowerBI has two important features—𝐝𝐫𝐢𝐥𝐥𝐝𝐨𝐰𝐧 and 𝐝𝐫𝐢𝐥𝐥𝐭𝐡𝐫𝐨𝐮𝐠𝐡 - that take your experience from static reporting to dynamic, interactive exploration. 🔎📊 🔹 𝐃𝐫𝐢𝐥𝐥𝐝𝐨𝐰𝐧: 𝐍𝐚𝐯𝐢𝐠𝐚𝐭𝐢𝐧𝐠 𝐋𝐚𝐲𝐞𝐫𝐬 𝐨𝐟 𝐈𝐧𝐬𝐢𝐠𝐡𝐭 Drilldowns involve navigating from a summarized view to a more detailed one within the same visual and enable users to peel back layers of data with a click. By implementing drilldowns, users can seamlessly transition, for example, to quarterly, monthly, and even daily views, adapting the level of granularity to suit their analytical needs. This feature not only enhances the user experience but also allows them to uncover insights at their own pace. 🔹 𝐃𝐫𝐢𝐥𝐥𝐭𝐡𝐫𝐨𝐮𝐠𝐡: 𝐓𝐚𝐢𝐥𝐨𝐫𝐢𝐧𝐠 𝐭𝐡𝐞 𝐃𝐚𝐭𝐚 𝐉𝐨𝐮𝐫𝐧𝐞𝐲 Drillthroughs allow users to navigate from a specific data point to a different page or report containing more detailed information relevant to that point. Imagine a regional sales map—clicking on a specific region triggers a drillthrough that opens a detailed report showcasing sales performance, customer demographics, and product preferences for that particular region. This level of customization tailors the data journey for users, providing them with precisely the information they seek. Interactivity empowers users to become active participants in the exploration process. Users can customize reports to suit their specific analytical needs. With the ability to drill down into specific details or drill through to related reports, users gain deeper insights into the details, which helps them understand the data more deeply and make informed decisions. 📨 If you would like to 𝐞𝐥𝐞𝐯𝐚𝐭𝐞 𝐲𝐨𝐮𝐫 #datastorytelling 𝐚𝐧𝐝 𝐞𝐦𝐩𝐨𝐰𝐞𝐫 𝐲𝐨𝐮𝐫 𝐚𝐮𝐝𝐢𝐞𝐧𝐜𝐞 𝐭𝐨 𝐛𝐞𝐜𝐨𝐦𝐞 𝐭𝐫𝐮𝐞 𝐝𝐚𝐭𝐚 𝐞𝐱𝐩𝐥𝐨𝐫𝐞𝐫𝐬 do not hesitate to contact us!

📢 𝐈𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐚𝐧𝐧𝐨𝐮𝐧𝐜𝐞𝐦𝐞𝐧𝐭 𝐭𝐨 𝐚𝐥𝐥 𝐏𝐨𝐰𝐞𝐫 𝐁𝐈 𝐏𝐫𝐞𝐦𝐢𝐮𝐦 𝐮𝐬𝐞𝐫𝐬! The transition to Microsoft Fabric, coupled with the decommissioning of Power BI Premium per capacity SKUs is on the horizon!   🗓️ 𝐊𝐞𝐲 𝐝𝐚𝐭𝐞𝐬: •      1 July 2024 – New customers won't be able to purchase Power BI Premium per capacity after the indicated date. •      1 January 2025 - Existing customers without an Enterprise Agreement (EA) can renew until the indicated date. Existing EA clients can renew until the end of their agreement. 💎 𝐖𝐡𝐚𝐭 𝐚𝐫𝐞 𝐭𝐡𝐞 𝐛𝐞𝐧𝐞𝐟𝐢𝐭𝐬? The shift to Microsoft Fabric brings additional flexibility with pay-as-you-go options, access to exclusive Azure features and smaller compute SKUs.   📩 If you have any questions or doubts how the change impacts your environment, do not hesitate to reach out to us! 𝐎𝐮𝐫 𝐓𝐞𝐚𝐦 𝐢𝐬 𝐫𝐞𝐚𝐝𝐲 𝐭𝐨 𝐬𝐮𝐩𝐩𝐨𝐫𝐭 𝐲𝐨𝐮 𝐢𝐧 𝐭𝐡𝐞 𝐭𝐫𝐚𝐧𝐬𝐢𝐭𝐢𝐨𝐧 𝐭𝐨 𝐮𝐧𝐥𝐨𝐜𝐤 𝐚𝐝𝐝𝐢𝐭𝐢𝐨𝐧𝐚𝐥 𝐛𝐞𝐧𝐞𝐟𝐢𝐭𝐬! Do not hesitate to contact our expert Michał Walanus