Our blog will help you stay in the know about data analytics, business intelligence, data warehousing, and more.
[email-subscribers namefield=”YES” desc=”” group=”Public”]
What Our Content Looks Like
Sharing Is Caring – How To Share Your Power BI Reports
This post is part of our Power BI series and is a follow up to “Baby Steps: How to Create Basic Charts in Power BI Desktop.” In this post, we talk about how you can share your Power BI reports with your co-workers, because after all, sharing is caring.
SQL Shootout: In-Memory Tables vs. Disk-Based Tables (Round 2)
In Part 1 of our investigation into In-Memory Tables, we saw how changing a Hash Index to a regular Nonclustered index of a sample database table improved the performance of our Select operation. In this article, we take a deeper dive into the types of indexes we can apply to memory optimized tables, focusing on the more common hash and nonclustered indexes.
Baby Steps: How To Build Basic Charts in Power BI Desktop
In part 1 of our Power BI series, we show you step-by-step how you can create basic charts in Microsoft’s Power BI Desktop.
For the SQL Craftsman: Date Matrix Aggregation
The SQL Date Matrix tool is a business intelligence tool that has its purpose, but is often left on the shelf to be slowly covered in dust and ultimately forgotten. But to the business intelligence expert, the SQL Date Matrix is an invaluable solution when used in the right situation.
Building a Data Warehouse: Populating and Using a Junk Dimension
A junk dimension is seen occasionally inside of data warehouses. This type of dimension can be thought of as a flag table, or a collection of attributes that have low-cardinality. In this post, we show you how to build a data warehouse by populating a junk dimension.
How To Inventory Your Sharepoint Content
In this post, we guide you step-by-step on how to inventory your SharePoint content.