Somo la 1Vipimo vya duka na eneo: Store_ID, Store_Name, Region, Country, ChannelFafanua vipimo vya duka na eneo kwa uchambuzi wa rejareja. Jifunze jinsi ya kuunda kitambulisho cha duka, majina, Mikoa, nchi, na njia, na jinsi sifa hizi zinasaidia ripoti ya utendaji wa jiografia na njia.
Store_ID as the store business keyStore_Name standards and cleansingRegion and country hierarchiesChannel classification and mappingLocation attributes for filteringSomo la 2Funguo, viunganisho, na majina: mbinu kwa vipimo vilivyolingana na viunganisho vingi kwenda kwenye meza ile ileUnda funguo, viunganisho, na majina ya kuingia ili kuunga mkono vipimo vilivyolingana. Jifunze jinsi ya kuunganisha vipimo vinavyoshirikiwa kwa ukweli mwingi, kuepuka peti, na kutumia majina ya meza kuwakilisha majukumu tofauti au njia katika muundo wa ulimwengu.
Natural versus surrogate keys in designInner and outer join choicesCreating and using table aliasesResolving join loops with contextsValidating join paths with sample queriesSomo la 3Vipimo vya ulimwengu vya msingi: Sales_Revenue (sum), Units_Sold (sum), Gross_Margin (sum), Discount_Amount (sum)Buni vipimo vya ukweli wa mauzo vinavyotegemewa na watumiaji. Jifunze jinsi ya kuunda mapato, vitengo, pembejeo, na punguzo kama vipimo vinavyoongezeka, fafanua tabia ya kuunganisha, na uandike sheria za biashara nyuma ya kila kipimo katika ulimwengu.
Business definition of Sales_RevenueUnits_Sold measure and aggregation rulesGross_Margin calculation and validationDiscount_Amount sourcing and logicMeasure formatting and number scalingSomo la 4Vipimo vilivyotokana na vilivyotolewa: tofauti kwa Margin_Pct, Stock_Turnover, Days_of_Inventory, Slow_Mover_FlagUnda vipimo vilivyotokana na vilivyotolewa vinavyojumuisha mantiki ya biashara. Jifunze jinsi ya kujenga asilimia ya pembejeo, kuzunguka kwa hesabu, siku za hesabu, na bendera za harakati polepole huku ukidumisha fomula zenye kudumishwa vizuri na kurekodi.
Margin_Pct formula and rounding rulesStock_Turnover calculation optionsDays_of_Inventory business definitionSlow_Mover_Flag thresholds and logicValidating derived metrics with samplesSomo la 5Vipimo vya ulimwengu vya ziada: Selling_Price (detail), Cost_of_Goods_Sold (detail), Stock_Level (snapshot), Stock_Value (calculated)Unda vipimo vya maelezo na picha za haraka vinavyoboresha uchambuzi. Jifunze jinsi ya kufunua bei ya kuuza, gharama ya bidhaa zilizouzwa, kiwango cha hesabu, na thamani ya hesabu, na kuelewa wakati wa kutumia maelezo dhidi ya vipimo vilivyounganishwa katika ripoti.
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 objectsSomo la 6Kushughulikia meza nyingi za ukweli: aina za viunganisho, muktadha, na majina kuzuia mitego ya feni na shimoShughulikia meza nyingi za ukweli kwa usalama ndani ya ulimwengu mmoja. Jifunze mikakati ya viunganisho, muktadha, na majina ili kuepuka mitego ya feni na shimo, kuhakikisha ripoti za mauzo na hesabu zimeripotiwa zina matokeo sahihi, yasiyo na mara mbili.
Identifying fan and chasm trap patternsJoin strategies for multiple fact tablesUsing contexts to isolate fact combinationsAliases to separate incompatible joinsTesting combined sales and stock queriesSomo la 7Vipimo vya vipimo: Product_ID, SKU, Product_Category, Product_Subcategory, BrandBuni vipimo vya vipimo vya bidhaa kwa uchambuzi thabiti. Jifunze jinsi ya kufunua ID, SKU, kategoria, vikategoria vidogo, na chapa, kudhibiti sifa zinazobadilika polepole, na kuhakikisha kuunganishwa kwa bidhaa kwa uwiano katika meza zote za ukweli.
Product_ID as primary business keySKU granularity and uniquenessProduct_Category hierarchy designProduct_Subcategory relationshipsBrand attributes and reporting useSomo la 8Kuepuka kuhesabu mara mbili: kufafanua nafaka wazi, matumizi ya muktadha unaofahamu jumla, maelezo ya vipimo vya kuongeza-nusuElewa jinsi ya kuzuia kuhesabu mara mbili katika ripoti zilizo na jumla. Jifunze kufafanua nafaka wazi ya ukweli, tumia vipimo na muktadha vinavyofahamu jumla, na kushughulikia vipimo vya kuongeza-nusu kama hesabu na salio kwa wakati.
Defining a clear and consistent fact grainAggregate-aware measures and objectsDesigning and using universe contextsSemi-additive measures across timeTesting reports for hidden double countingSomo la 9Vipimo vya wakati: Calendar_Date, Fiscal_Year, Fiscal_Period, Week, Month_To_Date_FlagBuni vipimo vya wakati kwa uchambuzi wa kipindi chenye unyumbufu. Jifunze jinsi ya kufunua tarehe za kalenda, miaka ya kifedha, vipindi vya kifedha, wiki, na bendera kama mwezi hadi sasa, ikiwezesha uchujao thabiti wa wakati na ulinganisho.
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 periodsSomo la 10Nafaka ya ukweli na uundaji: kufafanua ukweli wa mauzo wa kiwango cha shughuli dhidi ya ukweli wa picha ya hesabu, athari za nafakaFafanua na uandike nafaka ya ukweli kwa kila meza. Jifunze tofauti kati ya ukweli wa mauzo wa kiwango cha shughuli na ukweli wa picha ya hesabu, na jinsi chaguo za nafaka zinavyoathiri kuunganisha, njia za kuchimba, na utendaji wa ripoti.
Transaction-level sales fact definitionStock snapshot fact grain and timingGrain alignment across related factsImpact of grain on aggregationsDocumenting grain for report designersSomo la 11Tambua maeneo ya somo: ukweli wa mauzo, ukweli wa hesabu, bwana wa bidhaa, bwana wa duka, vipimo vya kalendaFafanua maeneo ya somo la biashara yanayoongoza ubuni wa ulimwengu. Jifunze jinsi data ya mauzo, hesabu, bidhaa, duka, na kalenda inavyoangaziwa kwenda kwenye meza za ukweli na vipimo, na jinsi kutenganisha huku kunasaidia ripoti yenye unyumbufu na thabiti.
Sales fact subject area definitionStock fact subject area definitionProduct master as a conformed dimensionStore master and location coverageCalendar dimension business requirementsSomo la 12Nyanja za ukaguzi na ukoo: Data_Source, Load_Timestamp, Record_Status kwa utatuzi na upatanishoAnzisha nyanja za ukaguzi na ukoo katika ulimwengu. Jifunze jinsi Data_Source, Load_Timestamp, na Record_Status zinavyosaidia utatuzi wa matatizo, upatanisho, na imani ya mtumiaji, na jinsi ya kuzifunua bila kuwachanganya watumiaji wa mwisho.
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