Assam is rapidly emerging as a digital innovation hub in Northeast India, driven by visionary policies and proactive governance under the Digital Assam initiative. With a growing IT ecosystem, expanding digital infrastructure, and a strong focus on e-Governance, the state is positioning itself at the forefront of India's digital transformation.
To further accelerate this journey, Elets Technomedia, in collaboration with the Information Technology Department, Government of Assam, is organising the National Digital Innovation Summit 2025 on 5-6 December in Guwahati. The summit will provide a platform for policymakers, industry leaders, innovators, and technologists to deliberate on strategies to advance the state's digital progress.
Sessions
Dynamic Speakers
of Special eGov Magazine
featuring cutting-edge solutions
Networking
An Initiative By
Knowledge Partner
Host Partner
Supporting Partner
Powered By
Banking Partner
Gold Partners
Digital Transformation Partner
Secured Communications Technology Partner
Associate Banking Partner
Technology Partner
Data Center Partner
E-Governance Partner
Branding Partners
Supporting Partners
| Item | Version / Requirement |
|------|-----------------------|
| SQL Server | 2019 or later (SSISDB catalog enabled) |
| SSIS | Visual Studio 2022 with the “SQL Server Integration Services Projects” extension |
| Source Files | StudentRecords.dbo.tblStudents (SQL), ArtworkCatalog.csv, TeacherDirectory.xlsx |
| Target | SchoolDashboard database (SQL) |
If any of these pieces need deeper detail (e.g., the exact SSIS XML, Power BI visual design, or a longer story), just let me know and I’ll expand the relevant section.
IF OBJECT_ID('dbo.SchoolDashboard') IS NULL
BEGIN
CREATE TABLE dbo.SchoolDashboard
(
DashboardID INT IDENTITY(1,1) PRIMARY KEY,
StudentID INT NOT NULL,
Is_HQ_Hinata BIT NOT NULL,
ArtworkTitle NVARCHAR(200) NULL,
Artist NVARCHAR(100) NULL,
IsArtMatched BIT NOT NULL,
LoadDate DATETIME DEFAULT GETDATE()
);
END
Create an SSIS package (named SSIS‑292) that:
Transforms the data:
Loads the cleaned data into a reporting schema (dbo.SchoolDashboard) that feeds a Power BI dashboard.
Marin immediately set to work. She scanned the envelope for hidden ink, using a UV light she kept in her backpack for science projects. A faint pattern emerged: a series of numbers—7‑4‑3‑1—written in a barely visible script.
Hinata, who loved puzzles as much as she loved running, recognized the numbers as coordinates. “The library’s floor plan has a grid,” she said, pointing to the schematic on the wall. “If we start at the seventh row, fourth column, and move three steps north, then one step east…”
The girls followed the path. It led them to a small alcove behind a row of old encyclopedias. Inside, tucked between a volume on ancient engineering and a textbook on modern physics, lay a brass key, its handle shaped like a stylized owl.
Madonna held the key up to the light. “The owl is the emblem of the school’s original crest,” she whispered. “It must open something important.”
Madonna Alvarez was the newest transfer student. She’d earned the nickname “Madonna” not because of any pop‑star fame, but because of her uncanny ability to stay calm and composed under pressure, a quality that reminded her classmates of the serene portrait of the Virgin Mary hanging in the school chapel.
Marin Takahashi, a shy but brilliant coder, had already made a name for herself by winning the regional robotics competition. Her quick fingers danced over keyboards as if she were playing a piano, and she could make any program sing.
Hinata Sato, the captain of the school’s track team, was known for her relentless drive. She could sprint the 100‑meter dash in under twelve seconds, and her leadership on the field translated into a natural ability to rally her friends when the stakes were high.
The three girls first met in the school’s library, a quiet sanctuary lined with towering shelves of dusty books. Madonna was scrolling through a digital archive of old school newspapers, Marin was debugging a piece of code on her laptop, and Hinata was sketching a strategy board for the upcoming inter‑school relay race.
A sudden flicker of light from a cracked window caught their attention. The three turned to see a thin, weather‑worn envelope slip out of a hidden compartment in the wall behind the ancient world‑history map.
Digital Transformation in Governance
Startups, Innovations & Entrepreneurial Growth in Northeast India
Artificial Intelligence (AI) for Inclusive Growth
Cloud, Data & Cybersecurity for a Secure Digital Future
Digital Infrastructure & Connectivity in Northeast India
Skilling, Capacity Building & Future Workforce Development
E-Governance & Citizen-Centric Service Delivery
| Item | Version / Requirement |
|------|-----------------------|
| SQL Server | 2019 or later (SSISDB catalog enabled) |
| SSIS | Visual Studio 2022 with the “SQL Server Integration Services Projects” extension |
| Source Files | StudentRecords.dbo.tblStudents (SQL), ArtworkCatalog.csv, TeacherDirectory.xlsx |
| Target | SchoolDashboard database (SQL) |
If any of these pieces need deeper detail (e.g., the exact SSIS XML, Power BI visual design, or a longer story), just let me know and I’ll expand the relevant section.
IF OBJECT_ID('dbo.SchoolDashboard') IS NULL
BEGIN
CREATE TABLE dbo.SchoolDashboard
(
DashboardID INT IDENTITY(1,1) PRIMARY KEY,
StudentID INT NOT NULL,
Is_HQ_Hinata BIT NOT NULL,
ArtworkTitle NVARCHAR(200) NULL,
Artist NVARCHAR(100) NULL,
IsArtMatched BIT NOT NULL,
LoadDate DATETIME DEFAULT GETDATE()
);
END
Create an SSIS package (named SSIS‑292) that:
Transforms the data:
Loads the cleaned data into a reporting schema (dbo.SchoolDashboard) that feeds a Power BI dashboard.
Marin immediately set to work. She scanned the envelope for hidden ink, using a UV light she kept in her backpack for science projects. A faint pattern emerged: a series of numbers—7‑4‑3‑1—written in a barely visible script.
Hinata, who loved puzzles as much as she loved running, recognized the numbers as coordinates. “The library’s floor plan has a grid,” she said, pointing to the schematic on the wall. “If we start at the seventh row, fourth column, and move three steps north, then one step east…”
The girls followed the path. It led them to a small alcove behind a row of old encyclopedias. Inside, tucked between a volume on ancient engineering and a textbook on modern physics, lay a brass key, its handle shaped like a stylized owl.
Madonna held the key up to the light. “The owl is the emblem of the school’s original crest,” she whispered. “It must open something important.”
Madonna Alvarez was the newest transfer student. She’d earned the nickname “Madonna” not because of any pop‑star fame, but because of her uncanny ability to stay calm and composed under pressure, a quality that reminded her classmates of the serene portrait of the Virgin Mary hanging in the school chapel.
Marin Takahashi, a shy but brilliant coder, had already made a name for herself by winning the regional robotics competition. Her quick fingers danced over keyboards as if she were playing a piano, and she could make any program sing.
Hinata Sato, the captain of the school’s track team, was known for her relentless drive. She could sprint the 100‑meter dash in under twelve seconds, and her leadership on the field translated into a natural ability to rally her friends when the stakes were high.
The three girls first met in the school’s library, a quiet sanctuary lined with towering shelves of dusty books. Madonna was scrolling through a digital archive of old school newspapers, Marin was debugging a piece of code on her laptop, and Hinata was sketching a strategy board for the upcoming inter‑school relay race.
A sudden flicker of light from a cracked window caught their attention. The three turned to see a thin, weather‑worn envelope slip out of a hidden compartment in the wall behind the ancient world‑history map.





































& many more...
Ritika Srivastava
+91- 9990108973Anuj Sharma
+91- 8860651650