Create a Star/Snowflake Schema and DAX measures in Excel
You are not wrong if you call PowerBI an upgraded Excel. The major components of PowerBI are Power Query, Power Pivot and Power View....
Descriptive Statistics: Covariance and Correlation
Last time out, we talked about the measures of distribution and dispersions. We will now focus on association measures, i.e. covariance...
Use Business Days to Calculate Revenue Projection
I made a PowerBI report for a client, and they requested a revenue projection. Sometimes, business problems require simple solutions. You...