Nexorium Training Institute — Professional Training, Corporate Training & Capacity Building Courses in Nairobi, Kenya

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

This course is suitable for business intelligence analysts, data analysts, monitoring and evaluation officers, finance and accounting professionals, marketing analysts, sales managers, operations managers, project managers, consultants, NGO reporting officers, performance management teams, IT professionals and executives who need to interpret organisational data. It is also appropriate for organisations seeking to strengthen self-service analytics and reduce dependence on manually prepared reports.

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

01 4. Will I develop dashboards using real business scenarios?

Yes. Practical exercises cover financial reporting, sales performance, marketing analytics, operational KPIs, workforce reporting and project monitoring. Participants can also work with suitable datasets from their own organisations, subject to data privacy requirements.

02 5. Can organisations request customised in-house training?

Yes. The workshop can be tailored to an organisation's reporting needs, datasets, KPIs, dashboards, governance requirements and industry, including banking, NGOs, government, healthcare, education, retail and professional services.