Data Preparation for Power BI
Data Wrangling: Accelerate Time to Insight
The Power of Power BI
Power BI is an increasingly popular self-service business intelligence tool from Microsoft. It can create custom dashboards and reports that are ready for web or mobile viewing. The suite allows end-users to create reports and dashboards without the support of the IT department. PC Magazine awarded Power BI its Editor's Choice award in the summer of 2018: „for its impressive ease of use, top-notch data visualization features, and excellent compatibility with other Microsoft Office products.“.
However, simple data wrangling tasks such as sorting and aggregation, before and after data display, can bog down or crash when fed „big data“ data sources.
Power BI with More Power
If you need to capture, integrate, clean, or mask multiple or high-volume data sources, you should do it outside the BI layer! The SortCL program in IRI CoSort Package or the data management platform IRI Voracity quickly and cost-effectively handles large, raw data sources in the file systemnot in SQL ServerBy centralizing pre-processing work of sort, join, and aggregate transformations in SortCL, this overhead is removed from Power BI, drastically reducing time to insight. See for yourself: Blog > Business Intelligence > Accelerating Time to Insight in Power BI