Date and Time Intelligence - The Date Table

EPM Strategy is a company that is enthusiastic about Business Intelligence and Power BI specifically.  We want every organization to be able to quickly and easily visualize their data so that they can make the right business decisions to meet their needs and objectives.  We provide training and consulting for organizations to better use Power BI to represent their data.

EPM Strategy

Date and Time Intelligence -  It Happened, BUT WHEN?

Almost every report has a Date or Time component associated with it. Think of just one example - sales. If somebody tells you that you had a million dollars in sales that might be positive, negative or even neutral. You have to know in what time period. A million dollars in sales yesterday is a lot different than a million dollars in sales over the last 50 years.

Having a date table in your Power BI file is one of the most consistently needed tables in reporting. With a date table you can use time intelligence for filtering, grouping, drilling, sorting and other date specific options. And, with a date table template you only have to create this one time and then it can be used throughout your organization. Using a date template allows for consistency throughout your entire organization.

This interactive, hands-on training will include a sample file to use while creating a Date Table of your own. Training will also involve how to add your Fiscal Dates to the Date Table (if needed). And, the training will conclude by creating some date specific visuals using the created Date Table.

This training will include at least the following aspects of the Date Table in Power BI:
	• Data Types
	• Date Table creation
		○ Considerations
		○ Creating columns
	• Power Query formulas
	• Working Days
	• Fiscal Dates
	• Holidays
	• Year, Month, Week and Day options
		○ How to design those settings those options for visuals
	• Date and Time considerations
		○ UTC versus local Time
		○ Data origination Date/Time
	
	
Requirements:
Power BI Desktop
Internet connectivity
Be able to join a Microsoft Teams session

*It is strongly recommended that participants have at least 2 monitors.
Class Length: 2.5 hours

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Date and Time Intelligence - The Date Table

More events from EPM Strategy

Follow organizers to get events picked for you

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Date and Time Intelligence - The Date Table

More events from EPM Strategy

Follow organizers to get events picked for you

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.