📚 Syllabus & Course Curriculum
Data Science & Analytics
Module-by-module breakdown of Business Intelligence Tools for Researchers: From Data to Insights, from foundations to a certified capstone project.
Foundations
• Dashboards for monitoring against ad hoc analysis for answering a question
• Tableau, Power BI and Looker Studio compared on cost and licensing
• When a BI tool is the wrong choice and a script is better
Data
• Connecting sources, extracts against live connections and refresh scheduling
• Tidy data, star schemas and why one wide spreadsheet breaks down
• Power Query and joins, with the fan and chasm traps that inflate totals
Calculation
• Calculated fields, DAX measures and row against filter context
• Aggregation errors: averaging an average, and totals that do not reconcile
• Time intelligence for period comparison
Design
• Chart selection matched to the question, and charts to avoid
• Layout, hierarchy and the small number of numbers a dashboard can carry
• Colour used for meaning, with accessible palettes
Delivery
• Publishing, row-level security and controlling who sees what
• Documenting definitions so two dashboards do not disagree
• Version control, validation against source and retiring stale reports
Earn government-registered certification in Business Intelligence Tools for Researchers: From Data to Insights
e-Certificate and e-Marksheet issued on successful completion.
