Blog – Page 44 – Prologika

Atlanta MS BI Group Meeting on Mar 28th

March 24, 2016 / No Comments »

Atlanta MS BI fans, join me for the next Atlanta MS BI Group meeting on Mar 28th and 6:30 PM. Luis Figueroa will show us how to do cloud ETL with Azure Data Factory. Allegient will sponsor the event. Don't forget to register at atlantabi.sqlpass.org. ate this meeting http://aka.ms/PUGSurvey, PUG ID: 104 Presentation: A Closer Look at Azure Data Factory Level: Intermediate Date: Monday, March 28th, 2016 Time 6:30 – 8:30 PM ET Place: South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346 Overview: Azure Data Factory is a modern data orchestration platform design to help you manage any data of any size from any source. It also makes a number of technologies available to you such as Azure Machine learning so that you can integrate predictive machine learning models in your data pipelines. This platform enables you to create intelligent applications that not only provide insights...
Power BI Hybrid Architecture

March 23, 2016 / No Comments »

A unique and tremendously useful Power BI feature allows you to implement hybrid solutions where your data remains on premises (SSAS, SQL Server, Oracle, and other data structures) but only report and dashboard definitions are deployed to powerbi.com. This hybrid architecture gives you the best of both worlds: cutting edge cloud-based visualizations with on-premises security, scale, and single version of truth. Since no cloud application can connect directly to your network, a connectivity software, called Power BI Enterprise Management Gateway, acts as a bridge between powerbi.com and your data sources. I'm wrapping up a Power BI Hybrid Architecture proof of concept (POC) for a large organization and I want to recap some important lessons learned: I'm really astonished by the roundtrip speed! It's remarkable that the round trip completes so fast given that powerbi.com (a data center in Virginia for East Cost I believe) connects to a data center in...
Tabular Display Folders

March 17, 2016 / 2 Comments »

A welcome usability enhancement in SQL Server 2016 Tabular is the ability to configure display folders to organize table fields and measures in logical folders. Previously, you had to use BIDS Helper or DAX Editor (for measures) to implement display folders. Starting with SQL Server 2016, you can just set the Display Folder property of a measure or a field. This adds the display folder to Fields List in Excel and Power BI Desktop.
Two New Prologika Training Courses

February 29, 2016 / No Comments »

Due to popular demand, we've added two more classes to our training curriculum. Applied SQL Fundamentals - This 2-day instructor led course provides you with the necessary skills to query Microsoft SQL Server databases with Transact-SQL. This course starts with the basics of a SELECT statement and its syntax, and progresses to teach you how to join, aggregate, and convert data. This course is perfect for developers who need to query SQL Server databases to retrieve data, from complete beginners through to more experienced developers who can use some of the modules as reference material. It will benefit novice Database Administrators, Database Developers, and Business Intelligence professionals. It will also benefit SQL power users who need to create SQL queries, including report writers, data analysts, and client application developers. Applied Microsoft BI - This 4-day class is designed to help you become proficient with the Microsoft BI toolset and acquire...
ATLANTA MS BI GROUP MEETING ON FEB 29TH

February 26, 2016 / No Comments »

Atlanta MS BI fans, join me for the next Atlanta MS BI Group meeting on Feb 29th and 6:30 PM. I'll present "What's New in SSRS 2016". Don't forget to register at atlantabi.sqlpass.org. Nevron will be our sponsor. Vishal Pawar will do us a quick Prototypes with Pizza demo about the new features in the Power BI Feb update. Rate this meetinghttp://aka.ms/PUGSurvey, PUG ID: 104Presentation:What's New in Reporting Services 2016 Level: IntermediateDate:Monday, February 29th, 2016Time6:30 – 8:30 PM ETPlace:South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346Overview:Reporting Services plays an important role in the updated Microsoft on-premises BI roadmap as a platform for delivering paginated, mobile, and interactive reports. This is a great news for many customers who previously had to rely on SharePoint for BI. Microsoft has made significant investments in SQL Server 2016 to bring Reporting Services up to its new role. Join this session to...
Getting Mobile Reports to Recognize SSAS Dates

February 25, 2016 / No Comments »

Scenario: Some of the controls in SSRS 2016 mobile reports (previously known as Datazen) require a date field. The Mobile Publisher would refuse binding the control to an SSAS shared dataset if a column of a Date data type is not present. That's because when you create a dataset, you write an MDX query and MDX returns the field name as a string. Solution: You can use add a calculated member to the query that returns the MEMBER_VALUE property. MEMBER_VALUE returns in the underlying data in its native data type. For this to work in Multidimensional, you need to set the Value property of the Date attribute of your Date dimension to an underlying column of a Date data type. The following example, shows a sample query that uses the Adventure Works Tabular model. WITH MEMBER [Measures].[Total Sales] as ([Measures].[Internet Total Sales] + [Measures].[Reseller Total Sales]) MEMBER DateCasted as Iif([Measures].[Total...
Gartner Positions Microsoft as a Leader in BI and Analytics Platforms

February 4, 2016 / No Comments »

The title says it all! Note that the evaluation was done in July-August 2015. Some of the missing points Gartner points out in the report have been implemented already, such as custom visuals So by now the bubble should have moved up toward the ability to execute J Beyond Power BI, I found the following Gartner's strategic observations interesting: By 2018, data discovery and data management evolution will drive most organizations to augment centralized analytic architectures with decentralized approaches. By 2017, 75% of IT organizations will have a bimodal capability; half will not handle this well, by either remaining over-controlling or completely ignoring the risks of more agile approaches. By 2017, highly featured and easy-to-use freemium and low-license-cost business intelligence (BI) offerings will accelerate user adoption deep into the enterprise beyond traditional BI users. Want to learn Power BI? We're still accepting students for the online class starting Monday. Class...
Prologika Power BI Showcase

February 4, 2016 / No Comments »

Microsoft launched a Power BI Partner Showcase section to help you "find the right solution for your organization" from certified partners like Prologika. I'm excited to announce the first Prologika Power BI Showcase! It's based on the work we did for an insurance company. This solution transformed the organization's data into a key strategic business asset, empowering employees like never before. It currently includes over 300 performance measures that can be analyzed across various dimensions, enabling business to collaborate and share insights with rich data storytelling. The solution delivers a "single version of truth" approach for reporting, and empowers business users to build customized reports and analyses using various tools. "We are extremely excited for the actionable intelligence and foresight this new tool will bring to our organization" Director Supply Chain Analytics Visit the solution page to learn more about how we did it, watch a short video, and even...
Improve your Power BI skills – Five days left to register!

January 27, 2016 / No Comments »

Call/email us if you have any questions about the class. Registration closes on January 31st. Join Teo Lachev as he presents his online Applied Power BI class. Power BI is a Microsoft cloud-hosted BI platform that opens BI to everyone without reliance on IT. And most of it is free! This class is designed for business users and data analysts. You'll learn: What is Power BI and why it'll disrupt the way you analyze your business. How to get instant insights from cloud services, such as Google Analytics, Dynamics CRM Online, Salesforce, and many others. How to create sophisticated self-service data models whose features are on a par with models built by BI pros. How to clean and shape dirty data. How to create insightful interactive reports and dashboards. How to share BI content with other users and view it on mobile devices. No travel, no hotel expenses, just 100% content delivered right to your desktop! Our intensive...
Atlanta MS BI Group Meeting on January 25th

January 21, 2016 / No Comments »

Atlanta MS BI fans, Join us for our first 2016 Atlanta MS BI and Power BI Group meeting on Monday, January 25th. Our sponsor, Panorama, will present Panorama Necto. And Patrick LeBlanc from Microsoft will present "Power BI for You" and show you how Power BI will disrupt the way you analyze data. Don't forget to register at atlantabi.sqlpass.org. Presentation:Power BI for You Level: IntermediateDate:Monday, January 25th, 2016Time6:30 – 8:30 PM ETPlace:South Terraces Building (Auditorium Room) 115 Perimeter Center Place Atlanta, GA 30346Overview:Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice...