BenMakesDataEasy

Follower of Jesus | #SQLServer | Python | Machine Learning | Building an app for #PowerBI | | Helping make data easier to work with

[BenMakesDataEasy @data_ben]

A little more walk through on a new forecasting script I created that ties together Python + FB Prophet + Power BI : )

Check out the script used in the community area on my YouTube channel. Greatly appreciate likes/subscribes there as well : )

Keep at it everyone!

https://t.co/37oYCUO7Ro

[BenMakesDataEasy @data_ben]

Forecasting is a game changer in the realm of data analytics : ) Watch me easily create a Python + FB Prophet + Power BI forecasting tool in under an hour : ) Cool factor 1 million.....maybe 1 billion!

[Kurt Buhler @kurtbuhler]

Visualize your semantic model data with Vega/D3.js from Fabric with data apps - a type of Fabric app. Custom web dashboards are now possible.

This is probably the most interested I've been in a new Power BI or Fabric feature, ever.

Read about it: https://t.co/3NC2lnUwOF

[𝘎𝘪𝘭𝘣𝘦𝘳𝘵 #FourMoo @GilbertQue]

Read this blog post if you want to get an overview of all the new #MicrosoftFabric announcements! They are so awesome, I just need to find the time to try them out. https://t.co/V0WsLk6MxT

[Kurt Buhler @kurtbuhler]

I love this - the Fabric CLI is my favorite feature from the Fabric team. It does create a bit of confusion among those using i.e. semantic link labs in notebooks already.

Anything I automated with notebooks before I've moved out of fabric with the CLI to i.e. actions/pipelines

[Marco Russo @marcorus]

Hot take for a Saturday morning:

The new card visual debate has produced more LinkedIn posts than actual card visuals in production.

Anyway, if you're tired of the whole thing, OKViz has this thing called Card with States. States, thresholds, colors, you know the drill. Certified and free forever. Just saying. https://t.co/PkTMrFag0T

How did you actually handle the switch? Wrong answers only, it’s Saturday ;)

[Kurt Buhler @kurtbuhler]

In 2 hours (18:00 CET) Peer from Tabular Editor will be presenting the Tabular Editor CLI - come check it out and see why I'm so excited about this. https://t.co/LZGY878ioI

[Kurt Buhler @kurtbuhler]

The XMLA endpoint in Power BI - What is it, and how do you use it?

This article by Ruben walks through the basics of the XMLA endpoint and why it's interesting not just for external tools but also Power BI Desktop and AI integrations via MCP/CLI.

Link: https://t.co/1QjH1sbMEB

[Kurt Buhler @kurtbuhler]

This blog by Bernat compares DAX UDFs and calculation groups when you have to calculate time intelligence.

Link: https://t.co/7Li2Jr6HnF

[𝘎𝘪𝘭𝘣𝘦𝘳𝘵 #FourMoo @GilbertQue]

Custom Live pools in #MicrosoftFabric allows for your notebooks to start quicker and can be used with Managed Endpoints https://t.co/yXp4YYry7V

[Kurt Buhler @kurtbuhler]

How you name things - workspaces, items, tables, fields, folders, and even variables - is very important. Not just for organization / consistency, but for better results using AI for dev or conversational BI.

Naming conventions for a semantic model: https://t.co/vme2uwHsBg

[Mim @mim_djo]

#dbt + #duckdb + #apacheiceberg +#onelake Catalog is on
🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥🔥

https://t.co/2aXhWgOdjZ

[Hoyt Emerson @HoytEmerson]

DuckLake solves streaming to a lakehouse without the "Small File" nightmare. This is primarily done through their elegant inlining feature.

Start here to get a deeper look:
https://t.co/CgnJPAzRyE

[John Kerski @JKerski]

If you haven’t checked out Aleksi Partanen's YouTube it's worth a look. He offers excellent Fabric tutorials, and if you’re trying to pull secrets from Azure Key Vault into a Gen2 dataflow as a parameter, this video is a great place to start:
https://t.co/lWKk5xnYa5

[Mim @mim_djo]

Can you do real ACID writes on Delta from pure Python? of course !! no catalog needed — just pip install deltalake and a path.
#rust #deltalake #python #polars #duckdb #datafusion
https://t.co/qaXlYAnD8h

[Hoyt Emerson @HoytEmerson]

DuckDB is one of my favorite data technologies, but I have found it a little difficult to know exactly where to start.

So I kicked off a "DuckDB Basics" series. My first article was on using SQL in the CLI. Here is the companion video for that article.

https://t.co/hOMLcLiXrg

[Marco Russo @marcorus]

We spend a lot of energy making fun of BI analysts and developers. This time it's the users' turn.

User-aware calculated columns are now a thing in DAX. The report can personalize itself based on who's viewing it. Translations, dynamic content, no RLS needed.

Turns out, not everyone loves the idea of their report knowing who they are. Which raises two questions: 
1) Have you ever heard of system logs?
2) What exactly are you doing in that report that you don't want anyone to know about? 😎

If you want the technical details: https://t.co/lJnPiPaZmm

[Chandeep Chhabra @chandeep2786]

The Simplest Way to Connect Claude and Power BI

[Marco Russo @marcorus]

What kind of parameters can you use in DAX user-defined functions?

This video introduces parameter types and passing modes in DAX UDFs: learning the difference between VAR and EXPR passing modes is the critical element to learn.

A practical demo to understand how parameters work in UDFs and why they matter when creating reusable DAX logic.

Watch the full video here: https://t.co/vYLPhnjlU4

[Nikola Ilic @DataMozart]

NEW BLOG POST!

Quick question for Fabric Warehouse folks:
If clustering reduces CPU by 40% and I/O by 69%, but elapsed time stays the same, is it working?

Yes. And the explanation is more interesting than the answer.

100M-row demo with real numbers:
https://t.co/W2LwRPJIUM

[Daniil Maslyuk @DMaslyuk]

Finally: pixel-perfect column widths in Power BI!

[Alex Freberg @Alex_TheAnalyst]

I currently run 3 businesses:

1. Alex The Analyst on YouTube
I say "business", but this one is my lowest revenue and time investments, but I do make some money from it. I do it because I love it and have always loved it - this takes maybe 5-10 hours per week.

2. Analyst Builder
This is my ed-tech platform to teach people Analytics and help them land jobs faster. This takes more time and I have a whole team that supports this platform. This takes 20-30 hours per week.

3. Alex Analytics LLC
This is my consulting business where I work with tech companies and startups. I do everything from helping with pricing strategy, data migrations, data analysis, to creating content. This takes 30-40 hours per week.

I didn't start out with all 3, they evolved over time. I started with my YouTube channel, and as that grew, I slowly started consulting. I started a small mentorship program and as that grew I created Analyst Builder to serve more people.

Things don't happen overnight and they don't always look like what you think they will. I'm a big believer in starting small and growing it until it makes sense to pivot.