Skip to content
Jan Zedníček
Freelancer – Data & Finance
Follow us on Facebook Follow us on LinkedIn
  • Home
  • SQL Tutorials
    • Handling SQL tables
    • SQL Basics
    • SQL Clauses
    • SQL Commands
    • SQL Functions
    • SQL Operators
    • Useful SQL Scripts
  • Data platforms
    • SQL Server
      • SSIS – Integration Services
      • SSRS – Reporting Services
      • SQL Administration
    • Dbt (Data Build Tool)
    • Fabric
    • Keboola – Tutorials and information
    • Mage AI – ETL Tool
  • Power BI
    • DAX
    • Power BI desktop
    • Power Pivot
    • Power Query
    • Sample Reports in power BI
  • Controlling
    • Finance analysis
    • Finance math in Excel
  • Excel
    • Excel functions
    • Excel tutorials
  • Other
    • Chat GPT
    • BI Blogs and Magazines
    • Power BI News
  • Contact
  • English
    • Čeština
    • English

Power BI Desktop – List of Articles in Category

  • Power BI Custom Visuals – Additional Visualizations to Power BI Desktop
  • Power BI Desktop – Powerful Report Tool Introduction
  • Sales Report in Power BI and Direct Query into SQL Database

Search

Power BI Desktop – List of Articles in Category

Navigation

  • Home
  • SQL Tutorials
    • Handling SQL tables
    • SQL Basics
    • SQL Clauses
    • SQL Commands
    • SQL Functions
    • SQL Operators
    • Useful SQL Scripts
  • Data platforms
    • SQL Server
      • SSIS – Integration Services
      • SSRS – Reporting Services
      • SQL Administration
    • Dbt (data build tool)
    • Fabric
    • Keboola – Tutorials and information
    • Mage AI – ETL Tool
  • Power BI
    • DAX
    • Power BI desktop
    • Power Pivot
    • Power Query
    • Sample Reports in power BI
  • Controlling
    • Finance analysis
  • Excel
    • Excel functions
    • Excel tutorials
    • Finance math in Excel
  • Chat GPT

Don’t miss out

  • Fabric-Medaillon-data-flow-exampleMicrosoft Fabric – Intro, Core Concepts – Why It’s so OP?
    This article serves as an introductory overview of MS Fabric and as a resource for a basic evaluation of this tool. It also functions as a hub for […]
  • fabric-connectors-exampleFabric | Getting Started with Data Factory, Pipelines, and Connectors
    This article is intended primarily for managers, IT specialists, and technical decision-makers who are evaluating Microsoft Fabric and are […]
  • xlookup_example_3_with_data_first_last_argument_en_versionExcel | XLOOKUP – Syntax, Guide, Examples of Lookup Values, Differences vs VLOOKUP
    I haven’t written anything about Excel for a long time, and today I’ve chosen the XLOOKUP function, which I shamefully haven’t described here yet. […]
  • fabric-data-factory-bulk-import-foreach-activity-completedBulk Table Automated Ingestion in Microsoft Fabric Data Factory Using a Single Pipeline and JSON Configuration
    This article is a technical guide on how to implement a bulk table import using a single pipeline in Fabric Data Factory (or Azure Data Factory) by […]
  • janzednicek data & financeTop 10 Advanced T-SQL Commands for SQL Server Development
    This article is a list of commands and techniques for working with SQL Server, which are routine for advanced T-SQL developers. If you are interested […]
  • gold-scd2-dimension-tables-fabricFabric | dbt – How I Build Gold Layer Dimensional Tables (SCD2) in Data Projects
    In the previous article Slowly Changing Dimension (SCD 2) – Snapshots I demonstrated how to implement historical tracking of dimensional data in the […]
  • insert-into-delta-tableFabric – Bronze: Data ingestion into Delta tables using pipeline (notebook)
    In several previous articles, I discussed how to configure ADLS Gen2 for storing source .parquet data and also how to connect ADLS Gen2 directly to […]
  • Fabric | dbt – Shortcuts and how to connect ADLS Gen2 with Fabric Lakehouse
    In the previous article – Fabric – ADLS Gen2 and Parquet – Storage Configuration and Bronze Data Format – I described how […]
  • adls-gen2-bronze-medaillonFabric – ADLS Gen2 and Parquet – Configuring Storage and the Bronze Data Format
    In a data architecture based on the Medallion Architecture approach, the Bronze layer represents the first stage of data processing – this is where […]
  • Fabric – Workspace and Task Flow – Organizing Processes, Artifacts, and Domains
    As part of the series of articles on the Microsoft Fabric platform, we focus on various features and artifacts of this data workspace environment, […]
© 2025 Jan Zedníček — Data Engineer & Controlling. Všechna práva vyhrazena.
Manage Cookie Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. Technical storage or access that is used exclusively for anonymous statistical purposes. Absent a subpoena, voluntary compliance by your Internet Service Provider, or other records from a third party, information stored or obtained solely for this purpose cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
  • Manage options
  • Manage services
  • Manage {vendor_count} vendors
  • Read more about these purposes
Show preferences
  • {title}
  • {title}
  • {title}