-
Power BI Desktop Supports Direct Connectivity to Tabular
July 25, 2015 / No Comments »
As you've probably heard the news, Power BI went live yesterday. Among the many new features, Power BI Desktop (previously known as Power BI Designer) now supports live connections to Tabular. This is conceptually similar to connecting Excel to Tabular or Power View to Tabular to create ad hoc reports. However, Power BI Desktop is a standalone and freely available tool that is independent of Office or SharePoint. When connected directly to Tabular, Power BI Desktop generates DAX queries as a result of report changes, sends them to Tabular and displays the results. Of course, we know we have new visualizations that don't exist in Excel and on-prem Power View, such as tree maps, region maps, etc. Upon discovering connectivity to Tabular, Power BI Desktop asks you how you want to connect: Once you create the report, you can publish the dataset and report to Power BI. As a prerequisite,...
-
Atlanta BI Group Meeting on July 27th 2015
July 25, 2015 / No Comments »
Come and join us for our next information-packed meeting on Monday, July 27th. Stacey Jones from UPS will present "Big Data as part of your Data Strategy" and Patrick LeBlanc from Microsoft will do a quick demo of Power BI Desktop now that Power BI has gone officially live. Our sponsor will be Prestige Staffing. Presentation:Big Data as part of your Data Strategy Level: IntermediateDate:Monday, July 27th, 2015Time6:30 – 8:30 PM ETPlace:South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346Overview:New data technologies are evolving at an unprecedented pace. The traditional RDBMS is no longer the only choice for storing your data. Big data technologies such as Hadoop and other data technologies such as Data Virtualization, NoSQL, In-memory databases, Columnar Databases, and Graph databases offer new capabilities, but hold the potential to simply distract or disrupt business. Do relational databases still play a role? Using the wrong technology for...
-
Using DQS for Externalizing Data Validation Rules
July 20, 2015 / No Comments »
Developers spend plenty of time coding for exceptions. The customer SSN must be 9 characters. The organization code must be four characters and it must be constrained to specific values. The happy path is easy, coding for exceptions is tedious. Some exceptions are easy to catch, others might require more complicated logic than implementing the happy path. And, it gets more difficult if the rules change often or your BI system needs to support adding new rules. This is where Data Quality Services (DQS) can help. To me, the biggest strength of DQS is externalizing rules. Instead of hardcoding rules in SQL or ETL, you can externalize them and even offload rule management to business users. Using the Data Quality Client tool, a business user can define simple rules and corrections, such as that the e-mail address must match a specific regular expression. Then, the ETL developer can integrate the...
-
Solving Datazen MDX Query Limitations
July 12, 2015 / No Comments »
As I mentioned in a previous blog, Microsoft added Datazen to its arsenal of data visualization tools. Datazen, of course, comes with its own pros and cons. In this blog, you'll see how you can get around a Datazen limitation when connected to an SSAS data model. Scenario: You create a Datazen dashboard that sources data from an SSAS MD or Tabular model. As usual, you need a query that slices some measures by dimension attributes, such as the query below: select {[Measures].[Sales Amount],[Measures].[Order Quantity]} on 0, [Product].[Category].[Category].Members on 1 from [Adventure Works] While this query works fine in SSRS, when Datazen runs the query it silently drops the dimension attributes from the result. You might attempt to rewrite the query as follows: select [Product].[Category].[Category].Members * {[Measures].[Sales Amount],[Measures].[Order Quantity]} on 0 from [Adventure Works] But then you get: The query cannot be prepared. The query must have at least one...
-
Power BI Custom Visuals Announced
July 10, 2015 / No Comments »
Today Microsoft announced the general availability of Power BI on July 24th meaning that Power BI goes live on that date. Among the many new features mentioned in the blog, the one that piqued my interest is custom visuals. Developers might recall that SSRS has provided custom report items since version 2005, which I wrote about in the October 2006 issue of the MSDN Magazine. Similarly, now you can implement custom visualizations in Power BI! And, instead of writing .NET code, you can do so using JavaScript. This opens the path to implement custom visuals using any of the JavaScript-based visualization frameworks, such as D3, WebGL, Canvas, or SVG. This will be huge as it will allow developers to extend the Power BI visualization capabilities using open-source visualization frameworks. Do you need some gadgets, like a bullet graph? With some coding wizardry, you can implement your own, such as by...
-
Azure Data Catalog Announced
July 10, 2015 / No Comments »
Microsoft just announced the public preview of Azure Data Catalog, previously known as "Project Tokyo". I had a chance to take an early review of Azure Data Catalog to help a big organization which was interested in simplifying discoverability and access to data across the enterprise. As I mentioned in my "QUO VADIS DATA WAREHOUSE?" newsletter, logical data warehousing (LDW) has gained some traction and backing from vendors, including Composite (acquired by Cisco), Denado, and others. "Logical data warehousing is at a very early stage of adoption. In my opinion, the companies that will benefit most of it are large organizations with many data repositories, where data availability is a major barrier for enabling self-service BI. If you believe that your organization might benefit from a Logical Data Warehouse, you might not need to make a major investment. If your organization has an Office 365 Power BI subscription, your first...
-
What’s New for BI in Office 2016?
July 9, 2015 / No Comments »
While you might be trying to convince management to upgrade to Office 2013, the next version of Microsoft Office (Office 2016) is on the horizon and scheduled to be released sometime in the Fall. Meanwhile, you can download and test the Public Preview. Naturally, you might wonder what's new for BI given that Excel is the Microsoft premium BI desktop tool. In my newsletter, I'm sharing my favorite Excel 2016 BI features (most significant listed first).
-
Disaster Recovering
July 9, 2015 / No Comments »
Over the last couple of weeks, I learned a thing or two about disaster recovery. My server crashed and it had to be replaced. While we were able to get Prologika.com up and running quickly, the community site was down for a while. I am happy to report that while there are some kinks remaining, for the most part the community site has been restored.
-
Cool Visualizations Coming To You This Summer
June 12, 2015 / No Comments »
I welcome every news about better visualizations in Microsoft BI so I rejoiced to read this blog by Ariel Netz, Group Program Manager in the Power BI Designer team. "The Power BI Designer team is working on our first update for the summer. That update will be significant, and will signal a new phase in our product development. To date we have mostly invested in the modeling and query capabilities, but starting with the first summer release users will see heavy investments in the Data Exploration & Reporting capabilities in the product. While it might be bit premature to go into detail, it's not premature to provide a teaser… " And the teaser screenshot in the blog shows more visualization gadgets with the ability to change chart series colors. I hope they thrown in conditional formatting as well. Confused which visualization tool to use? You probably are with so many...
-
Where Are My Storage Pool Disks?
June 6, 2015 / No Comments »
I've been doing quite a bit of SQL Server performance work lately, helping customers embrace the cloud. One great feature of Windows Server 2012 and above is the ability to implement a storage pool combining multiple disks. This greatly simplifies disk striping to distribute I/O and deprecates RAID configurations, as explained in more details in the "Performance Guidance for SQL Server in Windows Azure Virtual Machines" whitepaper from Microsoft. In this case, the client has an A7 Azure VM which allows attaching up to four 1TB data disks. Another great Azure feature is that you only pay for what you use. What it means to you is that you cut cost because you have all of this storage available but you are charged only for the actual storage and not for the capacity. In the process of configuring the storage pool, you might find that none or some of the...
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.
