Excel for BI Reporting and Publishing Through SharePoint – Part 2

In my previous article I have provided the instructions about how SharePoint list(s) can be imported into Excel using OData Feed option, and how it helps in real-time consumption of the data when the report is uploaded to SharePoint. This is the second part of this article series. In this part I will provide the …

Excel for BI Reporting and Publishing Through SharePoint – Part 1

In a typical SharePoint scenario, we build many small scalable custom applications where the SharePoint list(s) hold the data. One of the major challenge faced by SharePoint developers is BI Reporting of the data produced by such applications. Power BI is certainly a go-to tool for such a scenario and is the tool recommended by …

How to Use Aggregate Functions with Multiple Tables in Power BI

Objective If you’ve been following my blogs, you’d be half expecting this ‘complexity’ that I mentioned in my last blog. However, for those you haven’t been following the series, you can still start afresh from this. In this case study, I’ve a Customers table, named Table 1 with one column with unique values – say …

How to use Power BI in the context of SharePoint?

Who should use PowerBI? Anyone who knows the pain of presenting data in the form of charts/graphs, with added complexity of dynamic filters. However, if you are a consultant, trust your skills to link even oranges to iPhones…if you ask me how, I’d say iPhones are from Apple, apples and oranges are fruits…any further explanation …

Data and AI

Data and AI “Data is the new oil. Its valuable but if unrefined it cannot really be used. Just like oil has to be changed into gas, plastic, chemicals etc. to create a valuable entity that drives profitable activity; so must data be broken down, analyzed for it to have value.”~ Clive Humby, Data Scientist …