Power BI – World Tour (7 cities across the world)

The “Power BI User Group” (PUG) is going to run the “Power BI World Tour” with access to premium Power BI content designed by your local industry experts. Starting in August, the tour will visit seven cities throughout the World. Hurry up and register before 7 August to get discounted rates for this 2 days event. …

Continue reading ‘Power BI – World Tour (7 cities across the world)’ »

Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)

Hi Guys, I have been waiting for an official certification from Microsoft on Power BI. And finally I saw the exam opened up. 🙂 Even though it is still marked in Beta but you can go-ahead and schedule if you want. Or you can start gearing up with necessary technical knowledge to complete the certification. …

Continue reading ‘Power BI Certification: 70-778 – Analyzing and Visualizing Data with Microsoft Power BI (beta)’ »

MERGE your knowledge from EXPERTS – “Project BOTTICELLI”

Hi guys, I am just about to write an introduction of “Project Botticelli” for you; but they gave their introduction in very nice and precise manner so I decided to extract that and put it here for your quick reference. (Excerpt from https://projectbotticelli.com/about-project-botticelli-ltd) “Project Botticelli Ltd is a small company offering online training by business …

Continue reading ‘MERGE your knowledge from EXPERTS – “Project BOTTICELLI”’ »

What is OLAP Database ? What is FASMI?

Hi guys, i was reading an article and came across this term “FASMI“. i have done a little bit of RnD to find out its head & tail. This is what it means: FASMI is an acronym of “Fast Analysis of Shared Multidimensional Information“. A database when called “OLAP Database” if it satisfies following FASMI …

Continue reading ‘What is OLAP Database ? What is FASMI?’ »

Behavior Changes to Analysis Services Features in SQL Server 2012

Hi all, I would like to draw your attention to the few modifications in SSAS behaviors in SQL 2012. The most important difference you will find is the “Cube Browser”. Yes, it’s totally changed. According to Microsoft “The cube browser control that let you drag and drop fields onto a PivotTable structure in Management Studio …

Continue reading ‘Behavior Changes to Analysis Services Features in SQL Server 2012’ »

What you need to know about – “PowerPivot”

Hi All, Today i would like to talk about a booming technical feature by Microsoft i.e. “PowerPivot“. What is PowerPivot? PowerPivot (which is also known as Project “Gemini“) is Microsoft’s hottest business intelligence (BI) innovation. By integrating PowerPivot technology with Microsoft Excel, Excel has gradually becoming most wanted & preferred BI tool (client) in the …

Continue reading ‘What you need to know about – “PowerPivot”’ »

Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools

Hi All, Most of us; who are working on SQL BI solutions are aware of connecting SSAS Cube using Excel (as client) for browsing. Because we know that how much the clients/financial users likes to work with Excel 🙂 In SQL 2012 RC0, there is one handy-dandy quick-link which enables us to make this whole …

Continue reading ‘Browse an SSAS Cube using Excel – Automatic Setup done by SQL Server Data Tools’ »