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 articlesMicrosoft awarded me again with the Most Valuable Professional (MVP) Award for SQL Server. This makes it 10 consecutive years as MVP! Where did all this time go? Anyway, I feel honored to be a member of this elite group of dedicated professionals.
Read articleThe Atlanta BI Group is meeting tonight. Main Presentation: Dimensional Modeling 101 Level: Beginner Date: Monday, September 30th, 2013 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: So many names! Data warehouse, data mart, star-schema, snowflake schema, dimensional model, Type 1, Type 2, Type 3... What does it all mean? Whether you're…
Read article
I've upgraded to Windows 8.1 and got IE 11. As I've come to expect, a new browser upgrade brings a new set of issues, among which buttons disabled when they shouldn't be and page posts not working. What about reports? This is what I get when I use Report Manager. The report toolbar is all messed up. How to fix this horrible issue? Use the…
Read articleMy Fall newsletter entitled "Why a Semantic Layer?" is out and it will be e-mailed to subscribers on Monday. The reason why I wrote is to bring the focus back on organizational BI. Based on my experience, decision are makers are confused about what their company's BI strategy and roadmap should be. I've asked a BI manager recently if he knows that a semantic layer…
Read articleData is your biggest asset and today's currency but the data can be messy. You know it and we've seen it – many times. The messier the data, the bigger the headache. At Prologika, we believe that data quality issues should be addressed as early as possible and the validation process should start with the source systems. You need a solution to detect data entry…
Read article
With the rising popularity of Power View, you may need to integrate it with PerformancePoint to jazz up your dashboards and make them more interactive. Take a look at the following, admittedly unpolished, dashboard which combines a PerformancePoint scorecard and Power View report. What's interesting is that the Power View report is synchronized with the dashboard filter. For example, when the user changes the filter…
Read article
In my previous blog on the Power BI subject, I've introduced you to Power BI. In this blog, we'll take a look at the Data Management Gateway and how to set up data sources to refresh on-premise data. I'll be quick to point out that the actual data refresh is not in the preview yet. The Data Management Gateway is implemented as a Windows service…
Read article
I've been doing some work with ASP.NET Web API and I'm setting a demo service in the cloud (more on this in a future post). The service could be potentially accessed by any user. For demo purposes, I wanted to show how jQuery script in a web page can invoke the service. Of course, this requires a cross-domain Javascript call. If you have experience with…
Read article
Microsoft BI has been criticized about its complexity and price because it requires SharePoint Server Enterprise for deploying Power Pivot models and dashboards. Microsoft introduced Office 365 (E3 or E4 plan required) and SharePoint Online (Plan 2 required) to mitigate such concerns and allow you to host Power Pivot and Power View in the cloud. Power BI is the next step in the Microsoft BI cloud strategy. As…
Read article
I installed SQL Server 2012 SP1 CU5 and I got greeted with the following error while opening Data Quality Services DqsInstaller.exe can be found by default in the C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn folder. However, running the dqsinstaller-upgrade didn't fix the issue. To fix it, I had to recompile the .NET assemblies by running dqsinstaller-UpgradeDlls. BTW, CU4 is still marked as in research by the DQS…
Read article
