Category: Data Analytics

Power BI’s Data Compression: Large Data Imports in Power BI

Optimization of Power BI to Maximize Advantages of Encoding Methods This guide explores data compression regarding Power BI, specifically relating to xVelocity engine functionality and data importation limitations.  In this discussion, I focus on 10 GB uncompressed data and 1 GB compressed data.  Limitations of 10 GB Uncompressed Data  Likely error encountered by our client: “The amount of uncompressed data on the gateway client has exceeded the […]

Power BI: A Detailed Examination of Data Importation

Clarifying the Use of Queries and Methods for Data Importation with Power BI Power BI is an industry leader in self-service analytics. This service delivers large-scale business intelligence into the hands of the end user by leveraging familiar tools found in Excel and Analysis Services into a single streamlined application. Power BI takes advantage of […]

Strengthening Your Enterprise Through Data & Analytics

At IntelliTect, we use cloud services to extract, load and transform transactional data to create agile and scalable data warehouses capable of creating reports for any user. The advanced analytics we designed have been used in various industries throughout the Inland Northwest. This past month, I had the privilege of teaching a crash course at […]

Convert UTC to Local Time in Power BI

Update:  Recent updates to the Power BI service need to be reviewed and appropriate updates to the post will be made. Power BI provides exceptional business analytic services. Additionally, the Power BI component Power Query provides a powerful and dynamic tool for loading and transforming data into Power BI’s data model. However, Power Query lacks a […]

How I Installed Software on a Server using PowerShell

I was tasked with installing custom and generic software on a dozen new servers. As an SDET, I have never done this type of task before, so I googled some methods for automating this process since manually installing each server was time-consuming. PowerShell seemed to be the logical tool for running through my list of tasks. I was able […]