- #LibreOffice : notre suite bureautique où j'essaye de la maintenir le plus à jour possible (difficile de rivaliser avec #Office365 et surtout #PowerQuery dans #Excel)
- Prochainement #Odoo (ex #openERP) où j'y développerais bien des modules pour combler des besoins : callcenter, portail de supervision ...

Et surtout : #Docker qui nous rend autonome sur le déploiement de produits #opensource, plus besoin de demander aux collègues des VM #Linux

⬇️

@mikabxl @zaclys @doc75

#LibreOffice ne propose pas hélas un concurrent à #Microsoft #PowerQuery et c'est vraiment dommage ...

J'ai déployé hier #Apache #SuperSet comme une alternative à #BusinessObject et #PowerBi
J'ai un collègue qui le teste car il veut modéliser des flux de déchets à recycler et ca s'y prêterait.

I finally get the right redistributables installed, work out whether I need a 64 or 32bit ODBC DSN, fire up #Excel, add a connection to the DB. Then I have to deal with #powerquery!

I suddenly remember how hard it will be to get this mess on to user's PCs ☹️

Abandon the whole thing and write a #python script to query #mysql, create an Excel file and email it to those in need. Hook it up to a #systemd timer for weekly distribution 😎

So far I have used a notebook to load into my bronze lake all of the tables I'll need, and I'm using the SQL endpoint (❤️ ) to build a view that will return the area_id for every area, and the area_id for its ultimate parent as country_id.

This is where I gave up trying to implement this solution using #PowerBI alone. Although I probably could have built this view as a #PowerQuery, there were too many variables working against me. The source data is located in multiple text files, the schema is belligerently opaque and obtuse, and for a pet project there's only so much nonsense I can put up with at any one time.

With Fabric, I have the right tools for the job, and instead of fighting with Power Query performance when merging large text sources to themselves over and over, I can focus on the data itself.

2/

🗓️ Mark your calendars for this Thursday because we have an exciting event coming your way!

🌟 Join Mathias Halkjær Petersen and me for a Power BI Quiz, with a special focus on Power Query beyond the UI. 💪

🔍 Power Query is an essential part of Power BI that empowers you to quickly clean, transform, and shape your data.

📌 Whether you're a seasoned Power BI / Excel PRO or just starting your data journey, this quiz will challenge and inspire you. It's an opportunity to showcase your expertise, learn from fellow professionals, and expand your knowledge in Power Query. 📚

🏆 Exciting prize awaits the Power Query champion! 🎁

🎯 Join us this Thursday and let's dive into the world of Power Query together. Let's push our boundaries, embrace the data-driven future, and take our Power BI skills to new heights! 🚀

🔗 Link: https://www.linkedin.com/events/powerbiquiz-season5episode3-t-p7076629173309460480/comments/

See you all there!

#PowerBI #PowerQuery #DataAnalytics #Quiz #LinkedInLearning #BusinessIntelligence #ProfessionalDevelopment

✅ Yes, you can! You can extract cells with specific colors from Excel using #PowerQuery. Of course, it has its pitfalls and is not a straightforward path, but it is possible!

🔗 Link: https://datameerkat.com/extract-excel-cells-with-selected-color-by-power-query

#PowerBI

Lots of people create new columns in Power Query one by one. There are more effective ways to do that. It can also be done by [] inside ONE new column and then expanding it directly, but then you need to set column types. #PowerQuery - Next time, you can try this 🙃.

Oh Mashup Goodness! Your Power Query code just got Super Powers with Chat GPT4
https://youtu.be/ZtpaNDJEQkA

#PowerQuery #Excel #PowerBI #chatgpt

#Fabric

Convert those _ column names to spaces for your reporting with some #PowerQuery magic in your #PowerBI report

= Table.TransformColumnNames( PreviousStep, each Text.Replace(_, “_", " " ) )

Hello folks

New video aiming to explain (and avoid) those annoying Errors that appear when you try to use the PIVOT feature of #PowerQuery

PLUS stayed tuned to see a bonus 3 minute technique of merging a query with itself!

youtu.be/Tzv7jZ9WjAM

#Excel #PowerBI

Rogue file in your SharePoint Folder?

How to consolidate multiple files from a SharePoint / OneDrive folder AND how to debug issues when it doesn’t work… including creating an output table listing the problem files…

YouTube: https://youtu.be/x2i0MRsE3RU

#Excel #PowerBI #PowerQuery

New #PowerBI video : Remove first / last characters from text or column using #PowerQuery
https://youtu.be/Tthfl7BSEWo

How to write better Multiple IF formulas in Power Query.

- parameter approach
- approximate match approach

YouTube:
lnkd.in/gccPvPhA

#PowerQuery #Excel #PowerBI

Have you tried to expand tables on columns that have both values and nested tables but the double arrow is missing?

Here is how to do it when that happens :)

https://www.youtube.com/watch?v=YNzMbppUCik&ab_channel=Curbal

#PowerBI #PowerQuery #curbal

@greggyb Agreed! The #PowerQuery GUI seems to have been amazingly well designed right out of the gate.

The Data Modeling / Report Surface interface of PBI has changed dramatically, whereas the PQ GUI has been highly conserved.

Been working with an almighty #Excel workbook that needs converting to #PowerQuery format and ultimately #PowerBI

It is so big it barely functions

There are multitudes of data redundancies, formulae with errors, circular references, and tens of thousands of columns with random bits of unnecessary data

Every sheet needs to be checked, validated and cleaned before going into Power Query for further work and transformation

When it comes to Excel: just because you can, doesn't mean you should

VLOOKUP should no longer be considered the “base level” of #Excel skills for employers.

Experience with #PowerQuery is now the bar you need to set if you want to hire employees that will improve the efficiency of your data based operations.

⚓️ Are you ready to set sail with Power BI? Join other data enthusiasts and me on the Power BI Cruise.

⏰ But the time is coming! April 9 is the last date you can register. So do it now there: https://powerbicruise.com

Link to original article: https://www.linkedin.com/embed/feed/update/urn:li:ugcPost:7046922217934221312

#PowerBI #PowerQuery #PowerBICruise

Starting a new #Coursera course tomorrow: #Excel Power Tools for Data Analysis.
#PowerQuery #PowerPivot #PowerBI

While I didn’t intend to jump on the GPT4 bandwagon - I thought I’d throw a ridiculous #PowerQuery challenge at it - and this happened..

I may have just been converted to a believer…