OVERVIEW:
Original data: https://catalog.data.gov/dataset
The ‘LA CRIME’ project is an interactive dashboard report published in Power BI. I started the report by creating a database in Postgresql and importing a .csv file to populate the database. Once the data was available in my database, I began using SQL to do some exploratory analysis to determine which metrics I would be using for the Power BI report. I ended up doing some data transformation to group the data into categories and wrote a query to create a fact table for my Power BI report. After downloading my fact table to a .csv file, I then wrote 5 more queries and downloaded them into 5 more .csv files to be used as dimension tables in my Power BI data model. The purpose of this was to simulate using Direct Query while actually using Import mode in Power BI so that my report will remain online when my Postgresql is offline.
Once the data was loaded and available in Power BI, I built my data model to ensure optimal performance of the dashboard report. With the model and relationships established I began building the visual report, using DAX to create the desired measures for the statistical metrics of the report. Once the visual design of the report was complete, I finished the report by assigning the appropriate destinations for the navigation buttons and published the report to powerbi.com. The report remains a work in progress with new revisions currently being worked on
SKILLS PRACTICE:
SQL: Postgreql database mgt, ETL in Postgresql
Power BI: Data transformation, Data Visulaization
SCREENSHOT:
