• 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

PR Articles

Blog » PR Articles
GDPR dotazník

Are You GDPR Ready? Try Out Our GDPR Questionnaire

  • 21. 1. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Don't Miss Out, PR Articles
What I have for you today is not an article but a questionnaire focused on GDPR (General data protection regulation), that is directive in force since 25/5/2018.  This directive...
Číst »

Dixons start a new BI project. Would you like to be a part of it?

  • 11. 1. 2020
  • Ing. Jan Zedníček - Data & Finance
  • Don't Miss Out, PR Articles
Dixons start new Business Intelligence project. Dozens of systems integrated, work in MS Parallel DWH, the biggest ecommerce solution in CZE. Would you like to participate on complex end...
Číst »

Search

Back to Category

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

Don’t miss out

  • 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 […]
  • Power BI Gateway – Introduction Into Tool For Report Refresh/Update
    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 […]

News from other Websites

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

  • How to work with web information, maps, and images in Power BI
    by Daniel Calbimonte on 16. 1. 2023 at 0:00

    In this article, you will learn how you can add the map and image visuals to your Power BI report and have them update as you select different data […]

  • How to Find Missing Rows in a Table
    by Additional Articles on 16. 1. 2023 at 0:00

    When someone says, “Find all the rows that have been deleted,” it’s a lot easier when the table has an Id/Identity column. Let’s take the […]

  • Bucket Sort Algorithm in Python to Sort a List of Array Values
    by Additional Articles on 16. 1. 2023 at 0:00

    Learn about how to implement a simple bucket sort algorithm using Python code to sort a list of array values. The post Bucket Sort Algorithm in […]

  • Using OData.Feed And The Query Option To Avoid The Dynamic Data Sources Error In Power BI
    by Chris Webb on 15. 1. 2023 at 20:03

    Learn to use the Query option of the OData.Feed function in Power Query and Power BI

  • Announcing Power BI in Microsoft Teams collaboration experiences improvements
    on 13. 1. 2023 at 13:29

    We’re excited to start the year by announcing updates to the Power BI in Microsoft Teams experiences. Today we’re announcing three new […]

  • Getting started with SQL LIMIT clause
    by Manvendra Singh on 13. 1. 2023 at 11:28

    Today, I am going to explain how to use the SQL LIMIT clause to limit output values. We all know RDBMS systems are one of the popular ways to store, […]

  • Announcing: Viva Goals + Metrics integration, scorecard time zones and more
    on 13. 1. 2023 at 11:15

    New year, new features! We are excited to announce the general availability of the Viva Goals Power BI integration and three new Metrics features […]

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

  • 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?
  • WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?

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}