View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
Using Power Query to tell your story form your Facebook Data.
Most of the time of this weekend, I spent my time to extract the story behind my Facebook data by using Power Quer
In some case we need to transpose the table data that means we need to change the rows value into columns, and then this blog post will be surely helpful.
Let’s say we have to find ou
This is the 3rd part of my series of blog posts I am writing regarding configuring firewalls to permit connections to SQL Ser
As a consultant for PragmaticWorks, I work with a lot of different people. I have noticed that there is a lot of confusion about dimension attribute relationships with SQL Server Analysis Ser
After some hesitation I installed Windows 8.1 on my main laptop. I am familiar with the new interface and so there were no surprises in that regard. However, I was quite fond of Windows
Creating a tabbed report in SSRS will be same as creating good UI report using HTML, JQuery etc.
Even with countless properties of SSRS there is no direct way to create a tabbed report arch
A couple weeks ago I ran across a problem when setting up a shared data connection for a SQL Server Reporting Services in a test environment. After beating my head against the desk for a few
Best Parctices for Time Scale solution This is an original method that I use when I build SSAS Cubes and it is time to share it with you
Hello. Please enjoy my presentation from SQL Saturday #248 Tampa BI
If you have any questions please feel free to reach out ot me.
The other day I was tasked with creating a pretty intensive query (hey, I’m not an expert on T-SQL yet), and I came across a stored procedure that read something to the effect of: