Want to know what Power BI features were released in a certain time period? Check out the Power BI Features report. After some delay, you should see the report embedded on the page but please be patient. If no patience, you can also download the pbix file from the same page. Then, use the slicer on the first page to filter your date range. In…
Read article
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]…
Read article
Kudos to all the hard working individuals that made SQL Saturday BI (Atlanta) a success! It was great meeting many BI fans.
Read article
Semantics relates to discovering the meaning of the message behind the words. In the context of data and BI, semantics represents the user's perspective of data: how the end user views the data to derive knowledge from it. A modeler translates the machine-friendly database structures and terminology into a user-friendly semantic model that describes the business problems to be solved. To address this need, you…
Read article
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…
Read article
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…
Read article
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…
Read article
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…
Read article
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…
Read article
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…
Read article
