
Data rich, insight poor; business intelligence paradox
Robust data management and data analytics is a key differentiator in organisations. Those that can make strategic, data-driven decisions are more likely to be successful in identifying shifting trends that will affect their organisation, respond quickly to change, extract insight and answer business questions much faster.
Read More
Gold Microsoft Partner for Cloud Platform
Satalyst has been a strong performing Microsoft partner for over six years and now proudly announces it is a Gold Microsoft Partner for Cloud Platform. The achievement of Gold Competency status for Cloud Platform complements its Gold Data Analytics and Silver Cloud Productivity Competencies.
Read MorePower Query: Creating a parameterized function in M
This will be part two in my on-going series about Power BI, Power Query, and the general joys of data. In my last post I outlined how to iterate over a list in Power Query. But what if I want to iterate over a list and need to parameterize it with today’s date? What if I want to issue multiple web requests based on a list? This is exactly the scenario I had when trying to fetch crime data from the WA Police web site. First, I have to thank my colleague and web wizard John Chillemi who authored the azure website that I’m using. The WA Police site has all the data, but not in a nice HTML table, which is what Power Query needs. So, thanks to John, I can execute a single web request and get a webpage that looks like this: The web request takes five parameters – Suburb, Start Month, Start Year, End Month, and End Year, as seen below: I’d like to execute that web request for every suburb in Western Australia (there are over 1300 by my count) so obviously this is a case for automation, which means I need an M parameterized…
Read More