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. Formulas – The old way When …
In this article, you can get acquainted with main PowerBI pricing options and see what are the key features of each of them. Your company decided to implement Business Intelligence solution, and are considering PowerBI as a preferable option. Below you can find more about pricing options and reasons whether you should choose option 1, …
So far I have written a 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. …
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 …
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. What makes this language so special? Its ability to calculate complex formulas in a dynamic environment with …
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. Since the …
Power BI – Complex BI Solution at a fraction of a price Read More »
PowerPivot is everything PivotTable is, and everything PivotTable wanted to be. Robust, fast, big data cruncher and Business Inteligence tool. When one of the most authoritative persons in the world of Excel (Bill Jelen, or MrExcel) says that PowerPivot is the best new feature to happen to Excel in 20 years, you know there is …
Power Query, or Get&Transform in Excel 2016, is an ultimate tool for data transformation before loading it to Excel/Power BI. PowerQuery stands as a mediator between different data sources (Databases, Excel files, Web sources…) and final input. We can say that it acts like a macro recorder, but instead of recording movement across sheets, it …
Power Query – Powerful Excel feature you should start using right away Read More »
EXCEED Solutions d.o.o.
Drežnička 21, 10000 Zagreb, Hrvatska
OIB: 25417969805
MBS: 081124327
IBAN: HR6523600001102641074
info@exceed.hr
+385 98 9461 471
Ured: Modruška 2, 10000 Zagreb
Designed and powered by Adssential
