Thank you for the overwhelming response for Data Analytics webinar video. More than 800 attendees, 70+ questions.
Watch the video on YouTube (use 720P) or Download (MP4, 188 mb, 60 min) and view on your PC. A big thank you to the Microsoft and Economic Times team for making this possible.
It is a powerful but often ignored feature of Power Pivot.
It allows you to describe the meaning of the data column – independent of its field name.
Estimated reading time 8 min
Continue reading Understanding Data Categories in Power Pivot
Pictures in Excel reports:
This is available only with Excel 2013 Professional Edition and Office 365 Edition. Try it out right now. Enhance your reports. Make them more visual and easier to interpret. Use logos, product shots, country flags, features, people, locations, buildings, spare parts, posters, icons, anything visual.
This is a series of articles about people like me who deliver demos, conduct workshops and speak at keynotes.
I will share what I have learnt about delivering high-impact demos
Estimated reading time 7 min.
Continue reading Demo Warriors: Power Query and Power BI best practices
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 be an even better solution. Estimated reading time 7 min
Continue reading Power Pivot Month Sorting using Time Table – Part 3