Business Intelligence Dashboards

Description

A dashboard is not a chart with a nicer background; it is software, with users, edge cases and a real risk of shipping something nobody trusts. This course teaches you to design one on purpose and build it as a real, interactive application: filters that actually query a warehouse, KPI cards with trend indicators, a drilldown into the detail behind any number, and an automated test suite that proves the app behaves correctly without a single manual click. It is the third course of the Business Intelligence path, built directly on top of the star-schema warehouse from Business Intelligence Data Modeling, using Streamlit and Plotly, open Python tools that run entirely on your own computer.

What you will be able to do

• Apply dashboard design principles: purpose-first design, visual hierarchy, appropriate chart choice, and accessible, consistent color use.
• Build an interactive Streamlit app with filters, KPI cards and Plotly charts wired to a real SQL warehouse.
• Cache expensive queries so filtering an app feels instant instead of reloading data on every interaction.
• Write automated tests for a dashboard app with Streamlit's own AppTest tool, without ever clicking through it by hand.
• Build a master-detail drilldown and cross-filtering between charts, and handle empty results without the app breaking.
• Describe what it actually takes to package, deploy and access-control a dashboard so a team, not just you, can rely on it.

How the course is taught

Every lesson follows the same rhythm: a short, real situation, a precise explanation next to a plain-words version, a code demo you run yourself, a few exercises with hints, and a summary of what to remember. Every Streamlit example in this course is verified the same way the finished project is: run through AppTest and inspected for real, not screenshotted from a manual click-through, so the printed output on the page is what your own app will actually do. Everything runs offline with Streamlit, Plotly and SQLite; nothing needs installing beyond a Python environment, and no account, key or payment is required anywhere in the course.

You build directly on top of the warehouse from Business Intelligence Data Modeling, the same Trailhead Outfitters retail data used across this path. Deployment to a shared server is shown with real, recorded commands in the fourth module, since this course's environment cannot run a live public deployment, the same treatment given to Docker and cloud steps elsewhere in this platform's courses.

What is included

Short lessons that move from dashboard design principles, through building an interactive Streamlit app, to drilldowns and what it takes to share a dashboard with a team, plus a closing guided project. You also get the Trailhead warehouse file, a starter and solution dashboard application with an automated test suite, and a quiz drawn from a question bank at the end of every module.

Who it is for

If you have only ever built a static chart or a spreadsheet pivot table, this course teaches you to build something a user can actually filter and explore themselves, backed by real data instead of a screenshot. It suits analysts who finished Business Intelligence Data Modeling and now have a warehouse worth putting a real interface on, and it suits anyone who has used Power BI or Tableau and wants to understand dashboard interactivity from first principles, with open tools they can run and test themselves. By the end you will have built and tested a real interactive dashboard application, something you can run live in an interview or hand directly to a team. Enroll now, open the first lesson, and stop shipping dashboards nobody has actually tested.