Power BI Community Events

Zomalex runs a free full day “Introduction To Power BI” training at the Microsoft Reactor in Central London a few times per year.  Our next event is in March 2019.

We are also running a monthly series of 10 Power BI evening events  starting March 2019, also in Central London.   Each event will start at 6pm and finish by 8pm.  It will be a practical training – bring your own laptop.  The exact schedule and content is to be finalised from the shortlist of topics below

Solution-focussed case-studies

  • Financial Stress: calculate exposure, risk & stress measures from a collection of FX Swaps
  • Churn: generate revenue profiles and analyse a subscription business based a contract data over several years
  • People Analytics: Workforce profiling by age, experience and skill, BAME
  • Business Management: calculate key metrics to keep the pulse of a business; actuals against budgets and targets; this year vs previous years, by product type / revenue stream.

Specialist Aspects of Power BI

  • Visualisation: best practices, which type of viz to use when
  • Interactive Visualisations: combining pages visuals to work together well: drill-down, drill-through, report tooltips, bookmarks, synchronised slicers, editing interactions
  • Data Modelling: arrangement and relationships of tables and columns; facts and dimensions, star schemas, types of relationship
  • Python integration: as a data source, used in the Query Editor and as a visual
  • PowerApps – building business apps easily and connecting with Power BI
  • Flow – build useful workflow / collaborations and connecting to Power BI
  • Geospatial Mapping – building data maps, geo-coding, using lat/ longs – using the
  • Bing and ArcGIS map visuals
  • Data preparation – deep dive into the query editor
  • AI in Power BI – incorporation of Cognitive Services into Power BI
  • Dataflows – Data movement and preparation into Power BI (and other apps / stores)
  • Dates & Times: create good date table and calculate time-intelligence measures such as year-to-date etc
  • DAX: Basics; Ratios, Rolling Measures, moving averages
  • DAX Advanced: Peaks & Troughs, several delta relationships, open exposure calculations
  • Using Power BI Service; publishing reports, dashboards, datasets, sharing, apps
  • Power BI Service: Administration – users, workspaces, roles, data gateways and data refresh

A report page from one of the labs in the full day training