Artificial Intelligence & Data Science is coming soon

We're still writing and reviewing the notes for every subject, and we'll open it when every subject is ready. Meanwhile you can practise aptitude, ask Aria about any subject, or see the branches that are ready.

Artificial Intelligence & Data Science

Business Intelligence

BI and decision support, BI modelling, data warehouses, ETL and dashboards, data preprocessing, ML in BI, BI applications.

Interview questions
Notes for Business Intelligence are being written and reviewed. Until they're up, Aria teaches every topic — ask for any part of the syllabus, with worked numericals.

Coming next in Business Intelligence

  1. BI architecture and components· notes coming
  2. Decision support systems· notes coming
  3. Simon's decision-making process· notes coming
  4. Modelling in business intelligence· notes coming
  5. BPMN· notes coming
  6. Data warehouse schemas· notes coming
  7. ETL and change data capture· notes coming
  8. Data marts and OLAP cubes· notes coming
  9. Dashboards and performance management· notes coming
  10. Data validation and transformation· notes coming
  11. Data reduction· notes coming
  12. Univariate and bivariate analysis· notes coming
  13. Regression in BI· notes coming
  14. Classification in BI· notes coming
  15. Clustering in BI· notes coming
  16. Association rules· notes coming
  17. BI applications· notes coming
  18. Mobile and cloud BI· notes coming
  19. Data engineering workflow and pipelines· notes coming
  20. Excel functions, lookups and data cleaning· notes coming
  21. PivotTables and PivotCharts· notes coming
  22. What-if analysis, Goal Seek and Solver· notes coming
  23. Power BI: Power Query and data modelling· notes coming
  24. DAX measures and calculated columns· notes coming
  25. Power BI reports and dashboards· notes coming
  26. Tableau data preparation and blending· notes coming
  27. Tableau visualisations and dashboards· notes coming
  28. Automating data pipelines· notes coming
  29. Excel automation with VBA· notes coming
  30. Sharing and collaboration in Power BI and Tableau· notes coming
  31. Principles of effective visual design· notes coming
  32. Excel charts and dashboards· notes coming
  33. Interactive visualisation with Plotly and Dash· notes coming
  34. Geospatial visualisation with Folium· notes coming
  35. Google Looker Studio reports· notes coming
  36. Data mining and the KDD process· notes coming
  37. Data mining functionalities and task primitives· notes coming
  38. Attribute and data types· notes coming
  39. Data cleaning and integration· notes coming
  40. Data generalisation by attribute-oriented induction· notes coming
  41. FP-growth algorithm· notes coming
  42. Correlation analysis and constraint-based association mining· notes coming
  43. Rule-based classification· notes coming
  44. Grid-based clustering methods· notes coming
  45. Evaluating clusters· notes coming
  46. The business intelligence value proposition· notes coming
  47. ERP, CRM and business intelligence· notes coming
  48. Strategic, tactical and departmental BI· notes coming
  49. Querying, reporting and self-service BI· notes coming
  50. KPIs, metrics and briefing books· notes coming
  51. Importing and cleaning data in R· notes coming
  52. ggplot2: geoms, scales, facets and themes· notes coming
  53. Univariate graphs: bar, pie, tree map, histogram and density plots· notes coming
  54. Bivariate graphs: stacked bars, scatter, line and box plots· notes coming
  55. Mining complex data types: sequences, graphs and text· notes coming