Combine data from multiple files / sheets
Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added.
Using Power Query, this type of work is extremely painless and quick. What’s more it refreshes data in just a click when more files are added.
This is a part of data clean up series based upon the 10 rules for clean data. This video covers rules 1, 5, 6, 10 – cross-tabs, data growing horizontally
Starting a new video series on Power BI. Here is the first video: Power BI Data Import.
We spend lot of time in data cleaning. But there is no simple definition of exactly what clean data means. Therefore, I created a simple 10 item checklist. If all
I have noticed that most customers are reluctant to pay the 9$ license cost for Power BI. Here is how you can use Power BI free of cost. I am
At Microsoft Ignite 2020, more than 700 sessions were conducted in a matter of just 3 days. I created a Power BI Dashboard – Ignite Session Viewer to help you
While working with Power BI we often need to convert Seconds to Duration. This is easily done in Excel just by applying the formatting code “HH:MM:SS”. Unfortunately in Power Query
Grouping means combining multiple items into fewer items. It helps us consolidate and summarize things to understand them at a higher level of granularity. Let us see how to use
This content is relevant only if you are a CIO (or IT decision maker). Here is the video of the session I conducted at CIO Power List event on 4th
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.
