corpus.blog
56,966 blogs · [ { "id": "01a0c564-520f-7111-817f-44ada30654aa", "title": "Delta lake with Python, Local Storage and DuckDB", "url": "https://datamonkeysite.com/2022/06/28/using-delta-lake-with-python/", "published_at": "2022-06-28T11:29:05+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada3cbb9a7", "title": "CPM is Broken – The WHY", "url": "https://datamonkeysite.com/2022/06/18/cpm-is-broken-the-why/", "published_at": "2022-06-18T04:13:45+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada3ff2767", "title": "Loading 1 Billion New York Taxi Dataset into Datamart", "url": "https://datamonkeysite.com/2022/06/09/loading-1-billion-new-york-taxi-dataset-into-datamart/", "published_at": "2022-06-09T11:05:50+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada4123c49", "title": "Why Datamart is a Big Deal", "url": "https://datamonkeysite.com/2022/06/03/why-datamart-is-a-big-deal/", "published_at": "2022-06-03T12:05:25+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada41e936d", "title": "First Look at Datamart", "url": "https://datamonkeysite.com/2022/05/25/first-look-at-datamart/", "published_at": "2022-05-24T21:28:27+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada4866638", "title": "PowerBI vs Thoughtspot Semantic Model and Why Pricing is an Engineering Problem.", "url": "https://datamonkeysite.com/2022/05/14/powerbi-vs-thoughtspot-and-why-pricing-is-an-engineering-problem/", "published_at": "2022-05-14T12:12:02+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada4b3d69b", "title": "The simplest way to merge Multiple Tables in Google Data Studio", "url": "https://datamonkeysite.com/2022/05/07/the-simplest-way-to-merge-multiple-tables-in-google-data-studio/", "published_at": "2022-05-07T08:07:32+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada54614d3", "title": "Tableau vs PowerBI behavior in Direct Query Mode , Result Cache", "url": "https://datamonkeysite.com/2022/05/01/tableau-vs-powerbi-behavior-in-direct-query-mode-result-cache/", "published_at": "2022-05-01T06:44:03+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada5b58e8e", "title": "Using DuckDB with PowerBI", "url": "https://datamonkeysite.com/2022/04/17/using-duckdb-with-powerbi/", "published_at": "2022-04-17T13:19:55+00:00" }, { "id": "01a0c564-520f-7111-817f-44ada62d4d00", "title": "PowerBI Direct Quey modeling using flat Table", "url": "https://datamonkeysite.com/2022/03/27/powerbi-direct-quey-modeling-using-flat-table/", "published_at": "2022-03-27T09:48:36+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d320a78e9", "title": "How PowerBI Composite Model Works", "url": "https://datamonkeysite.com/2022/03/24/how-powerbi-composite-model-works/", "published_at": "2022-03-24T10:27:35+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d327ada48", "title": "Optimize PowerBI Direct Query performance by using Star Schema and Dual Mode.", "url": "https://datamonkeysite.com/2022/03/20/optimize-powerbi-direct-query-performance-by-using-star-schema-and-dual-mode/", "published_at": "2022-03-20T11:15:02+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d3299937a", "title": "First Look at Thoughtspot Modeling language TML", "url": "https://datamonkeysite.com/2022/03/17/first-look-at-thoughtspot-modeling-language-tml/", "published_at": "2022-03-17T11:03:10+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d33902373", "title": "First Look at Dynamic M Query parameter using SQL Server", "url": "https://datamonkeysite.com/2022/03/08/first-look-at-dynamic-m-query-parameter-using-sql-server/", "published_at": "2022-03-08T03:02:11+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d3465126d", "title": "Track BI Engine using information Schema", "url": "https://datamonkeysite.com/2022/03/05/bi-engine-information-schema/", "published_at": "2022-03-05T09:45:11+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d350d6921", "title": "Poor man’s snapshot using PowerBI Dataflow", "url": "https://datamonkeysite.com/2022/02/27/poor-mans-snapshot-using-powerbi/", "published_at": "2022-02-27T10:42:36+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d352d204a", "title": "PowerBI Custom Chart Ranges", "url": "https://datamonkeysite.com/2022/02/26/powerbi-custom-chart-ranges/", "published_at": "2022-02-26T14:06:05+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d35f65826", "title": "Optimize BigQuery BI Engine Memory usage by Using Materialized Views", "url": "https://datamonkeysite.com/2022/02/15/optimize-bigquery-bi-engine-memory-usage-by-using-materialized-views/", "published_at": "2022-02-15T09:29:30+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d36eb6071", "title": "PowerBI Hybrid Table, you can have your cake and Eat it too.", "url": "https://datamonkeysite.com/2022/01/22/powerbi-hybrid-table-you-can-have-your-cake-and-it-is-too/", "published_at": "2022-01-22T06:25:03+00:00" }, { "id": "01a0c56b-90cb-733b-b0df-261d3753be2e", "title": "Benchmarking Synapse Serverless using TPC-H-SF10", "url": "https://datamonkeysite.com/2022/01/13/benchmarking-synapse-serverless-using-tpc-h-sf10/", "published_at": "2022-01-13T12:37:11+00:00" }, { "id": "01a0c575-3911-7241-b958-812b7534bff5", "title": "Benchmark Snowflake, BigQuery, SingleStore , Databricks, Datamart and DuckDB using TPC-H-SF10", "url": "https://datamonkeysite.com/2022/01/07/benchmark-snowflake-bigquery-singlestore-and-databricks-using-tpc-h-sf10/", "published_at": "2022-01-07T13:58:49+00:00" }, { "id": "01a0c575-3911-7241-b958-812b75b65807", "title": "First Look at SingleStore", "url": "https://datamonkeysite.com/2022/01/04/first-look-at-singlestore/", "published_at": "2022-01-04T12:56:19+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa685eca4804", "title": "PowerBI Vertipaq Vs Snowflake Vs BigQuery BI Engine", "url": "https://datamonkeysite.com/2021/12/28/powerbi-vertipaq-vs-snowflake-vs-bigquery-bi-engine/", "published_at": "2021-12-28T00:54:09+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa685ecd792e", "title": "First Impression of Databricks SQL", "url": "https://datamonkeysite.com/2021/12/22/first-impression-of-databricks-sql/", "published_at": "2021-12-22T05:44:48+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa685ef00950", "title": "BigQuery Materialized View optimization", "url": "https://datamonkeysite.com/2021/12/17/bigquery-materialized-view-optimization/", "published_at": "2021-12-17T07:14:11+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa685fe868ac", "title": "First Look at Synapse Dedicated Pool", "url": "https://datamonkeysite.com/2021/12/13/first-look-at-synapse-dedicated-pool/", "published_at": "2021-12-13T10:50:54+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa6860546dac", "title": "First Impression of Snowflake from a BigQuery user perspective.", "url": "https://datamonkeysite.com/2021/12/08/first-impression-of-snowflake-from-a-bigquery-user/", "published_at": "2021-12-08T12:35:45+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa6860a74542", "title": "BigQuery BI Engine behavior under Heavy Load", "url": "https://datamonkeysite.com/2021/12/04/bigquery-bi-engine-behavior-under-heavy-load/", "published_at": "2021-12-04T05:19:30+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa68613a2312", "title": "Synapse Serverless vs BigQuery BI Engine using a dataset under 10 GB", "url": "https://datamonkeysite.com/2021/11/27/synapse-serverless-vs-bigquery-bi-engine-using-a-dataset-under-10-gb/", "published_at": "2021-11-27T13:58:18+00:00" }, { "id": "01a0c575-3912-72b3-9627-fa686215c3ff", "title": "Analyse Big Spatial Dataset using hex bin maps in PowerBI", "url": "https://datamonkeysite.com/2021/11/15/analyse-big-spatial-dataset-using-hex-bin-maps-in-powerbi/", "published_at": "2021-11-15T05:44:46+00:00" }, { "id": "01a0c583-0884-7312-9911-11d279a3a295", "title": "Building Complex Data Model using Nested Data in BigQuery", "url": "https://datamonkeysite.com/2021/10/24/modeling-complex-data-model-using-nested-data-in-bigquery/", "published_at": "2021-10-24T11:07:50+00:00" }, { "id": "01a0c583-0884-7312-9911-11d279a53657", "title": "Model Header/Details Schema using Nested Data in BigQuery", "url": "https://datamonkeysite.com/2021/10/17/model-header-details-schema-using-nested-data-in-bigquery/", "published_at": "2021-10-17T10:30:22+00:00" }, { "id": "01a0c583-0884-7312-9911-11d279d4cf7d", "title": "“Modern” BI tools are missing something like PowerBI Composable SQL Generator", "url": "https://datamonkeysite.com/2021/10/03/modern-bi-tools-are-missing-something-like-powerbi-composable-sql-generator/", "published_at": "2021-10-03T12:03:09+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27a9dc52c", "title": "First look at Apache Superset from a PowerBI user perspective", "url": "https://datamonkeysite.com/2021/09/30/first-look-at-apache-superset-from-a-powerbi-user-perspective/", "published_at": "2021-09-30T11:34:28+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27b2d0d2a", "title": "Share Data from a PowerBI Dataset using Dataflow", "url": "https://datamonkeysite.com/2021/09/12/export-data-from-a-powerbi-dataset-using-dataflow/", "published_at": "2021-09-12T09:59:37+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27b7cc45e", "title": "Calculate route distance, Tableau vs PowerBI", "url": "https://datamonkeysite.com/2021/09/02/calculate-route-distance-tableau-vs-powerbi/", "published_at": "2021-09-02T08:14:57+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27c482f7a", "title": "Calculate the shortest Path in a network in PowerBI", "url": "https://datamonkeysite.com/2021/08/26/calculate-the-shortest-path-in-a-network-in-powerbi/", "published_at": "2021-08-26T10:36:59+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27d0779c4", "title": "Filtering by Dynamic Distance in PowerBI", "url": "https://datamonkeysite.com/2021/08/20/filtering-by-dynamic-distance-in-powerbi/", "published_at": "2021-08-20T10:08:33+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27d3956a3", "title": "Using PowerBI M Parameter to calculate a polygon Area", "url": "https://datamonkeysite.com/2021/08/15/using-powerbi-m-parameter-for-geospatial-calculation/", "published_at": "2021-08-15T08:30:50+00:00" }, { "id": "01a0c583-0884-7312-9911-11d27e0dcc4d", "title": "Multi select parameter support in BigQuery when using PowerBI", "url": "https://datamonkeysite.com/2021/08/14/multi-select-parameter-support-in-bigquery-when-using-powerbi/", "published_at": "2021-08-14T04:17:24+00:00" }, { "id": "01a0c591-073d-701f-92c0-21335085b55a", "title": "Dynamic Geospatial Clustering using BigQuery GIS", "url": "https://datamonkeysite.com/2021/08/02/dynamic-geospatial-clustering-using-bigquery-gis/", "published_at": "2021-08-02T06:31:13+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb2c19533", "title": "Building a Metrics Store using PowerBI", "url": "https://datamonkeysite.com/2021/07/24/building-a-metrics-store-using-powerbi/", "published_at": "2021-07-24T12:43:40+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb3bb65a3", "title": "First impression of Looker from a PowerBI user", "url": "https://datamonkeysite.com/2021/07/15/first-impression-of-looker/", "published_at": "2021-07-15T10:49:40+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb45688a6", "title": "BigQuery GEOGRAPHY Support in Data Studio", "url": "https://datamonkeysite.com/2021/04/06/bigquery-geography-support-in-data-studio/", "published_at": "2021-04-06T11:56:34+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb53ae669", "title": "PowerBI – Resource Profiles from P6", "url": "https://datamonkeysite.com/2021/04/03/powerbi-resource-profiles-from-p6/", "published_at": "2021-04-03T12:34:38+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb5cdafc1", "title": "First Look at BigQuery BI Engine with PowerBI", "url": "https://datamonkeysite.com/2021/03/31/first-look-at-bigquery-bi-engine-with-powerbi/", "published_at": "2021-03-31T09:27:45+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb6c172aa", "title": "PowerBI Incremental refresh Parquet files, without a Database.", "url": "https://datamonkeysite.com/2021/01/11/powerbi-incremental-refresh-parquet-files/", "published_at": "2021-01-11T12:10:31+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb793c9ab", "title": "Load Data to PowerBI Push Dataset using Easymorph", "url": "https://datamonkeysite.com/2021/01/10/load-data-to-powerbi-push-dataset-using-easymorph/", "published_at": "2021-01-10T03:07:19+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb85c2cd3", "title": "Pushdown Filters to Parquet From PowerBI Using Synapse Serverless", "url": "https://datamonkeysite.com/2021/01/07/pushdown-filters-in-synapse-serverless-from-powerbi/", "published_at": "2021-01-07T13:07:14+00:00" }, { "id": "01a0c591-073e-729a-94e1-795fb869d38f", "title": "Push Dataset in PowerBI Composite Model, Near real Time made easy !!!", "url": "https://datamonkeysite.com/2021/01/05/push-dataset-in-powerbi-composite-model/", "published_at": "2021-01-05T04:54:14+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f531e99f", "title": "Refresh individual Tables using The Composite Model in PowerBI", "url": "https://datamonkeysite.com/2020/12/31/refresh-individual-tables-using-the-enhanced-semantic-model-in-powerbi/", "published_at": "2020-12-31T01:57:51+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f584f679", "title": "Building a Modern Data Stack using BigQuery, Dataform and PowerBI", "url": "https://datamonkeysite.com/2020/12/26/prepare-powerbi-tables-with-sql-transformation-using-dataform/", "published_at": "2020-12-26T11:19:31+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f63fda5f", "title": "Drill Down to another page in Google Data Studio, the easy way", "url": "https://datamonkeysite.com/2020/11/29/drill-down-to-another-page-in-google-data-studio-the-easy-way/", "published_at": "2020-11-29T12:11:42+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f6b3b90a", "title": "Dynamic Weekend using Parameter in PowerBI", "url": "https://datamonkeysite.com/2020/11/05/dynamic-weekend-using-parameter-in-powerbi/", "published_at": "2020-11-05T04:31:15+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f6f16f40", "title": "Dynamic Date Granularity using Parameter in Google Data Studio", "url": "https://datamonkeysite.com/2020/10/27/dynamic-date-granularity-using-parameter-in-google-data-studio/", "published_at": "2020-10-27T03:31:40+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f7326e5f", "title": "Change Dimension Dynamically using Parameter in PowerBI", "url": "https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/", "published_at": "2020-10-22T09:34:51+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f75883fb", "title": "Using PowerBI with Azure Synapse Serverless, First Look", "url": "https://datamonkeysite.com/2020/10/11/using-powerbi-with-azure-synapse-serverless/", "published_at": "2020-10-11T13:33:12+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f81a2a4c", "title": "Three years to finish a Dashboard", "url": "https://datamonkeysite.com/2020/09/27/building-a-construction-dashboard-using-google-data-studio/", "published_at": "2020-09-27T12:50:06+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f8b1933a", "title": "Row Level Security Using Parameter in Google Data Studio", "url": "https://datamonkeysite.com/2020/09/13/row-level-security-using-parameter-in-google-data-studio/", "published_at": "2020-09-13T13:45:29+00:00" }, { "id": "01a0e753-e10e-702e-a9f0-aa98f8c4e72d", "title": "Drill Down to Another Page in Google Data Studio", "url": "https://datamonkeysite.com/2020/09/12/drill-down-to-another-page-in-google-data-studio/", "published_at": "2020-09-11T15:27:50+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d86578e1f479", "title": "Change the color of one category in a chart", "url": "https://datamonkeysite.com/2020/09/08/change-the-color-of-one-category-in-a-chart/", "published_at": "2020-09-08T09:39:37+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657925a368", "title": "Top Performing items by category using Google Data Studio SQL Parameter", "url": "https://datamonkeysite.com/2020/08/23/top-performing-items-by-category-using-google-data-studio-sql-parameter/", "published_at": "2020-08-23T08:20:03+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657a1e2b36", "title": "How to calculate percentage of row using Google Data Studio Parameter", "url": "https://datamonkeysite.com/2020/08/22/how-to-calculate-percentage-of-row-using-google-data-studio-parameter/", "published_at": "2020-08-22T08:39:27+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657a5f0c82", "title": "Change the color of a bar chart based on a value using Google Data Studio Parameter", "url": "https://datamonkeysite.com/2020/08/22/change-the-color-of-a-bar-chart-based-on-a-value-using-google-data-studio-parameter/", "published_at": "2020-08-21T15:17:33+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657a84191d", "title": "Create Dynamic goal line on a bar Chart using Google Data Studio Parameter", "url": "https://datamonkeysite.com/2020/08/22/create-dynamic-goal-line-on-a-bar-chart-using-google-data-studio-parameter/", "published_at": "2020-08-21T14:38:32+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657b1cc74c", "title": "Dynamic Change of Dimension using Google Data Studio Parameter", "url": "https://datamonkeysite.com/2020/08/21/dynamic-change-of-dimension-using-google-data-studio/", "published_at": "2020-08-21T09:56:07+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657c199d09", "title": "Connect Streamlit to PowerBI service using XMLA end point", "url": "https://datamonkeysite.com/2020/08/16/connect-streamlit-to-powerbi-service-using-xmla-end-point/", "published_at": "2020-08-16T05:47:01+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657cf92447", "title": "How to plot Digital Elevation Model in Data Studio.", "url": "https://datamonkeysite.com/2020/07/27/how-to-plot-digital-elevation-model-in-datastudio/", "published_at": "2020-07-27T08:46:14+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657df4aec2", "title": "Using the new Convexhull function in BigQuery to reduce Geometry complexity", "url": "https://datamonkeysite.com/2020/07/21/using-the-new-convexhull-function-in-bigquery-to-reduce-geometry-complexity/", "published_at": "2020-07-21T04:47:39+00:00" }, { "id": "01a0e769-8e5c-72ea-8e20-d8657e53d3ec", "title": "NASA Apollo Cost Tracker", "url": "https://datamonkeysite.com/2020/07/08/nasa-apollo-cost-tracker/", "published_at": "2020-07-08T11:09:39+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b69456a0c", "title": "Rendering 1.2 Million points in PowerBI using Icon Map", "url": "https://datamonkeysite.com/2020/07/06/rendering-1-2-million-points-in-powerbi-using-icon-map/", "published_at": "2020-07-06T06:46:13+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6a40e866", "title": "How to build Compact layout Pivot Table in Google Data Studio", "url": "https://datamonkeysite.com/2020/06/29/how-to-build-compact-layout-pivot-table-in-google-datastudio/", "published_at": "2020-06-29T03:49:05+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6b2f502c", "title": "Is Google Data Studio Ready for Complex Business Reports ?", "url": "https://datamonkeysite.com/2020/06/27/is-google-datastudio-ready-for-complex-business-reports/", "published_at": "2020-06-27T10:15:04+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6b36008b", "title": "Integrated EPCM Management – Engineering Progress", "url": "https://datamonkeysite.com/2020/06/25/integrated-epcm-management-engineering-progress/", "published_at": "2020-06-25T09:07:48+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6bc851c8", "title": "Data Integration – Commissioning Test Sheets / P6", "url": "https://datamonkeysite.com/2020/05/30/data-integration-commissioning-test-sheets-p6/", "published_at": "2020-05-30T11:50:53+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6c7f1872", "title": "How to Model Primavera Activity ID and Quantity Measurement System using Multiple to Multiple in PowerBI", "url": "https://datamonkeysite.com/2020/05/19/how-to-model-primavera-activity-id-and-quantity-measurement-system-using-multiple-to-multiple-in-powerbi/", "published_at": "2020-05-19T14:22:32+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6d5e74c5", "title": "PowerBI Progress & Schedule Dashboard – By Darrin Kinney", "url": "https://datamonkeysite.com/2020/05/18/powerbi-progress-schedule-dashboard-by-darrin-kinney/", "published_at": "2020-05-18T10:38:31+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6d8f0fad", "title": "Digital Transformation – McKinsey Practices – Darrin Kinney Commentary", "url": "https://datamonkeysite.com/2020/05/15/digital-transformation-mckinsey/", "published_at": "2020-05-15T09:33:57+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6e3dba18", "title": "Analyzing GIS data using BigQuery and PowerBI", "url": "https://datamonkeysite.com/2020/04/07/analyzing-openstreet-map-data-using-bigquery-and-powerbi/", "published_at": "2020-04-07T06:47:59+00:00" }, { "id": "01a0e782-b803-73f8-be7e-2d2b6e9f4c7a", "title": "Digital Strategy in Construction – The Videos", "url": "https://datamonkeysite.com/2020/02/21/digital-strategy-in-construction-the-videos1-2/", "published_at": "2020-02-21T11:47:16+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4a3b2ebe", "title": "SharePoint / PowerBI / Primavera P6 Integration – By Darrin Kinney", "url": "https://datamonkeysite.com/2020/01/22/sharepoint-powerbi-primavera-p6-integration/", "published_at": "2020-01-22T08:18:53+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4a427235", "title": "Agile in Construction", "url": "https://datamonkeysite.com/2020/01/06/agile-in-construction/", "published_at": "2020-01-06T02:32:48+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4aec6289", "title": "How to reduce data volume in PowerBI Maps by using WKT", "url": "https://datamonkeysite.com/2019/12/21/how-to-reduce-data-volume-in-powerbi-maps-by-using-wkt/", "published_at": "2019-12-21T02:33:31+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4b433bdd", "title": "Controls Accounts for Cost – Houston we have a (possible) problem", "url": "https://datamonkeysite.com/2019/12/19/controls-accounts-for-cost-houston-we-have-a-possible-problem/", "published_at": "2019-12-19T00:38:06+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4bfbb00c", "title": "Load Raster tiles to PowerBI Data Model using R", "url": "https://datamonkeysite.com/2019/12/06/load-raster-tiles-to-powerbi-data-model/", "published_at": "2019-12-06T00:59:31+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4ce127fc", "title": "Normalize multiple progress files using PowerQuery", "url": "https://datamonkeysite.com/2019/12/02/normalize-multiple-progress-files-using-powerquery/", "published_at": "2019-12-02T06:10:15+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4d94cf94", "title": "PowerBI, generate multiple Print quality Maps using R", "url": "https://datamonkeysite.com/2019/11/26/powerbi-generate-multiple-print-quality-maps-using-r/", "published_at": "2019-11-26T00:22:30+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4e424250", "title": "PowerBI Incremental refresh using Python or R", "url": "https://datamonkeysite.com/2019/11/21/powerbi-incremental-refresh-using-python-or-r/", "published_at": "2019-11-21T03:43:09+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4ee09f37", "title": "How to Keep Your Primavera P6 Clean?", "url": "https://datamonkeysite.com/2019/11/20/how-to-keep-your-primavera-p6-clean/", "published_at": "2019-11-20T09:29:57+00:00" }, { "id": "01a0e7a2-caf6-7075-9b96-a65c4f3e38c1", "title": "How to Export data from PowerQuery to BigQuery", "url": "https://datamonkeysite.com/2019/11/17/how-to-export-data-from-powerquery-to-bigquery/", "published_at": "2019-11-17T10:14:04+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4ba15b5d", "title": "Construction Progress Report – PowerBI – by Darrin Kinney", "url": "https://datamonkeysite.com/2019/11/15/construction-progress-report-powerbi-by-darrin-kinney/", "published_at": "2019-11-15T13:09:18+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4c9ae49c", "title": "Custom SQL in Google Data Studio", "url": "https://datamonkeysite.com/2019/10/28/custom-sql-in-google-datastudio/", "published_at": "2019-10-28T06:03:24+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4ca956ca", "title": "Engineering Progress Report – PowerBI – by Darrin Kinney", "url": "https://datamonkeysite.com/2019/10/05/engineering-progress-report-powerbi/", "published_at": "2019-10-05T13:05:03+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4ceebe71", "title": "Planning and Project Management – What is Missing", "url": "https://datamonkeysite.com/2019/09/08/planning-and-project-management-what-is-missing/", "published_at": "2019-09-08T01:32:36+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4d2ee5cc", "title": "How to Build a near real time Dashboard using Data Studio and BigQuery", "url": "https://datamonkeysite.com/2019/09/07/how-to-build-a-near-real-time-dashboard-using-datastudio-and-bigquery/", "published_at": "2019-09-07T10:12:05+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4d946734", "title": "Construction Map time playback using Kepler.gl", "url": "https://datamonkeysite.com/2019/08/27/construction-map-time-playback-using-kepler-gl/", "published_at": "2019-08-27T07:52:05+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4db03404", "title": "Build asymmetrical Pivot table in PowerBI", "url": "https://datamonkeysite.com/2019/08/20/build-asymmetrical-pivot-table-in-powerbi/", "published_at": "2019-08-20T10:54:22+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4db83605", "title": "Level 1 Reporting – Source Excel Data – By Darrin Kinney", "url": "https://datamonkeysite.com/2019/08/16/level-1-reporting-source-excel-data/", "published_at": "2019-08-16T10:31:47+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4e948532", "title": "Connecting PowerBI to Primavera, Implement Row Level security", "url": "https://datamonkeysite.com/2019/07/22/connecting-powerbi-to-primavera-implement-row-level-security/", "published_at": "2019-07-22T07:57:22+00:00" }, { "id": "01a0e7ca-8a61-73d9-adef-fccf4edc1dc2", "title": "P6 Date Formats – Quick Data Hacks!", "url": "https://datamonkeysite.com/2019/07/22/p6-date-formats-quick-data-hacks/", "published_at": "2019-07-22T02:07:25+00:00" } ] posts Claim your blog
Back to datamonkeysite.com
Blog · corpus.blog/blogs/datamonkeysite.com/posts

datamonkeysite.com

datamonkeysite.com

2022

Delta lake with Python, Local Storage and DuckDBoriginal ↗
28 Jun 2022
CPM is Broken – The WHYoriginal ↗
18 Jun 2022
Loading 1 Billion New York Taxi Dataset into Datamartoriginal ↗
9 Jun 2022
Why Datamart is a Big Dealoriginal ↗
3 Jun 2022
First Look at Datamartoriginal ↗
24 May 2022
PowerBI vs Thoughtspot Semantic Model and Why Pricing is an Engineering Problem.original ↗
14 May 2022
The simplest way to merge Multiple Tables in Google Data Studiooriginal ↗
7 May 2022
Tableau vs PowerBI behavior in Direct Query Mode , Result Cacheoriginal ↗
1 May 2022
Using DuckDB with PowerBIoriginal ↗
17 Apr 2022
PowerBI Direct Quey modeling using flat Tableoriginal ↗
27 Mar 2022
How PowerBI Composite Model Worksoriginal ↗
24 Mar 2022
Optimize PowerBI Direct Query performance by using Star Schema and Dual Mode.original ↗
20 Mar 2022
First Look at Thoughtspot Modeling language TMLoriginal ↗
17 Mar 2022
First Look at Dynamic M Query parameter using SQL Serveroriginal ↗
8 Mar 2022
Track BI Engine using information Schemaoriginal ↗
5 Mar 2022
Poor man’s snapshot using PowerBI Datafloworiginal ↗
27 Feb 2022
PowerBI Custom Chart Rangesoriginal ↗
26 Feb 2022
Optimize BigQuery BI Engine Memory usage by Using Materialized Viewsoriginal ↗
15 Feb 2022
PowerBI Hybrid Table, you can have your cake and Eat it too.original ↗
22 Jan 2022
Benchmarking Synapse Serverless using TPC-H-SF10original ↗
13 Jan 2022
Benchmark Snowflake, BigQuery, SingleStore , Databricks, Datamart and DuckDB using TPC-H-SF10original ↗
7 Jan 2022
First Look at SingleStoreoriginal ↗
4 Jan 2022

2021

PowerBI Vertipaq Vs Snowflake Vs BigQuery BI Engineoriginal ↗
28 Dec 2021
First Impression of Databricks SQLoriginal ↗
22 Dec 2021
BigQuery Materialized View optimizationoriginal ↗
17 Dec 2021
First Look at Synapse Dedicated Pooloriginal ↗
13 Dec 2021
First Impression of Snowflake from a BigQuery user perspective.original ↗
8 Dec 2021
BigQuery BI Engine behavior under Heavy Loadoriginal ↗
4 Dec 2021
Synapse Serverless vs BigQuery BI Engine using a dataset under 10 GBoriginal ↗
27 Nov 2021
Analyse Big Spatial Dataset using hex bin maps in PowerBIoriginal ↗
15 Nov 2021
Building Complex Data Model using Nested Data in BigQueryoriginal ↗
24 Oct 2021
Model Header/Details Schema using Nested Data in BigQueryoriginal ↗
17 Oct 2021
“Modern” BI tools are missing something like PowerBI Composable SQL Generatororiginal ↗
3 Oct 2021
First look at Apache Superset from a PowerBI user perspectiveoriginal ↗
30 Sept 2021
Share Data from a PowerBI Dataset using Datafloworiginal ↗
12 Sept 2021
Calculate route distance, Tableau vs PowerBIoriginal ↗
2 Sept 2021
Calculate the shortest Path in a network in PowerBIoriginal ↗
26 Aug 2021
Filtering by Dynamic Distance in PowerBIoriginal ↗
20 Aug 2021
Using PowerBI M Parameter to calculate a polygon Areaoriginal ↗
15 Aug 2021
Multi select parameter support in BigQuery when using PowerBIoriginal ↗
14 Aug 2021
Dynamic Geospatial Clustering using BigQuery GISoriginal ↗
2 Aug 2021
Building a Metrics Store using PowerBIoriginal ↗
24 Jul 2021
First impression of Looker from a PowerBI useroriginal ↗
15 Jul 2021
BigQuery GEOGRAPHY Support in Data Studiooriginal ↗
6 Apr 2021
PowerBI – Resource Profiles from P6original ↗
3 Apr 2021
First Look at BigQuery BI Engine with PowerBIoriginal ↗
31 Mar 2021
PowerBI Incremental refresh Parquet files, without a Database.original ↗
11 Jan 2021
Load Data to PowerBI Push Dataset using Easymorphoriginal ↗
10 Jan 2021
Pushdown Filters to Parquet From PowerBI Using Synapse Serverlessoriginal ↗
7 Jan 2021
Push Dataset in PowerBI Composite Model, Near real Time made easy !!!original ↗
5 Jan 2021

2020

Refresh individual Tables using The Composite Model in PowerBIoriginal ↗
31 Dec 2020
Building a Modern Data Stack using BigQuery, Dataform and PowerBIoriginal ↗
26 Dec 2020
Drill Down to another page in Google Data Studio, the easy wayoriginal ↗
29 Nov 2020
Dynamic Weekend using Parameter in PowerBIoriginal ↗
5 Nov 2020
Dynamic Date Granularity using Parameter in Google Data Studiooriginal ↗
27 Oct 2020
Change Dimension Dynamically using Parameter in PowerBIoriginal ↗
22 Oct 2020
Using PowerBI with Azure Synapse Serverless, First Lookoriginal ↗
11 Oct 2020
Three years to finish a Dashboardoriginal ↗
27 Sept 2020
Row Level Security Using Parameter in Google Data Studiooriginal ↗
13 Sept 2020
Drill Down to Another Page in Google Data Studiooriginal ↗
11 Sept 2020
Change the color of one category in a chartoriginal ↗
8 Sept 2020
Top Performing items by category using Google Data Studio SQL Parameteroriginal ↗
23 Aug 2020
How to calculate percentage of row using Google Data Studio Parameteroriginal ↗
22 Aug 2020
Change the color of a bar chart based on a value using Google Data Studio Parameteroriginal ↗
21 Aug 2020
Create Dynamic goal line on a bar Chart using Google Data Studio Parameteroriginal ↗
21 Aug 2020
Dynamic Change of Dimension using Google Data Studio Parameteroriginal ↗
21 Aug 2020
Connect Streamlit to PowerBI service using XMLA end pointoriginal ↗
16 Aug 2020
How to plot Digital Elevation Model in Data Studio.original ↗
27 Jul 2020
Using the new Convexhull function in BigQuery to reduce Geometry complexityoriginal ↗
21 Jul 2020
NASA Apollo Cost Trackeroriginal ↗
8 Jul 2020
Rendering 1.2 Million points in PowerBI using Icon Maporiginal ↗
6 Jul 2020
How to build Compact layout Pivot Table in Google Data Studiooriginal ↗
29 Jun 2020
Is Google Data Studio Ready for Complex Business Reports ?original ↗
27 Jun 2020
Integrated EPCM Management – Engineering Progressoriginal ↗
25 Jun 2020
Data Integration – Commissioning Test Sheets / P6original ↗
30 May 2020
How to Model Primavera Activity ID and Quantity Measurement System using Multiple to Multiple in PowerBIoriginal ↗
19 May 2020
PowerBI Progress & Schedule Dashboard – By Darrin Kinneyoriginal ↗
18 May 2020
Digital Transformation – McKinsey Practices – Darrin Kinney Commentaryoriginal ↗
15 May 2020
Analyzing GIS data using BigQuery and PowerBIoriginal ↗
7 Apr 2020
Digital Strategy in Construction – The Videosoriginal ↗
21 Feb 2020
SharePoint / PowerBI / Primavera P6 Integration – By Darrin Kinneyoriginal ↗
22 Jan 2020
Agile in Constructionoriginal ↗
6 Jan 2020

2019

How to reduce data volume in PowerBI Maps by using WKToriginal ↗
21 Dec 2019
Controls Accounts for Cost – Houston we have a (possible) problemoriginal ↗
19 Dec 2019
Load Raster tiles to PowerBI Data Model using Roriginal ↗
6 Dec 2019
Normalize multiple progress files using PowerQueryoriginal ↗
2 Dec 2019
PowerBI, generate multiple Print quality Maps using Roriginal ↗
26 Nov 2019
PowerBI Incremental refresh using Python or Roriginal ↗
21 Nov 2019
How to Keep Your Primavera P6 Clean?original ↗
20 Nov 2019
How to Export data from PowerQuery to BigQueryoriginal ↗
17 Nov 2019
Construction Progress Report – PowerBI – by Darrin Kinneyoriginal ↗
15 Nov 2019
Custom SQL in Google Data Studiooriginal ↗
28 Oct 2019
Engineering Progress Report – PowerBI – by Darrin Kinneyoriginal ↗
5 Oct 2019
Planning and Project Management – What is Missingoriginal ↗
8 Sept 2019
How to Build a near real time Dashboard using Data Studio and BigQueryoriginal ↗
7 Sept 2019
Construction Map time playback using Kepler.gloriginal ↗
27 Aug 2019
Build asymmetrical Pivot table in PowerBIoriginal ↗
20 Aug 2019
Level 1 Reporting – Source Excel Data – By Darrin Kinneyoriginal ↗
16 Aug 2019
Connecting PowerBI to Primavera, Implement Row Level securityoriginal ↗
22 Jul 2019
P6 Date Formats – Quick Data Hacks!original ↗
22 Jul 2019
Previous Next