I hope you had a great summer. The chances are that your organization has a centralized data repository, such as ODS or a data warehouse, but you might not use it to the fullest. Do you want a single version of truth? Of course, you do. Do you want to empower your business users to create their own reports and offload reporting effort from IT? I bet this…
Read article
The summer is finally here. With everything coming to fruition, there are exiting news in the Microsoft BI land, the most important of which I’d like to recap in this newsletter. Before I start, I want to mention the availability of my Best Practices for Implementing Enterprise BI Solution presentation that you might find interesting. POWER VIEW MULTIDIMENSIONAL Also known as DAXMD, Power View has…
Read article
Implementing Dashboards Many organizations are considering digital dashboards for a quick 1000-foot view of the company performance. In this newsletter, I’ll review at a high level the options available in the Microsoft BI Platform for implementing dashboards and discuss how they compare. PerformancePoint Services PerformancePoint Services has been the Microsoft’s premium tool for implementing dashboards and scorecards in the SharePoint environment. Geared toward BI pros,…
Read article
What's New in Excel 2013 and SharePoint 2013 BI Microsoft released Office 2013 and SharePoint 2013 in October 2012. The logical question you might have is how the latest versions apply to your business intelligence needs. Here are some of the most important features that I believe might warrant your interest. Excel 2013 The latest release reinforces the Excel status is the Microsoft premium…
Read article
Big Data Big Data is getting a lot of attention nowadays. My definition of Big Data is a dataset (or a collection of datasets) that is so large that exceeds the capabilities of a single symmetric multiprocessing (SMP) server and traditional software to capture, manage, and process it within a reasonable timeframe. The boundaries of what defines a "large set" are always shifting upwards, but…
Read article
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…
Read article
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…
Read article
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…
Read article
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…
Read article
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…
Read article
