Requirements
- Basic understanding of tables, columns, and joins
- Comfort with Excel-level data concepts (filters, pivots are a plus)
- Basic SQL is helpful (we’ll guide you where needed)
- Laptop + stable internet connection
- Access to a sample dataset/warehouse (provided for practice)
- Willingness to do weekly hands-on assignments
Features
- Live Project-Based Training
- Expert-Led Sessions
- Flexible Learning Options
- Interactive Learning
- Comprehensive Study Material
- Globally Recognized Certification
- One-on-One Mentorship
Target audiences
- Data analysts and BI analysts
- MIS/Reporting professionals
- SQL developers moving into BI
- Data engineers supporting analytics teams
- Product analysts and growth analysts
- Finance/operations analysts building reports
- Freshers aiming for BI roles
- Teams migrating to Google Looker / governed BI
If you’re tired of dashboards that “look right” but don’t match the numbers, our Looker Training in Pune at Ascents Learning is designed for clean modeling and reliable reporting. This course isn’t just about clicking around the UI. You’ll learn how Looker works as a governed BI layer, how teams define metrics once, and how analysts build explores and dashboards that scale.
In Looker Training in Pune, we focus heavily on LookML—because that’s where real-world value sits. You’ll build views, explores, joins, and measures the way companies expect, including common fixes for duplicate counts and messy joins. You’ll also create stakeholder-ready dashboards with filters, drill-downs, scheduled deliveries, and alerts, so reports don’t depend on manual updates.
What you’ll learn in this Looker course
1. Looker setup, projects, content structure, best practices
2. LookML basics: views, explores, dimensions, measures, timeframes
3. Joins + relationships to avoid wrong totals
4. Derived tables (SQL/PDT concepts), validation, QA checks
5. Dashboard building: tiles, filters, drill paths, scheduling
Who should join
Analysts, MIS/reporting professionals, SQL developers, BI teams, and freshers targeting analytics roles—Looker Training in Pune fits both upskilling and job-focused learning.
Curriculum
- 15 Sections
- 56 Lessons
- 22 Hours
- Module 1: Looker Basics + BI Workflow5
- 1.1What Looker is (semantic layer + governed BI)CopyCopy
- 1.2Looker vs Looker Studio (where each fits)CopyCopy
- 1.3Typical analytics workflow: warehouse → model → explore → dashboardCopyCopy
- 1.4Key terms: Explore, View, Model, LookML, Dimensions, MeasuresCopyCopy
- 1.5Tour Looker UI, open an Explore, run basic queries, save looksCopyCopy
- Module 2: Setup, Projects, and Looker IDE5
- 2.1Looker instance structure, folders, spaces, content governanceCopyCopy
- 2.2Looker Projects: why they matterCopyCopy
- 2.3Looker IDE basics: files, folders, validation, content checkCopyCopy
- 2.4Git connection basics (concept + workflow)CopyCopy
- 2.5Create/open a project, run validation, fix simple errorsCopyCopy
- Module 3: Connecting Data (Warehouse + Connections)4
- Module 4: LookML Foundations (Model + View + Explore)4
- Module 5: Dimensions & Measures That Make Sense4
- Module 6: Time Intelligence (Dates Done Properly)4
- Module 7: Joins & Relationships (Avoid Wrong Numbers)4
- Module 8: Explores That Users Love (Clean, Governed, Fast)4
- Module 9: Derived Tables (SQL Derived Table + PDT Intro)3
- Module 10: Reusable LookML Patterns (Write Less, Scale More)3
- Module 11: Building Dashboards (Not Just Pretty Tiles)4
- Module 12: Governance + Metric Definitions (Single Source of Truth)4
- Module 13: Access Control (Roles, Groups, Row-Level Control)4
- Module 14: Performance + QA (Make It Reliable)4
- Module 15: Capstone Project (End-to-End Delivery)0
