PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articles
SSRS is near and dear to my heart. My first book ("Microsoft Reporting Services in Action" published in 2004 by Manning) was on this subject and I became an MVP because of my contributions around SSRS back in those days. Because of this and because every good thing should come in two, I rejoiced when I heard Microsoft announcing the Power BI Report Builder to complement the…
Read article
If "XMLA" doesn't ring a bell especially in the context of Power BI, it stands for Extensible Markup Language for Analysis. Still puzzled? It's the protocol of Analysis Services (Multidimensional and Tabular). So, when an Excel or Power BI sends a query to a cube, it's encoded according the XMLA specification (an XML-based format). And, the XMLA endpoint is the web service endpoint that Analysis…
Read article
Confused by magic quadrants? Curious about their internals, such as how companies move from one quadrant to another? GeekAndPoke came up with this much needed resource that explains it all. No words necessary! Happy April 1st!
Read article
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on April 1, Monday, at 6:30 PM at the Microsoft office in Alpharetta. Considering all the the momentum behind machine learning, the main presentation will be "Microsoft Citizen Data Science with Power BI" by Stacey Jones, a Principal Data Solution Architect at Microsoft. I'll do a brief overview of the brand new Modeling…
Read article
Scenario: If you want to pass an input table to a DAX query. For example, you might have an application that lets the user specify a subset of customers and as-of dates for each customer. Your query needs to calculate certain metrics, such as Sales, for the list of customers but as of the user-specified date for each customer, and potentially other parameters. It's impractical…
Read article
Just when I started thinking that there won't be any new BI features in SQL Server 2019, Christian Wade announced DAX calculation groups in CTP 2.3. His excellent post helped me try them out with Tabular Editor and Power BI Desktop and whip out this cool report. As Chris Webb pointed out, DAX calculation groups let us implement time calculations as in Multidimensional with a…
Read article
In my previous "First Look at the New Power BI Integration with Azure ML" blog, I showed you how Power BI will make it very easy to integrate it with Azure Machine Learning and Cognitive Services. Data scientists today have plenty of options to create predictive models but all of them have one thing in common: expertise in data science and statistics. The promise of…
Read article
Currently, Power BI doesn't integrate natively with Azure ML so you must resort to using the Web connector to call the experiment's web service. I demonstrate how you can do this in a singleton way (one row at a time) in chapter 11 of my latest Power BI book (you can download the code from the book page). Microsoft announced several forthcoming Machine Learning enhancements,…
Read article MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on March 4th, Monday, at 6:30 PM at the Microsoft office in Alpharetta. The main presentation will be "Power BI Architecture" by Paco Gonzalez from SolidQ. Eric Flamm will do us Prototypes with Pizza on configuring a Power BI visual for mobile layout. SolidQ will sponsor the event. For more details, visit our group…
Read article
The 2019 Gartner Quadrant for Analytics and BI Platforms is out and Microsoft BI aficionados like your humble correspondent have all the reasons to rejoice. Say whatever you want about Gartner but the quadrant is a great testimonial for Power BI and I think the highest score was overdue. Microsoft still has tons of work on the visualization side of things but I'm glad that Gartner…
Read article
