Uncategorized – BI Journey Challenge 365

Case Study 1 Case Study: How Does a Bike-Share Navigate Speedy Success?

Introduction Welcome to the Cyclistic bike-share analysis case study! In this case study, you will perform many real-world tasks of a junior data analyst. You will work for a fictional company, Cyclistic, and meet different characters and team members. In order to answer the key business questions, you will follow the steps of the dataContinue reading “Case Study 1 Case Study: How Does a Bike-Share Navigate Speedy Success?”

Introduction to R markdown Cheatsheet by R Studio

Date and time related common DAX formulas

“Year”,YEAR([Date]),“Start of Year”,DATE( YEAR([Date]),1,1),“End of Year”,DATE( YEAR([Date]),12,31),“Month”,MONTH([Date]),“Start of Month”,DATE( YEAR([Date]), MONTH([Date]), 1),“End of Month”,EOMONTH([Date],0),“Days in Month”,DATEDIFF(DATE( YEAR([Date]), MONTH([Date]), 1),EOMONTH([Date],0),DAY)+1,“Year Month Number”,INT(FORMAT([Date],”YYYYMM”)),“Year Month Name”,FORMAT([Date],”YYYY-MMM”),“Day”,DAY([Date]),“Day Name”,FORMAT([Date],”DDDD”),“Day Name Short”,FORMAT([Date],”DDD”),“Day of Week”,WEEKDAY([Date]),“Day of Year”,DATEDIFF(DATE( YEAR([Date]), 1, 1),[Date],DAY)+1,“Month Name”,FORMAT([Date],”MMMM”),“Month Name Short”,FORMAT([Date],”MMM”),“Quarter”,QUARTER([Date]),“Quarter Name”,”Q”&FORMAT([Date],”Q”),“Year Quarter Number”,INT(FORMAT([Date],”YYYYQ”)),“Year Quarter Name”,FORMAT([Date],”YYYY”)&” Q”&FORMAT([Date],”Q”),“Start of Quarter”,DATE( YEAR([Date]), (QUARTER([Date])3)-2, 1), “End of Quarter”,EOMONTH(DATE( YEAR([Date]), QUARTER([Date])3, 1),0),“Week of Year”,WEEKNUM([Date]),“StartContinue reading “Date and time related common DAX formulas”

Aggregation function in SSIS

Aggregation task is powerful task in SSIS. It contains many functions such as group by , count , countdistinct, minimum , average , maximum , sum. We can achieve a lot of task in from this task. For this particular task lets take data from Adventure works sales table. The motto of the task isContinue reading “Aggregation function in SSIS”

Ggplot2 – The basic powerful package of visualization

Ggplot2 contains the lot of package related to visualization. It contains almost all the powerful functions related to line , graphs , stacked bar charts and all. The normal ggplot with geom_point and aesthetics ; where ggplot is the main function , geom_point ( point related visualization) ,aes- asthetic which includes size , axis ,Continue reading “Ggplot2 – The basic powerful package of visualization”

Q&A section in Power BI

QA section is the artificial intelligence category of data visualization in power BI , You can find the many questions related to your data; additionally you can write standard question and the power BI visualize according to your question. This is one of the amazing feature I recently found. As in the above figure asContinue reading “Q&A section in Power BI”

Iterator Functions

Example : Iterator function add temporary new column , calculates the value in each row by multiplying order quantity and product price and apply aggregation to new column ( SUM)

Manage Roles in Power BI

The Roles are important to view the relevant report to the different users , Here is an example of the Adventure work report which is being restricted to view the Europe data of sales. The steps are given below. Step 1 – Go to Modelling and click manage roles Step 2 – Define the fieldContinue reading “Manage Roles in Power BI”

Notes on Calculated Columns and Measures

Use Measures instead of calculated columns ; calculated columns calculate value to each row whereas Measures calculate dynamic values in the report Even for simplest calculations measures are preferred as we can embed them in the complex queries and can use anywhere in the report Reference columns with table names and measures as it makesContinue reading “Notes on Calculated Columns and Measures”