Author Archives: powerpivotseth

About powerpivotseth

As long as I learn, I live, and to that end I am now immersing myself in the new Microsoft Power BI applications available through Excel. I was quite good at plain vanilla Excel, but even so, I ended up in "No, that is not possible" dead ends at times. Then I discovered Power Pivot and all my previous dead ends opened up into veritable eight-lane interstate highways!

A not so advanced, but useful, Excel tip.

A friend of mine was faced with this problem when preparing an offer to a customer, and asked me to save him from doing tedious manual entries for some 50 products.   He had to make this from his own … Continue reading

Posted in Power BI | Leave a comment

Small investment, low maintenance, high yield = Power Pivot

1. Small investment The vast majority of businesses in the world already use Excel so the big investment has already occurred. a. Companies still using Office 2007 or older are nearing the time when an upgrade to a newer version … Continue reading

Posted in Power BI | Leave a comment

Perfect Reports and Dashboards

Creating reports can be a lot of fun, but there are some very important points to take into account.

Posted in Power BI | Leave a comment

More Power Query–using the fabulous .csv-file

There are lots of fancy data sources that Power Query can grab data from, like the Web, Databases, Excel   and “Other Sources” but the day to day, bread and butter problem solver is most likely to be .csv since … Continue reading

Posted in Power BI, Power Query | Tagged , , | Leave a comment

Power BI–the awesome expansion of Excel!

Excel has been the dominant tool for analysis and reporting for a long time now, updates and improvements have been “software normal” until recently. However, in a rare “hop,skip and jump” Microsoft surprised us with some exciting changes. In Office … Continue reading

Posted in Power BI, Power Query | Tagged , , , , | Leave a comment

(It’s not [WHAT] you know), (it’s [WHO] you know)!

Never have so few =(1 person[me]) had so many =(4 musketeers[below links]) to thank for so much BIntelligence. (Paraphrased from the fat guy with the fat cigar) In order to expand your toolbox you need friends, including friends who might … Continue reading

Posted in Power BI | Leave a comment

Business Intelligence förr och snart.

Bakgrund Under många år har jag arbetat med att ladda in .txt-filer i Excel,omvandla text till siffror samt att bygga CONCATENATE, VLOOKUP, INDEX, MATCH och SUMIF formler. Detta är tidskrävande och inte på något vis foolproof, en missad eller felaktig … Continue reading

Posted in Power BI | Leave a comment