Power BI Case Study - November 2022
Join us in person as Tony Raasch, lead analyst for a Wisconsin-based restaurant franchise system consisting of over 800 restaurants in the US, shares how his organization uses Power BI to analyze restaurant performance across multiple KPIs like sales, experiences, speed of service, guest satisfaction, and more. The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm on Wednesday November 9th. ***LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. This is where we met in June. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutatePower BI Dashboards: Layout patterns and visualization techniques
Un buen diseño de dashboards permite a los usuarios visualizar los datos que son relevantes para el análisis de sus datos, buscando mostrar solamente los elementos más importantes de la historia que desea contar cada informe. Así, en esta sesión se abarcarán patrones de diseño y técnicas de visualización orientadas al diseño de dashboards en Power BI, haciendo énfasis en darle un impacto positivo a los usuarios finales.Power BI Projects (PBIP) and Git Quick Start
Bring your laptop and join us for a build-along demo where we learn about the new PBIP project format along with some Git fundamentals. Start developing good Git collaboration habits early! The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm. ***LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then the 2nd exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutateIntroduction to Microsoft Fabric
Microsoft Fabric is a new and innovative solution that simplifies data analytics for enterprises. It combines the best of Power BI, Azure Synapse, and Azure Data Factory into one integrated platform that covers everything from data movement to data science, real-time analytics, and business intelligence. With Fabric, you can enjoy a seamless and easy-to-use experience that lets you access and analyze your data in the cloud, without worrying about the underlying infrastructure or services. In this presentation, you will learn about the key features and benefits of Microsoft Fabric. The meeting will start at 5.30pm with refreshments. The presentation will start shortly after 6pm. ***LOCATION*** We'll be meeting on the ground floor of the Baker Tilly offices in Madison: 4807 Innovate Ln, Madison, WI 53707. It's on the far east side - exit the interstate on US-151 towards Sun Prairie, then the 2nd exit on American Parkway. Take the first left onto Eastpark Blvd. The Baker Tilly building is 2 buildings after Cambria Suites on Eastpark Blvd. Enter through the main entrance at the front of the building - doors are locked but we'll have someone to let you in and they'll be a phone number to call if you arrive later. What3Words: ///handyman.navigating.mutate
CCC Quarterly BI Convening
Join us for a quarterly meet-up and learning opportunity about Power BI for California Community College research practitioners. The purpose of these convenings is to provide a space for individuals to share their Power BI expertise and to also bring Power BI users together to engage in collaborative learning. For 2024, we will be meeting the fourth Thursday of every quarter (1/25, 4/25, 7/25, and 10/24) at 10:00am. January Agenda Introductions Overview: Jaime Rodriguez, Katy Wilson Chancellor’s Office Update: Erik Cooper Showcase: Success and Retention, D. Martinez; SQL Import Option, D. Buitron. Resources Next meeting/Website You can use this link to sign on: https://lrccd.zoom.us/j/87678134299Data Visualization and Data Storytelling Best Practices
Want to present? Click here! SESSION TOPIC: Data Visualization and Data Storytelling Best Practices [More Details to Follow] HIGH LEVEL AGENDA: #1. Settle in & Intros #2: Updates #3. Session Topic #4. Q&A / Close LEARNING OBJECTIVES: [Coming Soon]Architecture de la consommation des données dans Power BI
Dans un monde où les données sont au cœur des décisions stratégiques, l'architecture de leur consommation devient essentielle pour maximiser leur valeur. Cette présentation explore comment Power BI, avec ses pipelines natifs et ses capacités avancées, peut transformer la gestion des données en une stratégie gagnante. Vous découvrirez les meilleures pratiques pour concevoir des architectures mono-tenant et multi-tenant adaptées à différents contextes, en combinant pipelines natifs et outils comme Azure DevOps. L'objectif : simplifier les flux de données, améliorer la gouvernance et accélérer la prise de décision. Conférencier : Rodolphe Charly Yemeli Rodolphe Charly Yemeli est un ingénieur de données passionné et expert en technologies Microsoft, avec plus de 10 ans d’expérience dans la gestion de données, les pipelines ETL et la Business Intelligence. Actuellement en poste chez Desjardins, il est spécialisé dans l'architecture et l'administration de Power BI, la modélisation de données avancée, ainsi que l’optimisation des pipelines de données. Rodolphe a piloté des projets de gouvernance et de modernisation des plateformes Power BI à grande échelle, assurant à la fois la performance, la sécurité, et la conformité des données. Avec ses compétences en SQL, Azure Synapse, Power Query, et DAX, il propose des solutions d'architecture robustes et innovantes, adaptées aux besoins métier. Reconnu pour sa passion pour les nouvelles technologies et son esprit collaboratif, Rodolphe est également un formateur certifié, ayant animé de nombreuses formations techniques en Power BI, .NET, et SQL Server. À travers cette conférence, il partagera ses connaissances approfondies sur les architectures de consommation de données dans Power BI, en s’appuyant sur des pipelines natifs pour maximiser la valeur des données.
Issue: can you adjust the browser Power BI desktop uses to login to salesforce?
We are trying to connect Salesforce reports using Power BI Desktop. When we are prompted with the salesforce login we use custom domain, and then use SSO login. We are getting an error when logging in that way. We get the same error when trying to login to salesforce through an IE browser. Is there a way to adjust the browser Power BI desktop uses to login to salesforce?Global Text Search and Filter Across All Tables in Power BI
Greetings, Currently, couldn't find a method to enable users to search through every column in every table for a particular text string and promptly filter visuals on the page with corresponding results (Acting like a Search Bar). While workarounds like concatenating columns exist, they're inefficient and impractical for large datasets. Any enhancement facilitating this capability would greatly enhance efficiency and empower users to efficiently delve into their data. Thank you.
Pagination not working correctly with filtering/search in Power BI table (data exists but appears on
Hi everyone, I am new to Power BI and currently learning by building a Worker Status Report. I am facing an issue with custom pagination when filtering/searching data. Report Setup Data source: PostgreSQL Data is retrieved via a database VIEW Visual: Table Page size: 40 rows per page Pagination implemented using DAX + slicer Filters: Date slicer (range) Search (Company / Department / Employee / Team Leader) The data exists in the model, and both date filter and search work, but the issue is with pagination. When I apply filters or search: The table sometimes shows 0 rows However, the filtered data is actually present on page 4, 5, or some other page Pagination does not reset or dynamically adjust based on the filtered result As a result, users think there is no data even though it exists What I expect: Pagination should recalculate dynamically based on filtered rows If filtered data has fewer rows, page count should update automatically Filtered results should appear on page 1, not hidden on later pages Dax used for navigation page navigation table Page Navigation = VAR totalrows = COUNTROWS(vw_worker_status) VAR _pagesize = 40 VAR totalpages = CEILING(DIVIDE(totalrows, _pagesize), 1) RETURN ADDCOLUMNS( GENERATESERIES(1, totalpages, 1), "Min", ([Value] - 1) * _pagesize + 1, "Max", MIN([Value] * _pagesize, totalrows) ) Pagination measure slicer selection = VAR minvalue = SELECTEDVALUE('Page Navigation'[Min]) VAR maxvalue = SELECTEDVALUE('Page Navigation'[Max]) VAR indexvalue = SELECTEDVALUE(vw_worker_status[index_col]) RETURN IF ( indexvalue >= minvalue && indexvalue <= maxvalue, 1, 0 ) This measure is applied as a visual-level filter (= 1) on the table. My Question Why does pagination not adjust when filters/search are applied? How can pagination be made dynamic based on filtered rows, not total rows? Is there a better or recommended approach for pagination in Power BI tables? Should COUNTROWS be replaced with a filter-aware calculation (like ALLSELECTED)? I would really appreciate guidance or best practices. Thanks in advance for your help! https://drive.google.com/file/d/1DjHwOcX_bGAFqFlIzVC-YEXBzbYqHrBh/view?usp=sharing
