Why you should never import CSV into Excel – part 2
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
This is a very common and dangerous inaccuracy. Big operational risk! Check all your dates imports after reading this article. Share it with your colleagues as well. Estimated reading time
Yes. You read it correctly. Everyone does it. But still.It is very dangerous. DO NOT do it. Read on to find out why. Estimated reading time 7 min
In the previous article, we saw how to create custom sorting order using a separate month table.Now we will see how a new type of table called Time Table can
Here is the Power Pivot way of customizing sort order for any column. We will continue with the month sorting order example. Read the previous article first. Estimated reading time
If you use text month in a Power Pivot Table, it is sorted in alphabetical order. Here is the solution to the problem. Quick Solution time 2 min Detailed reading
Excel 2013 Professional edition contains two very powerful add-ins – Power Pivot and Power View. Unfortunately, most users who need these features do not even see these in their ribbon.
Recently I conducted a session for BI team of a large customer. This introduces the concept of end user BI to hard core developers. Have a look. It will give
Reports generated from business applications often become inputs to new reports. You end up spending too much time cleaning them up. Here is a new and unimaginably faster way of
Sometimes we need to share a workbook but not real data. Here is how you desensitize the workbook quickly. Estimated reading time 7 min
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.
