fbpx

About pleblanc

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

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

What if we could RATE a Power BI report page?

Have you wanted the ability to give ratings or feedback on Power BI reports? Have your users tell you what they think? Patrick shows you a way you can do this using Power Automate!

What if we could RATE a Power BI report page?2022-08-19T07:06:47-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

Select All items for Parameters in Power BI Paginated reports

Ever struggled with trying to get a parameter to select all items by default in a Power BI Paginated report? Patrick walks you through how to get this working! Create parameters for paginated reports in the Power BI service https://docs.microsoft.com/power-bi/paginated-reports/paginated-reports-parameters

Select All items for Parameters in Power BI Paginated reports2022-08-19T07:05:28-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
Go to Top