Blog – Page 30 – Prologika

The Cost of xVelocity Relationships

September 24, 2018 / No Comments »

How expensive is an xVelocity relationship? The answer depends on several factors, such as column cardinality, DAX calculations, and query itself. But it general, a relationship can add a significant overhead. Consider two tables: Customer (7.1 million rows) and Account Snapshot (187 million rows) and a relationship 'Account Snapshot'[CustomerKey] -> Customer[CustomerKey]. I'll use two queries for the test. The Relationship query uses the 'Account Snapshot'[CustomerKey]->Customer[CustomerKey] relationship, while the No Relationship query scans directly the Account Snapshot table bypassing the relationship. Relationship No Relationship EVALUATE CALCULATETABLE ( ADDCOLUMNS ( FILTER ( VALUES ( 'Customer'[CustomerKey], ... ), 'Customer'[CustomerKey] IN { 731102730822895922 } ), "Balance", [Balance] ), FILTER ( VALUES ( 'Date'[Date] ), 'Date'[Date] = DATE ( 2018, 3, 31 ) ) ) EVALUATE CALCULATETABLE ( ADDCOLUMNS ( FILTER ( VALUES ( 'Account Snapshot'[CustomerKey], ... ), 'Account Snapshot'[CustomerKey] IN { 731102730822895922} ), "Balance", [Balance] ), FILTER ( VALUES ( 'Date'[Date] ), 'Date'[Date] = DATE (...
Another Successful SQL Saturday!

September 22, 2018 / No Comments »

Kudos to all the hard working individuals that made SQL Saturday BI (Atlanta) a success! It was great meeting many BI fans.
2-Day Applied DAX with Power BI Workshop in Atlanta (Oct 15-16)

September 18, 2018 / No Comments »

Struggling with DAX? Data Analysis Expressions (DAX) is the expression language of Power BI, Power Pivot, and Analysis Services Tabular. It's very powerful but it's usually perceived as complex and requiring a steep learning curve. Taught by an established expert, this two-day workshop is designed to help you become proficient with DAX. Think of this workshop as advanced Power BI training. Reserve your seat today to attend this insightful 2-day workshop for only $999, when Teo Lachev (CEO of Prologika and Microsoft Data Platform MVP) teaches you the necessary DAX skills that you can immediately apply to your job. Event Summary Date: October 15 and 16 Time: 8:30 AM - 5 PM Location: Microsoft Office in Alpharetta Catering: lunch provided Syllabus: available here Price: $999 (use coupon SQL201810 for an instant 5% discount if you sign up two or more attendees from your company) For more information and to register, go to http://bit.ly/daxworkshop201810 Key Benefits...
Prologika at SQL Saturday BI in Atlanta

September 16, 2018 / No Comments »

SQL Saturday BI in Atlanta is around the corner. Prologika will deliver two sessions at this event on September 22nd: Bridge Analytics and Developer Worlds with Power BI and PowerApps by your humble correspondent, starting at 9 AM One of the Power BI most prominent strengths is that it's a part of the much broader Microsoft Data Platform that spans various on-premises and cloud offerings for data storage, processing, and analysis. Join me to learn how to integrate Power BI with PowerApps and discover exciting new possibilities that redefine the meaning of a report. During this entirely hands-on, no-slides session, I'll walk you through the steps to implement a popular report requirement for writeback, that Power BI doesn't natively support. Data Quality - Plain & Simple by our master data management guru, Neal Waterstreet, starting at 12:30 PM Data quality is a subject that comes up over and over again in...
New “Applied DAX with Power BI” Workshop

September 12, 2018 / No Comments »

Data Analysis Expressions (DAX) is the expression language of Power BI, Power Pivot, and Analysis Services Tabular. It's very powerful but it's perceived as complex, requiring a steep learning curve. I'm excited to announce a new 2-day "Applied DAX with Power BI" workshop that I designed to help you become proficient with DAX. You'll learn practical skills that will help you tackle a wide range of reporting requirements. We'll start with DAX fundamentals, such as calculated columns and measures, and then progress to more advanced concepts, including such as context transitions, variables, filters, time intelligence, advanced relationships, row-level security, query optimization, and much more. Think of this workshop as Advanced Power BI and the next level from my "Applied Power BI" class. The target audience is data analysts and BI developers wanting to hone their DAX skills with Power BI, Power Pivot, or Tabular. Here is my entire training catalog...
DAX Variables to Rescue

September 9, 2018 / No Comments »

Scenario: DAX has its own share of idiosyncrasies that can humble both novice and experienced users. Consider a common example where a measure attempts to return sales for the last date in the Date table. What makes this common is that many real-life calculations require measures that evaluate as of the user-specified date (as of date), which is what MAX('Date'[Date]) returns. =CALCULATE(SUM(Sales[SalesAmount]), MAX(Date[CalendarYear]) ) As innocent and logically correct this measure is, it fails with "A function 'MAX' has been used in a True/False expression that is used as a table filter expression. This is not allowed." It's also amusing to see even Microsoft struggling to explain the reason of this error which at some point was on the internal top 10 Microsoft list for DAX "ease of use". This is what the documentation states about this error: "The filter expression, MAX('Date'[CalendarYear]) attempts to return the largest numeric value in the CalendarYear...
Power BI Conversations

September 4, 2018 / No Comments »

As Microsoft announced in the "Distribute insights across the organization with Microsoft Power BI" presentation (forward to the Nikhil Gaekwad part starting at the 32 min), they've been releasing the following set of features to improve the end user experience in Power BI Service: Home (not yet available) – Personalized landing page Personal bookmarks (not yet available) – End users can create their own bookmarks Persistent filters (already available) – Remembers filters and slicers set by end users Conversations (dashboards conversations are available) – Dashboard and report discussions Sharing with filters (not yet available) – Propagates the current filters when sharing individual reports and dashboards I've noticed that the dashboard conversations are now available. Just open a Power BI dashboard and click the Comments menu. This will open a Comments pane when you can post comments related to the entire dashboard. You can also post comments for a specific tile by...
Where is Teo in September?

September 3, 2018 / No Comments »

I have a few public events in September (all in Atlanta). Sep 11-12: 2-day Power BI open enrollment workshop Sep 20: "10 Ways to Empower Your BI Strategy with Power BI" presentation for DAMA Sep 22: "Bridge Analytics and Developer Worlds with Power BI and PowerApps" presentation for SQL Saturday – BI Sep 25: Meeting of Atlanta MS BI and Power BI Group at the MS office in Avalon These events are also on my calendar.
Power BI Dataset Size Limits

September 1, 2018 / No Comments »

Question: What's the maximum dataset size Power BI can support? Answer: As of now (Sep 1, 2018), the maximum dataset size that Power BI Pro can support is 1 GB. The maximum dataset size with Power BI Premium and Power BI Embedded is 10 GB but it depends on the SKU purchased. Power BI Premium Plan Power BI Embedded Plan Max Dataset Size and Memory P1 A1 3 GB P2 A2 5 GB P3 and higher A3 or higher 10 GB The important point is "as of now", as with everything cloud these limits will probably get higher soon. Also, recall that Power BI compresses data well so don't jump to conclusions of how many rows a dataset can pack if you base the estimate solely on the dataset original size. For example, a 100 MB Excel file might compress to 10 megabytes. The limits apply to datasets after compression. So,...
Power BI Sharing Is Getting Better

August 26, 2018 / No Comments »

A Power BI training or assessment won't be complete unless I get hammered on the Power BI sharing limitations. So far, I could only mumble something to the extent of "I agree that Power BI sharing sucks big time", look for the exit and suggest an unplanned break. Fortunately, it looks like quantitative accumulations from unhappy corporate customers have resulted in qualitative changes as Microsoft is getting serious about addressing these limitations. To me, as it stands today, the Power BI sharing is a classic example of overengineering. Something that could have been easily solved with the conventional and simple folders a la SSRS, morphed into some farfetched "cool" vision of workspaces and apps without much practical value. Let's revisit the current Power BI sharing limitations to understand why change was due: Workspace dependency on Office 365 groups – This results in explosion of workspaces as Power BI is not...