Blogs

Be the first person to recommend this.
Join us for the upcoming  Power BI World Tour  in London and Copenhagen happening 23-24 August at London County Hall and 28-29 August at the Microsoft Office in Copenhagen/Lyngby where Tristan will be a featured expert! Each event will have  over twenty-seven educational sessions led by Industry Experts. But what is an Industry Expert ? These are active members of the Power BI community who have volunteered to share what they've learned through their years of industry experience by speaking at events, writing articles and leading webinars. Their knowledge and expertise make them trusted resources in the community. One of such expert presenters at The ...
0 comments
Be the first person to recommend this.
The upcoming  Power BI World Tour   in London happening 23-24 August at County Hall will have  over twenty-seven educational sessions  led by Industry Experts. But what is an  Industry Expert ? These are active members of the Power BI community who have volunteered to share what they've learned through their years of industry experience by speaking at events, writing articles and leading webinars. Their knowledge and expertise make them trusted resources in the community. One of such expert presenters at The Power BI World Tour is  Mark Wilcock , a Data Platform MVP and Technical Consultant. As a MVP, Mark’s passion for Power BI comes from his specialties ...
0 comments
Be the first person to recommend this.
The upcoming  Power BI World Tour   in London happening 23-24 August at County Hall will have  over twenty-seven educational sessions  led by Industry Experts. But what is an  Industry Expert ? These are active members of the Power BI community who have volunteered to share what they've learned through their years of industry experience by speaking at events, writing articles and leading webinars. Their knowledge and expertise make them trusted resources in the community. One of such expert presenters at The Power BI World Tour is  Ben Howard , a Project Server Consultant at Applepark, MCT and MVP. As a MVP, Ben’s passion has come from the many clients ...
0 comments
Be the first person to recommend this.
The upcoming  Power BI World Tour in London happening 23-24 August at County Hall will have  over twenty-seven educational sessions  led by Industry Experts. But what is an  Industry Expert ? These are active members of the Power BI community who have volunteered to share what they've learned through their years of industry experience by speaking at events, writing articles and leading webinars. Their knowledge and expertise make them trusted resources in the community. One of such expert presenters at The Power BI World Tour is  Rishi Sapra , a Senior Consultant at Altius and founder of www.excelhow-to.com. As a PUG leader for Power BI, Rishis’s passion ...
0 comments
Be the first person to recommend this.
The PUG Partner Sponsorship is a way for Partners to help build your corporate brand and g ain exposure to new markets and opportunities through PUG events, sponsorships and a partner directory.  Establish yourself as thought leaders in your areas of focus and competency and u ncover new revenue opportunities.  Learn More   Partners, here is an opportunity to expand your network, increase brand recognition and establish your company as an expert by supporting your Local PUG as a Sponsor with a Support Your Local PUG Sponsorship !  Receive continuous exposure and visibility throughout the year at a Regional PUG meeting where ...
0 comments
Be the first person to recommend this.
Interactive sunbuRst graphs in PowerBI in 5 minutes!! Thanks to Longhow for this contribution! Introduction If I mention Power BI to fellow data scientists I often get  strange looks . However, I quite like the tool, it is an  easy and fast  way to share results, KPI’s and graphs with others. With the latest release, Power BI now supports interactive R graphs, and they are easy to create as well. Steps to follow 1.  Install   Node.JS   from and then you can install the PowerBI tools with: > npm install -g powerbi-visuals-tools 2.  Create a new custom R visual: >pbiviz new sunburstRHTMLVisual -t rhtml ...
0 comments
Be the first person to recommend this.
​Atlanta PUG, This is a great blog post by Ken Puls on why we are experiencing performance issue in Power Query.  Just sharing a great article and please help by voting for the fix.  Look forward to seeing you at the Precon tonight. https://powerpivotpro.com/2017/07/power-query-refresh-speeds-suck/ Vote here! Best, Josh
0 comments
Be the first person to recommend this.
Esta publicación es la continuación a :  Como realizar un Diagrama 80/20 o De Distribución Porcentual Acumulada - Parte 2 En esta ocasión les voy a mostrar una manera de obtener el mismo resultado son la adición de la nueva tabla "Nombres". Para ello debemos de realizar ciertas modificaciones a nuestra medida llamada "Cantidad Acumulada Ordenada por Nombre" Cantidad Acumulada Ordenada por NombreV2 = VAR Ranking =     RANKX (         ALLSELECTED ( Ventas[Nombre] );         RANKX ( ALLSELECTED ( Ventas[Nombre] ); CALCULATE ( SUM ( Ventas[Cantidad] ) ) )             + DIVIDE (                 RANKX (                     ALLSELECTED ( Ventas[Nombre] ); ...
0 comments
Be the first person to recommend this.
Esta publicación es la continuación a :  Como realizar un Diagrama 80/20 o De Distribución Porcentual Acumulada En la publicación anterior nos encontramos con el siguiente problema cuando ordenamos por Cantidad. Nuestra línea pierde el valor acumulativo. Y esto se debe a que el Running Total lo ordena alfabeticamente los Nombres. (Es por ello que vemos que el punto más bajo de la línea es Angela y el más alto es Virginia). Ahora vamos a mostrar una primera alternativa de solución a este inconveniente. Vamos a crear la siguiente Medida: Cantidad Acumulada Ordenada por Nombre = VAR Var_Cantidad =           CALCULATE( SUM('Ventas'[Cantidad])) RETURN  ...
0 comments
Be the first person to recommend this.
If you weren't able to secure your seat at the sold out Data Insights Summit happening in Seattle, WA, next week, don't worry, you can attend remotely with a wealth of content being streamed live.  Check out the schedule and join here:  https://www.microsoft.com/en-us/datainsightssummit/default.aspx
0 comments
Be the first person to recommend this.
Maybe you did not have the opportunity to attend the Summit EMEA Conference this past April in Amsterdam, or perhaps attended and missed a session you wanted to see or would like to see a session repeated.  That is why we are bringing you the Best of Summit EMEA Webinar Series!  This webinar series is just some of the top-rated sessions from the April 2017 Summit EMEA Conference being hosted by PUG and made available to you as a live webinar.   Check out the webinars below and click on the title to read more detail and get registered.  You won’t want to miss out on these highly educational events. Best of Summit EMEA Series: Power BI - An In-depth ...
0 comments
Be the first person to recommend this.
En esta oportunidad vamos a realizar un diagrama 80/20 ( Pareto) que nos permite mostrar las principales ventas en un rango de tiempo. Primero vamos a describir a la tabla que vamos a utilizar: Tabla "Ventas" -Nombre: Vendedor -Mes de Compra: En formato Fecha (1 día de cada Mes) -Cantidad: Unidades vendidades Acá está el archivo con la Data en Excel  Ventas_Mensuales.xlsx El primer paso será insertar un gráfico de Líneas y Columnas Configuraremos el Gráfico de la siguiente forma: Con esta ya tenemos las ventas de cada mes (Enero a A Mayo 2017). Ahora necesitamos agregarle una línea que sea el acumulado de las ventas mes a mes. Para ello utilizaremos ...
0 comments
Be the first person to recommend this.
Congratulations to User Group Leader, Erik Svensen and the Denmark PUG on Winning the  June PUG Leader of the Month Challenge . Erik worked to invite the most Power BI Users to his community, post a blog or discussion about the Data Insights Summit, set up a meeting at the conference, and tweet about it.   We spoke with Erik and asked him more about the Denmark PUG, here are his answers:   What motivated you to start a PUG?   I love Power BI!!! - I really think that Power BI is a great tool that makes it so much easier and so much fun to work with and visualize data – but many haven’t discovered what Power BI ...
0 comments
Be the first person to recommend this.
Hello everyone, By attending this meetup, You could win free registration to Data insight summit ($600 each) We have great topic for this meetup and industry expert as speaker. I am eager to see you all again and share recent changes to group. This meeting agenda is divided in 5 sessions. Meetup Registration Link Agenda Beginner • 5:30 PM to 6:00 PM:-Introduction to Power BI By Vivek Patel Beginner and Expert • 6:00 PM to 6:45 PM:-Data preparation tools for Power BI Developers by Simon Nuss • 6:45 PM to 7:45 PM:-Power BI with Narrative Science: Look Who's Talking! by Rayis Imayev (Dimensional Strategies Inc.) • 7:45 PM to 8:15 PM:- ...
0 comments
Be the first person to recommend this.
Did you know Academy courses are now being offered for the members of the PUG Community? Receive the benefits of on-site training without the travel and expense! Learn from expert instructors Explore beyond core concepts and leverage practical, real-world content Hands-on, interactive training environment To view upcoming courses, prices and get registered, click the Education tab on the PUG website and navigate to Academy. Upcoming courses include: Academy – Power BI 3 Day Bootcamp – May 17-19, 2017 Academy – Power BI Developer 4 day Bootcamp – May 22- 25, 201
0 comments
Be the first person to recommend this.
Congratulations to User Group Leader, Ron Ellis Gaut and the Portland PUG on Winning the  May PUG Leader of the Month Challenge . Ron worked to invite the most Power BI Users to his community, post a welcome message, an event in his community, and a photo slideshow.   We spoke with Ron and asked him more about the Portland PUG, who happens to be celebrating their two year anniversary of the user group, here are his answers:   What motivated you to start a PUG?   I began working with Power BI from the very early days. My sense at the time was that Power BI was going to be very successful in the market. When I focused ...
0 comments
2 people recommend this.
Recently I came across very good article on How to select Chart.
1 comment
1 person recommends this.
Dive in Deep. Emerge an Expert. Does your business look at data to make business decisions? If so, Business Intelligence is one of the most important ways to ensure success! Attend PBIUG Focus , held May 10-11, 2017 in St. Louis, MO, for two full days of deep-dive educational content focused on analyzing your data from all data sources with Power BI. PBIUG Focus 2017 is unique because it is comprised of 90-minute sessions in   three targeted tracks :  Essentials, Technical,  and  Visuals . The targeted content will appeal to every type of Power BI user from novice to technical professional. There are a LOT of sessions and expert ...
0 comments
Be the first person to recommend this.
Prezados seguidores, colegas e amigos, tudo bem? Quanto maior é seu Modelo de Dados, mais complexo pode vir a ser sua análise. Para encontrar respostas você irá realizar cálculos utilizando o poder do DAX para construir as Medidas e com elas chegar às visualizações que irão trazer a informação à tona. Por diversas vezes são tantas Medidas em tantas tabelas, que é preciso ORGANIZÁ-LAS em um local específico para que todos seus cálculos fiquem em um repositório único. Por que não criar uma tabela com este propósito? Veja agora, em pouco mais de 5 minutos como fazer
0 comments
Be the first person to recommend this.
Hi everybody, I wish to inform you that I started a new series on SQLShack , called " How to create geographic maps using Power BI ".  The series' plan is the following:  Part 1 – Bubble and Filled Maps Part 2 – Built-in Shape Maps Part 3 - Custom Shape Maps Part 4 – ArcGIS Map for Power BI Part 5 – Globe Map, Flow Map, Route Map Part 6 – Using R in Power BI for mapping Part 7 – Customized images with Synoptic Panel Part 8 – Geocoding Part 9 - SandDance The first article has been released. I'll update the blog to keep you informed as the others come out.  I hope you enjoy it. Let me know what do you about and give me your feedbacks. Is ...
2 comments