Does Siksha Sarovar have an AI chatbot to answer student doubts?

Yes. Siksha Sarovar has a built-in AI Assistant chatbot accessible from a floating button on every page. It understands English, Hindi and Hinglish, handles typos (for example 'pyhtion' or 'certifecate'), and indexes 165+ destinations including every course, lesson, BCA subject, school chapter, competitive exam topic, FAQ and tool. Most queries return direct link cards in under 5 milliseconds. An AI fallback is available for novel questions.

Can I ask the SikshaSarovar chatbot questions in Hindi or Hinglish?

Absolutely. The chatbot is built specifically for Indian students — natural Hinglish queries like 'kaise milega certificate', 'free hai kya', 'pyhtion ke datatype kaha hai', 'kaha se shuru karu' are first-class citizens. The matcher strips Hindi filler words and routes you to the right course, lesson or page.

Is the SikshaSarovar AI chatbot free to use?

Yes. The chatbot is 100% free, requires no signup, and is available on every page. It runs locally in your browser for the vast majority of queries — there is no API cost or usage limit. The optional 'Ask AI' fallback for advanced coding questions uses the Pro AI Tutor.

Is Siksha Sarovar really free?

Yes. Every course, lesson, quiz, online compiler, and notes download is free to use without an account. We offer an optional Pro pass that unlocks longer AI tutor sessions, larger compiler quotas and priority support, but it is not required to learn from the platform. The educational content itself stays free.

Do I need to sign in to use the courses?

No. You can browse any course, read all lessons, run code in the compiler and take quizzes without signing in. Google Sign-In is purely optional and is used only to save your progress, quiz scores and certificate eligibility across devices. We never request access to Gmail, Drive, Calendar, Contacts, or any sensitive Google data.

Are the certificates from Siksha Sarovar recognised?

Our certificates are a record of completion that you can share on LinkedIn or attach to applications, but Siksha Sarovar is an independent platform — not a UGC-recognised university or board. We are upfront about that. The certificate is most useful as a verifiable signal that you have completed the curriculum, not as a substitute for a degree.

Which courses are best for BCA and MCA students?

Our University Curriculum section covers the YMCA BCA/MCA syllabus subject-by-subject — Data Structures, DBMS, Web Based Programming, Computer Networks, Operating Systems, Software Engineering, Data Warehousing and more. Each subject is broken down into the same units your university teaches, with previous year question papers where available.

Can I use Siksha Sarovar to prepare for SSC, UPSC, Banking or Railway exams?

Yes. The Competitive section has dedicated tracks for SSC (CGL, CHSL, MTS), UPSC, IBPS/SBI Banking, RRB Railways and defence exams (NDA, CDS, AFCAT). Topics include quantitative aptitude, reasoning, English grammar, general knowledge and current affairs, written specifically for the Indian exam pattern.

What languages does the online compiler support?

The Siksha Sarovar online compiler supports C, C++, Python, Java, PHP, JavaScript, C# and SQL. The compiler runs your code in a sandboxed environment using Judge0, returns the standard output and error stream, and supports stdin so you can test interactive programs. There is no installation — everything runs in your browser.

How is my personal data handled by Siksha Sarovar?

We follow data minimisation: we collect only what is needed (email, name, profile picture from Google sign-in, and your learning progress). Data is stored on Supabase with HTTPS in transit. We do not sell user data, and we do not use it to train AI models. You can request deletion at any time by emailing contact@sikshasarovar.com — see our Privacy Policy for the full details.

Who founded Siksha Sarovar?

Siksha Sarovar was founded by Rohit Kumar, who serves as CEO and Head Developer. Rohit built the platform to provide free, structured education to students across India — covering programming courses, university notes, school study material and competitive exam preparation.

2.9 Relationships, Cardinality & Cross-Filtering — Power BI Notes

Lesson 19 of 62 in the free Power BI notes on Siksha Sarovar, written by Rohit Jangra.

Creating Relationships Between Tables

Relationships define how tables connect to each other in the data model. They are essential for cross-table analysis and accurate calculations.

How to Create Relationships

Method 1: Auto-detect • Power BI automatically detects relationships based on matching column names • Go to File → Options → Current File → Data Load → Enable "Auto detect new relationships"

Method 2: Drag and Drop (Model View)

Go to Model View
Drag a column from one table to the matching column in another table
A relationship line appears between the tables

Method 3: Manage Relationships Dialog

Go to Home → Manage Relationships
Click New
Select the two tables and matching columns
Configure cardinality and cross-filter direction
Click OK

Cardinality

Cardinality defines the nature of the relationship between two tables — how many rows in one table relate to rows in another.

Cardinality	Description	Example
One-to-Many (1:*)	One row in Table A relates to multiple rows in Table B	One Customer → Many Orders
Many-to-One (*:1)	Many rows in Table A relate to one row in Table B	Many Orders → One Customer
One-to-One (1:1)	One row in Table A relates to exactly one row in Table B	One Employee → One ID Card
Many-to-Many (:)	Multiple rows in both tables relate to each other	Many Students → Many Courses

Best Practice: Most relationships should be **One-to-Many (1:)*, with the "one" side being the dimension table and the "many" side being the fact table.

Cross-Filter Direction

Cross-filtering determines how filters flow between related tables.

Direction	Description
Single	Filter flows from the "one" side to the "many" side only
Both (Bidirectional)	Filter flows in both directions

Default: Single direction (recommended) Bidirectional: Use cautiously — can cause ambiguity, performance issues, and unexpected results

When to Use Bidirectional: • When a slicer on a fact table needs to filter a dimension • In many-to-many relationships • For specific bridge table scenarios

Primary Key & Foreign Key

Primary Key (PK): • A column with unique values that identifies each row • Located in the dimension table (the "one" side) • Example: CustomerID in the Customers table

Foreign Key (FK): • A column that references the primary key of another table • Located in the fact table (the "many" side) • Example: CustomerID in the Sales table (references Customers.CustomerID)

Key Type	Location	Values	Purpose
Primary Key	Dimension table	Unique, no duplicates	Uniquely identify rows
Foreign Key	Fact table	Can repeat	Reference dimension rows

Relationship Best Practices

• Use Star Schema — fact table in center, dimensions around it • Prefer One-to-Many relationships • Avoid bidirectional cross-filtering unless absolutely necessary • Ensure primary key columns have no duplicates and no nulls • Use a Date dimension table for time-based analysis • Keep relationships simple — avoid complex chains of tables