1-darsDo‘kon va joylashuv ob'ektlari: Store_ID, Store_Name, Region, Country, ChannelChakana savdo analitikasi uchun do‘kon va joylashuv o‘lchov ob'ektlarini aniqlang. Do‘kon identifikatorlari, nomlari, viloyatlar, mamlakatlar va kanallarni modellashtirish va ushbu xususiyatlar geografik va kanal samaradorligi hisobotlarini qo‘llab-quvvatlashni o‘rganing.
Store_ID as the store business keyStore_Name standards and cleansingRegion and country hierarchiesChannel classification and mappingLocation attributes for filtering2-darsKalitlar, bog‘lanishlar va taxalluslar: moslangan o‘lchovlar va bir jadvalga bir nechta bog‘lanishlar uchun texnikalarMoslangan o‘lchovlarni qo‘llab-quvvatlash uchun kalitlar, bog‘lanishlar va taxalluslarni modellashtiring. Bir nechta faktlarga umumiy o‘lchovlarni bog‘lash, halqalardan qochish va universum sxemasida turli rollar yoki yo‘llarni ifodalash uchun jadval taxalluslari ishlatishni o‘rganing.
Natural versus surrogate keys in designInner and outer join choicesCreating and using table aliasesResolving join loops with contextsValidating join paths with sample queries3-darsAsosiy universum ob'ektlari: Sales_Revenue (sum), Units_Sold (sum), Gross_Margin (sum), Discount_Amount (sum)Foydalanuvchilar tayanadigan asosiy savdo fakt o‘lchovlarini loyihalang. Daromad, birliklar, marja va chegirmalarni qo‘shiladigan o‘lchovlar sifatida modellashtirish, agregatsiya xulqini aniqlash va universumda har bir ko‘rsatkich orqasidagi biznes qoidalarini hujjatlashtirishni o‘rganing.
Business definition of Sales_RevenueUnits_Sold measure and aggregation rulesGross_Margin calculation and validationDiscount_Amount sourcing and logicMeasure formatting and number scaling4-darsHosil qilingan va hisoblangan ob'ektlar: Margin_Pct, Stock_Turnover, Days_of_Inventory, Slow_Mover_Flag o‘zgaruvchilariBiznes mantiqini o‘rab oladigan hosil qilingan va hisoblangan ob'ektlarni yarating. Marja foizi, zaxira aylanmasi, inventar kunlari va sekin harakatlanuvchi belgilarni qurish, formulalarni saqlab qolish va yaxshi hujjatlashtirishni o‘rganing.
Margin_Pct formula and rounding rulesStock_Turnover calculation optionsDays_of_Inventory business definitionSlow_Mover_Flag thresholds and logicValidating derived metrics with samples5-darsQo‘shimcha universum ob'ektlari: Selling_Price (detail), Cost_of_Goods_Sold (detail), Stock_Level (snapshot), Stock_Value (calculated)Tahlilni boyitadigan qo‘shimcha tafsilot va snapshot o‘lchovlarini modellashtiring. Sotish narxi, sotilgan tovarlar xarajatini, zaxira darajasini va zaxira qiymatini ochish va hisobotlarda tafsilot yoki agregatsiyalangan ob'ektlardan qachon foydalanishni tushuning.
Selling_Price as a detail objectCost_of_Goods_Sold sourcing and rulesStock_Level as a snapshot measureStock_Value as a calculated measureChoosing detail versus aggregated objects6-darsBir nechta fakt jadvallari bilan ishlash: fan va chasm tuzoqlarini oldini olish uchun bog‘lanish turlari, kontekstlar va taxalluslarBir universum ichida bir nechta fakt jadvallarini xavfsiz boshqaring. Fan va chasm tuzoqlaridan qochish uchun bog‘lanish strategiyalari, kontekstlar va taxalluslarni o‘rganing, savdo va zaxira hisobotlari aniq va takrorlanmagan natijalarni qaytarishini ta'minlang.
Identifying fan and chasm trap patternsJoin strategies for multiple fact tablesUsing contexts to isolate fact combinationsAliases to separate incompatible joinsTesting combined sales and stock queries7-darsO‘lchov ob'ektlari: Product_ID, SKU, Product_Category, Product_Subcategory, BrandTahlil uchun mustahkam mahsulot o‘lchov ob'ektlarini loyihalang. ID lar, SKU lar, kategoriyalar, subkategoriyalar va brendlarni ochish, sekin o‘zgaruvchi xususiyatlarni boshqarish va barcha fakt jadvallari bo‘yicha izchil mahsulot rolluplarini ta'minlashni o‘rganing.
Product_ID as primary business keySKU granularity and uniquenessProduct_Category hierarchy designProduct_Subcategory relationshipsBrand attributes and reporting use8-darsIkki marta hisoblashning oldini olish: aniq granulani aniqlash, agregatsiya-bilikli kontekstlardan foydalanish va yarim qo‘shiladigan o‘lchovlarni tushuntirishAgregatsiyalangan hisobotlarda ikki marta hisoblashning oldini olishni tushuning. Aniq fakt granulalarini aniqlash, agregatsiya-bilikli ob'ektlar va kontekstlardan foydalanish va zaxira va balanslar kabi yarim qo‘shiladigan o‘lchovlarni vaqt bo‘yicha to‘g‘ri boshqarishni o‘rganing.
Defining a clear and consistent fact grainAggregate-aware measures and objectsDesigning and using universe contextsSemi-additive measures across timeTesting reports for hidden double counting9-darsVaqt ob'ektlari: Calendar_Date, Fiscal_Year, Fiscal_Period, Week, Month_To_Date_FlagMoslashuvchan davr tahlili uchun vaqt o‘lchov ob'ektlarini loyihalang. Kalendar sanalari, fiskal yillar, fiskal davrlar, haftalar va oy oxirigacha belgilarni ochishni o‘rganing, izchil vaqtga asoslangan filtrlarni va taqqoslashlarni yoqing.
Calendar_Date as the base time keyFiscal_Year and Fiscal_Period mappingWeek and month attributes for groupingMonth_To_Date_Flag logic and usageHandling holidays and special periods10-darsFakt granulasi va modellashtirish: tranzaksiya darajasidagi savdo fakti va zaxira snapshot fakti, granul ta’sirlariHar bir jadval uchun fakt granulalarini aniqlang va hujjatlashtiring. Tranzaksiya darajasidagi savdo faktlari va zaxira snapshot faktlari farqini o‘rganing va granul tanlovlari agregatsiyalar, drill yo‘llari va hisobot samaradorligiga qanday ta’sir qilishini tushuning.
Transaction-level sales fact definitionStock snapshot fact grain and timingGrain alignment across related factsImpact of grain on aggregationsDocumenting grain for report designers11-darsSub'ekt hududlarini aniqlash: savdo fakti, zaxira fakti, mahsulot asosiy, do‘kon asosiy, kalendar o‘lchoviUniversum dizaynini boshqaradigan biznes sub'ekt hududlarini aniqlang. Savdo, zaxira, mahsulot, do‘kon va kalendar ma’lumotlari fakt va o‘lchov jadvallariga qanday xaritalash va ushbu ajratish moslashuvchan, izchil hisobotlarni qo‘llab-quvvatlashini o‘rganing.
Sales fact subject area definitionStock fact subject area definitionProduct master as a conformed dimensionStore master and location coverageCalendar dimension business requirements12-darsAudit va lineage maydonlari: Data_Source, Load_Timestamp, Record_Status nosozliklarni bartaraf etish va moslashtirish uchunUniversumga audit va lineage maydonlarini kiriting. Data_Source, Load_Timestamp va Record_Status nosozliklarni bartaraf etish, moslashtirish va foydalanuvchi ishonchini qo‘llab-quvvatlash va ularni yakuniy foydalanuvchilarni chalkashtirmasdan ochishni o‘rganing.
Purpose of Data_Source in reportingUsing Load_Timestamp for recency checksRecord_Status for active or deleted rowsDesigning audit objects for power usersReconciliation techniques using audit data
