SharePoint Part 6 – Create Dashboards for data analysis
[youtube https://www.youtube.com/watch?v=j7TBVf78jrU?rel=0] See how easy it is to choose pivot tables and charts from multiple Excel files to create a single dashboard.
[youtube https://www.youtube.com/watch?v=j7TBVf78jrU?rel=0] See how easy it is to choose pivot tables and charts from multiple Excel files to create a single dashboard.
Unbelievable analytics using Excel: [youtube https://www.youtube.com/watch?v=vcwPk3eUxkg?rel=0] Here is a quick overview of how we can analyze data more effectively using new Excel tools. You can also refer to the collection
Repetitive activity? Record a macro. Right? WRONG! Find out why…
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
Earlier we saw how to create a Power View based dashboard. How to show this in PowerPoint? A better question is – WHY show it using PowerPoint? Estimated reading time
In this article, we will explore more benefits of using Power View in comparison with Pivot Table. Estimated reading time 12 min
In the previous article, we saw how to draw many pie charts quickly using Power View. Let us try that using Pivot Table. Estimated reading time 4 min
This is not just a catchy title. It actually happens. Read on to find out the secret. Requires Excel 2013 Professional Edition. Estimated reading time 4 min Practice 5 min
In the previous article we saw the problem with importing CSV files. Here is how the new Power Query can be used to clean the data while importing. Estimated reading
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.
