In this lab we will be implementing a forecasting measure using DAX. We will not be generating a forecast data set, rather, we will create a measure that will look at the actuals from the past to forecast what will happen in the future. We will be using a CDC data set of US Deaths. … Continue reading Forecasting Measure in Power BI
This Is Crazy: ThoughtSpot CEO wants to kill BI and for all dashboards to die
I have heard some CEOs say some crazy things, but this is a special kind of crazy talk that we are dealing with here, folks! In this article, Sudheesh Nair (who is the CEO of ThoughtSpot), gives us his critical view of the BI industry in the context of COVID19 aftermath as he attempts to … Continue reading This Is Crazy: ThoughtSpot CEO wants to kill BI and for all dashboards to die
Power BI Anomaly Detection is a Home Run!
Wanted to record a quick video to: congratulate the Power BI team with delivering of this killer featuredo a quick test drive of anomaly detection and see how I like itprovide a quick overview of what it does and how to use it. Not going to lie, I really love this feature. I put together … Continue reading Power BI Anomaly Detection is a Home Run!
How to Use Correlation Plot to Improve Storytelling and Analysis in Power BI
That is right, we are going to step up our game and start adding correlation analysis to our reports and dashboards. Why would you want to do that? Well, a good reason could be to analyze whether there is a relationship between two variables. Yes, technically, you would want to run a regression to get … Continue reading How to Use Correlation Plot to Improve Storytelling and Analysis in Power BI
Power BI & DAX: How to Compare Timeseries with Different Start Dates
Let's say you want to compare time series of two product launches that are six months apart. Plotting data chronologically will not be very user friendly. The best way to do it is to plot them based on number of days from the launch date. This way we can easily see which product grew to … Continue reading Power BI & DAX: How to Compare Timeseries with Different Start Dates
COVID19 vs. US Economy (update #2)
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
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
The Quality and Transparency of COVID19 Data is Unacceptable
Publicly available data for COVID19 is OK for basic trending; however, there are too many data inconsistencies in the data set. Much of relevant data is not publicly available. If our societies are to incur major costs (both financial and with respect to social liberties) then the powers at be must provide all of the … Continue reading The Quality and Transparency of COVID19 Data is Unacceptable
COVID19: Sweden – Was Not Wrong
Was Sweden's approach to COVID19 right? It's too early to tell, but so far, it's also hard to say that Sweden was wrong. More details in my video https://lnkd.in/ejBrVfx . Link to our COVID19 dashboard: https://bit.ly/2voUAbx.
COVID19: Sweden – Doing it Her Way
As you might know, Sweden has chosen a dramatically different approach to dealing with COVID19 pandemic. Instead of shutting down its economy as most other countries have done, Sweden has chosen to keep the restaurants and the borders open. They are, however, doing a bunch of other things to fight the disease. In my latest … Continue reading COVID19: Sweden – Doing it Her Way