https://store-images.s-microsoft.com/image/apps.14982.229fe15d-47fb-412b-8d3d-8921967d60aa.caa0b64c-186d-4a01-9b46-db61d1780e16.26857e3a-f931-4cd0-b5cd-acde08e24921

Power BI Advanced: 2-Day Workshop

Analytikus, LLC

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

D'una ullada
https://store-images.s-microsoft.com/image/apps.65169.229fe15d-47fb-412b-8d3d-8921967d60aa.caa0b64c-186d-4a01-9b46-db61d1780e16.375af67f-3d84-46f5-965c-0faba141698e
https://store-images.s-microsoft.com/image/apps.19932.229fe15d-47fb-412b-8d3d-8921967d60aa.caa0b64c-186d-4a01-9b46-db61d1780e16.4e843c6c-14b0-42b0-89cb-06b116325343
https://store-images.s-microsoft.com/image/apps.10592.229fe15d-47fb-412b-8d3d-8921967d60aa.caa0b64c-186d-4a01-9b46-db61d1780e16.010690d4-bc21-45a6-bcc0-bb54355c0a34
https://store-images.s-microsoft.com/image/apps.51569.229fe15d-47fb-412b-8d3d-8921967d60aa.caa0b64c-186d-4a01-9b46-db61d1780e16.4a29262b-ec85-428b-a6e9-75aeb6ec9907
https://store-images.s-microsoft.com/image/apps.21638.229fe15d-47fb-412b-8d3d-8921967d60aa.caa0b64c-186d-4a01-9b46-db61d1780e16.27772221-a2e5-45e3-87b0-a641e9fa6254