AgileBI is helping to change lives

Education must be something accessible to everyone. It’s based on this that Yarra Foundation’s goal is to make education a reality rather than just a distant dream for disadvantaged children and their families.


AgileBI also believes that education is the key to a better future. That’s why we also make our contribution to help this goal become a reality in disadvantaged children’s lives.

“It is an honour for Yarra Foundation to have Agile BI as a Major Sponsor. It goes with no say that the work that Yarra Foundations does, depends on generous people and businesses like AgileBI. Your continued support has enabled Yarra Foundation to reach out to more disadvantaged children and bring them the life changing gift of education. We sincerely appreciate your generosity and thank you for joining us in this journey.”

Arezou Houshmand
Public Relation Affair Manager

For more information, contact them via email at

Don’t leave for tomorrow, help them to change lives today!



Power BI PowerPoint Integration Arrives (ish)

Power BI has been on a roll recently, releasing a bunch of features that have overall strengthened Microsoft’s self-service business intelligence offering. It’s spiritual predecessor PowerView had a nice integration with PowerPoint. Now Power BI PowerPoint integration has arrived.

In the September update, we received a big upgrade to Power BI’s mapping capabilities through the introduction of ArcGIS maps. There has also been continued development around R integration within Power BI to better support the needs of customers requiring advanced analytics. You can now even connect to your preferred R IDE when developing R-based custom visuals or run an R script over your dirty data to impute missing values.

Power BI PowerPoint integration

n the last couple of days, Power BI has quietly released a feature that I personally think will get everyone excited and appeal to the masses – the ability to publish Power BI reports to PowerPoint with the click of a button! So lets get started on how you can find and use this new feature.

Open up a report in Power BI Online and click “File”. You will then see the screen below. Click the “Export to PowerPoint (Preview)” button to generate a PowerPoint file. It will contain a slide for each Power BI report page as well as a title slide containing information on when the data was last refreshed and the file downloaded.

Power BI PowerPoint Publishing

Power BI PowerPoint Publishing

Unfortunately, as you can see in the screenshot below, the end result is not what I expected. I would have liked to have seen a fully interactive experience that included the ability to use cross-highlighting/cross-filtering. It appears, for now at least, that the feature has fallen short of my expectations.

Power BI PowerPoint Publishing

Power BI PowerPoint Publishing

That being said, there are a few caveats, the first and biggest one is that this feature is in preview. We know from past experiences that Microsoft has been happy to ship features to Power BI that aren’t fully ready in the hope that they can leverage feedback from the community sooner rather than later. A recent notification from the Power BI team confirmed that this will be the case.


The second caveat is that in this demonstration we have used some Agile BI magic behind the scenes which probably has caused some headaches for Power BI’s cookie cutter Power BI PowerPoint feature. I tested this hypothesis by exporting a more simplistic Power BI report and I’ll be honest, I was impressed with the results.

The moral of the story, keep it simple for now.


This feature will eventually end up becoming a main selling point of Power BI over its competitors, but it still has a long way to go.

I’ve found with some things in Power BI you just have to be patient. In 2-4 months time, this feature will be generally released and I’m going to assume that this feature will end up being a lot closer to our current expectations. To put things in perspective, it has been less than a year and a half since the launch of Power BI and it has already become one of the leaders in the self-service BI market according to Gartner. In my opinion, one of the reasons that people see strength in Power BI is that they know it will continue to grow and develop faster than any other self-service product. I hope it continues as it’ll mean we’ll be seeing more new and improved features like this one coming to Power BI soon.

Predictive Power Visualised AML + Power BI

Sydney Power BI User Group

PBI_UserGroup_v2 (2)

We are excited to announce that our user group was one of the very few selected from across the world to be a launch partner for the newly formed Power BI User Groups! (PUGs) This partnership will allow our group to receive support from the Power BI team in the way of exclusive perks, contests, content, swag and more!
As well, because the Power BI group is data driven, we will be providing statistics about our meetings and content it can be aggregated with the other PUG
statistics. We will have Power BI dashboards and reports to evaluate trends and patterns that are most popular for the successful PUGs across the world. You will also play a key role in those statistics. The more we participate the more perks we earn as a group and as individuals!
As we are a launch partner, there will be a lot of flexibility and we play a key role in shaping the Power BI User Group Program, so feel free to share your feedback on our group page and with our leaders.
We would like to encourage you to show your support, tweet about it (don’t forget to use #powerbi for MS amplification) and visit this link now to claim your badge on the Power BI Community. We look forward to this exciting journey of being a Power BI User Group.

Iman Eftekhari, Agile BI co-founder and principal consultant speaks about loT and Cortana Analytics at Microsoft in Denmark.

Internet of Things (loT) is now even more practicable with the power of the cloud analytics. Now with Cortana Analytics which have included components across a broad set of Azure Services, Power BI and APIs, you can connect your sensors and devices to the cloud to do more intelligent stuff and “Connect the Dots”. In this session you will get an overview of the capabilities in Cortana Analytics, and Iman will show you an outlook of the future. Find here the event link.

Microsoft Cophenhagen

Why Cortana Analytics is such an impressive tool?

(1) Analytics that enables action

Take action ahead of your competitors by going beyond looking in the rear-view mirror to predicting what’s next. Enhance your business applications with machine intelligence to evolve from simple descriptive analytics to prescriptive recommendations.


  • Predict: Predict what will happen with state-of-the-art machine learning algorithms
  • Prescribe: Augment and improve your decision making processes with proactive alerting and recommendations on actions to take
  • Automate: Simplify and automate decision making when dealing with complex problems that involve multiple variables that may change in real time

(2) Perceptual intelligence

Interact with customers and stakeholders in new ways and infer intent with vision, face, speech, text and sentiment analysis to customise responses and drive appropriate actions.

  • See: Recognise your users and customers with face detection, identification and verification. Recognise objects within images to tailor your responses to your customers
  • Hear: Add speech recognition and response to your applications and translate spoken words into intent to drive actions needed for the business
  • Read: Understand and analyse text, e.g. customer feedback on your site or forum, to determine overall sentiment and key phrases

(3) Fast and flexible

Why start from scratch when you don’t have to? Build with partner solutions for your industry or extend our basic building blocks to tailor the solution to your specific needs.

  • Get started quickly: Build on top of industry-specific partner solutions or customise machine learning models, APIs and templates from our Solutions Gallery
  • Use all your data: Connect to and get value from data of any volume, variety and velocity both on premises and in the cloud
  • Open and extensible: Empower your organisation to work with the languages and frameworks they already know and use like R, Python and Hadoop

(4) Secure and scalable

Your business needs will grow over time; so should your infrastructure. Continue to get value from your data in a secure, compliant and scalable way.

  • Secure: Keep your customers’ data safe on a trusted and secure cloud platform with encrypted communications, threat management, mitigation practices and regular penetration testing
  • Compliant: Ensure infrastructure compliance with your industry through our broad set of compliance standards such as ISO 27001, HIPAA, FedRAMP, SOC 1 and SOC 2
  • Scalable: Elastically scale to petabytes of data as your business needs grow over time, while keeping the flexibility and choice to manage multiple data repositories in the cloud

(5) Personal digital assistant

Integrate with Cortana, your truly personal digital assistant. Cortana works with the Cortana Analytics Suite to enable your business, and your customers’ businesses, to get things done in more helpful, proactive, and natural ways.

  • Helpful: By intelligently learning about your business needs over time, Cortana becomes increasingly helpful when it comes to connecting data into intelligent action.
  • Natural interaction: Interact with you data with natural language and speech, through Cortana.
  • Proactive: Always looking out for you and your customers, Cortana can analyse business and customer data to pro-actively suggest helpful actions, trends and insights.

Ask us for more information about Cortana Analytics here.

Your Name (required)

Your Email (required)


Your Message



Nothing Found

Sorry, no posts matched your criteria