PROLOGIKA BLOG · IDEAS FROM THE FIELD
Practical perspectives on Microsoft Fabric, Power BI, semantic models, and the work of turning data into insight.
Explore the latest articlesOver 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.
Read articleI 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…
Read article
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…
Read articleThe first public preview of SQL Server 2016 (CTP2) got announced yesterday. The natural question for BI pros is what's new for BI. The "What's New in …" topics in the SQL Server 2016 Books Online provides the detailed description of the BI features that made the CTP2 cut. To summarize the major features: SSAS Process partitions within a Tabular table in parallel. Previously, partitions…
Read articleAs a continuation to my "Power BI vNext (let's now call it Power BI 2.0 to align terminology with Microsoft) SSAS Connector and Security" blog, you might wonder how Power BI provisions users. For example, if a user signs with his business e-mail and a coworker shares BI artifacts with him, what happens when the user leaves the company? Can he still gain access? As…
Read articleLots of announcements and roadmap updates coming from Microsoft Ignite which replaced TechEd and other conferences with one event. My favorites are the What's New sessions with the BI-specific ones below. Microsoft SQL Server BI Drill Down Microsoft BI Overview What's New in Master Data Services (MDS) and Integration Services (SSIS) in SQL Server What's Next for Business Analytics in Microsoft Excel Microsoft Azure SQL…
Read articleSQL Saturday Atlanta is around the corner. I'm presenting "Increase your BI productivity with community tools" scheduled in the first time slot at 8:15 AM. "Microsoft has always provided a comprehensive toolset for BI developers but functionality gaps remain. In attempt to fill in some of these gaps, MVPs and community have implemented outstanding tools. Join this session to learn how to increase your developer…
Read article
A customer wanted a bar chart where each bar shows the invoiced and realized sales and a marker to show a goal, as sketched below (notice the Budget marker). The chart had to render the data from SSAS. In SSRS, this of course can be done using a bullet gauge, which I hope one day will make its way to Excel and Power View. Because…
Read article
UPDATE: 1/1/2016 As Microsoft announced in the public BI roadmap (http://blogs.technet.com/b/dataplatforminsider/archive/2015/10/29/microsoft-business-intelligence-our-reporting-roadmap.aspx), Datazen will be fully integrated with SSRS 2016 for delivering mobile reports, alongside paginated (traditional SSRS reports), and Power BI Desktop reports. To follow up on my blog announcing Datazen, I want to share some additional notes now that I had to chance to install it and take it out for a spin. Pros…
Read articleScenario: You create an SSIS 2012 project in SSDT that uses the Attunity Oracle connector. By default, Attunity creates a private connector. You verified that the package connects and executes successfully. Then, you promote connector to a project-level connector so that you can manage the credentials in the SQL Server job configuration across all packages. When you attempt to deploy to the SSIS catalog, you…
Read article
