fbpx

Writing your first SQL Statement!

New to writing T-SQL? Patrick walks you through your first SQL statement. Great foundation to have when working with SQL Server or Azure Synapse Analytics! Download SQL Server Management Studio https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms Download and install Azure Data Studio https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio Transact-SQL Reference (Database Engine) https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

Writing your first SQL Statement!2022-05-31T08:36:02-05:00

🔴 Power BI tips from the Pros – LIVE (May 28, 2022) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 [...]

🔴 Power BI tips from the Pros – LIVE (May 28, 2022) (Member Chat 2nd Half)2022-05-27T08:21:02-05:00

Reduce the queries being sent with Incremental Refresh in Power BI!

Have you noticed some extra queries being sent when using Incremental Refresh in Power BI? Patrick explains why this could happen and a potential workaround. Privacy Levels: https://docs.microsoft.com/power-bi/enterprise/desktop-privacy-levels

Reduce the queries being sent with Incremental Refresh in Power BI!2022-05-26T07:18:26-05:00

Exploring the preview of datamart in Power BI!

We take a look at the newly announced preview of datamart in Power BI! A no code experience to build a relational database for analytics right inside Power BI! Announcement Blog: https://powerbi.microsoft.com/blog/announcing-public-preview-of-datamart-in-power-bi/ Documentation: https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Exploring the preview of datamart in Power BI!2022-05-25T06:19:14-05:00

Getting started with Azure Synapse Analytics

Not sure where to begin with Azure Synapse Analytics? Patrick gets you started and teaches you the clicks to get up and running quickly! Get Started with Azure Synapse Analytics https://docs.microsoft.com/azure/synapse-analytics/get-started

Getting started with Azure Synapse Analytics2022-05-24T06:44:12-05:00

Another 30 Day Query Folding challenge!!!

Here is another 30-day Query Folding challenge video for you. Patrick takes on Day 7 and ramps up his Power Query knowledge! Will Power BI Desktop get the best of him??? GitHub Repot: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY

Another 30 Day Query Folding challenge!!!2022-05-18T09:20:00-05:00

Are you following best practices with Azure Synapse Analytics?

How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It's a great way to get an understanding where your database is at! Azure Synapse Analyzer Report to monitor and improve Azure Synapse SQL Dedicated Pool performance https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/azure-synapse-analyzer-report-to-monitor-and-improve-azure/ba-p/3276960 Download [...]

Are you following best practices with Azure Synapse Analytics?2022-05-14T15:14:25-05:00

🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI! 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 [...]

🔴 Power BI tips from the Pros – LIVE (May 14, 2022) (Member Chat 2nd Half)2022-05-13T06:12:36-05:00

How do you share your Power BI Dataset for someone to review?

Need to have someone review your Power BI dataset for best practices and approval? Don't want to send them the full Power BI Desktop file and risk sharing data? Patrick walks you through some options that you have.

How do you share your Power BI Dataset for someone to review?2022-05-12T06:25:46-05:00

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion! DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/ Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???2022-05-11T06:40:26-05:00
Go to Top