• Power BI Nested Hierarchical Labels

    September 18, 2016 / No Comments » / 600 Views

    In the latest Power BI Desktop update, Power BI introduced a new drill-down option. Previously, after enabling drill-down on a chart and clicking the double-arrow icon, the chart will drill down to the next field in the Axis area (or to the next level of a hierarchy if a hierarchy is added to the Axis area). A student attending my Power BI class asked me this week how to avoid aggregation across all years if the user drills down from Year to the Month level. A few days ago, the only option was to introduce another Month field that has the Year-Month combination, e.g. 2005 July, 2005 August, and so on. Now, with the new drill down style, the chart will nest the hierarchical levels so you don't have to add a new field. This behavior is similar to how Excel show categories nested in PivotChart.

  • Atlanta MS BI Group Meeting on September 26th

    September 18, 2016 / No Comments » / 4086 Views

    MS BI fans, join me for the next must-attend Atlanta MS BI and Power BI Group meeting on September 26th at 6:30 PM. The Microsoft Ignite conference takes place this year in Atlanta, starting on Sep 26th. Kamal Hathi (General Manager for Power BI at Microsoft) and Pratap Ladhani (Sr. Program Manager at Microsoft) will be in town for Ignite and we will present at our meeting! This is a must attend session for everyone using or planning to use Power BI. Join us and learn why Power BI enjoys such a tremendous success and where Microsoft is planning to take it. Enjoy catering by Subway, thanks for Microsoft sponsoring this event. Presentation: Power BI at one year - a look back and a look forward  Level: Beginner Date: Monday, September 26th, 2016 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview:...

  • New Custom Visual Developer Toolset

    September 11, 2016 / No Comments » / 478 Views

    One of the most prominent Power BI benefits is its extensible architecture that allows developers to integrate Power BI with custom apps and extend its capabilities, such by creating custom visuals. Having contributed one of the first custom visuals, the Sparkline custom visual, I can tell from experience that Microsoft does its part to ensure that the submitted visuals meets quality, security, and functionality best practices. As custom visual developers have probably noticed, the Power BI Dev Tools is deprecated in favor of the new Custom Visual CLI Developer Toolset. The announcement page enumerates the main benefits of the new toolset. Personally, I like that Microsoft has decoupled the tool from dependencies to the "visual framework" that the original Power BI visuals use. This allows developers to use whatever dev tool they like, such as Visual Studio Code or Visual Studio, to code custom visuals. I also like the better...

  • AzureML – Current State of Affairs

    September 9, 2016 / No Comments » / 2689 Views

    Organizations are showing increased interest in predictive analytics. A large retailer that is using Azure Machine Learning (or AzureML) has approached me to help them automate the process. I can't help it but compare AzureML with the Analysis Service Data Mining each time I look at it. It looks like both Microsoft and I agree at this point, that what used to be difficult was made simple and vice versa. On the upside, AzureML provides business users with a cloud environment for creating predictive solutions without involvement from IT. AzureML has more features than SSAS Data Mining. Now that the focus is on the cloud, we probably won't see future investments from Microsoft in SSAS Data Mining (and the Excel data mining add-in for that matter) which is currently limited to nine algorithms. By contrast, not only has AzureML many more algorithms but also it allows users to use R...

  • Power BI Governance Getting Better

    September 4, 2016 / No Comments » / 1342 Views

    Larger organizations are naturally interested in established procedures for data governance, retention, search and taxonomy. With the rising important of data analytics, such policies are equally important for BI artifacts. For example, a large organization wants to restrict users to access Power BI only from approved devices and/ or on premises. Although it doesn't match yet the SharePoint data governance features, Power BI is making strides in this direction. The tenant admin can access the Admin Portal page (log in to powerbi.com, then click Settings, Admin Portal) to: View Power BI usage metrics and utilization. This fulfills a similar role to the Power Pivot Management Dashboard in SharePoint. Manage users. Set global tenant permissions, such as the ability to publish content pack to the entire organization, allowing sharing content with external users, publish to web (anonymous access), export data, interact with R scripts, Cortana, Analyze in Excel, templates, create audit logs,...

  • Upcoming Power BI Events in Atlanta

    August 25, 2016 / No Comments » / 840 Views

    Time is running out to sign up for these exclusive Power BI Events brought to you by Prologika and Microsoft! FORMULATING POWER BI ENTERPRISE STRATEGY Date: Aug 31st , 8:30-12:00 Place: Microsoft Office in Alpharetta Cost: Free To learn more and register: http://bit.ly/powerbiseminar 2-DAY APPLIED POWER BI TRAINING CLASS Date: Sep 14-15, 8:30-5:00 Place: Microsoft Office in Alpharetta Cost: $999/person (use coupon POWERBI20160914 to get 10% discount when signing up two or more people) To learn more and register: http://bit.ly/powerbiworkshop

  • “Enter Data” Feature in Power BI Desktop

    August 23, 2016 / No Comments » / 4462 Views

    Power BI Desktop has a very useful feature that lets you create tables by manually entering the data. This could be useful in a variety of scenarios, such as entering some reference data, defining KPI goals, creating simple lookup tables, or prototyping some data. If you're familiar with creating tables in Power Pivot by copying and pasting tabular data, think of Enter Data as the Power BI Desktop equivalent. However, Enter Data is more flexible because it lets you also the edit the data! This makes it more similar to the Power Pivot linked tables that automatically synchronize changes in the Excel source tables. Creating a new table is straightforward. You click the Enter Data button in the Home ribbon. Don't confuse this with the New Table button in the Modeling ribbon that allows to create a read-only table from a DAX table-producing expression. While entering the initial data and...

  • New USERPRINCIPALNAME DAX Function

    August 18, 2016 / No Comments » / 1593 Views

    Now that Power BI Desktop supports Row-level Security (RLS), modelers have a little predicament. On the desktop, the USERNAME() function returns the user's domain login (domain\login). However, when the model is deployed to powerbi.com, Username() returns the user principal name, which typically (but not always depending on how your AD is set up) is the user's email address. To simplify dynamic security based on the user identity, DAX introduces a new USERPRINCIPALNAME() function that can help you secure on a column that has the user principal name. This avoids having to use an OR filter to support both deployment scenarios. Notice that if your computer is not joined to a domain, both USERNAME() and USERPRINCIPALNAME() return the same thing (domain\login).

  • Configuring Power BI Embedded

    August 16, 2016 / No Comments » / 2374 Views

    There is a lot of interest surrounding Power BI Embedded from organizations looking for cost-effective ways to embed customer-facing (external) reports in custom apps. And there will be even more interest now that Microsoft reduced the Power BI Embedded cost dramatically by switching from per-render to a session-based pricing model. The best way to get started with Power BI Embedded is with the Microsoft sample app, which is well documented here. Here are a few notes for a better configuration experience: Register a native Azure app even if your custom app is web-based. That's because the ProvisionSample console app (inside the sample solution) expects to be configured in Azure as a native app. Instead of using the Azure Portal, the easiest way to register the app is to go to http://dev.powerbi.com/apps. On the registration page, specify app name (it should typically correspond to your web app name although you can...

  • 2-Day Applied Power BI Workshop – Atlanta

    August 8, 2016 / No Comments » / 1486 Views

    Are you looking for an agile self-service platform that doesn't require reporting and query skills to get basic analytics done without reliance on IT?  Or, perhaps you've heard or evaluating Power BI but not sure where to start or how to take the most out of it? If so, this workshop is for you. A year ago Microsoft unveiled the new Power BI platform consisting of the PowerBI.com cloud service, Power BI Desktop, and Power BI Mobile. Since then, Prologika has helped organizations of all sizes to adopt Power BI. Packed with features, Power BI supports a dizzying variety of features and integration scenarios and it offers plenty to all types of users interested in data analytics: information workers, data analysts, BI pros, and developers. Reserve your seat today to attend this insightful 2-day workshop for only $999 (use coupon POWERBI20160914 to get 10% discount when signing up two or more people) at the Microsoft Office in Alpharetta, when Teo Lachev (CEO of...

Training

We offer onsite and online Business Intelligence classes! Contact us about in-person training for groups of five or more students.
For more information or to register click here!

Books

Learn Power BI at your own pace with our latest book Applied Microsoft Power BI. Targeting information workers, data analysts, pros, and developers, It is designed as an easy-to-follow guide for learning how to implement BI solutions spanning the entire personal-team-organizational BI spectrum.

Syndication