BI Developer - Internship

Foresight BI & Analytics: BI Developer Internship

My submission for the Internship , May 2023.

Mbuotidem A. | August, 2023.

For the internship, I learned what end-to-end power BI project look like in consulting domain. I'd be sharing how I went about building my report, and how I cover everthing from cleaning, modeling, thought process and business requirement.

Data Dictionary: I curated a file to explain the metadata for the data provided in case to evaluate my understanding of the business domain.
Data Transformation & Preparation: After extracting, I did all cleaning and transformation in power query
Data Modelling: built a connection between different tables
DAX Calculations and Exporting: I wrote DAX calculations for advanced analysis and learned more about how to use Tabular Editor and DAX Studio. I used DAX studio to export DAX measures into an Excel file

Dataset Preview

Seven worksheet were provided in the Pharm dataset: DimLocation, DimSubchannel. DimChannel, DimProducts, DimEmployees

Target dataset

Understanding of the dataset

After exploring the datasets, I created a detailed list of all columns in each table using Microsoft Word.

Here is the details of each columns (as seen on the left).

Mock up

Next, I designed a mock-up on Microsoft Whiteboard outlining the layout and visual representation for each of the reports. This included specifying the types of charts to be used along with their corresponding titles.

Data Modeling

Task: "After Loading your dataset into Power BI. Build the appropriate data model and create the necessary relationships.

Then, In Power BI Desktop, go to the Modeling Tab, click on Manage Relationship. Then take a screenshot of your Power BI Data Model Relationships and upload"

DAX Studio exported to Excel

Task: "Create all your DAX Measures for the required numbers (Test them and make sure they work correctly).

Download and Install DAX Studio. When you do that, you should have it showing on the External Tools tab of your Power BI.
Launch it from Power BI Desktop. Inside DAX Studio, go to the DMV Panel and search for Measure. Use either the MDSHEMA_Measures or TMSCHEMA_Measures to export your Measures to Excel.
You may need a little research to find out how to do that

Reports/Analytics

This is the final stage, bringing everything together. The data has been cleaned and transformed, the model structured, DAX measures calculated, and the visuals designed. View the interactive version to get the full User Experience.

Task:
Export your Power BI Desktop Report to PDF and upload here

In an MS Word Document, paste a Web Link of your Power BI Report. (i.e, publish your report to power bi service, then create an embed link for web to be copied and pasted in the MS Word Document.
include the 2 files in a Folder, zip the folder and upload here for submission.

Page updated

Google Sites

Report abuse