feat: not found topics

.astro/types.d.ts

@@ -1,2 +1 @@
 /// <reference types="astro/client" />
-/// <reference path="content.d.ts" />

.github/workflows/sync-content-to-repo.yml

@@ -50,9 +50,8 @@ jobs:
           branch: "chore/sync-content-to-repo-${{ inputs.roadmap_slug }}"
           base: "master"
           labels: |
-            dependencies
             automated pr
-          reviewers: arikchakma
+          reviewers: jcanalesluna,kamranahmedse
           commit-message: "chore: sync content to repo"
           title: "chore: sync content to repository - ${{ inputs.roadmap_slug }}"
           body: |
@@ -64,4 +63,4 @@ jobs:
             > Commit: ${{ github.sha }}
             > Workflow Path: ${{ github.workflow_ref }}
 
-            **Please Review the Changes and Merge the PR if everything is fine.** 
+            **Please Review the Changes and Merge the PR if everything is fine.** 

package.json

@@ -31,6 +31,7 @@
     "migrate:editor-roadmaps": "tsx ./scripts/migrate-editor-roadmap.ts",
     "sync:content-to-repo": "tsx ./scripts/sync-content-to-repo.ts",
     "sync:repo-to-database": "tsx ./scripts/sync-repo-to-database.ts",
+    "migrate:content-repo-to-database": "tsx ./scripts/migrate-content-repo-to-database.ts",
     "test:e2e": "playwright test"
   },
   "dependencies": {

readme.md

@@ -47,6 +47,7 @@ Here is the list of available roadmaps with more being actively worked upon.
 - [Linux Roadmap](https://roadmap.sh/linux)
 - [Terraform Roadmap](https://roadmap.sh/terraform)
 - [Data Analyst Roadmap](https://roadmap.sh/data-analyst)
+- [BI Analyst Roadmap](https://roadmap.sh/bi-analyst)
 - [Data Engineer Roadmap](https://roadmap.sh/data-engineer)
 - [Machine Learning Roadmap](https://roadmap.sh/machine-learning)
 - [MLOps Roadmap](https://roadmap.sh/mlops)

scripts/migrate-content-repo-to-database.ts

@@ -0,0 +1,255 @@
+import fs from 'node:fs/promises';
+import path from 'node:path';
+import { fileURLToPath } from 'node:url';
+import type { OfficialRoadmapDocument } from '../src/queries/official-roadmap';
+import { parse } from 'node-html-parser';
+import { markdownToHtml } from '../src/lib/markdown';
+import { htmlToMarkdown } from '../src/lib/html';
+import matter from 'gray-matter';
+import type { RoadmapFrontmatter } from '../src/lib/roadmap';
+import {
+  allowedOfficialRoadmapTopicResourceType,
+  type AllowedOfficialRoadmapTopicResourceType,
+  type SyncToDatabaseTopicContent,
+} from '../src/queries/official-roadmap-topic';
+
+const __filename = fileURLToPath(import.meta.url);
+const __dirname = path.dirname(__filename);
+
+const args = process.argv.slice(2);
+const secret = args
+  .find((arg) => arg.startsWith('--secret='))
+  ?.replace('--secret=', '');
+if (!secret) {
+  throw new Error('Secret is required');
+}
+
+let roadmapJsonCache: Map<string, OfficialRoadmapDocument> = new Map();
+export async function fetchRoadmapJson(
+  roadmapId: string,
+): Promise<OfficialRoadmapDocument> {
+  if (roadmapJsonCache.has(roadmapId)) {
+    return roadmapJsonCache.get(roadmapId)!;
+  }
+
+  const response = await fetch(
+    `https://roadmap.sh/api/v1-official-roadmap/${roadmapId}`,
+  );
+
+  if (!response.ok) {
+    throw new Error(
+      `Failed to fetch roadmap json: ${response.statusText} for ${roadmapId}`,
+    );
+  }
+
+  const data = await response.json();
+  if (data.error) {
+    throw new Error(
+      `Failed to fetch roadmap json: ${data.error} for ${roadmapId}`,
+    );
+  }
+
+  roadmapJsonCache.set(roadmapId, data);
+  return data;
+}
+
+export async function syncContentToDatabase(
+  topics: SyncToDatabaseTopicContent[],
+) {
+  const response = await fetch(
+    `https://roadmap.sh/api/v1-sync-official-roadmap-topics`,
+    {
+      method: 'POST',
+      headers: {
+        'Content-Type': 'application/json',
+      },
+      body: JSON.stringify({
+        topics,
+        secret,
+      }),
+    },
+  );
+
+  if (!response.ok) {
+    const error = await response.json();
+    throw new Error(
+      `Failed to sync content to database: ${response.statusText} ${JSON.stringify(error, null, 2)}`,
+    );
+  }
+
+  return response.json();
+}
+
+// Directory containing the roadmaps
+const ROADMAP_CONTENT_DIR = path.join(__dirname, '../src/data/roadmaps');
+const allRoadmaps = await fs.readdir(ROADMAP_CONTENT_DIR);
+
+const editorRoadmapIds = new Set<string>();
+for (const roadmapId of allRoadmaps) {
+  const roadmapFrontmatterDir = path.join(
+    ROADMAP_CONTENT_DIR,
+    roadmapId,
+    `${roadmapId}.md`,
+  );
+  const roadmapFrontmatterRaw = await fs.readFile(
+    roadmapFrontmatterDir,
+    'utf-8',
+  );
+  const { data } = matter(roadmapFrontmatterRaw);
+
+  const roadmapFrontmatter = data as RoadmapFrontmatter;
+  if (roadmapFrontmatter.renderer === 'editor') {
+    editorRoadmapIds.add(roadmapId);
+  }
+}
+
+for (const roadmapId of editorRoadmapIds) {
+  try {
+    const roadmap = await fetchRoadmapJson(roadmapId);
+
+    const files = await fs.readdir(
+      path.join(ROADMAP_CONTENT_DIR, roadmapId, 'content'),
+    );
+
+    console.log(`🚀 Starting ${files.length} files for ${roadmapId}`);
+    const topics: SyncToDatabaseTopicContent[] = [];
+
+    for (const file of files) {
+      const isContentFile = file.endsWith('.md');
+      if (!isContentFile) {
+        console.log(`🚨 Skipping ${file} because it is not a content file`);
+        continue;
+      }
+
+      const nodeSlug = file.replace('.md', '');
+      if (!nodeSlug) {
+        console.error(`🚨 Node id is required: ${file}`);
+        continue;
+      }
+
+      const nodeId = nodeSlug.split('@')?.[1];
+      if (!nodeId) {
+        console.error(`🚨 Node id is required: ${file}`);
+        continue;
+      }
+
+      const node = roadmap.nodes.find((node) => node.id === nodeId);
+      if (!node) {
+        console.error(`🚨 Node not found: ${file}`);
+        continue;
+      }
+
+      const filePath = path.join(
+        ROADMAP_CONTENT_DIR,
+        roadmapId,
+        'content',
+        `${nodeSlug}.md`,
+      );
+
+      const fileExists = await fs
+        .stat(filePath)
+        .then(() => true)
+        .catch(() => false);
+      if (!fileExists) {
+        console.log(`🚨 File not found: ${filePath}`);
+        continue;
+      }
+
+      const content = await fs.readFile(filePath, 'utf8');
+      const html = markdownToHtml(content, false);
+      const rootHtml = parse(html);
+
+      let ulWithLinks: HTMLElement | undefined;
+      rootHtml.querySelectorAll('ul').forEach((ul) => {
+        const listWithJustLinks = Array.from(ul.querySelectorAll('li')).filter(
+          (li) => {
+            const link = li.querySelector('a');
+            return link && link.textContent?.trim() === li.textContent?.trim();
+          },
+        );
+
+        if (listWithJustLinks.length > 0) {
+          // @ts-expect-error - TODO: fix this
+          ulWithLinks = ul;
+        }
+      });
+
+      const listLinks: SyncToDatabaseTopicContent['resources'] =
+        ulWithLinks !== undefined
+          ? Array.from(ulWithLinks.querySelectorAll('li > a'))
+              .map((link) => {
+                const typePattern = /@([a-z.]+)@/;
+                let linkText = link.textContent || '';
+                const linkHref = link.getAttribute('href') || '';
+                let linkType = linkText.match(typePattern)?.[1] || 'article';
+                linkType = allowedOfficialRoadmapTopicResourceType.includes(
+                  linkType as any,
+                )
+                  ? linkType
+                  : 'article';
+
+                linkText = linkText.replace(typePattern, '');
+
+                if (!linkText || !linkHref) {
+                  return null;
+                }
+
+                return {
+                  title: linkText,
+                  url: linkHref,
+                  type: linkType as AllowedOfficialRoadmapTopicResourceType,
+                };
+              })
+              .filter((link) => link !== null)
+              .sort((a, b) => {
+                const order = [
+                  'official',
+                  'opensource',
+                  'article',
+                  'video',
+                  'feed',
+                ];
+                return order.indexOf(a!.type) - order.indexOf(b!.type);
+              })
+          : [];
+
+      const title = rootHtml.querySelector('h1');
+      ulWithLinks?.remove();
+      title?.remove();
+
+      const allParagraphs = rootHtml.querySelectorAll('p');
+      if (listLinks.length > 0 && allParagraphs.length > 0) {
+        // to remove the view more see more from the description
+        const lastParagraph = allParagraphs[allParagraphs.length - 1];
+        lastParagraph?.remove();
+      }
+
+      const htmlStringWithoutLinks = rootHtml.toString();
+      const description = htmlToMarkdown(htmlStringWithoutLinks);
+
+      const updatedDescription =
+        `# ${title?.textContent}\n\n${description}`.trim();
+
+      const label = node?.data?.label as string;
+      if (!label) {
+        console.error(`🚨 Label is required: ${file}`);
+        continue;
+      }
+
+      topics.push({
+        roadmapSlug: roadmapId,
+        nodeId,
+        description: updatedDescription,
+        resources: listLinks,
+      });
+    }
+
+    await syncContentToDatabase(topics);
+    console.log(
+      `✅ Synced ${topics.length} topics to database for ${roadmapId}`,
+    );
+  } catch (error) {
+    console.error(error);
+    process.exit(1);
+  }
+}

scripts/sync-content-to-repo.ts

@@ -3,6 +3,7 @@ import path from 'node:path';
 import { fileURLToPath } from 'node:url';
 import { slugify } from '../src/lib/slugger';
 import type { OfficialRoadmapDocument } from '../src/queries/official-roadmap';
+import type { OfficialRoadmapTopicContentDocument } from '../src/queries/official-roadmap-topic';
 
 const __filename = fileURLToPath(import.meta.url);
 const __dirname = path.dirname(__filename);
@@ -19,36 +20,6 @@ if (!roadmapSlug || roadmapSlug === '__default__') {
 }
 
 console.log(`🚀 Starting ${roadmapSlug}`);
-export const allowedOfficialRoadmapTopicResourceType = [
-  'roadmap',
-  'official',
-  'opensource',
-  'article',
-  'course',
-  'podcast',
-  'video',
-  'book',
-  'feed',
-] as const;
-export type AllowedOfficialRoadmapTopicResourceType =
-  (typeof allowedOfficialRoadmapTopicResourceType)[number];
-
-export type OfficialRoadmapTopicResource = {
-  _id?: string;
-  type: AllowedOfficialRoadmapTopicResourceType;
-  title: string;
-  url: string;
-};
-
-export interface OfficialRoadmapTopicContentDocument {
-  _id?: string;
-  roadmapSlug: string;
-  nodeId: string;
-  description: string;
-  resources: OfficialRoadmapTopicResource[];
-  createdAt: Date;
-  updatedAt: Date;
-}
 
 export async function roadmapTopics(
   roadmapId: string,

scripts/sync-repo-to-database.ts

@@ -5,37 +5,11 @@ import type { OfficialRoadmapDocument } from '../src/queries/official-roadmap';
 import { parse } from 'node-html-parser';
 import { markdownToHtml } from '../src/lib/markdown';
 import { htmlToMarkdown } from '../src/lib/html';
-
-export const allowedOfficialRoadmapTopicResourceType = [
-  'roadmap',
-  'official',
-  'opensource',
-  'article',
-  'course',
-  'podcast',
-  'video',
-  'book',
-  'feed',
-] as const;
-export type AllowedOfficialRoadmapTopicResourceType =
-  (typeof allowedOfficialRoadmapTopicResourceType)[number];
-
-export type OfficialRoadmapTopicResource = {
-  _id?: string;
-  type: AllowedOfficialRoadmapTopicResourceType;
-  title: string;
-  url: string;
-};
-
-export interface OfficialRoadmapTopicContentDocument {
-  _id?: string;
-  roadmapSlug: string;
-  nodeId: string;
-  description: string;
-  resources: OfficialRoadmapTopicResource[];
-  createdAt: Date;
-  updatedAt: Date;
-}
+import {
+  allowedOfficialRoadmapTopicResourceType,
+  type AllowedOfficialRoadmapTopicResourceType,
+  type SyncToDatabaseTopicContent,
+} from '../src/queries/official-roadmap-topic';
 
 const __filename = fileURLToPath(import.meta.url);
 const __dirname = path.dirname(__filename);
@@ -82,10 +56,7 @@ export async function fetchRoadmapJson(
 }
 
 export async function syncContentToDatabase(
-  topics: Omit<
-    OfficialRoadmapTopicContentDocument,
-    'createdAt' | 'updatedAt' | '_id'
-  >[],
+  topics: SyncToDatabaseTopicContent[],
 ) {
   const response = await fetch(
     `https://roadmap.sh/api/v1-sync-official-roadmap-topics`,
@@ -125,10 +96,7 @@ console.log(`🚀 Starting ${files.length} files`);
 const ROADMAP_CONTENT_DIR = path.join(__dirname, '../src/data/roadmaps');
 
 try {
-  const topics: Omit<
-    OfficialRoadmapTopicContentDocument,
-    'createdAt' | 'updatedAt' | '_id'
-  >[] = [];
+  const topics: SyncToDatabaseTopicContent[] = [];
 
   for (const file of files) {
     const isContentFile = file.endsWith('.md') && file.includes('content/');
@@ -198,7 +166,7 @@ try {
       }
     });
 
-    const listLinks: Omit<OfficialRoadmapTopicResource, '_id'>[] =
+    const listLinks: SyncToDatabaseTopicContent['resources'] =
       ulWithLinks !== undefined
         ? Array.from(ulWithLinks.querySelectorAll('li > a'))
             .map((link) => {

src/components/Roadmaps/RoadmapsPage.tsx

@@ -408,6 +408,11 @@ const groups: GroupType[] = [
         link: '/data-analyst',
         type: 'role',
       },
+      {
+        title: 'BI Analyst',
+        link: '/bi-analyst',
+        type: 'role',
+      },
       {
         title: 'Data Engineer',
         link: '/data-engineer',

src/data/roadmaps/bi-analyst/bi-analyst.md

@@ -0,0 +1,49 @@
+---
+pdfUrl: '/pdfs/roadmaps/bi-analyst.pdf'
+jsonUrl: '/jsons/roadmaps/bi-analyst.json'
+order: 21
+title: 'BI Analyst'
+description: 'Learn to become a Business Intelligence Analyst in 2025'
+briefTitle: 'BI Analyst'
+briefDescription: 'Learn to become a Business Intelligence Analyst in 2025'
+hasTopics: true
+isHidden: false
+isUpcoming: false
+isNew: true
+dimensions:
+  width: 968
+  height: 5120
+schema:
+  headline: 'BI Analyst'
+  description: 'Learn what business intelligence analysis is, what BI analysts do and how to become one using our community-driven roadmap.'
+  datePublished: '2025-08-21'
+  dateModified: '2025-08-21'
+  imageUrl: 'https://roadmap.sh/roadmaps/bi-analyst.png'
+seo:
+  title: 'BI Analyst'
+  description: 'Learn what business intelligence analysis is, what BI analysts do and how to become one using our community-driven roadmap.'
+  keywords:
+    - 'bi analyst'
+    - 'bi analyst roadmap'
+    - 'bi analyst roadmap 2025'
+    - 'Business Intelligence'
+    - 'become a BI Analyst'
+    - 'data analytics'
+    - 'business intelligence analyst'
+    - 'analytical skills'
+    - 'data visualization'
+    - 'career roadmap'
+relatedRoadmaps:
+  - 'data-analyst'
+  - 'sql'
+  - 'python'
+  - 'ai-data-scientist'
+sitemap:
+  priority: 1
+  changefreq: monthly
+tags:
+  - 'roadmap'
+  - 'main-sitemap'
+  - 'role-roadmap'
+renderer: editor
+---

src/data/roadmaps/bi-analyst/content/ab-testing@qKlo90-Cy8t_off5Qv8-6.md

@@ -0,0 +1 @@
+# A/B Testing

src/data/roadmaps/bi-analyst/content/accesibility@BiyrAHB34evej_0cnDzOa.md

@@ -0,0 +1 @@
+# Accesibility

src/data/roadmaps/bi-analyst/content/accessibility@wtEzdO_ZNu9jHJrFS3CrG.md

@@ -0,0 +1 @@
+# Accessibility

src/data/roadmaps/bi-analyst/content/accuracy@M1H3Fh09v8udCJIPSJPic.md

@@ -0,0 +1 @@
+# Accuracy

src/data/roadmaps/bi-analyst/content/advanced-queries@-gbb16Wl--Rjx5aoM0krL.md

@@ -0,0 +1 @@
+# Advanced Queries

src/data/roadmaps/bi-analyst/content/airflow@qnUHw2f2VmTPU3-NMnoLl.md

@@ -0,0 +1 @@
+# Airflow

src/data/roadmaps/bi-analyst/content/algorithmic-bias@_uLtsnyNNNRcz5A29Zpjl.md

@@ -0,0 +1 @@
+# Algorithmic Bias

src/data/roadmaps/bi-analyst/content/analog-vs-digital-data@kb216tShKrRPWv7mE9sVa.md

@@ -0,0 +1 @@
+# Analog vs Digital Data

src/data/roadmaps/bi-analyst/content/apis@xQDGmVwUkrmGdviOdG8Hu.md

@@ -0,0 +1 @@
+# APIs

src/data/roadmaps/bi-analyst/content/barplot@BUizLtQ7vpdyBRjS8KyIl.md

@@ -0,0 +1 @@
+# Barplot

src/data/roadmaps/bi-analyst/content/basic-machine-learning@ZGazuCNruu09bd7C-aSFC.md

@@ -0,0 +1 @@
+# Basic Machine Learning

src/data/roadmaps/bi-analyst/content/basic-queries@TuBJ2yUz1c5KMRGVHdvU5.md

@@ -0,0 +1 @@
+# Basic Queries

src/data/roadmaps/bi-analyst/content/beyond-linear-regression@_QyIZ2_vH3e3yic5NTuak.md

@@ -0,0 +1 @@
+# Beyond Linear Regression

src/data/roadmaps/bi-analyst/content/bi-analyst-vs-other-roles@JFNCITtE1YtcYmLfGfF5T.md

@@ -0,0 +1,3 @@
+# BI Analyst vs. Other Roles
+
+A BI Analyst focuses on analyzing data to provide insights and recommendations for business improvements. This role differs from other data-related roles like Data Scientists, who build predictive models, or Data Engineers, who focus on building and maintaining data infrastructure. While a BI Analyst uses data to understand past and current performance, other roles might focus on predicting future outcomes or ensuring the data is readily available for analysis.

src/data/roadmaps/bi-analyst/content/bi-communities@X8U-NQD0rYqFr_xgDWL2s.md

@@ -0,0 +1 @@
+# BI Communities

src/data/roadmaps/bi-analyst/content/bi-competitions@aTGsJj7Ntv5BWIzjaqvu_.md

@@ -0,0 +1 @@
+# BI Competitions

src/data/roadmaps/bi-analyst/content/bi-platforms@kpRqKLtAd3IO3nbs8Yxrh.md

@@ -0,0 +1 @@
+# BI Platforms

src/data/roadmaps/bi-analyst/content/bias-recognition@9aNVqEyygNGeicdce5X8b.md

@@ -0,0 +1 @@
+# Bias Recognition

src/data/roadmaps/bi-analyst/content/building-your-portfolio@UIdwl_KLELI8xL2VxYJmX.md

@@ -0,0 +1 @@
+# Building Your Portfolio

src/data/roadmaps/bi-analyst/content/business-acumen@OmhvVSTtzH5sxOIZRVYfQ.md

@@ -0,0 +1 @@
+# Business Acumen

src/data/roadmaps/bi-analyst/content/calculated-fields--measures@fFzCnLfZ_vSbhQjdAKLlJ.md

@@ -0,0 +1 @@
+# Calculated Fields & Measures

src/data/roadmaps/bi-analyst/content/categorical-vs-numerical@yXz6MkU3-HnlkmRmYh-Ev.md

@@ -0,0 +1 @@
+# Categorical vs Numerical

src/data/roadmaps/bi-analyst/content/ccpa@IwnXDA-f3FHK4EEeFuToC.md

@@ -0,0 +1 @@
+# CCPA

src/data/roadmaps/bi-analyst/content/central-tendency@F-fC2JWOuEeDbOHH1O6EB.md

@@ -0,0 +1 @@
+# Central Tendency

src/data/roadmaps/bi-analyst/content/certifications@hqpFbDhAvyT9_4hcoSLhC.md

@@ -0,0 +1 @@
+# Certifications

src/data/roadmaps/bi-analyst/content/change-management@vDQF2oaybSewNu3EMs6zG.md

@@ -0,0 +1 @@
+# Change Management

src/data/roadmaps/bi-analyst/content/chart-categories@GVgfPajmSqIgFZ6u2I1tK.md

@@ -0,0 +1 @@
+# Chart Categories

src/data/roadmaps/bi-analyst/content/cloud-bi-ecosystem@zGU6DyEm6xEYf1_73cbjL.md

@@ -0,0 +1 @@
+# Cloud BI Ecosystem

src/data/roadmaps/bi-analyst/content/cloud-computing-basics@_KYKLd-RNhVy-Sn1A-G5j.md

@@ -0,0 +1 @@
+# Cloud Computing Basics

src/data/roadmaps/bi-analyst/content/cloud-data-warehouses@D94743lQ1fAerVSpJWXfP.md

@@ -0,0 +1 @@
+# Cloud data warehouses

src/data/roadmaps/bi-analyst/content/cloud@WXk0-vebMUQC25he2lmbh.md

@@ -0,0 +1 @@
+# Cloud

src/data/roadmaps/bi-analyst/content/clv@OqHNW0PzIRsw7IBgh5U5Q.md

@@ -0,0 +1 @@
+# CLV

src/data/roadmaps/bi-analyst/content/coherence@4U66ZrBZqg7-ckOTmxAQj.md

@@ -0,0 +1 @@
+# Coherence

src/data/roadmaps/bi-analyst/content/cohort-analysis@R2zg0Ql-RsnIkV5Gmc1vN.md

@@ -0,0 +1 @@
+# Cohort Analysis

src/data/roadmaps/bi-analyst/content/color-theory@SJGEkoTSPK2ck4IvaK6Gz.md

@@ -0,0 +1 @@
+# Color theory

src/data/roadmaps/bi-analyst/content/communication--storytelling@TBcLXYtKs7_j_h_m2pAyh.md

@@ -0,0 +1 @@
+# Communication & Storytelling

src/data/roadmaps/bi-analyst/content/compliance-reporting@j-GXKpMnsVuUUUdRxAXLe.md

@@ -0,0 +1 @@
+# Compliance Reporting

src/data/roadmaps/bi-analyst/content/compliance-reporting@omvGuhou7_63k-Fwcc7Mu.md

@@ -0,0 +1 @@
+# Compliance Reporting

src/data/roadmaps/bi-analyst/content/conferences--webinars@UDF8wyYT8127wfFHcq37P.md

@@ -0,0 +1 @@
+# Conferences & Webinars

src/data/roadmaps/bi-analyst/content/confidence-intervals@xgP3zIiSEr9dtYcCQikPb.md

@@ -0,0 +1 @@
+# Confidence Intervals

src/data/roadmaps/bi-analyst/content/correlation-analysis@ASHk2LOjlhwpwpWSRs_Bi.md

@@ -0,0 +1 @@
+# Correlation Analysis

src/data/roadmaps/bi-analyst/content/correlation-vs-causation@JXYmXAYuA-zxrkl4PRLQd.md

@@ -0,0 +1 @@
+# Correlation vs Causation

src/data/roadmaps/bi-analyst/content/critical-thinking@NFKiPXrkjRre1yUZc27gl.md

@@ -0,0 +1 @@
+# Critical Thinking

src/data/roadmaps/bi-analyst/content/csv@LcLfC6BiOxJAkk2p424wL.md

@@ -0,0 +1 @@
+# CSV

src/data/roadmaps/bi-analyst/content/dashboard-design@KXhNou5nlekbSTfLYPs_8.md

@@ -0,0 +1 @@
+# Dashboard Design

src/data/roadmaps/bi-analyst/content/dashboard-design@qvPTiDbsY5ol_K-BNLmzk.md

@@ -0,0 +1 @@
+# Dashboard Design

src/data/roadmaps/bi-analyst/content/data-architectures@Zxuvc9F3bINLTdfbsx_S_.md

@@ -0,0 +1 @@
+# Data Architectures

src/data/roadmaps/bi-analyst/content/data-cleaning@Vo7LJ_W-DBvxvVrnz33BM.md

@@ -0,0 +1 @@
+# Data Cleaning

src/data/roadmaps/bi-analyst/content/data-formats@GsZWvJPNzN6XLDp2G1db4.md

@@ -0,0 +1 @@
+# Data Formats

src/data/roadmaps/bi-analyst/content/data-lake@iqpVtvoebAaoB_Dj9-gdw.md

@@ -0,0 +1 @@
+# Data Lake

src/data/roadmaps/bi-analyst/content/data-lineage@F21ypKzpziLCXkiKG1S5Z.md

@@ -0,0 +1 @@
+# Data Lineage

src/data/roadmaps/bi-analyst/content/data-mart@5x4NfuP6dAgjISlB-esIW.md

@@ -0,0 +1 @@
+# Data Mart

src/data/roadmaps/bi-analyst/content/data-modeling-for-bi@Dk31XtS7wWRzO31sdsEDo.md

@@ -0,0 +1 @@
+# Data Modeling for BI

src/data/roadmaps/bi-analyst/content/data-pipeline-design@yvSf7sGEd7QiaVoetalHc.md

@@ -0,0 +1 @@
+# Data Pipeline Design

src/data/roadmaps/bi-analyst/content/data-quality@bGCMAgaenZ0t3WeO5joyP.md

@@ -0,0 +1 @@
+# Data Quality

src/data/roadmaps/bi-analyst/content/data-sources@VUgxDDkoxkOcLxqpTDXzt.md

@@ -0,0 +1 @@
+# Data Sources

src/data/roadmaps/bi-analyst/content/data-transformation-techniques@hrkMVMYWCedRxhNd2N9wE.md

@@ -0,0 +1 @@
+# Data Transformation Techniques

src/data/roadmaps/bi-analyst/content/data-warehouse@wJiKBbTMLhIzelUtKn7jl.md

@@ -0,0 +1 @@
+# Data Warehouse

src/data/roadmaps/bi-analyst/content/databases@g44bQY90HOeI_dZ8gK2Uj.md

@@ -0,0 +1 @@
+# Databases

src/data/roadmaps/bi-analyst/content/dbt@-KzusmyDQ1NgqOADpqmEX.md

@@ -0,0 +1 @@
+# dbt

src/data/roadmaps/bi-analyst/content/descriptive-analysis@vTW3jSZ1bvc0OrP_bl22t.md

@@ -0,0 +1 @@
+# Descriptive Analysis

src/data/roadmaps/bi-analyst/content/descriptive-statistics@xc1hm_XTyiMUVtWiTKXWG.md

@@ -0,0 +1 @@
+# Descriptive Statistics

src/data/roadmaps/bi-analyst/content/design-principles@EDQjtoTd01ftwXxYkV9it.md

@@ -0,0 +1 @@
+# Design principles

src/data/roadmaps/bi-analyst/content/diagnostic-analysis@m5aC9aNy9mwLXz0xXBp40.md

@@ -0,0 +1 @@
+# Diagnostic Analysis

src/data/roadmaps/bi-analyst/content/discrete-vs-continuous@YSxvg2HrfGoGtpkwY0kGc.md

@@ -0,0 +1 @@
+# Discrete vs Continuous

src/data/roadmaps/bi-analyst/content/dispersion@1D98k1HNCaaiaI20euVwA.md

@@ -0,0 +1 @@
+# Dispersion

src/data/roadmaps/bi-analyst/content/distribution@JSqwWsfojjZTe8ynmA7fc.md

@@ -0,0 +1 @@
+# Distribution

src/data/roadmaps/bi-analyst/content/dplyr@ZAhjB_ghHukD4RPAtNDxh.md

@@ -0,0 +1 @@
+# dplyr

src/data/roadmaps/bi-analyst/content/duplicates@xjgqmJmetKpWXSWZHPwaL.md

@@ -0,0 +1 @@
+# Duplicates

src/data/roadmaps/bi-analyst/content/end-to-end-analytics-project@3xDVJwdl3uu5EcjlZ1ytA.md

@@ -0,0 +1 @@
+# End-to-end Analytics Project

src/data/roadmaps/bi-analyst/content/ethical-data-use@Vb06K0D2vWAlSe95QJrth.md

@@ -0,0 +1 @@
+# Ethical Data Use

src/data/roadmaps/bi-analyst/content/etl-basics@Du4GD-6pxbWYl4uSJRnOE.md

@@ -0,0 +1 @@
+# ETL basics

src/data/roadmaps/bi-analyst/content/etl-tools@lAK9QVs97hL3ysjz2blp8.md

@@ -0,0 +1 @@
+# ETL Tools

src/data/roadmaps/bi-analyst/content/excel@9BWyA0b4WrmQetSMph_mY.md

@@ -0,0 +1 @@
+# Excel

src/data/roadmaps/bi-analyst/content/excel@Dh62zxyyUHh0galD472p8.md

@@ -0,0 +1 @@
+# Excel

src/data/roadmaps/bi-analyst/content/excel@LLK3_hudKDX5d-fd98vlx.md

@@ -0,0 +1 @@
+# Excel

src/data/roadmaps/bi-analyst/content/exploratory-data-analysis-eda@ETT9eATuyLHQe2jPqaF5I.md

@@ -0,0 +1 @@
+# Exploratory Data Analysis (EDA)

src/data/roadmaps/bi-analyst/content/fact-vs-dimension-tables@hcbS18cpVxd55hVlUeLLT.md

@@ -0,0 +1 @@
+# Fact vs Dimension Tables

src/data/roadmaps/bi-analyst/content/finance@cxTriSZvrmXP4axKynIZW.md

@@ -0,0 +1 @@
+# Finance

src/data/roadmaps/bi-analyst/content/finance@xftv5BiyoVrFjpSN0tjsw.md

@@ -0,0 +1 @@
+# Finance

src/data/roadmaps/bi-analyst/content/financial-performance@1T2PyytlmndHreWgueD55.md

@@ -0,0 +1 @@
+# Financial Performance

src/data/roadmaps/bi-analyst/content/forecasting@ExHCSUDxDBwsJtTelvxjP.md

@@ -0,0 +1 @@
+# Forecasting

src/data/roadmaps/bi-analyst/content/fraud-detection@aJLGan5dkMefvkspFlcYo.md

@@ -0,0 +1 @@
+# Fraud Detection

src/data/roadmaps/bi-analyst/content/gdpr@CWf_vL78f8-mSUQbPnU8e.md

@@ -0,0 +1 @@
+# GDPR

src/data/roadmaps/bi-analyst/content/healthcare@VpGVezYr9O6puhAF12PN2.md

@@ -0,0 +1 @@
+# Healthcare

src/data/roadmaps/bi-analyst/content/heatmap@SNkYi2VZsCRG31v63v8_x.md

@@ -0,0 +1 @@
+# Heatmap

src/data/roadmaps/bi-analyst/content/histogram@wqLcUFVsLa_l9yQIee9MG.md

@@ -0,0 +1 @@
+# Histogram

src/data/roadmaps/bi-analyst/content/hospital-efficiency@ku3m0ZmNg23F0Z5CEb4JI.md

@@ -0,0 +1 @@
+# Hospital Efficiency