THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Power BI   (RSS)
Showing page 1 of 7 (65 total posts)
  • User group meetings and #dax training in Minneapolis and Chicago

    In the next three weeks I will deliver many speeches and training in United States. Here is the list: June 11, 2017: Precon Data Modeling with Power BI at Microsoft Data Insights Summit (Seattle, WA) June 12, 2017: Workshop DAX 101 at Microsoft Data Insights Summit (Seattle, WA) June 13, 2017: Workshop Advanced DAX at Microsoft Data ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 7, 2017
  • BI Beginner: Using R Visualizations

    Last week I showed a simple line plot of a hypothetical college student’s GPA. The plot could have been done using R. Before showing you a visualization that requires the power of R, I’m starting with the simple line plot recreated in R. For additional information about using R with Power BI desktop, David Iseminger has done a great job writing ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on June 4, 2017
  • How to design beautiful dashboards in Power BI – the cure: 15 rules for everyone #powerbi

    Is there a secret recipe to create a beautiful dashboard? Why do we need to use “beautiful”? Would “useful” be a better adjective? If you think for a moment, you know that we are attracted by the “beautiful”. It is important for a first impression, but after that, you want to discover more, and at that point other factors are considered. I ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 31, 2017
  • BI Beginner: Avoiding Mistakes With Averages

    I have seen mistakes in business reports, academic papers, and training materials when it comes to displaying and calculating averages. At first I created a sample dataset using sales data for widgets, but after seeing so many graduation posts this month, I decided to use college grades in this example. In our sample dataset, college kid ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 28, 2017
  • BI Beginner: Stacked Charts in Power BI

    People new to Power BI Desktop have asked me how to create a columnar chart where each column has different colors for different values stacked on top of each other. There’s no reason to be intimidated. Creating such a chart is very simple with only two additional requirements since yesterday’s port. First, your input data must classify the data ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 18, 2017
  • BI Beginner: Simple X-Y Plot

    When I worked for Microsoft giving presentations on data platform products, it was a common occurrence to have people tell me that they didn’t know how to use Power BI. This is the first in a series of posts showing how to do simple, useful tasks in Power BI Desktop. Power BI Desktop is free. Download the Power BI Desktop from here. You can ...
    Posted to John Paul Cook (Weblog) by John Paul Cook on May 17, 2017
  • The new data modeling book for Power BI and Power Pivot users

    In the last few years, I and Alberto Ferrari assisted many users of Power Pivot and Power BI who wanted to create their reports using these tools and were struggling with getting the desired numbers from their data. The first approach of an Excel user is to look for a function, or a more complex DAX expression, that can implement the calculation ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 7, 2017
  • Avoid measure and column with the same name in #dax

    I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and this similarity is the root of a number of issues. It would be much better if the measure ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 2, 2017
  • Using and optimizing DirectQuery in #powerbi and #ssas #tabular

    More than one year ago, I and Alberto Ferrari started to work on DirectQuery, exploring the new implementation appeared in Analysis Services 2016 for the Tabular models, which uses the same engine of Power BI. The previous version of DirectQuery appeared in SSAS Tabular 2012 was very slow and suffered of performance issues also using small models. ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 19, 2017
  • PASS Business Analytics Marathon (March 2017) - Recordings Available!

    The sessions of the event PASS Business Analytics Marathon, held last March 2017 on 29th, were recorded and now they are available for online streaming! If you have missed one session in particular or the entire event, you can view or review your preferred topics. Each video is available on detail page of the related session, you can find the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on April 14, 2017
1 2 3 4 5 Next > ... Last »
Privacy Statement