Creating DAX Measures in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a Measure.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading “Creating DAX Measures in Microsoft Power BI”

Adding the Fields to a Visual’s Tooltips in Microsoft Power BI

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

In this Video, I’ll show you how to add fields to the additional information, called “Tooltips”, in a Microsoft Power BI visual.

Continue reading “Adding the Fields to a Visual’s Tooltips in Microsoft Power BI”

Adding the Q&A Visual in Microsoft Power BI

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.

Continue reading “Adding the Q&A Visual in Microsoft Power BI”

Creating DAX Columns in Microsoft Power BI

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

In this Video, I’ll create a DAX (Data Analysis eXpression) function to create a column.  DAX can be used in Microsoft Power BI, Microsoft PowerPivot, and MDX.  It’s a relatively easy way to model your data.

Continue reading “Creating DAX Columns in Microsoft Power BI”

Not Your Daddy’s Financial Series

I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series.  Feel free to join me!

I’m conducting a 2-part series on building and consuming Financial Statement data in Microsoft Power BI called Not your Daddy’s Financials Series.  Feel free to join me!

Continue reading “Not Your Daddy’s Financial Series”

Using Relative Date Filtering in Microsoft Power BI

 In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI.  My dataset contains unpaid Accounts Payable invoices and their due dates.  I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks.  My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

In this video, I demonstrate using Relative Date Filtering in Microsoft Power BI.  My dataset contains unpaid Accounts Payable invoices and their due dates.  I use the Filter options to restrict the visual to display only invoices that are in the next 275 weeks.  My sample data is way out in the future, realistically, you would want to see what’s due this week, month, etc.

Power BI on-Premises Production Targeted for Mid 2017 — Paul Turley’s SQL Server BI Blog

NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal. The production-ready release is targeted for mid 2017. This is much sooner than most folks in the community were anticipating. An installable technical preview is targeted for January of 2017. This announcement was just made on the SQL Server Reporting […]

via Power BI on-Premises Production Targeted for Mid 2017 — Paul Turley’s SQL Server BI Blog

Amazon AWS Getting Serious about Analytics — Business Intelligence & Advanced Analytics

Last week over 24,000 attendees gathered at Amazon Web Services (AWS) annual re:Invent conference. The event has significantly grown over 84% since 2014 when there was 13,000 participants. If you are still questioning the … Read More The post Amazon AWS Getting Serious about Analytics appeared first on Business Intelligence & Advanced Analytics.

via Amazon AWS Getting Serious about Analytics — Business Intelligence & Advanced Analytics