Big Data – Small Problem! Is the data good?
For those of us who have been in the industry long enough – we know that IT is a hype driven field. New fads and fashions come and go… some
For those of us who have been in the industry long enough – we know that IT is a hype driven field. New fads and fashions come and go… some
All of us conduct surveys, get feedback forms or scoring sheets filled. When data is captured in Excel, we typically use Excel Pivot Tables to analyze it. But what if
Yes. This is a simple rule of efficiency. Of course, this rule is in the context of Office tools. But you never know, try applying it to real life –
The problem with large Excel files Today I was conducting an efficiency optimization session for Risk Management team of a global bank. During the discussion, one of the problems we
Imagine that you have 50,000 rows of data. You want to add a new calculated column. Adding the formula is easy. But copying it to 50,000 rows is nothing but
Common problem I am sure you have faced this problem before. Simply frustrating You copy pasted something from Excel to Word and the width of the page was not enough.
Thank you for your support and encouragement. This vote is now closed. I have submitted a video which demonstrates the benefits of Power BI. This is a global competition held
This time I wanted to try a new style of writing. I created a presentation instead of the usual document like style. Download presentation and view Download the presentation (300kb)
If you use Pivot Table, then you need PowerPivot! Read on to find out why. If you have never used Pivot Table, you should not read this article. You must
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
