Course details
BI Analyst
Learn the job of a business intelligence analyst: pin down the real business question, define KPIs everyone computes the same way, design dashboards that tell a clear story, check the data is fit to trust, and model it in facts and dimensions. The whole course follows Weftwise, one online home-textile store.
Course curriculum
Introduction to Business Intelligence3 lessons
Meet Weftwise and its first BI problem: three teams, three answers to one question. Learn what business intelligence is for, how the BI analyst differs from engineers, analysts and scientists, and the loop of work that fills a BI analyst's week.
Business Questions and KPIs4 lessons
Separate KPIs from ordinary metrics, write KPI definitions that everyone computes the same way, find every stakeholder behind a request, and turn a vague ask into a business question tied to a real decision.
Business Functions and BI Levels4 lessons
Compute the numbers finance, marketing, operations and HR steer by, using one month of Weftwise data, then match every BI request to its level: operational for today, tactical for the quarter, strategic for the years ahead.
Dashboards and Storytelling5 lessons
Pick the chart from the comparison a question needs, catch the tricks that make charts lie, use colour with purpose and for every reader, lay out a dashboard that passes the five-second test, and write the executive summary that gets a decision.
Data Quality and Lineage3 lessons
Test data against six quality dimensions, reconcile two revenue totals rupee by rupee, and trace a broken KPI upstream to its cause and downstream to everyone it affects.
Modelling Data for BI4 lessons
See where BI data lives, why reporting tables are denormalized, how facts and dimensions form a star schema, and how calculated fields and measures keep ratios such as margin correct however the data is sliced.