Expand the basic functionality to incorporate comparison dates.
When to use them, difference from dataset and dataflows and basic admin.
Ensure your data is as Tableau friendly as possible.
The case for using off-the-shelf ETL tools.
5 situations when home-grown ETL makes sense.
Power BI composite models is a game changer.
Compare 5 Microsoft options.
Synopsis of Microsoft’s two popular cloud-based options.
Strengths and weakness of data modules and when it’s better to use Framework Manager.
Dataflows and datasets are ways to organize and model self-service data.
Power BI offers many ways to pull in data for analysis. But what approach should your organization take? The answer depends on considerations that include whether or not your organization has an existing data warehouse, your need for real-time dashboarding and the ease-of-use factor for your analysts. We explore four options, outlining the pros and cons of each.
Take these into account when determining which tools are best suited to the task at hand.
We outline the benefits of OLAP report authoring and provide background on the architecture.
A retrospective of where OLAP started and what still brings to BI.
We describe how to work with data modules and discuss their limitations.
Learn the two-fold solution for Excel data extraction and scrubbing.
