• A Special Cyber Training Offer This Week!

    December 6, 2016 / No Comments » / 32 Views

    What a better gift to give you than increasing your BI IQ? Don't miss my highly-discounted ($150 per person only) Power BI Dashboard in a Day (DIAD) session this Friday! It's one of the three precon sessions of SQL Server Saturday BI Edition 2016. There are only three days left to register and there are still a few seats available. Then, join me on Saturday at 9 AM at SQL Saturday to learn how to embed reports using Power BI Embedded. Both events are in the Microsoft Office in Alpharetta. Power BI Dashboard in a Day (DIAD Precon Session SQL Saturday Atlanta BI Edition is proud to announce this full day training Power BI Dashboard in a Day (DIAD) is designed to accelerate your Power BI experience with a comprehensive training program in a single day. All you have to do is bring your Windows-based laptop and we'll supply the rest...

  • Atlanta MS BI Group Meeting on December 5th

    December 2, 2016 / No Comments » / 172 Views

    MS BI fans, join me for the next Atlanta MS BI and Power BI Group meeting on Monday, December 5th at 6:30 PM. I'll review the tremendous success that Microsoft BI had in 2016. We'll took a glimpse of the new Power BI navigation experience. Julie Smith will talk about Azure Data Factory Slices for our Prototypes with Pizza. Enjoy catering by Subway, thanks for Microsoft sponsoring this event. Rate this meeting http://aka.ms/PUGSurvey, PUG ID: 104 Presentation: Microsoft BI 2016 Review Level: Intermediate Date: Monday, December 5th, 2016 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: In the spirit of the season, join us to reflect on the state of Microsoft BI Platform at the end of year 2016. It's been a fantastic year for both on-premises and cloud BI! I'll revisit the most important changes. Please feel free...

  • Power BI Training for Atlanta BI SQL Saturday

    November 26, 2016 / No Comments » / 1601 Views

    Only two weeks to register for my "Dashboard in a Day" precon on December 9th for Atlanta BI SQL Saturday. A whole day of hands-on Power BI training for only $150! Power BI Dashboard in a Day (DIAD) is designed to accelerate your Power BI experience with a comprehensive training program in a single day. All you have to do is bring your Windows-based laptop and we'll supply the rest – even lunch! With DIAD you get practical hands-on training prepared by the Microsoft Power BI team. During this precon we'll build a Power BI dashboard together. Along the way, you'll learn: How to connect to, import & transform data from a variety of sources Build real data models, as well as author and publish insightful reports Customize and share your "creations" for collaboration with other groups securely inside your organization including mobile device sharing Get up to speed with the...

  • Choosing a Reporting Tool

    November 12, 2016 / No Comments » / 2758 Views

    Next to the question "How do I offload reporting effort from IT?" is "Which MS reporting tool should my users use?". Granted, Microsoft BI is not shy of reporting tools and they number is increasing! And with Power BI reports soon to be available in SSRS, the choice is getting even more difficult. The following diagram illustrates how I position reporting tools. The Y-axis represents complexity which measures the skills required to author different report types. The X-axis is for interactivity that is related to how well the tool supports interactive data exploration. The size of the bubble represents features supported by the tool – the bigger the bubble, the more features the tool supports. Of course, "features" are subjective. For example, if you care about ability to use custom visualizations, then Power BI reports should be very appealing to you (SSRS also supports custom visuals but you have to...

  • Power BI Reports in SSRS Techinical Preview

    October 28, 2016 / No Comments » / 15989 Views

    From the glimpse to the first public preview…it's great to see one of most requested feature coming to life: ability to render online Power BI reports in on-premises SSRS. Alas, Microsoft is keeping us in suspense and no official date and release vehicles have been announced yet but we can now see and test it using the VM that Microsoft put on Azure (read the Chris Finlan's steps to get started). At this point, the integration supports only Power BI Desktop files that connect to Analysis Services (Multidimensional and Tabular). Attempting to deploy models connected to something else or with imported data, doesn't work and you'll get an error. Custom visuals and R visuals are not supported yet. For the most part, the integration is limited to report viewing only (similar to what you get if you embed Power BI reports in Power BI Embedded). That's will be probably fine...

  • The Future of Microsoft Logical Data Warehouse

    October 26, 2016 / No Comments » / 18850 Views

    Let's face it, the larger the company, the more difficult is to achieve the dream of single enterprise data warehouse (EDW). In a typical mid-size to large organization, data is found in many data repositories and integrating all this data is difficult. I'm doing an assessment and strategy engagement now for a unit in a large organization, and they need access to at least 10 other on-premises systems, including two very large repositories. Naturally, they don't want to import all of this data, which could be millions of rows per day, and recreate their own copy of these large corporate repositories. So what to do? In my "QUO VADIS DATA WAREHOUSE?" newsletter, I defined a logical data warehouse (LDW), also known as data virtualization, is an emerging technology that allows you to access the data where it is. Don't we have linked servers in SQL Server that do this? We...

  • Power BI Dashboard in a Day (DIAD) for SQL Saturday BI

    October 25, 2016 / No Comments » / 2449 Views

    I'm doing a full-day Power BI Dashboard in a Day (DIAD) for SQL Saturday BI on Friday, December 9th for only $129. I'm also sponsoring the event and presenting "Embed Interactive Reports in Your Apps" presentation on Saturday at 9 AM. SQL Saturday Atlanta BI Edition is proud to announce this full day training, register at https://powerbidiad.eventbrite.com today! Power BI Dashboard in a Day (DIAD) is a one-day training designed by Microsoft to accelerate your Power BI experience with a comprehensive training program in a single day. All you have to do is bring your Windows-based laptop and we'll supply the rest – even lunch! With DIAD you get practical hands-on training prepared by the Microsoft Power BI team. During this precon we'll build a Power BI dashboard together. Along the way, you'll learn: • How to connect to, import & transform data from a variety of sources • Build real data...

  • Azure Analysis Services

    October 25, 2016 / No Comments » / 1612 Views

    Despite the mantra you might hear elsewhere, my experience shows that the best self-service BI is empowering users to create reports from trusted semantic models sanctioned and owned by IT. Most of the implementation work I do involves Analysis Services in one form or another. Analysis Services has a very important role in your BI ecosystem as I explain in the "Why Semantic Layer" newsletter. Today, at the SQL PASS SUMMIT, Microsoft announced that Analysis Services Tabular is now available as an Azure PaaS service. As a participant in the prerelease program, I had the opportunity to test Azure Analysis Services and this is why I believe you should care: If you develop cloud-based solutions, you might not have to provision a VM for Tabular anymore. Instead, you can provision an Analysis Services cloud service in seconds, just like you can provision an Azure SQL Database. You can easily scale...

  • Automating Power BI Desktop Refresh

    October 13, 2016 / 4 Comments » / 1816 Views

    Power BI Desktop is becoming an increasing popular tool for self-service reporting. But it has a glaring gap. Unlike Excel, it doesn't currently support an object model for automating tasks. Yet, there are a variety of scenarios that call for task automation, such as refreshing imported data. For example, one customer wanted to show a Power BI Desktop dashboard on a shared monitor that will refresh itself periodically. In another scenario, an ISV wanted to automate the data refresh because Power BI Embedded doesn't currently have APIs to support a scheduled refresh. Currently, there is no supported way to refresh Power BI Desktop files automatically. However, you can try the following approaches at your own risk: Use the Michal Dúbravčík's PBIXRefresher script. This is a PowerShell script that opens Power BI Desktop and sends a key to the Refresh button. Shell out to open Power BI Desktop with the file...

  • A Glimpse of Embedding Power BI Reports in SSRS

    October 6, 2016 / No Comments » / 6830 Views

    The first public demo of the highly anticipated Power BI report embedding feature in SSRS 2016 on premises came from Microsoft Ignite. Scroll to the 58 minute in the Ricardo Muti's "Create a modern enterprise reporting and mobile BI solution with SQL Server 2016" video and enjoy! I expect more details at SQL PASS SUMMIT at the end of this month. Thanks to Dan English for pointing out this video.

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