LBAG are running a series of monthly evening meetups in 2020 solving some typical analytical problems with Power BI. They are usually on a Wednesday evening each month from February to September at the Microsoft Reactor, a few minutes’ walk from Liverpool St Station in Central London. Here are the sessions and dates.
Shape Up – Transforming data into the best shape for analysis and visualisation
Our data is often not in the right shape that we can analyse and visualise it. We’ll describe what a good shape looks like, with the help of a few stars and snowflakes, and how we can bend our data into shape.
Dodgy Data – finding and fixing data quality issues
Data is never clean – it messy and often has missing and incorrect values. We’ll provide some datasets that may, or may not, have some interesting data quality issues. Can we find the data problems – and fix them?
Pimp My Power BI – building attractive and engaging visuals
We want to share important insights, but our audience are turned off by another boring bar chart. Let’s look at how we can spark interest with some intuitive and engaging visualisations, and how to design the viz to help make clear the trend or pattern that we want people to take note of.
As Time Goes By – dealing with dates and time intelligence
Products get ordered then later shipped. Transactions are traded then settled a few days later. It’s easy to how many are traded or ordered each day but often we want to know how many products have already been ordered but not yet shipped.
Not Adding Up – dealing with semi-additive and non-additive measures
Revenues and Costs are easy. They add up every way – for example we can total revenue by product and by month. Some other measures are a bit tricky; inventory levels can be added up in every way but not by date. There are some awkward calculations that don’t add up in any way – for example some measures of risk and exposure and netted values. We’ll look at how to aggregate these calculations even when we can’t just add them.
Peer Pressure – using DAX to bring it all together
Let’s we that you need a chart to show many things; for example, to compare our company’s performance with that of our competitors and peers and against industry benchmarks. The problem is that the data is spread out over several tables – how can we combine all these and build the visual we need?
Retention and Churn – financial modelling example
More and more businesses have a subscription model; e.g. magazines, streaming entertainment, mobiles – or even loans. We want to model the future revenue, and rates of churn. Often these are based retention profile based on cohorts and products.
Zomalex organises the London Business Analytics Group (LBAG), a very popular community data and analytics interest group. All meetings are free of charge and open to all and held in central London. Over the last 5 years, we have run 60 events with a typical audience of 100 people at each event. Details of upcoming talks and events are on our meetup page. (snapshot below)
Meetings start at 6pm. The talk and Q&A last for one hour maximum and there is some time for drinks, chat and networking afterwards. We meet about once a month on a weekday evening at a central London venue.
Some of our recent talks have been recorded and are available here. (snapshot below)