Blogs

Power BI - Nuevas funciones DAX para estadistica

By Pablo Moreno posted 9 days ago
Be the first person to recommend this.
Power BI ha agregado recientemente nuevas funciones DAX que amplian las capacidades estadisticas de analisis de datos. A continuacion presentamos un breve resumen y descripcion de estas nuevas funciones: ·         NORM.DIST Devuelve la distribución normal para la media especificada y la desviación estándar. Esta función tiene una amplia gama de aplicaciones en estadística, incluidas pruebas de hipótesis. Sintaxis NORM.DIST(x,mean,standard_dev,cumulative) Argumentos X requerido. El valor por el que desea la distribución. mean requerido. La media aritmética de la distribución. Standard_dev Requerido. La desviación estándar de la distribución. ...
0 comments

Power BI - Cardinalidad 'many-to-many'

By Pablo Moreno posted 21 days ago
Be the first person to recommend this.
Sin duda, una de las caracteristicas mas esperadas y requeridas por multitud de usuarios en Power BI, es la de poder relacionar tablas usando la relacion 'many-to-many'. Esta funcion fue activada en Julio 2018, y quisiera explicar como funciona. Con la función de relación ‘Many-to-Many (muchos a muchos) en Power BI Desktop, puede unir tablas con una cardinalidad de Muchos a muchos y crear modelos de datos que contienen varias fuentes de datos de forma más fácil e intuitiva. Lo primero que debemos hacer es activar la capacidad ‘Composite Models’ en Power BI Desktop: File > Options and Settings > Options > Preview Features , seleccione  composite ...
0 comments

Azure data sources in Power BI

By Erich DeJesus posted 23 days ago
Be the first person to recommend this.
Join Patrick Leblanc and Erich Dejesus on a  hands-on workshop where we will demonstrate how to leverage Power BI to connect to various Azure-based data sources. They will connect to sources such as Data Lake, CosmosDB, Blog Store, Azure SQL, Azure SQL Data Warehouse, etc.. Step-by-step details will be provided so that each attendee leaves with skills and knowledge to implement this when they are back at their desk. The only requirement is to have an Azure subscription you can create one free in this link   https://azure.microsoft.com/en-us/ This event is only for local user in ATL . Register Here: https://www.eventbrite.com/e/azure-data-sources-in-power-bi-tickets-47919398210
0 comments

Power BI World Tour -- Meet Your Speakers!

By Jena Coffie posted 25 days ago
Be the first person to recommend this.
The Power BI World Tour sessions for first three cities of this global tour are now available! Get a look at the popular topics and sessions planned for you, and get to know your speakers! Melbourne (August 21-22) Kelly Broekstra David Alzamendi Charlotte (August 28-29) Melissa Coates Angela Henry Sydney (August 28-29) Peter Myers More speakers and details are being confirmed each day so check back regularly for updates! www.powerbiworldtour.com #PowerBI #PowerApps #Flow #PBIWorldTour ​​​
0 comments

New Features & Look for the Power BI User Group (PowerBIUG)!

By Marghet Hager posted 07-18-2018
Be the first person to recommend this.
We are very excited to announce that  PowerBIUG   (formerly PUG) has a fresh new look! On top of that,  we are excited to  introduce  PowerAppsUG   –   a new site to connect PowerApps users with each other.   L et’s take a tour of some of the new personalized features which will help you better see relevant discussions and upcoming events.   Easily Access User Groups   With the new Utility navigation on the top bar, you can seamlessly access  PowerBIUG ,  PowerAppsUG , and other user groups without leaving the site. You can use your same login credentials for the User Group for Dynamics 365 ( D365UG.COM ) site, giving you ...
0 comments

July PUG of the Month Winner

By Quinne Germain posted 06-29-2018
Be the first person to recommend this.
Congratulations to @Maja Franješ  and the Zagreb PUG on winning the July challenge of the month. We spent some time with Maja to learn more about this community in Zagreb.   What has been the most exciting thing for your PUG so far?  The most exciting thing has been when we realized that all available seats were reserved by group members a week before our first PUG meeting. We have received emails asking for additional seats.   What makes your group successful? Definitely a great team!  None of this was possible without the help of an excellent team that helps in the preparation of promotional materials, finding lecturers and sponsors, ...
0 comments

Memories of DATA & BI Summit 2018 | Dublin, Ireland.

By Anil Maharjan posted 06-27-2018
Be the first person to recommend this.
The journey which we have thought in our mind but couldn’t make it happen due to different things. But this year I got an opportunity to represent myself, my country Nepal and overall Nepal Power BI User Group in DATA and BI Summit 2018 which was held in Dublin, Ireland on 23rd April to 25th April, 2018 at The Convention Centre Dublin. https://www.databisummit.com/home https://www.pbiusergroup.com/kathmandu I was also appointed to be a Program Committee member for this DATA and BI Summit 2018 in Visualize Track, where we team up in group to review different abstracts from different great speakers around the world. We work really hard to finalize the ...
0 comments

Analisis Predictivo con Power BI

By Pablo Moreno posted 06-11-2018
1 person recommends this.
Es cierto que Power BI es una aplicacion bastante versatile a la hora de visualizar y analizar datos, y aunque se menciona en varios blogs y white papers las capacidadesd de analisis predictivo o Machine Learning (al margen de usar el R script ), aqui presento un compendio de las funcionalidades que ya existen para tal fin sin necesidad de usar codigo en R o ningun otro codigo. En cuanto a los metodos o funcionalidades de analisis predictivo, vamos a distinguir entre las capacidades 'propias de Power BI' y las visualizaciones que actualmente estan disponibles en el ‘AppStore’ de Microsoft para Power BI. No es la intencion de este blog de describir o explicar ...
0 comments

Brief Overview of the Project Professional Program

By Tommy Puglia posted 06-11-2018
1 person recommends this.
I wanted to give a summary of what the Tampa Power BI User Group has started to integrate in our monthly meetups - many of you have heard about the Project Professional Program. We have already covered 3 sessions (overview, data modeling, and query editor), and if you are interested below is what we are covering and the goals of the series: Overview: To educate & train Tampa PUG members on building Power BI Reports by guided & interactive sessions via using the “Dashboard in an Hour” (DIAH) or Workshop format. The workshops & sessions will focus on best practices, advanced features & how to implement in reports, and providing solutions by ...
0 comments

Previous Row Value in Power Query

By Andy Parkerson posted 05-27-2018
Be the first person to recommend this.
Someone asked how he could get a calculated column with the value for a certain column in the previous row. In Excel, this is a simple task. However in M, things become a bit more tricky. Suppose you are taking measurements, and for some reason you want the previous measurement to be stored with your data. There are optimization concerns that may make this a useful thing to do, as Power Query only performs its actions on refresh, and not once the data loaded. Alternatively, DAX does it’s work every time you select a slider, click a visualization, or basically change anything on the report. This is one of the times when a good SQL background helps your M ...
0 comments

Counting Measure Results

By Andy Parkerson posted 05-27-2018
Be the first person to recommend this.
Someone had written a measure that gave a certain range of outputs, such as “A”, “B”, or “C”. They had a process that gave a grade to each order depending on how well it performed in certain ways — how fast it was shipped, how many times the customer called in, how much profit was made, etc. They then wanted to know how many As, Bs, and Cs were given. In short, they wanted to be able to count the measure results. When you want to measure other measures, you need the iterative functions (a.k.a the “X” functions). In this case they wanted  COUNTX() . I threw together an example PBIX with some random data. I have 4 data measurements each day ( M1  –  M4 ...
0 comments

Start of Current Month in Selected Year

By Andy Parkerson posted 05-26-2018
Be the first person to recommend this.
Someone asked how he could find the start of the current month in a different year. He had a report that contained a parameter that selected a year, say 2007. He wanted to find the beginning of the current month, say May, in that year. So what he wanted was the string "May 1, 2007" when the current date was May 26, 2018. And if the current date were October 5, 2023, he would want the string to read "October 1, 2007". Whenever you talk about dates in Power BI, you have to know how dates are stored. In this case, the date table was created with the DAX function Dates = CALENDAR(DATE(2001,1,1), TODAY()) That gives you a table named Dates with a column named ...
0 comments

Patrick LeBlanc comes to DC!

By Shannon Lindsay posted 05-03-2018
Be the first person to recommend this.
Have you wondered what the right approach is for creating and deploying your Power BI content? Which tools are the right ones? When do you use app workspaces and apps? How to understand your licensing options? And how to keep your data up to date? Microsoft's own Patrick LeBlanc is coming to DC to help us answer these questions! Join us to hear from Patrick and to network with fellow data people!  You can visit our DC PUG page here, or find us on Meetup  for more details! If you're in the DC area (or even if you're not), follow us on Twitter @Power_BI_DC ​ for Power BI-related news, blogs, and articles! We hope to see you there!  Shannon and Gio
1 comment

Visualizaciones adicionales en Power BI

By Guillermo Taylor posted 04-20-2018
Be the first person to recommend this.
Hola. Como primer post, corto pero se que de valor para ustedes, les estaremos contando sobre visualizaciones adicionales para complementar, de acuerdo con necesidades particulares en sus reportes o Dashboards, lo que construyan con Power BI Desktop . En esta página , qué hace parte del marketplace conocido como AppSource de Microsoft, particularmente para productos varios, encuentran, en el momento del post, un poco menos de 150 diferentes elementos para importar en Power BI Desktop y ampliar los elementos visuales para construir y generar reportes. Desde Power BI Desktop, solo deben ir a la sección de "Visualizaciones" y en la parte en dónde están los ...
0 comments

Preparing for the MCSA in Data Management and Analytics - Certify 3.0

By Phillip Guglielmi posted 04-11-2018
Be the first person to recommend this.
​ “Through 2020, the number of citizen data scientists will grow five times faster than the number of expert data scientists.” Gartner 2018 Magic Quadrant.   The business intelligence and analytics space is overflowing with opportunities for professional and personal growth, and the Microsoft stack commands the market for these platforms. Certify 3.0 is the third installment of a three part series on certifying in analyzing and visualizing data with Microsoft Power BI. This webinar will leave no stone unturned in the final leg of the certification. It will pierce the Power BI service (web service) and take an in depth look at the full lifecycle of Power ...
0 comments

Dynamic Data Masking from SQL Server to Power BI

By Erich DeJesus posted 04-09-2018
Be the first person to recommend this.
0 comments

Analizando texto con Power BI

By Pablo Moreno posted 03-27-2018
Be the first person to recommend this.
Analizando datos de texto con Power BI Es habitual analizar datos categoricos o numericos con Power BI, pero sabia que tambien se puede analizar datos de texto con Power BI? Recientemente estuve hacienda algunas pruebas con unos datos publicos de Twitter, y aqui les comparto brevemente lo conseguido. Una vez cargados mis datos (desde un fichero csv) en Power BI, he seleccionado la opcion  Edit Query Esta opcion abre el Query Editor, donde se puede llevar a cabo toda la transformacion de datos. La columna que contiene todos los textos de los twitters es la columna ‘Text’, y ese es el primer objetivo. Por tanto, lo primero que vamos a hacer ...
0 comments

‘Build Your Own’ Focus Conference: Customized Power BI Training

By Delaney Freer posted 03-26-2018
1 person recommends this.
We all have unique needs when it comes to our jobs. It can be difficult to find ways to customize your education, but Focus, held May 21-24, 2018 in Indianapolis, provides just that! at!  Focus does things a little differently than our traditional conferences - It is split up into four, two-day mini-conferences. All Power BI, Microsoft Dynamics 365, AX, CRM and NAV users are invited to join their peers, Microsoft and technical experts in the "Crossroads of America" where you can pick and choose which Focus conference to attend, best suited to your skills and interests. Monday, May 21- Tuesday, May 22, 2018 Dynamics NAV User Group (NAVUG) ...
0 comments

Focus 2018 schedule now available! Register today for access to 25+ deep-dive sessions

By Delaney Freer posted 03-15-2018
Be the first person to recommend this.
Over the last several months the Focus Programming Committee has worked diligently to determine the most relevant and useful session topics for Power BI users and they are ready to share Focus 2018 session details with you! Check out the schedule      The full schedule of deep-dive sessions is now posted online. View the 25-plus session line-up and accompanying descriptions so you can find the right ones for you. All sessions are 90-minutes long and taught by technical experts. Click here to view all Focus sessions, including speakers and descriptions.  Here's a sneak peek: Administrators Track: Advanced Power BI Security ...
0 comments

Certifying in Power BI and Preparing for the 70-778 Analyzing and Visualizing Data in Power BI

By Phillip Guglielmi posted 03-06-2018
Be the first person to recommend this.
The certification comprises of three topics to know like the back of your hand if you want to pass it, and each topic will challenge every level of understanding around extending data analysis and producing rich data models. Passing the 70-778 Analyzing and Visualizing Data with Microsoft Power BI certification requires proficiency in Microsoft BI tools and an excellent knowledge of relational databases and enterprise reporting. We as BI and analytics professionals seek to be innovators, and it takes a certain swagger to keep up with endless changes in today’s technology ecosystem. Therefore, the 'Certify' series of webinars will peel back the layers of Power ...
2 comments