I started learning Power BI a few days ago. I downloaded Power BI desktop.
What I realized is I can bring together data from different Excel files or Tables using Data Model, analyze it and report it. The totals are done by Power BI.
The time I had spent on Data Models in MS Access came in handy.
I used Power Query to bring the files together from folder.
Below is my first multi-index or nested columns and rows report. Power BI makes it easy to report in this way. In Power BI this is a matrix visual and is interactive.
The data is not real. Defining Calendar Table helped. The Calendar represents Indian financial year and quarters.
The next step for me is to expand it to add multiple years, other locations and other focus areas.
Once I have these building blocks in place, then the next challenge is to develop a dashboard.
What I realized is I can bring together data from different Excel files or Tables using Data Model, analyze it and report it. The totals are done by Power BI.
The time I had spent on Data Models in MS Access came in handy.
I used Power Query to bring the files together from folder.
Below is my first multi-index or nested columns and rows report. Power BI makes it easy to report in this way. In Power BI this is a matrix visual and is interactive.
The next step for me is to expand it to add multiple years, other locations and other focus areas.
Once I have these building blocks in place, then the next challenge is to develop a dashboard.