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 143 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 (2018-08-12)

Good day SQL folks! Here we are, new week, new Monday and something new to read about the Data Platform world. Power BI Desktop August 2018 Feature Summary The biggest

Last Week Reading 0 Comments

Last Week Reading (2019-06-16)

Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of the data platform. Here you have a big portion of news today. Press Unlock the value

Last Week Reading 0 Comments

Last Week Reading (2019-05-05)

Hello folks! Another set of information about the Microsoft Data Platform. This time: Spark, SQL Edge(!), Power BI, Big Data, Pester, DevOps, YAML. Press Microsoft brings Azure SQL Database to

0 Comments

No Comments Yet!

You can be first to comment this post!

Leave a Reply

Protected with IP Blacklist CloudIP Blacklist Cloud