talk-data.com

The final PBIMCR of 2023 is taking place at Bruntwood Sci-Tech office Address: Circle Square. 103, Oxford House, Oxford Rd, Manchester M1 7ED. (next door to Tesco Express and Hatch (food court) Date: Thursday 30th of November 2023 Time: 5:45pm for 6pm start Complimentary Pizza & Drinks provided by our sponsors Robert Walters

The Very Group: External Sharing and Data Labs The Very Group BI Team implemented Power BI as their enterprise reporting tool in 2019 and have steadily grown adoption since then, constantly looking for ways to evolve the operating model to offer a better service to the business. Two recent innovations that show great potential are external sharing (allowing third parties to access Power BI reports in a controlled way) and ‘data labs’ (large, granular data models that can be used to build multiple reports). We’d like to give an overview of these innovations and how we have implemented them from a technical, governance, and people point of view. Dan Burgon Dan Burgon leads the BI Development Team at The Very Group. He has been with The Very Group for five years, and has worked in a variety of roles and industries during his career.

Dan Lloyd Dan Lloyd is a Senior BI Developer at The Very Group. He is approaching the end of his 2nd year at The Very Group and has worked extensively on Trading data across a number of large scale report developments. He has been utilising Power BI for the creation of complex reports and interactive tools for around 4 years, with prior expertise in Process Automation (VBA and Power Automate) as well as Excel based reporting and validation tools across Finance and Procurement functions.

Paul Ewin Paul Ewin is a Senior BI Developer at The Very Group. He has been with the Very Group for over 20 years and has worked across various departments over that time. He has worked on Mathematical models to predict demand, built data models within Teradata as well as report building both in Excel and more recently Power BI.

Johnny Winter with "By the Power of Analytics Engineering!" As chosen by the user group members, in this session we're unravelling the mystery of analytics engineering - the latest hot job in the data universe, and seeing how it buddies up with Synapse Data Warehousing, Power BI, dbt, Tabular Editor and Azure Dev Ops to help you master your Fabric implementation.

We'll kick things off with a casual chat about analytics engineering, breaking down the jargony bits and zooming into what really matters.

Then, we'll zoom in on Fabric. Ever wondered how it can up its game with a sprinkle of analytics engineering magic? Join this session to find out the answers! Real stories of how Fabric can get battle ready with analytics engineering will be on the agenda.

Johnny Winter Johnny currently works as a consultant for Advancing Analytics. He’s been working with Business Intelligence software since 2007, specialising in the Microsoft data platform since 2016. He’s a self-confessed Business Intelligence geek and in his spare time runs the website and YouTube channel Greyskull Analytics, where he likes to nerd out about all things Power BI. He is also a co-organiser at pbiMCR, the Manchester based Power BI user group.

Join LEARNTOR FREE webinar on June 15th at 6 PM WAT via Zoom for an informative session on "Overview of Power BI as a Self Service and Enterprise BI Tool".

Connect with us here => https://bit.ly/LEARNTORQR 🚦 💃💃"Overview of Power BI as a Self Service and Enterprise BI Tool". Our guest speaker, Oyebola Omoya, is a Microsoft Certified Trainer, who have trained quite a number of individuals who are also interested in leveraging on analytical tool (Microsoft Power BI, Azure SQL) for excellent and impeccable delivery of their work for about 2years and counting. She will be sharing her knowledge and experience on using Power BI as a Self Service and Enterprise BI Tool. Time: June 15, 2023 06:00 PM West Central Africa Venue: Zoom Join Zoom Meeting

https://us02web.zoom.us/j/87690932689?pwd=ZkQ3OHZpYWRKempMMjB3RGRGdERVQT09

Meeting ID: 876 9093 2689 Passcode: LEARNTOR

Whether you're a Data analyst, Power BI Expert, or simply interested in learning more about data analysis, this meetup is for you.There will also be time for Q&A and networking, so you can connect with like-minded individuals and share your own experiences. Don't miss out on this opportunity to learn from an expert and take your Power BI skills to the next level. RSVP now to secure your spot!🚀

Meet the host: 🎙🎙🎙 Mercy George-Igbafe is a multi-award-winning tech evangelist committed to closing the gender gap in Africa with the goal to develop 10,000 women and youth. An Educator, founder, and mentor in championing, Artificial Intelligence (AI), Robotics, Agile, Scrum, Kanban, Data Analytics, Business Analysis, Cyber Security, and Digital Marketing with over 25 years of experience. A professional Scrum Master, and Microsoft Certified Trainer with Professional Diploma in digital marketing. We have trained 2,380 tech talent and 75% of our learners are women Tech first-timer. Despite challenges and overcoming insurmountable hardships not excluding rape with zero support as an orphan girl I was determined to make something of my life with a commitment to help other women win as I have. Hence my commitment to helping as many women get into tech to become African Change-agent . My Tech journey started in 2000, Technology as an employee of Ecobank, while in 2017 where I fully embraced Tech, confronted with a mid-life crisis unsure and in despair, Today I am on a mission to evangelize Tech to more women with a renewed of purpose as a customer-centric, value-driven and problem-solving individual devoted to social reforms. Today, I have almost 15 certifications. A Microsoft Certified Trainer, Data Analyst, Professional Scrum Master, Certified Business Analyst, Professional Digital marketing, and leading Agile Digital Transformation campaign and implementation for my clients and students. My tech journey began in 2000 when I joined Ecobank as an employee. It wasn't until 2017 that I fully embraced tech where I now hold over 15 certifications. An Agile Digital Transformation professional, a Microsoft Certified Trainer who is also a Data Analyst, Professional Scrum Master, Certified Business Analyst, Professional Digital Marketer, and Certified Data Analyst. I founded LEARNTOR Foundation and LEARNTOR with the goal to develop 10,000 women into tech by 2025 to mitigate the high rate of unemployment and employability problems whilst bridging the digital skills gap and advocating Agile best practices and principles. Our vision aligns with UN MDG goals (4, 5 & 8) Quality Education, Gender Equality Decent Work, and Economic Growth. Our traction and impact earned me an executive board appointment as an executive board member for Women in Agile (USA) for Diversity and Inclusion (DEI) and the convener of Women in Agile Africa organizing the most inclusive African Agile conference in 3 languages (French, English, and Portuguese). My commitment to advancing Tech in Nigeria and developing women has earned me features on major media platforms like, Channels TV (The Beam, Tech Trend, Business Morning), Wazobia MaxTV, Television Continental, ThisDay, The Nation Newspaper, Guardian, Arise TV, Daily Independent, Vanguard, Wazobia TV, Max FM, Guardian Woman, She Leads Africa etc LinkedIn Profile: https://www.linkedin.com/in/mercygeorgeigbafe/

With PowerPivot, Microsoft brings the power of Microsoft's business intelligence tools to Excel and SharePoint users. Self-service business intelligence today augments traditional BI methods, allowing faster response time and greater flexibility. If you're a business decision-maker who uses Microsoft Office or an IT professional responsible for deploying and managing your organization's business intelligence systems, this guide will help you make the most of PowerPivot. Professional Microsoft PowerPivot for Excel and SharePoint describes all aspects of PowerPivot and shows you how to use each of its major features. By the time you are finished with this book, you will be well on your way to becoming a PowerPivot expert. This book is for people who want to learn about PowerPivot from end to end. You should have some rudimentary knowledge of databases and data analysis. Familiarity with Microsoft Excel and Microsoft SharePoint is helpful, since PowerPivot builds on those two products. This book covers the first version of PowerPivot, which ships with SQL Server 2008 R2 and enhances Microsoft Office 2010. It provides an overview of PowerPivot and a detailed look its two components: PowerPivot for Excel and PowerPivot for SharePoint. It explains the technologies that make up these two components, and gives some insight into why these components were implemented the way they were. Through an extended example, it shows how to build a PowerPivot application from end to end. The companion Web site includes all the sample applications and reports discussed. What This Book Covers After discussing self-service BI and the motivation for creating PowerPivot, the book presents a quick, end-to-end tutorial showing how to create and publish a simple PowerPivot application. It then drilsl into the features of PowerPivot for Excel in detail and, in the process, builds a more complex PowerPivot application based on a real-world case study. Finally, it discusses the server side of PowerPivot (PowerPivot for SharePoint) and provides detailed information about its installation and maintenance. Chapter 1, "Self-Service Business Intelligence and Microsoft PowerPivot," begins Part I of the book. This chapter describes self-service BI and introduces PowerPivot, Microsoft's first self-service BI tool. It provides a high-level look at the two components that make up PowerPivot - PowerPivot for Excel and PowerPivot for SharePoint. Chapter 2, "A First Look at PowerPivot," walks you through a simple example of creating a PowerPivot application from end to end. In the process, it shows how to set up the two components of PowerPivot, and describes the normal workflow of creating a simple PowerPivot application. Chapter 3, "Assembling Data," starts off Part II of the book, and explains how to bring data into PowerPivot from various external data sources. It also introduces the extended example that you will build in this and subsequent chapters. Chapter 4, "Enriching Data," shows how to enhance the data you brought into your application by creating relationships and using PowerPivot's expression language, Data Analysis Expressions (DAX). Chapter 5, "Self-Service Analysis," describes how to use your PowerPivot data with various Excel features, such as PivotTables, PivotCharts, and slicers to do analysis. Chapter 5 also delves further into DAX, showing how to create and use DAX measures. Chapter 6, "Self-Service Reporting," shows how to publish your PowerPivot workbook to the server side of PowerPivot (PowerPivot for SharePoint), and make use of its features to view and update PowerPivot reports. It also shows how to use the data in a PowerPivot workbook as a data source for reports created in other tools such as Report Builder 3.0 and Excel. Chapter 7, "Preparing for SharePoint 2010," is the first chapter in Part III of the book. It describes the components of SharePoint 2010 that are relevant for PowerPivot, and looks at how PowerPivot for SharePoint interacts with those components. Chapter 8, "PowerPivot for SharePoint Setup and Configuration," provides instructions on how to set up and configure a multi-machine SharePoint farm that contains PowerPivot for SharePoint. Chapter 9, "Troubleshooting, Monitoring, and Securing PowerPivot Services," gives tips on how to troubleshoot PowerPivot for SharePoint issues. It also shows how to monitor the health of your PowerPivot for SharePoint environment, and discusses relevant security issues. Chapter 10, "Diving into the PowerPivot Architecture," describes at a deeper level the architecture of PowerPivot, both client and server. It also explains the Windows Identity Foundation and discusses the use of Kerberos in the context of PowerPivot for SharePoint. Chapter 11, "Enterprise Considerations," talks about common PowerPivot for SharePoint enterprise considerations: capacity planning, optimizing the environment, upgrade considerations, and uploading performance. Appendix A provides instructions for setting up the data sources that are used to build the SDR Healthcare extended example in Chapters 3 through 6. Additionally, two "bonus" elements are available online at this book's companion Web site: Appendix B is a comprehensive DAX reference that describes all the DAX functions and provides code snippets that show how to use them. A special chapter describes real-world scenarios in which PowerPivot is used to solve common problems.