In this follow up for the original analysis I used May updates for the US Census indicators. Unfortunately,things are going from bad to worse. Retail is down 15%, while some components of retail are down 40%, 60%, and even 80%. Link to dashboard: https://bit.ly/2RQ2jr0
Power BI: How to Implement Dropdown Navigation
EDIT 2021-03-02: if you would like to learn how to create a Dynamic Dropdown Navigation - please follow this link: https://businessintelligist.com/2021/03/02/dynamic-dropdown-navigation-in-powerbi/ Dropdown navigation allows us to use the real estate of the report page more efficiently. Traditionally, we use buttons and bookmarks to implement navigation between different pages in our reports, however, as number of … Continue reading Power BI: How to Implement Dropdown Navigation
Power BI & DAX: How to Implement Dynamic Page and Chart Titles
We often need to have a dynamic title (page or chart level) that changes based on what the user has selected from the different slicers/filters on the page. In this video, I go over several strategies for accomplishing this task. I start with a very simple one, that requires no knowledge of DAX and then … Continue reading Power BI & DAX: How to Implement Dynamic Page and Chart Titles
Power BI – SAP Connectors Part 2 Enable Trace
How to get to the log files when using SAP BW as the data source ? I answer this in the post below. https://youtu.be/7WfFDGfR6v4
PowerBI & DAX – Introduction to Calculation Groups
Calculation Groups is a powerful modeling capability in Power BI that allows us to dramatically reduce the number of measures in a model. Calculation Groups also have a dynamic formatting feature that allows us to specify a different format for our measures ($$ vs. %) on the same chart.
Power BI – SAP Connectors Part 1
In this post, I cover things I have learnt and best practices using SAP Connectors in Power BI. Direct Query vs Import mode, Relational vs Multidimensional mode... etc. https://youtu.be/w2Vt-oGhmxU
Power BI: Control Dataset Size Using Parameters
In this post, I cover the steps to use parameters to control dataset size. Check it out. https://www.youtube.com/watch?v=7ipslDgCtss&feature=youtu.be
US Economy: Obama vs. Trump
Who was a better president for the US economy? Trump vs. Obama... Obama vs. Trump... I go over the US Census economic indicators and compare how the US economy performed during the last several administrations. Make your own conclusions by exploring these numbers here: https://bit.ly/2RQ2jr0 US Census Economic Indicators: https://www.census.gov/economic-indicators/
COVID19 – Total Impact on US Deaths
According to the official statistics, there are almost 70k deaths in USA as of first week of May 2020.I am trying to find these deaths in the overall weekly US deaths in the CDC dataset and failing miserably. Our Coronavirus (COVID-19) dashboard is available here: https://bit.ly/2voUAbx Weekly U.S. Influenza Surveillance Report: https://www.cdc.gov/flu/weekly/index.htm Weekly US Deaths: … Continue reading COVID19 – Total Impact on US Deaths
Price Volume Mix (PVM) for Gross Margin Variance Analysis
I have covered Price Volume Mix (PVM) analysis for Revenue Variance in the earlier article. I recommend that you take a look at it first because PVM for Revenue variance analysis is much easier to understand as there are fewer moving parts to think about in the calculations. Assuming that you are now well versed … Continue reading Price Volume Mix (PVM) for Gross Margin Variance Analysis
business intelligist 