A Beginner’s Journey to Learning

  Microsoft Power BI


By Ellis Natalie

Chaminade University of Honolulu - DS 480

03-01-2025

Introduction: Starting Your Data Journey

Embarking on the path to learning Microsoft Power BI is similar to entering a universe of limitless possibilities in data visualization and analysis.

For a first-time learner, the journey of mastering Power BI can indeed feel like a steep climb, venturing into the unknown and facing moments of discomfort and frustration. However, as you grow more familiar with its tools and capabilities, the initially daunting process transforms into a gratifying experience that converts raw data into meaningful insights.



Follow this step-by-step instruction and discover valuable tips and lessons along the way.

Step 1: Understanding Power BI

As a beginner, your first inquiry could be, “What exactly is Power BI?”

Microsoft Power BI is a sophisticated business intelligence tool designed to transform data into visually compelling charts, dashboards, and reports. Think of it as a method to enable your data to “communicate” effectively, conveying its own narrative through vibrant color and interactive visualizations.

Before delving into the practical application, it is crucial to grasp the fundamental concepts:

  • Components of Power BI:
    The ecosystem comprises Power BI Desktop (for data analysis and report creation), Power BI Service (an online service for sharing and collaboration), and Power BI Mobile (for accessing reports on the go).

  • Core Concepts:
    Key ideas include data modeling (the process of organizing data for analysis), DAX (Data Analysis Expressions) for advanced calculations, and various visualization methods to effectively showcase data insights.

💡Pro Tip: Elevate your learning experience by watching educational videos or lessons from reputable sources. I highly recommend exploring Power BI content from distinguished YouTube channels, such as Leila Gharani, Kenji Explains, and How to Power BI (Bas), for their expertise and practical guidance.

Step 2: Install Power BI Desktop

To start:

1. Visit the Official Power BI Website: Navigate to the official Power BI website to access the download page.

2. Download Power BI Desktop: Ensure you download the latest version of Power BI Desktop, preferably the 64-bit version if your system supports it. This will optimize performance and compatibility.

3. Install the Application: Follow the on-screen prompts to install Power BI Desktop on your computer. The installation process is straightforward and user-friendly.

Microsoft Power BI Desktop
Microsoft Power BI Desktop


🌟 Encouraging Tip: When you first start Power BI Desktop, take a deep breath and prepare yourself for an exciting journey…   While the interface may initially appear overwhelming, keep in mind that it is your creative playground. This is where you will explore, learn, and eventually master the art of data visualization. Accept the task with enthusiasm and curiosity, knowing that with each click and command, you go one step closer to realizing the full potential of your data.

Step 3: Connect to Your Data

Power BI supports a variety of data sources, including Excel, SQL Server, web services, etc. For example, for this tutorials, begin by linking to an Excel file or sample dataset.

  1. Select ‘Home’ > ‘Get Data’.

  2. Choose your data source (e.g., Excel) and go to the file.


  3. Load the data into Power BI and examine the tables.

🌟 Encouraging Tip: This will feel like finding a buried treasure — you have just linked data to a powerful tool!   By connecting raw data to the powerful capabilities of Power BI, you are unveiling a world of opportunities.

Step 4: Transform and Clean Your Data

As a newcomer, you will quickly learn that raw data is rarely clean. Power BI has a built-in Power Query Editor for scrubbing your data. Steps to follow:

  1. Launch the Power Query Editor (‘Home’ -> ‘Transform Data’).

  2. Remove any extraneous columns, fix formatting, or filter rows.

  3. Make the necessary modifications and then load the clean data back into your workspace.

Power Query Editor
Power Query Editor


1. Ribbon: The ribbon contains multiple tabs that allow you to add transformations, choose options for your queries, and access various buttons to perform different tasks.

2. Queries Pane: This pane displays all your available queries in one view.

3. Current View: This is your main workspace that shows a preview of your query’s data. You can also enable the diagram view and switch between the schema vs data preview while maintaining the diagram view.

4. Query Settings: This section provides relevant information about the currently selected query, including the query name, query steps, and various indicators.

5. Status Bar: This bar shows important information about your query, such as execution time, total columns, and rows, and processing status. It also includes buttons to change your current view.

🌟 Encouraging Tip: When you first encounter the Power Query section, it can appear quite rigid. The various options and terminologies may seem terrifying, making it challenging to understand at first.  However, with patience and practice, you will start to see the power and flexibility that Power Query offers for transforming and preparing your data. Embrace the learning curve, and soon, you will find it to be an invaluable tool in your data journey.

Step 5: Build a Basic Visualization

This is where the fun truly begins: generating your first visual!

The excitement of transforming raw data into visually appealing charts is exhilarating. Follow these steps to get started:

  1. Drag a field (column) from the “Data” tab to the “Report” canvas.

  2. Power BI will automatically generate a default visual (often a table).



  3. Change the type by selecting a chart from the “Visualizations” tab (e.g., stacked column chart).



🌟 Encouraging Tip: By meticulously organizing and visualizing the information, you bridge the gap between complex data sets and clear & understandable conclusions. This process not only enhances your analytical skills but also empowers you to present your findings in a way that resonates with your audience, making the data meaningful and impactful.

Step 6: Create a Data Model

This stage may appear advanced, but it is critical to producing good reports. Power BI enables you to build relationships between several tables of data:

  1. Navigate to the “Model” view in Power BI.


  2. Manage relationships between tables by dragging and dropping fields.


  3. Apply this data model to produce more relevant and accurate visualizations.

🌟 Encouraging Tip: Think of data modeling like solving a jigsaw puzzle. Each piece, no matter how small, plays a vital role in revealing the full picture. As you connect these pieces, patterns emerge, and a meaningful narrative unfolds. Embrace the challenge with enthusiasm, knowing that each step brings you closer to uncovering the story your data reveals.

Step 7; Explore DAX

DAX (Data Analysis Expressions) might sound terrifying, but it is a powerful language for creating calculated columns and measures.

  1. Start with simple measures like:

    Sum Total Sales = SUM(Sales[Total Sales])

  2. Gradually experiment with more advanced functions like IF and FILTER.

💡Pro Tip: One of the best ways to learn DAX is by watching YouTube videos from experts in the field. Channels like Leila Gharani, How to Power BI (Bas), and Kevin Stratvert offer valuable tips, tricks, and practical examples that can help you understand and master DAX.

🌟 Encouraging Tip:. The first time you see your custom measure working perfectly is a moment to celebrate!  Learning DAX in Power BI can be challenging, but when your calculations come together seamlessly, it is incredibly rewarding. This accomplishment highlights your growing proficiency and ability to unlock deeper insights from your data.

Step 8: Design an Interactive Dashboard

Create an interactive dashboard to elevate your graphics.

  1. Add slicers (filters) so that users may interact with the data.

  2. Use themes and formatting choices to improve the dashboard’s visual attractiveness.

  3. Use numerous charts and images on a single page to communicate narrative of your story.



🌟 Encouraging Tip: When developing your dashboard, remember you are creating an experience for your audience, not just charts. Use color palettes thoughtfully to enhance the visual appeal and ensure clarity.  Focus on a user-friendly interface that guides viewers through the data seamlessly. By keeping their needs in mind, you will create a powerful tool that resonates with and informs your audience.

Step 9: Publish and Share

Once your report is completed, it is time to share it with others.

  1. Save the Power BI file (.pbix format).

  2. Submit the report to the Power BI Service (‘Home’ > ‘Publish’).

  3. Share the report’s link or embed it in a website or app.

🌟 Encouraging Tip: Publishing your work is like unveiling your masterpiece to the world! Just as an artist displays their artwork, sharing your project allows others to appreciate your creativity and insights. Take pride in your accomplishments and enjoy the impact your work can have.

Final Thoughts: A Learner’s Reflection

My journey to mastering Microsoft Power BI has been both challenging yet immensely gratifying. I owe much of my progress to a highly respected colleague who encouraged me to learn the application. Despite having Power BI Desktop installed on my computer for over a year, I was hesitant to take the first step into this unfamiliar territory. It wasn’t until I was preparing for a presentation and creating charts in Microsoft Excel that I wondered if I could achieve the same results in Power BI.

The first time I opened Power BI, I was intimidated by its robust and intricate interface. Creating a simple chart took considerable time, as I had to build it from the ground up — identifying data for the x-axis and y-axis, selecting chart line colors, background color, text color, and more. However, once I began, I could not stop…

Power BI’s capabilities, such as drilling down with various chart types, tables, and matrices, allowed me to transform my data into a compelling narrative. In the end, I was able to turn my data into actionable insights that resonated with my peers during the presentation.

💙 Final Note: One of my favorite quotes about Power BI comes from a video by How to Power BI (Bas). He explains that a great Power BI report can perfectly connect the past, present, and future. This summarizes the remarkable of Microsoft Power BI as a tool for data-driven decision-making and strategic planning.