This is a sneak preview of my upcoming Udemy course on Pivot Tables. This video explains the relationship between Pivot Tables and File Size. Watch this 6 minutes video and learn from it.
Apply this knowledge to your existing pivots – especially those with large file sizes and see the difference. Make sure you try it out on a copy. Never learn using Live files.
Continue reading Pivot Tables and File Size
Here is the list of articles I have written about Show Values As in Pivot table. This is a very important set of features but are mostly ignored.
Continue reading Show Values As: Knowledge Pack
Please read the earlier article about Pct Difference From in order to learn the background. This article shows how to take this one step further.
Continue reading Pct Difference From – Secrets
I am happy to announce that my first detailed training course is now up and running at Udemy. It is about Power BI. But it starts with what you already know – Pivot Tables. That is why the course is called Pivot Table to Power BI.
Continue reading Announcing Pivot Table to Power BI course
You must read this article first: Grouping Text in Pivot Tables. This article explains how to combine multiple text items into a single group. This is used for classifying or for correcting spelling mistakes. If new items appear, they remain ungrouped. That way, you have to keep doing the Grouping update repetitively. An alternative is to use VLOOKUP based text grouping. Read on to find out how this is done.
Continue reading VLOOKUP based text grouping
Although Power View and Power BI reports are similar, Microsoft is focusing on the later. Power BI platform is being separated out from Excel for many reasons. One of the reasons is to eliminate the dependence upon Silverlight (technology used to create Power View, which is now being phased out).
Here is a 2 minute video which explains how to convert Excel based Power BI components like data mode, queries, relationships and Power View dashboards into Power BI Desktop. Once converted, you can publish these to the Power BI portal.
I work with many customers on Power BI. It is a new topic for many users and decision makers (not techies). The benefits of using Power BI are obvious and everyone wants to use it immediately. However, the first question I get is – How to use Power BI with PowerPoint ?Here is the answer. Don’t try to put Power BI dashboards or visualizations into PowerPoint. Simple. If you want to know why, read on …
Continue reading Don’t use Power BI with PowerPoint
This is a very old feature. But it is still very useful. Spend 10 minutes to learn where you should use and not use Range Names in Excel.
Continue reading Where and when to use Range Names in Excel
Watch this five minute video to understand what we “really” mean by Remove Duplicate Rows in Excel. The default option removes the duplicate rows automatically. Most of us want to “see” the duplication. That is what leads to the confusion. Not to worry. Learn the right method now.
Scan this code and watch the video on your mobile phone and try it out on your laptop.
Download the sample file if you want to try it out yourself.
Continue reading How to Really Remove Duplicate Rows in Excel
Power BI Glossary is a one line description of relevant terms. Jargon free and easy to assimilate. This is actually part of the Power BI Udemy course I am working on. Let me know your feedback.
Power BI Glossary
||Data as it is received by you
||Information in a table form
||Data which is not good
||Good data with a name
||Roll up or combine raw data into smaller, easier to grasp information
||Finding all possible useful things from the data
||Popular tool to summarize tables and analyse the information
||A way of sharing results of analysis
||Using the analysis to eliminate bad things or increase good things in future
||Set of new tools which allow even more, faster and easier analysis
|Power BI Desktop
||Windows application which helps in gathering data, cleaning and analysis
||Showing data using a graphic rather than just numbers and text
||Multiple, related visualizations shown together
||Dashboard where changes to one item affects the related visualizations
|Power BI Portal
||The place on internet where you can publish and share the analysis
|Power BI app
||A mobile app for viewing and interacting with Dashboards