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 articlesI wonder how many people believe that Tabular DistinctCount outperforms Multidimensional judging by Excel reports alone. In this case, an insurance company reported a performance degradation with Excel reports connected to a multidimensional cube. One report was taking over three minutes to run and it was requesting multiple fields on rows (insured, insured state, insured city, policy number, policy year, underwriter, and a few more)…
Read articleMicrosoft awarded me again with the Most Valuable Professional (MVP) Award for SQL Server. This is an annual award given to selected individuals worldwide in recognition for their expertise and contribution to the community. This makes it 11 consecutive years for me as SQL MVP!
Read articleJoin us on Monday, September 29th for our meeting of Atlanta MS BI Group to learn about DAX – the programming language of Power Pivot and Tabular. Presentation: DAX 101 Level: Beginner Date: Monday, September 29th, 2014 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: In this session, we will look at…
Read article
Two different customers having deadlock issues. The first one is having deadlock issues happening during DML operations in an OLTP database. The second one – during ETL load of a data warehouse. First, what is a deadlock? Imagine that a friend and you go to a supermarket to buy beer and chips. You both go to the same aisle and you both attempt to pick…
Read articleJoin us tonight for a knowledge-packed meeting of Atlanta MS BI Group to learn how to optimize and automate your ETL. Presentation: Making your SSIS Fly Beyond the Sky Level: Intermediate to Advanced Date: Monday, August 25th, 2014 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: How fast can an ETL package…
Read article
Now that Microsoft has decoupled SQL Server Data Tools from the SQL Server 2014 setup, the quest to find SSDT has started. You can download SSDT from the Microsoft SQL Server Data Tools page. Note that to get the BI project templates, you need the SSDT-BI install depending on the Visual Studio version you have (scroll all the way down the page to see the SSDT-BI…
Read article
As you probably know, the SSRS Report Wizard allows users to select predefined report styles. These styles are basic "skins" that apply to report foreground and background colors. A question came in from a student as to how to modify/add styles. You can alter the existing style templates or add new ones by editing the StyleTemplates.xml file in the \Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\Business…
Read article
An interesting requirement popped up during an Analysis Services class I'm teaching this week. The customer wants to implement a Tabular/PowerPivot KPI that has this pseudo logic: CASE WHEN Actual Below Goal && Below LastYearSales Then Red WHEN Actual Below Goal && Above LastYearSales Then Yellow WHEN Actual >= Goal Then Green END Although I'm using Tabular, the same calculations will work with Power…
Read article
In an attempt to improve visualizations of Excel-based dashboards, Excel 2013 introduced a Timeline filter. Specifically designed to visualize dates, the Timeline filter works similarly to regular slicers which were introduced in Excel 2010. Similar to a regular slicer, Timeline connects at the connection level and is capable of filtering multiple reports. It supports also extended selections, such as to select multiple years. However, there…
Read articleDue to the popular demand, I'm adding a new 5-day Applied BI Semantic Model training course to our training classes. This course reflects the growing need of BI developers to implement both Tabular and Multidimensional semantic models and acquire the necessary knowledge in a compressed educational format. I'm teaching this class for 30 developers next month alone. Targeting BI developers, this intensive 5-day onsite class…
Read article
