Learn how to create a simple, but informative and interactive dashboard from daily updated data sourced from Johns Hopkins Institute.
Interact with the actual dashboard here.
We continue exploring data refinements using Power BI. In these videos we cover Grouping on dates, numbers and text along with creating hierarchies.
Comprehensive video showing very useful ways of using VLOOKUP. Explains when to use Range Lookup with easy examples.
We have already learnt how to import and clean data from various sources using Power Query (Transform). Once the data is inside Power BI Data tab (or Excel Data Model of Power Pivot), we can refine and enrich it further using various features like synonyms, custom sorting order, formatting, summarization and more. Watch the video for details – English as well as हिंदी versions are available.
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.