• Home
  • SQL Tutorials
    • Handling SQL tables
    • SQL Basics
    • SQL Clauses
    • SQL Commands
    • SQL Functions
    • SQL Operators
    • XML for SQL Server
    • Useful SQL Scripts
    • SQL Online Quiz
  • SQL Server
    • SQL Administration
    • SSRS – Reporting Services
    • SSIS – Integration Services
  • Power BI reporting
    • DAX
    • Power BI desktop
    • Power Pivot
    • Power Query
    • Sample Reports in power BI
  • Excel
    • Excel functions
    • Excel tutorials
    • Finance math in Excel
  • BI Latest News
    • BI Blogs and Magazines
    • Power BI News
  • Contact
  • English
    • Čeština
    • English
    • Home
    • SQL Tutorials
      • Handling SQL tables
      • SQL Basics
      • SQL Clauses
      • SQL Commands
      • SQL Functions
      • SQL Operators
      • XML for SQL Server
      • Useful SQL Scripts
      • SQL Online Quiz
    • SQL Server
      • SQL Administration
      • SSRS – Reporting Services
      • SSIS – Integration Services
    • Power BI reporting
      • DAX
      • Power BI desktop
      • Power Pivot
      • Power Query
      • Sample Reports in power BI
    • Excel
      • Excel functions
      • Excel tutorials
      • Finance math in Excel
    • BI Latest News
      • BI Blogs and Magazines
      • Power BI News
    • Contact
    • English
      • Čeština
      • English
Jan Zedníček – Data & Finance

Jan Zedníček – Data & Finance

  • Home
  • SQL Tutorials
    • Handling SQL tables
    • SQL Basics
    • SQL Clauses
    • SQL Commands
    • SQL Functions
    • SQL Operators
    • XML for SQL Server
    • Useful SQL Scripts
    • SQL Online Quiz
  • SQL Server
    • SQL Administration
    • SSRS – Reporting Services
    • SSIS – Integration Services
  • Power BI reporting
    • DAX
    • Power BI desktop
    • Power Pivot
    • Power Query
    • Sample Reports in power BI
  • Excel
    • Excel functions
    • Excel tutorials
    • Finance math in Excel
  • BI Latest News
    • BI Blogs and Magazines
    • Power BI News
  • Contact
  • English
    • Čeština
    • English

Blog - permanently moved from biportal.cz

Blog
sql Server 2019 mac M1

Mac M1/Apple Silicon – SQL Server Developer – Installation Guide

  • 22. 1. 2023
  • Ing. Jan Zedníček - Data & Finance
  • SQL Administration
I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience when unboxing, everything tuned to...
Číst »
sales report

Sales Report in Power BI and Direct Query into SQL Database

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Power BI desktop, Sample Reports in power BI
Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second...
Číst »

AND, OR Logical Functions in Excel

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Excel functions
Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out...
Číst »
excel category articles image

Excel | Subtotal – 11 Functions in One

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Excel functions
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function....
Číst »
excel category articles image

Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Excel functions
There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may...
Číst »

Power BI Gateway – Introduction Into Tool For Report Refresh/Update

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Power BI reporting
It is nothing hard to create report using Power BI desktop for example from Excel and then upload it to the cloud on powerbi.com. But how to update the...
Číst »

Connecting to SQL Server | Power Query

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Power Query, SQL Server
It is possible to connect to many data sources using Power Query (more in this article) and SQL Server database is one of them. This article will tell you...
Číst »

Power BI Refresh Does Not Work – Reason?

  • 23. 5. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Power Query
Did it ever happen to you that the Power BI update did not work? There might be several reasons for this problem and it is always user’s fault. We...
Číst »
excel category articles image

WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?

  • 21. 3. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Excel functions
You have a huge table with many date entries in it. You need to find out which date is after 20th week of the year or if a certain...
Číst »
Function CALCULATE in DAX model example - power bi

FILTER Functions for Power BI in DAX – Overview

  • 21. 3. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX
FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions...
Číst »

Aggregation in DAX – How Aggregations Work? + Function Overview

  • 21. 3. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX
Aggregate functions in DAX language are used to get certain summarized or grouped data view. Thanks to this, we can edit high detail data in a certain column into...
Číst »
DAX CALCULATE

Function DAX CALCULATE – Aggregation With a Condition in Power BI

  • 21. 3. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX
CALCULATE is an important function for a large number of calculations and for those of you who actively do DAX formulas in Power BI or PowerPivot. Understanding of how...
Číst »
Power BI datový model

DAX RELATED Function for Power BI – Lookup Into Table

  • 21. 3. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX
Function REALTED is very frequent and useful in DAX language. We can use it for example when we need to search table (A) for value from other table (B)....
Číst »
sql součty a mezisoučty

SQL ROLLUP, CUBE, GROUPING SETS – Totals and Subtotals

  • 15. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • SQL Commands
What about upgrading GROUP BY clause by use of useful commands? GROUP BY is used in a clause with aggregate operations. When it is used, aggregation happens throughout all...
Číst »
Difference between SUM and SUMX - comparing sum and sumx - final report

DAX | SUM and SUMX – How to Perform Aggregation in DAX Language for Power BI

  • 11. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX, Don't Miss Out
You probably noticed that there are many functions in DAX that are similar to Excel ones (as in article here). Contrary to Excel functions, DAX haves on strange thing....
Číst »
SQL indexy

SQL Indexes – Indexing Theory Simply, Balanced Tree, Heaps

  • 11. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • SQL Administration
Correct table indexing in SQL Server is a base for good database performance during querying. You need to understand how SQL Server stores data into tables/indexes if you want...
Číst »
Rozdíl mezi measure a column

DAX Difference Between Measure and Column + Example on Report

  • 11. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX, Power BI reporting
We can create two types of new values using DAX in Power BI or PowerPivot. They are calculated measures and columns. Difference between measure and column and its understanding...
Číst »

DAX language – Introduction into DAX for Power BI and Powerpivot

  • 11. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX
DAX language (Data Analysis Expressions) servers for data management and editing prior reporting in Power BI or Powerpivot, similarly to function set in Excel. This language is able to return...
Číst »
Parametry v DAX

Parameters in DAX – Introduction into DAX Expressions

  • 11. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • DAX
DAX language haves its standards as does any other language. This article sums up and describes how look the parameters of formulas. In other words, this article is about...
Číst »
SQL Dotazy

Basic SQL Queries – Overview For Beginners With Examples

  • 3. 2. 2020
  • Ing. Jan Zedníček - Data & Finance
  • SQL Basics, SQL Clauses, Useful SQL Scripts
What I have here today is a article for beginners. It will be full of sql query examples. We will start from the most basic ones and continue up....
Číst »

Posts navigation

1 2 … 6 Next

Search

Back to Category

  • SQL Server »
  • SQL tutorials »
  • Power BI »
  • Excel »
  • Zprávy a feedy »

Don’t miss out

  • sql Server 2019 mac M1Mac M1/Apple Silicon – SQL Server Developer – Installation Guide
    I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience […]
  • sales reportSales Report in Power BI and Direct Query into SQL Database
    Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second […]
  • AND, OR Logical Functions in Excel
    Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out […]
  • excel category articles imageExcel | Subtotal – 11 Functions in One
    SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, […]
  • excel category articles imageExcel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
    There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may have needed […]

News from other Websites

Resources: Power BI News and Blogs a BI Blogs and Magazines – SQL Server, Excel, Reporting

  • How to Connect SQL Server and Create C# Objects for Data Management
    by cmarix on 24. 3. 2023 at 0:00

    Learn about how you can work with your SQL Server data from C#. A good basic tutorial for beginning C# developers. The post How to Connect SQL Server […]

  • Thought Leadership resource page
    by Additional Articles on 24. 3. 2023 at 0:00

    Find the latest insights on digital modernization and the role of the database in it in our new resource page. With articles and webinars from […]

  • SQL Server, Oracle and PostgreSQL Database Security Roles, Schemas, Grants, Privileges and Owners - Part II
    by Additional Articles on 24. 3. 2023 at 0:00

    This article covers the concepts of roles, schemas, grants, privileges, and owners and the similarities and differences in SQL Server, Oracle, and […]

  • Power BI TMDL And Version Control Announcements From SQLBits
    by Chris Webb on 23. 3. 2023 at 18:26

    If you missed out on the big announcement last week about Tabular Model Definition Language and the future of Power BI version control at SQLBits […]

  • Data Wrangler: A Power Query-Like Experience For Python People
    by Chris Webb on 23. 3. 2023 at 11:13

    If, like me (and Ruth), you spend your life in Power BI but have a lingering feeling that you should get round to learning Python for data analysis […]

  • Understanding Substring in Oracle SQL
    by Arindam Mondal on 22. 3. 2023 at 12:47

    The Oracle SQL database provides many useful functions to use with your query or programming. The SUBSTR function is one of the most used string […]

  • Explore new capabilities in Microsoft Power BI at the Microsoft Business Applications Launch Event
    on 22. 3. 2023 at 8:55

    Businesses today are constantly facing new and bigger challenges. Technology is diversifying and evolving faster than ever to address these issues, […]

Ing. Jan Zedníček – Data & Finance

  • 734399420
  • jsem@janzednicek.cz
  • 9:00 - 17:00

Links and documents

  • Privacy policy
  • Cookie policy

RSS Most recent from blog

  • Mac M1/Apple Silicon – SQL Server Developer – Installation Guide
  • Sales Report in Power BI and Direct Query into SQL Database
  • AND, OR Logical Functions in Excel
  • Excel | Subtotal – 11 Functions in One
  • Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECOND
  • Power BI Gateway – Introduction Into Tool For Report Refresh/Update
  • Connecting to SQL Server | Power Query
  • Power BI Refresh Does Not Work – Reason?

2020 All Rights Reserved | Website made by Jan Zednicek

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 vendors Read more about these purposes
Show preferences
{title} {title} {title}