Using a Calendar Table in Power BI can allow you to filter your reports by time intelligence attributes like Year, Quarter, Month, and any other time aggregation by non-standard columns that your organization might need. In this video, Reid is going to talk about some considerations related to the calendar table, more specifically on what data types are best to be set when displaying certain things on various visual axis.

***** Video Details *****
00:00 Introduction
00:49 Creating custom column
01:45 Text data
01:57 Date data
03:49 Noisy axis
04:19 Self-contain

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial

A company’s success directly correlates with its people which is why employers and HR/talent acquisition personnel are constantly improving how they find, hire, and retain the best candidates. Data analytics plays a major role in this process.

In this episode of The Analytic Mind Podcast, Sam McKay is joined by Tim Freestone, founder of Alooba, to talk about hiring in analytics and data literacy.
From the big issues with CVs, and interviews, where companies typically go wrong to future trends in hiring and improving data literacy.

Tim Freestone has spent his career in analytics, starting initially as a financial analyst. Throughout his career, Continue reading “Hiring in Analytics and Improving Data Literacy with Tim Freestone” →

Every so often we’ll be needing the availability of a custom visual of a bar chart or line chart that gives an option to plot the chart either weekly, monthly, quarterly, or yearly. In this video, Greg is going to demonstrate how you can create dynamic temporal scale using a disconnected table in Power BI that can let you change the level of granularity depending on your date or time basis.

***** Video Details *****
00:00 Introduction
00:47 What is a dynamic temporal scale
00:50 Overview of Part 1
02:09 R10a_Table
05:23 The measure

***** Related Links *****
How To Create Dynamic Temporal Scale In Power BI Pt.1 – Continue reading “How To Create Dynamic Temporal Scale In Power BI Pt.2” →

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 16th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 17th – 5am Sydney (AEST), 7am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Melissa de Korte, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions – Nested Structured Values (Part 2)” →

Businesses are increasingly recognizing the importance of data analytics in making informed decisions across all aspects of their operations. However, simply having access to data is not enough. They need to be able to extract value from it as well. They also need to have the skills and tools to analyze it effectively. How can businesses become more literate about their data in order to identify and respond to opportunities and threats strategically?

George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms, and Continue reading “Improving Data Literacy with George Mount” →