Last week reading (2018-02-25)

Last week reading (2018-02-25)

It’s was very busy and pleasant week for me. Tenth SQLBits which has taken in London this year finished yesterday. I have been working as a volunteer (one of the ORANGE team) monitoring each day. Friday evening super party as always. Stay tuned as many great pictures will show soon.

Stairway to DAX and Power BI – Level 13: Simple Context Manipulation: Introducing the DAX All() Function
Quite detailed explanation how All function works. With a good example.

Creating Excel “Data Dump” Reports From Power BI
If you or your Client needs to analyze the data in old-way style rather than Power BI – check this Chris Webb’s post.

SQL Server Replication for Temporal Tables
How to replicate temporal history table? There is a workaround.

Analysis of Spatial Data Using Cosmos DB
Use CosmosDB in many ways. In this extremely easy example, you will see how to build such a solution using an alternative database with scale capabilities.

Azure #CosmosDB Graph API now generally available
Not only an announcement but also newly added support for Python and PHP application.

Azure Cosmos DB Consistency Levels
Everyone asks about it trying to understand how it works.

Data Virtualization vs. Data Movement
Do you always need ETL? What the drawbacks are if you create visualization directly from a source?

Data Lake, Big Data, NoSQL – The Good, The Bad and The Ugly
An essay about how bad the terms like Big Data and NoSQL are nowadays.

Unlock Query Performance with SQL Data Warehouse using Graphical Execution Plans
Yes, you see it well! Graphical plan for Azure Data Warehouse.

Reference Date Table in DAX and Power BI
Almost every single model in DWH or Power BI needs reference Data table. That one contains weeks, fiscal years and holidays for a specific country.

Have a good week! Cheers,
Kamil

 

Previous Last week reading (2018-02-18)
Next Last week reading (2018-03-04)

About author

Kamil Nowinski
Kamil Nowinski 200 posts

Blogger, speaker. Data Platform MVP, MCSE. Senior Data Engineer & data geek. Member of Data Community Poland, co-organizer of SQLDay, Happy husband & father.

View all posts by this author →

You might also like

Last Week Reading 0 Comments

Last Week Reading (2019-03-31)

Hello SQL/Data folks! The first week after returning from MVP Summit (Redmond, USA) was murderous for me. What about your past week? In this post, as every week, I review

General 0 Comments

The recap of the passing year 2019

Good morning girls and boys, ladies and gentlemen, in the new year 2020! I recently thought that we had started a new decade. But that’s not true. The new decade

General 0 Comments

Last Weeks Reading (2024-01-28)

📰 News Fabric end-to-end use case: Data Engineering part 2 – Pipelines If you’re new in Microsoft Fabric – check this series and build it with Sam. Set up Azure

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply