Business Intelligence Practitioner

🚀 What You'll Learn

This hands-on course teaches you to make smart business decisions using BI tools tailored for small businesses:

• Collect and clean business data using Google Sheets
• Build live dashboards using Google Looker Studio
• Run predictive models with Orange Data Mining
• Turn insights into decisions and business actions

📦 6 Practical Modules (with Submodules)

📘 Module 1 – BI for Small Business

• Intro to BI for small businesses
• Types of data: sales, inventory, customers
• BI cycle: data → insight → action
• Case: SweetBake Bakery data scenario

📊 Module 2 – Data Cleaning in Google Sheets

• Basic structure & formatting
• Cleaning: remove duplicates, validate entries
• Functions: IF, VLOOKUP, QUERY, ARRAYFORMULA
• Practice: daily coffee shop sales tracker

📈 Module 3 – Dashboards in Looker Studio

• Intro to Looker: layout, filters, data sources
• Creating live KPIs: revenue, orders, trends
• Data visualization: line/bar/pie charts
• Project: weekly sales dashboard

🧠 Module 4 – Predictive Analytics in Orange

• Workspace & widgets overview
• Intro to classification: Naive Bayes, Trees
• Clustering with k-Means
• Case: repeat customers & product segmentation

📊 Module 5 – Decision Making with BI

• Reading insights: outliers, trends, anomalies
• Strategy mapping from BI findings
• Pitching a data-driven business case
• Case: Homewear business scenario

🎓 Module 6 – Final Project + Certification

• BI capstone project with dashboard & report
• Feedback and scoring with rubric
• Official certificate from Lensetek