Category: Power Pivot

Power Pivot Olympic Dashboard

0 commentsExcelPower PivotPower Queryclean datadata modelexcelpivot tablepower pivotpower query

3 Game-Changing Things Power Pivot in Excel Can Do

If you’ve never experimented with Power Pivot in Excel, and you work with data with hundreds or thousands of rows, you’re probably sick of V-Lookups, index/match, and other frequently used Excel formulae. Even though Power Pivot may have a steeper learning curve, getting acquainted with it will save you countless hours in the long-run. This ….  Read More

Clean Data in Excel

0 commentsData StructuresExcelPower Pivotclean dataexcelpivot chartpivot tablepowerpivotunpivot

The Importance of Clean Data in Excel

To be sure that you’re able to report using your data, try to ensure that each row represents a Single Event! Normally, each row in a table contains data about the first column, or the subject that you will likely be reporting on. To be able to take full advantage of PowerPivot, it’s important to break each row down further, ….  Read More

Date Dimension Data Model

0 commentsDAXExcelPower PivotPowerBIdate dimensiondatedimDAXexcelpower bipower pivotpowerbipowerpivot

How to Create a DAX Date Dimension Table in PowerBI or Excel

I’ve been so spoiled throughout my years of building dashboards and data models in PowerBI and Excel…  I didn’t realize it until recently, as I started taking on freelancing projects outside of work.  I began the process of developing a PowerBI dashboard for an awesome new client, after touting my skills and experience to win ….  Read More