This data is provided out of the box by Microsoft. While this data was from essentially CSV files, I’ve worked with data pipelines directly into PowerBI and typically use import of direct query. After that I set up an online workspace for reports to live.

When building reports or dashboards, the audience is important to understand. Executives may want the 10,000 FT. view while others may want drill down abilities.

I previously led a team that’s only job was to make reports look good visually. PowerBI graphics are difficult at times but I’ve tried to develop a style that easily fits into a JSON theme file for easy, stunning reports.