Tag Archives: Analytics

Pivot Tables and File Size

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

VLOOKUP based text grouping

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

Convert Power View dashboards to Power BI Desktop

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.

Don’t use Power BI with PowerPoint

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 …

Why not use Power BI with PowerPoint

Continue reading Don’t use Power BI with PowerPoint

How to Really Remove Duplicate Rows 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.

Remove duplicates QRScan 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 in plain English

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 poster

Power BI Glossary

Data Information
Raw data Data as it is received by you
Good data Information in a table form
Bad data Data which is not good
Table Good data with a name
Summarization Roll up or combine raw data into smaller, easier to grasp information
Analysis Finding all possible useful things from the data
Pivot Table Popular tool to summarize tables and analyse the information
Report A way of sharing results of analysis
Action Using the analysis to eliminate bad things or increase good things in future
Power BI 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
Visualization Showing data using a graphic rather than just numbers and text
Dashboard Multiple, related visualizations shown together
Interactive Dashboard 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