August 2018 archive

Tree Map chart

Tree map chart

A tree map chart gives you a vision of the size of your data by area. The more then area is big, the more the data is important. With a tree map chart you can see at a glance which element has the biggest size, percentage, value. You can have and example with the New …

Continue reading

Sunburst chart

Sunburst chart

With a Sunburst chart you can present your hierarchy data in a very comprehensive way. In this article, we will see how to visualise the contain of a folder and sub-folder but a sunburst chart could be also the best chart to see the hierarchy in a company (for the number of employees, for the …

Continue reading

Export folder or file list to Excel

Export files from folder

Export the list of files contained in a folder or sub-folders has always been a difficult task. Now with Power Query this job is as easy as 1-2-3 😎😃😍 But more, if you don’t want the list of files but just the folder and sub-folders name, it’s also easy. Connect Power Query to a path …

Continue reading

Power BI with Excel

Power BI is the name gives by Microsoft to a bunch of tools to create amazing dashboard. Limitation of Excel For many people Excel is a tool that is used for its formulas, graphs or macros. I can’t blame them, I’ve worked that way myself for years. However, no one will have missed that an …

Continue reading