Data is stored everywhere around us. It depends on us to use all available sources to create a useful set of information which will help us drive our business forward. The data was around us since the expansion of the world wide web, but only recently did technology evolve enough to provide us with the right tools for gathering, modeling and presenting key information.

 

Add a comment

Measures are with us since the Excel 2010, yet I’ve seen only a few people using them while doing analysis or data manipulation in any way.

To use Measures in Excel 2010, you first needed to install PowerPivot add-in, since it is not a part of the application itself.

Add a comment

In this article, you can get acquainted with main PowerBI pricing options and see what are the key features of each of them.

Add a comment

So far I have written couple of articles about PowerPivot, PowerQuery, and DAX. The reason I started my blog with these topics, and will continue to do so, was to get you all familiar with “New” technologies that are coming our way and that are redefining our understanding of Data extrapolation and data analysis. The one thing is certain. The whole industry is shifting from IT approach to Data Specialists approach!

Add a comment

If you are an advanced Excel user already familiar with PivotTables, eventually you will surpass regular features Excel has to offer, and you will start using PowerPivot. Why? Because in today’s world it is all about Big data. There are plenty of sources available for analysis,the amount of data is bigger than ever and increasing each day with astonishing speeds.

Add a comment

With the release of PowerPivot in 2010, Microsoft also released programming language called DAX. Beside PowerPivot, DAX is also used in Microsoft SQL Server Analysis Services (SSAS). It’s a formula language which operates against the data model.

Add a comment

PowerBI is a combination of visualization tools (like Tableau), Self-service analysis tools (like PivotTable) and cloud-based tools. You get all this under one product which is user-friendly, easy to implement and maintain. On the other hand, it is strong enough to be used in large companies for complex data modeling and reporting requirements.

Add a comment

PowerPivot is everything PivotTable is, and everything PivotTable wanted to be. Robust, fast, big data cruncher and Business Inteligence tool.

Add a comment

Power Query, or Get&Transform in Excel 2016, is an ultimate tool for data transformation before loading it to Excel/Power BI.

Add a comment

Web by eSENTIO

Ova web-lokacija upotrebljava Googleove kolačiće, te njezinim korištenjem prihvaćate upotrebu kolačića
Saznajte više Ok