fbpx

About pleblanc

This author has not yet filled in any details.
So far pleblanc has created 213 blog entries.

You thought DAX? Alex shows you Dynamic M-M-Magic!

We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you! Connect with Alex: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ Power Query folding https://docs.microsoft.com/power-query/power-query-folding 30 Day Challenge: Query Folding https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Power Query [...]

You thought DAX? Alex shows you Dynamic M-M-Magic!2022-08-10T05:51:34-05:00

Top 5 things to get started with Azure Synapse Analytics

Getting started with Azure Synapse Analytics? Here are 5 things you should know as you begin your journey! Already been using Synapse SQL dedicated pools? Are you aware of these items? Connect with Shane: https://www.linkedin.com/in/shanerisk/ Best Practices: https://docs.microsoft.com/azure/synapse-analytics/sql/best-practices-dedicated-sql-pool What is dedicated: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-overview-what-is Table Distribution: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute Indexes: https://docs.microsoft.com/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index Statistics: https://docs.microsoft.com/azure/synapse-analytics/sql/develop-tables-statistics Data Loading: https://docs.microsoft.com/azure/synapse-analytics/sql/data-loading-best-practices

Top 5 things to get started with Azure Synapse Analytics2022-08-09T07:55:42-05:00

Can you be a Data Scientist without actually being a Data Scientist???

Forecasting data and other items are usually stuff that data scientists use to tell the future. What if you could do the same thing - EASILY! Tzvia is back to show you how Azure Data Explorer can help! Connect with Tzvia: https://www.linkedin.com/in/tzvia/ https://twitter.com/tzvia Time series analysis in Azure Data Explorer https://docs.microsoft.com/azure/data-explorer/time-series-analysis Anomaly detection and forecasting [...]

Can you be a Data Scientist without actually being a Data Scientist???2022-08-02T06:19:47-05:00

Discovering data within Power BI and quickly EXPORT!

Sometimes you just don't know what data is out there in Power BI. Patrick shows you how you can discover data available to you and also how to quickly export that data! Even with just a Pro account! Data discovery using the data hub https://docs.microsoft.com/power-bi/connect-data/service-data-hub?tabs=datasets Create exportable formatted data tables in the Power BI service [...]

Discovering data within Power BI and quickly EXPORT!2022-07-27T06:19:57-05:00

FAST – Billions of rows with Azure Data Explorer (ADX)

Have you tried Azure Data Explorer? We look at how ADX can support large amounts of data and query at blazing fast speeds. it truly is BANANAS! And you can try it for FREE! Connect with Tzvia: https://www.linkedin.com/in/tzvia/ https://twitter.com/tzvia What is Azure Data Explorer? https://docs.microsoft.com/azure/data-explorer/data-explorer-overview Create a free Azure Data Explorer cluster https://docs.microsoft.com/azure/data-explorer/start-for-free-web-ui Azure Data [...]

FAST – Billions of rows with Azure Data Explorer (ADX)2022-07-26T07:36:42-05:00

A new approach for dynamic Power BI visuals?

Want to give report users a way to control Power BI visuals dynamically? Don't want to use the personalize visual feature? Interesting!!! Patrick has an approach that may fit the need! Dynamic X and Y Axis in Power BI visuals? Yes please! https://www.youtube.com/watch?v=1eurc0EY2Xg A different perspective with Power BI Personalized Visuals https://www.youtube.com/watch?v=20HwiEhIShc

A new approach for dynamic Power BI visuals?2022-07-20T06:19:56-05:00

Intro to aggregates in T-SQL

Getting started with T-SQL? Patrick looks at using aggregate functions within your statements to help get the right results. If you are just starting with T-SQL in either Azure SQL Database or Azure Synapse Analytics, this is for you! Transact-SQL Reference (Database Engine) https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16 Aggregate Functions (Transact-SQL) https://docs.microsoft.com/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver16

Intro to aggregates in T-SQL2022-07-19T06:36:19-05:00

Dynamic X and Y Axis in Power BI visuals? Yes please!

Have you wanted both dynamic X and Y axis within a Power BI visual? Patrick shows you how you can use Field Parameters to accomplish it! Let report readers use field parameters to change visuals https://docs.microsoft.com/power-bi/create-reports/power-bi-field-parameters

Dynamic X and Y Axis in Power BI visuals? Yes please!2022-07-06T06:53:30-05:00

What’s up with the different JOINS in Azure SQL and Azure Synapse?

Not sure what the different JOINs mean in Azure Synapse Analytics and Azure SQL Database? Patrick walks you through the different types to get you on the right path! Joins (SQL Server) https://docs.microsoft.com/sql/relational-databases/performance/joins?view=sql-server-ver16

What’s up with the different JOINS in Azure SQL and Azure Synapse?2022-06-28T08:00:30-05:00

From Decomposition Tree to Details in Power BI!!!

The Decomposition Tree is an amazing visual but how can we get to the details. Where's my drill through? Patrick walks you through how you can set this up in Power BI Desktop! Create and view decomposition tree visuals in Power BI https://docs.microsoft.com/power-bi/visuals/power-bi-visualization-decomposition-tree Set up drillthrough in Power BI reports https://docs.microsoft.com/power-bi/create-reports/desktop-drillthrough Wyn Hopkins https://twitter.com/wynhopkins

From Decomposition Tree to Details in Power BI!!!2022-06-22T09:03:00-05:00
Go to Top