Dubai Police Report – Based on Open Data available on Dubai Pulse

You all know that I am very much fond of working on open data and especially about Dubai. I have recently created a report based on open data of Dubai Police. This is a good usecase as it gives a very good insight for traffic incidents. The same example can be implemented for other cities as scenarios are fairly similar in all cities.

First I created a summary report which was based on overall data. In summary you cannot put so much information, however the report was fairly informative giving quick overview of trends and patterns.

After completing summary report I then worked on one more page/report which was focusing on only one type/classification of incident at a time. This gives detailed information about individual incident type. For cases where human lives are at risk, this report can help in identifying problem locations and time slots to derive action plan to minimize such incidents. I may add few more pages in future but my prime purpose was to provide a good example to start with such data.

Report can be seen live through following link. (Note: Page 1 is a summary – Page 2 is for individual incidents)

Click here to view report

Page 1 – Summary

Dubai Police Incident Report Snapshot

Page 2 – Individual Incident Report

Report indicates where such accidents happened along with hour of the day having more accidents.

Dubai Police Report - Details

I am presently working on more usecases which will be shared later. I can be reached for similar projects in consultancy and/or development roles on my UAE number Cell: 0501167826

Dubai – Importance of Open Data

Living in Dubai for almost a decade I realized that the forward looking and innovative approach has always created opportunities and made Dubai ahead of its competitors. The initiative of Smart City, Data Strategy, Artificial Intelligence and 3D printing are few important areas where Dubai is far ahead and having proper road map in place.

Since I moved towards data focused learning and personal grooming in terms of data visualization and reporting, I found Dubai a place where you have every opportunity to realize your dream of being known and appreciated in your field if your are doing exceptional work.

First I evaluated data available on Dubai Statistics Department’s site which was in much organized manner and was ready to be used for impressive visualizations. I created report based on RTA’s data couple of years back which provide great insight to the operations of RTA in terms of Metro, Taxis and Water Transports.

Water fleet

When I read Dubai’s Data Strategy and Its road map to enable Dubai Government’s entities share and collaborate data, I started thinking of using this data in best possible ways. Smart Dubai is working on different initiatives among those Dubai Pulse stand out as it provides repository of open datasets which can be of great use if utilized properly. Since open data is available on As-Is basis you cannot expect it to be in perfect form, however information hidden in these files need to be cleverly extracted.
The important part is designing meaningful report with simple story to tell which can grab attention and explain its purpose without the help or assistance. For this I selected number of entities to work on their data. Following are couple of examples for the same.
Following are few examples of reports created using open data of Dubai Pulse. Reports are fairly simple in terms of understanding information hidden inside open data.
Dubai Customs
DC Report based on Dubai Pulse

Click here to view report in action


Dubai Health Authority

Licensed Professionals Registered with DHA

Click here to see report in action


Department of Tourism and Commerce Marketing – Dubai

Epermit Report

Click here to see report in action

Dubai Electricity and Water Authority – DEWA

Dewa Report Snapshot

Click here to see report in action

I am presently working on other reports which may be updated soon.

Keep following this post for more examples.

Data Spadework for Power BI Visualization


If you have decided to work on a report for your organization or customer, make sure that your spadework is up to the mark. This will help you in saving lot of hassle when making a report or visualization when making without proper spadework.
First of all you have to see what type of control you have on your data source.

1- Full Control
This must not be taken wrongly as this is related to access to data, here it means that how much you can influence the way and form you are getting data for your reports. If you are mandated to implement business intelligence in your company, then you have to set standards for your data. This may fall in data governance domain but to some extent you have to play a role to get data in meaningful format without unnecessary and inconsistent arrangements. This may be very cumbersome to check for the sanity of data after imported in Power BI especially when your data is in bad shape. This may adversely affect your facts and figures and may contribute in raising false flags due to incorrect data. If you have full control on your data then you can easily achieve maximum accuracy level in your reports.

2- Partial Control
When you don’t have much of a control on the way of getting data, you might have to face a lot of challenges in producing quality results. This may be true when organizations are not ready to change the way the data is gathered and produced. This also belongs to change management where organizations are reluctant to experiment new ways because of working culture and limitations in terms of workforce capabilities. In order to minimize effects of inconsistent data format, you need to list down possible variations to cater the same in your queries. Things may be very difficult in cases where consolidation of data is needed. The best way of getting good reports is to ensure that each data provider is ensuring consistent data entry. Proper standards can be enforced when referring similar data like department names and designations where consistent data entry can help in getting correct figures when data is consolidated from different sources.

3- No Control
In cases where you have simply no control on data sources, you have to set expectations correctly with the recipient of these reports. There are always chances of errors especially when data consolidation is required and data is constantly refreshed and updated. Such cases requires constant testing and maintenance if report is not a one off report. Whenever fresh data is imported, proper auditing is needed to check if any real data is ignored by your query rules. This is also true when your report needs data from external/third party sources. If your external source has changed the format of data or moved to a different URL, you will have to go back and fix your reports.