A new, updated, PowerBI report for motoliczby.pl.
More then 4m records of new vehicles registered in Poland, Extracted from Cepik, Transformed and cleaned in python, Loaded to Power BI.
Links:
motoliczby.pl
motoliczby dashboad – published to web (no Power Bi account needed)
Motoliczby.pl are updated. New data and visualizations.
Very simple but useful Calendar table for Power Bi
Calendar =
ADDCOLUMNS(
CALENDARAUTO() /*CALENDAR(date(startyear,1,1),date(endyear,12,31))*/
,"Day Name",FORMAT([Date],"DDDD")
,"Day of Week",(WEEKDAY([Date],1))
,"Day of Month",DAY([Date])
,"Week",DATE(YEAR([Date]),MONTH([Date]),DAY([Date]))-(WEEKDAY([Date],1)-1)
,"Week Name", "Week of " & DATE(YEAR([Date]),MONTH([Date]),DAY([Date]))-(WEEKDAY([Date],1)-1)
,"Week of Year", WEEKNUM([Date],1)
,"Month", DATE(YEAR([Date]),MONTH([Date]),1)
,"Month Name", FORMAT([Date],"MMMM")
,"Month of Year", MONTH([Date])
,"Month Year Name", FORMAT([Date],"MMM") & " " & YEAR([Date])
,"Month Year Name Sort",(100*YEAR([Date])+MONTH([Date]))
,"Quarter",DATE(YEAR([Date]),SWITCH(ROUNDUP(DIVIDE(MONTH([Date]),3,1),0),1,1,2,4,3,7,4,10),1)
,"Quarter Name", "Q" & ROUNDUP(MONTH([Date])/3,0)
,"Quarter Year Name", "Q" & ROUNDUP(MONTH([Date])/3,0) & " " & YEAR([Date])
,"Year", DATE(YEAR([Date]),1,1)
,"Year #",YEAR([Date]))
I started to work on the web page presenting data of polish automotive market. Data are collected from CEPiK database and presented on charts using google charts library.
More at motoliczby.pl
Eshop in Takt. A web platform as make-to-order selling formula for most common company products. Platform offers a dozens of products such as vinyl records or cd disc. All products are widely configurable. During the configuration prices are automatically calculated and presented online. Client may download all necessary layouts for printing artworks preparation as well as upload them back with audio. More at eshop.takt.eu.
Eshop works as saas. My role was: php, html, css code modifications, products and structure configuration, building price calculations mechanism and all formal regulations.
Another movie made in Flurish and DaVinci Resolve.
Data include all registered electric vehicles in Poland. It contains only vehicles where electric engine is the the only engine installed (no hybrid cars).
Vehicles registered in CEPIK (polish vehicles database) on 16/6 2022. Please note that data include all vehicles registered (including e.g. scooters, motorbikes, and electric buses)
Data downloaded by python script ( https://github.com/czterdziesci4/polish-vehical-database-cepik ) using CEPIK Api.
Title: Electric vehicles in Poland Animation:
flourish.com
Source: Cepik Updated: 2022-06-16 Music: Youtube – Modern Time
CEPIK is polish public IT system of database containing data and information on road motor vehicles, their owners, as well as information about driving licenses issued in Poland.
Cepik have its Api and you can use it to download information. This short script will help you to do it automatically. The process may take a couple of minutes because system’s reply is limited to 500 records per one request and sometimes system do not reply or limits the number of request. More information how API works you may find at CEPIK Api documentation.
Github repository – link