Skip to main content

Why I started using Microsoft PowerBi and so should you

Microsoft’s stocks have been performing really well for the past couple of years now. I believe it is due to their continuous efforts in improving their cloud services and adding new applications to their long list of essential business applications for people in the enterprise, schools, and even small businesses. One of their latest applications is PowerBi, a business analytics software for data visualization and I can honestly say, people should be using this application.

First, it is free. At least for now. I use the PowerBi desktop version which doesn’t require an Office 365 account to work (by not signing in). You could then extract your data from multiple different sources, and create wonderful diagrams, charts, and interactive reports.


For me, Excel and SQL Server are among the most popular data sources for PowerBi. I, for one, use both. Even just for simple data cleaning, this amazing software works wonders.



I usually use PowerBi to clean some data before using Python (Jupyter Notebook) for data analysis. Though right now, it is for smaller-size data as it continues to improve performance-wise.

My usual steps go something like this:

  • Organize my data sources. I usually have my Excel files in my OneDrive and the SQL Server SQL commands tested using SQL Server. 

  • Using SQL when querying data makes the PowerBi file size much smaller so I test them first to get my desired data.

  • Transform data by properly changing data types, removing empty rows, or renaming some columns.

  • Then I start creating new calculated columns, measured values, or merged data.

  • I start designing the graphical interface using the visualization and filter tabs.


Familiarize yourself with the interface before we get started:


Orange Border

Data: This is where you pick your dataset from different sources like SQL Server database, Excel files, and many more. These options keep updating and growing.


Blue Border

Queries: Edit Queries (Using M language - More about this later), change the data type of each column, or refresh the data query.


Purple Border

Visualizations: Selection of different visualization (charts, slicer, table, etc.) tools.

Fields: These contain the tables/data sets obtained from a query.

Filters: Filter options per selected visualization tool.


Yellow Border

Values: When a visual is selected, this is where the user edits/adds data either by dragging a column table from the Fields, changing parameters of a chart like adding background color, changing fonts, etc.

Main Toolbar: Contains Data, Queries, Share, Calculations, and Insert options.


Green Border

Side Toolbar: Data Model, Data View (Using DAX), Relationship.


I will write more tutorials in the future regarding more PowerBi capabilities including more visualization, merging, and creating one-to-one, one-to-many, and many-to-many relationships.


Cheers,

Philip
Labels:
Location: Edmonton

Comments

Post a Comment

Popular posts from this blog

Imagine-Station's Virtual Farming: The Future of Agriculture?

Imagine running a fully automated farm in the comfort of your own home. With the increasing population in urban areas and automation slowly stealing people's jobs, we need to find a win-win solution. Using automation to control highly sophisticated processes like agriculture is definitely still far ahead but we are getting there. Agriculture is a staple source of survival of any civilization but due to increased urbanization, younger people started moving toward cities pursuing jobs much farther than farming. And that is not a good thing. With recent advances in technology including faster wireless connection, smarter computers, and a much better human-machine interface, I believe we are heading towards a new era of automated tasks that includes farming. Using robotics to plant, maintain, and harvest produce sounds complicated but with the help of artificial intelligence to identify plant growth stages and productivity, it can be easier to optimize any agricultural process. Remote...
Post a Comment
Read more

Top 5 must have items for apartment dwellers

A lack of space is usually one of the constraints of apartment living. Before buying a new item, you first have to consider its size since you lack real estate for storage. Living in a smaller space could also mean that you must have long-lasting and multi-purpose items. Another factor to consider is the convenience of technology or design. Even if it serves its purpose, will it be convenient to operate or use? To help you a bit, I prepared a list of must-have items to consider if you do happen to live in an apartment.  Some of the items here work better in smaller spaces and are very helpful in low-rise to high-rise apartment complexes. This list is in random order so it is up to you to figure out which one will be most helpful. Now, on to our list. 1. An Air fryer I cannot stress this enough. I live in an apartment and my air fryer is my lifeline! It is so convenient and cooks deliciously! Cooking in an air fryer also cuts back on calories and fats according to multiple sources ...
Post a Comment
Read more

Imagine Station's Operating System in the Cloud

Imagine a next-level streaming technology that lets you stream your own personal computer in the cloud. A completely online-only operating system with a familiar user interface that emulates an actual computer. A personal virtual machine accessible to everyone. All from the cloud. So how does it work? You have a familiar device (like a tablet that is network-ready), you log in using your online account, and voila! a whole desktop experience right in front of you. Everything you do there gets saved in the cloud and of course, you can log in to your personal computer from any device with a browser and internet access. Just like Google Drive has different tiers, why not an actual full Operating System that exists in an online drive? OS streaming that is subscription-based with a free basic account to go back to if you run out of money? That sounds amazing. The upgradeable tiers include a combination of memory, graphics, processing speed, storage space, multiple users, and more (insert fe...
Post a Comment
Read more