#powerbi — Public Fediverse posts

ETL log: как упростить работу инженеров данных. Опыт «Ленты»

Привет, Хабр! На связи Александр Курносов, руководитель группы платформы данных, и Андрей Двинских, инженер больших данных. В ежедневной работе мы используем несколько инструментов. Чтобы разобраться с очередной задачей, приходится переключаться между ними, искать нужную информацию и собирать общую картину буквально по частям. В какой-то момент мы поняли, что большинство таких действий повторяются каждый день. Поэтому решили собрать самые востребованные сценарии в одном внутреннем инструменте. Так появился ETL log. В статье расскажем, почему решили его создать, какие задачи он помогает решать и как устроена работа с ним.

https://habr.com/ru/companies/lentatech/articles/1075374/

#etl #etlпроцессы #data_engineering #airflow #datahub #powerbi

How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to sort data with code in VBA - S1 EP19 P1 #excelcourse #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write And Edit a macro in VBA .S1 EP18 P9 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to write First Code in Vba Excel S1 EP18 P8 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

What is a Subroutine comment and a Basic Syntax in VBA Explained S1 EP18 P7 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Refer to a cell in VBA Code S1 EP18 P6 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to Write and change Values in Excel with Code S1 EP18 P5 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

How to save your Macro in Your Macro Library and Reuse- S1 EP18 P4 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #microsoftexcel #excel

Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

Selecting and Formatting Cells using VBA in Excel - EP18 P3 #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

S1 EP18 P2 How to Enable the Developer Tab in excel #excel #microsoftexcel #exceltips #excelcourseuae #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries

S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

S1 EP17 P9 Standard Mathematical Operations in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

S1 EP17 P8 View Section in Power Query Editor Explained #excel #powerqueryeditor #excelformula #exceltutorial #excelcourse #datacleaning #exceltip #datamagic #productivity #exceltips #exceltutoriales #dataextractor #powerbi #excelshortcuts #ConditionalColumn #excelshortcutss #QuickFill #DateSeries #spreadsheethacks #datasplit

Secret to no Pivot Tables By Using Power Query Part 84:
The Group By feature in Power Query summarizes data by grouping rows based on one or more columns and applying aggregate functions like sum, count, or average.
#PowerQuery #ExcelTips #GroupBy #DataCleaning #ExcelTutorial #PowerBI #DataTransformation #ExcelHacks

Group By Option Power Query Part 78:
Group By in Power Query aggregates rows based on one or more columns to summarize data (e.g., sum, count, average).
#PowerQuery #ExcelTips #DataCleaning #GroupBy #ExcelTutorial #DataTransformation #PowerBI #ExcelHacks

Group By Option Power Query Part 77:
Group By in Power Query aggregates rows based on one or more columns to summarize data (e.g., sum, count, average).
#PowerQuery #ExcelTips #DataCleaning #GroupBy #ExcelTutorial #DataTransformation #PowerBI #ExcelHacks

🧙‍♂️ One does not simply build reports on OLTP data…

This week on The Drill Down with Ahmad & James, our special guest
Kristyna Ferris will be presenting a session titled "The Fellowship of the Star Schema: Transforming OLTP Data for Power BI"

🛠️ This session is packed with:
- Clear distinctions between OLTP & OLAP
- Tips for building Power BI-ready models
- A sprinkle of Slowly Changing Dimension magic

💡Whether you’re a data wizard 🧙, business hobbit 🧝‍♀️, or SQL ranger 🏹 — this is your quest.

🗓️ Join us LIVE on LinkedIn | Wednesday, July 2nd @ 2PM Central
https://lnkd.in/eWh4SsBb

#TheDrillDown #MicrosoftFabric #PowerBI #DataEngineering #DataTransformation #DataAnalytics #BusinessIntelligence #StarSchema #OLTP #KristynaFerris

Gearing up for Elena Drakulevska's session, The #JediMindTrick of #PowerBIDesign!

#Gestalt #PowerBI #MicrosoftFabric #FabConEurope