Cov txheej txheem:

Yuav ua li cas koj sau cov lus nug hauv lub zog lus nug?
Yuav ua li cas koj sau cov lus nug hauv lub zog lus nug?

Video: Yuav ua li cas koj sau cov lus nug hauv lub zog lus nug?

Video: Yuav ua li cas koj sau cov lus nug hauv lub zog lus nug?
Video: Zeb Muas - Foom Kom txiv tej lus kub (Nkauj Tawm Tshiab 2021 - 2022) 2024, Plaub Hlis Ntuj
Anonim

Thawj kauj ruam hauv kev tsim koj tus kheej Lub zog Query tsab ntawv yog ntxiv ib qho khoob nug rau Lub zog BI Desktop. Ntxiv rau nug , nyem Tau Cov Ntaub Ntawv ntawm Lub Tsev ribbon nyob rau hauv lub qhov rais loj, mus rau Lwm ntu, thiab nyem ob npaug rau Blank Lus nug . Qhov no tso tawm Lus nug Editor nrog tus tshiab nug teev nyob rau hauv lub Lus nug pane.

Hauv qhov no, koj yuav ua li cas tsim cov lus nug hauv lub zog lus nug?

Lub zog Query 101

  1. Kauj ruam 1: Txuas mus rau nplooj ntawv Wikipedia. Excel 2016: Ntawm Cov Ntaub Ntawv tab, nyem Cov Lus Nug Tshiab> Los Ntawm Lwm Qhov Chaw> Los Ntawm Web.
  2. Kauj ruam 2: Hloov cov ntaub ntawv.
  3. Kauj ruam 3: Ntxuav cov ntaub ntawv.
  4. Kauj Ruam 4: Lim cov nqi hauv ib kem.
  5. Kauj Ruam 5: Sau npe cov lus nug.
  6. Kauj Ruam 6: Xa cov lus nug mus rau ib daim ntawv ua haujlwm.
  7. Kauj Ruam 7: Tshawb nrhiav qhov tshwm sim tom qab qhov xwm txheej.

Ib sab saum toj no, koj ua li cas lub zog nug? Ntshuam cov ntaub ntawv nrog Hwj chim Query (Tau & Hloov)

  1. Mus rau Ribbon> Cov Ntaub Ntawv> Tau Txais Cov Ntaub Ntawv> Los Ntawm Cov Ntaub Ntawv> Los Ntawm Phau Ntawv Ua Haujlwm.
  2. Lub Hwj Chim Query qhia txog Ntshuam Cov Ntaub Ntawv dialog box.
  3. Txheeb xyuas qhov chaw ua haujlwm thiab nyem ob npaug rau nws.
  4. Power Query qhia lub Navigator dialog box.
  5. Xaiv cov ntaub ntawv qhov chaw koj xav ua haujlwm nrog.
  6. Nyem Load.

Tsis tas li ntawd, koj puas tuaj yeem sau SQL hauv cov lus nug fais fab?

Feem ntau hais lus koj ua tsis yog sau SQL queries hauv Lub zog BI . Koj ua tau embed lawv hauv a nug tab sis feem ntau tsis tsim nyog. Koj tsim lus nug hauv nug editor. Vim Fais fab BI tuaj yeem txuas rau ntau lwm qhov chaw tshaj li SQL ntawv nws muaj nws hom lus.

M query yog dab tsi?

Cov M stands rau cov ntaub ntawv Mash-up, as zog query yog txhua yam hais txog kev txuas mus rau ntau qhov sib txawv cov ntaub ntawv thiab "Mashing" lawv. M code yog cov lus qab lub scenes ntawm zog query . Thaum koj tsim cov ntaub ntawv hloov pauv hauv lub zog query editor UI, Excel tab tom sau qhov sib xws M code rau cov nug.

Pom zoo: