Data analytics is oftentimes referred to as business intelligence, BI development, or product analytics. However, that is just the tip of the iceberg since the data analytics process includes activities such as data formation/creation, data cleansing, exploratory data analysis (especially this part), feature engineering, and interpretation of suggestions/predictions/results derived from advanced modelling analysis (i.e.: Machine Learning).
For this project you will perform some of these activities in order to analyse a dataset of your interest.
A GitHub repository including:
-
A
data modelshowing the table schemas and relations between them. You may use an application such as DBdiagram. -
A
functional design mockupwhere the dashboard parts and functionalities must be represented. This document should be an starting point, meaning that the final product can be different. You may use any tool you want, however, it is highly recommended to use ink and paper!!! -
A
BI Report/Dashboardmeeting the requeriments specified in Challenge 1. If you use Tableau you need to include the Tableau Public link to the reporting app. If you use Power BI you need to include the.pbixfile in your repo. -
A
README.mdfile explaining the job done, the reporting app architecture and your main conclusions after the exploratory data analysis. You may find more info of how to build a README file here.
-
Time: 5 minutes sharp.
-
Content: eventhough the perfect report/dashboard should be selfexplanatory, you'll need to explain the reporting architecture and show its funtionalities. Also, you'll need to give actionable insights about your data and support your arguments using the report.
IMPORTANT NOTE: You only need your BI Report/Dashboard for the presentation (i.e.: no Jupyter, no PowerPoint/Canva)
BI Reports and Dashboards are powerful tools for communicating important information at-a-glance. The goal of this challenge is to build a BI Report/Dashboard using a dataset of your choice. Bear in mind the purpose of the report and build a normalized model that fits your visualization requeriments and interactivity performance.
You may use either Tableau or Power BI as your main tool for creating your reporting app. There are not restictions about the data source location or format (local drive, database, multiformat, etc.).
Tip: you should first consider which data and which indicators should be put on the BI Report/Dashboard. Then, decompose the key indicators from multiple dimensions.
A BI Report/Dashboard is not exactly a sequential set of descriptive charts. Instead, a BI Report/Dashboard should be a single interactive interface built around a specific objetive and which components are logically arranged in order to provide data relevant insights effectively.