Data Visualization – EZPowerBI

Dubai Police – Impressive Fleet

Dubai Police is unique because of having one of the most expensive fleet in the world. Their fleet includes high speed sports cars as well as expensive luxury vehicles primarily to project soft image of their department in front of large expat community and tourists. When recently they tweeted possible inclusion of Tesla’s Cyber Truck, I was interested in getting proper data of their fleet. Unfortunately I couldn’t find any comprehensive data to work on so I gathered data from different sites including few mentioned below.

Finally I gathered sufficient data to work on my next data visualization project. The result was fantastic as I came to know a lot about their fleet and shared the same through my report for those who want to get details on single screen. Furthermore, I used Microsoft Power BI to create fleet catalog which gives a details of individual vehicles.

Report can be viewed live through following link.

View Report

Catalog Dubai Police - Aamir Ali Ansari - EZPowerBI - Treehouse Consultancy LLC

Infographic using Power BI

With more demand and acceptance of data visualization, we have to deal with different kind of audiences. Some of those are not having analytical minds and simply grab information through graphics and cosmetics. There is also a need of awareness for masses for which statistical analysis and graphs are sometimes too much for general audience. In this scenario Inforgraphic is the best candidate to address these concerns.

I have experimented a report baased on open data of the government entity DEWA of Dubai. The result was amazing and really provide a simple information about operations and customers’ segmentation.

Report can be viewed through following link

Click here to view

Dynamic Infographics

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

Click Here to View Report in action

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

Dubai Police Force – Wikipedia

Dubai Police Cars – DubaiFAQs

The National