Blogs

If you are just getting started with Power BI you may be seeing a lot of references to a 'Calendar' Table or 'Date Table.  Maybe you already have a handle on this aspect of PBI, but a lot of people seem not to understand how to get started.  If you forego having a 'Calendar' Table altogether, you can end up having a very cumbersome file and you won't be able to take advantage of many of the awesome date/time functions offered through Power BI.  There are quite a few good resources already out there.  This post points you to a few of those and helps you get started in both M and DAX. To turn off Time intelligence - here is a great blog resource:  ...

Register for our no-charge webinar series to learn how to protect yourself from being a a target of cyber threats! With over 164.68 million sensitive records exposed in 2019, there has never been a greater need for cyber security training. There are news stories published almost daily about data breaches and identity theft. To address this community need, Dynamic Communities has partnered with industry experts in the cyber security world to provide valuable information on how to protect your organization from cyber crime attacks. Join us for a tapas-style (small bits of learning on various topics), no-charge webinar series June ...

What's your type? For a beginner in Power BI and in business intelligence in general, it is not easy to understand data types and differentiate them from data format. And then comes data category... So, what's all that about, really? It's true that in spreadsheet applications like Excel, data type is not really of a bother to the user, as there is no functionality to define the type of the data present in cells. We just enter values and it's all fine (somehow). In fact, I only started to bother about data types when starting to use Power Query, Power BI and Power Pivot (data modelling tool in Excel). Power Query is less friendly with typeless ...

Hi Friend,  When New York was first picked as a stop on the Power Platform World Tour ,  the topic of how the Microsoft Power Platform was being used to influence change in the NY Taxicab system seemed fitting. Although Dynamic Communities has made the decision to take a virtual approach to this event to ensure the health and safety of our community, we still find value in sharing this story about big data and Power BI. Power BI Reporting and Integration with Azure Synapse Analytics Meet Jared Brown  and  Kenneth (KC) Philcox   from  Tallan – two guys who certainly get data and analytics. Their story is something ...

Hi folks! In the last few days we have observed several news about the Coronavirus that started in China and around the world today is globalized in several regions of the world! My concern is to understand the seriousness of this moment and nothing better than numbers to reach the conclusion that the situation is critical! See my dashboard, I would be grateful for your comment or suggestion for improvement! Link to report: https://app.powerbi.com/view?r=eyJrIjoiNDRhNjQwNjQtZjRlNC00NDEzLTljMGEtMGUxNDRhZTJiNzY2IiwidCI6ImRkYzM1ZDUzLTgxMzUtNDYyNy1hYzM3LWIwZjAwNjQwNGI3MSJ9 Thanks! Vithor da Silva e Silva | Power BI UG Leader - Vitória-ES ...

Hi everyone. This is my first post (in Elnglish), and I hope you can help me. I have a table of dates with all the necessary fields ([Year], [Month], [MonthName], etc) I have another table 'Results' with records of various types (Sales, Returns, Discounts, etc; all these in a single field [Description]) and the value of each record per month [Amount]. I must say that this table is of monthly closing results, so two things happen: (1) to July I will have records until June of that year and (2) for each description there is only one record per month. Both tables are related by the [Dates] field. I want to do a sales analysis comparing one year ...

Hola a todos. Este es mi primer post, espero que puedan ayudarme. Tengo una tabla de fechas con todos los campos necesarios ([Año], [Mes], [NombreMes], etc) Tengo otra tabla 'Resultados' con registros de varios tipos (Ventas, Devoluciones, Descuentos, etc; todos estos en un solo campo [Descripción]) y el valor de cada registro por mes [Monto]. He de decir que esta tabla es de resultados de cierre mensual, así que ocurren dos cosas: (1) a julio tendré registros hasta junio de ese año y (2) por cada descripción hay un sólo registro por mes.  Ambas tablas están relacionadas por el campo [Fechas]. Quiero hacer un análisis de ventas comparando ...

Diseño de cuadros de mandos para auto servicio con Power BI ¿ Les ha pasado que dentro de una misma sección en un cuadro de mando de Power BI, algunos usuarios prefieren gráficas de barras y otros prefieren una tabla sencilla y y quedamos analizando como cubrir esa solicitud? ¿O que algunos usuarios solicitan ver indicadores de satisfacción del cliente, pero otros prefieren indicadores de desempeño de sus equipos? Si bien es cierto, podemos organizar cuadros de mandos que muestren la información en secciones y así darle la oportunidad a los usuarios que consulten el área de su preferencia, también podemos combinar todo dentro de una ...

Environmental Impact of Power Platform Business professionals all around the world are using the Microsoft Power Platform to analyze data, build solutions, automate processes, and create virtual agents. Did you know these powerful tools are also being used to influence change in both state and local government? We all need water, preferably clean and healthy water, in our everyday life. Jared Brown , Vice President of Data & Analytics at Tallan had the opportunity to work alongside DC Water as their Microsoft Partner to use the cloud and artificial intelligence technologies to conduct predictive analytics on the water distribution ...

Azure Machine Learning is a platform on which data scientists can develop machine learning models to meet complex business challenges. So, here we have  Power BI  to discover all behind the scenes to interact users as well as business analysts in much easier and faster way. Read More #AI #Azure #PowerB