The 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…
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…
My 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…
Data 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…
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…
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…
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…