Google Looker Studio for Interactive Dashboards and Business Intelligence Training Workshop

Course overview

The Google Looker Studio for Interactive Dashboards and Business Intelligence Training Workshop equips professionals with practical skills to transform raw business data into interactive dashboards, management reports and decision-support tools. Participants learn to connect data sources, prepare and blend datasets, create calculated fields, visualise key performance indicators (KPIs), design interactive reports and share insights with stakeholders.

The workshop emphasises enterprise reporting applications across finance, sales, marketing, human resources, operations, project management, NGOs and public-sector institutions. Participants work with practical datasets and business scenarios to develop dashboards that support performance monitoring, operational efficiency, accountability and strategic decision-making.

Course objectives

• Connect Google Looker Studio to data sources such as Google Sheets, Google Analytics 4, BigQuery and other supported connectors.
• Publish, share and maintain dashboards using appropriate data-source credentials, access permissions and reporting practices.
• Develop professional KPI dashboards for financial performance, sales, marketing, operations and organisational performance.
• Create calculated fields, apply data blending and develop meaningful business metrics for enterprise reporting.
• Design interactive dashboards using charts, tables, scorecards, filters, date controls, drill-downs and report navigation.

Who should attend

Course content

• Module 1: Introduction to Business Intelligence and Google Looker Studio Business intelligence concepts and enterprise reporting, role of dashboards in data-driven decision-making, introduction to Google Looker Studio and its capabilities, differences bet
• Module 2: Data Sources, Connectivity and Data Preparation Connecting Google Sheets and CSV files, connecting Google Analytics 4 and Google BigQuery, understanding native and partner connectors, using supported third-party data connectors, preparing datase
• Module 3: Looker Studio Interface and Report Development Navigating the Looker Studio workspace, creating reports from scratch, selecting data sources, adding and arranging charts, configuring report properties, managing pages and report sections, using t
• Module 4: Data Visualisation and Chart Selection Creating bar and column charts, developing line and time-series charts, using pie and donut charts appropriately, building tables and pivot tables, designing scorecards and KPI indicators, creating area cha
• Module 5: Interactive Dashboards, Filters and Navigation Adding drop-down filters and selection controls, implementing date-range controls, configuring filter scope, creating chart interactions and cross-filtering where supported, implementing drill-down
• Module 6: Calculated Fields and Business Metrics Creating data-source-level and chart-level calculated fields, understanding dimensions and metrics, using arithmetic and conditional expressions, applying CASE statements, working with date and text functio
• Module 7: Data Blending and Multi-Source Reporting Understanding data blending concepts, joining data using common dimensions and keys, combining sales and target datasets, blending marketing expenditure with campaign results, connecting budget and actual
• Module 8: Enterprise KPI Dashboards and Performance Scorecards Translating business objectives into measurable indicators, defining leading and lagging KPIs, setting performance targets and thresholds, creating actual-versus-target scorecards, monitoring
• Module 9: Financial Reporting and Budget Monitoring Dashboards Developing revenue and expenditure dashboards, tracking budget versus actual expenditure, calculating budget variance and variance percentages, analysing income and operating costs, monitoring
• Module 10: Sales, Marketing and Customer Analytics Building sales performance dashboards, monitoring revenue by product and region, analysing customer acquisition and retention, measuring sales target achievement, tracking marketing expenditure and campai
• Module 11: Operational, HR and Project Performance Reporting Developing operations dashboards, tracking service delivery and productivity, analysing turnaround times and service-level indicators, building workforce dashboards for recruitment and headcount
• Module 12: Advanced Reporting, Parameters and Customisation Using parameters where supported, developing dynamic metric-selection controls, creating advanced calculated fields, using regular expressions for text analysis, applying date calculations, confi
• Module 13: Enterprise Data Governance, Sharing and Security Understanding report-sharing options, managing viewer and editor permissions, distinguishing report access from data-source access, configuring data-source credentials appropriately, understandin
• Module 14: Dashboard Quality Assurance, Maintenance and Performance Validating source data and dashboard totals, reconciling metrics with source reports, testing filters and date controls, checking calculated fields, identifying aggregation errors, invest
• Module 15: Enterprise Capstone Project and Dashboard Presentation Defining an enterprise reporting problem, identifying users and decision requirements, selecting and preparing a suitable dataset, establishing KPIs and business rules, connecting the data
• Training tools and software The workshop uses Google Looker Studio as the primary dashboard development platform, supported by Google Sheets, Microsoft Excel, CSV datasets, Google Analytics 4, Google Search Console and Google BigQuery where appropriate. P

General notes

• Practical exercises and expected outputs Participants will connect and prepare business datasets, create calculated fields, develop interactive dashboards with filters and date controls, blend datasets for consolidated reporting, design KPI scorecards, build budget-versus-actual reports, analyse sales and marketing performance, create a departmental performance dashboard, validate dashboard figures against source data, configure appropriate sharing permissions and present findings to a mock management team. By the end of the workshop, each participant should have developed a portfolio of interactive business dashboards, including an executive KPI dashboard and at least one specialised dashboard aligned with their professional responsibilities.
• 1. Who should attend this Looker Studio training workshop? The workshop is suitable for data analysts, business intelligence professionals, finance officers, marketing teams, managers, project officers, consultants and other professionals who prepare or use business reports.
• 2. Do I need programming experience? No. The course is designed for beginners and working professionals. Basic spreadsheet skills are helpful, while advanced calculated fields and data integration are introduced progressively. SQL is useful for the BigQuery module but is not essential for the introductory course.
• Master Google Looker Studio for interactive dashboards, enterprise business intelligence and automated reporting. This practical professional training workshop helps participants connect business data, create KPI scorecards, develop financial and operational dashboards, blend data sources and deliver actionable insights for better organisational decision-making in Kenya and across Africa.

Frequently asked questions

Schedule & fees