• Upcoming Power BI Events in Atlanta

    August 25, 2016 / No Comments » / 140 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 » / 468 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, such as KPI goals, creating simple lookup tables, or prototyping 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 » / 1315 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 » / 2197 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 » / 1226 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...

  • Formulating a Power BI Enterprise Strategy Seminar – Atlanta

    August 8, 2016 / No Comments » / 2893 Views

    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 plan and adopt Power BI. Packed with features, Power BI supports a dizzying variety of features and integration scenarios but it might be difficult to understand how Power BI fits in your data analytics ecosystem. Join Prologika and Microsoft for a 3-hour free seminar on Wednesday, August 31th, 8:30 AM -12 PM ET, at the Microsoft Office in Alpharetta, when Teo Lachev (CEO of Prologika) and Brian Jackson (Cloud Solution Architect at Microsoft) share practical knowledge and experience to help you to formulate a Power BI enterprise strategy. If you're considering Power BI but you're not sure how it fits within your organizational data strategy, this event is for you. Key Takeaways Understand how Power BI changed the way users (information workers, data analysts, BI...

  • Going with the Flow

    August 1, 2016 / No Comments » / 481 Views

    Currently in preview, Microsoft Flow is a cloud service for creating automation flows without writing code, similar to Zapier's "zaps" and IFTTT's "recipes". How is this useful for BI? Let's consider an example. Power BI has recently introduced data-driven alerts in Power BI Service (previously alerts were supported on iPhone only). Currently, alerts can be created only on single-card dashboard tiles that are connected to imported datasets. You can go to the tile properties and click the Manage Alerts (bell) icon to create an alert rule, such as "SalesAmount is above 1,000,000." When the alert rule condition is met, you are notified in the Power BI notification center and by e-mail. But what if you want to broadcast the alert to a large audience? Currently, this feature is not a Power BI native feature. Sure, you can forward the email manually but what if you're on vacation or the alert is triggered...

  • Trend Lines in Power BI Charts

    July 28, 2016 / No Comments » / 2629 Views

    Recently, Power BI charts introduced trend lines. However, they require numeric or date values on X-axis, which must have a continuous type. In fact, if you use a text field for the X-axis, a warning indicator will be displayed in the top left corner of the chart to warn you that non-numeric values are used. This requirement presents issues if the report is connected to a Multidimensional cube because by default all attributes are text-based. As a workaround, in the Multidimensional project set the ValueColumn property of the attribute to a column in the underlying table of a numeric or date data type, and deploy the cube. Back to Power BI Desktop, bind the corresponding .Value field to the X-axis.

  • Happy Birthday, Power BI!

    July 24, 2016 / No Comments » / 1346 Views

    Power BI is one-year old. it's hard to imagine that one year has passed but here we are. The momentum behind Power BI is huge both from development and customer perspectives. It's exiting to see a product that evolves so fast based on feedback from users. So, there will be many more birthdays. And for the nay sayers out there, no, Power BI is not immature as its building blocks (Power Pivot, Power Query, Power View, Tabular, Azure) have been around for many years. Anyway, it's time to recognize all the effort that went behind the new Power BI. Happy Birthday from the community! [embed]https://youtu.be/An_8wf4RwBw[/embed]

  • Atlanta MS BI Group Meeting on July 25th

    July 24, 2016 / No Comments » / 10460 Views

    MS BI fans, join me for the next Atlanta MS BI and Power BI Group meeting on July 25th at 6:30 PM. Shabnam Watson will teach you MDX fundamentals. Pyramid Analytics, our sponsor, will show us why they are Microsoft Power BI preferred vendor. And I'll demo the Power BI Publisher for Excel. Rate this meeting http://aka.ms/PUGSurvey, PUG ID: 104 Presentation: A SQL Developer’s Guide to MDX Basics Level: Intermediate Date: Monday, July 25th, 2016 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: MDX is an industry standard query language for OLAP systems and is used to query Microsoft Analysis Services (SSAS). Custom MDX queries can be authored in SQL Server Management Studio (SSMS), Reporting Services, Power BI and custom applications. While SQL and MDX share some common keywords, they have very different syntax and concepts. This session is for anyone...

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