メイン コンテンツにスキップ

Power BI Advanced: 2-Day Workshop

Analytikus

Provide modeling tools in Power Pivot and Power BI through DAX, for data-based decision making. In specific applied to statistical data analysis, its visualization and interpretation

Agenda

Introduction to DAX (4 hours)

  • DAX for Excel, Power Pivot, and Power BI
  • Compression of calculations in DAX: measurements and measurements calculated
  • DAX functions more common: logics, information, aggregate, date, relationships, text and mathematics, and examples
  • Use of basic table functions and context evaluation
  • Use of the calculate and calculatetable functions
  • Display of results in Power BI and applications in Power Pivot

Data visualization and descriptive analytics (4 hours) * Use of functions of descriptive statistics * Visualization and interpretation of information through Power BI Desktop * Examples of application in Power BI (pareto of a system of inventories, sales distribution, desertion prediction, recruitment optimization, etc)

Calculations of time intelligence (8 hours) * Construction of a date table * Calendar type function study * Handling of multiple dates and multiple date tables * Introduction to time intelligence (added and compared in time) * Management of functions and closure of balance in the time * Examples applied to the different industries * Advanced time intelligence models * Display and interaction with time series in Power BI

https://gallery.azure.com/artifact/20151001/analytikus.advancedworkshopanalytikus.1.0.0/Artifacts/SampleImage/1ea69c2f-155f-41a1-998a-8df9abd2c2c4.png
https://gallery.azure.com/artifact/20151001/analytikus.advancedworkshopanalytikus.1.0.0/Artifacts/SampleImage/1ea69c2f-155f-41a1-998a-8df9abd2c2c4.png
https://gallery.azure.com/artifact/20151001/analytikus.advancedworkshopanalytikus.1.0.0/Artifacts/SampleImage/37988d79-0acb-48fc-ad32-e0476d5fe420.png
https://gallery.azure.com/artifact/20151001/analytikus.advancedworkshopanalytikus.1.0.0/Artifacts/SampleImage/999d8f4f-f4c2-47c2-a6db-6e730bbda865.png
https://gallery.azure.com/artifact/20151001/analytikus.advancedworkshopanalytikus.1.0.0/Artifacts/SampleImage/6cec22d1-3694-484d-9533-48557e4f9692.png
https://gallery.azure.com/artifact/20151001/analytikus.advancedworkshopanalytikus.1.0.0/Artifacts/SampleImage/9dd1e6df-2ad2-44d3-9a29-989634fb305e.png